University of California, Davis
Data Wrangling, Analysis and AB Testing with SQL
University of California, Davis

Data Wrangling, Analysis and AB Testing with SQL

This course is part of Learn SQL Basics for Data Science Specialization

Taught in English

Some content may not be translated

64,606 already enrolled

Included with Coursera Plus

Course

Gain insight into a topic and learn the fundamentals

3.3

(931 reviews)

|

80%

Intermediate level

Recommended experience

15 hours (approximately)
Flexible schedule
Learn at your own pace

What you'll 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

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

9 quizzes

Course

Gain insight into a topic and learn the fundamentals

3.3

(931 reviews)

|

80%

Intermediate level

Recommended experience

15 hours (approximately)
Flexible schedule
Learn at your own pace

See how employees at top companies are mastering in-demand skills

Placeholder

Build your subject-matter expertise

This course is part of the Learn SQL Basics for Data Science Specialization
When you enroll in this course, you'll also be enrolled in this Specialization.
  • Learn new concepts from industry experts
  • Gain a foundational understanding of a subject or tool
  • Develop job-relevant skills with hands-on projects
  • Earn a shareable career certificate
Placeholder
Placeholder

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV

Share it on social media and in your performance review

Placeholder

There are 4 modules in this course

In this module, you will be able to create trustworthy analysis from a new set of data. You will be able to coalesce some nulls and identify unreliable data and discover reasons why data might be missing. You will also be able to answer ambiguous questions by defining new metrics.

What's included

12 videos3 readings2 quizzes6 discussion prompts

In this module, you will be able to name the main the categories of data types. You will be able to explain how the unfiltered data can be manipulated into a table where you can conduct data analysis. You will be able to discuss why a data warehouse is separate from a production database, and you will be able to use the tools you learned to create your own trustworthy tables.

What's included

10 videos4 quizzes

In this module, you will be able to map out your joins and be able to highlight the level of detail needed for different kinds of questions. You will be able to practice answering data questions, which should help you feel ready to get asked a whole slough of questions, vague questions, ambiguous questions, or even poorly worded questions. Finally, you will develop a strategy for answering all those questions using data.

What's included

11 videos2 quizzes4 discussion prompts

In this module, you will be able to use your SQL skills to set up a basic AB testing system. You will be able to apply hypothesis testing to prove or disprove a hypothesis about how user behavior changed. You will be able to test and interpret the results using a metric or metrics that are tied directly to some business metrics. You will be able to test your SQL skills and give you the base experience you need to learn anything more complicated in terms of AB testing in the future.

What's included

10 videos2 readings1 quiz1 peer review4 discussion prompts

Instructor

Instructor ratings
3.2 (278 ratings)
Katrina Glaeser Poole
University of California, Davis
1 Course64,606 learners

Offered by

Recommended if you're interested in Data Analysis

Why people choose Coursera for their career

Felipe M.
Learner since 2018
"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."
Jennifer J.
Learner since 2020
"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."
Larry W.
Learner since 2021
"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."
Chaitanya A.
"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Learner reviews

Showing 3 of 931

3.3

931 reviews

  • 5 stars

    33.01%

  • 4 stars

    16.45%

  • 3 stars

    16.45%

  • 2 stars

    16.02%

  • 1 star

    18.05%

NM
5

Reviewed on Jun 4, 2021

AR
5

Reviewed on Jun 29, 2021

AA
5

Reviewed on May 7, 2020

New to Data Analysis? Start here.

Placeholder

Open new doors with Coursera Plus

Unlimited access to 7,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription

Advance your career with an online degree

Earn a degree from world-class universities - 100% online

Join over 3,400 global companies that choose Coursera for Business

Upskill your employees to excel in the digital economy

Frequently asked questions