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

This course is dedicated to developers and solution architects who want to build data-driven applications using Microsoft Azure SQL DatabaseParticipants will learn how to create and configure SQL databases in Azure, automate publishing processes using GitHub Actions, and Azure Pipelineand develop API applications using Data API Builder, Azure Web Apps and Static Web Apps.

The course also provides a practical look at data import/export methods via REST APIs and Azure Functions, as well as on database security best practices.

Who is it for?

The course is recommended for:
• Developers who build applications based on relational databases in Azure
• Solution architects who design scalable and secure applications in cloud
• Professionals who want to automate development and publishing processes in Azure
• Teams developing API applications using Azure SQL and related services

What will you learn?

After completing the course, you will know how to:
• Create and configure Azure SQL Database for modern applications
• Automate build and deployment processes using GitHub Actions and Azure Pipelines
• Use Data API Builder to create REST and GraphQL APIs
• Import data from external sources using REST endpoints
• Export data using Azure Functions
• Apply security measures to protect Azure SQL Database

Prerequisites:

Participants should have:
• Experience working with relational databases
• Basic knowledge of security concepts (identities, permissions)
• Experience in using the portal Azure for creating and configuring resources

Course schedule:

Course materials are in English. Teaching is done in Romanian.

  1. Introduction to Azure SQL Database for modern development
    • Features and benefits
    • Tools for development and management
  2. Development for Azure SQL Database
    • Automate the publishing process
    • Using GitHub Actions and Azure Pipelines
  3. Creating an API for Azure SQL Database
    • Using Data API Builder
    • Creating REST and GraphQL endpoints
  4. Importing and exporting data
    • Import from external sources via REST API
    • Export using Azure Functions
  5. Securing a database Azure SQL
    • Access control and permissions
    • Security practices for data protection

We recommend continuing with:

Certification programs

There are no certification programs at this time.

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

Personalized offers for groups of at least 2 people

Course details

1
days

Price:

On demand

Delivery:

Classroom Teaching, Hybrid Classroom, Virtual Classroom

Level:

3. Intermediate

Roles:

Developer, Solutions Architect