Database Engineering
114 videos • 109,793 views • by Hussein Nasser
Videos on Database Engineering, ACID, Memory databases and much more by Hussein Nasser
1
Relational Database ACID Transactions (Explained by Example)
Hussein Nasser
Download
2
B-Tree vs B+Tree in Production Database Systems
Hussein Nasser
Download
3
Key vs Non-Key Column Database Indexing
Hussein Nasser
Download
4
SELECT COUNT (*) can impact your Backend Application Performance, here is why
Hussein Nasser
Download
5
Column vs Row Oriented Databases Explained
Hussein Nasser
Download
6
Can you get Eventual Consistency in Relational Databases?
Hussein Nasser
Download
7
Database Indexing Explained (with PostgreSQL)
Hussein Nasser
Download
8
Indexing in PostgreSQL vs MySQL
Hussein Nasser
Download
9
Postgres Explain Explained - How Databases Prepare Optimal Query Plans to Execute SQL
Hussein Nasser
Download
10
Is SELECT * Expensive?
Hussein Nasser
Download
11
Bloom Filters Explained by Example
Hussein Nasser
Download
12
Database Partitioning Crash Course (with Postgres)
Hussein Nasser
Download
13
Horizontal vs Vertical Database Partitioning
Hussein Nasser
Download
14
Database Replication Crash Course ( with Postgres 13 )
Hussein Nasser
Download
15
Database Engines Crash Course (MyISAM, Aria, InnoDB, XtraDB, LevelDB & RocksDB)
Hussein Nasser
Download
16
Database Sharding Crash Course (with Postgres examples)
Hussein Nasser
Download
17
Avoid premature Database Sharding
Hussein Nasser
Download
18
Pessimistic concurrency control vs Optimistic concurrency control in Database Systems Explained
Hussein Nasser
Download
19
Two Phase Locking Explained (2PL)
Hussein Nasser
Download
20
Redis In-memory Database Crash Course
Hussein Nasser
Download
21
Spinning MongoDB, MongoShell and Mongo GUI with Docker
Hussein Nasser
Download
22
Database Exclusive lock vs Shared Lock (Explained by Example)
Hussein Nasser
Download
23
Connection Pooling in PostgresSQL with NodeJS (Performance Numbers)
Hussein Nasser
Download
24
Building a Web API with Express and PostgreSQL to Consume from Browser
Hussein Nasser
Download
25
IndexedDB Crash Course with Javascript
Hussein Nasser
Download
26
Postgres Database Cursors in Python with psycopg2
Hussein Nasser
Download
27
Database Dead Locks Explained by Example
Hussein Nasser
Download
28
Step by Step Javascript and Postgres Tutorial using node-postgres
Hussein Nasser
Download
29
Step-by-Step Python and Postgres Tutorial with psycopg2
Hussein Nasser
Download
30
Spinning multiple Postgres instances and PGAdmin with Docker
Hussein Nasser
Download
31
MySQL and NodeJS Tutorial
Hussein Nasser
Download
32
What is a Distributed Transaction in Microservices?
Hussein Nasser
Download
33
How to Avoid Double Booking and Race Conditions in Online Web Applications
Hussein Nasser
Download
34
Multi-player System Game Design - Pros & Cons of Proposed Designs & System Design Interviews Advice
Hussein Nasser
Download
35
When should you shard your database?
Hussein Nasser
Download
36
Can the QUIC Protocol improve Database Performance in Web Applications?
Hussein Nasser
Download
37
URL Shortener System Design (Explained with Two proposed Designs with Pro and Cons of each)
Hussein Nasser
Download
38
How Do Databases Store Tables on Disk? Explained both SSD & HDD
Hussein Nasser
Download
39
Concurrent Requests and Unique Keys on Web Applications
Hussein Nasser
Download
40
Carnegie Mellon University Advanced Database Course Is a GREAT resource for Backend Engineers!
Hussein Nasser
Download
41
Keep your Servers Close and Your Database Closer
Hussein Nasser
Download
42
What is the Largest SQL Query We can Send Before The Database Process Crashes?
Hussein Nasser
Download
43
MariaDB vs MySQL SSD NVMe vs SATA Performance - Discussions on the Percona Benchmark
Hussein Nasser
Download
44
What caused the cold start performance “dip” in MariaDB .. Let us discuss (@percona Article)
Hussein Nasser
Download
45
Best Practices Working with Billion-row Tables in Databases
Hussein Nasser
Download
46
Index Scan vs Index Only Scan on Database Systems (with Postgres)
Hussein Nasser
Download
47
Why Discord Moved from MongoDB to Apache Cassandra, Let us Discuss
Hussein Nasser
Download
48
PostgreSQL 13 Has Some Performance Boosts! Let us discuss it!
Hussein Nasser
Download
49
Opening Old Wounds - Why Uber Engineering Switched from Postgres to MySQL
Hussein Nasser
Download
50
Why Redis Became the Most Popular Database on the Cloud in 2020
Hussein Nasser
Download
51
Basic Caching Techniques Explained - Spatial, Temporal, Distributed, Write-Through, Write-Back,Aside
Hussein Nasser
Download
52
Will AWS Babelfish Succeed in Moving Developers Away from SQL Server to Postgres?
Hussein Nasser
Download
53
Meet mySQL RAPID - distributed, in-memory, columnar, query processing engine by ORACLE
Hussein Nasser
Download
54
Combining Database Indexes for Better Performance in Your Backend Applications (with PostgreSQL)
Hussein Nasser
Download
55
don’t use “offset” in your SQL
Hussein Nasser
Download
56
Burned by Docker and it was my fault (Postgres issue)
Hussein Nasser
Download
57
Bitmap Index Scan in Postgres Explained with Examples (Members only)
Hussein Nasser
Download
58
Is EventStoreDB the First Native gRPC Database?
Hussein Nasser
Download
59
Create Index Blocking Production Database Writes? Postgres Solves this with this trick
Hussein Nasser
Download
60
How to Automate Partitioning in Postgres
Hussein Nasser
Download
61
UUIDs are Bad for Performance in MySQL - Is Postgres better? Let us Discuss
Hussein Nasser
Download
62
Redis In-Memory Database Crash Course
Hussein Nasser
Download
63
Phantom Reads in Postgres Explained Compared to Other DBMS
Hussein Nasser
Download
64
Serializable vs Repeatable Read Isolation Level - When to use one over the other in Database Systems
Hussein Nasser
Download
65
How Database Cursors Help in Fetching Large Result sets from your SQL
Hussein Nasser
Download
66
Watch out before Adding Indexes to Your Table, Your Database Optimizer Might not Use them
Hussein Nasser
Download
67
Write Amplification Explained in Backend Apps, Database Systems and SSDs
Hussein Nasser
Download
68
Can NULLs Improve your Database Queries Performance?
Hussein Nasser
Download
69
SELECT COUNT(*) is Slow, Estimate it Instead (with Example in Node JS and Postgres)
Hussein Nasser
Download
70
Auth0 MongoDB Gets Overloaded Causes an Major Outage
Hussein Nasser
Download
71
The Tale of OLTP, OLAP, and HTAP in Data Warehousing - The Backend Engineering Show
Hussein Nasser
Download
72
Optimizing Communication and Networking in Database Systems - The Backend Engineering Show
Hussein Nasser
Download
73
The New Postgres 14 Looks Promising - The Backend Engineering Show with Hussein Nasser
Hussein Nasser
Download
74
Primary Key vs Secondary Key - What you probably didn't know (Members ONLY)
Hussein Nasser
Download
75
All Types of Database Replication Discussed
Hussein Nasser
Download
76
My thoughts on the CAP theorem
Hussein Nasser
Download
77
B-tree vs B+ tree in Database Systems
Hussein Nasser
Download
78
Should you go with an Optimistic or Pessimistic Concurrency Control Database?
Hussein Nasser
Download
79
Can Redis be used as a Primary database?
Hussein Nasser
Download
80
Turns out MySQL Statement-based Replication might not be a good idea, Lets discuss why
Hussein Nasser
Download
81
[Private video]
Download
82
Partial Indexing | The Backend Engineering Show
Hussein Nasser
Download
83
Update your database statistics often or your SQL queries will suffer #shorts
Hussein Nasser
Download
84
Table Clustering in MySQL and Postgres - The pros and cons
Hussein Nasser
Download
85
How Redis efficiently snapshots gigabytes of memory to disk (forking)
Hussein Nasser
Download
86
backend leaking Postgres database connections - what I did to fix it
Hussein Nasser
Download
87
on graph databases
Hussein Nasser
Download
88
On Graph Databases | The Backend Engineering Show
Hussein Nasser
Download
89
The cost rolling back transactions (postgres/mysql)
Hussein Nasser
Download
90
when indexes are useless | The Backend Engineering Show
Hussein Nasser
Download
91
What is the cost of Indexing too many columns - Udemy Q&A November 2021
Hussein Nasser
Download
92
Postgres index bloat | The Backend Engineering Show
Hussein Nasser
Download
93
what is a database index?
Hussein Nasser
Download
94
The limitations of today’s SSDs | The Backend Engineering Show
Hussein Nasser
Download
95
Why this query is fast
Hussein Nasser
Download
96
Redo, Undo and WAL logs | The Backend Engineering Show
Hussein Nasser
Download
97
Sorting in Postgres 15 is 371% faster in certain cases
Hussein Nasser
Download
98
Index Fill Factor | The Backend Engineering Show
Hussein Nasser
Download
99
nulls are weird, Postgres15 makes them slightly better
Hussein Nasser
Download
100
Consistent Hashing | The Backend Engineering Show
Hussein Nasser
Download
101
Memcached Architecture - Crash Course with Docker, Telnet, NodeJS
Hussein Nasser
Download
101
Memcached Architecture - Crash Course with Docker, Telnet, NodeJS
Hussein Nasser
Download
102
MongoDB Internal Architecture
Hussein Nasser
Download
103
How Shopify’s engineering improved database writes by 50% with ULID
Hussein Nasser
Download
104
How Fast is MySQL on HTTP/3?
Hussein Nasser
Download
105
Postgres Internal Architecture Explained
Hussein Nasser
Download
106
Postgres System Columns Explained (ctid, xmin,xmax)
Hussein Nasser
Download
107
How Discord Stores Trillions of Messages | Deep Dive
Hussein Nasser
Download
108
Clustered Collections makes Mongo faster but there is a cost
Hussein Nasser
Download
109
The effect of Random UUID on database performance
Hussein Nasser
Download
110
Why create Index blocks writes
Hussein Nasser
Download
111
Database Background Writers
Hussein Nasser
Download
112
MySQL is having a bumpy journey
Hussein Nasser
Download
113
Advanced MySQL Index Locking Explained
Hussein Nasser
Download
114
SQL IN clauses are miles faster in Postgres 17
Hussein Nasser
Download