What’s Included?
High-Quality Video, E-book & Audiobook
Module Quizzes
AI Mentor
Access for Tablet & Phone
Prerequisites
- Experience with SQL Server and relational databases
- Familiarity with Azure services and portal usage
- Understanding of security concepts and access management
- Basic knowledge of performance tuning and automation
Skills You’ll Gain
- Deploy and manage Azure SQL resources
- Secure databases with roles and policies
- Monitor and optimize database performance
- Automate tasks using built-in tools
- Implement backup and recovery strategies
Self Study Materials Included
Videos
Engaging visual content to enhance understanding and learning experience.
Podcasts
Insightful audio sessions featuring expert discussions and real-world cases.
Audiobooks
Listen and learn anytime with convenient audio-based knowledge sharing.
E-Books
Comprehensive digital guides offering in-depth knowledge and learning support.
Module Wise Quizzes
Interactive assessments to reinforce learning and test conceptual clarity.
Additional Resources
Supplementary references and list of tools to deepen knowledge and practical application.
Tools You’ll Master
Azure Portal
Azure SQL Database & Managed Instance
Microsoft SQL Server Management Studio (SSMS)
Azure Monitor & Log Analytics
Azure Automation & PowerShell
Azure Security Center
What You’ll Learn
Plan Scalable Resources
Design data platforms for performance and growth.
Secure Azure SQL Access
Control permissions and protect database environments.
Optimize & Automate Tasks
Improve query performance and automate admin routines.
Backup & Recovery Strategy
Implement disaster recovery and ensure data resilience.
Course Modules
Lesson 1: Plan and Implement Data Platform Resources
Module 1: Prepare to Maintain SQL Server-Based Databases on Azure
Module 2: Deploy IaaS Solutions with Azure SQL
Module 3: Deploy PaaS Solutions with Azure SQL
Module 4: Migrate SQL Server Workloads to Azure SQL Database
Module 5: Migrate SQL Server Workloads to Azure SQL Managed Instance
Lesson 2: Implement a Secure Environment for a Database Service
Module 1: Configure Database Authentication and Authorization
Module 2: Protect Data In-Transit and At Rest
Module 3: Implement Compliance Controls for Sensitive Data
Lesson 3: Monitor and Optimize Operational Resources in Azure SQL
Module 1: Describe Performance Monitoring
Module 2: Configure SQL Server Resources for Optimal Performance
Module 3: Configure Databases for Optimal Performance
Lesson 4: Optimize Query Performance in Azure SQL
Module 1: Explore Query Performance Optimization
Module 2: Explore Performance-Based Database Design
Module 3: Evaluate Performance Improvements
Lesson 5: Automate Database Tasks for Azure SQL
Module 1: Automate Database Deployment
Module 2: Create and Manage SQL Agent Jobs
Module 3: Manage Azure PaaS Tasks Using Automation
Lesson 6: Plan and Implement a High Availability and Disaster Recovery Environment
Module 1: Describe High Availability and Disaster Recovery Strategies
Module 2: Explore IaaS and PaaS Solutions for High Availability and Disaster Recovery
Module 3: Back Up and Restore Databases
Frequently Asked Questions
No, it’s intended for professionals with database experience.
It supports the Azure Database Administrator Associate certification.
Yes, the course covers hybrid, cloud, and on-premises scenarios.
Yes, practical labs are integrated throughout the course.
Yes, both instructor-led and self-paced formats are available.
