This course prepares students who are already familiar with core Azure services and Azure and SQL database skills used by Azure Database Administrators.
An Azure Database Administrator is responsible for the management, availability, security, performance monitoring, and optimization of modern relational database solutions. They also assist Azure Data Engineers in managing operational aspects of a data platform solution. Azure Database Administrators are familiar with:
- Deploying SQL database solutions within Azure
- Azure SQL Server, database, and query architecture
- Basic usage of Transact-SQL for administrative tasks
- Securing Azure SQL resources and data
- Interconnecting Azure SQL resources with other Azure services
- Monitoring and optimizing Azure SQL Database performance
- Maintaining business continuity for Azure SQL resources
- Processes for migrating on-premises SQL Server databases to Azure
- Other options for managing relational data in Azure
This course also prepares exam candidates to pass the DP-300: Administering Relational Databases on Microsoft Azure exam to attain the Azure Database Administrator Associate certification. Candidates for the exam are presumed to be database administrators and data management specialists that manage on-premises and cloud relational databases built on top of Microsoft SQL Server and Microsoft Azure data services.
Table of contents
About the authors
Landon Fowler
For as long as I can remember, I’ve been drawn to technology, eager to soak up everything I could learn about it. Over my 20-year career—spanning roles from helpdesk to server and database administration—I’ve discovered that one of my greatest joys is sharing that passion with others. These days, my focus is on data, which I believe is the cornerstone of all technology, driving innovation across every area of IT. I’m also a big fan of automation and love finding ways to streamline processes with tools like PowerShell.
Outside of work, I enjoy spending time with my family, volunteering with my church, and diving into a good book, movie, or video game. Whether on the page or the screen, I love a good adventure.
The Cloud Content team comprises subject matter experts hyper focused on services offered by the leading cloud vendors (AWS, GCP, and Azure), as well as cloud-related technologies such as Linux and DevOps. The team is thrilled to share their knowledge to help you build modern tech solutions from the ground up, secure and optimize your environments, and so much more!
