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

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

Learn how to develop data-driven applications using Azure SQL Database. Learn how to leverage its advanced capabilities to create scalable and secure solutions.

Intermediate - Developer - Azure SQL Database - Application Development, Back-end Development, Cloud Computing

Course aimed at

The DP-3020 course is designed for developers, solution architects, and IT professionals who want to build optimized, secure, and scalable applications using Azure SQL Database. It's ideal for those with basic knowledge of relational databases looking to enhance their skills in modern development environments.

DP-3020 Training Objectives

• Configure and manage Azure SQL Database.
  
• Development and deployment automation.
  
• API development for data-driven applications.
• API development for data-driven applications.
• Data management using REST endpoints and Azure functions.
• Implement advanced security measures to protect your Azure SQL Database from unauthorized access and threats.

DP-3020 Course Content

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

• Introduction
• Explain implementation options
  
• Explore hyperscale capabilities
  
• Understand the serverless computing tier
• 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 in 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: Developing 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: Developing 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: Developing a Data API for Azure SQL Database

Module 5: Explore security practices for Azure SQL Database

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

Prerequisites

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

Language

• Course: English / Spanish
  

Microsoft Applied Skills - Applied Skills

This course is part of the Microsoft Applied Skills Credentials.

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

Applied Skills: Explore all credentials in one guide