DP-3020: Develop Data-Driven Applications with Azure SQL Database

Course Title:

DP-3020: Develop Data-Driven Applications with Azure SQL Database

Course Description:

Accelerate your application development with the power of Azure SQL Database. This instructor-led, hands-on course teaches developers how to build modern, scalable, and intelligent applications using cloud-based SQL databases. Learn how to leverage T-SQL, Azure SQL capabilities, and modern security and performance features to create highly available, data-driven solutions.

Through real-world examples and guided instruction, you'll gain the skills to design, implement, and optimize applications that connect seamlessly to Azure SQL Database, enabling you to build resilient and secure systems that scale globally. Whether you're migrating an existing app or building a new cloud-native solution, this course provides the practical knowledge and tools needed to succeed.

Note: 40% to 50% of the course includes hands-on exercises, giving you practical experience with Azure SQL Database development.

Target Audience:

This course is designed for:

• Application developers who build or maintain applications that interact with Azure SQL Database

• Data professionals looking to modernize their development skills in the cloud

• Cloud developers and architects focused on data-driven application design

• Anyone preparing for the Microsoft DP-300 or DP-420 certifications (as foundational preparation)

Prerequisites: Experience writing T-SQL and basic familiarity with relational databases and Azure services.

Course Outline:

Module 1: Introduction to Azure SQL Database for Developers

• Understand Azure SQL Database as a Platform-as-a-Service (PaaS)

• Compare deployment options: Azure SQL Database vs SQL Managed Instance

• Explore use cases for cloud-based database development

Module 2: Design and Implement Data Models

• Use T-SQL to create tables, constraints, indexes, and relationships

• Apply normalization and denormalization best practices

• Model data effectively for cloud scalability and performance

Module 3: Build Secure and Scalable Applications

• Integrate Azure SQL with application logic

• Secure your applications with Azure Active Directory, roles, and permissions

• Use parameterized queries and stored procedures to avoid SQL injection

Module 4: Optimize Performance for Cloud Applications

• Monitor and tune queries using Query Store, execution plans, and DMVs

• Implement indexing strategies for high-throughput scenarios

• Use automatic tuning and Intelligent Query Processing in Azure SQL

Module 5: Integrate Azure Services with Azure SQL Database

• Connect applications with Azure Functions, Logic Apps, and Event Grid

• Use Azure Key Vault for secure connection strings and credentials

• Implement alerting and automation with Azure Monitor and Log Analytics

Module 6: Implement Resilience and High Availability

• Design applications for fault tolerance and geo-redundancy

• Understand active geo-replication, failover groups, and point-in-time restore

• Leverage retry logic and transient fault handling in client apps

Module 7: Deploy and Monitor Applications in Azure

• Use Azure DevOps or GitHub Actions for CI/CD pipelines with Azure SQL

• Automate deployments with DACPACs, BACPACs, and ARM templates

• Monitor database health and usage with Azure SQL Insights

Delivery Format:

• Instructor-led with live demonstrations

• 40%–50% hands-on development exercises

• Access to Azure SQL development environment included