Topics
254 programming, AI and security concepts, each with a one-line definition, what to learn first and where to practise it.
Showing 1–12 of 12 in Databases · Clear filters
Transactions and ACID
Groups of changes that succeed or fail together, with isolation levels deciding what concurrent transactions see.
10 practice questionsGROUP BY and aggregate functions
Collapsing rows into groups and computing COUNT, SUM, AVG, MIN and MAX per group, filtered with HAVING.
8 practice questionsWindow functions
Functions such as ROW_NUMBER, RANK and running SUM that compute over related rows without collapsing them.
8 practice questionsSQL joins
Combining rows from two tables on a condition: inner, left, right, cross and self joins.
7 practice questionsDatabase indexes
Sorted structures, usually B+trees, that let a database find rows without scanning the whole table.
6 practice questionsPassword security
Storing passwords with slow salted hashes, and policies, managers and MFA.
1 article · 3 practice questionsDatabase schema design
Choosing tables, keys, data types and how to change them safely as an application grows.
5 practice questionsNULL in SQL
SQL's marker for a missing value, which makes comparisons UNKNOWN and is skipped by most aggregates.
5 practice questionsObservability
Understanding a running system from its logs, metrics and traces.
1 article · 1 practice questionSubqueries and CTEs
Queries nested inside other queries, including correlated subqueries and WITH (common table expressions), recursive ones too.
4 practice questionsKeys and constraints
Primary, unique and foreign keys, NOT NULL and CHECK rules that keep relational data valid.
2 practice questionsDatabase normalisation
Structuring tables so each fact is stored once, through first, second and third normal form.
1 practice question