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%
Schema Migration
Database & SQLTopic 18 of 172 questions