Search⌘ K

Deep Dive into the Internals of the Database

0%

1.Introduction

Course Introduction Introduction to Common Database Terminologies

2.Taxonomy of Databases

Different Classification Types Classification Based on Data Model Classification Based on Storage Medium Classification Based on Disk Layout Classification Based on Access Pattern Quiz on Databases Taxonomy

3.Database Architecture

Core Components of Databases Quiz on Database Architecture

4.Data Structures used in Databases

Binary Search Tree Balanced Binary Search Tree B-Tree B+ Tree WAL Log-Structured Merge-Tree Hash Index Bloom Filter Merkle Trees Quiz on Data Structures Used in Databases

5.Disk Layout

Layout of HDD Layout of an SSD Binary Encoding of Data Types Data Layout on Disk Quiz on Data Layout on Disk

6.Database Index

What Is a Database Index?Different Types of Database Indexes Quiz on Database Index

7.Transaction

What Is a Transaction?ACID Transaction Guarantee Atomicity Consistency Isolation Durability Distributed Transaction Quiz on Transactions

8.Replication

What Is Replication in Databases?Single-Leader Replication Multileader Replication Leaderless Replication Failure Detection Strategies Quiz on Replication

9.Partitioning

What Is Partitioning in Databases?Different Partitioning Strategies in Databases How to Partition Secondary Indexes Rebalancing Quiz on Partitioning

10.Concurrency Controls

What Is a Concurrency Control?Optimistic vs. Pessimistic Concurrency Control Multiversion Concurrency Control Locking Strategies Quiz on Concurrency Controls

11.Consistency Models

What Is a Consistency Model?Linearizability Different Consistency Models Quiz on Consistency Models

12.Consensus

What Is Consensus?Atomic Broadcasts Zookeeper Atomic Broadcast Paxos and Raft Leader Election Strategies Quiz on Consensus

13.Common Problems Associated with Distributed Databases

Clocks Unreliable Networks Two Generals' Problem FLP Impossibility Quiz on Commons Problems Associated with Distributed Databases

14.Conclusion

Assessment

Database Internals Assessment

Deep Dive into the Internals of the Database

Quiz on Database Index

Test your understanding of the database index.

We'll cover the following...

...