Save for later

SQL for Data Science

Learn SQL Basics 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 and may earn a commission when you buy through our links.

Get a Reminder

Send to:
Rating 4.4 based on 811 ratings
Length 5 weeks
Effort 4 weeks of study, 3-5 hours/week
Starts Jul 17 (44 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

Send to:

Similar Courses

What people are saying

easy to follow

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.

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

Easy to follow.

this is very interesting course Easy to follow.

Easy to follow, good explanations, perfect for busy professionals.

In general it was very useful and easy to follow lessons given by Sadie!

good course well it is good source for introduction only The course is easy to follow, well-explained and have enough hands-on to reinforce what we have learnt!

The first two weeks were easy to follow along with.

It was easy to follow and I learned a ton.

Great for beginners and easy to follow along.

Good course for a beginner easy to follow up I had already some experience with other databases and higher education on science and I founded it interesting enough, not very difficult, easy to follow, do not expect very challenging things.

The lessons and quizzes are well-organized and easy to follow, as well as give good food-for-thought questions to get the problem solving gears going.

Everything was fine and easy to follow.

Read more

highly recommend

Great course and experience.Suitable for all levels where content can be applied immediatelyHighly recommended!

I highly recommend this course for anyone who is interested in data science.

Highly recommend to others who never learn SQL before.

Highly recommend!

I highly recommend it to everyone.

I highly recommend this course.

great introduction course for SQL, devoted lecturer, good teaching style, sufficient exercises to practice, highly recommended!

I highly recommend it.

It helps a lot to my career IT's a great course for starters Highly recommended course!

Highly recommend Awesome training!

Highly recommended for those who want to start exploring SQL.

Good to Start with..:) Highly recommended for everyone who wants to know basic of SQL as well as use of SQL in data science.

I highly recommend taking this course for those who have little to no experience with SQL.

Read more

data scientist

Oriented for beginners, no prerequisites A great introduction to aggregating and extracting data from data tables with the data scientist as the intended audience.

The final assignment was very thorough and helped put together lots of focused questions you might encounter using SQL as a data scientist.

nice course The course helped me understand the basic concepts in SQL which are required to be a good data scientist.

Moreover I like how it relates to Data Scientists' context, and how it helps to understand Data Scientist's role and mindset.

Very help ful The course is simple and to the point, it teaches you the basics of data analysis as well how you can start thinking as a Data scientist.

I think it is a must have course for all Data Scientists.

I recommend this course to anyone who's just starting out (or aspiring) to be a Data Scientist.

=) Very clear walkthrough of important concepts in SQL and why use certain functions for certain tasks.=( Wish there were more practice questions so it's more interative.=( Also it would be great if there are more "real-life" SQL practices that involve solving for an actual question that you might encounter as a data scientist working for a tech company.Thanks so much for sharing this with us, Sadie!

Simple and straightforward introduction to SQL for business-oriented/frontend-facing end users (data analysts, data scientists).

I would expect a lot more tips and tricks and examples of real-life problems and how an actual data scientist would tackle them.

One of the answer choices is "A translation system for used to communicate with Data Scientists" You probably meant to write "A translation system used to communication with Data Scientists" (leaving out "for") Just figured you might want to know so you can change it before more people sign up for the course.

Excellent course for data scientists great beginner class and also teaches critical logic thinking, which is what most business want out of Analysis type of jobs or Data Science in general, something useful and actionable.

Read more

sql for data science

I'm not sure why it is called "SQL for Data Science" other than that is a catchy title.

Great course on SQL for Data science.

I took IBM's SQL for Data Science and I had a bad experience.

It's a good intro course to SQL for data science.

this course was excellent for basics in sql for data science, In the last part of the course I was expecting more advanced notions of SQL The best course to learn deeply SQL, lots of exercises, and practical quizz.

Would definitely recommend it to my collegues Great introduction to SQL for Data Science The course structure is so very well laid out that on reaching the final week, I am hungry to learn more and more concepts and practical uses of SQL.

The course is called "SQL for Data Science", yet I found very little in the way of applying SQL to data science.

Read more

great course for beginners

Great course for beginners very helpful course El curso fue muy básico.

Great course for beginners, very clear and instructor share useful tips.

Very easy to follow.Great course for beginners!

Coursera is good platform for beginners as well as people who work in industries.Right now I am planning to take another course in coursera.The course content and assignments are very well planned.Please convert subscription course into individual course Great course for beginners to get their hands on SQL.

This is a great course for beginners.

Great course for beginners and intermediate SQL writers.

Great course for beginners!

Read more

peer review

A few questions in the final peer review assignment were also very ambiguous.

Lot's of bugs in the assessment, lot's of incompleteness, teacher does not go deep in subjects, ends with a peer review letting you no guarantee it will ever be review, certainly not within the Free Week.

A good notes is necessary to attempt the final peer review assignment.

This is an outstanding course for people who are new to SQL Great course... Fast, clear and with interesting projects peer review is pretty useful.

Peer review assignment needs to be updated.

But it is short and there appears to be enough students to make the peer review of the final project possible in April 2019.

great experience with my instructor and University of California, Davis The Content of the course is good, quizzes are fine, but the final project is a total mess up, inconsistent and don't contain the course potential, so you won't be able to apply the knowledge by doing it The course was a great introduction to SQL and the peer reviewing process is a great initiative.

The peer review will be challenging but the learning will be all worth it.

Did not need to be a peer review assessment, most of the tests lacked creativity and could be automated.

The peer review component should just apply to the creative components that can be expanded.

I gained very good knowledge I'm totally new to SQL and even as a beginner I found these lessons to be way too slow, assignments were interesting but the questions of the peer review were very difficult to understand.

Read more

poorly worded

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.

However, the final project was very poorly worded, most of the businesses in one table were not in the other tables because they did a poor job of selecting records from these tables to set things up which makes joins very hard to do, and the rubric at times didn't make sense or didn't even have you grade a question that you spent a lot of time on.

poorly worded questions in the assignment.

Also the final assignment was really poorly worded so it could be difficult at times to understand what the questions were asking for.

Some portions of the final assignments are poorly worded and the mentors aren't active.

It is sometimes time consuming and the questions are in some cases poorly worded deriving in learners confusion ( a lot of discussions in the forums have been opened because of this matter).

The peer review assignment was very poorly worded and ambiguous.

Read more

real world

Learned core concepts that are helpful with real world examples.

Один из лучших курсов на платформе, очень много практики Execellent Good and systematic course settings, combining knowledge with real world practice.

I also think the course lacks some application in the real world.

More Practice sessions with real world complex SQL queries are requested, to build confidence for interviews and the like perfect The course is good for Data science.

I love the data scientist role play part, make me feel like I can apply what I learned here into real world business.

I really liked the integration of the chinook and yelp datasets in this course, as they give you a glimpse of what it is like in the real world.

Read more

my only

I give it three stars because I did learn a few things.I think my only recommendation is to add some more practise coding before the quiz available .

My only request for this course is that the topics go a little more in depth (explanation of more complex examples) and that there could be an optional video to watch where the instructor does the coding quizzes, and explains their reasoning behind the queries they create.

My only sticking point was in the final assignment.

This course covers many great issues.My only problem with this course is the way tackle SQL on the first 4 videos.

My only suggestion is having query results in the videos somehow.

My only beef with the course was that some of the questions in the graded quizzes weren't clearly written, and this gave me a lot of grief (thus, 4 stars).

Read more

longer than

Therefore it took way longer than the stated 2 hours.

wonderful The questions in the final assignment were quite difficult to understand and the overall course took longer than the estimated amount of hours.

However, the questions on the final are ambiguous and can be very challenging, and the final as a whole can take much longer than the anticipated 2 hours.

It took me way longer than it said it would and I had problems understanding a few things around it.

Read more

little bit

I would have loved a little bit more material, e.g.

___doge) Great course, although final peer-reviewed assignment seems a little bit odd.

In parallel, I solve hackerrank tasks and this course gave me everything to pass it easy.Really appreciate final peer-review assingment, it looks close to real-life analytics and was a little bit challenging for me.

The one thing I can think of that can be improved is the way the teacher is presenting the lessons, it is unfortunately a little bit monotonous.

Read more

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.

Rating 4.4 based on 811 ratings
Length 5 weeks
Effort 4 weeks of study, 3-5 hours/week
Starts Jul 17 (44 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