Free Oracle SQL Exam Prep

Relational terminology, entity relationships, table structure, keys, normalization, and the logical model behind SQL queries.

SELECT syntax, projection, aliases, expressions, DISTINCT, and query output.

WHERE conditions, operator precedence, pattern matching, NULL predicates, substitution variables, and ORDER BY behavior.

Character, number, date, and nested single-row functions used to transform query output.

Implicit and explicit datatype conversion, NULL-handling functions, CASE, DECODE, and conditional result logic.

Aggregate functions, NULL behavior, GROUP BY, HAVING, grouping rules, and filtered aggregate results.

Inner, outer, self, and non-equijoins, cartesian products, and row-preservation behavior.

Single-row, multiple-row, correlated, scalar, and EXISTS-based subqueries, including cardinality and NULL traps.

UNION, UNION ALL, INTERSECT, and MINUS compatibility, duplicate handling, and final ordering.

INSERT, UPDATE, DELETE, MERGE, multitable inserts, transaction control, COMMIT, ROLLBACK, and SAVEPOINT.

Creation, use, behavior, and limitations of common supporting schema objects.

CREATE, ALTER, DROP, TRUNCATE, Oracle data types, constraints, temporary tables, and table relationships.

Simple and complex views, creation rules, DML behavior, and view limitations.

System and object privileges, roles, grants, revokes, and access boundaries.

Using Oracle data dictionary views to inspect users, objects, privileges, and metadata.

Datetime and interval data types, time-zone-aware values, conversion, comparison, and display.