Exam Prep DP-300: Azure Database Administrator Associate
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.
Monthly Subscription Starting at AED 99 + VAT
- Level Professional
- Duration 16 hours
- Course by Whizlabs
-
Offered by
About
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.Modules
Course Introduction and Working with Azure Virtual Machines
-
6
Videos
-
2
Readings
-
1
Discussion
-
1
Assignment
1
Assignment
- Practice Quiz 1
1
Discussions
- Meet and Greet
6
Videos
- 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
2
Readings
- Course Outline
- Week Outline
The Azure SQL Database
-
11
Videos
-
1
Assignment
1
Assignment
- Practice Quiz 2
11
Videos
- 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
Azure SQL Data Sync and Database Migration
-
6
Videos
-
1
Assignment
1
Assignment
- Week 1 Assessment
6
Videos
- 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
Azure Active Directory
-
3
Videos
-
1
Readings
-
1
Assignment
1
Assignment
- Practice Quiz 3
3
Videos
- Azure Active Directory
- Lab - Configuring Azure AD Authentication
- Lab - Creating Azure AD Users in Azure SQL database
1
Readings
- Week Outline
Configuring SQL Security
-
10
Videos
-
2
Assignment
2
Assignment
- Practice Quiz 4
- Week 2 Assessment
10
Videos
- 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
Azure Monitor
-
2
Videos
-
1
Readings
2
Videos
- Lab - Azure Monitor - Azure SQL Database Metrics
- Lab - Azure Monitor - Set up alerts
1
Readings
- Week Outline
Implement a secure environment
-
7
Videos
-
1
Assignment
1
Assignment
- Practice Quiz 5
7
Videos
- 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 and Table Indexes
-
3
Videos
3
Videos
- Database Normalization
- Tables Indexes
- Lab - Using Tables Indexes
Data Compression
-
3
Videos
-
2
Assignment
2
Assignment
- Practice Quiz 6
- Week 3 Assessment
3
Videos
- Lab - Data Compression - Setup
- Lab - Data Compression - Implementation
- Lab - Dynamic Management Views
Perform automation of tasks
-
6
Videos
-
1
Readings
-
1
Assignment
1
Assignment
- Practice Quiz 7
6
Videos
- 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
1
Readings
- Week outline
Plan and Implement a High Availability and Disaster Recovery (HA/DR) Environment
-
8
Videos
-
2
Assignment
2
Assignment
- Practice Quiz 8
- Week 4 Assessment
8
Videos
- 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
Understanding database backups
-
3
Videos
-
1
Readings
-
1
Assignment
1
Assignment
- Practice Quiz 9
3
Videos
- Understanding database backups
- Lab - SQL Database - Full backups and restore
- Lab - SQL Database - Transaction Log Backups
1
Readings
- Week Outline
Database Consistency checks and Database Roles
-
3
Videos
-
1
Readings
-
2
Assignment
2
Assignment
- Week 5 Assessment
- Overall Graded Assessment
3
Videos
- Lab - SQL Database - Database Consistency checks
- Lab - SQL Database - Database Roles
- SQL Database - Database Growth
1
Readings
- Key Takeaways of the Course
Auto Summary
The "Exam Prep DP-300: Azure Database Administrator Associate" course offered by Coursera is a thorough and engaging training program tailored for IT professionals, developers, and database administrators aiming to excel in cloud computing and database management. This course is specifically designed to prepare individuals for the DP-300 certification exam, which is crucial for those pursuing a career in database administration with a focus on cloud and hybrid data platform solutions. Led by expert instructors, this comprehensive program spans over 7 hours of rich content, including video lectures, reading materials, quizzes, and practical assessments. The curriculum is meticulously organized into 5 modules, each further divided into concise lessons that cover all exam objectives. Key topics include implementing security, monitoring, high availability solutions, and optimizing Azure SQL Database and Azure Cosmos DB environments. Learners will gain hands-on experience through practical exercises and labs, ensuring they acquire the necessary skills to manage, maintain, and optimize cloud-based relational databases on the Microsoft Azure platform. Upon completion, participants will possess a solid understanding of Azure database concepts and principles, enabling them to efficiently handle the operational aspects of data platform solutions. This course is a valuable asset for anyone looking to achieve the Azure Database Administrator Associate certification and advance their expertise in the field of database administration. With a flexible subscription model and professional-level content, it is an essential investment for those committed to excelling in the dynamic domain of cloud-based database management.
Whizlabs Instructor