Microsoft Azure Relational Databases

提供方
Microsoft
在此指導項目中,您將:

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
Beginner初級
Cloud無需下載
Video分屏視頻
Comment Dots英語(English)
Laptop僅限桌面

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

您要培養的技能

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

分步進行學習

在與您的工作區一起在分屏中播放的視頻中,您的授課教師將指導您完成每個步驟:

  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

指導項目工作原理

您的工作空間就是瀏覽器中的雲桌面,無需下載

在分屏視頻中,您的授課教師會為您提供分步指導

常見問題

常見問題

還有其他問題嗎?請訪問 學生幫助中心