DP-3020: Develop Data-Driven Applications with Azure SQL Database
Course Overview
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
Ready to Get Started?
Join thousands of professionals who have advanced their careers with our training programs.
Join Scheduled Training
Find upcoming sessions for this course and register for instructor-led training with other professionals.
View ScheduleCustom Training Solution
Need training for your team? We'll create a customized program that fits your organization's specific needs.
Get Custom Quote