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
A Cloud Guru
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!
For as long as I can remember I've been tearing things apart to see how they work. Gadgets and tech are in my blood, and as I've grown I've discovered that one of my greatest joys is sharing that passion with others. I've been in IT for over 15 years, doing everything from helpdesk tech to server and database administration. In recent years my focus has been on databases and the cloud. I think that data is the fundamental component of all IT and that cloud technology is taking it to awesome new heights. I also enjoy DevOps, and particularly using scripting languages like PowerShell to automate all the things. Outside of work I love to spend time with my family, volunteer with my church, and read or play video games. I love a good adventure whether it's in book, movie, or video game form.