author-cover
INTERACTIVE COURSE

Practical Data Analysis with SQL

Beginner

30 Lessons

9h

Certificate of Completion

author-cover
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 Content

1

Introduction

1 Lesson

2

Basic SQL for Data Analysis

8 Lessons

Show all 8 lessons
3

Descriptive Statistics

3 Lessons

4

Grouping and Subtotals

4 Lessons

5

Running and Cumulative Aggregation

5 Lessons

6

Interpolation

4 Lessons

7

Binning

4 Lessons

8

Conclusion

1 Lesson

COURSE AUTHOR

Show License and Attributions

Show License and Attributions

How You'll Learn

Hands-on Coding Environments

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.

2x Faster Than Videos

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.

No Set-up Required

Start learning immediately instead of fiddling with SDKs and IDEs. It‘s all on the cloud.

Progress You Can Show

Built-in assessments let you test your skills. Completion certificates let you show them off.