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 lost track of what they can do with plain SQL. In this course, you will learn advanced concepts and techniques for analyzing data using SQL. You will obtain hands-on experience in producing descriptive statistics, breaking a large query into mu...
Course Content
Introduction
Basic SQL for Data Analysis
Descriptive Statistics
Grouping and Subtotals
Running and Cumulative Aggregation
Interpolation
4 Lessons
Binning
4 Lessons
Conclusion
1 Lesson
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. Educative‘s interactive, text-based lessons accelerate learning — no setup, downloads, or alt-tabbing required.
Learn faster and smarter with adaptive AI tools embedded in every Educative course.
Built-in assessments let you test your skills. Completion certificates let you show them off.