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/2219Joins & Subqueries0/120SQL 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
19 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/5518Schema Migration0/22
19Joins & Subqueries0/11
20SQL Practice: 331 Real Interview Queries0/99

Joins & Subqueries

Database & SQL·Topic 19 of 17·1 question
Q1How do SQL joins, aggregation, and subqueries work

SQL joins combine rows from multiple tables based on related columns, aggregation functions compute summary values from groups of rows, and subqueries embed one SELECT inside another to build complex queries.

Read Answer
Previous · Topic 18Schema Migration2 questionsNext · Topic 20SQL Practice: 331 Real Interview Queries9 questions
javabypankaj© 2026 javabypankaj
PrivacyTerms
HomeSearchLibrary