Cart 0
Training
Certificate
DP-300: Implement scalable database solutions using Azure SQL
Course Information
Course Name
DP-300: Implement scalable database solutions using Azure SQL
Exam code
DP-300
Duration
4 Days
Certification
Overview
Audience Profile
Prerequisities
At Course Completion
Course Outline
Overview
This course provides students with the knowledge and skills to administer a SQL Server database infrastructure for cloud, on-premises and hybrid relational databases and who work with the Microsoft PaaS relational database offerings. Additionally, it will be of use to individuals who develop applications that deliver content from SQL-based relational databases.
Overview
Overview
This course provides students with the knowledge and skills to administer a SQL Server database infrastructure for cloud, on-premises and hybrid relational databases and who work with the Microsoft PaaS relational database offerings. Additionally, it will be of use to individuals who develop applications that deliver content from SQL-based relational databases.
Audience Profile
Audience Profile
The audience for this course is data professionals managing data and databases who want to learn about administering the data platform technologies that are available on Microsoft Azure. This course is also valuable for data architects and application developers who need to understand what technologies are available for the data platform with Azure and how to work with those technologies through applications.
Prerequisities
Prerequisites
Successful Azure Database Administrators start this role with professional experience in database management and technical knowledge of cloud technologies.
Specifically:
- Working with, maintaining, and developing with SQL Server
Experience with Azure, such as deploying and managing resources
At a minimum, you should know the information in the following online training before attending the course:
AZ-900 Azure Fundamentals
DP-900 Azure Data Fundamentals
At Course Completion
At Course Completion
Course Outline
Course Outline
Module 1: Prepare to maintain SQL databases on Azure
Module 2: Deploy IaaS solutions with Azure SQL
Module 3: Deploy PaaS solutions with Azure SQL
Module 4: Evaluate strategies for migrating to Azure SQL
Module 5: Migrate SQL Server workloads to Azure SQL Database
Module 6: Migrate SQL Server workloads to Azure SQL Managed Instance
Module 7: Configure database authentication and authorization
Module 8: Protect data in-transit and at rest
Module 9: Implement compliance controls for sensitive data
Module 10: Describe performance monitoring
Module 11: Configure SQL Server resources for optimal performance
Module 12: Configure databases for optimal performance
Module 13: Explore query performance optimization
Module 14: Explore performance-based design
Module 15: Evaluate performance improvements
Module 16: Automate deployment of database resources
Module 17: Create and manage SQL Agent jobs
Module 18: Manage Azure PaaS tasks using automation
Module 19: Describe high availability and disaster recovery strategies
Module 20: Explore IaaS and PaaS solutions for high availability and disaster recovery
Module 21: Back up and restore databases
