Programm
- Microsoft Cloud Data Platform Overview
- Microsoft Cloud Data Platform
- Microsoft SQL Server
- Common Tools
- Cloud Data Offerings
- Data Visualizations
- Cortana Analytics Suite
- Implement SQL Server on Azure VM
- Virtual machine components
- Storage Architecture
- Azure deployment models
- Virtual machine tiers
- Virtual machine deployments
- Deployment scenarios
- Move existing workloads
- Connecting to Azure VMs
- Domain joining VMs
- VM best practices
- Lab : SQL Server in Azure VMs
- Implement SQL Database
- What is SQL Database
- Data tiers/ Elastic data tiers
- Scalability Options
- Elastic Databases
- Elastic Database Tools
- SQL Database performance
- Service Tier Advisor
- Lab : Implementing SQL Database
- SQL Database High Availability and disaster recovery
- Business Continuity with SQL Database
- SQL Database HA/DR
- SQL Database Backup Solutions
- SQL Database Replication Scenarios
- Lab : SQL Database HA/DR
- Hybrid HA/DR scenarios with SQL Server
- HA/DR deployment architectures
- AlwaysOn availability groups
- AlwaysOn Failover Clustering
- Database Mirroring
- Log Shipping
- Backup to Azure
- Managed Backups
- SQL Server data files on Azure
- Lab : Implement HA/DR with SQL Server in Azure VMs
- Design and Implement Security
- SQL Database Security Approach
- SQL Database Firewall Security
- SQL Database Active Directory Integration
- Encryption
- Row Level Security
- Dynamic Data Masking
- Auditing and Threat Detection
- Lab : Design and Implement SQL Database Security
- Monitor and manage implementations on Azure
- Azure Automation Capabilities
- SQL Monitoring and Management
- Operational Insights
- Lab : Monitoring and manage implementations
- Design and implement database solutions for SQL Server and SQL Database
- Case Study – SQL Server Hybrid Scenario
- Case Study – Lift and Shift
Ziele
The focus of this three-day instructor-led Microsoft Training course is on designing and implementing cloud data platform solutions with the Microsoft Data Platform by using SQL Server on-premises, hybrid and cloud data platform solutions. It describes how to design and implement and optimize workloads in hybrid scenarios with both on-premises and Microsoft Azure cloud-based solutions, and how to implement high availability and disaster recovery solutions.
Nach Abschluss dieses Seminars haben die Teilnehmer Wissen zu folgenden Themen:
Nach Abschluss dieses Seminars haben die Teilnehmer Wissen zu folgenden Themen:
- Position Microsoft Cloud Data Platform Solutions
- Design and implement solutions on Azure using SQL Server
- Design and implement solutions on Azure using SQL Database
- Design and implement security, access and auditing for cloud data platform solutions
- Design highly scalable mission critical solutions using the Microsoft Data Platform
- Design and implement cloud data platform solutions.
Mögliche Zertifizierung: MCSA: Cloud Platform
Voraussetzungen
Für dieses Seminar werden folgende Kenntnisse empfohlen:
- Students must have a good understanding of SQL Server and pre-existing MCSE Data Platform certification or equivalent professional experience.