Take advantage of spring savings with up to 50% off ILT training.

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

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.

GK# 834086 Vendor# DP-3020

Vendor Credits:

Global Knowledge Delivered Course
Training Exclusives

Live Instructor

Live Instructor

Experience live expert-led training in person, from your home, office or anywhere with an internet connection.
Group Training

Group Training

Live expert-led training for your team or entire organization that can be customized to fit your exact needs.

Virtual Classroom Live

No matching courses available.

Start learning as soon as today! Click Add To Cart to continue shopping or Buy Now to check out immediately.

Access Period:

Scheduling a custom training event for your team is fast and easy! Click here to get started.

$

Your Selections:

Location:

Access Period:

No available dates

Add To Cart

BUY NOW

Request a quote

Course Outline

Module 1: 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
Knowledge check
Summary

Module 2: 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
Knowledge check
Summary

Module 3: 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
Knowledge check
Summary

Module 4: 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: Develop a Data API for Azure SQL Database
Knowledge check
Summary

Module 5: 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
Knowledge check
Summary

BUY NOW

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.