Data & Analytics #1beginner

SQL & Metrics for AI Builders

Turn data into decisions. Learn SQL fundamentals, database design for AI apps, metrics frameworks (North Star, AARRR), AI-assisted dashboard building, data pipelines, and anomaly detection. Everything a builder needs to measure what matters.

What You Build

A metrics system with SQL queries, dashboard, data pipeline, and anomaly detection — all measuring what matters for your product

Sections

Lessons

Estimated

Concepts

Start Course

This Course Unlocks

intermediateData & Analytics

Experiments & Decision Systems

Stop guessing, start testing. Master A/B testing, feature flags, progressive rollouts, statistical significance, multi-armed bandits, and decision frameworks like RICE and ICE. Build a culture of experimentation that turns data into better products.

sqlmetricsdashboardsdata-pipelinesanalyticsanomaly-detectiondatabase-design

Dev Jordan

walkthrough · casual

First 5 lessons are free (83% of the course). No login required.

SQL and Metrics Foundations

SQL fundamentals, database design, and metrics frameworks.

SQL Fundamentals: SELECT, JOIN, GROUP BY

30 min Ship Build in Public

Ship: 10 SQL queries answering real business questions against a sample dataset

Tweet: Tweet: 'If you can write SQL, you can answer any business question in seconds instead of waiting for a report.'

Database Design for AI Applications

30 min Ship

Ship: Schema design for an AI application with proper indexing and relationships

Metrics That Matter: North Star, AARRR, Input vs Output

30 min Ship

Ship: Metrics framework document with north star metric, AARRR funnel metrics, and leading indicators

Dashboards and Pipelines

AI-assisted dashboards, data pipelines, and anomaly detection.

Building Dashboards with AI-Assisted SQL

30 min Ship

Ship: Interactive dashboard with 5+ charts powered by SQL queries

Data Pipelines: ETL, ELT, and Streaming Basics

30 min Ship Build in Public

Ship: Working data pipeline that transforms raw events into dashboard-ready metrics

Tweet: Tweet: 'Set up my first data pipeline. Raw events go in, clean metrics come out. No more manual spreadsheet exports.'

Preview — content blurs halfway through

Anomaly Detection and Alerting

30 min

Unlock the rest of this course

$5 for full course or $25/mo for everything

See pricing

Next Course