Managing cloud-based SQL solutions requires a blend of traditional database skills and modern platform knowledge. This course enables participants to deploy, configure, monitor, and maintain Microsoft Azure SQL databases. They will gain hands-on experience with hybrid and cloud-native scenarios using practical labs.
Learning Outcomes:
Provision and configure Azure SQL databases
Monitor performance and optimise workloads
Implement security, backups, and high availability
Automate administrative tasks using tools and scripts
Key Topics:
Azure SQL Database and Managed Instance features
Performance tuning and query optimisation
Backup, restore, and disaster recovery strategies
Security: firewalls, authentication, and encryption
Automation with PowerShell and Azure CLI
Exam Details
This course is designed to build participants’ understanding of key concepts and domains covered in the DP-300: Administering Microsoft Azure SQL Solutions certification.
While the course provides technical training aligned with certification objectives, the certification exam is not bundled and must be registered separately.
To maximise success, participants are strongly encouraged to complement the course with additional self-study, revision of course materials, and dedicated practice before attempting the exam.
1. Prepare to maintain SQL databases on Azure
Explore the role of a database administrator on Azure. Describe SQL Server-based offerings on Azure.
2. Deploy IaaS solutions with Azure SQL
Configure virtual machine sizing, storage, and networking options to ensure adequate performance for your database workloads. Choose and configure appropriate high availability options.
3. Deploy PaaS solutions with Azure SQL
Provision and deploy Azure SQL Database and Azure SQL managed instance. Select the appropriate options when performing a migration to the SQL PaaS platform.
4. Evaluate strategies for migrating to Azure SQL
Describe database migration options and tools on Azure. Understand how compatibility level affects database behavior. Describe Azure private and public preview options.
5. Migrate SQL workloads to Azure SQL Databases
In this module, you will learn to demonstrate the benefits and processes for moving a SQL Server database to Azure SQL Database.
6. Migrate SQL workloads to Azure Managed Instances
Learners will be able to demonstrate the benefits and processes for moving a SQL Server database to an Azure SQL Database Managed Instance.
7. Configure database authentication and authorization
Contrast authentication using Azure Active Directory, Windows Active Directory, and SQL Server authentication. Implement various security principals and configure permissions.
8. Protect data in-transit and at rest
Explore encryption options available within Azure SQL, including firewall rules, Always Encrypted, and Transport Layer Security. Understand how SQL Injection works.
9. Implement compliance controls for sensitive data
Explore data classification capabilities and degrees of confidentiality. Implement security options to maintain private data safe, including Azure SQL auditing, Microsoft Defender for SQL, row-level security, Dynamic Data Masking and Azure SQL Database Ledger.
10. Describe performance monitoring
Compare Azure, and on-premises tools for monitoring and measuring performance. Determine critical metrics. Understand the purpose of a baseline for comparative analysis. Configure extended event sessions for tracing activities.
11. Configure SQL Server resources for optimal performance
Choose the appropriate size and storage options for your Azure SQL databases. Configure server resources such as tempdb. Understand the usage of Resource Governor.
12. Configure databases for optimal performance
Implement tasks for both IaaS and PaaS to maintain indexes, and statistics. Explore the automatic tuning features of Azure SQL Database. Control database-level configuration options. Explore Intelligent Query Processing.
13. Explore query performance optimization
Read and understand various forms of execution plans. Compare estimated vs actual plans. Learn how and why plans are generated. Understand the purpose and benefits of the Query Store.
14. Evaluate performance improvements
Evaluate possible changes to indexes. Determine the impact of changes to queries and indexes. Explore Query Store hints.
15. Explore performance-based design
Explore normalization for relational databases. Investigate the impact of proper datatype usage. Compare types of indexes.
16. Automate deployment of database resources
Explore multiple deployment models available on Azure. Use Azure Resource Manager (ARM) templates and Bicep files for deploying Azure SQL resources. Understand how to use PowerShell and Azure CLI for automation purposes.
17. Create and manage SQL Agent jobs
Explore SQL automation for scheduled tasks, and automatic alerts for SQL Server and Azure SQL Managed Instance.
18. Manage Azure PaaS tasks using automation
Explore automation for Azure SQL platform. Configure elastic jobs, explore Azure Automation, and evaluate different strategies for monitoring automation tasks.
19. Describe high availability and disaster recovery strategies
Plan an appropriate high availability and disaster recovery strategy based on recovery time objective and recovery point objective. Choose the best solution for IaaS or PaaS deployments or hybrid workloads.
20. Explore IaaS and PaaS solutions for high availability and disaster recovery
Deploy Windows Server Failover Cluster and availability groups in Azure and hybrid environments. Configure temporal tables, geo-replication, and auto-failover groups.
21. Back up and restore databases
Plan and implement policy for recovering data if user errors occur or the technology fails. Explore various options for how and where to back up and restore databases.
.png?width=50&name=Artificial%20Intelligence%20(AI).png)
-1.png?width=360&name=Server%20(4)-1.png)
/AI%20(6)-1-1.png?width=360&name=AI%20(6)-1-1.png)
/AI%20(8)-1.png?width=360&name=AI%20(8)-1.png)
-1.png?width=360&name=Automation%20RPA%20(2)-1.png)
/AI%20(5)-1.png?width=360&name=AI%20(5)-1.png)
