Creating Stored Procedures for Course Data Retrieval

Introduction

In this project, you will learn how to create a stored procedure in MySQL to retrieve courses with credits greater than 3. This project will help you understand the basics of working with stored procedures in a database management system.

👀 Preview

MariaDB [edusys]> CALL getCourses();
+-----------+----------------------------+------------+---------+
| course_id | title                      | dept_name  | credits |
+-----------+----------------------------+------------+---------+
| BIO-101   | Intro. to Biology          | Biology    |       4 |
| BIO-301   | Genetics                   | Biology    |       4 |
| CS-101    | Intro. to Computer Science | Comp. Sci. |       4 |
| CS-190    | Game Design                | Comp. Sci. |       4 |
| PHY-101   | Physical Principles        | Physics    |       4 |
+-----------+----------------------------+------------+---------+
5 rows in set (0.000 sec)

🎯 Tasks

In this project, you will learn:

• How to access MySQL using the sudo command without a password
• How to import data into the MySQL database
• How to create a stored procedure to retrieve specific data from a table
• How to test the stored procedure to ensure it is working as expected

🏆 Achievements

After completing this project, you will be able to:

• Understand the purpose and benefits of using stored procedures in a database
• Create your own stored procedures to perform specific data retrieval tasks
• Troubleshoot and test stored procedures to ensure they are functioning correctly
• Apply the knowledge gained in this project to build more complex database-driven applications