Chevron Left
返回到 Data Wrangling, Analysis and AB Testing with SQL

學生對 加州大学戴维斯分校 提供的 Data Wrangling, Analysis and AB Testing with SQL 的評價和反饋

365 個評分
144 條評論


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....



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


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!


26 - Data Wrangling, Analysis and AB Testing with SQL 的 50 個評論(共 144 個)

創建者 Cristina R


Pretty informative course!

Sometimes the descriptions of the practice exercises seem a bit fuzzy, but as you go with the course it gets easier to understand how to interpret the requirements. Very helpful solution videos!

創建者 A. M B


The course is not very well structure, I understand that this subject is not the easiest one to teach, but one thing that could help is to give a structured representation of the database with all the keys that are in it. you have to almost guess what is in it.

The videos should be more carefully planned, the solution videos are a little messy and some steps are not explain

創建者 Jennifer B


A very thorough overview of SQL and how to best structure data tables and metrics for AB testing. I appreciate the high quality content of the UC Davis courses!

創建者 Karan B


Course was ok overall. I learned the basics and the SQL was good. I learned a lot about the basics of SQL through the course. However, the video could have been better edited and the prompts/questions (especially in the final project) were difficult to understand.

創建者 Ayomide O


I'll give it a 5 mostly because this is one of the few in-depth SQL courses on the site, plus it actually goes beyond Joins and all that other pre-advanced stuff. I actually learnt new methods such as using windowing functions and using AB Testing. It could be better yes but we need more practical courses like this one.

創建者 Karina S


Great course!! I have learned a lot about how to evaluate the quality of the data received, how to problem solve with SQL when asked ambiguous business requirements, tips to do multiple selection editing in text editor (that was a great discovery!), metrics and AB testing. Highly recommended!

創建者 boraton2003


The information in this course is very great as well as the practical part of the course. The instructor was very great and knowledgeable. Thus, I recommend this program to anyone who is interested in learning SQL queries.

創建者 Endong T


The assignments are pretty difficult, and I think this course suits those who have advanced SQL skills and wanna use SQL to solve higher level problems. The lecturer are pretty interesting, and I enjoy that.

創建者 Mike F


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

創建者 Soprano R


It is pretty useful course to understand how to prepare data for AB Testing in real database environment. you should know SQL intermediate leve before starting this course.

創建者 Viviana R


Gracias por impartir conocimientos online y darnos la posibilidad, a quienes trabajamos seguir perfeccionándonos, organizando los tiempos personles

創建者 Nathaniel M


Overall great course, really get's you into data wrangling and exploring data in SQL with in almost real life situations.

創建者 Jose L O T


Bien practico el cuso me encanto esta parte. También me ayudo a saber que tengo que reforzar en estadística .

創建者 Abhinav A


Good course but a little more challenging for me as a beginner and new to SQL. Overall Good

創建者 Carolina G


Excellent course and material but it require a lot of practice.

創建者 Steven K C W


Amazing work guys! I enjoyed the coding part a lot. Thank you!

創建者 Vamsi A


This Course teaches you real world application of SQL.

創建者 Gary T


SQL, Data Wrangling. Challenging and fun course.

創建者 Monish P


Well executed and scripted for learning

創建者 Mahedi M


Challenging, but I learned quite a lot.

創建者 David M G


Very complete course! Thank you!

創建者 Samuel E


Really professional!!

創建者 Aditya S


Interesting Course

創建者 Chen M


useful course