Build a working vocabulary for real queries
Use this inventory to scan the scope of the hub.
- Browse concepts alphabetically through canonical glossary URLs for grain, keys, cardinality, null logic, windows, transactions, plans, and validation language.
- Browse by concept family: relational modeling, query semantics, aggregation, analytical windows, data quality, transactions, constraints, and performance basics.
- Each term exists to explain a concept used in lessons or feedback, not to fill a keyword page.
Browse SQL concepts
Choose a course, reference page, dataset, or project. Practice opens in the app when you are ready.
- Table Grain
- Primary Key
- Foreign Key
- Cardinality
- Join Fan Out
- Null
- Three Valued Logic
- Predicate
- Projection
- Row Expression
- Aggregate
- Grouping Grain
- Stable Sort
- Tie Breaker
- Complete Calendar
- Cohort
- Retention
- Window Function
- Partition
- Frame
- Common Table Expression
- Correlated Subquery
- Anti Join
- Set Operation
- Transaction
- Constraint
- Upsert
- Returning Clause
- Execution Plan
- Sequential Scan
- Index Scan
- Selectivity
- Data Quality
- Duplicate Fact
- Metric Definition
- Hidden Variant
Connect the concept to working SQL
Use these guides to choose the next topic, then open the workspace for the editor, checks, drafts, reviews, and saved progress.