Play all

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

Description:

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.

Database Engineering

Hussein Nasser

Add to list

#Programming #Databases #Relational Databases #PostgreSQL #Computer Science #Data Structures #B-trees #Distributed Systems #Eventual Consistency #Information Technology #Data Management #Database Engineering

0:00 / 0:00