Set Reminder Save for later

SQL for Data Science

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!

Get Details and Enroll Now

OpenCourser is an affiliate partner of Coursera.

Get a Reminder

Not ready to enroll yet? We'll send you an email reminder for this course

Send to:

Coursera

&

University of California, Davis

Rating 4.0 based on 142 ratings
Length 5 weeks
Effort 4 weeks of study, 3-5 hours/week
Starts Mar 4 (3 weeks ago)
Cost $49
From University of California, Davis via Coursera
Instructor Sadie St. Lawrence
Download Videos On all desktop and mobile devices
Language English
Subjects Data Science Mathematics
Tags Data Science Data Analysis Math And Logic

Get a Reminder

Get an email reminder about this course

Send to:

What people are saying

We analyzed reviews for this course to surface learners' thoughts about it

final assignment in 12 reviews

Normally, I get bore when the instructor explain many things and after I got it, she/he continues explaining.I loved that the instructor goes right to the point and does not waste time repeating the same thing again and again.The only piece I was not happy about was the final assignment.

Class work should be similar to the Final Assignment to cultivate thinking.

The final assignment is so horrendously worded and set up that much if it is unanswerable.

The final assignment is very confusing and sometimes it is hard to know what you are being asked.

The final assignment can be one of great effort or minimal effort depending on the individuals interest in trying out complex queries that are out of their comfort zone, but both sides of the coin end up with the same certificate in hand.

Final assignment is too bad, simple queries for getting the info we are being asked to look, repetitive code to be implemented, a lot of ambiguity in the description of some points.

The final assignment was tricky in it's wordings.

Horribly designed questions in the final assignment.

data science in 11 reviews

Nothing is taught about how its used for data science Overall a good course for the starters in SQL in Dtaa Science filed, however I felt it could be some more hands-on oriented with some more examples, and it was mainly of lecture contents, rather things could be shown visually for a better understanding.

Really good first step in data science.

But I did not see much connection between sql and data science in the course.

Having to update a .txt file (which is notoriously difficult to format) and review others' .txt files makes for a bumpy experience for the final assignment This course has great potential, but as of February 2018, it is still not fully fledged out: the lectures focus on general SQL examples with data science mostly in the background.

The part that I found the most relevant with regards to data science was the final peer-reviewed project.

Sadie is a great instructor, clear presenter and holds immense knowledge for data science!

Thanks for your courses as it help me understand SQL and data science as whole in a better way than I ever could have.I would recommend people join it.

Greetings from Peru :) Brilliant lecture very easy to understand amazing pres Basic overview of SQL querying - not necessarily data science specific.

final project in 6 reviews

Final project needs some work and this course will be top notch!!

There is not any practice during the course except for the quizes and the final project.

Also, some questions of the final project were not clear enough, while reviewing I found out that people understood different things.

I spent far more time on the project than I thought necessary.So great course, terrible final project.

Very good Only reason I did not give this class 5 stars is because the final project is horribly organized and very difficult to through - it doesn't test your ability to use SQL or solve data science problems, but your ability to figure out what the instructor wants.

However, the final project has some major problems.

Moreover, a large part of the final project is data analysis that you would never conduct in SQL - what would take a few lines of code in Python becomes cumbersome and frustrating and incomplete in SQL.

The final project is very difficult and seems geared more towards advanced SQL users.

easy to follow in 5 reviews

This course was very good, easy to follow and understand.

Clearly-explained, organised lecture flow and materials, easy to follow, not burdened with great details for beginners while emphases are made on crucial aspects of database management with SQL.

easy to follow Good overall course, I like the order of topics introduced and they're application to real world events.

The first few weeks were very informative and easy to follow, however week 3 and week 4 seemed disjointed.

Easy to follow.

understanding of sql in 5 reviews

Felt a little lost at first, but feel like I got a great basic understanding of SQL An amazing course which brings the fundamental for SQL.

Great Course to start with.Gives a good understanding of SQL on one side en working with databases on the other.A syllabus of al the code examples in the video's should behelpfull Need to take a more in-depth class to fully understand this class.

the course is great but the final assignment is annoying and not serious Great course for getting a good general understanding of SQL.

On the other hand, if you can make it through the final, you will come out with a great introductory understanding of SQL by the end of the course.

I enjoyed the course and learned a basic understanding of SQL.

poorly worded in 5 reviews

Assignments were poorly worded and clearly not thought out properly.

Internalizing information would be much more efficient if there was more than just seeing results of queries and answering poorly worded questions.

The lectures are fantastic but the final course project was a nightmare that was poorly worded so that you had to spend a long time trying to figure out what the questions meant before you could attempt to answer them.

poorly worded questions in the assignment.

Careers

An overview of related careers and their average salaries in the US. Bars indicate income percentile.

Data Scientist - Big Data $68k

Data Review Scientist $81k

Data Scientist 1 3 $86k

Data Scientist - Data Curation $92k

Data Scientist 2 3 $99k

Energy Data Scientist $99k

Data Scientist 3 4 $99k

Data Scientist - P&C $102k

Data Scientist / Data Visualization $107k

Data Scientist 1 2 $109k

Research Scientist / Data Scientist $117k

Data Scientist, IT $156k

Write a review

Your opinion matters. Tell us what you think.

Coursera

&

University of California, Davis

Rating 4.0 based on 142 ratings
Length 5 weeks
Effort 4 weeks of study, 3-5 hours/week
Starts Mar 4 (3 weeks ago)
Cost $49
From University of California, Davis via Coursera
Instructor Sadie St. Lawrence
Download Videos On all desktop and mobile devices
Language English
Subjects Data Science Mathematics
Tags Data Science Data Analysis Math And Logic

Similar Courses

Sorted by relevance

Like this course?

Here's what to do next:

  • Save this course for later
  • Get more details from the course provider
  • Enroll in this course
Enroll Now