Develop data-driven applications by using Azure SQL Database (DP-3020)

This hands-on course teaches developers and solution architects how to build, deploy, and secure data-driven applications using Azure SQL Database. Learn how to create and configure databases, automate deployment with CI/CD pipelines, and develop APIs using Azure services. Gain practical experience in data manipulation, security best practices, and integrating external data sources to enhance your application’s performance and resilience.

Develop data-driven applications by using Azure SQL Database (DP-3020) Benefits

• In this course, you will:

  • Learn to develop and deploy cloud-based applications using Azure SQL Database.
  • Automate database publishing with GitHub Actions and Azure DevOps.
  • Create REST and GraphQL-based APIs with Azure Data API Builder.
  • Import and export data using RESTful endpoints and Azure Functions.
  • Implement security best practices, including authentication, managed identities, and advanced data security.

• Prerequisites

  • Experience using the Azure portal to create resources.
  • Basic knowledge of security concepts like identities, permissions, and encryption.
  • Basic knowledge of networking concepts like virtual networks, subnetting, and hybrid scenarios.
  • Basic knowledge of Azure Policy and Azure Arc concepts.

Develop Data-Driven Apps with Azure SQL Training Outline

Learning Objectives

Module 1: Get Started with Azure SQL Database for Modern Application Development

• Overview of deployment options and Hyperscale capabilities.
• Understanding the serverless compute tier.
• Enabling application resilience with Azure SQL Database.
• Exploring AI capabilities for Azure SQL Database.

Module 2: Develop for Azure SQL Database

• Creating and configuring an Azure SQL Database.
• Using SQL Database Projects for development.
• Automating database deployment with GitHub Actions and Azure DevOps.
• Securing and monitoring CI/CD pipelines.

Module 3: Develop a Data API for Azure SQL Database

• Introduction to Azure Data API Builder for REST and GraphQL endpoints.
• Developing a data API using Azure Static Web Apps.
• Deploying a data API with Azure Web App for Containers.

Module 4: Explore Data Manipulation Options in Azure SQL Database

• Importing data using RESTful endpoints.
• Manipulating data with Azure Functions.
• Exploring data movement tools for automation and integration.

Module 5: Explore Security Practices for Azure SQL Database

• Authentication methods and configuring managed identities.
• Implementing firewall rules and advanced data security.
• Securing access and monitoring database security threats.