Этот материал находится в платной подписке. Оформи премиум подписку и смотри или слушай Fundamentals of Database Engineering, а также все другие курсы, прямо сейчас!
Премиум
  1. Урок 1. 00:06:37
    Welcome to the Course
  2. Урок 2. 00:00:38
    Course Note 1
  3. Урок 3. 00:07:37
    Course Note 2
  4. Урок 4. 00:09:25
    Course Note 3
  5. Урок 5. 00:03:55
    Introduction to ACID
  6. Урок 6. 00:13:35
    What is a Transaction?
  7. Урок 7. 00:10:05
    Atomicity
  8. Урок 8. 00:31:54
    Isolation
  9. Урок 9. 00:12:42
    Consistency
  10. Урок 10. 00:12:13
    Durability
  11. Урок 11. 00:21:22
    ACID by Practical Examples
  12. Урок 12. 00:07:36
    Phantom Reads
  13. Урок 13. 00:08:18
    Serializable vs Repeatable Read
  14. Урок 14. 00:14:34
    Eventual Consistency
  15. Урок 15. 00:21:04
    How tables and indexes are stored on disk (MUST WATCH before continue)
  16. Урок 16. 00:34:16
    Row-Based vs Column-Based Databases
  17. Урок 17. 00:10:57
    Primary Key vs Secondary Key - What you probably didn't know
  18. Урок 18. 00:04:23
    Create Postgres Table with a million Rows (from scratch)
  19. Урок 19. 00:18:19
    Getting Started with Indexing
  20. Урок 20. 00:10:17
    Understanding The SQL Query Planner and Optimizer with Explain
  21. Урок 21. 00:11:25
    Bitmap Index Scan vs Index Scan vs Table Scan
  22. Урок 22. 00:17:03
    Key vs Non-Key Column Database Indexing
  23. Урок 23. 00:08:09
    Index Scan vs Index Only Scan
  24. Урок 24. 00:14:08
    Combining Database Indexes for Better Performance
  25. Урок 25. 00:11:20
    How Database Optimizers Decide to Use Indexes
  26. Урок 26. 00:03:11
    Create Index Concurrently - Avoid Blocking Production Database Writes
  27. Урок 27. 00:09:19
    Bloom Filters
  28. Урок 28. 00:13:09
    Working with Billion-Row Table
  29. Урок 29. 00:03:35
    B-Tree Section's Introduction & Agenda
  30. Урок 30. 00:03:28
    Full Table Scans
  31. Урок 31. 00:04:47
    Original B-Tree
  32. Урок 32. 00:07:58
    How the Original B-Tree Helps Performance
  33. Урок 33. 00:06:32
    Original B-Tree Limitations
  34. Урок 34. 00:06:18
    B+Tree
  35. Урок 35. 00:04:28
    B+Tree DBMS Considerations
  36. Урок 36. 00:04:46
    B+Tree Storage Cost in MySQL vs Postgres
  37. Урок 37. 00:01:08
    B-Tree Section's Summary
  38. Урок 38. 00:01:27
    Introduction to Database Partitioning
  39. Урок 39. 00:03:29
    What is Partitioning?
  40. Урок 40. 00:02:08
    Vertical vs Horizontal Partitioning
  41. Урок 41. 00:01:33
    Partitioning Types
  42. Урок 42. 00:02:44
    The Difference Between Partitioning and Sharding
  43. Урок 43. 00:05:23
    Preparing: Postgres, Database, Table, Indexes
  44. Урок 44. 00:01:19
    Execute Multiple Queries on the Table
  45. Урок 45. 00:03:47
    Create and Attach Partitioned Tables
  46. Урок 46. 00:04:00
    Populate the Partitions and Create Indexes
  47. Урок 47. 00:05:33
    Class Project - Querying and Checking the Size of Partitions
  48. Урок 48. 00:04:42
    The Advantages of Partitioning
  49. Урок 49. 00:02:49
    The Disadvantages of Partitioning
  50. Урок 50. 00:01:11
    Section Summary - Partitioning
  51. Урок 51. 00:10:07
    How to Automate Partitioning in Postgres
  52. Урок 52. 00:01:07
    Introduction to Database Sharding
  53. Урок 53. 00:03:32
    What is Database Sharding?
  54. Урок 54. 00:02:42
    Consistent Hashing
  55. Урок 55. 00:01:09
    Horizontal partitioning vs Sharding
  56. Урок 56. 00:01:06
    Sharding with Postgres
  57. Урок 57. 00:07:24
    Spin up Docker Postgres Shards
  58. Урок 58. 00:21:59
    Writing to a Shard
  59. Урок 59. 00:11:20
    Reading from a Shard
  60. Урок 60. 00:02:00
    Advantages of Database Sharding
  61. Урок 61. 00:03:34
    Disadvantages of Database Sharding
  62. Урок 62. 00:00:46
    Database Sharding Section Summary
  63. Урок 63. 00:20:07
    When Should you consider Sharding your Database?
  64. Урок 64. 00:11:05
    Shared vs Exclusive Locks
  65. Урок 65. 00:05:32
    Dead Locks
  66. Урок 66. 00:07:09
    Two-phase Locking
  67. Урок 67. 00:13:43
    Solving the Double Booking Problem (Code Example)
  68. Урок 68. 00:17:50
    Double Booking Problem Part 2 ( Alternative Solution and explination)
  69. Урок 69. 00:09:10
    SQL Pagination With Offset is Very Slow
  70. Урок 70. 00:10:51
    Database Connection Pooling
  71. Урок 71. 00:01:20
    Introduction to Database Replication
  72. Урок 72. 00:03:46
    Master/Standby Replication
  73. Урок 73. 00:01:24
    Multi-master Replication
  74. Урок 74. 00:03:07
    Synchronous vs Asynchronous Replication
  75. Урок 75. 00:19:21
    Replication Demo with Postgres 13
  76. Урок 76. 00:03:29
    Pros and Cons of Replication
  77. Урок 77. 01:11:57
    Twitter System Design Database Design
  78. Урок 78. 00:37:51
    Building a Short URL System Database Backend
  79. Урок 79. 00:02:45
    Introduction
  80. Урок 80. 00:06:42
    What is a Database Engine?
  81. Урок 81. 00:06:50
    MyISAM
  82. Урок 82. 00:06:46
    InnoDB
  83. Урок 83. 00:02:07
    XtraDB
  84. Урок 84. 00:03:45
    SQLite
  85. Урок 85. 00:02:28
    Aria
  86. Урок 86. 00:02:41
    BerkeleyDB
  87. Урок 87. 00:06:21
    LevelDB
  88. Урок 88. 00:04:06
    RocksDB
  89. Урок 89. 00:02:32
    Popular Database Engines
  90. Урок 90. 00:17:09
    Switching Database Engines with mySQL
  91. Урок 91. 00:09:32
    What are Database Cursors?
  92. Урок 92. 00:01:45
    Server Side vs Client Side Database Cursors
  93. Урок 93. 00:03:30
    Inserting Million Rows with Python in Postgres using Client Side Cursor
  94. Урок 94. 00:04:43
    Querying with Client Side Cursor
  95. Урок 95. 00:01:26
    Querying with Server Side Cursor
  96. Урок 96. 00:04:39
    Pros and Cons of Server vs Client Side Cursors
  97. Урок 97. 00:43:25
    MongoDB Architecture
  98. Урок 98. 00:12:02
    How to Secure Your Postgres Database by Enabling TLS/SSL
  99. Урок 99. 00:14:08
    Deep Look into Postgres Wire Protocol with Wireshark
  100. Урок 100. 00:24:05
    Deep Look Into MongoDB Wire Protocol with Wireshark
  101. Урок 101. 00:09:45
    What is the Largest SQL Statement that You can Send to Your Database
  102. Урок 102. 00:06:54
    Best Practices Working with REST & Databases
  103. Урок 103. 00:23:41
    Database Permissions and Best Practices for Building REST API
  104. Урок 104. 00:01:54
    Introduction to Homomorphic Encryption
  105. Урок 105. 00:01:30
    What is Encryption?
  106. Урок 106. 00:04:33
    Why Can't we always Encrypt?
  107. Урок 107. 00:05:01
    What is Homomorphic Encryption
  108. Урок 108. 00:00:36
    Homomorphic Encryption Demo
  109. Урок 109. 00:02:36
    Clone and Build the Code
  110. Урок 110. 00:01:06
    Going Through the Code and the Database
  111. Урок 111. 00:03:12
    Searching The Encrypted Database
  112. Урок 112. 00:02:31
    Is Homomorphic Encryption Ready?
  113. Урок 113. 00:12:55
    Heap Index scan instead of Index only scan why?
  114. Урок 114. 00:06:16
    What is the unit of the Cost in Postgres Planner?
  115. Урок 115. 00:26:08
    All Isolation Levels - Explained Details
  116. Урок 116. 00:07:56
    Snapshot and Repeatable Read Isolation difference?
  117. Урок 117. 00:07:38
    I have an Index why is the database doing a full table scan?
  118. Урок 118. 00:11:03
    Why Databases Read Pages instead of Rows?
  119. Урок 119. 00:10:54
    How does Indexing a column with duplicate values work?
  120. Урок 120. 00:08:46
    Should I drop unused indexes?
  121. Урок 121. 00:07:00
    Why use serializable Isolation Level when we have SELECT FOR UPDATE?
  122. Урок 122. 00:07:01
    Can I use the same database connection for multiple clients?
  123. Урок 123. 00:15:48
    Do I need a transaction if I'm only reading?
  124. Урок 124. 00:23:50
    Why does an update in Postgres touches all indexes?
  125. Урок 125. 00:25:46
    What is the value of bitmap index scan?
  126. Урок 126. 00:19:38
    What does Explain Analyze actually do?
  127. Урок 127. 00:11:16
    Does Create Index block writes and Why?
  128. Урок 128. 00:39:11
    WAL, Redo and Undo logs
  129. Урок 129. 00:10:38
    SELECT COUNT (*) can impact your Backend Application performance, here is why
  130. Урок 130. 00:31:23
    How Shopify Switched from UUID as Primary Key
  131. Урок 131. 00:18:56
    How does the Database Store Data On Disk?
  132. Урок 132. 00:33:16
    Postgres Architecture
  133. Урок 133. 00:12:16
    Is QUIC a Good Protocol for Databases?
  134. Урок 134. 00:21:29
    What is a Distributed Transaction?
  135. Урок 135. 00:49:23
    Hash Tables and Consistent Hashing
  136. Урок 136. 00:13:02
    Indexing in PostgreSQL vs MySQL
  137. Урок 137. 00:47:14
    Why Uber Moved from Postgres to MySQL (Discussion)
  138. Урок 138. 00:21:13
    Can NULLs Improve your Database Queries Performance?
  139. Урок 139. 00:21:16
    Write Amplification Explained in Backend Apps, Database Systems and SSDs
  140. Урок 140. 00:17:37
    Optimistic vs Pessmistic Concurrency Control
  141. Урок 141. 00:01:40
    Introduction to ACID (Archived)
  142. Урок 142. 00:02:32
    What is a Transaction? (Archived)
  143. Урок 143. 00:02:40
    Atomicity (Archived)
  144. Урок 144. 00:20:36
    Isolation (Archived)
  145. Урок 145. 00:13:07
    Consistency (Archived)
  146. Урок 146. 00:01:45
    Durability (Archived)