Microsoft Azure Relational Databases

Offered By
Microsoft
In this Guided Project, you will:

Create an Azure Database for MYSQL Server using the Azure Portal

Create an Azure MySQL Database by connecting to the cloud service

Add, Modify and Query Data in Azure MySQL database

ClockThis project should take approximately two hours to complete including, Videos, Tasks, and Quiz
BeginnerBeginner
CloudNo download needed
VideoSplit-screen video
Comment DotsEnglish
LaptopDesktop only

In this 2-hour long tutorial, you will learn how to create, and configure a Microsoft Azure Database for MySQL server and database. We will do this by walking through the process of creating a free trial subscription on Azure, logging in and getting familiar with the Azure Portal. We will create a Resource Group in preparation for creating the Azure database and then step through the process of configuring and deploying an Azure Database for MySQL server. From here we will connect securely to the cloud based server and create a new database. We will then populate the database with some sample data, query and update the data using the MySQL command line tool. Once complete we will restore the database to a point in time using the Azure restore database process and finally clean up unused resources keeping costs to a minimum. The skills learned in this guided project provide the foundation to understanding and implementing Azure Relational Databases specifically in relation to MySQL which is a fully managed database offering from Microsoft Azure. Note: This course works best for learners who are based in the North America region. We’re currently working on providing the same experience in other regions. If you enjoy this project, we recommend taking the Microsoft Azure Data Fundamentals DP-900 Exam Prep Specialization: https://www.coursera.org/specializations/microsoft-azure-dp-900-data-fundamentals

Skills you will develop

  • Azure Cloud Shell
  • Cloud Services
  • Azure database for MySQL server
  • MySQL command line utility
  • Azure Relational Databases

Learn step-by-step

In a video that plays in a split-screen with your work area, your instructor will walk you through these steps:

  1. Create a free trial account in Microsoft Azure and log in using the new subscription.

  2. Create a Resource Group in preparation for creating a new Azure Database for MySQL Server

  3. Create, configure aconfigure secure access through the server firewallnd deploy an Azure Database for MySQL Server using the Azure Portal

  4. Configure firewall setting to allow access to the Azure database for MySQL server through the cloud service

  5. Connect and authenticate to the Azure Database for MySQL Server for the first time.

  6. Create a new database on the Azure MySQL server, load sample data and process queries using the MySQL command-line tool.

  7. Update data in the new database

  8. Restore the database to a point in time.

  9. Clean up and Delete unwanted resources to keep costs to a minimum

How Guided Projects work

Your workspace is a cloud desktop right in your browser, no download required

In a split-screen video, your instructor guides you step-by-step

Frequently asked questions

Frequently Asked Questions

More questions? Visit the Learner Help Center.