Training: Implement scalable database solutions using Azure SQL (DP-300)

Ref. DP-300T00

Download PDF

Duration:

jours

Exam:

Optionnel

Level:

Intermédiaire

Funding:

Eligible

Home > Trainings > IT Pro > Implement scalable database solutions using Azure SQL (DP-300)

Implement scalable database solutions using Azure SQL Training (DP-300)

You manage SQL Server databases and need to extend your skills to Azure cloud environments? Database administration is evolving rapidly with hybrid architectures combining on-premises SQL Server and Azure SQL services. Without up-to-date skills, ensuring performance, security and high availability across both environments becomes increasingly challenging.

This official Microsoft DP-300 training gives you in 4 days the expertise to administer relational databases on Azure and SQL Server. Guided by MCT-certified trainers, you master deployment planning, security configuration, performance monitoring and optimization, query tuning, and high availability strategies including backup and disaster recovery. You work with Azure SQL Database, Azure SQL Managed Instance and SQL Server on Azure VMs. This training prepares you for the Azure Database Administrator Associate certification. Sessions are available in person in Geneva and Lausanne or via virtual classroom.

Participant Profiles

Database administrators
Data professionals and analysts
Data architects
Application developers
System and cloud engineers
Microsoft technology consultants

Objectives

Plan and implement data platform resources on Azure
Configure secure environments for Azure SQL solutions
Monitor and optimize database performance and query execution
Implement high availability and disaster recovery strategies
Automate administrative tasks using T-SQL and Azure tools
Manage backups and restore operations across SQL environments
Configure and manage Azure SQL Database, Managed Instance and SQL Server on Azure VMs

Prerequisites

Basic knowledge of relational database administration
General understanding of cloud concepts and Azure services
Familiarity with SQL language and basic queries

Course Content

Module 1: Prepare to maintain SQL Server-based databases on Azure

Describe Microsoft Intelligent Data Platform roles
Understand SQL Server in an Azure virtual machine
Design Azure SQL Database for cloud-native applications
Explore Azure SQL Managed Instance

Module 2: Deploy IaaS solutions with Azure SQL

Explain IaaS options to deploy SQL Server in Azure
Understand hybrid scenarios
Explore performance and security
Explain high availability and disaster recovery options

Module 3: Deploy PaaS solutions with Azure SQL

Explain PaaS options for deploying SQL Server in Azure
Explore single SQL database
Deploy SQL database elastic pool
Understand SQL database hyperscale
Examine SQL managed instance

Module 4: Migrate SQL Server workloads to Azure SQL Database

Choose the right Azure SQL Database feature
Use Azure Database Migration Service to migrate to Azure SQL Database
Migrate to Azure SQL Database using BACPAC
Use an online method to migrate to Azure SQL Database
Move data to Azure SQL Database

Module 5: Migrate SQL Server workloads to Azure SQL Managed Instance

Evaluate migration scenarios
Migrate using Azure Arc
Use Log Replay Service (LRS) to migrate
Migrate using Managed Instance link
Move data to SQL Managed Instance

Module 6: Configure database authentication and authorization

Describe authentication and identities
Describe Security Principals
Describe database and object permissions
Identify authentication and authorization failures

Module 7: Protect data in-transit and at rest

Explore Transparent Data Encryption
Configure server and database firewall rules
Explain object encryption and secure enclaves
Enable encrypted connections
Describe SQL injection
Understand Azure Key Vault

Module 8: Implement compliance controls for sensitive data

Explore data classification
Explore server and database audit
Implement Dynamic Data Masking
Implement Row Level security
Understand Microsoft Defender for SQL
Explore Ledger
Implement Microsoft Purview

Module 9: Describe performance monitoring

Describe performance monitoring tools
Describe critical performance metrics
Establish baseline metrics
Explore extended events
Describe database watcher (preview)
Explore Query Performance Insight

Module 10: Configure SQL Server resources for optimal performance

Explain how to optimize Azure storage for SQL Server virtual machines
Describe virtual machine resizing
Optimize database storage
Control SQL Server resources

Module 11: Configure databases for optimal performance

Explore database maintenance checks
Describe database scoped configuration options
Describe automatic tuning
Describe intelligent query processing

Module 12: Explore query performance optimization

Understand query plans
Explain estimated and actual query plans
Describe dynamic management views and functions
Explore Query Store
Identify problematic query plans
Describe blocking and locking

Module 13: Explore performance-based database design

Describe normalization
Choose appropriate data types
Design indexes

Module 14: Evaluate performance improvements

Describe wait statistics
Tune and maintain indexes
Understand query hints
Explore performance scenarios

Module 15: Automate database deployment

Describe deployment models in Azure
Automate deployment by using Azure Resource Manager templates and Bicep
Automate deployment by using PowerShell
Automate deployment by using Azure CLI

Module 16: Create and manage SQL Agent jobs

Create a SQL Server maintenance plan
Describe task status notifications

Module 17: Manage Azure PaaS tasks using automation

Explore Elastic jobs
Understand Azure Automation
Build an automation runbook
Automate database workflows by using Logic Apps
Monitor automated tasks

Module 18: Describe high availability and disaster recovery strategies

Describe recovery time objective and recovery point objective
Explore high availability and disaster recovery options
Describe Azure high availability and disaster recovery features for Azure Virtual Machines
Describe high availability and disaster recovery for PaaS deployments
Explore high availability and disaster recovery solution for IaaS
Describe hybrid solutions

Module 19: Explore IaaS and PaaS solutions for high availability and disaster recovery

Describe failover clusters in Windows Server
Configure Always-on availability groups
Describe active geo-replication for Azure SQL Database
Explore auto-failover groups for Azure SQL Database and Azure SQL Managed Instance
Monitor availability

Module 20: Back up and restore databases

Back up and restore SQL Server running on Azure virtual machines
Back up a SQL Server virtual machine
Back up and restore a database for SQL Database and SQL Managed Instance

Documentation

Accès à Microsoft Learn, la plateforme d’apprentissage en ligne Microsoft, offrant des ressources interactives et des contenus pédagogiques pour approfondir vos connaissances et développer vos compétences techniques.

Lab / Exercises

This course provides you with exclusive access to the official Microsoft lab, enabling you to practice your skills in a professional environment.

Exam

This course prepares you to the DP-300: Azure Database Administrator Associate exam.

Complementary Courses

Eligible Funding

ITTA is a partner of a continuing education fund dedicated to temporary workers. This fund can subsidize your training, provided that you are subject to the “Service Provision” collective labor agreement (CCT) and meet certain conditions, including having worked at least 88 hours in the past 12 months.

Additional Information

Azure SQL administration: managing databases in hybrid cloud environments

Modern database administration extends far beyond managing on-premises SQL Server instances. Organizations in Switzerland increasingly deploy hybrid architectures combining SQL Server with Azure SQL Database, Azure SQL Managed Instance and SQL Server on Azure VMs. The DP-300 training prepares you to manage all these environments with a unified skill set. You learn to plan deployments, implement security, monitor performance, optimize queries and ensure business continuity through high availability and disaster recovery strategies.

What you learn during this 4-day training

The program covers the complete scope of Azure database administration following the official Microsoft curriculum. You start with planning and deploying data platform resources, then move to implementing secure environments, monitoring and optimizing performance, and configuring high availability. You work extensively with Azure SQL Database, Managed Instance and SQL Server on VMs. Advanced topics include automated tuning, intelligent query processing, backup strategies and disaster recovery configurations. Each module combines theory with practical labs on live Azure environments.

Frequently Asked Questions

What are the prerequisites for this DP-300 training?

You should have experience with SQL Server database administration and working knowledge of T-SQL. Familiarity with Azure fundamentals (AZ-900 level) is recommended. The DP-080 training provides the T-SQL foundation if needed.

Which certification does this training prepare for?

This training prepares you for the DP-300 exam leading to the Azure Database Administrator Associate certification, which validates your skills in managing relational databases across Azure and SQL Server.

Does this training cover Azure SQL Managed Instance?

Yes, the training covers all three Azure SQL deployment options: Azure SQL Database, Azure SQL Managed Instance and SQL Server on Azure Virtual Machines, including migration scenarios between them.