DP-300 Administering Microsoft Azure SQL Solutions

Administering Microsoft Azure SQL Solutions -koulutus soveltuu hybridimalleihin, joissa käytetään sekä Azure SQL-kantoja, että On-Prem SQL Serveriä.

Tavoite

Opi SQL Serverin hallinta, käyttö ja optimoinnin perusteet Azuressa, sekä IaaS (virtuaalikone), että PaaS (palvelu) -ympäristöissä.

Koulutuksen sisältö

Module 1: Introduction to Azure database administration

Lessons

• Prepare to maintain SQL databases on Azure

Module 2: Plan and implement data platform resources

Lessons

• Deploy IaaS solutions with Azure SQL
• Deploy PaaS solutions with Azure SQL
• Evaluate strategies for migrating to Azure SQL
• Migrate SQL Server workloads to Azure SQL Database
• Migrate SQL workloads to Azure Managed Instances

Module 3: Implement a secure environment for a database service

Lessons

• Configure database authentication and authorization
• Protect data in-transit and at rest
• Implement compliance controls for sensitive data

Module 4: Monitor and optimize operational resources in Azure SQL

Lessons

• Describe performance monitoring
• Configure SQL Server resources for optimal performance
• Configure databases for optimal performance

Module 5: Optimize query performance in Azure SQL

Lessons

• Explore query performance optimization
• Explore performance-based design
• Evaluate performance improvements

Module 6: Automate database tasks for Azure SQL

Lessons

• Automate deployment of database resources
• Create and manage SQL Agent jobs
• Manage Azure PaaS tasks using automation

Module 7: Plan and implement a high availability and disaster recovery environment

Lessons

• Describe high availability and disaster recovery strategies
• Explore IaaS and PaaS solutions for high availability and disaster recovery
• Back up and restore databases