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

Course Overview

1 - Get started with Azure SQL Database for modern application development

• Explain deployment options
• Explore Hyperscale capabilities
• Understand the serverless compute tier
• Enable application resilience with Azure SQL Database
• Understand AI capabilities for Azure SQL Database

2 - Develop for Azure SQL Database

• Create and configure an Azure SQL Database
• Use SQL Database Projects
• Build and deploy database projects in GitHub Actions and Azure DevOps
• Secure and monitor Continuous Integration and Continuous Deployment (CI/CD)

3 - Develop a data API for Azure SQL Database

• Explore 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

4 - Explore data manipulation options in Azure SQL Database

• Use RESTful endpoints to import data to Azure SQL Database
• Manipulate data in Azure SQL Database with Azure Functions
• Understand the data movement tools available

5 - Explore security practices for Azure SQL Database

• Explore authentication methods
• Configure managed identity
• Understand firewall rules
• Explore advanced data security

Prerequisites

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