Code24Lab
Menu
Courses Categories Guides Pricing Log in Sign up

generate_series: Reports Without Missing Days

Lesson 7 of 20 Lab 🔒 Locked

Lessons in this course

  1. Joins in PostgreSQL: USING, Aliases and a First ReportLabFree
  2. LEFT JOIN, COALESCE and the FILTER ClauseLab Locked
  3. DISTINCT ON: The Latest Row per GroupLab Locked
  4. LATERAL Joins: Top N Rows per GroupLab Locked
  5. CTEs: Building a Report in Readable StepsLab Locked
  6. WITH RECURSIVE: Walking a Category TreeLab Locked
  7. generate_series: Reports Without Missing DaysLab Locked
  8. Arrays: @>, && and ANYLab Locked
  9. unnest, array_agg and the Double-Counting TrapLab Locked
  10. JSONB: ->, ->>, ? and @>Lab Locked
  11. JSONB Arrays to Rows: jsonb_to_recordsetLab Locked
  12. GIN Indexes and Selectivity for JSONB and ArraysLab Locked
  13. Window Functions: ROW_NUMBER, RANK, DENSE_RANKLab Locked
  14. Running Totals and Window Frames: RANGE vs ROWSLab Locked
  15. LAG and LEAD: Month-over-Month ChangeLab Locked
  16. Shares and Top N per Group with Window AggregatesLab Locked
  17. Views: Saved Queries That Are Always CurrentLab Locked
  18. Materialized Views: Fast but StaleLab Locked
  19. UPSERT with INSERT ... ON CONFLICTLab Locked
  20. Final Project: A Customer Report in One QueryLab Locked