1999 zł
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
CERTYFIKACJE ZAWODOWE
| Certyfikacja podstawowa |
CertyfIkacja specjalistyczna |
Certyfikacja ekspercka |
| FUNDAMENTALS |
ASSOCIATE |
EXPERT |
Tematyka szkolenia pokrywa zagadnienia wymagane na ścieżce MCSE: Data Management and Analytics
Dowiedz się więcej o certyfikacjach Microsoft
POZIOM SZKOLENIA
| podstawowy |
średniozaawansowany |
zaawansowany |
ekspercki |
| 100 |
200 |
300 |
400 |
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