IT & DevOps Analytics

Uptime, MTTR, incident trends.
The SQL IT analysts run for SRE and security.

Incident MTTR, deploy frequency, change-failure rate, ticket queue aging, system uptime, vulnerability burn-down, endpoint compliance — the SQL patterns IT / DevOps / Security analysts write against ServiceNow, PagerDuty, and CMDB extracts. Coming soon.

Missions in development — landing live nowSee All Missions

Coming soon · join the waitlist

How It Works

1

Read the briefing

A Slack message from your manager

2

Explore the schema

5 tables in a star schema

3

Write your query

Full SQL editor with autocomplete

4

Get expert feedback

Graduated hints, not just pass/fail

Why This Path

Incident Analytics

MTTR, MTBF, severity-mix, repeat-incident clustering.

DORA Metrics

Deploy frequency, lead time for changes, change-failure rate.

Service Desk

Ticket SLA attainment, queue aging, first-contact resolution.

Security Posture

Vulnerability burn-down, patch latency, endpoint compliance.

The Missions

Each mission is a real request from someone at the company. Difficulty increases as you go.

The Database

A realistic IT operations star schema with planted data quality issues. Coming soon.

●dimension tables  ● fact tables

Join the waitlist

We’ll email when the path ships.

Missions in development

The seed data and mission content ship in a follow-up.

Looking for something different?

|