Oracle 1Z0-182 study plan

Write and explain the logical clause order (FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY) and predict which clause fails first when a query is malformed.

Filter rows with comparison, BETWEEN, IN, LIKE (including ESCAPE), IS NULL, and combine predicates with AND/OR/NOT while applying correct precedence.

Sort result sets with ORDER BY, including ASC/DESC, multiple keys, column aliases, and NULLS FIRST/LAST behavior.

Apply row limiting with FETCH FIRST n ROWS ONLY, OFFSET, and WITH TIES, and contrast it with ROWNUM filtering in a subquery.

Solve 20 prediction-style items where you state the exact rows returned or the error raised before executing the query.

Classify single-row functions (character, numeric, date, conversion, NULL-handling) and apply NVL, COALESCE, NULLIF, and CASE correctly in SELECT and WHERE.

Format and convert values with TO_CHAR, TO_DATE, and TO_NUMBER, and diagnose implicit-conversion errors caused by mismatched literal formats.

Use group functions (COUNT, SUM, AVG, MIN, MAX) and distinguish COUNT(*), COUNT(column), and COUNT(DISTINCT column) outcomes on the same data.

Group rows with GROUP BY, filter groups with HAVING, and explain why a non-aggregated SELECT column must appear in GROUP BY.

Restrict group results with the WHERE-versus-HAVING decision rule and verify with nested aggregation examples.

Combine filtering, grouping, and sorting in single queries that return a specified number of rows, and verify each against a hand-computed expectation.

Predict NULL propagation through aggregates, arithmetic, and concatenation, and rewrite queries so NULLs do not silently drop rows.

Use date arithmetic (ADD_MONTHS, MONTHS_BETWEEN, NEXT_DAY, TRUNC on dates) inside grouped queries and explain rounding effects on results.

Time yourself on 30 mixed SELECT/group-function items and record accuracy and elapsed time per item.

Write inner joins using both ANSI JOIN ... ON syntax and traditional comma-with-WHERE syntax, and convert queries between the two forms.

Implement LEFT, RIGHT, and FULL OUTER joins and predict exactly which rows survive when the join key contains NULLs.

Use self-joins to resolve hierarchical-style questions (for example, employee to manager) and explain the role of table aliases.

Write single-row and multi-row subqueries with IN, ANY, ALL, and EXISTS, and choose correctly between them for a stated requirement.

Use inline views and scalar subqueries in the SELECT list, and identify when a correlated subquery is required.

Insert rows with INSERT ... VALUES and INSERT ... SELECT, including column-list omissions and the resulting NULL/default behavior.

Update and delete rows with correlated WHERE conditions, and verify affected-row counts before and after each statement.

Use MERGE to perform insert-or-update logic, and explain each clause (ON, WHEN MATCHED, WHEN NOT MATCHED) and its restrictions.

Apply transactional reasoning to DML: identify what COMMIT, ROLLBACK, and SAVEPOINT do to uncommitted changes in a multi-statement sequence.

Diagnose common DML failures: constraint violations, mutating-table errors, and subquery returning multiple rows.

Create tables with appropriate column data types and DEFAULT values, and choose between VARCHAR2, CHAR, NUMBER, and DATE for stated requirements.

Add and manage constraints (NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY with ON DELETE behavior, CHECK) at creation time and via ALTER TABLE.

Create, replace, and drop views, and explain when a view is updatable versus read-only, including the effect of joins and group functions.

Use CREATE TABLE ... AS SELECT and explain how it differs from a view in terms of stored data and constraint inheritance.

Interpret and resolve common DDL errors: duplicate object names, invalid identifiers, and constraint violations on existing data.

Create sequences with START WITH, INCREMENT BY, and CACHE options, and use NEXTVAL and CURRVAL correctly, including their session scope and ordering caveats.

Create private and public synonyms and explain name resolution order when a synonym and a real object share a name.

Create indexes on appropriate columns, distinguish unique from non-unique indexes, and explain when a function-based index is needed.

Use data dictionary views (USER_TABLES, USER_CONSTRAINTS, USER_INDEXES, USER_SEQUENCES) to verify that objects were created as intended.

Perform routine schema maintenance with Oracle tools: adding a column, dropping an unused column, renaming an object, and dropping objects in dependency-safe order.

Grant and revoke system and object privileges, and explain the difference between them with a concrete example of each.

Create users and roles, assign privileges through a role, and describe what happens to access when the role is revoked.

Explain transaction boundaries and isolation behavior: when locks are held, what COMMIT releases, and how a second session sees uncommitted data.

Review Domain 1 fundamentals (relational model, keys, integrity, normalization basics, SQL statement categories) and close gaps flagged in earlier weeks.

Complete two full-length timed practice exams and build a prioritized list of remaining weak objectives.