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 part of the Learn SQL Basics for Data Science Specialization
About this Course
What you will learn
Identify a subset of data needed from a column or set of columns and write a SQL query to limit to those results.
Use SQL commands to filter, sort, and summarize data.
Create an analysis table from multiple queries using the UNION operator.
Manipulate strings, dates, & numeric data using functions to integrate data from different sources into fields with the correct format for analysis.
Skills you will gain
- Data Science
- Data Analysis
Syllabus - What you will learn from this course
Getting Started and Selecting & Retrieving Data with SQL
Filtering, Sorting, and Calculating Data with SQL
Subqueries and Joins in SQL
Modifying and Analyzing Data with SQL
- 5 stars73.60%
- 4 stars20.32%
- 3 stars3.42%
- 2 stars1.31%
- 1 star1.33%
TOP REVIEWS FROM SQL FOR DATA SCIENCE
Clear, well-paced explanations in each video. The final coding assignment was much harder than the quizzes along the way, but everything you need to know to complete it is technically in the videos.
Please Included examples while the instructor is teaching in the video lectures. The instructor is very talented in teaching but due to lack of examples in the video it downgrades the overall course.
This course provided the necessary knowledge to use SQL effectively in deriving insights from data stored in database management systems. The exercises and quizes helped reinforce lessons learned.
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.
About the Learn SQL Basics for Data Science Specialization
Frequently Asked Questions
When will I have access to the lectures and assignments?
What will I get if I subscribe to this Specialization?
Is financial aid available?
More questions? Visit the Learner Help Center.