Sign In
Select Your Favourite
Category And Start Learning.
Administering Microsoft Azure SQL Solutions – Training
Course Content
Introduction
-
Introduction
-
Welcome to Udemy
-
How to get the best out of your Udemy course
-
Do you want auto-translated subtitles in more languages?
-
Curriculum
-
Resources
Review prerequisites
Optimize Query Performance
Evaluate performance improvements
Plan and Implement Data Platform Resources
Configure Azure SQL Database resources for scale and performance
Evaluate a strategy for migrating to Azure
Configure database AuthN and AuthZ by using platform and database tools
Implement security for data at rest and in transit
Implement compliance controls for sensitive data – Part 1
Implement compliance controls for sensitive data – Part 2
Monitor activity and performance
Implement performance-related maintenance tasks
Identify performance-related issues
Automate tasks and Perform backup and restore a database by using database tools
Recommend an HADR strategy for a data platform solution
Perform Administration by Using T-SQL
Introduction to Virtual Machines and Managed Instances (MI)
Configure database authentication, and filegroups
Evaluate and implement an alert and notification strategy
Identify performance-related issues
Create scheduled tasks
Perform backup and restore a database by using database tools – VMs
Recommend and test HA/DR strategies, and configure HA/DR
Conclusion
Bonus section – No longer needed for the DP-300 exam
Bonus Lecture
About Course
“Administering Microsoft Azure SQL Solutions” training equips IT professionals with essential skills to manage and optimize Azure SQL databases. Participants learn to configure, monitor, and troubleshoot SQL databases in Azure, ensuring high availability, security, and performance. Topics include database deployment, data migration, disaster recovery strategies, and implementing security measures. Practical hands-on exercises and case studies enhance understanding of Azure SQL administration best practices. This training is ideal for database administrators and Azure professionals looking to expand their expertise in cloud-based SQL solutions, enabling them to effectively manage data platforms and support business-critical applications in Azure environments.
