Chevron Left
Back to Data Wrangling, Analysis and AB Testing with SQL

Learner Reviews & Feedback for Data Wrangling, Analysis and AB Testing with SQL by University of California, Davis

3.3
stars
922 ratings

About the Course

This course allows you to apply the SQL skills taught in “SQL for Data Science” to four increasingly complex and authentic data science inquiry case studies. We'll learn how to convert timestamps of all types to common formats and perform date/time calculations. We'll select and perform the optimal JOIN for a data science inquiry and clean data within an analysis dataset by deduping, running quality checks, backfilling, and handling nulls. We'll learn how to segment and analyze data per segment using windowing functions and use case statements to execute conditional logic to address a data science inquiry. We'll also describe how to convert a query into a scheduled job and how to insert data into a date partition. Finally, given a predictive analysis need, we'll engineer a feature from raw data using the tools and skills we've built over the course. The real-world application of these skills will give you the framework for performing the analysis of an AB test....

Top reviews

MF

Sep 22, 2020

A good course for learning and apply sql to conduct analysis on ab testing results. Would be better if the instructor could provide more info about how to design and apply AB Testing on the customers

SP

Jul 29, 2019

The instructor is very smart and her syllabus is very easy to follow. The real life examples are great and helps put ideas in perspective! I would definitely recommend this course and already have!

Filter by:

276 - 300 of 370 Reviews for Data Wrangling, Analysis and AB Testing with SQL

By Michael S

Aug 28, 2022

There are some real strenghts to this course; it introduces some important concepts, and the instructor goes over them in sufficient detail in the explanation videos. However the reliance on Mode without sufficient updates has led to problems such as tables not matching either instructions or assignments, some assignments not being completable, or the final project not being reviewable by peers. I would strongly suggest more integrated checks-on-learning during videos.

By Daniel A

Aug 16, 2022

The concepts and material were very good but the professor did not teach the course well. I had a hard time learning because the solution videos were not helpful. Many solutions were not fully shown, she constantly made mistakes, and she corrected her mistakes while explaining distracting me from the overall material. She did a very bad job at explaining and I was confused most of the course. I did not like the professor and I took her concepts and learned on my own.

By Shashank S

Mar 1, 2022

The concept of AB testing is probably the only good topic of this course. The instructor keeps referring to tables used in previous assignments which makes it very inconvenient for learners because if you can't remember what that table looked like, you have to constantly go back and look at it. Also, the instructor assumes that everyone taking this course knows what type of data would be required for analysis in certain scenarios. Overall a poorly designed course!

By Ka W S

Apr 9, 2021

If you come from the last course of this series, i would say stop this course. They expect you to know many things you didn't learn in the first course, and the teaching style is not helpful. I will not continue this certificate due to the quality of this course. Some of the answer they give out are wrong and the explanation is not good. I will change to a different certificate. I wonder why this course has so many bad reviews, so I know it.

By Christina F

Aug 30, 2022

This course was not a very smooth transitions from the basics class. It moved very quickly and assumed you knew a lot of information/had skills that were not developed in the first class which made it very frustrating. There were times you were supposed to follow specific directions but the buttons they said to press weren't there. It was very frustrating and difficult and I didn't get as much out of it as I would've liked

By Holden C

Aug 4, 2022

The course did not prepare me for the final project at the end, it was very confusing. I appreciate the structure of the first course where i got to query after given a speicfic question, this way I got instant feedback and know what I did wrong. The seoncd course asked me to query in a different website and the prompt was very vague I didn't know what was asked most of the time. This course was really disapponting .

By Panos S

Dec 28, 2023

Definatelly, not a beginner course. The gap between that course and a previous one is huge. I like the idea that the instructor tries to implement every day thing on the course but really missed it. Also, you can clearly tell that is totally unstractured and hasn't any flow. I don't think I will continue this spesialization, propably going to take another one.

By Annamaria N R L S

May 29, 2020

Interesting Course. had more opportunities to practice, but would recommend that the incoming student have more practice and experience before starting. Still rather disorganized and some parts (i.e. explinations and subject videos0 in need of review by creator (i.e. gaps in explanations, vague directions and instruction, etc.). Am grateful for extra practice.

By Cha H

Jun 8, 2021

So far, this certificate stated this was a foundational and basics in SQL but it's more intermediate than beginner. There's absolutely no assistance if you run into any problems and each course uses a different platform so there's no consistency. We went from SQL Lite to postgre in the next course.

Feeling a bit frustrated and disappointed with this cert

By Sven H

Nov 8, 2022

The course is really poorly designed. It feels disjointed, there is missing information and some questions are vague or straight up not finished. I can't even say that this course is a big jump from the previous intro. I understand the concepts and commands used. The problems are akin to someone telling you "do analytics and find out what makes sense".

By Remko M

Oct 31, 2020

Not well instructed...messy. For example, in the video her own faults or issues are not cut out of the video. You watch minutes of that in total and that a total time waister to me. So you tend to zoom out or wanted to skip through the video. Also the assignment instruction are not coherent with the instructions in mode. That is somethings confusing.

By Kevin E C O

Oct 23, 2022

Los nuevos conceptos en este son muy interesantes pero el número de ejemplos que se brinda no son muy claros y cuesta entenderlos. La profesora al realizar los ejercicios no deja comentarios en sus codigo lo que dificulta su comprensión.

Mejoras:

- Poner más ejercicios de ejemplos.

- Ser más claro en la explicación de los conceptos.

By Tomomi Y

Feb 9, 2021

The topic itself is interesting, but I think this course has a room to improve the lecture video quality. Instructor seems not well prepared when recording the video and she often makes mistakes & mumbles which makes me hard to follow what she is doing. Also I think practice questions are sometimes ambiguous compared to other courses.

By Matthew B

Nov 29, 2023

Difficult for me to follow in comparison to other courses I had taken on here. 'Mode' was also a challenge to use and follow the instruction given. Overall, I believe some of the resources (mode in particular) have changed since the course was released and the instructions were not updated to align with current operation.

By Kiarash H

Sep 8, 2023

I liked the idea of doing many exercises and assignments instead of just passive listening or reading and I think I benefited from this course.

However, the whole course is poorly organized, and do not blame yourself if you cannot understand what exactly the assignment wants you to do since they are far from clear.

By Hoang P T N

Mar 11, 2024

The course is poorly structured, most of the code provided are pictures which makes it wasting time to type everything again. Everyone can make mistake even a pro, but it doesn't help when it comes to presenting yourself to learner, it makes the learning process confusing and time wasting.

By Lynda P

Dec 26, 2020

This course has very poor instructions, exercises are vague and all solutions don't always align with course. For the DBMS (Mode) used in this course, there is no explanation on how to use it. The instructor expects you to present charts without explaining how to use it.

By Yat N W

Feb 23, 2023

Overall - I wouldn't recommend this course to people.

Two star for all the SQL practices you get from the hands on exercises. The instructor did put in a lot of thoughts to create these practices.

The AB testing part - they assume students have statistics background.

By Linh B

Sep 20, 2022

This course was really frustrating and difficult to follow. I almost lost my interest in SQL while taking this course. A lot of the data was out of date, and the instructor did not explain the concepts or how she came up with the solutions thoroughly.

By Irving G M

Aug 27, 2020

The course helped to practice the implementation of complicated SQL queries. However, it was quite unstructured and there teacher said wrong concepts and interpretation about hypothesis testing. This course need to be checked.

By ERIC M

Jul 21, 2020

It's not organized like a class. The teaching style is more like you can shadow me while i work. That's fine if someone can ask questions and get instant feedback. But as an e-learning course it doesn't work very well.

By sushant p

Dec 7, 2022

- Coursework was not properly constructed

- Ambiguity around the videos and quizzes, too big a leap from basics to intermediate

- Including AB testing dealt a bigger blow to understanding data wrangling through SQL

By Виктор И

Jun 15, 2022

Если кратко, то не советую. Ни SQL нормально не попрактикуете, ни в A/B тестах не разберётесь.

Много пространных видео, подача информации не очень. Есть задания в которых совершенно не ясно что нужно делать.

By Georgios A

Aug 10, 2020

This course lacks some structure, overview and professionalism (like editing the videos). Nevertheless, it is a useful of this specialization, if ones has the extra time to invest.

By Martin F

Jun 6, 2023

El funcionamiento del curso en si me presento muchos inconvenientes. Aprendi muy poco y basicamente hice lo posible por sacármelo de arriba. Es un curso NO recomendable.