Exam Prep DP-300: Azure Database Administrator Associate
- Offered byCoursera
Exam Prep DP-300: Azure Database Administrator Associate at Coursera Overview
Duration | 15 hours |
Start from | Start Now |
Total fee | Free |
Mode of learning | Online |
Official Website | Explore Free Course |
Credential | Certificate |
Exam Prep DP-300: Azure Database Administrator Associate at Coursera Highlights
- Flexible deadlines Reset deadlines in accordance to your schedule.
- Shareable Certificate Earn a Certificate upon completion
- 100% online Start instantly and learn at your own schedule.
- Coursera Labs Includes hands on learning projects. Learn more about Coursera Labs External Link
- Intermediate Level
- Approx. 15 hours to complete
- English Subtitles: English
Exam Prep DP-300: Azure Database Administrator Associate at Coursera Course details
- Database administration is one of the basic necessities of every enterprise. The growth of cloud and On-premises relational databases continues to create the need for professional database administrators. Therefore, an updated certification such as DP-300 could open up favorable options for employment of database administrators.
- The Azure database administrator implements and manages the operational aspects of cloud-native and hybrid data platform solutions built on SQL Server and SQL database services. Professionals in this role use a variety of methods and tools to perform and automate day-to-day operations, including applying knowledge of using T-SQL and other tools for administrative management purposes.
- These professionals are responsible for management, availability, security, and performance monitoring and optimization of database solutions. They evaluate and implement migration strategies for moving databases between Azure and on-premises. Also, they work with Azure data engineers, Azure solution architects, Azure developers, data scientists, and other professionals to manage operational aspects of data platform solutions.
- Microsoft Certified: Azure Database Administrator Associate Exam DP-300 training course includes more than 7 hours of training videos covering all the exam objectives. Learners could find a combination of Video Lectures, Reading material, Quizzes in the training course with comprehensive coverage of all topics regarding Microsoft Certified: Azure Database Administrator Associate Exam. These lectures are divided into 5 Modules and each module is further split into Lessons. The entire course includes Assessments (both Graded and Non-Graded) to validate knowledge checks of learners.
- The Azure Database Administrator Associate Exam DP-300 course is a comprehensive training program designed to prepare individuals for the DP-300 certification exam.
- This course covers various topics related to managing and maintaining cloud-based relational databases on the Microsoft Azure platform, such as implementing security, monitoring, and high availability solutions.
- Through a combination of lectures, hands-on labs, and practical exercises, candidates will learn how to deploy, manage, and optimize Azure SQL Database and Azure Cosmos DB environments.
- The course is ideal for IT professionals, developers, and database administrators who are interested in earning the Azure Database Administrator Associate certification and want to enhance their skills in cloud computing and database management.
- Upon completion of the course, candidates will have a solid understanding of Azure database concepts and principles, as well as the skills necessary to manage and maintain cloud-based databases on the Microsoft Azure platform.
- Overall, the Azure Database Administrator Associate Exam DP-300 course is a must-have for anyone who wants to succeed in the field of cloud-based database administration and pass the DP-300 certification exam.
Exam Prep DP-300: Azure Database Administrator Associate at Coursera Curriculum
Plan and Implement Data Platform Resources
Course Introduction
The different database offerings on Azure
Lab - Deploying an Azure virtual machine
Lab - Installing Microsoft SQL Server on the virtual machine
Lab - Connecting to Microsoft SQL Server
Lab - Using Azure Marketplace - SQL Server
The Azure SQL Database offering
Azure SQL Database - Pricing tiers
Lab - Deploying Azure SQL Database
Lab - Deploying a sample additional Azure SQL database
Scalability for different database offerings
Lab - Azure SQL Database Managed Instances - Setup
Lab - Azure SQL Database Managed Instances - Connecting to the Instance
Lab - Azure SQL Elastic Pool- Part 1
Lab - Azure SQL Elastic Pool- Part 2
SQL Server on Azure VM - Design for Performance
Database Partitioning Techniques
Patches for IaaS deployments
Hybrid deployments for SQL Databases
Lab - Azure SQL Data Sync
Lab - Database Migration - Evaluate requirements
Lab - Database Migration - Offline Migration
Database Migration - Online Migration
Course Outline
Week Outline
Practice Quiz
Practice Quiz
Graded Quiz
Implement a secure environment
Azure Active Directory
Lab - Configuring Azure AD Authentication
Lab - Creating Azure AD Users in Azure SQL database
Lab - Configuring security for SQL users
Azure SQL Database - Transparent Data Encryption
Lab - Azure SQL Database - Dynamic data masking
Lab - Azure key vault
Lab - Azure SQL Database - Encryption
Lab - Virtual Machine disk encryption
Lab - Azure SQL Database Firewalls
Lab - Azure SQL - Vulnerability Assessment
Lab - Azure SQL - Database classification
Lab - Azure SQL Database - Auditing
Week Outline
Practice Quiz
Practice Quiz
Graded Quiz
Monitor and optimize operational resources in Azure SQL
Lab - Azure Monitor - Azure SQL Database Metrics
Lab - Azure Monitor - Set up alerts
Lab - Azure SQL Database - Intelligent Insights
Azure SQL Database - Automatic Tuning
Lab - Elastic Job Agent - Setup
Lab - Elastic Job Agent - Implementation
Lab - Using the Query Store
Using Resource Governance
Lab - Understanding the Execution Plan
Database Normalization
Tables Indexes
Lab - Using Tables Indexes
Lab - Data Compression - Setup
Lab - Data Compression - Implementation
Lab - Dynamic Management Views
Week Outline
Practice Quiz
Practice Quiz
Graded Quiz
Plan Task Automation, Implement High Availability and Disaster Recovery (HA/DR) Environment
Lab - SQL Server on Azure VM - SQL Server Agent jobs- Part 1
Lab - SQL Server on Azure VM - SQL Server Agent jobs-Part 2
Lab - SQL Server on Azure VM - SQL Server Agent alerts
Lab - Azure Policies
Lab - Azure Resource Manager templates-Part 1
Lab - Azure Resource Manager templates-Part 2
High Availability and Disaster Recovery
Azure SQL Database backups
Lab - Azure SQL Database - Point in time restore
Azure SQL Database - Long term retention
Lab - Azure SQL Database - Replication
Lab - Azure SQL Database - Auto-Failover Groups
Lab - Availability Groups - Setup
Lab - Availability Groups - Implementation
Week outline
Practice Quiz
Practice Quiz
Graded Quiz
Perform Administration by Using T-SQL
Understanding database backups
Lab - SQL Database - Full backups and restore
Lab - SQL Database - Transaction Log Backups
Lab - SQL Database - Database Consistency checks
Lab - SQL Database - Database Roles
SQL Database - Database Growth
Week Outline
Key Takeaways of the Course
Practice Quiz
Graded Quiz
Overall Graded Assessment