DP-300 Administering Microsoft Azure SQL Solutions Course

The Microsoft Certified: Azure Database Administrator Associate credential proves you can administer cloud and hybrid relational databases built on Azure SQL services and SQL Server. It signals to employers that you can deploy and secure data platforms, keep them fast and available, and recover them when something goes wrong. It sits at the associate, role-based level of the Microsoft data path, a clear step beyond the DP-900 data fundamentals and a credential that maps directly to the day-to-day Azure Database Administrator job. With organisations moving SQL workloads to the cloud, it is a credential that holds its value and supports strong salary outcomes for database professionals.

Choosing Logitrain for your DP-300 training means the official exam fee is included, and you can sit the exam within three months of completing the course. You keep the DP-300 digital course material for ongoing reference, you are covered by our price beat guarantee on any competitor’s advertised price, and you can sit the exam at the Logitrain test centre, at any other Pearson VUE test centre, or online with Pearson VUE online proctoring. Training is delivered in-person in Melbourne, Sydney, Brisbane, Adelaide, Perth and Canberra, plus live online across Australia, all delivered live in real time with a trainer, so you can choose what fits your schedule and location.

There are no mandatory prerequisites for DP-300, so you can enrol without holding an earlier certification. To get the most from the course, Microsoft recommends professional experience with database management and a working knowledge of Transact-SQL, along with familiarity with Azure SQL Database, Azure SQL Managed Instance, SQL Server on Azure Virtual Machines and SQL Server on-premises.

If you are newer to Azure or to data in the cloud, the better starting points are the AZ-900 Microsoft Azure Fundamentals course for core cloud concepts and the DP-900 Microsoft Azure Data Fundamentals course for core data concepts. Both build the background that makes the DP-300 material easier to absorb.

Candidates can achieve this certification by passing the following exam.

• DP-300: Administering Microsoft Azure SQL Solutions, leading to Microsoft Certified: Azure Database Administrator Associate

You can book and sit the exam within three months of finishing your course. Sit it at the Logitrain test centre, at any other Pearson VUE test centre, or online through Pearson VUE online proctoring from a private space.

Exam format: a maximum of 40 to 60 multiple choice and performance based questions, around 100 minutes, with a passing score of 700 on a scale of 1 to 1000.

The digital course material for DP-300: Administering Microsoft Azure SQL Solutions is included, mapped to the current exam objectives. It is provided in digital format for flexibility and is yours to keep for revision and on-the-job reference.

• Deploy Azure SQL Database, Azure SQL Managed Instance and SQL Server on Azure Virtual Machines
• Recommend the right Azure SQL offering for a given workload and requirement
• Configure data platform resources for scale and performance
• Plan and run online and offline migrations to Azure SQL
• Secure databases using Microsoft Entra ID authentication and least privilege
• Protect data with Transparent Data Encryption, Always Encrypted and dynamic data masking
• Configure firewall rules, auditing and vulnerability assessments
• Monitor performance using Query Store and intelligent performance features
• Optimise query performance and review index design
• Automate maintenance, backups and patching with SQL Server Agent and Azure Automation
• Configure high availability with Always On availability groups and failover clustering
• Plan and test disaster recovery using failover groups and geo-replication
• Perform backup and restore, including point-in-time recovery
• Administer Azure SQL databases efficiently using Transact-SQL

This course is likely to add to the employment-related skills of the participants. The skills developed are likely to be used in the course of being an employee or working in a business.

• Database administrators
• Azure database administrators
• SQL Server administrators and database engineers
• Data platform engineers
• Cloud engineers and cloud administrators moving into data roles
• On-premises database administrators migrating workloads to Azure SQL
• Data architects and application developers who work with Azure SQL
• IT professionals preparing for the DP-300 exam and the Azure Database Administrator Associate certification

Plan and implement data platform resources

• Recommend an appropriate Azure SQL database offering for specific requirements
• Choose an automated deployment method for database resources
• Identify use cases for Azure Arc-enabled SQL services
• Identify use cases for Azure SQL Database in Microsoft Fabric
• Plan and configure table partitioning
• Recommend a database sharding solution
• Deploy database offerings on Azure SQL Database, Managed Instance and SQL Server on Azure Virtual Machines
• Deploy hybrid SQL Server solutions
• Apply patches and updates for hybrid and infrastructure as a service deployments
• Configure Azure SQL resources for scale and performance
• Configure data compression
• Evaluate requirements for a database migration
• Compare offline and online migration strategies
• Implement an online or offline migration to Azure
• Migrate between Azure SQL services
• Implement Azure SQL Managed Instance database copy and move
• Troubleshoot a migration

Implement a secure environment

• Configure Microsoft Entra ID authentication for Azure SQL
• Configure authentication for SQL on Azure Virtual Machines and Managed Instance
• Configure security principals and create users from Microsoft Entra identities
• Configure database and object-level permissions using graphical tools
• Apply the principle of least privilege for all securables
• Implement Transparent Data Encryption
• Implement Always Encrypted and object-level encryption
• Configure dynamic data masking
• Configure Azure Key Vault and disk encryption for Azure Virtual Machines
• Configure server and database firewall rules and network security
• Apply a data classification strategy
• Configure server and database audits
• Perform a vulnerability assessment

Monitor, configure and optimise database resources

• Prepare an operational performance baseline
• Determine and interpret sources of performance metrics
• Assess database performance using Azure SQL intelligent performance
• Configure and monitor activity using extended events
• Configure and manage Query Store
• Optimise IOPS, throughput and latency
• Optimise tempdb and configure storage for performance
• Implement index and statistics maintenance tasks
• Configure database automatic tuning
• Review and analyse query execution plans
• Identify and implement index changes for queries
• Recommend query construct modifications based on resource usage
• Review database table and index design

Configure and manage automation of tasks

• Create and schedule regular maintenance jobs
• Configure multi-server automation
• Configure notifications for task success, failure and non-completion
• Create event notifications for Azure resources and metrics
• Automate the deployment of database resources
• Automate backups, patching and performance tuning
• Manage SQL Server Agent jobs, Azure Automation and elastic jobs
• Implement policies using automated evaluation modes

Plan and configure a high availability and disaster recovery environment

• Recommend a high availability and disaster recovery strategy based on RPO and RTO requirements
• Evaluate high availability and disaster recovery for hybrid and Azure-specific deployments
• Configure replication
• Create and configure Always On availability groups
• Configure a Windows Server failover cluster and quorum options
• Configure an availability group listener
• Configure failover groups and active geo-replication
• Perform backup and restore, including point-in-time restore
• Configure long-term backup retention
• Test high availability and disaster recovery using failover

• AZ-900 Microsoft Azure Fundamentals course: the recommended first step for anyone new to Azure, covering core cloud concepts before DP-300.
• DP-900 Microsoft Azure Data Fundamentals course: builds the core data concepts that make the DP-300 material easier to follow.
• AZ-104 Microsoft Azure Administrator course: a strong companion at the same associate level for administrators who manage the wider Azure environment, not just databases.
• Microsoft Azure training courses: the full Azure range if you are mapping a longer certification path.
• Microsoft courses: browse every Microsoft certification course Logitrain offers.
• Database job ready program: combines training, certifications, an internship and career counselling for those targeting a database administrator role from the ground up.

Got a team to train? Logitrain can deliver the DP-300 Administering Microsoft Azure SQL Solutions course in house at your premises anywhere in Australia, with the same experienced trainer, course material, mock test and the included official exam as the public courses. In-house delivery suits database and platform teams who want everyone trained together on Azure SQL administration, on dates that suit the business.

What is the DP-300 certification?

DP-300 is the Microsoft exam titled Administering Microsoft Azure SQL Solutions, and passing it earns the Microsoft Certified: Azure Database Administrator Associate credential. It proves you can deploy, secure, monitor and maintain relational databases on Azure SQL services and SQL Server.

Is the exam included in the course?

Yes. The official DP-300 exam fee is included, and you can book and sit the exam within three months of completing your course, at the Logitrain test centre, at any other Pearson VUE test centre, or online through Pearson VUE online proctoring.

What are the prerequisites for DP-300?

There are no mandatory prerequisites. Microsoft recommends experience with database management and Transact-SQL, plus familiarity with Azure SQL services and SQL Server. If you are newer to Azure, the AZ-900 and DP-900 courses are the recommended starting points.

Which exam version does this course cover?

The course covers the current DP-300: Administering Microsoft Azure SQL Solutions exam, aligned with the skills measured by Microsoft as of 2026, leading to the Azure Database Administrator Associate certification.

How long is the DP-300 course?

The course runs four days full-time on weekdays. It can also be taken part-time over four weeks on weeknights or weekends to suit professionals who are working.

Where can I train for DP-300?

Training is available in-person in Melbourne, Sydney, Brisbane, Adelaide, Perth and Canberra, plus live online across Australia, all delivered live in real time with a trainer.

How much does the DP-300 course cost?

Logitrain backs every course with a price beat guarantee on a competitor’s advertised price, and the included official exam means there are no hidden extras. Contact the team for current dates and pricing.

Which course should I do first, DP-900 or DP-300?

If you are new to data in the cloud, start with DP-900 Microsoft Azure Data Fundamentals to build the core concepts, then move to DP-300 for the role-based Azure Database Administrator skills and certification. Experienced database administrators can begin directly with DP-300.