Chevron Left
Zurück zu SQL for Data Science

SQL for Data Science, University of California, Davis

4.5
(1,621 ratings)

Über diesen Kurs

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-Bewertungen

von MS

Mar 11, 2019

Great course i had a very good learning experience from this course and what i was expecting from this course i got that knowledge and i am very happy to take this course. thank you so much.

von 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

Filtern nach:

433 Bewertungen

von Hector

May 19, 2019

This is a comprehensive SQL course. It might take a bit more time to complete the assignments than stated by its creators.

von Saisha Monga

May 18, 2019

I personally found the course really helpful. I recently started working on SAS and this SQL course came in handy. I'm planning on taking a course on SAS now. I'd recommend this course to anyone who wants to get started with SQL, it's a pretty basic course.

von Dave Nair

May 18, 2019

This course is a great course for people new to SQL. No prior programming experience is necessary, and Sadie is very to-the-point while still being very welcoming and friendly. I highly recommend this course.

von Babajan Kannemadugu

May 17, 2019

It would be great helpful for the

von José Dávalos

May 16, 2019

This course is really interesting.

von Dileep Kumar

May 16, 2019

I really thank full, It was great learning experience...

von Marwan Daar

May 16, 2019

The lectures are littered with sloppy errors that haven't been fixed or acknowledged even after multiple people have pointed them out more than a year ago. Some of these errors seriously impede understanding and progress.

The narration is awkward and appears to have been written by someone other than the narrator.

Some of the assignment questions are terribly worded and mentors have provided inconsistent clarification on how to deal with some of these cases.

Many legitimate concerns that have been raised in the forums have not even been acknowledged let alone addressed by staff/mentors.

Nevertheless, the course at the very least does provide a reasonable structure, and the graded quizzes/assignment motivate students to achieve a certain level of mastery.

von

May 15, 2019

very good explaination for each topic and user interactive too

von Luis Enrique Cadenas Gil

May 14, 2019

Curso de muy alta calidad, videos y foros muy bien documentados.

von Gregory Buri

May 14, 2019

If I hadn't already been a little familiar with SQL before this I would have been pretty lost for a lot of this. A lot of the information presented could have used a little more details.

The quizzes often asked questions that involved material that wasn't in the course, as did the coding parts.

At the end of the day, I have had better experiences with some of the free courses available online (and learned more from them).