13
Database & SQL
17 topics · 141 questions
1SQL Basics: SELECT, WHERE, ORDER BY0/882Joins: INNER, LEFT, RIGHT, FULL, CROSS0/12123Aggregation: GROUP BY, HAVING, COUNT, SUM0/10104Subqueries & CTEs0/775Window Functions: ROW_NUMBER, RANK, LEAD, LAG0/886Indexing0/18187Transactions & ACID0/448Normalization & Schema Design0/779SQL vs NoSQL0/210Connection 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
1SQL Basics: SELECT, WHERE, ORDER BY82Joins: INNER, LEFT, RIGHT, FULL, CROSS123Aggregation: GROUP BY, HAVING, COUNT, SUM104Subqueries & CTEs75Window Functions: ROW_NUMBER, RANK, LEAD, LAG86Indexing187Transactions & ACID48Normalization & Schema Design79SQL vs NoSQL210Connection Pooling611Query Optimization & EXPLAIN512Sharding & Partitioning713Database Internals: B-tree, MVCC, WAL114Stored Procedures, Views & Triggers615Migrations & Schema Changes116Practical SQL Queries3417Advanced: Replication, Consistency, CAP5
17 topics141 Qs0%
SQL vs NoSQL
Database & SQLTopic 9 of 172 questions