Chevron Left
返回到 SQL for Data Science

SQL for Data Science, University of California, Davis

4.5
945 个评分
277 个审阅

课程信息

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

热门审阅

创建者 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

创建者 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!

筛选依据:

275 个审阅

创建者 Tomás Lickfold

Dec 11, 2018

The mistakes in the presentations and the massive ambiguity in the final assignment were a complete letdown for me. All in all, I did learn everything that was taught, but I wonder how much of that was made possible thanks to my previous experience in IT.

创建者 Tabish Faiyaz

Dec 11, 2018

Would be better if you could support MySQL,

PostgreSQL

创建者 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.

创建者 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.

创建者 Ganesh Lingam

Dec 05, 2018

E

创建者 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.

创建者 Shuchi Tripathi

Dec 03, 2018

Great course for beginners!

创建者 Manish Ranjan

Nov 30, 2018

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

创建者 David Samuel Friday

Nov 29, 2018

excellent experience

创建者 Rengalakshmi.B

Nov 29, 2018

The course was informative and good.