🗄️ Database Systems

⚙️

Stored Procedures & Triggers

PL/SQL, T-SQL, event-driven actions.

SQL

👁️

Views & Materialized Views

Virtual tables, caching, refresh strategies.

SQL

⚡

ACID Properties

Atomicity, Consistency, Isolation, Durability.

Isolation Levels

Read Uncommitted, Read Committed, Repeatable Read, Serializable.

MVCC (Multi-Version Concurrency)

Snapshot isolation, PostgreSQL, InnoDB.

Indexing

B-tree, hash, bitmap, primary vs secondary.

Query Optimization

Cost-based, query plans, statistics, EXPLAIN.

Database Tuning

Configuration, memory, disk I/O, connection pooling.

NoSQL Basics

CAP theorem, BASE, eventual consistency.

📄

MongoDB

Document model, queries, aggregation, indexing.

⚡

Redis

Key-value store, caching, pub/sub, data structures.

📊

Cassandra

Wide-column store, partition key, clustering, tunable consistency.

🕸️

Neo4j

Graph database, nodes, relationships, Cypher query.

🔎

Elasticsearch

Search engine, inverted index, aggregations, ELK stack.

🌐

Distributed Databases

Sharding, partitioning, distributed transactions.

Distributed

🔄

Replication

Master-slave, master-master, synchronous, asynchronous.

Sharding

Range, hash, consistent hashing, rebalancing.

Distributed Consensus

Raft, Paxos, ZooKeeper, etcd.

Distributed

☁️

Cloud Databases

AWS RDS, DynamoDB, Aurora, Google Spanner.

Data Warehouses

Star schema, snowflake, OLAP, Redshift, BigQuery.

Lakehouse Architecture

Delta Lake, Iceberg, Hudi, unified storage.

Time Series Databases

InfluxDB, Prometheus, TimescaleDB.

Vector Databases

Pinecone, Milvus, Weaviate, embeddings.

Streaming Databases

Kafka, Flink, Materialize, real-time processing.

ORM (Object-Relational Mapping)

Hibernate, SQLAlchemy, Entity Framework.

Database Migration

Schema migration, Alembic, Flyway, Liquibase.

Database Constraints

Primary key, foreign key, unique, check, default.

Database Security

Authentication, authorization, encryption, auditing.

Database Benchmarking

TPC benchmarks, performance testing, load testing.

NewSQL

CockroachDB, TiDB, VoltDB, distributed SQL.

Modern