Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Work with relational data in Azure

Microsoft via Microsoft Learn

Go to class Write review

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

Grab it

Module 1: Find out what makes Azure SQL Database a good choice for your relational database, how to create the database from the portal and connect with Azure Cloud Shell.

In this module, you will learn:

Why Azure SQL Database is a good choice for running your relational database
What configuration and pricing options are available for your Azure SQL database
How to create an Azure SQL database from the portal
How to use Azure Cloud Shell to connect to your Azure SQL database, add a table, and work with data

Module 2: Plan and implement the migration of relational data from SQL Server to Azure SQL Database. Select the appropriate migration strategy for your database, and then use Data Migration Assistant to do the assessment and the migration.

In this module, you will:

Select a migration strategy for your relational data stored in SQL Server
Perform a migration from SQL Server to a single Azure SQL database by using the process of migration with downtime

Module 3: This module is a no-code introduction to PostgreSQL on Azure, including an explanation of particular problems that using Azure Database for PostgreSQL can solve. At a high level, we show how the components fit together and identify situations where you should use Azure Database for PostgreSQL.

In this module, you will:

Describe the components of Azure Database for PostgreSQL.
Identify situations when to use Azure Database for PostgreSQL.

Module 4: Learn how to create SQL elastic pools and how to use them to manage performance and cost for a collection of SQL databases.

In this module, you will:

Create an elastic pool
Add databases to an elastic pool
Configure database performance in an elastic pool

Module 5: Secure an Azure SQL database to keep the information safe and diagnose potential security concerns as they happen.

In this module, you will:

Control network access to your Azure SQL Database using firewall rules
Control user access to your Azure SQL Database using authentication and authorization
Protect your data in transit and at rest
Audit and monitor your Azure SQL Database for access violations

Module 6: Create an Azure SQL database to store data for an application, and create an ASP.NET application to query data from the database.

In this module, you will:

Create, configure, and populate a single database in SQL Database
Configure an ASP.NET application to query the database

Syllabus

Module 1: 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

Module 2: 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

Module 3: 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

Module 4: 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

Module 5: 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

Module 6: 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

Tags

united states

Reviews

Start your review of Work with relational data in Azure