BigQuery in Practice
Signature Course No. 566 — A Signature AI Socratic Coaching Course.
No experience needed — your coach starts where you are.
A New Kind of Learning
Socratic coaching, delivered by an agentic AI coach.
Not a course you watch. An AI coach you work with.
The Lighthouse Coach begins by discovering how you think about the subject, teaches what is missing, and gives you realistic practice before asking you to prove that you can use it. You may test out of concepts you already understand, while capstones turn the learning into a practical plan, decision, conversation, or other real-world result.
The curriculum is deliberately authored; the AI delivers it through coaching. It is not an AI randomly generating lessons.
A coach that teaches by asking — not by lecturing
The Lighthouse Coach is an AI Socratic coach built on Cognosco Learning's BigQuery in Practice 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.
The bill follows the bytes. In BigQuery's on-demand model, a query is priced chiefly by the data it reads — not by how long it runs, how clever it is, or how much the answer matters. A query that reads a terabyte and returns one row costs the scanning of a terabyte; a query that reads a gigabyte and returns a million rows costs the scanning of a gigabyte. This course builds the second kind of practitioner: the one who knows what a query will cost before it runs, models tables so every future query reads less, and governs the estate before the invoice arrives.
It runs on one stipulated case. Westmoor Outfitters sells outdoor equipment through 46 stores and an online shop, and its analytics estate grew the way real estates grow — quickly, usefully, and without anyone designing it: an orders table of 1,460 GB growing by 2 GB a day, an order_items table of 1,800 GB, a web clickstream table of 12 TB, and a store-manager dashboard that refreshes every fifteen minutes — while nobody at Westmoor can say what the warehouse costs in a month, which queries cause it, or which tables earn their storage.
It starts with the bill. Bytes are the bill — then the estimate read before the run, the columns you name as the price you pay, the partition that prunes and the cluster that cuts again, the join that must not explode, the shape chosen for the question actually asked, the slot understood as a shared room, and storage treated as a lifecycle decision with a price attached to every month of neglect.
It works in two movements. First, Module 1 — Model and Cost the Warehouse — work through Concepts 1–9, finishing with The Westmoor Rebuild Plan; then, Module 2 — Run It Like a Practitioner — work through Concepts 10–18, finishing with The Ninety-Day Operating Charter.
Both capstones produce real artifacts — a costed rebuild plan for the orders estate: the baseline priced from evidence, the shapes chosen from the workload and certified against figures the business already trusts, the guards set before the work goes live, and the savings claimed only where the arithmetic supports them; and a ninety-day operating charter for running that estate: the audit routine, the allocated ceilings, the quality and tuning regimes, and the lifecycle calendar, written so a successor could execute it.
The honesty standard is part of the course. Every price in the course is illustrative, labelled as illustrative at the point of use, and worked at a stated rate so every figure can be recomputed by hand; current pricing, edition details, and product limits are fenced to the book's Appendix, to be confirmed at Google's own published pricing before anyone relies on them. And no saving is promised: real bills depend on real estates. What is promised is the craft — predict a query's cost before you run it, explain any line of the bill from the work that caused it, and run an estate where cost surprises are investigated rather than endured.
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. You can type your answers, or talk out loud: the Voice Coach speaks its questions and listens to your spoken replies. Learners who already know the material can test out concept by concept.
BigQuery in Practice is part of The Lighthouse Signature Series — the online counterpart to the one-day, in-person learning Cognosco Learning delivers.
Course Facts
One full concept, coached end to end — free: verify your email and we’ll send you a link to start.
Already enrolled? Enter the course →
Diagnose → Learn & Practice → Prove → Capstone
Every learner moves through the same discipline a Cognosco instructor would insist on in the room.
Diagnose
The Coach starts where the course starts: with the bill. Pick the query you run most often and say how many bytes it scans — or whether you have only ever watched its seconds; say when you last saw a warehouse cost figure attributed to a specific query you wrote, and who could produce that figure in your organisation today; and judge your estate's most expensive-feeling work — is it expensive because it is complex, or because it reads a great deal, very often, and what evidence separates those two explanations? Every concept opens with three questions that locate where you actually stand, and your answers shape how deeply the Coach works the concept with you. Everyone begins with Module 1 — no skipping the foundations you only think you have.
Learn & Practice
Work each concept in conversation with the Coach — spoken or written — then practice it against realistic situations until it holds up.
Prove
Every concept ends in proof: answer the check cold and demonstrate the skill. Know it already? Test out and take credit immediately.
Capstone
Finish with two capstones — The Westmoor Rebuild Plan for Module 1 and The Ninety-Day Operating Charter for Module 2 — that pull the whole course together, and earn the certificate.
What You'll Learn
Bytes first, seconds second. Judge every piece of work by one question first: how many bytes, how often? Speed and cost are different meters in this warehouse — a fast answer can be bought with massive parallel scanning — and the practitioner who prices the reading before the run is never surprised by the invoice.
Module 1 models and costs the warehouse. Why bytes scanned set the price; the estimate read before the run and the discipline of refusal; columnar storage and the price of what you name; partitioning and clustering, each preventing a different failure; joins checked by key counts before they can lie; the shape chosen by the workload; slots as a shared room; and storage as a lifecycle decision.
Module 2 runs it like a practitioner. Legacy shards retired without breakage; repeated work done once, by cache, materialized view, or pre-aggregation; loads gated at the door; spend attributed from the warehouse's own job history; quotas and budgets that bite before the invoice; extensions adopted only on written terms; the data itself tested; slow queries read from their execution plans; and the whole estate held in a weekly and monthly rhythm.
And it holds its boundary throughout. This course teaches BigQuery, and only BigQuery — the warehouse's durable behaviour, not its console: no click-paths, no feature catalogue, and no examination preparation. It assumes you can already write a competent query; what it adds is the level underneath — how the warehouse stores, reads, prices, and schedules work — and the level above it: designing, costing, tuning, and governing real work so the estate serves the business instead of billing it.
What you will learn
- Predict what a query will cost before you run it — from the bytes it will scan, at a stated rate — and refuse, cap, or redesign any query whose estimate you cannot defend
- Model tables so queries read less: choose columns, partitions, and clusters against the questions actually asked, and state the failure each choice prevents
- Join without exploding: check keys before you join, predict a join's output size, and name what a fan-out does to every number downstream
- Choose the shape data sits in — wide, joined, or nested — by the workload it must serve, and load it behind quality gates that stop bad data at the door
- Treat compute as a shared room: reason about slots, queueing, and reservations as capacity judgments, not as settings to copy
- Decide where repeated work is done once — cache, materialized view, or pre-aggregated table — and defend the choice by its refresh and staleness terms
- Read the warehouse's own records to attribute spend to the query, the project, and the person who caused it, and run the audit as a routine
- Govern the estate before the invoice does: quotas, budgets, and review rhythms that bite early and exempt nothing silently
- Diagnose a slow query from its execution plan — stage by stage, shuffle, spill, and wait — and test the data itself so the numbers the business reads can be trusted
Everything in the course
- All 18 concepts of BigQuery in Practice, in 2 modules
- A starting-point check first — the Coach finds where you actually stand before teaching
- Learn, Practice, Prove for every concept — no passive video watching
- A test-out on every concept: prove you know it and move on
- The Voice Coach: talk with the Coach out loud — it speaks, listens, and replies
- A personal Learner Record of your work across the course
- Two capstone exercises: The Westmoor Rebuild Plan and The Ninety-Day Operating Charter
- A printable session summary whenever you pause
- The Lighthouse Coach completion certificate (Signature Series)
- Your progress is saved as you go — stop anytime, resume where you left off
Built for the people who run the warehouse
Analysts and analytics engineers who already work in BigQuery — who want the step from writing queries to designing the estate those queries run on, modelling, cost judgment, and tuning included; and data engineers responsible for a BigQuery estate's bill and reliability who need a defensible method for partitioning, clustering, loading, and governing, rather than a pile of tips.
Team leads and platform owners — who must answer for warehouse spend, attributing it, capping it, and explaining it, and who need the concepts that make that conversation honest.
Practitioners moving to BigQuery from another warehouse — who know data work well and need this platform's specific economics and habits, taught at workflow depth rather than as a feature list. This course assumes working SQL and some experience of tables, schemas, and scheduled reports; it assumes no particular Google Cloud role or console familiarity, and it teaches none.
Prefer to learn live and in person? The same material anchors Cognosco's one-day programs — browse the in-person catalog.
Start with Bytes Are the Bill
$195 — introductory price. One payment. No subscription, no password to manage.
Here is exactly what happens when you enroll:
- Pay securely with Stripe — you are taken straight into the course
- Create your learner profile and begin the Module 1 starting-point check
- Save the access key you are given — it restores your enrollment on any device
- Learn at your pace; your progress is stored in your browser on your device
For the full voice experience, use Chrome and allow the microphone when asked. Typing your answers works everywhere, all the time. Questions before you enroll? Email hello@cognoscolearning.com.
Before you enroll
What is a Socratic coaching session?
A conversation, not a video. Your coach asks a question; you answer — out loud by voice, or by typing — and the coach responds to what you said: naming the misconception it hears, affirming what you got right, and asking the next question. You advance only when you have mastered each concept, so a finished course means the learning held.
How long does it take — and how long do I have?
About 30 minutes per concept. Learn in sittings of any length; your progress is saved as you go. You have a full year from purchase to finish, and you can revisit and retake within that year.
What does the certificate verify?
That you completed every concept and both capstones of this course. Anyone can confirm a Cognosco certificate online — enter its certificate ID on our verification page.
What if it isn't for me — what are the refunds?
If you have not started, cancel for a full refund within seven days of purchase. Once you have started, there is no cash refund — stop before finishing and we credit the full amount you paid toward any other course in the library (credit valid one year from your original purchase). Once you complete the course, no refund or credit applies.
Independently verified before publication — structure, claims, and sources checked; tested end to end as a learner takes it.
More Signature Courses are coming
BigQuery in Practice is Signature Course No. 566. Leave your email and we'll send you news of future Signature Courses and Lighthouse updates as they are announced — nothing else.