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

Ref. DP-300T00

Download PDF

Duration:

4

days

Exam:

Optionnel

Level:

Intermediate

Funding:

Eligible

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

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

Database administration in the cloud represents a major challenge for businesses today. Microsoft Azure SQL has become an essential solution for effectively managing your data infrastructures. This DP-300 training supports you in fully mastering Azure SQL administration.

A recognized certification training

This comprehensive program prepares you for the DP-300 exam. You will develop the technical skills necessary to administer SQL Server databases in Azure. The training covers all scenarios: cloud, hybrid, and on-premises. You will learn to configure, secure, and optimize your data environments.

The content is structured around practical and progressive modules. Each section addresses concrete issues encountered by professionals. Hands-on exercises consolidate your learning throughout the course. You will directly work with Azure SQL Database and Azure SQL Managed Instance tools.

Participant Profiles

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

Objectives

Administer a SQL Server infrastructure on Microsoft Azure
Deploy IaaS and PaaS solutions with Azure SQL
Migrate databases to Azure SQL Database and Managed Instance
Configure database security and authentication
Optimize query and resource performance
Implement high availability and disaster recovery
Monitor and diagnose performance issues
Protect sensitive data with Azure tools

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 for SQL Server database maintenance on Azure

Explore the role of a database administrator on Azure
Describe SQL Server-based offerings in Azure
Describe the roles of the Microsoft intelligent data platform
Understand SQL Server in an Azure virtual machine
Design an Azure SQL Database for cloud-native applications
Explore Azure SQL Managed Instance

Module 2: Deploy IaaS solutions with Azure SQL

Configure virtual machine sizing, storage, and network options
Ensure adequate performance for database workloads
Explain IaaS options for deploying SQL Server in Azure
Understand hybrid scenarios
Explore performance and security
Explain high availability and disaster recovery options
Provision a SQL Server instance on an Azure virtual machine

Module 3: Deploy PaaS solutions with Azure SQL

Provision and deploy Azure SQL Database and Azure SQL Managed Instance
Select appropriate options when migrating to the SQL PaaS platform
Explain PaaS options for deploying SQL Server in Azure
Explore a single SQL database
Deploy an elastic pool of SQL databases
Understand a hyperscale SQL database
Examine an Azure SQL managed instance
Deploy an Azure SQL database

Module 4: Migrate SQL Server workloads to Azure SQL Database

Explore different migration tools
Migrate SQL Server databases to Azure SQL Database
Choose the right Azure SQL Database feature
Use the Azure SQL migration extension to migrate to Azure SQL Database
Explore the Data Migration Assistant to migrate to Azure SQL Database
Migrate to an Azure SQL database using BACPAC
Use an online method to migrate to Azure SQL Database
Move data to Azure SQL Database
Migrate a SQL Server database to Azure SQL Database

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

Explore different migration tools
Migrate SQL Server databases to Azure SQL Managed Instance
Evaluate migration scenarios
Use Log Replay Service (LRS) to migrate
Migrate using a Managed Instance link
Move data to SQL Managed Instance
Migrate a SQL Server database to Azure SQL Managed Instance

Module 6: Configure database authentication and authorization

Contrast authentication using Microsoft Entra ID and SQL Server authentication
Implement different security principals
Configure permissions
Describe authentication and identities
Describe security principals
Describe database and object permissions
Identify authentication and authorization failures
Authorize access to Azure SQL Database with Microsoft Entra ID

Module 7: Protect data in transit and at rest

Explore encryption options available in Azure SQL
Configure firewall rules, Always Encrypted, and Transport Layer Security
Understand how SQL injection works
Explore Transparent Data Encryption
Configure server and database firewall rules
Explain object encryption and secure enclaves
Enable encrypted connections
Describe SQL code injection
Understand Azure Key Vault
Configure a server-based firewall rule from the Azure portal

Module 8: Implement compliance controls for sensitive data

Explore data classification features and sensitivity levels
Implement security options to ensure private data security
Discover data classification
Explore server and database auditing
Implement dynamic data masking
Implement row-level security
Understand Microsoft Defender for SQL
Explore the ledger
Implement Microsoft Purview
Enable Microsoft Defender for SQL and data classification

Module 9: Describe performance monitoring

Compare Azure and on-premises tools for monitoring and measuring performance
Determine critical metrics
Understand the purpose of a baseline for benchmarking
Configure extended event sessions for activity tracking
Describe performance monitoring tools
Describe critical performance metrics
Establish baseline metrics
Explore extended events
Describe database watcher (preview)
Explore Query Performance Insight
Isolate monitoring issues

Module 10: Configure SQL Server resources for optimal performance

Choose the appropriate size and storage options for Azure SQL databases
Configure server resources such as tempdb
Understand the use of Resource Governor
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

Implement tasks for IaaS and PaaS to manage indexes and statistics
Explore the automatic tuning feature of Azure SQL Database
Control database-level configuration options
Explore intelligent query processing
Explore database maintenance checks
Describe database-specific configuration options
Describe automatic tuning
Describe intelligent query processing
Detect and correct fragmentation issues

Module 12: Explore query performance optimization

Discover the different forms of execution plans
Compare estimated plans to actual plans
Discover how and why plans are generated
Discover the purpose and benefits of the Query Store
Understand query plans
Explain estimated query plans and actual query plans
Describe dynamic management views and functions
Explore the Query Store
Identify problematic query plans
Describe blocking and locking
Identify and resolve blocking issues

Module 13: Explore performance-based database design

Explore normalization of relational databases
Investigate the impact of using correct data types
Compare index types
Describe normalization
Choose appropriate data types
Design indexes
Identify database design issues

Module 14: Evaluate performance improvements

Evaluate changes that can be made to indexes
Determine the impact of changes made to queries and indexes
Explore Query Store hints
Explain wait statistics
Tune and manage indexes
Understand query hints
Explore performance scenarios
Isolate problem areas in poorly performing queries

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

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

The evolution of database architectures in Azure

The relational database landscape is undergoing a profound transformation. Companies are gradually abandoning their traditional on-premises infrastructures. Microsoft Azure SQL responds to this shift by offering flexible and scalable models. The architectural decisions made today determine the success of your future projects.

Organizations face complex strategic choices. Should they prioritize total control with virtual machines? Or opt for the simplicity of a fully managed database? Each option carries significant financial and operational implications. A thorough understanding of these alternatives becomes essential for professionals.

Managed instances represent a major innovation in this ecosystem. They combine maximum SQL Server compatibility with cloud automation. This approach significantly facilitates migrations of existing applications. Teams retain their skills while benefiting from Azure advantages.

Real challenges of cloud migration

Migrating a critical database is never a trivial operation. Technical teams must anticipate numerous potential obstacles. SQL Server feature compatibility constitutes the first point of vigilance. Some syntaxes or stored procedures sometimes require minor adjustments.

The migration window often represents a major constraint for businesses. Business applications rarely tolerate prolonged interruptions. Continuous replication techniques minimize these downtimes. The final switchover then takes only a few minutes.

Network aspects also require particular attention. Hybrid connectivity between on-premises environments and Azure demands careful configuration. Site-to-site VPNs or ExpressRoute guarantee secure and high-performance communications. These infrastructure elements determine the success of your migration.

Prior assessment largely determines project success. Free tools analyze your existing databases in depth. They identify potential incompatibilities before actual deployment. This preparation phase avoids unpleasant surprises in production.

Security and compliance in a regulated world

Data protection regulations are multiplying around the world. GDPR in Europe imposes strict requirements on personal information management. Swiss companies must also comply with the Federal Data Protection Act. Azure SQL natively integrates mechanisms to meet these obligations.

Complete traceability of data access becomes an absolute necessity. Every consultation, modification, or deletion must be reliably recorded. Audit logs feed monitoring and anomaly detection systems. This proactive approach prevents major security incidents.

Systematic encryption protects your most sensitive information assets. Data remains unreadable even in case of unauthorized storage access. Cryptographic keys benefit from centralized and highly secure management. This architecture meets the most demanding standards of the financial sector.

Automatic classification simplifies the identification of sensitive data. Algorithms automatically detect social security numbers or bank details. Administrators then apply appropriate protection policies. This automation significantly reduces the risk of human error.

Performance and continuous optimization

Application slowness immediately causes end-user frustration. Every millisecond gained concretely improves the overall user experience. Query optimization represents an often underutilized improvement lever. A simple index modification can divide response times by ten.

Diagnosing performance issues requires a rigorous methodology. Analysis always begins with identifying the most expensive queries. Execution plans reveal inefficient operations performed by the engine. This scientific approach advantageously replaces haphazard approximations.

Database statistics play a crucial but often overlooked role. They guide the optimizer in choosing the best execution strategies. Obsolete statistics inevitably generate suboptimal plans. Regular maintenance of these metadata ensures stable performance.

Appropriate resource sizing avoids significant budget waste. Azure offers flexible pricing based on actual consumption. Development environments can use economical service tiers. This elasticity enables continuous optimization of operational costs.

FAQ

Is Azure SQL Database suitable for critical transactional applications?

Absolutely, Microsoft guarantees a 99.99 percent availability SLA. Automatic replication mechanisms ensure protection against failures. Many Fortune 500 companies use Azure SQL for their critical applications. Performance rivals traditional on-premises infrastructures.

How can I effectively manage costs in Azure SQL?

Continuous consumption monitoring constitutes the essential first step. Underutilized databases can automatically switch to lower tiers. Elastic pools share resources among multiple databases. These strategies significantly reduce the overall monthly bill.

Can I keep my existing backups during migration?

Yes, several approaches allow you to integrate your backups into Azure. The service automatically maintains a restoration history for several weeks. You freely configure retention according to your specific needs. This flexibility reassures IT managers about data protection.

What skills are really necessary to administer Azure SQL?

Solid SQL Server experience constitutes the required fundamental foundation. Understanding cloud concepts provides substantial added value. Microsoft certifications like DP-300 officially validate these sought-after skills. Continuous training remains essential in this evolving technological environment.