800.674.3550
Microsoft

Microsoft Azure SQL Solutions Training

SQL
Course Schedule
SQL Training

Microsoft Azure SQL Solutions Training

This course trains professionals to administer scalable SQL-based databases in both IaaS (Azure VMs) and PaaS (Azure SQL Database/Managed Instance) environments. It covers critical administration topics, including security implementation with Microsoft Defender, performance optimization using Intelligent Query Processing (IQP), High Availability and Disaster Recovery (HA/DR) planning with AG and WSFC, and automation using PowerShell and Azure CLI. This course is ideal for those preparing for the Administering Microsoft Azure SQL Solutions Exam (DP-300).

Training at a glance

Level

Intermediate

Duration

4 Days

Experience

1 year: IT business-level professionals

Average Salary

$140,000

Labs

Yes

Training Details

Students will learn to:
  • Plan, deploy and configure Azure SQL offerings
  • Monitor database performance and tune a database and queries for optimum performance
  • Plan and configure a High Availability Solution
  • Module 1: Planning and Implementing Data Platform Resources
    • 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

  • Module 2: Implementing a Secure Database Environment
    • Configure Database Authentication and Authorization
    • Protect Data In-Transit and At Rest
    • Implement Compliance Controls for Sensitive Data

  • Module 3: Monitoring and Optimization
    • Describe Performance Monitoring
    • Configure SQL Server Resources for Optimal Performance
    • Configure Databases for Optimal Performance

  • Module 4: Optimizing Query Performance in Azure SQL
    • Explore Query Performance Optimization
    • Explore Performance-Based Database Design
    • Evaluate Performance Improvements

  • Module 5: Automating Database Tasks for Azure SQL
    • Automate Database Deployment
    • Create and Manage SQL Agent Jobs
    • Manage Azure PaaS Tasks Using Automation

  • Module 6: High Availability and Disaster Recovery
    • Describe HA/DR Strategies
    • Explore IaaS and PaaS Solutions for HA/DR
    • Back Up and Restore Databases

  • Module 7: Lab Outline
    • Provision SQL Server on an Azure Virtual Machine
    • Provision an Azure SQL Database
    • Authorize access with Microsoft Entra ID and configure firewall rules
    • Enable Microsoft Defender for SQL and Data classification
    • Isolate performance problems through monitoring and fix fragmentation/blocking issues
    • Identify database design issues and isolate problem areas in poorly performing queries
    • Deploy Azure SQL Database using ARM template
    • Create a CPU status alert for a SQL Server
    • Deploy an automation runbook to automatically rebuild indexes
    • Configure geo-replication and implement Backup to/Restore from URL


  • Database Administrators who manage and maintain on-premises or cloud-based SQL Server databases and are looking to migrate to or work within Azure.

  • Data Engineers and IT Professionals involved in planning, deploying, configuring, optimizing, and securing Azure SQL environments.

  • Cloud Database Professionals seeking to expand their cloud database management skills, especially in IaaS and PaaS scenarios with Azure SQL Database and SQL Managed Instances.

  • Candidates preparing for the Microsoft DP-300 Certification Exam as part of earning the Microsoft Certified: Azure Database Administrator Associate credential.

• Working with, maintaining, and developing with SQL Serve
• Experience with Azure, such as deploying and managing resources
• Recommended Prior Course: DP-900T00: Introduction to Microsoft Azure Data

Download Course PDF

Upcoming Classes

We offer more than just SQL Training

Our successful training results keep our corporate and military clients returning. That’s because we provide everything you need to succeed. This is true for all of our courses.

Strategic Planning & Project Management

From Lean Six Sigma to Project Management Institute Project Management Professional, Agile and SCRUM, we offer the best-in-class strategic planning and project management training available. Work closely with our seasoned multi-decade project managers.

IT & Cybersecurity

ATA is the leading OffSec and Hack the Box US training provider, and a CompTIA and EC-Council award-winning training partner. We offer the best offensive and defensive cyber training to keep your team ahead of the technology skills curve.

Leadership & Management

Let us teach your team the high-level traits and micro-level tools & strategies of effective 21st-century leadership. Empower your team to play to each others’ strengths, inspire others and build a culture that values communication, authenticity, and community.

From Lean Six Sigma to Project Management Institute Project Management Professional, Agile and SCRUM, we offer the best-in-class strategic planning and project management training available. Work closely with our seasoned multi-decade project managers.
ATA is the leading OffSec and Hack the Box US training provider, and a CompTIA and EC-Council award-winning training partner. We offer the best offensive and defensive cyber training to keep your team ahead of the technology skills curve.
Let us teach your team the high-level traits and micro-level tools & strategies of effective 21st-century leadership. Empower your team to play to each others’ strengths, inspire others and build a culture that values communication, authenticity, and community.