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
961 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 390 Reviews for Data Wrangling, Analysis and AB Testing with SQL

By Jing Y

Sep 12, 2022

I did have learned something from this course, but I really cannot love it. Here are something I like and dislike.

Likes:

1. I learned to format my code better by typing together with the solution video.

2. I practiced what I learned from the last course.

3. The instructor shared valuable practical tips.

4. I like that the instructor emphsised "think before type".

Dislikes (actually suffering):

1. Peer review. I wish there are instructions for making sharable mode link.

2. The practice excercises are actually valuable but the way how it was introduced to us was VERY confusing.

3. Like many others reivewed, this course is not well-organized.

4. This is the second SQL course I took . As the second SQL course of the specilization, the first course brought me from 0 to 5. I feel this second course expects me to jump from 5 directly to 60 in week 1.

By Moritz P

Jan 23, 2021

I just want to take the time again to critique this course. I found the first in the series (SQL for Data Science) way better than this one. Make no mistake, it was really insightful and helpful. However, the practice of forcing people to comment before being able to watch the next videos just leads to a lot of non-sense in the discussion forums, disturbing all others who really want to discuss. Additionally, this course was way less engaging than the first one and made considerably less fun practicing. Especially, when tasks in the PDF are only described in broken sentences and when in the actual solution videos SQL code is copy-pasted so quickly that there is no way to catch-up. Yes, one could pause. However, this really disturbs a progressive learning atmosphere and destroys the joy of coding, at least for me.

By Maor L

Mar 15, 2021

Good Riddance! On the positive side, the course covered very important aspects of SQL and forced me to learn by myself several methods in SQL. However, the course structure was very bad, and I won't be surprised if many students have left the specialization at this point, not because of its difficulty, but because of the contents. Here are some of the main problems of this course - the instructor isn't correlated with the presentations, the Mode tasks are poorly drafted and there isn't a clear guide how to use this platform (which is essential to the final project), many questions in the tests are very ambiguous. Basically I would recommend US Davis to restructure this course in a way which will be in the same high level of the first course by Sadie, and in a way it won't be so frustrating to learn it.

By Luis A S A S

Sep 14, 2023

I had to resubmit my peer-review assignment because 1 of the graders did not know how to access my work. There is absolutely no guidance on how to create a shareable link with SQL Mode (platform for the project) or how to create well structured SQL Mode reports...

Concerning the course's content, even though the excessive difficulty of the exercises given in class was good as a way to improve our way of thinking, it was many times too much, as it made it difficult to learn and progress. Many times the questions are also poorly phrased, making it even harder...

Also, AB testing was just briefly touched at the end of the course, without giving all the foundations necessary for the students to be at the same level when going for the final project (peer-review assignment).

By Tim S

Jun 20, 2020

The use of mode made the experience for this course a bit clunky; also the final assignment could have been outlined more in line with the rubric. A model to emulate is the use of SQL lite in the first course. To add I was hoping that there would be a way to programmatically determine A/B testing vs. using an external tool; perhaps the third week assignment would be to code up a SQL significance calculator then in the forth week use that model to the data. These are the reasons why I give this course 2 stars. This of course might be very difficult given that SQL is not a functional language (I personally haven't tried this). The instruction, exercises and the design really make me stop and learn key concepts and the professor's recorded demos were excellent.

By Rifqi R

Nov 24, 2020

honestly, this course feels like navigating through a foreign city without any knowledge of the landmark.

class is confusing. more query statements introduced without any proper introduction to the query made this class is lacking sense of continuation from the previous ones.

the training/examples are not streamlined with Coursera's built in quiz feature. using app.mode is a new thing and the intro to the app isn't well explained.

training instructions are confusing and the solutions aren't helping, for example, we need to find what's wrong in a query, while we're confused and trying to find the solutions in the solutions videos, why not throw in graphs into the mix and make us more confused..

By Angel M

Dec 11, 2023

This course was not taught well and not structured well. I did not understand a lot of the tables used during the class. For example, the teacher could have explained what the line_item was compare to a regular item instead of us guessing. The overall course title ( Learn SQL Basics for Data Science) implies a beginner level course but the teacher within this class immediately comes out and says you need to be really good at SQL prior to coming here which is definitely misleading. In one of the solution videos, the answer was out of order. I don't want to sound rude, this is just constructive criticism. It has potential to be better.

By Bedirhan K

Jun 13, 2024

The explainations was god enought but I think assigment/practice structure of the course was really insufficien because of theset: 1. Starter codes in PDFs was screenshot and not a code text which I can directly copy to start. This makes really hard to complite the assigments and may take too long time. 2.The questions in some assigments and in the final project was not so detailed and understandable. I couldn't be sure about what the assigment wants from me. 3. Maybe you should use a better data analysis platform instead of a Web based platform which might increase effectivness and be easier.

By Daniel O

May 16, 2021

This was the second course in the Learn SQL Basics for Data Science. It felt like big steps were skipped in between. What was even more frustrating was that the instructor said multiple times that material should have been covered in previous courses and/or to search Google if the learner was unfamiliar with any topic. I’m certain some areas were not covered and telling students to search Google is just lazy. I also felt that the instructor did an excellent job of showing her knowledge on the material but failed to properly explain what she was doing or why.

By Jacob R

Oct 10, 2021

This was good SQL practice but overall the course quality was poor. Instructions were at times unclear and unpractical (e.g. expecting students type dozens of lines of starter code instead of letting them copy-paste them). The video lectures were useless as they tended to be more about data science as a whole. Kat Glaeser is simply a poor instructor, with many glaring editing and speech mistakes in her lectures. I'm disappointed I paid for this course while there are hundreds of higher quality and free exercises and videos elsewhere on the internet.

By Ronald S

Aug 2, 2023

Interrupted the course due to bad teaching approach.

It's basically that you are thrown tasks to solve with little introduction of the ideas and methods.

Then the "teacher" shows you how they solved it with tools never mentioned before. Resulting in frontal teaching with low level presentation skills.

The course seems like it was meant for offline groups which interact a lot with each other.

It's one of these "if you are good and invested a lot of extra effort" classes that bad professors at university did to weed out students they deemed unworthy.

By José M V D

Mar 3, 2021

This was a very disjointed course and unfortunately the worst Coursera course that I have made so far.

The teacher was good, it seems that she knows a lot about the SQL concepts explained in the course, but I don't think the concepts are well explained. You can learn something from the exercises, but only once you see the solution. Before seeing the solution, it is often hard to understand what you have to do.

To sum up, I would not pay again for this course, and I would not have finished it, if it wasn't needed to get the certification.

By Luke F

Jun 12, 2020

The lecturer is clearly friendly and passionate. However, as other reviewers have noted, this course introduces more complex areas of SQL with no explanation. The videos before the assignments provide little insight into how to do them afterwards and instead I found myself skipping them and then just watching cluelessly as the solutions were quickly banged out. I appreciate the efforts of the instructor but I feel this course needs to be a) refined and b) simplified for those of us coming off the first data science course.

By A I K

Nov 13, 2023

there are so many things that I'm unsatisfied with. One is inappropriate guidance, Second is videos are full of unnecessary time-wasting frames. they should delete some parts of some videos and join them together to make a qualitiful lesson. 3rd thing is mismatching questions between the provided questions in the final assignment workbook and the questions for grading in the final assignments. there are so many lack of things to make this course to be considered as an intermediate level course.

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.