About this Course

91,804 recent views
Shareable Certificate
Earn a Certificate upon completion
100% online
Start instantly and learn at your own schedule.
Flexible deadlines
Reset deadlines in accordance to your schedule.
Intermediate Level

Some statistics is recommended and at least 2-years business experience.

Approx. 16 hours to complete
English

What 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 TestingQuery StringData AnalysisPredictive AnalyticsSQL
Shareable Certificate
Earn a Certificate upon completion
100% online
Start instantly and learn at your own schedule.
Flexible deadlines
Reset deadlines in accordance to your schedule.
Intermediate Level

Some statistics is recommended and at least 2-years business experience.

Approx. 16 hours to complete
English

Offered by

Placeholder

University of California, Davis

Syllabus - What you will learn from this course

Content RatingThumbs Up84%(1,490 ratings)Info
Week
1

Week 1

5 hours to complete

Data of Unknown Quality

5 hours to complete
12 videos (Total 85 min), 3 readings, 2 quizzes
12 videos
Introduction of Data of Unknown Quality1m
Introduction to the Course Dataset10m
Error Codes (Solution)13m
Flexible Data Formats6m
Flexible Data Formats (Solution)5m
Identifying Unreliable Data + Nulls3m
Unreliable Data - Part 1 (Solution)4m
Unreliable Data -Part 2 (Solution)7m
Unreliable Data - Part 3 (Solution)8m
Answering Ambiguous Questions3m
Users Table (Solution)16m
3 readings
A Note From UC Davis10m
Connecting to Mode Analytics20m
Not Dumb Questions10m
2 practice exercises
Are You Connected to Mode Analytics?5m
Module 1 Quiz30m
Week
2

Week 2

3 hours to complete

Creating Clean Datasets

3 hours to complete
10 videos (Total 53 min)
10 videos
Tools of the Trade: Coding Guide with Sublime Text (Optional)3m
Data Types4m
What is a Dependency?5m
Create a View-Item Table2m
Turn a Clean Query Into a Table (Activity/Solution)9m
Hierarchy of Data2m
Create User Info Table3m
Create a User Snapshot Table (Activity/Solution)13m
Partitions in Hive (Optional)5m
4 practice exercises
Data Types (Quiz)30m
Dependencies (Quiz)30m
Turn a Clean Query Into a Table (Quiz)30m
Module 2 Quiz30m
Week
3

Week 3

4 hours to complete

SQL Problem Solving

4 hours to complete
11 videos (Total 64 min)
11 videos
Map Out Your Joins4m
Test Queries vs Final Queries3m
Example: Create an Aggregate Table with a Rolling Date Period2m
Rolling Orders (Solution)10m
Find Each User's Most Recently Viewed Page for an Email Campaign2m
Review Windowing Functions3m
Promo Email (Solution)11m
Product Analysis4m
Product Analysis (Solution)15m
Coding with Style2m
2 practice exercises
Reorder and Connect Tables30m
Module 3 Quiz30m
Week
4

Week 4

4 hours to complete

Case Study: AB Testing

4 hours to complete
10 videos (Total 72 min), 2 readings, 2 quizzes
10 videos
Statistics Refresher (Optional)8m
Test Assignments8m
Test Assignments (Solution)11m
Create a New Metric5m
Creating a New Metric (Solution)9m
Analyze Results7m
Analyzing Results (Solution)13m
Peer Review Overview3m
Course Summary1m
2 readings
Additional Thoughts for the Final Project5m
Additional Practice and Reading (Optional)10m
1 practice exercise
Prepared for the Final Project?10m

Reviews

TOP REVIEWS FROM DATA WRANGLING, ANALYSIS AND AB TESTING WITH SQL

View all reviews

About the Learn SQL Basics for Data Science Specialization

Learn SQL Basics for Data Science

Frequently Asked Questions

More questions? Visit the Learner Help Center.