Chevron Left
返回到 SQL for Data Science

學生對 加州大学戴维斯分校 提供的 SQL for Data Science 的評價和反饋

4.6
10,128 個評分
2,636 條評論

課程概述

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

熱門審閱

JP
2020年4月5日

This course has really helped with optimizing queries that I work with everyday, enhancing my understanding of RDBMS, joins, analyzing and structuring exactly what you need and yielding those results.

AL
2020年8月21日

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.

篩選依據:

2526 - SQL for Data Science 的 2550 個評論(共 2,655 個)

創建者 Daniel E

2020年1月4日

Good content but the questions are badly worded and need updating.

創建者 Melissa V

2018年4月28日

Need to take a more in-depth class to fully understand this class.

創建者 Matt E

2018年4月1日

You can learn this stuff on your own. You don't need a course.

創建者 Priyanshu V

2020年7月31日

Some topic is not cover like constraints alter modify default

創建者 Tim S

2020年7月8日

Quite easy. The peer-reviewed assignment is also very easy.

創建者 liqi x

2019年12月24日

not enough teaching examples, could be tough for beginner

創建者 Ashish D

2021年6月29日

Explanations could be improved with the help of examples

創建者 TANMAY R C

2020年6月25日

Very fast and high level for a person who knows nothing

創建者 Saulo G d M S

2020年7月27日

A really good course, but the forum isn't that great.

創建者 SAKET M

2021年2月24日

Could be more better. You could have taught more SQL

創建者 Phillipe S S R

2018年1月3日

Quiz and graded materials not available for free.

創建者 Hari G

2019年12月11日

Too much theory and very little or no practice

創建者 Yến Đ H

2021年7月5日

The course is basically theoretical.

創建者 dager6

2018年5月4日

Good general basic introductions.

創建者 Gaoge Z

2021年1月4日

Could show results in demos.

創建者 Fabian M

2021年3月16日

Too little practice

創建者 Renuka G

2019年12月20日

good one

創建者 318126512050 S R B

2021年6月21日

good

創建者 Carl D A

2020年8月13日

good

創建者 Krishna G

2020年6月10日

good

創建者 Chen G

2019年2月15日

Soso

創建者 Gergely H

2021年7月30日

Y

創建者 renas c

2021年3月12日

.

創建者 Manas d

2020年9月19日

.

創建者 max

2021年3月20日

lessons are not well structured, it would be so much more easy to explain sql

interactively by explainging a concept of sql, then creating a query highlighting what is particularly important of that query and then seeing the result of that querry. Instead it is done in old fashioned power point. First a set of concepts, then some additional information and then application,

E-learning allows for a much more interwoven structure, that might be more initial work for the creator of the course but it clearly would add a lot of value to the students.

Sometimes the course misses to explaing relevant detail.

For example in the last weeks lecture about Date, we learned that we could do operations like

Date('now') - DateColum, and this would return the time difference but only in years, not days, not hours. It would be intersting to know why that is.

The last assignment