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