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