Designing and Implementing Cloud Data Platform Solutions (Examen: 70-473)
€1640, aangeboden door Master it Training
De focus van deze driedaagse Microsoft Training is het ontwerpen en implementeren van cloud dataplatform oplossingen met Microsoft Data Platform met gebruik van SQL Server onpremises, hybride en cloud dataplatformoplossingen. Het beschrijft hoe je workloads ontwerpt, implementeert en optimaliseren in hybride scenario's met zowel onpremise en Microsoft Azure cloudgebaseerde oplossingen. Daarnaast leer je hoe je high availability en disaster recoveryoplossingen kunt implementeren.Deze training is de ideale voorbereiding op het volgend examen: 70473 Designing and Implementing Cloud Data Platform SolutionsNa afronding van de training ben je in staat om: Microsoft Cloud Data Platform Solutions plaatsen; Ontwerp en implementatie van oplossingen op Azure met behulp van SQL Server; Ontwerp en implementatie van oplossingen op Azure met behulp van SQLdatabases; Ontwerp en implementatie van beveiliging, toegang en controle voor cloud dataplatform oplossingen; Ontwerpen van highly scalable mission critical oplossingen met behulp van de Microsoft Data Platform; Ontwerp en implementatie van cloud dataplatformoplossingen.
Let op. Deze training is exclusief het examen.
Doelgroep
De primaire doelgroep voor deze training zijn database professionals die hun bestaande SQL Server kennis willen verbeteren met hybride oplossingen en cloudoplossing architectuur met gebruik van Microsoft Data Platform.
Voorkennis voor de Designing and Implementing Cloud Data Platform Solutions training
Deelnemers moeten een goede kennis van SQL Server en reeds bestaande MCSE Data Platform certificering of een gelijkwaardige werkervaring hebben.
Examen
70-473
Onderwerpen in de Designing and Implementing Cloud Data Platform Solutions training
Module 1: Microsoft Cloud Data Platform OverviewThis module provides an overview of the Microsoft Data Platform Solutions in Hybrid and Cloud based scenarios. The module provides an overview of offerings and capabilities.Lessons Microsoft Cloud Data Platform Microsoft SQL Server Common Tools Cloud Data Offerings Data Visualizations Cortana Analytics SuiteModule 2: Implement SQL Server on Azure VMThis module with a handsonlab describes the core capabilities of running SQL Server in a virtual machine environment (IAAS) on Azure.Lessons 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 practicesLab : SQL Server in Azure VMsModule 3: Implement SQL DatabaseThis module with a handsonlab describes the core capabilities of implementing data platform solutions using SQL Database on Azure. The module provides details in service tiers and offerings.Lessons What is SQL Database Data tiers/ Elastic data tiers Scalability Options Elastic Databases Elastic Database Tools SQL Database performance Service Tier AdvisorLab : Implementing SQL DatabaseModule 4: SQL Database High Availability and disaster recoveryThis module with a handson lab describes high availability and disaster recovery scenarios with SQL Database.Lessons Business Continuity with SQL Database SQL Database HA/DR SQL Database Backup Solutions SQL Database Replication ScenariosLab : SQL Database HA/DRModule 5: Hybrid HA/DR scenarios with SQL ServerThis module with a handson lab exercise describes the design of high available, scalable data platform solutions onpremises, in the cloud and in hybrid cloud scenarios using SQL Server on premises and with Azure VMs.Lessons HA/DR deployment architectures AlwaysOn availability groups AlwaysOn Failover Clustering Database Mirroring Log Shipping Backup to Azure Managed Backups SQL Server data files on AzureLab : Implement HA/DR with SQL Server in Azure VMsModule 6: Design and Implement SecurityThis module with a handsonlab describes the security features and capabilities in SQL Server in Azure VMs and SQL Database including firewalls andauditing.Lessons SQL Database Security Approach SQL Database Firewall Security SQL Database Active Directory Integration Encryption Row Level Security Dynamic Data Masking Auditing and Threat DetectionLab : Design and Implement SQL Database SecurityModule 7: Monitor and manage implementations on AzureThis module with a handsonlab focuses on management and deployment, monitoring for performance of SQL Database and SQL Server in Azure VMs.Lessons Azure Automation Capabilities SQL Monitoring and Management Operational InsightsLab : Monitoring and manage implementationsModule 8: Design and implement database solutions for SQL Server and SQL DatabaseThis module covers design and architecture scenarios for implementation of database solutions using the Microsoft Cloud Data Platform. This module introduces key scenarios to discuss with classroom attendees in order to build out the right architecture and infrastructure based on architecture and business requirements.Lessons Case Study – SQL Server Hybrid Scenario Case Study – Lift and Shift