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

Learn SQL Basics for Data Science Specialization

Taught in English

Some content may not be translated

Don Noxon
Conor Murphy
Katrina Glaeser Poole

Instructors: Don Noxon

242,903 already enrolled

Included with Coursera Plus

Specialization - 4 course series

Get in-depth knowledge of a subject

4.5

(9,859 reviews)

Beginner level
No prior experience required
2 months at 10 hours a week
Flexible schedule
Learn at your own pace

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

  • Use the collaborative Databricks workspace and create an end-to-end pipeline that reads data, transforms it, and saves the result

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

Details to know

Shareable certificate

Add to your LinkedIn profile

Specialization - 4 course series

Get in-depth knowledge of a subject

4.5

(9,859 reviews)

Beginner level
No prior experience required
2 months at 10 hours a week
Flexible schedule
Learn at your own pace

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

Placeholder

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
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

Specialization - 4 course series

SQL for Data Science

Course 114 hours4.6 (15,976 ratings)

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

Category: Data Science
Category: Data Analysis
Category: Sqlite
Category: SQL

Data Wrangling, Analysis and AB Testing with SQL

Course 215 hours3.3 (921 ratings)

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

Category: Query String
Category: Predictive Analytics
Category: Data Analysis
Category: SQL
Category: A/B Testing

Distributed Computing with Spark SQL

Course 313 hours4.5 (659 ratings)

What you'll learn

  • Use the collaborative Databricks workspace to write scalable Spark SQL code that executes against a cluster of machines

  • Inspect the Spark UI to analyze query performance and identify bottlenecks

  • Create an end-to-end pipeline that reads data, transforms it, and saves the result

  • Build a medallion (bronze, silver, gold) lakehouse architecture with Delta Lake to ensure the reliability, scalability, and performance of your data

Skills you'll gain

Category: Data Science
Category: SQL
Category: Apache Spark
Category: Delta Lake

SQL for Data Science Capstone Project

Course 435 hours4.2 (219 ratings)

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

Category: Data Analysis
Category: creating metrics
Category: Presentation Skills
Category: SQL
Category: Exploratory Data Analysis

Instructors

Don Noxon
University of California, Davis
1 Course35,114 learners

Offered by

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

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