- 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 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.
- Learn the essentials of Azure SQL Database deployment and migration. Explore its benefits, exclusive features, and migration options while optimizing performance and application connections for a smooth transition to the cloud.
In this module, you'll:
Explore the advantages, capabilities, and migration possibilities offered by Azure SQL Database.
Migrate databases using Azure SQL Migration extension for Azure Data Studio and tracking database migration activities.
Use transactional replication as an online method to migrate to Azure SQL Database.
Explore several other methods for migrating SQL Server databases to Azure SQL Database.
- 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.
AI Engineer - Learn how to integrate AI into software applications
35% Off Finance Skills That Get You Hired - Code CFI35
Overview
Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Syllabus
- 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 SQL Server workloads to Azure SQL Database
- Introduction
- Choose the right Azure SQL Database feature
- Use Azure SQL migration extension to migrate to Azure SQL Database
- Migrate to Azure SQL Database using BACPAC
- Use an online method to migrate to Azure SQL Database
- Move data to Azure SQL Database
- Exercise - Migrate a SQL Server database to Azure SQL Database
- Module assessment
- 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
- Module assessment
- Summary