What is going on with the TASK 1 in the Associate SQL Certification Exam?!
[deleted by user]
SQL Associate Practical Exam
DataCamp and beyond basic SQL
Does DataCamp offer Data Analyst Certification?
How long are DataCamp Certifications valid for?
Our Technology Certifications are valid for two years from the date awarded. The data industry is moving quickly and it is important to keep your skills up to date, so you will be invited to retake the exams after two years, or if you would prefer, you can attempt to upgrade to a more advanced level certification.
How much do DataCamp Certifications cost?
DataCamp Certification is included with your premium subscription, so there are no additional costs. When you subscribe you will have access to learning materials to prepare for your certification, practice assessments and exams and the certification itself.
Videos
I keep getting all of the tasks correct except for 1 section of Task 1 where it tells you to return the columns of a certain table after replacing missing values with unknown etc.. I do DISTINCT to see whats going on and say one column has a data type of integer but there are no missing values that are NULL just say '-' as a string so I replace those values. Everything is returned using coalesce or case statements to replace missing values with the correct ones and making sure the final data types match the schema but it keeps saying I don't get it right. Here is one picture for example. Is there some trick I'm not getting behind the initial cleaning task 1 for these Associate SQL Certification practical exams?