MS-20465 Designing Solutions for Microsoft SQL Server 2014

KLUCZOWE ZAGADNIENIA

• planowanie infrastruktury SQL Server
• tworzenie i modyfikacja polityk
• praca z  „Data Collectror” i „SQL Server Utility”
• zapewnienie wysokiej dostępności SQL Server przy użyciu:
  – Failover Clustering
  – Availbility Groups
  – Replikacji danych

Przemysław Rosłon, Microsoft Certified Trainer

Tematyka szkolenia pokrywa zagadnienia wymagane na ścieżce MCSE: Data Management and Analytics
Dowiedz się więcej o certyfikacjach Microsoft

TEMATYKA ZAJĘĆ

• Module 1: Introduction to Enterprise Data Architecture
  Considerations for Enterprise Data
  Assessing an Existing Infrastructure
  Lab: Assessing an Existing Enterprise Data Infrastructure

• Module 2: Multi-Server Configuration Management
  Policy-Based Management
  Microsoft System Center
  Lab: Planning and Implementing Policy-Based Management

• Module 3: Monitoring SQL Server 2014 Health
  Introduction to Health Monitoring
  Data Collector
  SQL Server Utility
  Lab: Monitoring SQL Server Health

• Module 4: Consolidating Database Workloads with SQL Server 2014
  Considerations for Database Server Consolidation
  Managing Resources in a Consolidated Database Infrastructure
  Lab: SQL Server Consolidation

• Module 5: Introduction to Cloud Data Solutions
  Overview of Cloud Computing
  SQL Server in a Private Cloud
  Lab: Preparing a SQL Server Installation in a Virtual Machine Template

• Module 6: Introduction to High Availability in SQL Server 2014
  High Availability Concepts and Options in SQL Server 2014
  Log Shipping
  Lab: Using Log Shipping

• Module 7: Clustering with Windows Server and SQL Server 2014
  Introduction to Windows Server Failover Clustering
  SQL Server AlwaysOn Failover Cluster Instances
  Lab: Implementing an AlwaysOn Failover Cluster Instance

• Module 8: AlwaysOn Availability Groups
  Introduction to AlwaysOn Availability Groups
  Working with AlwaysOn Availability Groups
  Considerations for Using AlwaysOn Availability Groups
  Lab: Implementing and Testing an AlwaysOn Availability Group

• Module 9: Planning High Availability and Disaster Recovery
  High Availability and Disaster Recovery with SQL Server 2014
  SQL Server High Availability and Disaster Recovery Solutions
  Lab: Planning High Availability and Disaster Recovery

• Module 10: Replicating Data
  SQL Server Replication
  Planning Replication
  Lab: Planning and Implementing Replication