Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
5 Hour(s) 2 Minute(s)
Language
English
Taught by
Emar Morrison, Adrianna Parchment
Rating
Course Overview
Mastering Database Management and Security with Azure SQL Server
The Microsoft Certified: Azure Database Administrator Associate course is designed for individuals who want to gain expertise in managing and maintaining cloud-based databases using Microsoft Azure. This course provides a comprehensive understanding of database management in Azure and prepares students for the Azure Database Administrator Associate certification exam.
The course covers the following topics:
Introduction to Azure Databases: This section provides an overview of Azure databases and their benefits. Students will learn about different types of databases available in Azure, such as Azure SQL Database, Azure Database for MySQL, and Azure Database for PostgreSQL.
Designing and Implementing Azure Databases: This section covers the design and implementation of Azure databases. Students will learn how to create and configure databases, implement security measures, and optimize database performance.
Monitoring and Optimizing Azure Databases: This section covers techniques for monitoring and optimizing Azure databases. Students will learn how to use Azure Monitor to track database performance, implement backup and recovery strategies, and manage database growth.
Managing and Maintaining Azure Databases: This section covers the day-to-day management and maintenance of Azure databases. Students will learn how to manage database users and permissions, troubleshoot common issues, and implement disaster recovery measures.
Upon completion of the course, students will have a thorough understanding of managing and maintaining Azure databases and be prepared to take the Microsoft Certified: Azure Database Administrator Associate certification exam. This certification validates the student's skills in implementing and managing databases in Azure and demonstrates their expertise in cloud-based database administration.
Course Content
- 10 section(s)
- 51 lecture(s)
- Section 1 Introduction
- Section 2 Getting Started with Azure SQL
- Section 3 Deploy and configure servers, instances, and databases for Azure SQL
- Section 4 Configure database authentication and authorization
- Section 5 Implement compliance controls for sensitive data
- Section 6 Protect data in-transit and at rest and in-transit
- Section 7 Deploy highly available solutions by using Azure SQL
- Section 8 Migrating to Azure
- Section 9 Performance & Monitoring with Azure SQL
- Section 10 Automation & Maintenance
What You’ll Learn
- Students will learn how to create and manage databases in Azure dents and individuals who are interested in learning about databases and SQL as a career path
- Students will learn how to migrate data from on-premises databases to Azure SQL Database, including best practices and considerations for the migration process.
- Students will learn how to monitor and troubleshoot Azure SQL Database
- Students will learn how to scale and configure high availability solutions in Azure SQL Database, including how to set up geo-replication and failover groups.
Skills covered in this course
Reviews
-
VVenkatesh
azure sql backups and types and authentication types
-
AAnkita Kumari
Awesome course, everyone should watch this course.
-
AAthanasios Peristeropoulos
Great intro
-
SSilvestre Kuala
I can't provide more than that as we still in the beginning...
