Skip to content
javabypankaj
HomeLibraryPopularCommunity
Design PatternsSystem Design
13
Database & SQL
17 topics · 156 questions
1SQL Basics: SELECT, WHERE, ORDER BY0/10102Joins: INNER, LEFT, RIGHT, FULL, CROSS0/12123Aggregation: GROUP BY, HAVING, COUNT, SUM0/10104Subqueries & CTEs0/775Window Functions: ROW_NUMBER, RANK, LEAD, LAG0/886Indexing0/19197Transactions & ACID0/448Normalization & Schema Design0/779SQL vs NoSQL0/2210Connection Pooling0/6611Query Optimization & EXPLAIN0/5512Sharding & Partitioning0/7713Database Internals: B-tree, MVCC, WAL0/1114Stored Procedures, Views & Triggers0/6615Migrations & Schema Changes0/1116Practical SQL Queries0/343417Advanced: Replication, Consistency, CAP0/5518Schema Migration0/219Joins & Subqueries0/1120SQL Practice: 331 Real Interview Queries0/99
1SQL Basics: SELECT, WHERE, ORDER BY102Joins: INNER, LEFT, RIGHT, FULL, CROSS123Aggregation: GROUP BY, HAVING, COUNT, SUM104Subqueries & CTEs75Window Functions: ROW_NUMBER, RANK, LEAD, LAG86Indexing197Transactions & ACID48Normalization & Schema Design79SQL vs NoSQL210Connection Pooling611Query Optimization & EXPLAIN512Sharding & Partitioning713Database Internals: B-tree, MVCC, WAL114Stored Procedures, Views & Triggers615Migrations & Schema Changes116Practical SQL Queries3417Advanced: Replication, Consistency, CAP518Schema Migration219Joins & Subqueries120SQL Practice: 331 Real Interview Queries9
17 topics156 Qs0%
01Core Java17402OOP3203Collections6704Exception Handling2805Concurrency & Multithreading13006Java Streams, Lambda & Functional Programming32907Spring & Spring Boot5208Transactions2409JPA & Hibernate7010Microservices20211Kafka & Messaging11712DevOps, CI/CD & Tooling14313Database & SQL15614REST API & Web4315Design Patterns & LLD5816Advanced Java7517Coding Problems: DSA49518AWS & Cloud4119Data Engineering19420QA, Testing & SDET4221System Design3522Security2723Behavioral / HR: STAR Method37
17Topics
156Questions
0%Complete
18 of 20 topics
Topics
1SQL Basics: SELECT, WHERE, ORDER BY0/10102Joins: INNER, LEFT, RIGHT, FULL, CROSS0/12123Aggregation: GROUP BY, HAVING, COUNT, SUM0/10104Subqueries & CTEs0/775Window Functions: ROW_NUMBER, RANK, LEAD, LAG0/886Indexing0/19197Transactions & ACID0/448Normalization & Schema Design0/779SQL vs NoSQL0/2210Connection Pooling0/6611Query Optimization & EXPLAIN0/5512Sharding & Partitioning0/7713Database Internals: B-tree, MVCC, WAL0/1114Stored Procedures, Views & Triggers0/6615Migrations & Schema Changes0/1116Practical SQL Queries0/343417Advanced: Replication, Consistency, CAP0/55
18Schema Migration0/22
19Joins & Subqueries0/1120SQL Practice: 331 Real Interview Queries0/99

Schema Migration

Database & SQL·Topic 18 of 17·2 questions
Q1How do you manage database migrations safely with Flyway

Database migrations are versioned scripts that evolve the database schema incrementally, and Flyway is a tool that applies these scripts in order, tracks which ones have run, and prevents re-execution.

Read Answer
Q2What is the expand-and-contract pattern for schema migrations

The expand-and-contract pattern splits a breaking schema change (like renaming a column) into four phases: add the new column, backfill data, switch application code, and drop the old column, so that zero downtime is achieved during rolling deployments.

Read Answer
Previous · Topic 17Advanced: Replication, Consistency, CAP5 questionsNext · Topic 19Joins & Subqueries1 questions
javabypankaj© 2026 javabypankaj
PrivacyTerms
HomeSearchLibrary