DP-3020: Develop data-driven applications by using Microsoft Azure SQL Database

Module 1: Get started with Azure SQL Database for modern application development

• Introduction
• Explain implementation options
  
• Exploring Hyperscale Capabilities
  
• Understanding the level of serverless computing
• Enable application resilience with Azure SQL Database
• Understand AI capabilities for Azure SQL Database
• Exercise: Enable application resilience with Azure SQL Database
  

Module 2: Developing for Azure SQL Database

• Introduction
• Create and configure an Azure SQL databaseUsing SQL database projects
• Create and deploy database projects to GitHub Actions and Azure DevOps
• Protect and monitor continuous integration and continuous deployment (CI/CD)
• Exercise: Configure and deploy CI/CD pipelines for Azure SQL Database projects

Module 3: Develop a data API for Azure SQL Database

• Introduction
• Explore the Data API Builder for Azure SQL Database
• Develop a data API using Azure Static Web Apps
• Develop a data API using Azure Web App for Containers
• Exercise: Develop a data API for Azure SQL Database

Module 4: Explore data manipulation options in Azure SQL Database

• Introduction
• Use RESTful endpoints to import data into Azure SQL Database
• Manipulate data in Azure SQL Database with Azure Functions
• Understand the data movement tools available
• Exercise: Develop a data API for Azure SQL Database

Module 5: Explore security practices for Azure SQL Database

• Introduction
• Explore authentication methods
• Configure managed identity
• Understanding firewall rules
• Explore advanced data security
• Exercise: Set up a managed identity for Azure SQL Database

• Experience with relational databases.
• Basic knowledge of security concepts such as identities and permissions.
• Experience using the Azure portal to create resources and set permissions.

• Course: English / Spanish
  

This course is part of the Microsoft Applied Skills Credentials.

Earn this Microsoft Applied Skills credential. In this course, you will learn how to develop data-driven applications using Microsoft Azure SQL Database.

Applied Skills: Explore all credentials in one guide