Practical Data Analysis with SQL
Beginner
30 Lessons
9h
Certificate of Completion
Takeaway Skills
Familiarity with advanced concepts and techniques for analyzing data using SQL
The ability to generate random data for training and benchmarking
Familiarity with datasets through descriptive statistics and histograms
Working knowledge of binning techniques and time series analysis
The ability to produce cumulative aggregation, subtotals, cubes, pivot tables, and data summaries for analysis
The ability to clean and prepare data with interpolation and linear regression
Course Overview
SQL databases have been around since the 1970s. Some of the smartest people in the world worked on making it easy to slice, dice, fetch and manipulate data quickly and efficiently. SQL databases have come such a long way that many developers and data scientists have...Show More
Course Content
Introduction
1 Lesson
Basic SQL for Data Analysis
8 Lessons
Descriptive Statistics
3 Lessons
Grouping and Subtotals
4 Lessons
Running and Cumulative Aggregation
5 Lessons
Interpolation
4 Lessons
Binning
4 Lessons
Conclusion
1 Lesson
Show License and Attributions
Show License and Attributions
How You'll Learn
You don’t get better at swimming by watching others. Coding is no different. Practice as you learn with live code environments inside your browser.
Videos are holding you back. The average video tutorial is spoken at 150 words per minute, while you can read at 250. That‘s why our courses are text-based.
Start learning immediately instead of fiddling with SDKs and IDEs. It‘s all on the cloud.
Built-in assessments let you test your skills. Completion certificates let you show them off.