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

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.

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.

MV

4.0Reviewed Jul 19, 2020

Please Included examples while the instructor is teaching in the video lectures. The instructor is very talented in teaching but due to lack of examples in the video it downgrades the overall course.

PM

5.0Reviewed Sep 12, 2020

This is amazing course . Once you join this it gives complete information about SQL basics.To improve knowledge of creating databases it is very important course.I am glad to become part of these.

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.

SS

5.0Reviewed Mar 25, 2022

This is a great introductory course, highlights the most inportant things in syntax and speeds up from simple queries to complex joins... the best thing about this course are the coding assignments.

BG

4.0Reviewed Nov 10, 2019

Videos are a bit lengthy course could be shorter by 10-20% from a time perspective with the content staying the same. Overall good course for anyone that need to learn or to refresh their skills.

LG

4.0Reviewed Apr 9, 2018

Great course for beginners, very clear and instructor share useful tips. The only reason I don't give it 5 stars is because I think there could be more material related to date and time functions.

ME

5.0Reviewed Aug 22, 2020

This course was good because it teaches you many keywords that are used for practical application in the world of data science. I definitely feel more confident with SQL after finishing this course.

NC

5.0Reviewed Oct 18, 2020

I really liked the course, I learned too much. The explanation is clear, appropriate activities and very good traceability. I really enjoyed it, I will definitely apply what I learned in my career.

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