SQL for Business Analysts

A coach that teaches by asking — not by lecturing

The Lighthouse Coach is an AI Socratic coach built on Cognosco Learning's SQL for Business Analysts course, in the Personal Effectiveness & Well-Being category. It does not play videos at you.

It holds a conversation: it asks you a question, listens to your answer, names the misconception it hears, affirms what you got right, and asks the next question — the way a great coach works in the room. You work on your own business questions alongside the Coach throughout: the Coach teaches and questions, you translate, query, and check, and what you produce is what gets checked.

This is the course for the analyst who currently waits for answers — who files requests, assembles spreadsheets by hand, or reuses last quarter's figure because getting a fresh one is somebody else's job — and for anyone who has been burned by a wrong number and wants the checking habits that prevent a repeat.

It works in the order the craft itself runs: first, Module 1 — Asking the Database: From Business Question to First Correct Query — work through Concepts 1–9, finishing with The Monday Morning Sales Pack; then, Module 2 — Joining, Checking, and Handing Over — work through Concepts 10–18, finishing with The Quarterly Review Query Pack.

You finish by proving the whole course — in The Monday Morning Sales Pack and in The Quarterly Review Query Pack. You can type your answers, or talk out loud: the Voice Coach speaks its questions and listens to your spoken replies, hands-free. The course is self-paced and always on — roughly 30 minutes per concept, about 9 hours in full, taken in as many sittings as you like. Learners who already know the material can test out concept by concept.

The book teaches against one small sample database — three tables, twenty-six rows in total — printed in full, small enough to check by hand, and every row count, sum, and average shown is what that stated data returns when the printed query runs against it; no result was written from memory or estimated.

The book teaches standard SQL, not one vendor's product — the shared core every major database speaks — so no learner finishes fluent in one company's tool and lost in another's. Every term is defined in ordinary words when it first appears, and every query is printed in a formatting style you are taught to copy, because a query nobody else can read is a query nobody else can check.

Window functions are given a foundations pass rather than a full treatment, and recursive queries, set operations, and database administration are excluded entirely.

Both capstones produce real artifacts — a Monday-morning sales pack rebuilt end to end, and a quarterly review query pack built to be rerun, reconciled, and handed over — not just ideas about querying.

This is the one hundred and fifteenth course in The Lighthouse Signature Series — the online counterpart to the one-day, in-person learning Cognosco Learning has delivered since 2002.