Skip to content

How to read this guide

Current as of late 2026

This guide is for students and self-learners. Product names, versions, standards and dates were checked for accuracy as of late 2026, but databases and data management changes quickly — confirm details with official documentation and standards bodies. Product names and trademarks belong to their owners.

Each topic follows the same simple pattern, so you can jump to any page and understand it without reading the rest first.

How each topic is built

In plain English
A jargon-free explanation of what the topic is.
Think of it like…
An everyday analogy that makes the idea click.
Real-world example
A short realistic story or worked example showing it in action.
How it works
The key steps, in order.
Who uses it
The people, jobs and industries that rely on it.
Key takeaway
The single most important thing to remember.

Many topics include a Try it box with a safe command or snippet. Then a table lists the most important entries — with what each one does and a concrete example.

Entry type labels

Concept, Database, Data Model, Language, Standard, Algorithm, Data Structure, Pattern, Feature, Service, Tool, Framework, Library, Format, Protocol, Metric, Command, Organisation, Certification, Career, Resource

Concept = an idea to understand. Database / Service = a database product or a managed cloud database. Data model / Pattern = ways to structure data and systems. Language / Standard / Protocol / Format = query languages, official specs and data formats. Algorithm / Data structure / Feature = how databases work inside. Tool / Framework / Library / Command = things you install or run. Metric = a measure. Organisation / Certification / Career / Resource = bodies, credentials, jobs and learning material.

Status labels

Current, Legacy, Emerging

Current = widely used today. Legacy = still found and worth knowing, but being replaced or mainly historical. Emerging = new, announced or just being adopted.

Level labels

Beginner, Intermediate, Advanced

Beginner = learn this first. Intermediate = needed for coursework and most jobs. Advanced = specialist depth.

Data-model labels

Relational, Document, Key-Value, Wide-Column, Graph, Time-Series, Search, Vector, Multi-Model, Analytical, General

The main data model a database or concept belongs to. Analytical = column stores, warehouses and lakehouses built for reporting and big queries. General = applies across models.

About this guide