We may earn an affiliate commission when you visit our partners.

Learn SQL Basics for Data Science

Sadie St. Lawrence, Brooke Wenig, Conor Murphy, Don Noxon, and Katrina Glaeser Poole

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.

Enroll now

Or subscribe to Coursera Plus

And get unlimited access to Coursera

Help others find Specialization from Coursera by sharing it with your friends and followers:

Facebook

Copy Link

What's inside

Three courses

SQL for Data Science

(16 hours)

As data collection has increased exponentially, the need for people skilled at using and interacting with data has also increased. This course is designed to give you a primer in the fundamentals of SQL and working with data so that you can begin analyzing it for data science purposes.

View more details for this course

Data Wrangling, Analysis and AB Testing with SQL

(15 hours)

This course applies SQL skills to data science inquiry case studies. We'll learn to convert timestamps, perform optimal JOINs, clean data, and analyze data per segment. We'll also describe how to convert a query into a scheduled job, insert data into a date partition, and engineer a feature from raw data. These skills provide the framework for performing the analysis of an AB test.

View more details for this course

SQL for Data Science Capstone Project

Data science demands SQL skills. This course provides a foundation in applying SQL skills to analyze data and solve real business problems.

View more details for this course

Learning objectives

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

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

Save this collection

Create your own learning path. Save this collection to your list so you can find it easily later.

Save

Time

2700 hours

Via

Coursera

Institution

University of California, Davis

Instructors

Sadie St. Lawrence

Brooke Wenig

Conor Murphy

Don Noxon

Katrina Glaeser Poole

Language

English

Transcripts

Bahasa Indonesia Svenska Türkçe آذربایجان دیلی Español हिंदी 日本語 қазақша فارسی magyar nyelv Polski العربية Français বাংলা українська мова 中文 Ελληνικά Italiano Português tiếng Việt Nederlands 한국어 Deutsch پښتو اُردُو, Pусский ไทย

Learn SQL Basics for Data Science

Share

What's inside

Three courses

SQL for Data Science

Data Wrangling, Analysis and AB Testing with SQL

SQL for Data Science Capstone Project

Learning objectives

Save this collection