Certification Achievement Based on Course Completion

Courses
1

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:

  1. Basic Safety Protocols
  2. Infection Control 101
  3. Emergency Response Techniques
  4. Patient Care Fundamentals
  5. Health and Wellness Basics
  6. 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?

2

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.

3

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!

4

Hey there Mia_79Dance! :raised_hands:

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? :blush: