Udemy - Fundamentals of Database Engineering [TP]

Files:

• 001 Welcome to the Course.mp4 (145.9 MB)
• 001 Welcome to the Course_en.vtt (7.9 KB)
• 002 Course Update Oct 2020.mp4 (14.0 MB)
• 002 Course Update Oct 2020_en.vtt (0.6 KB)
• 003 Course Update April 2021.mp4 (121.4 MB)
• 003 Course Update April 2021_en.vtt (9.5 KB)
• 004 Course Update December 2021.mp4 (201.1 MB)
• 004 Course Update December 2021_en.vtt (11.3 KB)
• 005 Note about Docker.html (1.2 KB)
• [Tutorialsplanet.NET].url (0.1 KB)

• 001 Introduction to ACID.mp4 (18.5 MB)
• 001 Introduction to ACID_en.vtt (3.9 KB)
• 002 What is a Transaction.mp4 (36.1 MB)
• 002 What is a Transaction_en.vtt (16.5 KB)
• 003 Atomicity.mp4 (28.0 MB)
• 003 Atomicity_en.vtt (11.9 KB)
• 004 Isolation.mp4 (50.7 MB)
• 004 Isolation_en.vtt (40.0 KB)
• 005 Consistency.mp4 (16.2 MB)
• 005 Consistency_en.vtt (15.0 KB)
• 006 Durability.mp4 (15.5 MB)
• 006 Durability_en.vtt (15.2 KB)
• 007 Eventual Consistency.mp4 (36.7 MB)
• 007 Eventual Consistency_en.vtt (18.6 KB)
• 008 ACID by Practical Examples.mp4 (125.8 MB)
• 008 ACID by Practical Examples_en.vtt (22.7 KB)
• 009 Phantom Reads.mp4 (33.0 MB)
• 009 Phantom Reads_en.vtt (8.9 KB)
• 010 Serializable vs Repeatable Read.mp4 (72.8 MB)
• 010 Serializable vs Repeatable Read_en.vtt (10.0 KB)
• 28160058-Eventual-Consistency.jpg (31.7 KB)
• 28160060-Eventual-Consistency.pdf (362.6 KB)
• 28160064-Eventual-Consistency.pptx (451.7 KB)
• 28160068-Eventual-Consistency.odp (443.6 KB)
• 32536504-read.pdf (4.0 MB)
• 36778652-ACID-Updated.pptx (529.7 KB)
• 36778658-ACID-Updated.odp (436.4 KB)
• 36778664-ACID-Updated.pdf (402.3 KB)

• 001 How tables and indexes are stored on disk (MUST WATCH before continue).mp4 (53.4 MB)
• 001 How tables and indexes are stored on disk (MUST WATCH before continue)_en.vtt (26.7 KB)
• 002 Row-Based vs Column-Based Databases.mp4 (81.1 MB)
• 002 Row-Based vs Column-Based Databases_en.vtt (42.7 KB)
• 003 Primary Key vs Secondary Key - What you probably didn't know.mp4 (191.1 MB)
• 003 Primary Key vs Secondary Key - What you probably didn't know_en.vtt (11.5 KB)
• 28950132-Row-Based-vs-Column-Based-Databases-1.jpg (39.7 KB)
• 28950136-Row-Based-vs-Column-Based-Databases.pptx (135.0 KB)
• 28950138-Row-Based-vs-Column-Based-Databases.odp (82.0 KB)
• 28950140-Row-Based-vs-Column-Based-Databases.pdf (177.5 KB)
• 36991010-How-tables-and-indexes-are-stored-on-disk.pptx (78.3 KB)
• 36991012-How-tables-and-indexes-are-stored-on-disk.odp (26.1 KB)
• 36991014-How-tables-and-indexes-are-stored-on-disk.pdf (59.7 KB)

• 001 Create Postgres Table with a million Rows (from scratch).mp4 (9.4 MB)
• 001 Create Postgres Table with a million Rows (from scratch)_en.vtt (5.5 KB)
• 002 Getting Started with Indexing.mp4 (124.8 MB)
• 002 Getting Started with Indexing_en.vtt (22.3 KB)
• 003 Understanding The SQL Query Planner and Optimizer with Explain.mp4 (44.0 MB)
• 003 Understanding The SQL Query Planner and Optimizer with Explain_en.vtt (14.1 KB)
• 004 Index Scan vs Index Only Scan.mp4 (31.7 MB)
• 004 Index Scan vs Index Only Scan_en.vtt (9.5 KB)
• 005 Key vs Non-Key Column Database Indexing.mp4 (116.4 MB)
• 005 Key vs Non-Key Column Database Indexing_en.vtt (20.5 KB)
• 006 Combining Database Indexes for Better Performance.mp4 (86.1 MB)
• 006 Combining Database Indexes for Better Performance_en.vtt (17.7 KB)
• 007 How Database Optimizers Decide to Use Indexes.mp4 (229.3 MB)
• 007 How Database Optimizers Decide to Use Indexes_en.vtt (14.4 KB)
• 008 Bitmap Index Scan vs Index Scan vs Table Scan.mp4 (50.9 MB)
• 008 Bitmap Index Scan vs Index Scan vs Table Scan_en.vtt (14.2 KB)
• 009 Create Index Concurrently - Avoid Blocking Production Database Writes.mp4 (15.6 MB)
• 009 Create Index Concurrently - Avoid Blocking Production Database Writes_en.vtt (3.8 KB)
• 010 Bloom Filters.mp4 (25.7 MB)
• 010 Bloom Filters_en.vtt (12.1 KB)
• 011 Working with Billion-Row Table.mp4 (316.3 MB)
• 011 Working with Billion-Row Table_en.vtt (15.6 KB)
• 012 Article - The Cost of Long running Transactions.html (2.3 KB)
• 013 Article - Microsoft SQL Server Clustered Index Design.html (5.7 KB)
• 28183792-bloom-filter.jpg (27.9 KB)
• 28183800-bloom-filter.pdf (135.6 KB)
• 28183802-bloom-filter.odp (236.5 KB)
• 28183804-bloom-filter.pptx (276.6 KB)
• 30408038-1.png (54.1 KB)
• 30408042-2.png (69.5 KB)
• 30987274-one-million-pg.txt (0.2 KB)
• 32509342-multiple-indexes.pdf (2.2 MB)
• 34765100-employees.sql (1.0 KB)
• 35793236-students.sql (1.1 KB)
• 37305960-grades.sql (0.5 KB)
• 38484996-SQL-Server-Index-Architecture-and-Design-Guide-SQL-Server-Microsoft-Docs.pdf (1.2 MB)

• 001 B-Tree Section's Introduction & Agenda.mp4 (29.6 MB)
• 001 B-Tree Section's Introduction & Agenda_en.vtt (3.8 KB)
• 002 Full Table Scans.mp4 (33.8 MB)
• 002 Full Table Scans_en.vtt (3.7 KB)
• 003 Original B-Tree.mp4 (18.3 MB)
• 003 Original B-Tree_en.vtt (5.3 KB)
• 004 How the Original B-Tree Helps Performance.mp4 (32.6 MB)
• 004 How the Original B-Tree Helps Performance_en.vtt (9.4 KB)
• 005 Original B-Tree Limitations.mp4 (27.2 MB)
• 005 Original B-Tree Limitations_en.vtt (7.0 KB)
• 006 B+Tree.mp4 (30.5 MB)
• 006 B+Tree_en.vtt (6.8 KB)
• 007 B+Tree DBMS Considerations.mp4 (23.4 MB)
• 007 B+Tree DBMS Considerations_en.vtt (4.6 KB)
• 008 B+Tree Storage Cost in MySQL vs Postgres.mp4 (28.2 MB)
• 008 B+Tree Storage Cost in MySQL vs Postgres_en.vtt (4.9 KB)
• 009 B-Tree Section's Summary.mp4 (5.1 MB)
• 009 B-Tree Section's Summary_en.vtt (1.1 KB)
• 34799532-B-trees-vs-B-trees.pptx (30.9 MB)
• 34799538-B-trees-vs-B-trees.pdf (403.1 KB)
• 34799544-B-trees-vs-B-trees.odp (31.1 MB)
• 34799924-b-tree-original-paper.pdf (624.4 KB)
• [Tutorialsplanet.NET].url (0.1 KB)

• 001 Introduction to Database Partitioning.mp4 (2.6 MB)
• 001 Introduction to Database Partitioning_en.vtt (2.0 KB)
• 002 What is Partitioning.mp4 (6.6 MB)
• 002 What is Partitioning_en.vtt (4.4 KB)
• 003 Vertical vs Horizontal Partitioning.mp4 (3.7 MB)
• 003 Vertical vs Horizontal Partitioning_en.vtt (2.6 KB)
• 004 Partitioning Types.mp4 (2.4 MB)
• 004 Partitioning Types_en.vtt (2.1 KB)
• 005 The Difference Between Partitioning and Sharding.mp4 (5.3 MB)
• 005 The Difference Between Partitioning and Sharding_en.vtt (3.6 KB)
• 006 Preparing Postgres, Database, Table, Indexes.mp4 (7.3 MB)
• 006 Preparing Postgres, Database, Table, Indexes_en.vtt (7.5 KB)
• 007 Execute Multiple Queries on the Table.mp4 (3.6 MB)
• 007 Execute Multiple Queries on the Table_en.vtt (1.5 KB)
• 008 Create and Attach Partitioned Tables.mp4 (6.1 MB)
• 008 Create and Attach Partitioned Tables_en.vtt (4.1 KB)
• 009 Populate the Partitions and Create Indexes.mp4 (5.5 MB)
• 009 Populate the Partitions and Create Indexes_en.vtt (4.6 KB)
• 010 Class Project - Querying and Checking the Size of Partitions.mp4 (30.3 MB)
• 010 Class Project - Querying and Checking the Size of Partitions_en.vtt (6.8 KB)
• 011 The Advantages of Partitioning.mp4 (7.9 MB)
• 011 The Advantages of Partitioning_en.vtt (5.8 KB)
• 012 The Disadvantages of Partitioning.mp4 (5.0 MB)
• 012 The Disadvantages of Partitioning_en.vtt (3.6 KB)
• 013 Section Summary - Partitioning.mp4 (4.5 MB)
• 013 Section Summary - Partitioning_en.vtt (1.7 KB)
• 014 How to Automate Partitioning in Postgres.mp4 (64.8 MB)
• 014 How to Automate Partitioning in Postgres_en.vtt (12.4 KB)
• 31688148-Partitioning.jpg (29.1 KB)
• 31688152-Partitioning.pptx (106.5 KB)
• 31688154-Partitioning.odp (69.5 KB)
• 31688158-Partitioning.pdf (109.8 KB)
• 31688160-Partitioning.txt (2.3 KB)

• 001 Introduction to Database Sharding.mp4 (2.1 MB)
• 001 Introduction to Database Sharding_en.vtt (1.5 KB)
• 002 What is Database Sharding.mp4 (5.6 MB)
• 002 What is Database Sharding_en.vtt (4.7 KB)
• 003 Consistent Hashing.mp4 (3.4 MB)
• 003 Consistent Hashing_en.vtt (3.7 KB)
• 004 Horizontal partitioning vs Sharding.mp4 (2.1 MB)
• 004 Horizontal partitioning vs Sharding_en.vtt (1.7 KB)
• 005 Sharding with Postgres.mp4 (2.2 MB)
• 005 Sharding with Postgres_en.vtt (1.5 KB)
• 006 Spin up Docker Postgres Shards.mp4 (16.4 MB)
• 006 Spin up Docker Postgres Shards_en.vtt (9.7 KB)
• 007 Writing to a Shard.mp4 (136.0 MB)
• 007 Writing to a Shard_en.vtt (29.4 KB)
• 008 Reading from a Shard.mp4 (56.9 MB)
• 008 Reading from a Shard_en.vtt (14.3 KB)
• 009 Advantages of Database Sharding.mp4 (2.5 MB)
• 009 Advantages of Database Sharding_en.vtt (2.8 KB)
• 010 Disadvantages of Database Sharding.mp4 (5.3 MB)
• 010 Disadvantages of Database Sharding_en.vtt (4.8 KB)
• 011 Database Sharding Section Summary.mp4 (1,015.6 KB)
• 011 Database Sharding Section Summary_en.vtt (1.1 KB)
• 012 When Should you consider Sharding your Database.mp4 (466.4 MB)
• 012 When Should you consider Sharding your Database_en.vtt (22.9 KB)
• 31688754-commands.txt (0.3 KB)
• 31688758-Sharding.jpg (28.7 KB)
• 31688762-Sharding.txt (2.0 KB)
• 31688766-Sharding.pdf (142.9 KB)
• 31688768-Sharding.odp (159.7 KB)
• 31688770-Sharding.pptx (200.8 KB)
• 38752864-links-code-commands.txt (0.3 KB)

• 001 Shared vs Exclusive Locks.mp4 (34.4 MB)
• 001 Shared vs Exclusive Locks_en.vtt (13.2 KB)
• 002 Dead Locks.mp4 (34.7 MB)
• 002 Dead Locks_en.vtt (6.5 KB)
• 003 Two-phase Locking.mp4 (16.9 MB)
• 003 Two-phase Locking_en.vtt (8.7 KB)
• 004 Solving the Double Booking Problem (Code Example).mp4 (116.9 MB)
• 004 Solving the Double Booking Problem (Code Example)_en.vtt (17.4 KB)
• 005 Double Booking Problem Part 2 ( Alternative Solution and explination).mp4 (87.5 MB)
• 005 Double Booking Problem Part 2 ( Alternative Solution and explination)_en.vtt (21.8 KB)
• 006 SQL Pagination With Offset is Very Slow.mp4 (72.3 MB)
• 006 SQL Pagination With Offset is Very Slow_en.vtt (11.0 KB)
• 007 Database Connection Pooling.mp4 (56.8 MB)
• 007 Database Connection Pooling_en.vtt (14.9 KB)
• 30404966-offset.pdf (1.9 MB)
• 30404972-offset.mp4 (1.1 MB)
• 30404978-offset.png (62.6 KB)
• 35879308-booking-system.zip (918.3 KB)
• external-assets-links.txt (0.1 KB)

• 001 Introduction to Database Replication.mp4 (3.6 MB)
• 001 Introduction to Database Replication_en.vtt (1.5 KB)
• 002 MasterStandby Replication.mp4 (12.7 MB)
• 002 MasterStandby Replication_en.vtt (4.4 KB)
• 003 Multi-master Replication.mp4 (2.1 MB)
• 003 Multi-master Replication_en.vtt (1.8 KB)
• 004 Synchronous vs Asynchronous Replication.mp4 (6.5 MB)
• 004 Synchronous vs Asynchronous Replication_en.vtt (3.7 KB)
• 005 Replication Demo with Postgres 13.mp4 (107.2 MB)
• 005 Replication Demo with Postgres 13_en.vtt (23.8 KB)
• 006 Pros and Cons of Replication.mp4 (5.2 MB)
• 006 Pros and Cons of Replication_en.vtt (4.9 KB)
• 28523393-Replication.jpg (28.6 KB)
• 28523399-Replication.pdf (143.7 KB)
• 28523405-Replication.odp (73.2 KB)
• 28523409-Replication.pptx (111.5 KB)

• 001 Twitter System Design Database Design.mp4 (447.8 MB)
• 001 Twitter System Design Database Design_en.vtt (87.2 KB)
• 002 Building a Short URL System Database Backend.mp4 (177.5 MB)
• 002 Building a Short URL System Database Backend_en.vtt (47.8 KB)

• 001 Introduction.mp4 (13.5 MB)
• 001 Introduction_en.vtt (3.9 KB)
• 002 What is a Database Engine.mp4 (12.8 MB)
• 002 What is a Database Engine_en.vtt (8.6 KB)
• 003 MyISAM.mp4 (13.5 MB)
• 003 MyISAM_en.vtt (9.1 KB)
• 004 InnoDB.mp4 (10.2 MB)
• 004 InnoDB_en.vtt (8.9 KB)
• 005 XtraDB.mp4 (3.3 MB)
• 005 XtraDB_en.vtt (2.5 KB)
• 006 SQLite.mp4 (6.0 MB)
• 006 SQLite_en.vtt (4.7 KB)
• 007 Aria.mp4 (3.5 MB)
• 007 Aria_en.vtt (3.0 KB)
• 008 BerkeleyDB.mp4 (4.0 MB)
• 008 BerkeleyDB_en.vtt (3.4 KB)
• 009 LevelDB.mp4 (10.6 MB)
• 009 LevelDB_en.vtt (7.8 KB)
• 010 RocksDB.mp4 (6.4 MB)
• 010 RocksDB_en.vtt (5.3 KB)
• 011 Popular Database Engines.mp4 (5.7 MB)
• 011 Popular Database Engines_en.vtt (3.1 KB)
• 012 Switching Database Engines with mySQL.mp4 (93.7 MB)
• 012 Switching Database Engines with mySQL_en.vtt (21.3 KB)
• 28183022-Database-Engines.jpg (37.6 KB)
• 28183024-Database-Engines.pdf (238.4 KB)
• 28183030-Database-Engines.odp (314.8 KB)
• 28183034-Database-Engines.pptx (345.2 KB)
• [Tutorialsplanet.NET].url (0.1 KB)

• 001 What are Database Cursors.mp4 (10.1 MB)
• 001 What are Database Cursors_en.vtt (12.0 KB)
• 002 Server Side vs Client Side Database Cursors.mp4 (10.9 MB)
• 002 Server Side vs Client Side Database Cursors_en.vtt (2.0 KB)
• 003 Inserting Million Rows with Python in Postgres using Client Side Cursor.mp4 (8.2 MB)
• 003 Inserting Million Rows with Python in Postgres using Client Side Cursor_en.vtt (3.6 KB)
• 004 Querying with Client Side Cursor.mp4 (15.7 MB)
• 004 Querying with Client Side Cursor_en.vtt (5.3 KB)
• 005 Querying with Server Side Cursor.mp4 (5.3 MB)
• 005 Querying with Server Side Cursor_en.vtt (1.6 KB)
• 006 Pros and Cons of Server vs Client Side Cursors.mp4 (15.9 MB)
• 006 Pros and Cons of Server vs Client Side Cursors_en.vtt (5.8 KB)
• [Tutorialsplanet.NET].url (0.1 KB)

• 001 How to Secure Your Postgres Database by Enabling TLSSSL.mp4 (67.2 MB)
• 001 How to Secure Your Postgres Database by Enabling TLSSSL_en.vtt (14.9 KB)
• 002 Deep Look into Postgres Wire Protocol with Wireshark.mp4 (135.7 MB)
• 002 Deep Look into Postgres Wire Protocol with Wireshark_en.vtt (17.3 KB)
• 003 Deep Look Into MongoDB Wire Protocol with Wireshark.mp4 (262.1 MB)
• 003 Deep Look Into MongoDB Wire Protocol with Wireshark_en.vtt (30.4 KB)
• 004 What is the Largest SQL Statement that You can Send to Your Database.mp4 (117.4 MB)
• 004 What is the Largest SQL Statement that You can Send to Your Database_en.vtt (10.5 KB)
• 005 Best Practices Working with REST & Databases.mp4 (113.9 MB)
• 005 Best Practices Working with REST & Databases_en.vtt (7.9 KB)
• 006 Database Permissions and Best Practices for Building REST API.mp4 (118.8 MB)
• 006 Database Permissions and Best Practices for Building REST API_en.vtt (27.5 KB)

• 001 Introduction to Homomorphic Encryption.mp4 (4.9 MB)
• 001 Introduction to Homomorphic Encryption_en.vtt (2.2 KB)
• 002 What is Encryption.mp4 (2.7 MB)
• 002 What is Encryption_en.vtt (2.0 KB)
• 003 Why Can't we always Encrypt.mp4 (8.4 MB)
• 003 Why Can't we always Encrypt_en.vtt (6.0 KB)
• 004 What is Homomorphic Encryption.mp4 (10.0 MB)
• 004 What is Homomorphic Encryption_en.vtt (6.0 KB)
• 005 Homomorphic Encryption Demo.mp4 (748.3 KB)
• 005 Homomorphic Encryption Demo_en.vtt (0.8 KB)
• 006 Clone and Build the Code.mp4 (17.6 MB)
• 006 Clone and Build the Code_en.vtt (3.3 KB)
• 007 Going Through the Code and the Database.mp4 (9.3 MB)
• 007 Going Through the Code and the Database_en.vtt (1.4 KB)
• 008 Searching The Encrypted Database.mp4 (18.9 MB)
• 008 Searching The Encrypted Database_en.vtt (3.9 KB)
• 009 Is Homomorphic Encryption Ready.mp4 (6.4 MB)
• 009 Is Homomorphic Encryption Ready_en.vtt (3.3 KB)
• 31708486-commands.txt (0.4 KB)
• 31708488-Homomorphic-Encryption.jpg (26.9 KB)
• 31708490-Homomorphic-Encryption.odp (33.2 KB)
• 31708492-Homomorphic-Encryption.pdf (87.5 KB)
• 31708494-Homomorphic-Encryption.pptx (70.0 KB)
• 31708500-Homomorphic-Encryption.txt (2.8 KB)

• 001 Q&A - October 2021.mp4 (94.9 MB)
• 001 Q&A - October 2021_en.vtt (21.3 KB)
• 002 Q&A - November 2021.mp4 (366.6 MB)
• 002 Q&A - November 2021_en.vtt (28.6 KB)
• 003 Q&A - December 2021.mp4 (99.2 MB)
• 003 Q&A - December 2021_en.vtt (24.9 KB)
• [Tutorialsplanet.NET].url (0.1 KB)

• 001 SELECT COUNT () can impact your Backend Application performance, here is why.mp4 (65.5 MB)
• 001 SELECT COUNT () can impact your Backend Application performance, here is why_en.vtt (13.3 KB)
• 002 How does the Database Store Data On Disk.mp4 (324.7 MB)
• 002 How does the Database Store Data On Disk_en.vtt (22.2 KB)
• 003 Is QUIC a Good Protocol for Databases.mp4 (282.2 MB)
• 003 Is QUIC a Good Protocol for Databases_en.vtt (14.4 KB)
• 004 What is a Distributed Transaction.mp4 (371.9 MB)
• 004 What is a Distributed Transaction_en.vtt (27.3 KB)
• 005 Why Uber Moved from Postgres to MySQL (Discussion).mp4 (673.3 MB)
• 005 Why Uber Moved from Postgres to MySQL (Discussion)_en.vtt (55.0 KB)
• 006 Can NULLs Improve your Database Queries Performance.mp4 (437.6 MB)
• 006 Can NULLs Improve your Database Queries Performance_en.vtt (24.7 KB)
• 007 Write Amplification Explained in Backend Apps, Database Systems and SSDs.mp4 (437.3 MB)
• 007 Write Amplification Explained in Backend Apps, Database Systems and SSDs_en.vtt (27.1 KB)
• 008 Optimistic vs Pessmistic Concurrency Control.mp4 (379.4 MB)
• 008 Optimistic vs Pessmistic Concurrency Control_en.vtt (19.5 KB)
• 33213918-NULL.pdf (134.4 KB)

• 001 Introduction to ACID (Archived).mp4 (2.6 MB)
• 001 Introduction to ACID (Archived)_en.vtt (2.0 KB)
• 002 What is a Transaction (Archived).mp4 (3.6 MB)
• 002 What is a Transaction (Archived)_en.vtt (3.5 KB)
• 003 Atomicity (Archived).mp4 (4.0 MB)
• 003 Atomicity (Archived)_en.vtt (3.6 KB)
• 004 Isolation (Archived).mp4 (35.4 MB)
• 004 Isolation (Archived)_en.vtt (25.4 KB)
• 005 Consistency (Archived).mp4 (17.5 MB)
• 005 Consistency (Archived)_en.vtt (15.4 KB)
• 006 Durability (Archived).mp4 (1.8 MB)
• 006 Durability (Archived)_en.vtt (2.4 KB)
• 31503186-ACID.pptx (403.5 KB)
• 31503188-ACID.odp (353.0 KB)
• 31503194-ACID.pdf (275.5 KB)
• [Tutorialsplanet.NET].url (0.1 KB)