Set up a lab to teach database management for relational databases
Note
This article references features available in lab plans, which replaced lab accounts.
This article describes how to set up a lab for a basic database management class in Azure Lab Services. Database concepts are one of the introductory courses taught in most of the Computer Science departments in college. Structured Query Language (SQL) is an international standard. SQL is the standard language for relation database management including adding, accessing, and managing content in a database. It's most noted for its quick processing, proven reliability, ease, and flexibility of use.
In this article, you learn how to set up a virtual machine template in a lab with both MySQL Database Server and SQL Server 2019 server. MySQL is a freely available open source Relational Database Management System (RDBMS). SQL Server 2019 is the latest version of Microsoft’s RDBMS.
Lab configuration
To set up this lab, you need an Azure subscription and lab account. If you don't have an Azure subscription, create a free account before you begin.
When you get an Azure subscription, you can create a new lab plan in Azure Lab Services. For more information about creating a new lab plan, see the tutorial on how to set up a lab plan. You can also use an existing lab plan.
Lab plan settings
Enable the settings described in the table below for the lab plan. For more information about enabling marketplace images, see Specify Marketplace images available to lab creators.
| Lab plan setting | Instructions |
|---|---|
| Marketplace image | Enable the ‘SQL Server 2019 Standard on Windows Server 2019’ image. |
Lab settings
Use the settings in the table below when setting up a lab. For more information about creating a lab, see set up a lab tutorial.
| Lab settings | Value/instructions |
|---|---|
| Virtual Machine Size | Medium. This size is best suited for relational databases, in-memory caching, and analytics. |
| Virtual Machine Image | SQL Server 2019 Standard on Windows Server 2019 |
Template machine configuration
To install MySQL on Windows Server 2019, you can follow the steps mentioned in Install and Run MySQL Community Server on a Virtual Machine.
SQL Server 2019 is pre-installed in the virtual machine image we selected when creating the new lab.
Cost estimate
Let's cover a possible cost estimate for this class. We'll use a class of 25 students. There are 20 hours of scheduled class time. Also, each student gets 10 hours quota for homework or assignments outside scheduled class time. The virtual machine size we chose was medium, which is 42 lab units.
Following is an example of a possible cost estimate for this class:
25 students * (20 scheduled hours + 10 quota hours) * 0.42 USD per hour = 315.00 USD
Important
Cost estimate is for example purposes only. For current details on pricing, see Azure Lab Services Pricing.
Conclusion
This article walked you through the steps necessary to create a lab for basic database management concepts using both MySQL and SQL Server. You can use a similar setup for other databases classes.
Next steps
The template image can now be published to the lab. For more information, see Publish the template VM.
As you set up your lab, see the following articles:
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for