Administering Microsoft Azure SQL Solutions – Training
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.
Course Content
Module 1: 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
Module 2: Review prerequisites
Module 3: Optimize Query Performance
Module 4: Evaluate performance improvements
Module 5: Plan and Implement Data Platform Resources
Module 6: Configure Azure SQL Database resources for scale and performance
Module 7: Evaluate a strategy for migrating to Azure
Module 8: Configure database AuthN and AuthZ by using platform and database tools
Module 9: Implement security for data at rest and in transit
Module 10: Implement compliance controls for sensitive data – Part 1
Module 11: Implement compliance controls for sensitive data – Part 2
Module 12: Monitor activity and performance
Module 13: Implement performance-related maintenance tasks
Module 14: Identify performance-related issues
Module 15: Automate tasks and Perform backup and restore a database by using database tools
Module 16: Recommend an HADR strategy for a data platform solution
Module 17: Perform Administration by Using T-SQL
Module 18: Introduction to Virtual Machines and Managed Instances (MI)
Module 19: Configure database authentication, and filegroups
Module 20: Evaluate and implement an alert and notification strategy
Module 21: Identify performance-related issues
Module 22: Create scheduled tasks
Module 23: Perform backup and restore a database by using database tools – VMs
Module 24: Recommend and test HA/DR strategies, and configure HA/DR
Module 25: Conclusion
Earn a certificate
Add this certificate to your resume to demonstrate your skills & increase your chances of getting noticed.
