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