Database Engineering

Dive into an extensive collection of database engineering videos covering a wide range of topics including ACID transactions, indexing strategies, database partitioning, replication, sharding, concurrency control, and various database engines. Explore in-depth explanations of B-Trees, bloom filters, and different database types such as relational, column-oriented, and in-memory databases. Learn about performance optimization techniques, query planning, and how to handle large-scale data efficiently. Discover insights on database design for microservices, system design considerations, and real-world case studies from companies like Discord and Uber. Gain practical knowledge on working with PostgreSQL, MySQL, MongoDB, Redis, and other popular database systems, as well as understanding the intricacies of database operations on both SSDs and HDDs.

Relational Database ACID Transactions (Explained by Example).
B-Tree vs B+Tree in Production Database Systems.
Key vs Non-Key Column Database Indexing.
SELECT COUNT (*) can impact your Backend Application Performance, here is why.
Column vs Row Oriented Databases Explained.
Can you get Eventual Consistency in Relational Databases?.
Database Indexing Explained (with PostgreSQL).
Indexing in PostgreSQL vs MySQL.
Explain Explained in PostgreSQL - How Databases Prepare Optimal Query Plans to Execute SQL.
Is SELECT * Expensive?.
Bloom Filters Explained by Example.
Database Partitioning Crash Course (with Postgres).
Horizontal vs Vertical Database Partitioning.
Database Replication Crash Course ( with Postgres 13 ).
Database Engines Crash Course (MyISAM, Aria, InnoDB, XtraDB, LevelDB & RocksDB).
Database Sharding Crash Course (with Postgres examples).
Avoid premature Database Sharding.
Pessimistic concurrency control vs Optimistic concurrency control in Database Systems Explained.
Two Phase Locking Explained (2PL).
Redis In-memory Database Crash Course.
Spinning MongoDB, MongoShell and Mongo GUI with Docker.
Database Exclusive lock vs Shared Lock (Explained by Example).
Connection Pooling in PostgresSQL with NodeJS (Performance Numbers).
Building a Web API with Express and PostgreSQL to Consume from Browser.
IndexedDB Crash Course with Javascript.
Postgres Database Cursors in Python with psycopg2.
Database Dead Locks Explained by Example.
Step by Step Javascript and Postgres Tutorial using node-postgres.
Step-by-Step Python and Postgres Tutorial with psycopg2.
Spinning multiple Postgres instances and PGAdmin with Docker.
Step by Step Mysql 8.x and Javascript Tutorial (with mysql2 NodeJs).
What is a Distributed Transaction in Microservices?.
How to Avoid Double Booking and Race Conditions in Online Web Applications.
Multi-player System Game Design - Pros & Cons of Proposed Designs & System Design Interviews Advice.
When should you shard your database?.
Can the QUIC Protocol improve Database Performance in Web Applications?.
URL Shortener System Design (Explained with Two proposed Designs with Pro and Cons of each).
How Do Databases Store Tables on Disk? Explained both SSD & HDD.
Concurrent Requests and Unique Keys on Web Applications.
Carnegie Mellon University Advanced Database Course Is a GREAT resource for Backend Engineers!.
Keep your Servers Close and Your Database Closer.
What is the Largest SQL Query We can Send Before The Database Process Crashes?.
MariaDB vs MySQL SSD NVMe vs SATA Performance - Discussions on the Percona Benchmark.
What caused the cold start performance “dip” in MariaDB .. Let us discuss (@Percona Article).
Best Practices Working with Billion-row Tables in Databases.
Index Scan vs Index Only Scan on Database Systems (with Postgres).
Why Discord Moved from MongoDB to Apache Cassandra, Let us Discuss.
PostgreSQL 13 Has Some Performance Boosts! Let us discuss it!.
Opening Old Wounds - Why Uber Engineering Switched from Postgres to MySQL.
Why Redis Became the Most Popular Database on the Cloud in 2020.
Basic Caching Techniques Explained - Spatial, Temporal, Distributed, Write-Through, Write-Back,Aside.
Will AWS Babelfish Succeed in Moving Developers Away from SQL Server to Postgres?.
Meet mySQL RAPID - distributed, in-memory, columnar, query processing engine by ORACLE.
Combining Database Indexes for Better Performance in Your Backend Applications (with PostgreSQL).
don’t use “offset” in your SQL.
Burned by Docker and it was my fault.
Bitmap Index Scan in Postgres Explained with Examples (Members only).
Is EventStoreDB the First Native gRPC Database?.
Create Index Blocking Production Database Writes? Postgres Solves this with this trick.
How to Automate Partitioning in Postgres.
UUIDs are Bad for Performance in MySQL - Is Postgres better? Let us Discuss.
Redis In-Memory Database Crash Course.
Phantom Reads in Postgres Explained Compared to Other DBMS.
Serializable vs Repeatable Read Isolation Level - When to use one over the other in Database Systems.
How Database Cursors Help in Fetching Large Result sets from your SQL.
Watch out before Adding Indexes to Your Table, Your Database Optimizer Might not Use them.
Write Amplification Explained in Backend Apps, Database Systems and SSDs.
Can NULLs Improve your Database Queries Performance? - The Backend Engineering Show.
SELECT COUNT(*) is Slow, Estimate it Instead (with Example in Node JS and Postgres).
Auth0 MongoDB Gets Overloaded Causes an Major Outage.
The Tale of OLTP, OLAP, and HTAP in Data Warehousing - The Backend Engineering Show.
Optimizing Communication and Networking in Database Systems - The Backend Engineering Show.
The New Postgres 14 Looks Promising - The Backend Engineering Show with Hussein Nasser.
Primary Key vs Secondary Key - What you probably didn't know (Members ONLY).
All Types of Database Replication Discussed.
My thoughts on the CAP theorem.
B-tree vs B+ tree in Database Systems.
Should you go with an Optimistic or Pessimistic Concurrency Control Database?.
Can Redis be used as a Primary database?.
Turns out MySQL Statement-based Replication might not be a good idea, Lets discuss why.
Partial Indexing | The Backend Engineering Show.
Update your database statistics often or your SQL queries will suffer #shorts.
Table Clustering in MySQL and Postgres - The pros and cons.
How Redis efficiently snapshots gigabytes of memory to disk (forking).
backend leaking Postgres database connections - what I did to fix it.
on graph databases.
On Graph Databases | The Backend Engineering Show.
The cost rolling back transactions (postgres/mysql).
when indexes are useless | The Backend Engineering Show.
What is the cost of Indexing too many columns - Udemy Q&A November 2021.
Postgres index bloat | The Backend Engineering Show.
what is a database index?.
The limitations of today’s SSDs | The Backend Engineering Show.
Why this query is fast.
Redo, Undo and WAL logs | The Backend Engineering Show.
Sorting in Postgres 15 is 371% faster in certain cases.