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

指导项目工作原理

您的工作空间就是浏览器中的云桌面,无需下载

在分屏视频中,您的授课教师会为您提供分步指导

常见问题

常见问题

还有其他问题吗?请访问 学生帮助中心