Course Overview
Learn how to develop data-driven applications by using Microsoft Azure SQL Database. DP-3020
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.
Course Content
Get started with Azure SQL Database for modern application development
- Introduction
- 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
- Exercise: Enable application resilience with Azure SQL Database
- Module assessment
- Summary
Develop for Azure SQL Database
- Introduction
- 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)
- Exercise: Configure and deploy CI/CD pipelines for Azure SQL Database projects
- Module assessment
- Summary
Develop a data API for Azure SQL Database
- Introduction
- 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
- Exercise: Develop a Data API for Azure SQL Database
- Module assessment
- Summary
Explore data manipulation options in Azure SQL Database
- Introduction
- 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
- Exercise: Import and export data for development in Azure SQL Database
- Module assessment
- Summary
Explore security practices for Azure SQL Database
- Introduction
- Explore authentication methods
- Configure managed identity
- Understand firewall rules
- Explore advanced data security
- Exercise: Configure managed identity for Azure SQL Database
- Module assessment
- Summary