0% completed

All LessonsFree Lessons (3)

Introduction

Course Introduction Introduction to Common Database Terminologies

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

Database Architecture

Core Components of Databases Quiz on Database Architecture

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

Disk Layout

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

Database Index

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

Transaction

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

Replication

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

Partitioning

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

Concurrency Controls

What Is a Concurrency Control?

Optimistic vs. Pessimistic Concurrency Control

Multiversion Concurrency Control

Locking Strategies

Quiz on Concurrency Controls

Consistency Models

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

Consensus

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

Common Problems Associated with Distributed Databases

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

Conclusion

Course Assessment

Database Internals Assessment

Deep Dive into the Internals of the Database/

...

/

Quiz on Concurrency Controls

Quiz on Concurrency Controls

Test your understanding of concurrency controls.

We'll cover the following...

Technical Quiz

1.

(True or False) Concurrency is the process of executing more than one task at the same time, with each task running on a dedicated CPU core.

A.

False

B.

True

1 / 4