Biology Course Alumni Search

Introduction

In this project, you will learn how to search for students who have taken courses offered by a specific department, in this case, the Biology department. This is a common task that teachers often need to perform when calculating student grades.

👀 Preview

MySQL [edusys]> SOURCE /home/labex/project/multiTableQuery.sql
+-------+--------+-----------+-------+
| ID    | name   | course_id | grade |
+-------+--------+-----------+-------+
| 98988 | Tanaka | BIO-101   | A     |
| 98988 | Tanaka | BIO-301   | NULL  |
+-------+--------+-----------+-------+
2 rows in set (0.002 sec)

🎯 Tasks

In this project, you will learn:

• How to start and access the MySQL database using the sudo command
• How to import a SQL file (edusys.sql) into the MySQL database
• How to write a SQL query that joins multiple tables (student, course, and takes) to retrieve the required information
• How to run the SQL query and display the resulting table

🏆 Achievements

After completing this project, you will be able to:

• Understand how to work with multiple database tables to retrieve specific information
• Write complex SQL queries that involve joining tables and filtering data
• Apply your SQL knowledge to real-world scenarios, such as searching for student records in a course management system