Training: Develop data-driven applications by using Azure SQL Database (DP-3020)

Ref. DP-3020

Download PDF

Duration:

1

day

Exam:

Not certifying

Level:

Intermediate

Funding:

Eligible

Home > Trainings > IT Pro > Cloud Computing > Develop data-driven applications by using Azure SQL Database (DP-3020)

Develop data-driven applications by using Azure SQL Database (DP-3020)

Create and configure an Azure SQL Database

This DP-3020 course trains you in developing data-driven applications with Azure SQL Database. You will learn to configure a database, automate deployment, and create data APIs integrated into your applications. This program also teaches you how to import data via REST endpoints and export data using Azure Functions. You will discover how to secure your databases and ensure their resilience for high-performance and reliable applications.

Tools like GitHub Actions and Azure Pipelines will be used to simplify continuous deployment. Azure’s data API builder will be used to create REST and GraphQL APIs. This training will provide you with essential skills to develop modern applications and optimize data management.

Automate development and deployment

You will use GitHub Actions and Azure DevOps to automate deployment and ensure continuous integration (CI/CD). This course is designed for professionals seeking to master data-driven application development with Azure, combining performance, security, and automation.

Participant Profiles

<ul>
<li>Solution architects</li>
<li>Application developers</li>
<li>Database administrators</li>
<li>DevOps engineers</li>
<li>IT project managers</li>
</ul>

Objectives

Create and configure an Azure SQL Database
Leverage Hyperscale and serverless features
Automate deployment with GitHub Actions and Azure DevOps
Secure continuous integration (CI/CD)
Develop a data API with Azure Web Apps
Import and export data via REST endpoints
Ensure application security and resilience

Prerequisites

Experience with relational databases
Knowledge of security concepts: identities and permissions
Using the Azure Portal to create resources

Course Content

Module 1: Get started with Azure SQL Database for modern application development

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

Module 2: Develop for Azure SQL Database

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)

Module 3: Develop a data API for Azure SQL Database

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

Module 4: Explore data manipulation options in Azure SQL Database

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

Module 5: Explore security practices for Azure SQL Database

Explore authentication methods
Configure managed identity
Understand firewall rules
Explore advanced data security

Documentation

Access to Microsoft Learn, Microsoft’s online learning platform, offering interactive resources and educational content to deepen your knowledge and develop your technical skills.

Lab / Exercises

This course provides you with exclusive access to the official Microsoft lab, enabling you to practice your skills in a professional environment.

Complementary Courses

Eligible Funding

ITTA is a partner of a continuing education fund dedicated to temporary workers. This fund can subsidize your training, provided that you are subject to the “Service Provision” collective labor agreement (CCT) and meet certain conditions, including having worked at least 88 hours in the past 12 months.

Additional Information

Develop high-performance applications with Azure SQL Database

Modern application development increasingly relies on data-driven systems. Azure SQL Database offers a reliable and scalable cloud platform, ideal for creating secure and high-performance applications. Through this training, you will learn to fully leverage this solution by mastering advanced features and automation tools.

Optimized data management for greater flexibility

One of the major advantages of Azure SQL Database lies in its ability to adapt to the needs of each project. Whether using the Hyperscale option for massive data volumes or the serverless mode to optimize costs, this platform offers unmatched flexibility. You will discover how to configure and manage these features to ensure optimal performance.

Automate deployment for increased efficiency

Automation plays a key role in modern application development. This training teaches you how to use GitHub Actions and Azure DevOps to automate the deployment of your databases. By creating CI/CD pipelines, you reduce human errors and accelerate production while ensuring the consistency of your projects.

Create data APIs to connect your applications

With Azure’s Data API Builder, it becomes easy to transform your database into a REST or GraphQL API. This approach simplifies data integration into your applications while ensuring granular security controls. You will learn to develop APIs with Azure Web Apps and Azure Static Web Apps, ensuring smooth communication between your applications and your database.

Import and export data with ease

Managing data flows is essential to ensure the proper functioning of your applications. Azure SQL Database allows you to import data via RESTful endpoints, facilitating integration with external services and APIs. Using Azure Functions to export data offers an efficient solution to automate these processes, reducing manual tasks and the risk of errors.

Secure your data to ensure compliance

Data security is a top priority for any organization. This training teaches you how to configure different authentication methods and set up managed identities to secure access to your database. You will also learn to manage firewall rules and use the Advanced Data Security solution to protect your data from internal and external threats.

Practical training for immediately applicable skills

This learning path emphasizes a hands-on approach, with exercises and real-world scenarios. Each module offers concrete scenarios to help you master the skills needed for developing applications based on Azure SQL Database. By the end of the training, you will be able to create high-performance databases, develop data APIs, and automate the deployment of your projects.

FAQ

What are the main benefits of Azure SQL Database?

Azure SQL Database offers a scalable, secure, and flexible cloud platform, ideal for modern application development. Its advanced features, such as Hyperscale and serverless mode, help optimize performance and costs.

Is this training suitable for beginners?

No, this training is intended for professionals with prior experience with relational databases and basic knowledge of the Azure portal. It aims to deepen your skills and familiarize you with automation and development tools.

What tools will I learn to use?

You will learn to use GitHub Actions, Azure DevOps, Azure’s Data API Builder, as well as Azure Web Apps and Azure Static Web Apps to develop data APIs.

Does this training include practical exercises?

Yes, each module offers practical exercises that allow you to apply the skills acquired and develop concrete solutions based on Azure SQL Database.

How will this training help me in my career?

By mastering data-driven application development with Azure SQL Database, you will increase your employability and be able to contribute effectively to digital transformation projects within your organization.