Enrolment options
Udemy - Fundamentals of Database Engineering 2025-9
- Enrolled students: There are no students enrolled in this course.
Guests cannot access this course. Please log in.
Course content
Sections:
18
•
Activities:
1
•
Resources:
154
- Announcements
- 1 Welcome to the Course
- 2 Course Note 1
- 3 Course Note 2
- 4 Course Note 3
- 1 Introduction to ACID
- 2 What is a Transaction
- 3 Atomicity
- 4 Isolation
- 5 Consistency
- 6 Durability
- 7 ACID by Practical Examples
- 8 Phantom Reads
- 9 Serializable vs Repeatable Read
- 10 Eventual Consistency
- 1 How tables and indexes are stored on disk MUST WATCH before continue
- 2 Row Based vs Column Based Databases
- 3 Primary Key vs Secondary Key What you probably didnt know
- 1 Create Postgres Table with a million Rows from scratch
- 2 Getting Started with Indexing
- 3 Understanding The SQL Query Planner and Optimizer with Explain
- 4 Bitmap Index Scan vs Index Scan vs Table Scan
- 5 Key vs Non Key Column Database Indexing
- 6 Index Scan vs Index Only Scan
- 7 Combining Database Indexes for Better Performance
- 8 How Database Optimizers Decide to Use Indexes
- 9 Create Index Concurrently Avoid Blocking Production Database Writes
- 10 Bloom Filters
- 11 Working with Billion Row Table
- 12 How UUIDs in BTree Indexes affect performance
- 1 B Tree Sections Introduction Agenda
- 2 Full Table Scans
- 3 Original B Tree
- 4 How the Original B Tree Helps Performance
- 5 Original B Tree Limitations
- 6 BTree
- 7 BTree DBMS Considerations
- 8 BTree Storage Cost in MySQL vs Postgres
- 9 B Tree Sections Summary
- 1 Introduction to Database Partitioning
- 2 What is Partitioning
- 3 Vertical vs Horizontal Partitioning
- 4 Partitioning Types
- 5 The Difference Between Partitioning and Sharding
- 6 Preparing Postgres Database Table Indexes
- 7 Execute Multiple Queries on the Table
- 8 Create and Attach Partitioned Tables
- 9 Populate the Partitions and Create Indexes
- 10 Class Project Querying and Checking the Size of Partitions
- 11 The Advantages of Partitioning
- 12 The Disadvantages of Partitioning
- 13 Section Summary Partitioning
- 14 How to Automate Partitioning in Postgres
- 1 Introduction to Database Sharding
- 2 What is Database Sharding
- 3 Consistent Hashing
- 4 Horizontal partitioning vs Sharding
- 5 Sharding with Postgres
- 6 Spin up Docker Postgres Shards
- 7 Writing to a Shard
- 8 Reading from a Shard
- 9 Advantages of Database Sharding
- 10 Disadvantages of Database Sharding
- 11 Database Sharding Section Summary
- 12 When Should you consider Sharding your Database
- 1 Shared vs Exclusive Locks
- 2 Dead Locks
- 3 Two phase Locking
- 4 Solving the Double Booking Problem Code Example
- 5 Double Booking Problem Part 2 Alternative Solution and explination
- 6 SQL Pagination With Offset is Very Slow
- 6 offset
- 7 Database Connection Pooling
- 1 Introduction to Database Replication
- 2 MasterStandby Replication
- 3 Multi master Replication
- 4 Synchronous vs Asynchronous Replication
- 5 Replication Demo with Postgres 13
- 6 Pros and Cons of Replication
- 1 Twitter System Design Database Design
- 2 Building a Short URL System Database Backend
- 1 Introduction
- 2 What is a Database Engine
- 3 MyISAM
- 4 InnoDB
- 5 XtraDB
- 6 SQLite
- 7 Aria
- 8 BerkeleyDB
- 9 LevelDB
- 10 RocksDB
- 11 Popular Database Engines
- 12 Switching Database Engines with mySQL
- 1 What are Database Cursors
- 2 Server Side vs Client Side Database Cursors
- 3 Inserting Million Rows with Python in Postgres using Client Side Cursor
- 4 Querying with Client Side Cursor
- 5 Querying with Server Side Cursor
- 6 Pros and Cons of Server vs Client Side Cursors
- 1 SQL vs NoSQL and how MongoDB Revolutionized NoSQL
- 3 MongoDB Clustered Collections
- 5 Memcached NoSQL Architecture
- 6 NOSQL Redis Internals
- 7 CAP Theorem Explained
- 1 How to Secure Your Postgres Database by Enabling TLSSSL
- 2 Deep Look into Postgres Wire Protocol with Wireshark
- 3 Deep Look Into MongoDB Wire Protocol with Wireshark
- 4 What is the Largest SQL Statement that You can Send to Your Database
- 5 Best Practices Working with REST Databases
- 6 Database Permissions and Best Practices for Building REST API
- 1 Introduction to Homomorphic Encryption
- 2 What is Encryption
- 3 Why Cant we always Encrypt
- 4 What is Homomorphic Encryption
- 5 Homomorphic Encryption Demo
- 6 Clone and Build the Code
- 7 Going Through the Code and the Database
- 8 Searching The Encrypted Database
- 9 Is Homomorphic Encryption Ready
- 1 Heap Index scan instead of Index only scan why
- 2 What is the unit of the Cost in Postgres Planner
- 3 All Isolation Levels Explained Details
- 4 Snapshot and Repeatable Read Isolation difference
- 5 I have an Index why is the database doing a full table scan
- 6 Why Databases Read Pages instead of Rows
- 7 How does Indexing a column with duplicate values work
- 8 Should I drop unused indexes
- 9 Why use serializable Isolation Level when we have SELECT FOR UPDATE
- 10 Can I use the same database connection for multiple clients
- 11 Do I need a transaction if Im only reading
- 12 Why does an update in Postgres touches all indexes
- 13 What is the value of bitmap index scan
- 14 What does Explain Analyze actually do
- 16 Does Create Index block writes and Why
- 1 WAL Redo and Undo logs
- 2 SELECT COUNT can impact your Backend Application performance here is why
- 3 How Shopify Switched from UUID as Primary Key
- 4 How does the Database Store Data On Disk
- 5 Postgres Architecture
- 6 Is QUIC a Good Protocol for Databases
- 7 What is a Distributed Transaction
- 8 Hash Tables and Consistent Hashing
- 9 Indexing in PostgreSQL vs MySQL
- 10 Why Uber Moved from Postgres to MySQL Discussion
- 11 Can NULLs Improve your Database Queries Performance
- 12 Write Amplification Explained in Backend Apps Database Systems and SSDs
- 13 Optimistic vs Pessmistic Concurrency Control
- 17 MySQL InnoDB Advanced Locking Techniques
- 1 Introduction to ACID Archived
- 2 What is a Transaction Archived
- 3 Atomicity Archived 2022
- 4 Isolation Archived 2022
- 5 Consistency Archived 2022
- 6 Durability Archived 2022
- 7 Atomicity Archived 2024