Course Content
10 – Database System Design
0/2
001 Twitter System Design Database Design.mp4
01:11:56
002 Building a Short URL System Database Backend.mp4
37:49
18 – Archived Lectures
0/6
001 Introduction to ACID (Archived).mp4
01:39
002 What is a Transaction (Archived).mp4
02:31
003 Atomicity (Archived).mp4
02:39
004 Isolation (Archived).mp4
20:35
005 Consistency (Archived).mp4
13:05
006 Durability (Archived).mp4
01:44
17 – Database Discussions
0/13
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
0/15
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
0/9
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
0/6
001 How to Secure Your Postgres Database by Enabling TLSSSL.mp4
12:01
002 Deep Look into Postgres Wire Protocol with Wireshark.mp4
14:07
003 Deep Look Into MongoDB Wire Protocol with Wireshark.mp4
24:04
004 What is the Largest SQL Statement that You can Send to Your Database.mp4
09:43
005 Best Practices Working with REST & Databases.mp4
06:53
006 Database Permissions and Best Practices for Building REST API.mp4
23:40
13 – SQL vs NoSQL Architecture
0/1
001 MongoDB Architecture.mp4
43:24
12 – Database Cursors
0/6
001 What are Database Cursors.mp4
09:31
002 Server Side vs Client Side Database Cursors.mp4
01:44
003 Inserting Million Rows with Python in Postgres using Client Side Cursor.mp4
03:29
004 Querying with Client Side Cursor.mp4
04:42
005 Querying with Server Side Cursor.mp4
01:24
006 Pros and Cons of Server vs Client Side Cursors.mp4
04:38
11 – Database Engines
0/12
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
0/4
001 Welcome to the Course.mp4
06:36
002 Course Note 1.mp4
00:37
003 Course Note 2.mp4
07:36
004 Course Note 3.mp4
09:24
09 – Database Replication
0/6
001 Introduction to Database Replication.mp4
01:19
002 MasterStandby Replication.mp4
03:45
003 Multi-master Replication.mp4
01:23
004 Synchronous vs Asynchronous Replication.mp4
03:06
005 Replication Demo with Postgres 13.mp4
19:20
006 Pros and Cons of Replication.mp4
03:27
08 – Concurrency Control
0/8
001 Shared vs Exclusive Locks.mp4
11:04
002 Dead Locks.mp4
05:31
003 Two-phase Locking.mp4
07:08
004 Solving the Double Booking Problem (Code Example).mp4
13:42
005 Double Booking Problem Part 2 ( Alternative Solution and explination).mp4
17:49
006 offset.mp4
00:39
006 SQL Pagination With Offset is Very Slow.mp4
09:09
007 Database Connection Pooling.mp4
10:50
07 – Database Sharding
0/12
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
0/14
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
0/9
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
0/11
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
0/3
001 How tables and indexes are stored on disk (MUST WATCH before continue).mp4
21:03
002 Row-Based vs Column-Based Databases.mp4
34:15
003 Primary Key vs Secondary Key – What you probably didn’t know.mp4
10:56
02 – ACID
0/10
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
[Last updated 4/2024] Fundamentals of Database Engineering (Udemy – Engsub)
Previous
Next
0% Complete