INTERACTIVE COURSE

Practical Data Analysis with SQL

Beginner

30 Lessons

Certificate of Completion

144 Playgrounds

6 Quizzes

18 Illustrations

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 Contents

Introduction

1 Lesson

Introduction

Basic SQL for Data Analysis

8 Lessons

Anatomy of an SQL query Common Table Expressions Generating Data Exercise: Generate a Date Dimension Random Data

Show all 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

COURSE AUTHOR

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.