19 docs tagged with "database"

Window functions, CTEs, subqueries, recursive queries, lateral joins, pivot/unpivot, and advanced SQL patterns.

RPO, RTO, backup strategies, point-in-time recovery, logical vs physical backups, and disaster recovery planning.

Cache patterns, eviction policies, Redis deep dive, cache invalidation strategies, and common pitfalls like cache stampede and cache penetration.

OLTP vs OLAP, dimensional modeling, star and snowflake schemas, ETL/ELT, materialized views, and modern data warehouse tools.

Entity-Relationship modeling, normal forms (1NF through BCNF), denormalization trade-offs, and schema design patterns.

A comprehensive reference covering relational fundamentals, indexing, transactions, distributed systems, caching, and more — with common interview questions.

Transactional Outbox, Saga, CQRS, Event Sourcing, database-per-service, and data consistency patterns in distributed architectures.

Authentication, authorization, SQL injection, encryption at rest and in transit, auditing, and security best practices.

Full-text search concepts, inverted indexes, relevance scoring, MySQL FULLTEXT, PostgreSQL tsvector, and Elasticsearch for advanced search.

Deep dive into database indexes — B-Tree, hash, covering, composite — and strategies to analyze and optimize slow queries.

Key-value, document, wide-column, and graph databases — their models, trade-offs, and when to choose each.

Identifying slow queries, profiling tools, key metrics, connection pooling, and practical optimization workflow.

How databases parse, plan, and optimize SQL queries — cost-based optimization, statistics, plan hints, and common planner pitfalls.

Core concepts of relational databases — tables, keys, joins, SQL basics, and the relational model.

Database replication strategies, sharding patterns, the CAP theorem, and horizontal scaling techniques.

Managing database schema changes safely in production — Flyway, Liquibase, zero-downtime migration patterns, and rollback strategies.

How databases store and retrieve data — B+ trees, LSM trees, heap files, InnoDB vs MyISAM, WAL, and buffer pools.

Time-series data characteristics, storage optimizations, InfluxDB, TimescaleDB, Prometheus, and common time-series patterns.

ACID properties, isolation levels, locking mechanisms, MVCC, deadlocks, and optimistic vs pessimistic concurrency.