Chevron Left
Volver a SQL for Data Science

SQL for Data Science, University of California, Davis

4.5
962 calificaciones
284 revisiones

Acerca de este Curso

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

Principales revisiones

por 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

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

Filtrar por:

280 revisiones

por Dane A. Pascoe

Dec 14, 2018

Mostly good- the week with joins was rough (made too many conceptual leaps, didn't make sense with prior course knowledge).

por Eric Vallee

Dec 13, 2018

Some glitchy issues with the quizzes, etc. and some funky results in the rubric for the assignment. However, overall quite useful!

por Márcio Angelo Bezerra de Lira

Dec 13, 2018

Excelente!

por Sergio Gonzalez Catalan

Dec 13, 2018

Loved this course. Easy to follow videos, they go straight to the point and you can practice queries right away from the first lesson. Gradually increases in difficulty and you end up doing a very interesting and helpfull assingment. I fell I earned all the basics in SQL.

por Mohamed Affissou Achirou

Dec 12, 2018

Great course. Thank you very much !!

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

por Tabish Faiyaz

Dec 11, 2018

Would be better if you could support MySQL,

PostgreSQL

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

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

por Ganesh Lingam

Dec 05, 2018

E