DP-300T00: Administering Microsoft Azure SQL Solutions

Master SQL Server administration in Azure with the DP-300 course. This program covers Azure SQL Database, Azure SQL Edge, and Intelligent Query Processing (IQP). You’ll learn to use PowerShell for Azure SQL administration, secure databases with Azure SQL Firewall, and deploy SQL Server Always On Availability Groups (AG) and Windows Server Failover Clustering (WSFC) for high availability. This course is ideal for IT professionals and developers looking to optimize SQL applications in the Azure environment.

Course Details

Price:

$2,495.00

Days:

Location:

Virtual

Course Overview

Here are the course objectives formatted into a bullet list:

• 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

• Working with, maintaining, and developing with SQL Server
• Experience with Azure, such as deploying and managing resources

– • Deploy IaaS solutions with Azure SQL
– • Prepare to maintain SQL databases on Azure
– • Evaluate strategies for migrating to Azure SQL
– • Deploy PaaS solutions with Azure SQL
– • Migrate SQL workloads to Azure Managed Instances
– • Migrate SQL workloads to Azure SQL Databases
– • Configure database authentication and authorization
– • Protect data in transit and at rest
– • Configure SQL Server resources for optimal performance
– • Describe performance monitoring
– • Implement compliance controls for sensitive data
– • Describe high availability and disaster recovery strategies
– • Explore IaaS and PaaS solutions for high availability and disaster recovery
– • Back up and restore databases
– • Create and manage SQL Agent jobs
– • Manage Azure PaaS tasks using automation
– • Explore performance-based design
– • Automate deployment of database resources
– • Evaluate performance improvements
– • Explore query performance optimization
– • Configure databases for optimal performance
– • Plan and implement data platform resources
– • Implement a secure environment for a database service
– • Monitor and optimize operational resources in Azure SQL
– • Optimize query performance in Azure SQL
– • Automate database tasks for Azure SQL
– • Plan and implement a high availability and disaster recovery environment
– • Introduction to Azure database administration
– • LAB Outline

Class Dates & Times


4/28/2025 Virtual 09:00:00-17:00:00 CST Enroll Now $2,495.00
5/12/2025 Virtual 09:00:00-17:00:00 CST Enroll Now $2,495.00
6/23/2025 Virtual 09:00:00-17:00:00 CST Enroll Now $2,495.00
7/21/2025 Virtual 09:00:00-17:00:00 CST Enroll Now $2,495.00
8/18/2025 Virtual 09:00:00-17:00:00 CST Enroll Now $2,495.00
9/15/2025 Virtual 09:00:00-17:00:00 CST Enroll Now $2,495.00
10/14/2025 Virtual 09:00:00-17:00:00 CST Enroll Now $2,495.00
11/17/2025 Virtual 09:00:00-17:00:00 CST Enroll Now $2,495.00
12/15/2025 Virtual 09:00:00-17:00:00 CST Enroll Now $2,495.00

— Questions?

Information Request

— Empower Change

Invest in Skills & Equality

Support Diversity, Equity, and Inclusion with Every Purchase.

Great Horizons is a North Carolina Certified HUB Vendor and WOSB. By becoming a patron of our organization, you are not only supporting a historically underutilized business, but a woman-owned small business as well.

Student? Switch to our Career Center Site →