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
  • £ 940.—
Book now
Enquire a date
Classroom Training

Duration
1 day

Price
  • United Kingdom: £ 940.—

Schedule

Instructor-led Online Training:   This computer icon in the schedule indicates that this date/time will be conducted as Instructor-Led Online Training. If you have any questions about our online courses, feel free to contact us via phone or Email anytime.
This is a FLEX course, which is delivered both virtually and in the classroom. Please note, local pricing is applicable.

English

European Time Zones

Online Training Course language: English

5 hours difference to British Summer Time (BST)

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

6 hours difference to British Summer Time (BST)

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

8 hours difference to British Summer Time (BST)

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
This is a FLEX course, which is delivered both virtually and in the classroom. Please note, local pricing is applicable.

Europe

Germany

 Frankfurt This is a FLEX course.   Book now:
Book online training
Book classroom training
Hamburg This is a FLEX course.   Book now:
Book online training
Book classroom training

Poland

 Warsaw This is a FLEX course.   Book now:
Book online training
Book classroom training
Warsaw This is a FLEX course.   Book now:
Book online training
Book classroom training

Ukraine

 Kiev This is a FLEX course.   Course language: Ukrainian Book now:
Book online training
Book classroom training
Kiev This is a FLEX course.   Course language: Ukrainian Book now:
Book online training
Book classroom training

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