Exploring Student Enrollments and Completions in Data-Related Career Tracks

Question

While executing this project I discovered that the datset provided has no record of completion date througout the 10,441 rows. So, am amazded what datasets was used in executing the solution files upon which analysis was carried out on the completeion rate, when infact no record of any completion rate is included in the dataset. PLease assist me on this

Answer 1

Hi Abayomi-Rufai,

Thanks for reaching out.

Are you referring to the employees_mod database or the albums/online_courses database? Each database has been assembled with a different purpose, i.e. to test certain SQL skills, so it has been adapted for the exercises provided.

Looking forward to your answer.
Kind regards,
Martin

Answer 2

Abayomi-Rufai Obarinde

Posted on:

01 Sept 2024

0

Answer 3

Abayomi-Rufai Obarinde

Posted on:

01 Sept 2024

0

I mean the datasets provided for this project

Answer 4

Hey Abayomi-Rufai,

Thank you for your patience, and I apologize for the delayed response.

If you're referring to the date_completed column in the career_track_student_enrollments table, please note that this field will be NULL for any career track that has not been completed.

If this doesn't address your concern, or if I've misunderstood, please feel free to clarify, and I'd be happy to assist further.

Kind regards,

365 Hristina

Answer 5

Yeah it is. But every single record is NULL, meaning nobody actually completed any track, so how are they carrying out the analysis of the completion rate?

Answer 6

Hey again,

The majority of the date_completed records are indeed NULL. However, upon executing the following SQL script, you'll ensure there are 123 records where a completion date is present.

SELECT 
    COUNT(date_completed)
FROM
    career_track_student_enrollments;

Let me know if you encounter other issues.

Kind regards,

365 Hristina

Exploring Student Enrollments and Completions in Data-Related Career Tracks

Submit an answer

related questions