Overview
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.
Why Choose KORNERSTONE
- Accredited, practitioner-led, expert certificate trainers to provide high quality training
- Official training material included
- Practical, scenario-based learning – focus on application, not just theory
- Excellent Passing Rate
Skills Covered
- Get started with Azure SQL Database for modern application development
- Develop for Azure SQL Database
- Develop a data API for Azure SQL Database
- Explore data manipulation options in Azure SQL Database
- Explore security practices for Azure SQL Database
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 Curriculum
Module 1: Get started with Azure SQL Database for modern application development
You’ll explore different features and tools to help you develop in Azure SQL Database.
Learning objectives
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.
Prerequisites
- Ability to navigate the Azure portal.
- Experience with T-SQL programming language at a basic level.
Module 2: Develop for Azure SQL Database
You’ll learn different methods to develop and automate Azure SQL Database publishing for development purposes.
Learning objectives
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.
Prerequisites
- Ability to navigate the Azure portal.
- Experience with T-SQL programming language at a basic level.
Module 3: Develop a data API for Azure SQL Database
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.
Learning objectives
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.
Prerequisites
- Experience using the Azure portal to create resources.
- Experience with T-SQL programming language at a basic level.
Module 4: Explore data manipulation options in Azure SQL Database
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.
Learning objectives
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
Prerequisites
- Experience using the Azure portal to create resources.
- Experience with T-SQL programming language at a basic level.
Module 5: Explore security practices for Azure SQL Database
You’ll explore different features and tools to help you secure an Azure SQL Database.
Learning objectives
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.
Prerequisites
- Ability to navigate the Azure portal.
- Experience with T-SQL programming language at a basic level.
Dates & Locations
Exam & Certification
To earn this Microsoft Applied Skills credential, learners demonstrate the ability to develop data-driven applications by using Microsoft Azure SQL Database.
Candidates for this top Microsoft Applied Skills credential should have experience developing data-driven applications. They should also be familiar with the Azure ecosystem and the components involved in developing applications that include Azure SQL Database. Candidates need a basic understanding of Git-based source control, in addition to how REST APIs interact with Azure SQL Database for data operations.
Tasks performed
- Develop an Azure SQL Database
- Develop a data API
- Enable a read-only Azure SQL Database
- Import data by using an external REST endpoint
- Export data by using an Azure Function
- Secure an Azure SQL Database
