Simple Anomaly Detection using SQL

Course Overview

Learn how to identify anomalies in your data using SQL. Understand how to apply mathematical concepts such as mean, standard deviation, and z-score to detect when an anomaly occurred in your data and how to investigate past data to improve and refine the model.

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.

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.

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.

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.

Course Contents

Hide All

Hide All Lessons

1. Detecting Anomalies

Introduction

What are Anomalies?

Understanding Z-score

Optimizing Z-score

Quiz 1

2. Analyzing A Server Log

Getting a Sense of the Data

Preparing the Data

Identifying Anomalies

Quiz 2

3. Backtesting

Finding Past Anomalies

Adding Thresholds

Eliminating Repeating Alerts

Experiment with Different Values

Quiz 3

4. Improving Accuracy

Weighted Mean

Median

Other Methods

Conclusion

Quiz 4