compendium

14 Lessons

Handling Nulls Correctly

14 Lessons

Join Fan-Out & Duplicate Rows: The Silent Wrong Answer

14 Lessons

Joins in Depth: Inner, Left, Full, Cross & Self Joins

14 Lessons

Aggregation & Grouping, Including HAVING versus WHERE

14 Lessons

Filtering Precisely: SELECT, WHERE, IN, LIKE & BETWEEN

14 Lessons

Normalisation & Denormalisation: What Each One Costs You

14 Lessons

Query Execution Order and Why It Explains Most Errors

14 Lessons

Relational Databases, Keys & Reading an Entity Relationship Diagram

13 Lessons

Statistical Traps: p-Hacking, Multiple Comparisons & Simpson's Paradox

13 Lessons

Correlation vs Causation: Confounders & Study Design

13 Lessons

Correlation, Regression & the Limits of Both

13 Lessons

Non-Parametric Tests: What to Use When Assumptions Break

13 Lessons

Choosing the Right Test: t-Test, Chi-Square & Analysis of Variance

13 Lessons

Type I & Type II Errors, Statistical Power and Sample Size

13 Lessons

Hypothesis Testing: Null, Alternative, p-Values & Significance

13 Lessons

Sampling, Sampling Bias & the Central Limit Theorem

13 Lessons

Confidence Intervals & Margin of Error, Explained Plainly

13 Lessons

Probability Essentials: Rules, Conditional Probability & Bayes' Theorem