University of California, Davis
Learn SQL Basics for Data Science Specialization
University of California, Davis

Learn SQL Basics for Data Science Specialization

Don Noxon
Katrina Glaeser Poole
Sadie St. Lawrence

Instructors: Don Noxon

Included with Coursera Plus

Get in-depth knowledge of a subject

(10,379 reviews)

Beginner level
No prior experience required
1 month at 10 hours a week
Flexible schedule
Earn a career credential
Share your expertise with employers
Get in-depth knowledge of a subject

(10,379 reviews)

Beginner level
No prior experience required
1 month at 10 hours a week
Flexible schedule
Earn a career credential
Share your expertise with employers

What you'll learn

  • Use SQL commands to filter, sort, & summarize data; manipulate strings, dates, & numerical data from different sources for analysis

  • Assess and create datasets to solve your business questions and problems using SQL

  • Develop a project proposal & select your data, perform statistical analysis & develop metrics, and present your findings & make recommendations

Overview

What’s included

Shareable certificate

Add to your LinkedIn profile

Taught in English
Recently updated!

August 2025

23 practice exercises

Advance your subject-matter expertise

  • Learn in-demand skills from university and industry experts
  • Master a subject or tool with hands-on projects
  • Develop a deep understanding of key concepts
  • Earn a career certificate from University of California, Davis

Specialization - 3 course series

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.

Skills you'll gain

SQL, Data Governance, Query Languages, Relational Databases, Data Quality, Data Analysis, Database Design, Data Modeling, Data Manipulation, Data Transformation, and Data Science

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

Skills you'll gain

SQL, Business Metrics, Exploratory Data Analysis, JSON, Data Analysis, Data Transformation, Forecasting, Complex Problem Solving, Business Reporting, Data Visualization, Debugging, Predictive Analytics, Data Quality, and Data Presentation

What you'll learn

  • Develop a project proposal and select your data

  • Perform descriptive statistics as part of your exploratory analysis

  • Develop metrics and perform advanced techniques in SQL

  • Present your findings and make recommendations

Skills you'll gain

Data Modeling, Target Audience, Descriptive Statistics, Business Analytics, Exploratory Data Analysis, Data Storytelling, Peer Review, Presentations, Text Mining, Proposal Development, Data Manipulation, Performance Metric, SQL, Data Science, Data Analysis, and Statistical Analysis

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.

Instructors

Don Noxon
University of California, Davis
1 Course41,079 learners
Katrina Glaeser Poole
University of California, Davis
1 Course80,665 learners

Offered by

Compare with similar products

Rating
Level
Skills
Tools
Last updated
Number of practice exercises
Degree eligibility
Part of Coursera Plus

You might also like

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."
Coursera Plus

Open new doors with Coursera Plus

Unlimited access to 10,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