________________________________________________________________
Do you want to take this course remotely or in person?
Contact us by email: info@nanforiberica.com , phone: +34 91 031 66 78, WhatsApp: +34 685 60 05 91 , or contact Our Offices
________________________________________________________________
Course DP-3020: Develop data-driven applications by using Microsoft Azure SQL Database
In this course, students will learn how to develop data-driven applications using Microsoft Azure SQL Database.
You will 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 will explore how to use the Data API Generator for Azure SQL Database and develop a data API with Azure Web Apps and Static Web App.
Additionally, you will gain skills in importing data through an external REST endpoint, exporting data using an Azure Function , and securing an Azure SQL database. These essential skills will enable you to effectively develop and manage applications using Azure SQL Database.
Intermediate - Developer - Azure SQL Database - Application Development, Back-End Development, Cloud Computing
DP-3020 Course Content
Module 1: Get started with Azure SQL Database for modern application development
- Introduction
- Explain implementation options
- Exploring Hyperscale Capabilities
- Understanding the level of serverless computing
- Enable application resilience with Azure SQL Database
- Understand AI capabilities for Azure SQL Database
- Exercise: Enable application resilience with Azure SQL Database
Module 2: Developing for Azure SQL Database
- Introduction
- Create and configure an Azure SQL databaseUsing SQL database projects
- Create and deploy database projects to GitHub Actions and Azure DevOps
- Protect and monitor continuous integration and continuous deployment (CI/CD)
- Exercise: Configure and deploy CI/CD pipelines for Azure SQL Database projects
Module 3: Develop a data API for Azure SQL Database
- Introduction
- Explore the 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 4: Explore data manipulation options in Azure SQL Database
- Introduction
- Use RESTful endpoints to import data into Azure SQL Database
- Manipulate data in Azure SQL Database with Azure Functions
- Understand the data movement tools available
- Exercise: Develop a data API for Azure SQL Database
Module 5: Explore security practices for Azure SQL Database
- Introduction
- Explore authentication methods
- Configure managed identity
- Understanding firewall rules
- Explore advanced data security
- Exercise: Set up a managed identity for Azure SQL Database
Prerequisites
- Experience with relational databases.
- Basic knowledge of security concepts such as identities and permissions.
- Experience using the Azure portal to create resources and set permissions.
Language
- Course: English / Spanish
Microsoft Applied Skills - Applied Skills
This course is part of the Microsoft Applied Skills Credentials.
Earn this Microsoft Applied Skills credential. In this course, you will learn how to develop data-driven applications using Microsoft Azure SQL Database.
Applied Skills: Explore all credentials in one guide
