Table of Contents

      Introduction

  1. Writing Basic SQL Queries
  2. Using Multiple Tables When Querying Data
  3. Using Advanced Table Joins
  4. Filtering Data
  5. Applying Complex Filters to Queries
  6. Making Simple Calculations
  7. Aggregating Output
  8. Working with Dates in MySQL
  9. Formatting Text in Query Output
  10. Formatting Numbers and Dates
  11. Using Basic Logic to Enhance Analysis
  12. Subqueries
  13. Derived Tables
  14. Common Table Expressions
  15. Correlated Subqueries
  16. Dataset Manipulation
  17. Using SQL for More Advanced Calculations
  18. Segmenting and Classifying Data
  19. Rolling Analysis
  20. Analyzing Data Over Time
  21. Complex Data Output