Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Microsoft

Develop data-driven applications by using Azure SQL Database

Microsoft via Microsoft Learn

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
  • Learn how Azure SQL Database works, the key concepts, and practical examples to help developers effectively utilize Azure SQL Database in their cloud-based applications.

    By the end of this module, you'll be able to:

    • 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.
  • Learn how to create and configure an Azure SQL Database. You'll use SQL Database Projects in VS Code, including installing the extension, importing, and modifying a schema. Additionally, you'll build and deploy database projects in GitHub Actions and Azure Pipelines, and automate and invoke the publishing of a database.

    By the end of this module, you'll be able to:

    • 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.
  • Learn how to create modern REST data API for Azure SQL Database. We'll delve into Data API Builder, a powerful cross-platform that simplifies the creation of 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 effortlessly transform your database into a versatile API.

    By the end of this module, you'll be able to:

    • 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.
  • Learn how to invoke REST endpoints in Azure SQL Database and manipulate data using Azure Functions. Also, explore various tools and options for importing and exporting data to and from Azure SQL Database.

    By the end of this module, you'll be able to:

    • Invoke an external REST endpoint in Azure SQL Database
    • Manipulate data in Azure SQL Database by using Azure Functions
    • Understand additional data movement tools
  • Learn how security works in Azure SQL Database, the key concepts, and practical examples to help developers effectively utilize Azure SQL Database in their cloud-based applications.

    By the end of this module, you'll be able to:

    • Explain the authentication options available.
    • Configure managed identity to access Azure SQL Database.
    • Understand how firewall rules work.
    • Explain advanced data security features.

Syllabus

  • 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

Reviews

Start your review of Develop data-driven applications by using Azure SQL Database

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.