title
Please take a moment to fill out this form. We will get back to you as soon as possible.
All fields marked with an asterisk (*) are mandatory.
Develop data-driven applications by using Azure SQL Database
Duration
1 Day
Course
MOC-DP-3020
Available Formats
Classroom Training, Online Training
Course Description
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.
Objectives
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.
Topics
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
- Knowledge check
- Summary
- 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
- Knowledge check
- Summary
- 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
- Knowledge check
- Summary
- 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: Develop a Data API for Azure SQL Database
- Knowledge check
- Summary
- Introduction
- Explore authentication methods
- Configure managed identity
- Understand firewall rules
- Explore advanced data security
- Exercise: Configure managed identity for Azure SQL Database
- Knowledge check
- Summary
Related Courses
-
Microsoft Azure Security Technologies
MOC-AZ-500T00- Duration: 4 Days
- Delivery Format: Classroom Training, Online Training
- Price: 2,380.00 USD
-
Microsoft Azure Fundamentals (1 Day)
MOC-AZ-900T00- Duration: 1 Day
- Delivery Format: Classroom Training, Online Training
- Price: 595.00 USD
Self-Paced Training Info
Learn at your own pace with anytime, anywhere training
- Same in-demand topics as instructor-led public and private classes.
- Standalone learning or supplemental reinforcement.
- e-Learning content varies by course and technology.
- View the Self-Paced version of this outline and what is included in the SPVC course.
- Learn more about e-Learning
Course Added To Shopping Cart
bla
bla
bla
bla
bla
bla
Self-Paced Training Terms & Conditions
??spvc-wbt-warning??
Exam Terms & Conditions
??exam-warning??
??group-training-form-area??
??how-can-we-help-you-area??
??personalized-form-area??
??request-quote-area??
Sorry, there are no classes that meet your criteria.
Please contact us to schedule a class.
STOP! Before You Leave
Save 0% on this course!
Take advantage of our online-only offer & save 0% on any course !
Promo Code skip0 will be applied to your registration
Nothing yet
Purchase Information
??elearning-coursenumber?? ??coursename??
View Cart
title
Please take a moment to fill out this form. We will get back to you as soon as possible.
All fields marked with an asterisk (*) are mandatory.