DP-300 Azure Relational DBA

This course is part of Microsoft Azure: Cloud Solutions Mastery Specialization

Instructor: EDUCBA

Included with Learn more

Ask Coursera

3 modules

Gain insight into a topic and learn the fundamentals.

Intermediate level

Recommended experience

7 hours to complete

Flexible schedule

Learn at your own pace

3 modules

Gain insight into a topic and learn the fundamentals.

Intermediate level

Recommended experience

7 hours to complete

Flexible schedule

Learn at your own pace

What you'll learn

Identify Azure SQL deployment models and configure relational database environments using Azure tools and best practices.
Evaluate database solutions based on performance, security, availability, and scaling requirements for Azure workloads.
Apply replicas, sharding, and SQL Data Sync to optimize distributed relational database architectures.
Develop and execute database migration strategies using Azure assessment tools while minimizing downtime and preserving data integrity.

Skills you'll gain

Tools you'll learn

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

11 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

Build your subject-matter expertise

This course is part of the Microsoft Azure: Cloud Solutions Mastery Specialization

When you enroll in this course, you'll also be enrolled in this Specialization.

Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate

There are 3 modules in this course

Build the skills required to design, administer, secure, scale, and migrate relational databases in Microsoft Azure with this comprehensive course aligned to the Microsoft DP-300: Administering Relational Databases on Azure certification. Through practical demonstrations and scenario-based learning, you will explore Azure SQL deployment models, provision database environments, configure connectivity, and apply best practices for database administration.

As you progress, you will evaluate database solutions based on business, performance, security, availability, and scalability requirements. You will learn how to plan resilient database architectures, implement vertical and horizontal scaling strategies, and optimize distributed environments using replicas, sharding, and SQL Data Sync. The course also guides you through planning and executing database migrations using Azure assessment tools while minimizing downtime and maintaining data integrity. Designed for database professionals and learners preparing for the DP-300 certification, this course combines foundational concepts with advanced administration and migration strategies. By the end of the course, you will be able to configure Azure SQL environments, evaluate deployment options, optimize database performance and availability, and develop effective migration strategies for relational databases in Microsoft Azure.

This module introduces learners to the foundational concepts and tools required for administering relational databases in Microsoft Azure. It covers the certification structure, account setup, core database service options, environment provisioning through Azure Portal and Marketplace, network access configuration, and deployment of sample databases. By completing this module, learners will gain practical experience in preparing their environment and understanding the platform offerings relevant to Azure Database Administration.

What's included

11 videos4 assignments

11 videosTotal 59 minutes

Introduction to Course6 minutes
Exam Requirements5 minutes
Azure Free Account4 minutes
Azure Relational Databases Covered in Exam5 minutes
SQL Database Options Overview8 minutes
Creating Azure VM and Installing SQL Server10 minutes
Connect Database Through Port 14335 minutes
Deploying SQL Server from the Azure Marketplace5 minutes
Maintenance Window2 minutes
Install Azure SQL Database8 minutes
Using Sample Database2 minutes

4 assignmentsTotal 60 minutes

Introduction and Course Overview10 minutes
Azure SQL Environment Setup10 minutes
Provisioning and Sample Database Setup10 minutes
Graded - Getting Started with Azure and SQL Databases30 minutes

This module equips learners with the knowledge and skills necessary to evaluate and design relational database solutions in Microsoft Azure based on workload demands, functional capabilities, performance needs, security considerations, and availability requirements. Through guided demonstrations and practical scenarios, learners will assess service models, plan scaling strategies, and prepare database environments to meet enterprise-grade architectural and compliance standards.

What's included

8 videos4 assignments

8 videosTotal 55 minutes

How to Choose an Azure Relational Database11 minutes
Evaluate Functional Requirements7 minutes
Evaluate Scaling Requirements4 minutes
Availability and Backup Requirements10 minutes
Security Requirements7 minutes
Scaling Azure SQL Database2 minutes
Using Elastic Pool Database to Scale6 minutes
Scaling SQL VM7 minutes

4 assignmentsTotal 60 minutes

Choosing and Evaluating Database Solutions10 minutes
High Availability and Security Planning10 minutes
Scaling Options10 minutes
Graded - Planning and Requirements Analysis30 minutes

This module provides learners with hands-on insights into advanced techniques for improving Azure SQL performance and availability using replicas, sharding, and SQL Data Sync. It also introduces the planning, assessment, and execution of database migrations and upgrades from on-premises or cloud environments into Azure. Learners will explore best practices for ensuring high integrity and low downtime during migration, as well as validate compatibility and optimize post-migration success.

What's included

6 videos3 assignments

6 videosTotal 47 minutes

Using SQL DB Replicas and Sharding6 minutes
SQL Data Sync9 minutes
Prepare a Migration Strategy8 minutes
Prepare an Upgrade Strategy3 minutes
Run a Migration Assessment12 minutes
Perform a Database Migration8 minutes

3 assignmentsTotal 50 minutes

Advanced Database Architecture10 minutes
Migration Planning and Execution10 minutes
Graded - Advanced Capabilities and Migration Strategy30 minutes

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.

Instructor

EDUCBA

1,707 Courses352,700 learners

Offered by

EDUCBA

Explore more from Cloud Computing

Status: Preview
Whizlabs
Exam Prep DP-300: Azure Database Administrator Associate
Course
Status: Free Trial
Microsoft
Microsoft Azure SQL
Course
Status: Free Trial
Microsoft
Microsoft Azure Cosmos DB
Course
Status: Free Trial
EDUCBA
DP-900 Azure Data Fundamentals
Course

Why people choose Coursera for their career

Felipe M.

Learner since 2018

"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020

"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021

"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Unlock access to 10,000+ courses with a subscription
Advance your career with an online degree
Earn a degree from world-class universities - 100% online
Join over 4,700 global companies that choose Coursera for Business

Frequently asked questions

To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.

When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.

Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.