Data, Analytics & AI Category Banner Image

Microsoft DP-3020 - Develop Data-Driven Applications with Azure SQL Database

Length 1 day

Course overview

View dates &
book now

Why study this course

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.

This one-day course prepares you for an Applied Skills credential.
For more than 30 years, Microsoft's industry-recognised certifications have provided proof of world-class technical proficiency for in-demand job roles. In today’s ever-changing business environment, there are also times when you need verified project-specific skills. Microsoft Applied Skills is a new verifiable credential that validates that you have the targeted skills needed to implement critical projects aligned to business goals and objectives. Applied Skills gives you a new opportunity to put your skills centre-stage, empowering you to showcase what you can do and what you can bring to key projects in your organisation.

Please note: This course is due to be released by Microsoft on December 13, 2024.

Request Course Information

What you’ll learn

After completing this course, students will 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
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
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
Invoke an external REST endpoint in Azure SQL Database
Manipulate data in Azure SQL Database by using Azure Functions
Understand additional data movement tools
Explain the authentication options available
Configure managed identity to access Azure SQL Database
Understand how firewall rules work
Explain advanced data security features

Microsoft Azure at Lumify Work

Lumify Work has been delivering effective training across all Microsoft products for over 30 years. We are proud to be both Australia's and New Zealand’s first Microsoft Gold Learning Solutions Partner and the winner of the Microsoft MCT Superstars Award for FY24, which formally recognises us as having the highest quality Microsoft Certified Trainers (MCTs) in ANZ. All Lumify Work Microsoft Azure courses follow Microsoft Official Curriculum (MOC) and are led by MCTs.

View all Microsoft Azure at Lumify Work courses

Who is the course for?

Developers
Solution Architects

Course subjects

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

Terms & Conditions

The supply of this course by Lumify Work is governed by the booking terms and conditions. Please read the terms and conditions carefully before enrolling in this course, as enrolment in the course is conditional on acceptance of these terms and conditions.