Develop data-driven applications by using Azure SQL Database

Intermediate
Developer
Solution Architect
Azure SQL Database
Azure

This learning path prepares you for the task of developing data-driven applications by using Microsoft Azure SQL Database.

You'll learn how to create and configure an Azure SQL Database, build and deploy database projects using GitHub Actions and Azure Pipelines, and automate the publishing process. Additionally, you'll explore how to use Data API builder for Azure SQL Database and develop a data API with Azure Web Apps and Static Web App.

Furthermore, you'll gain skills in importing data via an external REST endpoint, exporting data using an Azure Function, and securing an Azure SQL Database. These essential skills will empower you to effectively develop and manage applications using Azure SQL Database.

Note

You need an Azure subscription to complete the exercises. If you don't have an Azure subscription, create a free account and add a subscription before you begin. If you're a student, you can take advantage of the Azure for students offer.

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.

Modules in this learning path

You'll explore different features and tools to help you develop in Azure SQL Database.

You'll learn different methods to develop and automate Azure SQL Database publishing for development purposes.

We'll explore the use of Azure's Data API Builder, a powerful tool that simplifies the creation of REST and GraphQL endpoints for your Azure SQL Database. With features like automatic query generation, granular security controls, and seamless integration with other Azure services, the Data API Builder can transform your database into a versatile API with minimal effort.

Azure SQL Database allows you to import data using RESTful endpoints. This capability integrates Azure SQL Database with various external services and APIs, making it a versatile and user-friendly platform. Also, by combining Azure Functions with Azure SQL Database, you can create seamless workflows that automate data processing and enhance the functionality of your applications.

You'll explore different features and tools to help you secure an Azure SQL Database.