This Specialization is intended for a learner with no previous coding experience seeking to develop SQL query fluency. Through four progressively more difficult SQL projects with data science applications, you will cover topics such as SQL basics, data wrangling, SQL analysis, AB testing, distributed computing using Apache Spark, Delta Lake and more. These topics will prepare you to apply SQL creatively to analyze and explore data; demonstrate efficiency in writing queries; create data analysis datasets; conduct feature engineering, use SQL with other data analysis and machine learning toolsets; and use SQL with unstructured data sets.
Learn SQL Basics for Data Science Specialization
Give your career the gift of Coursera Plus with $160 off, billed annually. Save today.
Learn SQL Basics for Data Science Specialization
Instructors: Don Noxon
266,960 already enrolled
Included with 
Get in-depth knowledge of a subject
4.5
(10,344 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
Skills you'll gain
Details to know
Shareable certificate
Add to your LinkedIn profile
Taught in English
See how employees at top companies are mastering in-demand skills
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
Earn a career certificate
Add this credential to your LinkedIn profile, resume, or CV
Share it on social media and in your performance review
Specialization - 4 course series
SQL for Data Science
Course 115 hours4.6 (16,503 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 (961 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 38 hours4.4 (687 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 (229 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
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."
Explore more related skills
Career resources
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
This Specialization consists of 4 courses that could take anyone from 4-6 months to complete.
This Specialization is intended for the learner with no prior knowledge and will progress through the courses advancing their SQL skills.
We absolutely recommend you take the first course listed first and the Capstone project last, but courses two and three can be completed in either order.