Этот материал находится в платной подписке. Оформи премиум подписку и смотри или слушай Mastering Postgres | The most comprehensive course on PostgreSQL, а также все другие курсы, прямо сейчас!
Премиум
  1. Урок 1. 00:02:15
    Introduction to the course
  2. Урок 2. 00:03:41
    Overview of course structure
  3. Урок 3. 00:02:09
    Postgres vs. everyone
  4. Урок 4. 00:02:39
    The psql CLI
  5. Урок 5. 00:06:46
    Introduction to schema
  6. Урок 6. 00:09:40
    Integers
  7. Урок 7. 00:09:51
    Numeric
  8. Урок 8. 00:08:05
    Floating point
  9. Урок 9. 00:08:17
    Storing money
  10. Урок 10. 00:03:45
    NaNs and infinity
  11. Урок 11. 00:05:36
    Casting types
  12. Урок 12. 00:07:43
    Characters types
  13. Урок 13. 00:08:55
    Check constrai
  14. Урок 14. 00:07:49
    Domain types
  15. Урок 15. 00:07:48
    Chars and collations
  16. Урок 16. 00:09:01
    Binary data
  17. Урок 17. 00:06:20
    UUIDs
  18. Урок 18. 00:03:48
    Boolean
  19. Урок 19. 00:12:45
    Enums
  20. Урок 20. 00:12:44
    Timestamps
  21. Урок 21. 00:13:13
    Timezones
  22. Урок 22. 00:07:51
    Dates and times
  23. Урок 23. 00:05:47
    Intervals
  24. Урок 24. 00:09:53
    Serial type
  25. Урок 25. 00:04:50
    Sequences
  26. Урок 26. 00:07:03
    Identity
  27. Урок 27. 00:04:49
    Network and mac addresses
  28. Урок 28. 00:10:18
    JSON
  29. Урок 29. 00:07:05
    Arrays
  30. Урок 30. 00:08:03
    Generated columns
  31. Урок 31. 00:07:43
    Text search types
  32. Урок 32. 00:05:16
    Bit string
  33. Урок 33. 00:15:40
    Ranges
  34. Урок 34. 00:04:20
    Composite types
  35. Урок 35. 00:03:53
    Nulls
  36. Урок 36. 00:05:38
    Unique constrai
  37. Урок 37. 00:06:52
    Exclusion constrai
  38. Урок 38. 00:10:51
    Foreign key constrai
  39. Урок 39. 00:05:28
    Introduction to indexes
  40. Урок 40. 00:04:18
    Heaps and CTIDs
  41. Урок 41. 00:05:02
    B-Tree overview
  42. Урок 42. 00:03:01
    Primary keys vs. secondary indexes
  43. Урок 43. 00:07:13
    Primary key types
  44. Урок 44. 00:08:45
    Where to add indexes
  45. Урок 45. 00:09:16
    Index selectivity
  46. Урок 46. 00:08:45
    Composite indexes
  47. Урок 47. 00:03:09
    Composite range
  48. Урок 48. 00:04:34
    Combining multiple indexes
  49. Урок 49. 00:08:54
    Covering indexes
  50. Урок 50. 00:06:30
    Partial indexes
  51. Урок 51. 00:04:01
    Index ordering
  52. Урок 52. 00:02:36
    Ordering nulls in indexes
  53. Урок 53. 00:05:23
    Functional indexes
  54. Урок 54. 00:03:05
    Duplicate indexes
  55. Урок 55. 00:04:13
    Hash indexes
  56. Урок 56. 00:02:17
    Naming indexes
  57. Урок 57. 00:01:25
    Introduction to explain
  58. Урок 58. 00:05:17
    Explain structure
  59. Урок 59. 00:11:29
    Scan nodes
  60. Урок 60. 00:08:24
    Co and rows
  61. Урок 61. 00:02:39
    Explain analyze
  62. Урок 62. 00:01:26
    Introduction to queries
  63. Урок 63. 00:06:19
    Inner joins
  64. Урок 64. 00:05:41
    Outer joins
  65. Урок 65. 00:06:38
    Subqueries
  66. Урок 66. 00:06:23
    Lateral joins
  67. Урок 67. 00:03:45
    ROWS FROM
  68. Урок 68. 00:06:56
    Filling gaps in sequences
  69. Урок 69. 00:14:21
    Subquery elimination
  70. Урок 70. 00:07:58
    Combining queries
  71. Урок 71. 00:06:22
    Set generating functions
  72. Урок 72. 00:04:47
    Indexing joins
  73. Урок 73. 00:01:26
    Introduction to advanced SQL
  74. Урок 74. 00:05:21
    Cross joins
  75. Урок 75. 00:11:08
    Grouping
  76. Урок 76. 00:07:15
    Grouping s, rollups, cubes
  77. Урок 77. 00:18:11
    Window functions
  78. Урок 78. 00:10:31
    CTEs
  79. Урок 79. 00:10:35
    CTEs with window functions
  80. Урок 80. 00:06:45
    Recursive CTE
  81. Урок 81. 00:06:20
    Hierarchical recursive CTE
  82. Урок 82. 00:06:51
    Handling nulls
  83. Урок 83. 00:11:44
    Row value syntax
  84. Урок 84. 00:07:44
    Views
  85. Урок 85. 00:10:53
    Materialized views
  86. Урок 86. 00:05:01
    Removing duplicate rows
  87. Урок 87. 00:08:38
    Upsert
  88. Урок 88. 00:04:00
    Returning keyword
  89. Урок 89. 00:04:32
    COALESCE + generated column
  90. Урок 90. 00:03:01
    Introduction to full text search
  91. Урок 91. 00:03:04
    Searching with LIKE
  92. Урок 92. 00:08:10
    Vectors, queries, and ranks
  93. Урок 93. 00:05:56
    Websearch
  94. Урок 94. 00:14:10
    Ranking
  95. Урок 95. 00:06:09
    Indexing full text search
  96. Урок 96. 00:03:32
    Highlighting
  97. Урок 97. 00:03:16
    Intro to JSON
  98. Урок 98. 00:04:17
    JSON vs JSONB
  99. Урок 99. 00:04:42
    Validating JSON
  100. Урок 100. 00:08:21
    Creating JSON objects + arrays
  101. Урок 101. 00:08:25
    JSON extraction
  102. Урок 102. 00:04:15
    JSON containment
  103. Урок 103. 00:03:04
    JSON existence
  104. Урок 104. 00:08:42
    JSON recordset
  105. Урок 105. 00:11:54
    Updating JSON
  106. Урок 106. 00:10:09
    Indexing JSON parts
  107. Урок 107. 00:06:15
    GIN index
  108. Урок 108. 00:02:18
    Intro to pgvector
  109. Урок 109. 00:08:00
    Vector embedding columns
  110. Урок 110. 00:09:22
    Find related articles
  111. Урок 111. 00:03:02
    Upsert vector embedding
  112. Урок 112. 00:05:36
    Semantic search
  113. Урок 113. 00:03:06
    Other operators
  114. Урок 114. 00:05:00
    Vector indexes
  115. Урок 115. 00:01:42
    Thank you
  116. Урок 116. 01:02:46
    Heroku's glory days & Postgres vs the world (with Craig Kerstiens)
  117. Урок 117. 01:01:21
    Creating a Postgres platform with Monica & Tudor from Xata.io
  118. Урок 118. 01:21:58
    Bootstrapping an email service provider (with Jesse Hanley)