Table of Contents

  1. Writing Basic SQL Queries
  2. Filtering Data
  3. Applying Complex Filters to Queries
  4. Simple Calculations
  5. Aggregating Output
  6. Working with Dates in Databricks
  7. Formatting Text in Query Output
  8. Formatting Numbers and Dates
  9. Using Basic Logic to Enhance Analysis
  10. Using Multiple Tables When Querying Data
  11. Using Advanced Table Joins
  12. Subqueries
  13. Derived Tables
  14. Common Table Expressions
  15. Correlated Subqueries
  16. Datasets 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