As a candidate for this certification, you should have subject matter expertise in building database solutions that are designed to support multiple workloads built with: Azure SQL services SQL Server on-premises You’re a database administrator who manages cloud and on-premises databases built with Azure SQL services and SQL Server. As the Azure database administrator, you implement and manage the operational aspects of cloud-native and hybrid data platform solutions built on Azure SQL services and SQL Server. You use a variety of methods and tools to perform and automate day-to-day operations, including applying knowledge of using Transact-SQL (T-SQL) and other tools for administrative management purposes. You’re responsible for the following concerning database solutions: Management Availability Security Performance monitoring and optimization You evaluate and implement migration strategies for moving databases between Azure and on-premises. Plus, you work with Azure data engineers, Azure solution architects, Azure developers, data scientists, and other professionals to manage operational aspects of data platform solutions. As a candidate for this certification, you should have knowledge of and experience with: Azure SQL Database Azure SQL Managed Instance SQL Server on Azure Virtual Machines (Windows and Linux) SQL Server on-premises Important The English language version of this certification will be updated on October 27, 2026. Review the study guide linked in the Certification resources section for details about upcoming changes. Tip A new Practice Assessment experience is available on AI Skills Navigator that more closely aligns with the exam experience. To try it, SIGN IN to AI Skills Navigator at Microsoft Certified: Azure Database Administrator Associate. Launch the Practice Assessment. You can also take the legacy Practice Assessment on Microsoft Learn at https://aka.ms/DP300-LearnPA. Please note that legacy Practice Assessments on Learn are no longer being updated. We strongly recommend using the new experience.

To earn this Microsoft Applied Skills credential, learners demonstrate the ability to assess and migrate SQL Server workloads to Azure SQL Database. Candidates for this credential should have a solid understanding of both database-level and instance-level scoped objects in SQL Server. They should also be familiar with provisioning Azure SQL resources and navigating the Azure portal.

This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database, Azure Synapse Analytics, and Microsoft Fabric. Audience Profile This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers.