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