Karlebovej 91, 3400 Hillerød | Krajbjergvej 3, 8541 Skødstrup
70 22 29 29
08:30 - 17:00

Designing and Implementing Cloud Data Platform Solutions 55247 (70-473)

  • jan 21
    mandag 21/01/2019 - onsdag 23/01/2019
    09:00 - 16:00 Skødstrup
    • Afholdelsesgaranti
    • Kr.14,695.00 ekskl. MOMS
    Ekskl. moms
  • feb 18
    mandag 18/02/2019 - onsdag 20/02/2019
    09:00 - 16:00 Hillerød
    • Kr.14,695.00 ekskl. MOMS
    Ekskl. moms
  • mar 18
    mandag 18/03/2019 - onsdag 20/03/2019
    09:00 - 16:00 Århus
    • Kr.14,695.00 ekskl. MOMS
    Ekskl. moms
  • apr 08
    mandag 08/04/2019 - onsdag 10/04/2019
    09:00 - 16:00 Hillerød
    • Kr.14,695.00 ekskl. MOMS
    Ekskl. moms
  • maj 20
    mandag 20/05/2019 - onsdag 22/05/2019
    09:00 - 16:00 Århus
    • Kr.14,695.00 ekskl. MOMS
    Ekskl. moms
  • jun 17
    mandag 17/06/2019 - onsdag 19/06/2019
    09:00 - 16:00 Hillerød
    • Kr.14,695.00 ekskl. MOMS
    Ekskl. moms
Er der ingen af disse datoer som passer dig? Foreslå en anden dato

Kursusinfo

  • Dette kursus varer 3 dage
  • Der medfølger kursusmateriale til dette kursus
  • Dette kursus koster 4 klip på dit klippekort.
  • Fuld forplejning (Morgenmad, frokost, kage, kaffe og sodavand ad libitum)
  • Fuld beståelsesgaranti er inkluderet i prisen - Læs mere her
  • Eksamen er inkluderet i prisen
  • Med i prisen hører Practice Test
  • Du har i alt adgang til din kursus-pc i 3 uger

Varighed

Dette kursus varer 3 dage

Materialer

Der medfølger kursusmateriale til dette kursus

Klip på klippekort

Dette kursus koster 4 klip på dit klippekort.

Forplejning

Fuld forplejning (Morgenmad, frokost, eftermiddagskage samt kaffe og sodavand ad libitum)

Garanti for beståelse

Fuld beståelsesgaranti er inkluderet i prisen - Læs mere her

Eksamen

Alle eksamensforsøg er inkluderet i prisen

Practice Tests

Med i prisen hører Practice Test

Remote adgang

Du har i alt adgang til din kursus-pc i 3 uger

Microsoft Vouchers

3 vouchers + 4.950 kr. for Certificeringspakken.
Læs mere her

Dette kursus, fokuserer med udgangspunkt i Microsoft SQL Server on-premise, hybrid og Azure data platform på design og implementering af cloud data platform løsninger. Det leder dig igennem design, implementering og optimering af workloads i hybrid løsninger, såvel som on-premise og Azure cloud baserede samme, samt opsætning af high availability og disaster recovery løsninger.

Deltager profil
The primary audience for this course are database professionals who want to enhance their existing SQL Server skills with hybrid solutions and cloud solution architecture using the Microsoft Data Platform.

Efter endt kursus
Efter endt kursus vil du have følgende kompetencer:

• 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.

Kursusbeskrivelse for Designing and Implementing Cloud Data Platform Solutions

Module 1: Microsoft Cloud Data Platform Overview
This 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 Suite

Module 2: Implement SQL Server on Azure VM
This module with a hands-on-lab 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 practices

Lab : SQL Server in Azure VMs

Module 3: Implement SQL Database
This module with a hands-on-lab 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 Advisor

Lab : Implementing SQL Database

Module 4: SQL Database High Availability and disaster recovery
This module with a hands-on 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 Scenarios

Lab : SQL Database HA/DR

Module 5: Hybrid HA/DR scenarios with SQL Server
This module with a hands-on lab exercise describes the design of high available, scalable data platform solutions on-premises, 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 Azure

Lab : Implement HA/DR with SQL Server in Azure VMs

Module 6: Design and Implement Security
This module with a hands-on-lab 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 Detection

Lab : Design and Implement SQL Database Security

Module 7: Monitor and manage implementations on Azure
This module with a hands-on-lab 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 Insights

Lab : Monitoring and manage implementations

Module 8: Design and implement database solutions for SQL Server and SQL Database
This 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

 

Lignende kurser

Microsoft Azure Fundamentals (MOC 10979) 02 jan 19
Performing Data Engineering on Microsoft HD Insight 20775 (70-775) Skriv dig op som interesseret til dette kursus
Azure Solutions Architect Expert (AZ-300 & AZ-301) 21 jan 19
Managing SQL Business Intelligence Operations (MOC 10988) Skriv dig op som interesseret til dette kursus
Performance Tuning and Optimizing SQL Databases (10987) 07 jan 19