Prices shown in US dollars.
Find my training Basket 0
Microsoft

Develop data-driven applications with Azure SQL Database

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. Virtual Learning This interactive training can be taken from any location, your office or home and is delivered by a trainer. This training does not have any delegates in the class with the instructor, since all delegates are virtually connected. Virtual delegates do not travel to this course, Global Knowledge will send you all the information needed before the start of the course and you can test the logins.

GK #M-DP3020Company EventPublic ClassroomVirtual Learning
Duration1 dayFormatsCompany Event · Public Classroom · Virtual LearningTopicsArtificial Intelligence

What you’ll learn

Course Content

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

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

Upcoming training

Dates and availability are confirmed by Bolt when we follow up. All times are shown in the provider’s stated time zone.

2027-03-08 — 2027-03-088:30 AM to 4:30 PM
Virtual LearningVirtual (Eastern Standard Time) · English
2027-07-01 — 2027-07-018:30 AM to 4:30 PM
Virtual LearningVirtual (Eastern Standard Time) · English
2027-10-27 — 2027-10-278:30 AM to 4:30 PM
Virtual LearningVirtual (Eastern Standard Time) · English