Address
Level 8/25 Restwell Street, Bankstown NSW 2200, Australia
Business Hours
Monday to Friday: 10AM - 6PM
Weekend: CLOSED
DP-300T00: Implement scalable database solutions using Azure SQL
This intermediate course gives database professionals practical skills to plan, secure, monitor, optimise and automate database solutions on Azure SQL. It covers deploying IaaS and PaaS options, migrating SQL Server workloads, protecting sensitive data, tuning query performance and keeping databases highly available. It prepares you for the Microsoft Certified: Azure Database Administrator Associate (DP-300) exam.
Duration
32 hours (4 days)
Modules
6 Modules
Course type
Microsoft
Course Overview
This intermediate-level course is designed for database administrators and data professionals who manage relational databases in cloud, on-premises, or hybrid environments. Learners will gain hands-on experience in planning, securing, optimizing, and automating Azure SQL database solutions. The course prepares candidates for the Azure Database Administrator Associate certification.
Before You Begin
- Experience with SQL Server and relational databases
- Familiarity with Azure services and portal usage
- Understanding of security concepts and access management
- Basic knowledge of performance tuning and automation
Key outcomes
- Plan Scalable Resources Design data platforms for performance and growth.
- Secure Azure SQL Access Control permissions and protect database environments.
- Optimize & Automate Tasks Improve query performance and automate admin routines.
- Backup & Recovery Strategy Implement disaster recovery and ensure data resilience.
Tools you’ll use
Azure Portal
Azure SQL Database & Managed Instance
Microsoft SQL Server Management Studio (SSMS)
Azure Monitor & Log Analytics
Azure Automation & PowerShell
Skills you’ll gain
- Deploy and manage Azure SQL resources
- Secure databases with roles and policies
- Monitor and optimize database performance
- Automate tasks using built-in tools
- Implement backup and recovery strategies
What You’ll Learn
6 modules
1Lesson 1: Plan and Implement Data Platform Resources
Module 1: Prepare to Maintain SQL Server-Based Databases on Azure Module 2: Deploy IaaS Solutions with Azure SQL Module 3: Deploy PaaS Solutions with Azure SQL Module 4: Migrate SQL Server Workloads to Azure SQL Database Module 5: Migrate SQL Server Workloads to Azure SQL Managed Instance
2Lesson 2: Implement a Secure Environment for a Database Service
Module 1: Configure Database Authentication and Authorization Module 2: Protect Data In-Transit and At Rest Module 3: Implement Compliance Controls for Sensitive Data
3Lesson 3: Monitor and Optimize Operational Resources in Azure SQL
Module 1: Describe Performance Monitoring Module 2: Configure SQL Server Resources for Optimal Performance Module 3: Configure Databases for Optimal Performance
4Lesson 4: Optimize Query Performance in Azure SQL
Module 1: Explore Query Performance Optimization Module 2: Explore Performance-Based Database Design Module 3: Evaluate Performance Improvements
5Lesson 5: Automate Database Tasks for Azure SQL
Module 1: Automate Database Deployment Module 2: Create and Manage SQL Agent Jobs Module 3: Manage Azure PaaS Tasks Using Automation
6Lesson 6: Plan and Implement a High Availability and Disaster Recovery Environment
Module 1: Describe High Availability and Disaster Recovery Strategies Module 2: Explore IaaS and PaaS Solutions for High Availability and Disaster Recovery Module 3: Back Up and Restore Databases
Certification & Credentials
Certificate track
32 hours (4 days)
Frequently asked questions
Is this course suitable for beginners?
No, it’s intended for professionals with database experience.
What certification does this course support?
It supports the Azure Database Administrator Associate certification.
Will I learn both on-premises and cloud solutions?
Yes, the course covers hybrid, cloud, and on-premises scenarios.
Are hands-on labs included?
Yes, practical labs are integrated throughout the course.
Can I take this course online?
Yes, both instructor-led and self-paced formats are available.
| Duration | 32 hours (4 days) |
|---|---|
| Modules | 6 Modules |
| Course type | Microsoft |
| Category | Microsoft |
| Prerequisites | Experience with SQL Server and relational databases, Familiarity with Azure services and portal usage, Understanding of security concepts and access management, Basic knowledge of performance tuning and automation |
Be the first to review “DP-300T00: Implement scalable database solutions using Azure SQL”
Reviews
There are no reviews yet.