DataCamp
support.datacamp.com › hc › en-us › articles › 19267574171927-SQL-Associate
SQL Associate – Support | DataCamp
September 2, 2024 - SQ101 is a 60-minute exam that most candidates typically complete in 45 minutes. This exam will contain Data Management, SQL, and theory content as well as the exploratory analysis SQL content.
DataCamp
datacamp.com › certification › sql-associate
SQL Certification Course, SQL Associate Certificate | DataCamp
DataCamp's SQL Associate Certification is awarded to individuals who successfully complete one timed exam (SQ101) and one practical exam (SQ501P).
SQL Associate Practical Exam help
I have reviewed your code. Your problem is the aliasing in TASK 3. The column name should be description instead of service_description. SELECT s.description , b.id AS branch_id, b.location, r.id AS request_id, r.rating FROM request r JOIN branch b ON b.id = r.branch_id JOIN service s ON r.service_id = s.id WHERE s.description IN ('Meal', 'Laundry') AND b.location IN ('EMEA', 'LATAM'); Thanks by the way yyour code helped me to succeed More on reddit.com
11
9
February 21, 2024Data Analyst Associate Practical Exam DA501P
Hey man, we share the same pain, but a little difference on my case: I managed to produce the results but I could not understand why only "Convert values between data types" was not met. I guess it is something with the final data types of weight and price, but I tried casting both REAL and NUMERIC types for weight, yet it did not work. I put my failed code here if you want to have a look. 2. Feedback on your code (at the time I look at it): Based on you failing the 3rd requirement, I think you failed to convert stock_location to uppercase. A simple UPPER function would help, rather than CASE WHEN which is complicated and you may miss/mess up some conditions. 3. Questions: Does the "median" part really matter here? I don't think so. There is no null values in weight and price, so it seems like we don't even need to think about it. I think your code proves it, as you don't write anything to change the null values to median (PERCENTILE_CONT). The final type of each column? As I failed this requirement, I don't know what is expected here and why I failed. I guess by casting type back and forth, I made the value type in the columns complicated and inconsistent somehow. 4. Based on all the above, I come to this conclusion: We don't need to write redundant code although we are required to. So we just do nothing for columns where null values do not exist or where values need no change -> just select them. This aligns with the guideline: Only the final output will be graded. 5. Let's sum up of what should be done: Missing values of the brand column are '-', not Null -> should be changed to 'Unknown' weight values needs to be a number rounded to 2 decimal places and without 'grams' stock_location should be converted to uppercase ('a' -> 'A', etc.) I hope that my assumptions above are correct and help all of us 14 days later. More on reddit.com
41
14
December 5, 2023Timed exams
I think this is only done for the practical part since you will have to share your presentation and record yourself giving it. More on reddit.com
2
4
November 9, 2023SQ501P-Practical Exam (Hotel Operations dataset)
SELECT id, COALESCE(location, 'Unknown') AS location, CASE WHEN total_rooms BETWEEN 1 AND 400 THEN total_rooms ELSE 100 END AS total_rooms, CASE WHEN staff_count IS NOT NULL THEN staff_count ELSE total_rooms * 1.5 END AS staff_count, CASE WHEN opening_date = '-' THEN '2023' WHEN opening_date BETWEEN '2000' AND '2023' THEN opening_date ELSE '2023' END AS opening_date, CASE WHEN target_guests IS NULL THEN 'Leisure' WHEN LOWER(target_guests) LIKE 'b%' THEN 'Business' ELSE target_guests END AS target_guests FROM public.branch; This is my code for TASK 1 for hotel Operations data set it is showing error on the part "All required data has been created and has the required columns" Could you tell me where is the error or how to fix it More on reddit.com
25
4
March 9, 2024Does DataCamp provide materials to prepare for Certification?
Yes! As part of your subscription, you will have access to our content library that includes hundreds of hours of courses, practice and projects. You won’t need to complete it all though. We have curated a series of Career tracks that will guide you through building the core skills you will need for certification. Once you feel ready, we also provide a range of resources to help you prepare for the exams themselves, giving you a chance to experience the process before you start.
datacamp.com
datacamp.com › certification › sql-associate
SQL Certification Course, SQL Associate Certificate | DataCamp
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.
datacamp.com
datacamp.com › certification › sql-associate
SQL Certification Course, SQL Associate Certificate | DataCamp
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.
datacamp.com
datacamp.com › certification › sql-associate
SQL Certification Course, SQL Associate Certificate | DataCamp
Videos
DataCamp
datacamp.com › blog › introducing-new-sql-associate-certification
Introducing a brand new SQL associate certification for data-driven professionals. | DataCamp
December 6, 2023 - The final step in this Certification is a practical exam. The practical exam assesses your skills in data management SQL.
DataCamp
support.datacamp.com › hc › en-us › articles › 7926454692631-Data-Scientist-Associate
Data Scientist Associate – Support | DataCamp
July 25, 2025 - The DS102 is a 2-hour exam where you'll choose either R or Python to answer questions about data management, modeling, and programming for data science. Most candidates typically complete it in one hour.
Medium
medium.com › javarevisited › is-sql-associate-certification-on-datacamp-worth-it-review-0164a850c201
Review — Is Datacampl’s SQL Associate Certification worth it in 2025? | by javinpaul | Javarevisited | Medium
April 21, 2025 - SQ101 is a 60-minute exam that most candidates typically complete in 45 minutes. This exam will contain Data Management, SQL, and theory content as well as the exploratory analysis SQL content.
GitHub
github.com › ssarrayya › datacamp-associate-certification
GitHub - ssarrayya/datacamp-associate-certification: Case study submission for the DataCamp Associate Data Analyst Certificate Exam. · GitHub
Describe the relationship between repeat purchases and sales. Your answer must include a visualization to demonstrate the relationship.
Starred by 17 users
Forked by 4 users
Languages Jupyter Notebook
DEV Community
dev.to › itsjjpowell › passing-the-datacamp-sql-associate-certificate-jcc
Passing The DataCamp SQL Associate Certificate - DEV Community
April 10, 2024 - If you're familiar with the terms, or have used them at least once, you'll be able to answer most questions. Joins: LEFT JOIN, FULL JOIN, INNER JOIN, UNION, UNION ALL · String Manipulation: UPPER, LOWER, LIKE, ILIKE, ~, REGEX, TRIM, LEFT, RIGHT ... The more general database questions may require taking the DataCamp courses because they seem to expect you to use the same language that instructors use in those courses. The timed practical exam is a mutli-part question where you write queries for some provided tables.
DataCamp
support.datacamp.com › hc › en-us › articles › 25852618427543-Python-Data-Associate
Python Data Associate – Support | DataCamp
Certification Requirements DataCamp's Python Associate Certification is awarded to individuals who successfully complete one timed exam and one practical exam (PY101 & PY501P). The PY101 is a 2...
GitHub
github.com › tuananh-0401 › SQL-Associate
GitHub - tuananh-0401/SQL-Associate · GitHub
The practical exam involves completing a project that addresses a business problem using SQL. This project is based on the DataCamp projects format, and candidates must utilize DataLab to submit their work.
Author tuananh-0401
Reddit
reddit.com › r/datacamp › sql associate practical exam help
r/DataCamp on Reddit: SQL Associate Practical Exam help
February 21, 2024 -
I've just tried my first attempt and just can't see what is wrong even with the hints, made some changes but I think something might be still off.
I don't mind failing the exam to take it again but I just want to learn from my mistakes here since I spent quite a while doing this.
UPDATE: the guy in the comments helped me out and i passed, do take a look if you're struggling to complete it
ps.!! i couldn't update it on git so just take note of my error in TASK 3 where the column description should not be renamed to service_description
https://github.com/christyleeyx/sql-associate-cert/blob/main/notebook%20(3).ipynb
Top answer 1 of 4
2
I have reviewed your code. Your problem is the aliasing in TASK 3. The column name should be description instead of service_description. SELECT s.description , b.id AS branch_id, b.location, r.id AS request_id, r.rating FROM request r JOIN branch b ON b.id = r.branch_id JOIN service s ON r.service_id = s.id WHERE s.description IN ('Meal', 'Laundry') AND b.location IN ('EMEA', 'LATAM'); Thanks by the way yyour code helped me to succeed
2 of 4
1
I keep getting the error "clean categorical and text data by manipulating strings" on task 1, did you pass task one? if so can you please help
Medium
medium.com › geekculture › nailing-datacamps-data-scientist-professional-certification-9c084532b00e
Nailing DataCamp’s Data Scientist Professional Certification | by Wouter van Heeswijk, PhD | Geek Culture | Medium
May 8, 2023 - Nailing DataCamp’s Data Scientist Professional Certification Prepare yourself for the exams DS101, DS201 and the practical exam The DataCamp trajectory DataCamp is a great way to build a data …
DataCamp
support.datacamp.com › hc › en-us › articles › 7633838697111-DataCamp-Certification-Practical-Exams-An-Overview
DataCamp Certification Practical Exams: An Overview – Support | DataCamp
May 2, 2024 - DataCamp Fundamentals Certifications do not include a practical exam.
Scribd
scribd.com › document › 795469682 › SQL-Certification-Study-Guide
SQL Associate Certification Study Guide | PDF | Postgre Sql | Sql
Exam SQ101: Data Management Theory & SQL and Exploratory Analysis Theory SQL · ● Aggregate numeric, categorical variables and dates by groups using PostgreSQL. ● Interpret a database schema and combine multiple tables by rows or columns ...
Reddit
reddit.com › r/datacamp › data analyst associate practical exam da501p
r/DataCamp on Reddit: Data Analyst Associate Practical Exam DA501P
December 5, 2023 -
I'm starting to think there is something wrong with this data set. TASK 2 seems to be problematic. I'd appreciate your enlightenment.
Clean categorical and text data by manipulating strings not passed.Source Link
Edit: It was a funny experience for me. First of all, I need to state that my first problem is with my use of Markdown. We had the chance to choose the database connection of the cells as Dataframe or Query. I didn't know that I could access the frame I created in a different cell on the page by selecting Query. In my first attempt, I tried to create a temporary table and this made me make unnecessary mistakes. As a result, I had the opportunity to realise a different approach to task2 thanks to your comments. You can find the details in the successful source code.
Top answer 1 of 4
4
Hey man, we share the same pain, but a little difference on my case: I managed to produce the results but I could not understand why only "Convert values between data types" was not met. I guess it is something with the final data types of weight and price, but I tried casting both REAL and NUMERIC types for weight, yet it did not work. I put my failed code here if you want to have a look. 2. Feedback on your code (at the time I look at it): Based on you failing the 3rd requirement, I think you failed to convert stock_location to uppercase. A simple UPPER function would help, rather than CASE WHEN which is complicated and you may miss/mess up some conditions. 3. Questions: Does the "median" part really matter here? I don't think so. There is no null values in weight and price, so it seems like we don't even need to think about it. I think your code proves it, as you don't write anything to change the null values to median (PERCENTILE_CONT). The final type of each column? As I failed this requirement, I don't know what is expected here and why I failed. I guess by casting type back and forth, I made the value type in the columns complicated and inconsistent somehow. 4. Based on all the above, I come to this conclusion: We don't need to write redundant code although we are required to. So we just do nothing for columns where null values do not exist or where values need no change -> just select them. This aligns with the guideline: Only the final output will be graded. 5. Let's sum up of what should be done: Missing values of the brand column are '-', not Null -> should be changed to 'Unknown' weight values needs to be a number rounded to 2 decimal places and without 'grams' stock_location should be converted to uppercase ('a' -> 'A', etc.) I hope that my assumptions above are correct and help all of us 14 days later.
2 of 4
4
For those facing trouble with task 3 on this exam, it is meant to be done on the products table, not the corrected query. As someone who teaches coding, I would explain this project is in fact not something that ywould be done in a production environment (as you would use clean_data to get the accurate numbers and/or update the table / create a new one after correcting the data errors), but rather a test of your skills. I just passed this with help from some threads on here. I had preivously failed it, went back and practiced case and coalesce stuff, looked at ways to address the data issues, of which there are reasonable solutions in the answer provided in this thread. The one problem in the 'solution' by the OP is that they utilize clean_data in task 3. If you look closely, though, the output doesn't match what you'd get with running the same query on the products table - so use the products table (even though that wouldn't make sense in a production environment / real world. This is testing your skills on the products dataset, do not see each task as tied together at all - which is largely contrary to how coding in a production environment works. I hope that helps some folks break through the wall! Also, there are multiple different ways to do task 2, the only thing that matters is that your outputs are correct! Look at the sample outputs in the provided solution by OP and you'll get an idea of what it should look like.
Quizlet
quizlet.com › 504474672 › ds101-final-answers-flash-cards
DS101 Final answers Flashcards | Quizlet
DS101 Final answers Learn with flashcards, games, and more — for free.
DataCamp
datacamp.com › blog › Acing-the-DataCamp-Certification-Practical
Acing the DataCamp Certification Practical Exam | DataCamp
November 21, 2022 - You may not have done it much in your courses, but missing this step can lead you to making inaccurate conclusions or recommendations. It’s a straightforward task in the practical exam and easy to meet, but the most common reason for failing is not demonstrating that you really did validate all of the data.
GitHub
github.com › topics › datacamp-exercises
datacamp-exercises · GitHub Topics · GitHub
python data-science machine-learning pandas data-analysis datacamp-course datacamp datacamp-exercises datacamp-solutions-python datacamp-python datacamp-machine-learning datacamp-track data-analyst-with-sql-server data-scientist-with-python data-analyst-with-python data-science-for-everyone datacamp-data-science
Reddit
reddit.com › r/datacamp › timed exams
r/DataCamp on Reddit: Timed exams
November 9, 2023 -
I tried to start my first timed exam (DS101) and the first thing it told me was that I need to enable a webcam and screen sharing. Is the screen sharing done to make sure you’re not referencing any material? Or is it to make sure you’re not referencing any material that’s blatantly cheating (like feeding all your questions into ChatGPT)? I’m wondering if I’m allowed to look at official documentation for Python modules if I forget if a parameter name is “column” or “columns” or “col” or “usecols” etc. After all, Python users in the professional world have to look things up all the time. Nobody has every module, function, attribute, etc memorized.
Reddit
reddit.com › r/datacamp › sq501p-practical exam (hotel operations dataset)
r/DataCamp on Reddit: SQ501P-Practical Exam (Hotel Operations dataset)
March 9, 2024 -
Did anyone take the SQ501P - SQL Associate practical exam? I'm struggling with task1 (on hotel operations dataset. No matter what options I try, i still receiving error.
Top answer 1 of 5
2
SELECT id, COALESCE(location, 'Unknown') AS location, CASE WHEN total_rooms BETWEEN 1 AND 400 THEN total_rooms ELSE 100 END AS total_rooms, CASE WHEN staff_count IS NOT NULL THEN staff_count ELSE total_rooms * 1.5 END AS staff_count, CASE WHEN opening_date = '-' THEN '2023' WHEN opening_date BETWEEN '2000' AND '2023' THEN opening_date ELSE '2023' END AS opening_date, CASE WHEN target_guests IS NULL THEN 'Leisure' WHEN LOWER(target_guests) LIKE 'b%' THEN 'Business' ELSE target_guests END AS target_guests FROM public.branch; This is my code for TASK 1 for hotel Operations data set it is showing error on the part "All required data has been created and has the required columns" Could you tell me where is the error or how to fix it
2 of 5
1
Did you complete the exam ? I completed all but except one step. Task 1: Clean categorical and text data by manipulating strings. I can't pass this step, can you send me the code if you solved it?
Reddit
reddit.com › r/datacamp › data analyst associate practical exam tips
r/DataCamp on Reddit: Data Analyst Associate Practical Exam Tips
November 2, 2023 -
Hi! I completed the timed exam from the certification and was just wondering if anyone knows the formal of the practical exam?
i skimmed the subreddit and saw a lot of practical exams include a presentation and video recording of it. is that the case with this practical too? i looked at the sample exam and it doesn’t seem like it but just want to be sure.
if anyone can provide a description of what the practical exam entails that would be greatly appreciated. Thank you!
Top answer 1 of 3
2
The associate one doesn’t require a presentation. You will clean the data and create some visuals while describing your work (why you did what you did and what you found out from the data).
2 of 3
2
Thanks all for the comments. are there any projects that would be a good practice before attempting the practical? I did the Data Analyst track, but from the sounds of it, the project seems very different from the practical.