Dashboards and alarms SQL alarms with threshold

245. SQL alarms with threshold

This lesson is based on theLive dataset.

Monitoring and sophisticated alarms is a big topic itself (“monitoringhabit.com” 🤔 😆) and we need to start somewhere. The most basic alarm simply monitors that a specific metric is always 0 (for example, error rate) or more than 0 (signup rate).

☝ Alarms themselves can brake or have wrong queries, so it’s not a silver bullet solution. I’d say it’s a good example of the 80/20 rule in action – setting up SQL alarms is definitely way less than 20% of our time dealing with monitoring, but it for sure covers 80% of possible errors.

In this lesson, let’s...

“well worth the money”
Sign up and check out 36 free lessons and exercises.

Anatoli Makarevich, author of SQL Habit About SQL Habit

Hi, it’s Anatoli, the author of SQL Habit. 👋

SQL Habit is a course (or, as some of the students say, “business simulator”). It’s based on a story of a fictional startup called Bindle. You’ll play a role of their Data Analyst 📊 and solve real-life challenges from Business, Marketing, and Product Management.

SQL Habit course is made of bite-sized lessons (you’re looking at one atm) and exercises. They always have a real-life setting and detailed explanations. You can immediately apply everything you’ve learned at work. 🚀

“well worth the money”

Fluent in SQL in a month

Master Data Analysis with SQL with real life examples from Product Management, Marketing, Finance and more.
-- Type your query here, for example this one -- lists all records from users table: SELECT * FROM users
Loading chart... ⏳
Previous lesson: SQL alarms basics
Next lesson: Notes on anomaly detection