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
  • on request
Dates and Booking
Request a date
Classroom Training

Duration
1 day

Price
  • on request

Schedule

English

2 hours difference

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

7 hours difference

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

8 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

10 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 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. All FLEX courses are also Instructor-led Online Trainings (ILO).

Middle East

Saudi Arabia

Riyadh Course language: English
Riyadh Course language: English

United Arab Emirates

Dubai Course language: English
Dubai Course language: English
This is a FLEX course, which is delivered both virtually and in the classroom. All FLEX courses are also Instructor-led Online Trainings (ILO).