Chapter 1

Architecture

Three level schema

medium • 1 min read

Data independence

medium • 2 min read

DBA roles

medium • 3 min read

Client server

medium • 4 min read

Query processing

medium • 5 min read

Chapter 2

ER Modeling

Entity sets

medium • 1 min read

Relationship types

medium • 2 min read

Weak entities

medium • 3 min read

Mapping rules

medium • 4 min read

Normalization

medium • 5 min read

Chapter 3

SQL Language

DDL commands

medium • 1 min read

DML commands

medium • 2 min read

Joins nested

medium • 3 min read

Views triggers

medium • 4 min read

Constraints

medium • 5 min read

Chapter 4

Transactions

ACID properties

medium • 1 min read

Concurrency lock

medium • 2 min read

Strict 2PL

medium • 3 min read

Deadlock wait

medium • 4 min read

Crash recovery

medium • 5 min read

Chapter 5

NoSQL Basics

BASE theorem

medium • 1 min read

Key value stores

medium • 2 min read

Document DB

medium • 3 min read

Graph DB

medium • 4 min read

Map Reduce

medium • 5 min read