pillar
SQL glossary for relational and analytical concepts
Plain-language definitions for grain, keys, cardinality, null logic, windows, transactions, plans, and validation concepts.
Start in the app
SQL glossary for relational and analytical concepts overview
Plain-language definitions for grain, keys, cardinality, null logic, windows, transactions, plans, and validation concepts.
This public page is designed to answer the learning question directly and then point to the interactive workspace only when practice is useful.
What this hub covers
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.
What to explore next
The links below are canonical public resources. They render as normal anchors and do not require the product runtime.
From reading to doing
Public pages explain concepts and show verified examples. The `/app` workspace adds the editor, PGlite worker, hidden variants, drafts, review scheduling, and mastery evidence.