Develop data-driven applications by using 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,– €
Plats & Datum
Enquire a date
Classroom training

Duration
1 day

Price
  • Sverige: 690,– €

Schedule

English

Time zone: Central European Summer Time (CEST)   ±1 hour

Online training Time zone: Greenwich Mean Time (GMT) Course language: English

6 hours difference

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

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

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
Instructor-led Online Training:   This is an Instructor-Led Online course. If you have any questions about our online courses, feel free to contact us via phone or Email anytime.

Middle East

Saudi Arabia

Riyadh Course language: English
Riyadh Course language: English

United Arab Emirates

Dubai Course language: English
Dubai Course language: English