I’m working on a project to make a report that shows when someone finishes enough classes to get certified. The idea is that if they finish 6 specific courses, they get the certification.
Here’s what I’m dealing with:
- We have two tables: one for users and one for courses
- All the courses a user takes are in the course table with their name
For example, let’s say we have a user named Jane Doe who took these classes:
- Basic Safety Protocols
- Infection Control 101
- Emergency Response Techniques
- Patient Care Fundamentals
- Health and Wellness Basics
- Medical Ethics and Compliance
I want the report to show that Jane is now certified because she finished all six required courses.
How can I set up my report to automatically recognize when a user has completed the right mix of courses and mark them as certified? Any tips on the best way to approach this?
As someone who’s worked on similar certification tracking systems, I can offer some insights. You’re on the right track with your two-table setup. Here’s what I’d suggest: Create a third table for certification requirements that lists the six specific courses needed for certification. Then, use a SQL query to join this table with your user and course tables and check if a user has completed all required courses. For the report, consider using a subquery or HAVING clause to filter users who have completed all six courses based on a COUNT(DISTINCT course_name) = 6 condition. This approach is scalable and flexible for future updates.
hey mia, that proj sounds cool! try creating a table with reqd courses and use a join between users and courses. group by user and filter with having count(distinct course)==6. that way, u can auto mark users as certified. good luck!
Hey there Mia_79Dance! 
Your project sounds super interesting! I’ve actually been wondering about something similar for my own work. Have you thought about using a points system instead of just course completion? Like, maybe some courses could be worth more towards certification than others?
Just curious - how are you planning to handle partial completion? Say someone’s done 5 out of 6 courses, would your system show their progress somehow?
Oh, and another thing - will there be any time limits on when courses need to be completed by? I’ve seen some certifications expire if you don’t finish within a certain timeframe.
Anyway, love the idea! Keep us posted on how it turns out, yeah? 