[Last updated 4/2024] Fundamentals of Database Engineering (Udemy – Engsub)

About Course

Views

What you’ll learn:
Learn and understand ACID Properties
Database Indexing
Database Replication
Database Cursors
B-Trees in Production Database Systems
Difference between Database Management System, Database Engine and Embedded database
Benefits of Using one database engine over the other
Database Security
Homomorphic Encryption
Switching Database Engines with MySQL
Database Engines such as MyISAM, InnoDB, RocksDB, LevelDB and More
Database System Designs
Concurrency Control (Optimistic, Pessimistic)
Database Partitioning
Time video:
26 hours (157 Lessons + Documents)
Teacher:
Hussein Nasser
Total weight:
12.77 GB

Original link:
https://www.udemy.com/course/database-engines-crash-course/
Link :
Below The Post

Khuyên dùng phần mềm 7Zip để giải nén!

Course Content

10 – Database System Design

001 Twitter System Design Database Design.mp4

01:11:56
002 Building a Short URL System Database Backend.mp4

37:49

18 – Archived Lectures

17 – Database Discussions

001 WAL, Redo and Undo logs.mp4

39:10
002 SELECT COUNT () can impact your Backend Application performance, here is why.mp4

10:36
003 How Shopify Switched from UUID as Primary Key.mp4

31:22
004 How does the Database Store Data On Disk.mp4

18:55
005 Postgres Architecture.mp4

33:15
006 Is QUIC a Good Protocol for Databases.mp4

12:15
007 What is a Distributed Transaction.mp4

21:27
008 Hash Tables and Consistent Hashing.mp4

49:22
009 Indexing in PostgreSQL vs MySQL.mp4

13:01
010 Why Uber Moved from Postgres to MySQL (Discussion).mp4

47:13
011 Can NULLs Improve your Database Queries Performance.mp4

21:12
012 Write Amplification Explained in Backend Apps, Database Systems and SSDs.mp4

21:15
013 Optimistic vs Pessmistic Concurrency Control.mp4

17:36

16 – Answering your Questions

001 Heap Index scan instead of Index only scan why.mp4

12:54
002 What is the unit of the Cost in Postgres Planner.mp4

06:15
003 All Isolation Levels – Explained Details.mp4

26:07
004 Snapshot and Repeatable Read Isolation difference.mp4

07:55
005 I have an Index why is the database doing a full table scan.mp4

07:37
006 Why Databases Read Pages instead of Rows.mp4

11:02
007 How does Indexing a column with duplicate values work.mp4

10:53
008 Should I drop unused indexes.mp4

08:45
009 Why use serializable Isolation Level when we have SELECT FOR UPDATE.mp4

06:59
010 Can I use the same database connection for multiple clients.mp4

07:00
011 Do I need a transaction if I’m only reading.mp4

15:47
012 Why does an update in Postgres touches all indexes.mp4

23:49
013 What is the value of bitmap index scan.mp4

25:44
014 What does Explain Analyze actually do.mp4

19:37
016 Does Create Index block writes and Why.mp4

11:15

15 – Homomorphic Encryption – Performing Database Queries on Encrypted Data

001 Introduction to Homomorphic Encryption.mp4

01:52
002 What is Encryption.mp4

01:29
003 Why Can’t we always Encrypt.mp4

04:32
004 What is Homomorphic Encryption.mp4

05:00
005 Homomorphic Encryption Demo.mp4

00:35
006 Clone and Build the Code.mp4

02:35
007 Going Through the Code and the Database.mp4

01:05
008 Searching The Encrypted Database.mp4

03:11
009 Is Homomorphic Encryption Ready.mp4

02:30

14 – Database Security

13 – SQL vs NoSQL Architecture

12 – Database Cursors

11 – Database Engines

001 Introduction.mp4

02:44
002 What is a Database Engine.mp4

06:41
003 MyISAM.mp4

06:49
004 InnoDB.mp4

06:44
005 XtraDB.mp4

02:06
006 SQLite.mp4

03:44
007 Aria.mp4

02:27
008 BerkeleyDB.mp4

02:40
009 LevelDB.mp4

06:20
010 RocksDB.mp4

04:05
011 Popular Database Engines.mp4

02:31
012 Switching Database Engines with mySQL.mp4

17:08

01 – Course Updates

09 – Database Replication

08 – Concurrency Control

07 – Database Sharding

001 Introduction to Database Sharding.mp4

01:06
002 What is Database Sharding.mp4

03:31
003 Consistent Hashing.mp4

02:41
004 Horizontal partitioning vs Sharding.mp4

01:08
005 Sharding with Postgres.mp4

01:05
006 Spin up Docker Postgres Shards.mp4

07:23
007 Writing to a Shard.mp4

21:58
008 Reading from a Shard.mp4

11:19
009 Advantages of Database Sharding.mp4

01:59
010 Disadvantages of Database Sharding.mp4

03:33
011 Database Sharding Section Summary.mp4

00:44
012 When Should you consider Sharding your Database.mp4

20:06

06 – Database Partitioning

001 Introduction to Database Partitioning.mp4

01:26
002 What is Partitioning.mp4

03:28
003 Vertical vs Horizontal Partitioning.mp4

02:07
004 Partitioning Types.mp4

01:32
005 The Difference Between Partitioning and Sharding.mp4

02:43
006 Preparing Postgres, Database, Table, Indexes.mp4

05:22
007 Execute Multiple Queries on the Table.mp4

01:18
008 Create and Attach Partitioned Tables.mp4

03:46
009 Populate the Partitions and Create Indexes.mp4

03:59
010 Class Project – Querying and Checking the Size of Partitions.mp4

05:32
011 The Advantages of Partitioning.mp4

04:41
012 The Disadvantages of Partitioning.mp4

02:47
013 Section Summary – Partitioning.mp4

01:10
014 How to Automate Partitioning in Postgres.mp4

10:05

05 – B-Tree vs B+Tree in Production Database Systems

001 B-Tree Section’s Introduction & Agenda.mp4

03:34
002 Full Table Scans.mp4

03:27
003 Original B-Tree.mp4

04:46
004 How the Original B-Tree Helps Performance.mp4

07:56
005 Original B-Tree Limitations.mp4

06:31
006 B+Tree.mp4

06:17
007 B+Tree DBMS Considerations.mp4

04:27
008 B+Tree Storage Cost in MySQL vs Postgres.mp4

04:45
009 B-Tree Section’s Summary.mp4

01:07

04 – Database Indexing

001 Create Postgres Table with a million Rows (from scratch).mp4

04:22
002 Getting Started with Indexing.mp4

18:18
003 Understanding The SQL Query Planner and Optimizer with Explain.mp4

10:16
004 Bitmap Index Scan vs Index Scan vs Table Scan.mp4

11:24
005 Key vs Non-Key Column Database Indexing.mp4

17:02
006 Index Scan vs Index Only Scan.mp4

08:08
007 Combining Database Indexes for Better Performance.mp4

14:07
008 How Database Optimizers Decide to Use Indexes.mp4

11:19
009 Create Index Concurrently – Avoid Blocking Production Database Writes.mp4

03:10
010 Bloom Filters.mp4

09:18
011 Working with Billion-Row Table.mp4

13:08

03 – Understanding Database Internals

02 – ACID

001 Introduction to ACID.mp4

03:54
002 What is a Transaction.mp4

13:34
003 Atomicity.mp4

10:03
004 Isolation.mp4

31:53
005 Consistency.mp4

12:41
006 Durability.mp4

12:12
007 ACID by Practical Examples.mp4

21:20
008 Phantom Reads.mp4

07:35
009 Serializable vs Repeatable Read.mp4

08:17
010 Eventual Consistency.mp4

14:33

Student Ratings & Reviews

No Review Yet

About Course

Course Content

10 – Database System Design

001 Twitter System Design Database Design.mp4

002 Building a Short URL System Database Backend.mp4

18 – Archived Lectures

001 Introduction to ACID (Archived).mp4

002 What is a Transaction (Archived).mp4

003 Atomicity (Archived).mp4

004 Isolation (Archived).mp4

005 Consistency (Archived).mp4

006 Durability (Archived).mp4

17 – Database Discussions

001 WAL, Redo and Undo logs.mp4

002 SELECT COUNT () can impact your Backend Application performance, here is why.mp4

003 How Shopify Switched from UUID as Primary Key.mp4

004 How does the Database Store Data On Disk.mp4

005 Postgres Architecture.mp4

006 Is QUIC a Good Protocol for Databases.mp4

007 What is a Distributed Transaction.mp4

008 Hash Tables and Consistent Hashing.mp4

009 Indexing in PostgreSQL vs MySQL.mp4

010 Why Uber Moved from Postgres to MySQL (Discussion).mp4

011 Can NULLs Improve your Database Queries Performance.mp4

012 Write Amplification Explained in Backend Apps, Database Systems and SSDs.mp4

013 Optimistic vs Pessmistic Concurrency Control.mp4

16 – Answering your Questions

001 Heap Index scan instead of Index only scan why.mp4

002 What is the unit of the Cost in Postgres Planner.mp4

003 All Isolation Levels – Explained Details.mp4

004 Snapshot and Repeatable Read Isolation difference.mp4

005 I have an Index why is the database doing a full table scan.mp4

006 Why Databases Read Pages instead of Rows.mp4

007 How does Indexing a column with duplicate values work.mp4

008 Should I drop unused indexes.mp4

009 Why use serializable Isolation Level when we have SELECT FOR UPDATE.mp4

010 Can I use the same database connection for multiple clients.mp4

011 Do I need a transaction if I’m only reading.mp4

012 Why does an update in Postgres touches all indexes.mp4

013 What is the value of bitmap index scan.mp4

014 What does Explain Analyze actually do.mp4

016 Does Create Index block writes and Why.mp4

15 – Homomorphic Encryption – Performing Database Queries on Encrypted Data

001 Introduction to Homomorphic Encryption.mp4

002 What is Encryption.mp4

003 Why Can’t we always Encrypt.mp4

004 What is Homomorphic Encryption.mp4

005 Homomorphic Encryption Demo.mp4

006 Clone and Build the Code.mp4

007 Going Through the Code and the Database.mp4

008 Searching The Encrypted Database.mp4

009 Is Homomorphic Encryption Ready.mp4

14 – Database Security

001 How to Secure Your Postgres Database by Enabling TLSSSL.mp4

002 Deep Look into Postgres Wire Protocol with Wireshark.mp4

003 Deep Look Into MongoDB Wire Protocol with Wireshark.mp4

004 What is the Largest SQL Statement that You can Send to Your Database.mp4

005 Best Practices Working with REST & Databases.mp4

006 Database Permissions and Best Practices for Building REST API.mp4

13 – SQL vs NoSQL Architecture

001 MongoDB Architecture.mp4

12 – Database Cursors

001 What are Database Cursors.mp4

002 Server Side vs Client Side Database Cursors.mp4

003 Inserting Million Rows with Python in Postgres using Client Side Cursor.mp4

004 Querying with Client Side Cursor.mp4

005 Querying with Server Side Cursor.mp4

006 Pros and Cons of Server vs Client Side Cursors.mp4

11 – Database Engines

001 Introduction.mp4

002 What is a Database Engine.mp4

003 MyISAM.mp4

004 InnoDB.mp4

005 XtraDB.mp4

006 SQLite.mp4

007 Aria.mp4

008 BerkeleyDB.mp4

009 LevelDB.mp4

010 RocksDB.mp4

011 Popular Database Engines.mp4