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

Discover 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, solutions architects, and IT professionals who want to create optimized, secure, and scalable applications using Azure SQL Database. It's ideal for those with a basic understanding of relational databases who want to enhance their skills in modern development environments.

Objectives of the DP-3020 training

• Configure and manage Azure SQL Database.
  
• Automation of development and implementation.
  
• 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 the Azure SQL Database against unauthorized access and threats.

Course content DP-3020

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

• Introduction
• Explain the implementation options
  
• Explore hyperscale capabilities
  
• Understand the level of serverless computing
• Enable application resilience with Azure SQL Database
• Understand the AI ​​capabilities for Azure SQL Database
• Exercise: Enable application resilience with Azure SQL Database
  

Module 2: Developing for the Azure SQL Database

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

Module 3: Develop a data API for Azure SQL Database

• Introduction
• Explore the data API generator for the 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 the Azure SQL database

Module 4: Exploring data manipulation options in Azure SQL Database

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

Module 5: Exploring Security Practices for Azure SQL Database

• Introduction
• Explore authentication methods
• Configure 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 will learn to develop data-driven applications using Microsoft Azure SQL Database.

Applied Skills: Explore all credentials in one guide