SQL notes and introductory exercises covering relational queries, filtering, ordering and data aggregation.
SHOWCASE SOURCE · SOURCE CODE · PAGES ACTIVATION REQUIRED
- SQL notes: syntax notes and quick reference.
- WHERE and ORDER BY: introductory filtering and sorting exercise.
- SQL operations 01 and SQL operations 02: additional notes and exercises.
More focused exercises remain in their own repositories to avoid divergent copies:
- SELECT, WHERE and ORDER BY.
- DISTINCT and logical operators.
- Aggregate functions.
- GROUP BY and HAVING.
- Querying and analysing relational datasets.
Execute each query against the schema specified by its exercise in a compatible relational database management system. This repository contains notes and queries, not a complete database instance.
- SQL
- Relational databases
The static showcase source is in docs/; GitHub Pages activation is required before it can be viewed publicly. It displays sample queries and links to study notes; it does not execute SQL in the browser.
The Pages workflow is defined in .github/workflows/pages.yml and publishes the static showcase.
This is a learning repository. Query examples may require adaptation to the SQL dialect and schema used by a specific database.
See LICENSE.