Unlock This Course & The Entire Vault™ Library
Have questions about our subscriptions? Call 1-800-264-9029 or email an account manager.
Login Buy SubscriptionDP-300T00: Implement Scalable Database Solutions using Azure SQL
This course provides students with the knowledge and skills to create 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.
What you will learn
With a focus on practical applications, the course covers:
- Plan and Implement Data Platform
- Migration strategies for moving databases to Azure.
- Implement a Secure Environment
- Monitor, Configure, and Optimize Resources
- Configure and Manage Automation
- Plan and Implement High Availability / Disaster Recovery (HA/DR)
What products and services will you use and learn about in this course
- Deploy Azure SQL Database,
- Azure SQL Managed Instances
- SQL Server on Azure Virtual Machines
- Query Performance Insight
- Azure SQL Analytics
- SQL Agent jobs
- Azure automation services.
- Geo-replication
- Always On Availability Groups
Prepare for the Microsoft Certified: Azure Database Administrator Associate Certification
This course is designed to help students confidently prepare for the DP-300: Microsoft Certified: Azure Database Administrator Associate exam.
Note: To pass the certification test, studying outside the course may be required to ensure all the concepts are fully understood.
Learning Path: Plan and implement data platform resources
Deploy data platform resources in Azure SQL. Explore options for deployment and migration. Calculate resource requirements and create templates.
Modules:
- Prepare to maintain SQL Server-based databases on Azure
- Deploy IaaS solutions with Azure SQL
- Deploy PaaS solutions with Azure SQL
- Migrate SQL Server workloads to Azure SQL Database
- Migrate SQL Server workloads to Azure SQL Managed Instance
Exercises:
- Provision a SQL Server on an Azure Virtual Machine
- Deploy an Azure SQL Database
- Migrate a SQL Server database to Azure SQL Database
- Migrate a SQL Server database to Azure SQL Managed Instance
Learning Path: Implement a secure environment for a database service
Implement SQL Server-based options for authentication and authorization, as well as Azure options for securing Azure SQL databases. Explore encryption, firewalls and advanced threat protection.
Modules:
- Configure database authentication and authorization
- Protect data in-transit and at rest
- Implement compliance controls for sensitive data
Exercises:
- Authorize Access to Azure SQL Database with Microsoft Entra ID
- Configure a server-based firewall rule using the Azure portal
- Enable Microsoft Defender for SQL and Data Classification
Learning Path: Monitor and optimize operational resources in Azure SQL
Configure hardware and server resources for optimum performance after establishing a baseline. Identify sources of performance problems. Troubleshoot using Azure SQL Intelligent Insights.
Modules:
- Describe performance monitoring
- Configure SQL Server resources for optimal performance
- Configure databases for optimal performance
Exercises:
- Isolate problems with monitoring
- Detect and correct fragmentation issues
Learning Path: Automate database tasks for Azure SQL
Scripting repetitive tasks in Azure SQL for regular maintenance jobs and multi-instance administration. Automation of error and resource alerts. Configuration of notifications for failures.
Modules:
- Automate database deployment
- Create and manage SQL Agent jobs
- Manage Azure PaaS tasks using automation
Exercises:
- Deploy an Azure SQL Database using an Azure Resource Manager template
- Create a CPU status alert for a SQL Server
- Deploy an automation runbook to automatically rebuild indexes
Learning Path: Plan and implement a high availability and disaster recovery environment
Data must be available when needed. Configure, test and manage a solution for high availability and disaster recovery using Azure tools and SQL Server tools.
Modules:
- Describe high availability and disaster recovery strategies
- Explore IaaS and PaaS solutions for high availability and disaster recovery
- Backup and restore databases
Exercises:
- Configure geo replication for Azure SQL Database
- Backup to URL
