1. Урок 1. 00:03:35
    Course introduction
  2. Урок 2. 00:10:47
    Databases and SQL
  3. Урок 3. 00:12:20
    Tables and the relational model
  4. Урок 4. 00:04:30
    Installing PostgreSQL and DBeaver (Windows)
  5. Урок 5. 00:04:47
    Installing PostgreSQL and DBeaver (Mac)
  6. Урок 6. 00:19:31
    Creating your first database and table
  7. Урок 7. 00:04:14
    Several nice tweaks for DBeaver
  8. Урок 8. 00:06:06
    Setting up the sample database
  9. Урок 9. 00:08:19
    SELECT FROM
  10. Урок 10. 00:11:27
    Derived columns
  11. Урок 11. 00:10:30
    Filtering with WHERE
  12. Урок 12. 00:05:10
    AND, OR, and NOT
  13. Урок 13. 00:05:29
    NULL handling
  14. Урок 14. 00:07:14
    IN, BETWEEN, and LIKE
  15. Урок 15. 00:08:40
    ORDER BY
  16. Урок 16. 00:05:26
    SQL Order of execution
  17. Урок 17. 00:05:09
    LIMIT and OFFSET
  18. Урок 18. 00:04:35
    DISTINCT
  19. Урок 19. 00:07:32
    CASE expressions
  20. Урок 20. 00:04:20
    Common aggregate functions
  21. Урок 21. 00:11:46
    GROUP BY and HAVING
  22. Урок 22. 00:10:47
    CASE expressions and aggregations
  23. Урок 23. 00:14:04
    Introduction to data types
  24. Урок 24. 00:11:52
    Character data types
  25. Урок 25. 00:19:10
    Number data types
  26. Урок 26. 00:19:40
    Date and time data types
  27. Урок 27. 00:02:58
    Introduction to joins
  28. Урок 28. 00:08:41
    Cross joins
  29. Урок 29. 00:12:27
    Inner joins
  30. Урок 30. 00:16:34
    Outer joins
  31. Урок 31. 00:08:54
    Advanced join topics
  32. Урок 32. 00:11:01
    Uncorrelated subqueries
  33. Урок 33. 00:13:14
    Correlated subqueries
  34. Урок 34. 00:11:44
    Table subqueries
  35. Урок 35. 00:04:41
    Lateral subqueries
  36. Урок 36. 00:08:16
    Common table expressions (CTEs)
  37. Урок 37. 00:08:57
    Ranking window functions
  38. Урок 38. 00:12:40
    Aggregate window functions
  39. Урок 39. 00:08:08
    LAG and LEAD
  40. Урок 40. 00:03:11
    A little bit of set theory
  41. Урок 41. 00:07:41
    UNION
  42. Урок 42. 00:04:21
    INTERSECT
  43. Урок 43. 00:07:02
    EXCEPT
  44. Урок 44. 00:14:42
    Creating tables
  45. Урок 45. 00:17:49
    Primary keys
  46. Урок 46. 00:11:06
    Foreign keys
  47. Урок 47. 00:10:48
    CHECK, UNIQUE, and NOT NULL constraints
  48. Урок 48. 00:10:29
    Importing and exporting data
  49. Урок 49. 00:09:12
    Using transactions and inserting data
  50. Урок 50. 00:08:59
    Updating data
  51. Урок 51. 00:04:29
    Deleting data
  52. Урок 52. 00:00:57
    Views
  53. Урок 53. 00:07:50
    Materialized views
  54. Урок 54. 00:05:45
    Functions
  55. Урок 55. 00:02:28
    Writing functions with SQL
  56. Урок 56. 00:08:25
    Writing functions with PL/pgSQL
  57. Урок 57. 00:10:16
    Query plans with EXPLAIN
  58. Урок 58. 00:11:31
    Indexes
  59. Урок 59. 00:10:57
    Reading complex query plans
  60. Урок 60. 00:10:18
    Query optimization
  61. Урок 61. 00:11:31
    Congratulations