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