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 Databases Taxonomy

Quiz on Databases Taxonomy

Test your understanding of database taxonomy.

We'll cover the following...

Technical Quiz

1.

What is the preferred query language in Relational DBMS?

A.

LINQ

B.

SQL

C.

GraphQL

D.

JSON

1 / 5

...