Chevron Left
Back to SQL for Data Science

SQL for Data Science, University of California, Davis

4.5
1,224 ratings
347 reviews

About this Course

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

Top reviews

By NP

Jan 07, 2018

A nice course to get introduced to writing SQL queries in Data science. Provides hands on exercises that boost confidence. Genuinely appreciate the ease with which SQL topics are covered

By GL

May 03, 2018

This was an amazing course. I learned so much practical and application skills from the course. The lectures are great, as our the assignments and tests.\n\nThank you for a great time!

Filter by:

342 Reviews

By Eric Mehner

Feb 19, 2019

Overall I think the course was pretty good. I think a lot of sections could have used more examples, especially of queries that combined several different types of clauses. There were also too many "choose the better answer" type questions in the weekly quizzes with more than one correct answer. Finally, the wording on many of the final assignment questions was terribly unclear. There are dozens of posts and questions about these on the forums. Ironing out these deficiencies would really help improve the overall course.

By Sarthak Singh Tomar

Feb 18, 2019

Course is really very good. Content is well organised, takes you through the concepts. Excellently taught.

By Roshni Ganeshram

Feb 16, 2019

Excellent course. But could have specified more on DML or adding data into table as well

By Chen Guanyu

Feb 16, 2019

Soso

By ZHUXINGWEN

Feb 14, 2019

very usefel

By Arslan Munir

Feb 14, 2019

A good course. this increase my knowledge of SQL which helpful for me in my professional career

By Chiara Larraine Gerona Reyes

Feb 13, 2019

Very well discussed. Thanks a lot

By Sebastian Plaza Ponte

Feb 12, 2019

excelent for beginners!!

By Sriraj K

Feb 10, 2019

Some if the query running environments were not working on an iPAD. So it was very difficult to complete get answers. Otherwise this course is good.

By Doru Bogdan

Feb 10, 2019

The course is super !