Chevron Left
Back to SQL for Data Science

SQL for Data Science, University of California, Davis

4.5
941 ratings
276 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:

273 Reviews

By Yi Wei

Dec 10, 2018

Strongly suggest adding more example code and its running result which will make more sense for beginner. And more exercise problems as current Quiz do not cover all the points in the lecture.

By Yifan Zhao

Dec 07, 2018

She's a horrible teacher as of explaining code. For the most time, she only shows the input and never mentions the output. And if you google it, most of the codes are from templates online that are not very illustrative. Also, many of the questions in quiz are irrelevant to what she taught, or the things she spent a lot of time on never appeared in the quiz. Terrible experience with this instructor.

By Ganesh Lingam

Dec 05, 2018

E

By Jose Ramirez

Dec 04, 2018

Very well expalined, intended mainly for anyone which does not have any prior understanding for either SQL language or data analysis.

By Shuchi Tripathi

Dec 03, 2018

Great course for beginners!

By Manish Ranjan

Nov 30, 2018

Good course. The peer assignments was a bit challenging hence most interesting as well.

By David Samuel Friday

Nov 29, 2018

excellent experience

By Rengalakshmi.B

Nov 29, 2018

The course was informative and good.

By Leo Urushibata

Nov 25, 2018

Great for complete beginners.

+) Video tutorials + coding practices in controlled, sandbox environment.

+) No need to install anything. You can complete everything in browser view.

-) Quiz and exam questions are poorly written; they are unclear and unhelpful.

-) Quizzes and exercises are also far an few between. You need more frequent exercises.

-) Nobody will answer your questions. But that's ok. You will still learn the fundamental concepts and you will pass the test.

Overall, this course is good as a very first step in a safe and clean environment. If you want something in a more real environment (say, integrate with Python), you will need to take another course.

By Elina Manandhar

Nov 23, 2018

The Course was really good and specially the Assignments getting tougher gradually and making us dive into the database for a deeper understanding.. I appreciate that.