Biology Course Alumni Search

Beginner

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.

SQLMySQL

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

Teacher

labby

Labby

Labby is the LabEx teacher.