Set up a lab to teach database management for relational databases

Note

This article references features available since the August 2022 Update, when lab plans replaced lab accounts. For more information, see What's New in the August 2022 Update.

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: