Instructor

DP-3020: Develop data-driven applications with Azure SQL Database Training

Curriculum

Ratings

( 4.0 Ratings )

Live Online Classes starting on 01 January, 1970

DP-3020: Develop data-driven applications with Azure SQL Database

The DP-3020 course provides hands-on training in developing data-driven applications with Azure SQL Database, focusing on deployment, resilience, and serverless capabilities. You'll learn how to leverage Hyperscale, build CI/CD pipelines, and create data APIs using Data API Builder. By mastering Azure SQL Database security, monitoring, and AI integration, you’ll be well-prepared to build robust applications for modern cloud environments.

 

Target Audience

  • Azure Developer

  • Database Developer

 

Prerequisites
Required:

  • 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 Objectives

  • Understand deployment options and Hyperscale features in Azure SQL Database.

  • Learn to build resilient, serverless applications with Azure SQL Database.

  • Develop and deploy CI/CD pipelines for database projects in GitHub Actions and Azure DevOps.

  • Create data APIs for Azure SQL Database using Data API Builder and Azure web apps.

  • Implement robust security practices, including managed identities and firewall rules, in Azure SQL Database.

 

Course Outline

1) Get started with Azure SQL Database for modern application development

  • Explain the deployment options available

  • Explore Hyperscale capabilities

  • Understand how serverless works

  • Explain application resilience options for Azure SQL Database

  • Understand AI capabilities for Azure SQL Database

  • Lab: Enable application resilience with Azure SQL Database

2) Develop for Azure SQL Database

  • Create and configure an Azure SQL Database

  • Use SQL Database projects

  • Build and deploy database projects in GitHub Actions and Azure DevOps

  • Understand how to secure and monitor your Continuous Integration and Continuous Deployment (CI/CD) process

  • Lab: Configure and deploy CI/CD pipelines for Azure SQL Database projects

3) Develop a data API for Azure SQL Database

  • Use Data API Builder to create a data API for Azure SQL Database

  • Develop a data API using a static Azure web app

  • Develop a data API using Azure Web Apps

  • Lab: Develop a Data API for Azure SQL Database

4) Explore data manipulation options in Azure SQL Database

  • Invoke an external REST endpoint in Azure SQL Database

  • Manipulate data in Azure SQL Database by using Azure Functions

  • Understand additional data movement tools

  • Lab: Develop a Data API for Azure SQL Database

5) Explore security practices for Azure SQL Database

  • Explain the authentication options available

  • Configure managed identity to access Azure SQL Database

  • Understand how firewall rules work

  • Explain advanced data security features

  • Lab: Configure managed identity for Azure SQL Database

(4.0 Ratings)

Download Course Contents

Still unsure?
We're just a click away


Course Outline PDF

SpireTec Unique Features

course-img
1-On-1 Training

Benefit from our 1-On-1 Training for personalized, focused, and effective learning experiences.

course-img
Customized Training

Experience our Customized Training service tailored to meet your specific learning needs and goals

course-img
4 - Hours / Weekend Session

Join our Class featuring 4 - Hours / Weekend Session for in-depth learning and expert training.

course-img
Free Demo Class

Join our Free Demo Class to experience top-notch training and expert guidance first hand!

Purchase This Course

Request More Information

CERTIFICATE

Get Ahead With SpireTec Solutions
Training Certificate

Earn your Certificate

Our course is exhaustive and this certificate is proof that you have taken a big leap in mastering the domain.

Differentiate yourself with Masters Certificate

Our course is exhaustive and this certificate is proof that you have taken a big leap in mastering the domain.

Share your achievement

Our course is exhaustive and this certificate is proof that you have taken a big leap in mastering the domain.

Need Customized Curriculum?

Our course is exhaustive and this certificate is proof that you have taken a big leap in mastering the domain.

Talk To Adviser
course-certificate

Top Certifications