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