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