EXIN SQL Foundation study guide
EXIN SQL Foundation · Work through your exam, one topic at a time.
The EXIN SQL Foundation credential is listed by EXIN, an independent certification and examination institute, as a certification in the SQL domain. This page is an independent study resource for candidates preparing for that exam; it is not affiliated with, endorsed by, or operated by EXIN, and it does not reproduce any official question bank. The EXIN SQL Foundation study guide has 4 sections and about 1,638 words.
01SQL Fundamentals
The SQL Fundamentals domain of the EXIN SQL Foundation exam tests the vocabulary and mental model behind every query: relational tables, rows and columns, candidate/primary/foreign keys, entity and referential integrity, and the SQL statement families. Exam items ask you to classify statements, predict NULL behavior, and explain why a result set has a particular shape or order.
412 words, about 2 min02Data Definition and Data Types
This domain tests DDL and the SQL type system: creating and changing tables, choosing character, numeric, temporal, boolean and binary types, and enforcing rules with constraints. Expect items on CREATE TABLE syntax, ALTER TABLE operations, DROP versus TRUNCATE, and why a constraint rejects or accepts a row.
398 words, about 2 min03Data Manipulation and Queries
This domain tests changing data and retrieving it from one table: INSERT, UPDATE, DELETE, SELECT with WHERE and ORDER BY, DISTINCT, and aggregate functions with GROUP BY and HAVING. Exam items ask you to predict row counts, handle NULLs, and decide whether a condition belongs in WHERE or HAVING.
381 words, about 2 min04Advanced Querying and Database Objects
This domain tests multi-table retrieval and schema objects that support it: inner, outer and self joins, subqueries, set operators, views, indexes and sequences. Exam items ask you to choose the join that preserves unmatched rows, predict duplicate behavior, and explain when an index or view helps.
447 words, about 2 min