View map →

PostgreSQL

Fork

Forking needs an account. Create one.

engineering · 40 units · 40 lessons

  1. 1. What Is PostgreSQL

  2. 2. SELECT & Projection

  3. 3. Filtering with WHERE

  4. 4. ORDER BY, LIMIT & OFFSET

  5. 5. DISTINCT & NULL Semantics

  6. 6. Numeric & Boolean Types

  7. 7. Text & Character Types

  8. 8. Date, Time & Intervals

  9. 9. Casting & Type Coercion

  10. 10. Enums & Arrays

  11. 11. INNER JOIN

  12. 12. LEFT, RIGHT & FULL Joins

  13. 13. Self & Cross Joins

  14. 14. USING, NATURAL & Join Conditions

  15. 15. UNION, INTERSECT & EXCEPT

  16. 16. Aggregate Functions

  17. 17. GROUP BY

  18. 18. HAVING & Filtering Groups

  19. 19. DISTINCT & FILTER in Aggregates

  20. 20. GROUPING SETS, ROLLUP & CUBE

  21. 21. Scalar & Column Subqueries

  22. 22. IN, ANY, ALL & EXISTS

  23. 23. Correlated Subqueries

  24. 24. Common Table Expressions

  25. 25. Recursive CTEs

  26. 26. CREATE TABLE & DDL

  27. 27. Primary & Foreign Keys

  28. 28. NOT NULL, UNIQUE & CHECK

  29. 29. Normalization

  30. 30. ALTER TABLE & Migrations

  31. 31. B-tree Indexes

  32. 32. GIN, GiST, BRIN & Hash

  33. 33. EXPLAIN & EXPLAIN ANALYZE

  34. 34. The Query Planner & Statistics

  35. 35. Composite & Partial Indexes

  36. 36. Transactions & ACID

  37. 37. Isolation Levels & MVCC

  38. 38. Window Functions

  39. 39. Window Frames & Running Totals

  40. 40. JSONB & Document Data