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

 

Course Overview

Learn how to develop data-driven applications by using Microsoft Azure SQL Database. DP-3020

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.

Course Content

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
  • Module assessment
  • Summary

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
  • Module assessment
  • Summary

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
  • Module assessment
  • Summary

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: Import and export data for development in Azure SQL Database
  • Module assessment
  • Summary

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
  • Module assessment
  • Summary

Prices & Delivery methods

Online Training

Duration
1 day

Price
  • 690.— € (excl. tax)
    821.10 € (incl. 19% tax)
Dates and Booking
Request a date
Classroom Training

Duration
1 day

Price
  • Germany:
    690.— € (excl. tax)
    821.10 € (incl. 19% tax)
  • Switzerland:
    CHF 870.— (excl. tax)
    CHF 940.47 (incl. 8.1% tax)
incl. catering
Dates and Booking
Request a date

Schedule

Instructor-led Online Training:   Course conducted online in a virtual classroom.
FLEX Classroom Training (hybrid course):   Course participation either on-site in the classroom or online from the workplace or from home.

English

European Time Zones

Online Training Course language: English

6 hours difference to Central European Summer Time (CEST)

Online Training Time zone: Eastern Daylight Time (EDT) Course language: English
Online Training Time zone: Eastern Daylight Time (EDT) Course language: English

7 hours difference to Central European Summer Time (CEST)

Online Training Time zone: Central Daylight Time (CDT) Course language: English
Online Training Time zone: Central Daylight Time (CDT) Course language: English
Online Training Time zone: Central Standard Time (CST) Course language: English
Online Training Time zone: Central Standard Time (CST) Course language: English

9 hours difference to Central European Summer Time (CEST)

Online Training Time zone: Pacific Daylight Time (PDT) Course language: English
Online Training Time zone: Pacific Daylight Time (PDT) Course language: English
Online Training Time zone: Pacific Standard Time (PST) Course language: English
Online Training Time zone: Pacific Standard Time (PST) Course language: English
FLEX Classroom Training (hybrid course):   Course participation either on-site in the classroom or online from the workplace or from home.

Germany

Frankfurt
Hamburg

If you can't find a suitable date, don't forget to check our world-wide FLEX training schedule.