After this training you can run databases on Azure SQL and SQL Server with confidence: you choose the right platform, migrate existing systems, find the causes of slow queries, and plan backups and failover against clear recovery targets. You automate routine tasks with Agent jobs and scripts. The course suits you if you already work with SQL Server and want to extend your administration skills to the cloud or to hybrid environments.
What you’ll take away.
- Choose the right Azure SQL offering and deploy it automatically
- Assess migrations to Azure and carry them out online or offline
- Set up authentication, encryption and compliance controls
- Analyse performance problems with Query Store, DMVs and execution plans
- Plan high availability, backups and disaster recovery against RPO and RTO
Your training in detail
- Who is it for?
- Database administrators and data platform professionals who run SQL Server and Azure SQL services.
- Prerequisites
- You should be able to read and write T-SQL and have experience with SQL Server, or with Azure SQL Database, SQL Managed Instance or SQL Server on Azure VMs.
- Format & planning
- Standard length: 4 training days. A different length can be arranged for companies.
Agenda: from understanding to application
Our independently developed agenda proposal. Focus areas, lab environment and scope are agreed before booking.
Comparing and deploying Azure SQL offerings
Scaling, partitioning and migration strategies
Entra ID authentication, permissions and encryption
Sensitive data: classification, audits, masking and row-level security
Monitoring and tuning with Query Store, Extended Events and indexes
Automation with SQL Server Agent, elastic jobs, Bicep and Azure CLI
Backup, restore, failover groups and Always On
You migrate a SQL Server database to Azure, speed up a slow query using Query Store, then test a point-in-time restore.
Exams, licences & credentials
This course prepares you for the DP-300 exam for the Microsoft Certified: Azure Database Administrator Associate certification. The exam and its fees are included only if your offer confirms this. The certificate comes from Microsoft. This is not an official Microsoft course.
Vendor references & review date
Sources checked on 2026-11-04. These sources describe the technology or external exam requirements. They do not imply a partnership with NextNowa.
Your learning content
These objectives describe the training topic. The specific syllabus, dates and trainer are agreed before booking; the written offer is binding.
Frequently asked questions
What does DP-300 assess?
Data platform deployment, security, monitoring and optimisation, automation, and high availability and disaster recovery. The English version was last updated on 27 October 2026.
Is it only about Azure?
No. The exam also covers on-premises SQL Server and hybrid scenarios, such as migrations and Azure Arc-enabled SQL services.
Does DP-300: Administering Microsoft Azure SQL Solutions include a certificate?
This course prepares you for the DP-300 exam for the Microsoft Certified: Azure Database Administrator Associate certification. The exam and its fees are included only if your offer confirms this. The certificate comes from Microsoft. This is not an official Microsoft course.