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.
This course is part of the Learn SQL Basics for Data Science Specialization
Offered By
Learn SQL Basics for Data Science SpecializationUniversity of California, DavisAbout this Course
Some statistics is recommended and at least 2-years business experience.
Could your company benefit from training employees on in-demand skills?
Try Coursera for BusinessWhat you will learn
Validate and clean a dataset
Assess and create datasets to answer your questions
Solve problems using SQL
Build a simple testing framework to touch on AB Testing
Skills you will gain
- A/B Testing
- Query String
- Data Analysis
- Predictive Analytics
- SQL
Some statistics is recommended and at least 2-years business experience.
Could your company benefit from training employees on in-demand skills?
Try Coursera for Business
Offered by
Syllabus - What you will learn from this course
Data of Unknown Quality
Creating Clean Datasets
SQL Problem Solving
Case Study: AB Testing
Reviews
- 5 stars33.88%
- 4 stars17.83%
- 3 stars16.30%
- 2 stars14.77%
- 1 star17.19%
TOP REVIEWS FROM DATA WRANGLING, ANALYSIS AND AB TESTING WITH SQL
Overall great course, really get's you into data wrangling and exploring data in SQL with in almost real life situations.
At first I hated this course bcz it has a lot of exercises but then those actually helped me hone this skill.
Good course but a little more challenging for me as a beginner and new to SQL. Overall Good
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!
About the Learn SQL Basics for Data Science Specialization
Frequently Asked Questions
When will I have access to the lectures and assignments?
What will I get if I subscribe to this Specialization?
Is financial aid available?
More questions? Visit the Learner Help Center.
