FreeCourseSite com Udemy - Fundamentals of Database Engineering

1. 1 - Course Updates/1 - Welcome to the Course.mp4145.86MB
2. 1 - Course Updates/2 - Course Note 1.mp413.98MB
3. 1 - Course Updates/3 - Course Note 2.mp4121.42MB
4. 1 - Course Updates/4 - Course Note 3.mp4201.14MB
5. 10 - Database System Design/82 - Twitter System Design Database Design.mp4758.81MB
6. 10 - Database System Design/83 - Building a Short URL System Database Backend.mp4287.82MB
7. 11 - Database Engines/84 - Introduction.mp413.47MB
8. 11 - Database Engines/85 - What is a Database Engine.mp417.57MB
9. 11 - Database Engines/86 - MyISAM.mp418.73MB
10. 11 - Database Engines/87 - InnoDB.mp413.63MB
11. 11 - Database Engines/88 - XtraDB.mp44.48MB
12. 11 - Database Engines/89 - SQLite.mp47.98MB
13. 11 - Database Engines/90 - Aria.mp44.69MB
14. 11 - Database Engines/91 - BerkeleyDB.mp45.44MB
15. 11 - Database Engines/92 - LevelDB.mp414.23MB
16. 11 - Database Engines/93 - RocksDB.mp48.7MB
17. 11 - Database Engines/94 - Popular Database Engines.mp48.14MB
18. 11 - Database Engines/95 - Switching Database Engines with mySQL.mp4151.31MB
19. 12 - Database Cursors/100 - Querying with Server Side Cursor.mp48.51MB
20. 12 - Database Cursors/101 - Pros and Cons of Server vs Client Side Cursors.mp425.75MB
21. 12 - Database Cursors/96 - What are Database Cursors.mp413.09MB
22. 12 - Database Cursors/97 - Server Side vs Client Side Database Cursors.mp418.97MB
23. 12 - Database Cursors/98 - Inserting Million Rows with Python in Postgres using Client Side Cursor.mp412.21MB
24. 12 - Database Cursors/99 - Querying with Client Side Cursor.mp424.45MB
25. 13 - SQL vs NoSQL Architecture/103 - MongoDB Architecture.mp4802.11MB
26. 14 - Database Security/104 - How to Secure Your Postgres Database by Enabling TLSSSL.mp4111.98MB
27. 14 - Database Security/105 - Deep Look into Postgres Wire Protocol with Wireshark.mp4223.63MB
28. 14 - Database Security/106 - Deep Look Into MongoDB Wire Protocol with Wireshark.mp4441.03MB
29. 14 - Database Security/107 - What is the Largest SQL Statement that You can Send to Your Database.mp4194.13MB
30. 14 - Database Security/108 - Best Practices Working with REST Databases.mp4227.53MB
31. 14 - Database Security/109 - Database Permissions and Best Practices for Building REST API.mp4190.53MB
32. 15 - Homomorphic Encryption Performing Database Queries on Encrypted Data/110 - Introduction to Homomorphic Encryption.mp44.95MB
33. 15 - Homomorphic Encryption Performing Database Queries on Encrypted Data/111 - What is Encryption.mp43.97MB
34. 15 - Homomorphic Encryption Performing Database Queries on Encrypted Data/112 - Why Cant we always Encrypt.mp412.08MB
35. 15 - Homomorphic Encryption Performing Database Queries on Encrypted Data/113 - What is Homomorphic Encryption.mp414.27MB
36. 15 - Homomorphic Encryption Performing Database Queries on Encrypted Data/114 - Homomorphic Encryption Demo.mp41018.82KB
37. 15 - Homomorphic Encryption Performing Database Queries on Encrypted Data/115 - Clone and Build the Code.mp430.9MB
38. 15 - Homomorphic Encryption Performing Database Queries on Encrypted Data/116 - Going Through the Code and the Database.mp416.55MB
39. 15 - Homomorphic Encryption Performing Database Queries on Encrypted Data/117 - Searching The Encrypted Database.mp431.64MB
40. 15 - Homomorphic Encryption Performing Database Queries on Encrypted Data/118 - Is Homomorphic Encryption Ready.mp410.58MB
41. 16 - Answering your Questions/119 - Heap Index scan instead of Index only scan why.mp4213.21MB
42. 16 - Answering your Questions/120 - What is the unit of the Cost in Postgres Planner.mp4112.97MB
43. 16 - Answering your Questions/121 - Snapshot and Repeatable Read Isolation difference.mp440.1MB
44. 16 - Answering your Questions/122 - I have an Index why is the database doing a full table scan.mp452.67MB
45. 16 - Answering your Questions/123 - Why Databases Read Pages instead of Rows.mp4101.81MB
46. 16 - Answering your Questions/124 - How does Indexing a column with duplicate values work.mp4229.93MB
47. 16 - Answering your Questions/125 - Should I drop unused indexes.mp445.43MB
48. 16 - Answering your Questions/126 - Why use serializable Isolation Level when we have SELECT FOR UPDATE.mp452.77MB
49. 16 - Answering your Questions/127 - Can I use the same database connection for multiple clients.mp437.93MB
50. 16 - Answering your Questions/128 - Do I need a transaction if Im only reading.mp4119.36MB
51. 16 - Answering your Questions/129 - Why does an update in Postgres touches all indexes.mp4166.35MB
52. 16 - Answering your Questions/130 - What is the value of bitmap index scan.mp4172.52MB
53. 16 - Answering your Questions/131 - What does Explain Analyze actually do.mp4153.89MB
54. 17 - Database Discussions/133 - WAL Redo and Undo logs.mp4853.16MB
55. 17 - Database Discussions/134 - SELECT COUNT can impact your Backend Application performance here is why.mp4104.75MB
56. 17 - Database Discussions/135 - How Shopify Switched from UUID as Primary Key.mp4502.36MB
57. 17 - Database Discussions/136 - How does the Database Store Data On Disk.mp4644.72MB
58. 17 - Database Discussions/137 - Is QUIC a Good Protocol for Databases.mp4562.36MB
59. 17 - Database Discussions/138 - What is a Distributed Transaction.mp4744.85MB
60. 17 - Database Discussions/139 - Hash Tables and Consistent Hashing.mp41.11GB
61. 17 - Database Discussions/140 - Indexing in PostgreSQL vs MySQL.mp4289.42MB
62. 17 - Database Discussions/141 - Why Uber Moved from Postgres to MySQL Discussion.mp4673.31MB
63. 17 - Database Discussions/142 - Can NULLs Improve your Database Queries Performance.mp4437.61MB
64. 17 - Database Discussions/143 - Write Amplification Explained in Backend Apps Database Systems and SSDs.mp4437.31MB
65. 17 - Database Discussions/144 - Optimistic vs Pessmistic Concurrency Control.mp4379.37MB
66. 18 - Archived Lectures/145 - Introduction to ACID Archived.mp43.82MB
67. 18 - Archived Lectures/146 - What is a Transaction Archived.mp44.89MB
68. 18 - Archived Lectures/147 - Atomicity Archived.mp45.3MB
69. 18 - Archived Lectures/148 - Isolation Archived.mp448.26MB
70. 18 - Archived Lectures/149 - Consistency Archived.mp422.64MB
71. 18 - Archived Lectures/150 - Durability Archived.mp42.32MB
72. 2 - ACID/10 - Isolation.mp471.91MB
73. 2 - ACID/11 - Consistency.mp422.21MB
74. 2 - ACID/12 - Durability.mp421.55MB
75. 2 - ACID/13 - ACID by Practical Examples.mp4125.82MB
76. 2 - ACID/14 - Phantom Reads.mp433.01MB
77. 2 - ACID/15 - Serializable vs Repeatable Read.mp472.79MB
78. 2 - ACID/16 - Eventual Consistency.mp458.79MB
79. 2 - ACID/7 - Introduction to ACID.mp418.46MB
80. 2 - ACID/8 - What is a Transaction.mp436.08MB
81. 2 - ACID/9 - Atomicity.mp420.19MB
82. 3 - Understanding Database Internals/17 - How tables and indexes are stored on disk MUST WATCH before continue.mp484.06MB
83. 3 - Understanding Database Internals/18 - RowBased vs ColumnBased Databases.mp4114.78MB
84. 3 - Understanding Database Internals/19 - Primary Key vs Secondary Key What you probably didnt know.mp4380.35MB
85. 4 - Database Indexing/21 - Create Postgres Table with a million Rows from scratch.mp413.47MB
86. 4 - Database Indexing/22 - Getting Started with Indexing.mp4124.79MB
87. 4 - Database Indexing/23 - Understanding The SQL Query Planner and Optimizer with Explain.mp443.99MB
88. 4 - Database Indexing/24 - Bitmap Index Scan vs Index Scan vs Table Scan.mp472.49MB
89. 4 - Database Indexing/25 - Key vs NonKey Column Database Indexing.mp4116.37MB
90. 4 - Database Indexing/26 - Index Scan vs Index Only Scan.mp449.23MB
91. 4 - Database Indexing/27 - Combining Database Indexes for Better Performance.mp4141.11MB
92. 4 - Database Indexing/28 - How Database Optimizers Decide to Use Indexes.mp4229.27MB
93. 4 - Database Indexing/29 - Create Index Concurrently Avoid Blocking Production Database Writes.mp415.59MB
94. 4 - Database Indexing/30 - Bloom Filters.mp425.73MB
95. 4 - Database Indexing/31 - Working with BillionRow Table.mp4304.04MB
96. 5 - BTree vs BTree in Production Database Systems/34 - BTree Sections Introduction Agenda.mp429.56MB
97. 5 - BTree vs BTree in Production Database Systems/35 - Full Table Scans.mp433.78MB
98. 5 - BTree vs BTree in Production Database Systems/36 - Original BTree.mp428.83MB
99. 5 - BTree vs BTree in Production Database Systems/37 - How the Original BTree Helps Performance.mp454.95MB
100. 5 - BTree vs BTree in Production Database Systems/38 - Original BTree Limitations.mp443.95MB
101. 5 - BTree vs BTree in Production Database Systems/39 - BTree.mp450.88MB
102. 5 - BTree vs BTree in Production Database Systems/40 - BTree DBMS Considerations.mp439.23MB
103. 5 - BTree vs BTree in Production Database Systems/41 - BTree Storage Cost in MySQL vs Postgres.mp445.14MB
104. 5 - BTree vs BTree in Production Database Systems/42 - BTree Sections Summary.mp48.65MB
105. 6 - Database Partitioning/43 - Introduction to Database Partitioning.mp43.79MB
106. 6 - Database Partitioning/44 - What is Partitioning.mp49.37MB
107. 6 - Database Partitioning/45 - Vertical vs Horizontal Partitioning.mp45.31MB
108. 6 - Database Partitioning/46 - Partitioning Types.mp43.37MB
109. 6 - Database Partitioning/47 - The Difference Between Partitioning and Sharding.mp47.51MB
110. 6 - Database Partitioning/48 - Preparing Postgres Database Table Indexes.mp410.37MB
111. 6 - Database Partitioning/49 - Execute Multiple Queries on the Table.mp45.86MB
112. 6 - Database Partitioning/50 - Create and Attach Partitioned Tables.mp49.23MB
113. 6 - Database Partitioning/51 - Populate the Partitions and Create Indexes.mp47.92MB
114. 6 - Database Partitioning/52 - Class Project Querying and Checking the Size of Partitions.mp450.93MB
115. 6 - Database Partitioning/53 - The Advantages of Partitioning.mp410.99MB
116. 6 - Database Partitioning/54 - The Disadvantages of Partitioning.mp47.01MB
117. 6 - Database Partitioning/55 - Section Summary Partitioning.mp47.51MB
118. 6 - Database Partitioning/56 - How to Automate Partitioning in Postgres.mp4103.2MB
119. 7 - Database Sharding/57 - Introduction to Database Sharding.mp43.32MB
120. 7 - Database Sharding/58 - What is Database Sharding.mp48.11MB
121. 7 - Database Sharding/59 - Consistent Hashing.mp44.53MB
122. 7 - Database Sharding/60 - Horizontal partitioning vs Sharding.mp43.05MB
123. 7 - Database Sharding/61 - Sharding with Postgres.mp43.43MB
124. 7 - Database Sharding/62 - Spin up Docker Postgres Shards.mp425.5MB
125. 7 - Database Sharding/63 - Writing to a Shard.mp4226.78MB
126. 7 - Database Sharding/64 - Reading from a Shard.mp494.53MB
127. 7 - Database Sharding/65 - Advantages of Database Sharding.mp43.4MB
128. 7 - Database Sharding/66 - Disadvantages of Database Sharding.mp47.47MB
129. 7 - Database Sharding/67 - Database Sharding Section Summary.mp41.38MB
130. 7 - Database Sharding/68 - When Should you consider Sharding your Database.mp4926.6MB
131. 8 - Concurrency Control/69 - Shared vs Exclusive Locks.mp458.28MB
132. 8 - Concurrency Control/70 - Dead Locks.mp463.47MB
133. 8 - Concurrency Control/71 - Twophase Locking.mp426.44MB
134. 8 - Concurrency Control/72 - Solving the Double Booking Problem Code Example.mp4205.43MB
135. 8 - Concurrency Control/73 - Double Booking Problem Part 2 Alternative Solution and explination.mp4138.93MB
136. 8 - Concurrency Control/74 - SQL Pagination With Offset is Very Slow.mp4106.65MB
137. 8 - Concurrency Control/74 - offset.mp41.08MB
138. 8 - Concurrency Control/75 - Database Connection Pooling.mp494.4MB
139. 9 - Database Replication/76 - Introduction to Database Replication.mp43.63MB
140. 9 - Database Replication/77 - MasterStandby Replication.mp412.7MB
141. 9 - Database Replication/78 - Multimaster Replication.mp42.82MB
142. 9 - Database Replication/79 - Synchronous vs Asynchronous Replication.mp48.86MB
143. 9 - Database Replication/80 - Replication Demo with Postgres 13.mp4173.26MB
144. 9 - Database Replication/81 - Pros and Cons of Replication.mp46.92MB