Microsoft Azure Relational Databases

ofrecido por
Microsoft
En este proyecto guiado, tú:

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
BeginnerPrincipiante
CloudNo se necesita descarga
VideoVideo de pantalla dividida
Comment DotsInglés (English)
LaptopSolo escritorio

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

Habilidades que desarrollarás

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

Aprende paso a paso

En un video que se reproduce en una pantalla dividida con tu área de trabajo, tu instructor te guiará en cada paso:

  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

Cómo funcionan los proyectos guiados

Tu espacio de trabajo es un escritorio virtual directamente en tu navegador, no requiere descarga.

En un video de pantalla dividida, tu instructor te guía paso a paso

Preguntas Frecuentes

Preguntas Frecuentes

¿Tienes más preguntas? Visita el Centro de Ayuda al Alumno.