Topics
254 programming, AI and security concepts, each with a one-line definition, what to learn first and where to practise it.
Showing 1–17 of 17 in Databases · Clear filters
MySQL
A widely used open-source relational database; InnoDB is its default storage engine.
14 practice questionsSQL
The standard language for defining, querying and changing data in relational databases.
14 practice questionsTransactions and ACID
Groups of changes that succeed or fail together, with isolation levels deciding what concurrent transactions see.
10 practice questionsPostgreSQL
An open-source relational database.
3 articlesGROUP 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 questionsSQL query optimisation
Making queries faster by reading execution plans (EXPLAIN), choosing indexes and rewriting queries.
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 questionsDatabase replication
Copying changes from a primary database to replicas for read scaling and failover; in MySQL, through the binary log.
3 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