This list combines videos from both playlists: Building with Databases and Relational Database Internals.
| # | Title | Arabic | Done |
|---|---|---|---|
| 1 | Relational Databases & Relational Algebra => internals | Arabic | ✅ |
| 2 | Relational Algebra - Deep Dive => internals | Arabic | |
| 3 | Database Storage 1 (Files & Pages) => internals | Arabic | ✅ |
| 4 | Database Storage 2 (Page layouts and tuples) => internals | Arabic | ✅ |
| 5 | Database Indexes 1 (B and B+ trees) => internals | Arabic | |
| 6 | Database Indexes 2 (Hash, Composite) => internals | Arabic | |
| 7 | Database Indexes 3 (Union, Intersection, Clustered, Covering) => internals | Arabic | |
| 8 | Database Indexes 4 (Q & A) => internals | Arabic | |
| 9 | Database Design | Arabic | ✅ |
| 10 | Relationships in ER Diagrams | Arabic | |
| 11 | Database Keys | Arabic | ✅ |
| 12 | ER to Relational Mapping | Arabic | |
| 13 | Database Normalization | Arabic | ✅ |
| 14 | SQL Query Life Cycle => internals | Arabic | |
| 15 | Join Algorithms => internals | Arabic | |
| 16 | SQL Join Types (Inner, Outer, Semi-join, Anti-join) | Arabic | |
| 17 | Common Table Expressions (CTEs) vs. Subqueries | Arabic | |
| 18 | Aggregation Algorithms => internals | Arabic | |
| 19 | SQL Query Optimizer => internals | Arabic | |
| 20 | Understanding EXPLAIN in Postgres | Arabic | |
| 21 | Cardinality Estimation 1 (Overview, Selection) => internals | Arabic | |
| 22 | Cardinality Estimation 2 (Aggregation, Join) => internals | Arabic | |
| 23 | Cardinality Estimation 3 (Estimation Errors) => internals | Arabic | |
| 24 | Query Execution => internals | Arabic | |
| 25 | Database Views | Arabic | ✅ |
| 26 | Materialized Views | Arabic | |
| 27 | Transactions 1 (ACID Properties) => internals | Arabic | |
| 28 | Transactions 2 (Schedules) => internals | Arabic | |
| 29 | Concurrency Control: Two-Phase Locking (1) => internals | Arabic | |
| 30 | Concurrency Control: Two-Phase Locking (2) => internals | Arabic | |
| 31 | Concurrency Control: Timestamp Ordering & Optimistic Concurrency Control => internals | Arabic | |
| 32 | Concurrency Control: Multi Version Concurrency Control => internals | Arabic | |
| 33 | Data Partitioning | Arabic | |
| 34 | Distributed Databases | Arabic | |
| 35 | Database Sharding (and Consistent Hashing) => internals | Arabic |