Back to SQL for Data Science
University of California, Davis

SQL for Data Science

As data collection has increased exponentially, so has the need for people skilled at using and interacting with data; to be able to think critically, and provide insights to make better decisions and optimize their businesses. This is a data scientist, “part mathematician, part computer scientist, and part trend spotter” (SAS Institute, Inc.). According to Glassdoor, being a data scientist is the best job in America; with a median base salary of $110,000 and thousands of job openings at a time. The skills necessary to be a good data scientist include being able to retrieve and work with data, and to do that you need to be well versed in SQL, the standard language for communicating with database systems. 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. You will begin to ask the right questions and come up with good answers to deliver valuable insights for your organization. This course starts with the basics and assumes you do not have any knowledge or skills in SQL. It will build on that foundation and gradually have you write both simple and complex queries to help you select data from tables. You'll start to work with different types of data like strings and numbers and discuss methods to filter and pare down your results. You will create new tables and be able to move data into them. You will learn common operators and how to combine the data. You will use case statements and concepts like data governance and profiling. You will discuss topics on data, and practice using real-world programming assignments. You will interpret the structure, meaning, and relationships in source data and use SQL as a professional to shape your data for targeted analysis purposes. Although we do not have any specific prerequisites or software requirements to take this course, a simple text editor is recommended for the final project. So what are you waiting for? This is your first step in landing a job in the best occupation in the US and soon the world!

Status: Data Manipulation
Status: Data Modeling
BeginnerCourse16 hours

Featured reviews

SM

4.0Reviewed Mar 15, 2020

Good course for beginners.- classes are fine- quizzes evaluate quite well your understanding I think- the final assessment contains plenty of VERY ambiguous questions and I think it should be reworked

YL

5.0Reviewed Apr 18, 2021

Exactly what I signed up for. Basic understanding and syntax learning. For anyone looking to further their sql writing, I believe this course and the rest of the curriculum will do perfectly fine

AL

5.0Reviewed Aug 21, 2020

A comprehensive course that covers major aspects of query building and retrieval in a management system. The topics were delivered well and the materials/assignments were relevant for skill-building.

NG

4.0Reviewed Aug 27, 2020

The course is nice but I suppose the PowerPoint presentation that accompanies it could use some effects to show us the clauses one by one, as they are spoke. That would make understanding them easier.

AT

5.0Reviewed Nov 17, 2020

Well it was a short course, the assignments are a little bit repetitive (mostly in the last). The course reviews every 'practical' aspects of SQL, how to assemble the bricks while writing queries,...

YP

4.0Reviewed Oct 9, 2022

R​eally good course with intresting final task. In any situation will be shown "common structure of querry" and at most cases real-life examples. Will be great if this examples appear in every case

AV

5.0Reviewed Sep 11, 2021

This course provided the necessary knowledge to use SQL effectively in deriving insights from data stored in database management systems. The exercises and quizes helped reinforce lessons learned.

KF

5.0Reviewed Apr 1, 2023

I loved the practices. I learned alot But I think some of them had mistakes... The online visual studio code never worked for me! It might be good to make a video that explains how to work with it.

KD

5.0Reviewed Mar 19, 2021

this was more challenging than I expected, the assignments will definitely make you think. A good intro to SQL. If you have no background reading the supplementary articles will be very helpful

DA

5.0Reviewed Jun 21, 2021

Thank you for the material that was presented well and clearly. I got to know better how to use SQL for data science. Hopefully, by learning this, I can implement it in the future as a Data Analyst.

N

5.0Reviewed May 24, 2023

It waas one of the best courses I attended in Coursera. I learned a lot in a short period of time, and it has great hands-on exercises. Thank you very much for preparing a useful course like this!

LO

4.0Reviewed Sep 11, 2018

Did not need to be a peer review assessment, most of the tests lacked creativity and could be automated. The peer review component should just apply to the creative components that can be expanded.

All reviews

Showing: 20 of 4,428

lkflrs
2.0
Reviewed Apr 30, 2019
Laura Winzen
1.0
Reviewed Apr 30, 2019
Leo Urushibata
3.0
Reviewed Nov 25, 2018
Luca Tschannen
2.0
Reviewed Mar 18, 2019
Marwan Daar
2.0
Reviewed May 16, 2019
André Alessi
2.0
Reviewed Apr 30, 2019
Yifan Zhao
2.0
Reviewed Dec 6, 2018
Finn O'Shea
2.0
Reviewed Apr 6, 2019
Chris Spangler
1.0
Reviewed Jan 30, 2018
Felipe Fittipaldi
1.0
Reviewed Jan 13, 2021
Chutian Zhou
4.0
Reviewed Jan 17, 2019
Gary Burrows
3.0
Reviewed Nov 15, 2018
Tyler Golson
2.0
Reviewed Feb 4, 2020
Conor MacCarthy
2.0
Reviewed Jul 9, 2019
Jan-Michael Perez
5.0
Reviewed Apr 6, 2020
Miguel Meza
1.0
Reviewed Mar 31, 2019
Andrea Lebon
5.0
Reviewed Aug 22, 2020
veronica gonzalez
2.0
Reviewed Feb 19, 2018
Mugdha hassan
1.0
Reviewed Jun 27, 2020
MONOJIT PAL
5.0
Reviewed Jul 18, 2020