University of California, Davis

SQL for Data Science

Sadie St. Lawrence

Instructor: Sadie St. Lawrence

628,092 already enrolled

Included withCoursera Plus

Gain insight into a topic and learn the fundamentals.
4.6

(16,467 reviews)

Beginner level
No prior experience required
Flexible schedule
Approx. 15 hours
Learn at your own pace
91%
Most learners liked this course
Gain insight into a topic and learn the fundamentals.
4.6

(16,467 reviews)

Beginner level
No prior experience required
Flexible schedule
Approx. 15 hours
Learn at your own pace
91%
Most learners liked this course

What you'll learn

  • Identify a subset of data needed from a column or set of columns and write a SQL query to limit to those results.

  • Use SQL commands to filter, sort, and summarize data.

  • Create an analysis table from multiple queries using the UNION operator.

  • Manipulate strings, dates, & numeric data using functions to integrate data from different sources into fields with the correct format for analysis.

Details to know

Earn a career certificate

Add to your LinkedIn profile

Assessments

14 assignments

Taught in English

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 define SQL and discuss how SQL differs from other computer languages. You will be able to compare and contrast the roles of a database administrator and a data scientist, and explain the differences between one-to-one, one-to-many, and many-to-many relationships with databases. You will be able to use the SELECT statement and talk about some basic syntax rules. You will be able to add comments in your code and synthesize its importance.

What's included

11 videos3 readings4 assignments2 discussion prompts

In this module, you will be able to use several more new clauses and operators including WHERE, BETWEEN, IN, OR, NOT, LIKE, ORDER BY, and GROUP BY. You will be able to use the wildcard function to search for more specific or parts of records, including their advantages and disadvantages, and how best to use them. You will be able to discuss how to use basic math operators, as well as aggregate functions like AVERAGE, COUNT, MAX, MIN, and others to begin analyzing our data.

What's included

9 videos1 reading3 assignments

In this module, you will be able to discuss subqueries, including their advantages and disadvantages, and when to use them. You will be able to recall the concept of a key field and discuss how these help us link data together with JOINs. You will be able to identify and define several types of JOINs, including the Cartesian join, an inner join, left and right joins, full outer joins, and a self join. You will be able to use aliases and pre-qualifiers to make your SQL code cleaner and efficient.

What's included

10 videos2 readings3 assignments1 discussion prompt

In this module, you will be able to discuss how to modify strings by concatenating, trimming, changing the case, and using the substring function. You will be able to discuss the date and time strings specifically. You will be able to use case statements and finish this module by discussing data governance and profiling. You will also be able to apply fundamental principles when using SQL for data science. You'll be able to use tips and tricks to apply SQL in a data science context.

What's included

11 videos3 readings4 assignments1 discussion prompt

Instructor

Instructor ratings
4.7 (4,644 ratings)
Sadie St. Lawrence
University of California, Davis
4 Courses640,326 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 16467

4.6

16,467 reviews

  • 5 stars

    73.71%

  • 4 stars

    19.89%

  • 3 stars

    3.49%

  • 2 stars

    1.42%

  • 1 star

    1.47%

JM
5

Reviewed on Feb 14, 2023

NK
5

Reviewed on Oct 5, 2022

AM
4

Reviewed on Sep 23, 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