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

776 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


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


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:

126 - 150 of 313 Reviews for Data Wrangling, Analysis and AB Testing with SQL

By reyner v

Nov 19, 2022

Muy desafiante e interesante

By siddhesh b

Jul 14, 2022

Good course. Learnt a lot!

By Samuel E

Nov 11, 2020

Really professional!!

By Navin D

Oct 18, 2022

gud dificulty level

By Aditya S

Oct 30, 2020

Interesting Course

By Ruben D S P

Jan 18, 2022

great course

By Chen M

Aug 17, 2020

useful course

By Wahab A

Feb 26, 2023

Best course.

By Sachin W

Jan 21, 2021

nice course

By Thao N

Jun 19, 2020



Jul 1, 2022


By Luis B P T

Oct 21, 2021


By Namanpreet K

Jul 6, 2020


By Saman S

Jan 27, 2020


By Nataly C R G

Sep 28, 2022


By Hector G

Sep 5, 2020


By James N N

May 24, 2022



Nov 23, 2021

all ok

By Edoh A

Oct 28, 2021


By Cesar J L R

Jun 13, 2022


By César V C

May 5, 2022


By Karen K

Jul 2, 2021


By Weizmann G B

Nov 12, 2022


By chen c

Sep 21, 2021


By Brian

Dec 20, 2022

Tough call on where to rate this: 5 stars for planning and ambition, choice of use case and data; 4 stars for quality of instruction and videos, 2-3 stars for clarity of assignment questions and checking to make sure things are up to date.

I think most people will come out of this course with a deeper understanding of how databases for online stores actually work (not some "toy version" but closer to the real thing) but it can be a frustrating journey as you will have to hack around in Mode to try different things plus use other resources to figure out what's going on. That's a bit more like being a working professional, but maybe you don't want that lesson to be wrapped up with your efforts to acquire some SQL skills and tricks of the trade.