Schema SQL
Review tables, columns, primary keys and foreign keys and the relationships between sales, purchases, payments and products.
View the schemaSQL learning resources
Use these resources to understand the relational model, review SQL concepts and connect queries to finance scenarios.
SQL reference
Quickly find essential syntax for SELECT, WHERE, JOIN, GROUP BY, HAVING, COALESCE, VAT and gross margin.
View SQL referenceSQL glossary
Review key definitions: primary key, foreign key, aggregation, join, NULL, aliases and SQL functions.
View glossaryScenario-based exercises
Understand and query simplified data involving VAT, margins, overdue balances, purchases and sales.
View scenariosHow to use these resources
- Review the SQL schema before exercises involving several tables.
- Use the SQL reference to find a query pattern quickly.
- Return to the glossary when a technical concept is unclear.
- Use scenario-based exercises to connect queries with finance data.