What you'll get
- 3+ Hours
- 1 Courses
- Course Completion Certificates
- Self-paced Courses
- Technical Support
- Case Studies
Synopsis
- Design and deploy data platform resources to support organizational objectives.
- Establish and maintain a secure database environment.
- Monitor system operations to enhance resource efficiency.
- Optimize query execution and overall database performance.
- Automate routine administrative and operational tasks.
- Plan and implement High Availability and Disaster Recovery (HADR) solutions.
- Manage and perform administrative tasks with T-SQL.
Content
| Courses | No. of Hours | Certificates | Details |
|---|---|---|---|
| DP-300 Azure Relational DBA | 2h 59m | ✔ | View Curriculum |
Description
This course offers in-depth training for the Microsoft DP-300: Administering Relational Databases on Microsoft Azure certification. It emphasizes Azure SQL Database administration while also covering Azure SQL Managed Instances and SQL Server on Azure Virtual Machines. Learners will explore the distinct capabilities of Managed Instances and SQL Server running on Azure Virtual Machines.
Learners will develop skills in setting up alerts, troubleshooting performance issues, and automating routine tasks. The course also covers database backup and restore on Virtual Machines, along with planning, testing, and configuring High Availability and Disaster Recovery strategies.
Minimal prior knowledge is required. Participants should be familiar with SELECT statements. A basic understanding of Microsoft Azure is helpful but not required.
Specifically, learners are expected to have basic SQL Server skills, including:
- Writing SELECT statements
- Creating views and stored procedures
- Performing database backups and restores
Familiarity with Azure fundamentals, such as those covered in the DP-900 exam, is beneficial but not essential.
After completing the course, participants will have practical skills to administer Azure SQL Databases, Azure SQL Managed Instances, and SQL Server on Azure Virtual Machines. With further practice, learners will be well-prepared for the Microsoft DP-300 certification, which can strengthen a professional resume or CV.
Requirements
- A strong interest in exploring and learning Microsoft’s rapidly evolving cloud platform.
- No prior Azure account or subscription is necessary to participate.
Target Audience
- This course is designed for professionals who implement or manage operational aspects of cloud-native and hybrid data platform solutions with Azure Data Services and SQL Server.
- It is well-suited for database administrators and data management specialists responsible for on-premises and cloud-based relational databases using Microsoft SQL Server and Azure Data Services.
- Completing this course and practicing with official preparation tests will prepare participants for the Microsoft DP-300 exam. Earning the Microsoft Certified: Azure Database Administrator Associate certification can significantly enhance a professional profile and strengthen a CV or resume.
