Work with relational data in Azure
- Offered byMicrosoft
Work with relational data in Azure at Microsoft Overview
Duration | 5 hours |
Start from | Start Now |
Total fee | Free |
Mode of learning | Online |
Schedule type | Self paced |
Difficulty level | Intermediate |
Official Website | Explore Free Course |
Credential | Certificate |
Work with relational data in Azure at Microsoft Course details
- Provision an Azure SQL database to store application data
- Migrate your relational data stored in SQL Server to Azure SQL Database
- Introduction to Azure Database for PostgreSQL
- Scale multiple Azure SQL Databases with SQL elastic pools
- Secure your Azure SQL Database
- Develop and configure an ASP.NET application that queries an Azure SQL database
- Azure supports several popular SQL-based database solutions including SQL Server, PostgreSQL, and MySQL
- Learn how to use these enterprise data solutions in Azure to store and retrieve your app's data in the cloud
- This learning path can help you prepare for the Microsoft Certified: Azure Developer Associate certification
- This learning path helps prepare you for Exam AZ-203: Developing Solutions for Microsoft Azure
- Use the Azure Portal and Cloud Shell to provision, connect, and manage Azure SQL databases
Work with relational data in Azure at Microsoft Curriculum
Provision an Azure SQL database to store application data
Introduction
Plan your Azure SQL database
Exercise - Create your Azure SQL database
Exercise - Connect to your database and add sample data
Summary and cleanup
Migrate your relational data stored in SQL Server to Azure SQL Database
Introduction
Exercise - Environment setup
Migration process overview
Exercise - Assess a database by using Data Migration Assistant
Migration with downtime
Exercise - Migrate a database schema by using Data Migration Assistant
Exercise - Migrate a database with downtime by using Azure Database Migration Service
Summary
Introduction to Azure Database for PostgreSQL
Introduction
What is Azure Database for PostgreSQL?
What is Hyperscale?
How Azure Database for PostgreSQL works
When to use Azure Database for PostgreSQL
Knowledge check
Summary
Scale multiple Azure SQL Databases with SQL elastic pools
Introduction
Create a SQL elastic pool
Exercise - Create a SQL elastic pool
Manage SQL elastic pools performance and cost
Exercise - Manage SQL elastic pools
Knowledge Check
Summary
Secure your Azure SQL Database
Introduction
Exercise - Set up sandbox environment
Exercise - Restrict network access
Exercise - Control who can access your database
Exercise - Secure your data in transit, at rest, and on display
Exercise - Monitor your database
Knowledge check
Summary
Develop and configure an ASP.NET application that queries an Azure SQL database
Introduction
Create tables, bulk import, and query data
Exercise - Create tables, bulk import, and query data
Connect an ASP.NET application to Azure SQL Database
Exercise - Connect an ASP.NET application to Azure SQL Database
Summary