8. Make tests useful in continuous integration
Core software skills · Create a repeatable check command and understand what a CI result actually proves.
Existing companion · depth review pendingOpen collection →Read deeply.
Put your understanding to work.
Explore a topic as a collection of learning resources. Choose a chapter, work through a question, inspect the data or return to an explanation.
Explore the SQL reference collection →201 topic collections. Page 14 of 17. Existing companions are not automatically complete study units.
9. Deliver a reviewable software mini-project
Core software skills · Hand over a tested fictional order-summary tool with honest operating limits.
Existing companion · depth review pendingOpen collection →1. Turn a product question into a metric contract
Product Analytics · Define the population, analysis unit, event and observation window before calculating.
Existing companion · depth review pendingOpen collection →2. Audit event evidence before interpreting a chart
Product Analytics · Validate identities, timestamps, repeated deliveries and event meaning.
Existing companion · depth review pendingOpen collection →3. Build an ordered, time-bounded user funnel
Product Analytics · Measure step conversion without counting repeats or out-of-order actions as new users.
Existing companion · depth review pendingOpen collection →4. Compare cohorts without confusing time and age
Product Analytics · Group users consistently and compare the same stage of their product lifetime.
Existing companion · depth review pendingOpen collection →5. Measure retention with complete observation windows
Product Analytics · Distinguish exact-day return, rolling return and incomplete data.
Existing companion · depth review pendingOpen collection →6. Design a randomized experiment before seeing results
Product Analytics · Define assignment, intention-to-treat analysis, outcomes, guardrails and stopping rules.
Existing companion · depth review pendingOpen collection →7. Interpret effects, uncertainty and experiment health
Product Analytics · Calculate an effect with its uncertainty and resist premature winner claims.
Existing companion · depth review pendingOpen collection →8. Deliver a product analytics decision memo
Product Analytics · Combine funnel, retention and experiment evidence into an honest recommendation.
Existing companion · depth review pendingOpen collection →1. Design an evidence-first AI workflow
Applied AI · Separate retrieval, extraction, validation and final factual review.
Existing companion · depth review pendingOpen collection →2. Run real local semantic retrieval
Applied AI · Encode meaning-related text and compare it with a transparent keyword baseline.
Existing companion · depth review pendingOpen collection →One useful next step
Start learning. Build understanding.
Explore the introductory learning, then create a free account to continue, save learning notes and track supported lessons. Registration and email verification cost nothing.