DP-3020 – Develop data-driven applications with Azure SQL Database

About the Course

This learning path prepares you for the task of developing data-driven applications by using Microsoft Azure SQL Database. You’ll learn how to create and configure an Azure SQL Database, build and deploy database projects using GitHub Actions and Azure Pipelines, and automate the publishing process. Additionally, you’ll explore how to use Data API builder for Azure SQL Database and develop a data API with Azure Web Apps and Static Web App. Furthermore, you’ll gain skills in importing data via an external REST endpoint, exporting data using an Azure Function, and securing an Azure SQL Database. These essential skills will empower you to effectively develop and manage applications using Azure SQL Database.

There are currently no scheduled sessions available for this course. However, feel free to contact us for more information or to inquire about upcoming sessions.

Questions about this? let our team answer them!

Course Outline

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
• Use Azure Static Web Apps with a data API
• 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

Course Details

Pre-requisites

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

Target Audience

Candidates for this credential should have experience developing data-driven applications. They should also be familiar with the Azure ecosystem and the components involved in developing applications that include Azure SQL Database. Candidates need a basic understanding of Git-based source control, in addition to how REST APIs interact with Azure SQL Database for data operations.

Class Format

For online (live) format

There are currently no scheduled sessions available for this course. However, feel free to contact us for more information or to inquire about upcoming sessions.