33 docs tagged with "database"

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

DynamoDB mastery for DVA-C02. Covers partition keys, sort keys, GSI vs LSI, read/write capacity modes, DynamoDB Streams, DAX, TTL, transactions, and the most common exam scenarios and anti-patterns.

Amazon RDS and Aurora for DVA-C02. Multi-AZ vs Read Replicas, Aurora Serverless, RDS Proxy, IAM authentication, connection pooling, encryption, and common developer patterns with Java/Spring Boot.

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

Detailed guide and senior deep dive into JPA/Hibernate best practices for @ManyToOne and @OneToMany mappings based on Thorben Janssen's tutorial.

A comprehensive guide to the CAP theorem in distributed systems, covering network partitions, consistency models, microservice-level trade-offs, interview questions, and real-world implementations.

Comprehensive guide on Change Data Capture (CDC), detailing how it works, alternatives comparison, implementation patterns with Debezium and Spring, and deep dives for senior engineers.

Databases, web frameworks, and all third-party frameworks are details — implementation choices that should be deferred and hidden behind boundaries. Learn why treating them as the center of your architecture leads to rigidity and how to protect your business rules from them.

A comprehensive deep dive into consistent hashing, addressing modulo scaling bottlenecks, hash rings, virtual nodes, data replication, interview questions, and real-world implementations.

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

A comprehensive guide to database ACID properties (Atomicity, Consistency, Isolation, Durability) for both beginners and experienced engineers.

A complete guide to database connection pooling — how connections work, pool mechanics, HikariCP tuning, pool sizing formulas, failure modes, PgBouncer, RDS Proxy, and production observability. Beginner through senior depth.

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.

A complete guide to horizontal scaling — sharding strategies, consistent hashing, cross-shard complexities, rebalancing, distributed ID generation, and real-world database comparisons.

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

Deep dive into database indexing mechanisms — covering disk I/O, B-Trees, hash indexes, composite index design, geospatial indexing, inverted indexes, EXPLAIN analysis, and Spring/JPA performance.

A comprehensive list of technical interview questions and detailed answers from a real LTIMindtree Java Developer interview for a candidate with 2 to 7 years of experience.

From first principles to production — key-value, document, wide-column, and graph databases with deep dives into MongoDB and Cassandra for Java/Spring engineers.

What MongoDB is, why to use it, core concepts, data modelling, CRUD, aggregation, indexes, advanced architecture, and schema patterns. Covers beginner through senior depth.

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.

Redis as a primary in-memory database — persistence mechanisms (RDB, AOF), durability guarantees, data modeling patterns, and when to use Redis as your primary store vs cache.

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.

Common SQL interview questions on ranking queries, indexing, and practical query optimization.

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.

A complete guide to the Transactional Outbox Pattern — from the Dual-Write problem for beginners to CDC vs polling internals, at-least-once guarantees, ordering semantics, and production monitoring for senior engineers.

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