ExamFinch.com My Study

Study guide

Oracle SQL study guide

Read a lesson, then practice the ideas you want to remember.

Practice this exam

Lessons

  1. Object Privileges — Free Study Guide 2026
  2. Roles & Privilege Management — Free Study Guide 2026
  3. System Privileges — Free Study Guide 2026
  4. Conditional Expressions: CASE and DECODE
  5. Implicit vs Explicit Datatype Conversion
  6. General NULL-Handling Functions — Free Study Guide 2026
  7. TO_CHAR, TO_NUMBER, and TO_DATE Functions
  8. Data Dictionary Structure & View Prefixes
  9. Inspecting Constraints, Privileges, and Comm
  10. Querying Schema & Object Metadata — Free Study Guide 2026
  11. Datetime Data Types & Time Zone Offsets
  12. Interval Data Types & Arithmetic — Free Study Guide 2026
  13. Time Zone Functions & Session Environment
  14. ANSI/ISO SQL Equijoins & Natural Joins — Free Study Guide 2026
  15. Non-Equijoins, Self Joins, and Cartesian Pro
  16. Outer Joins: LEFT, RIGHT, and FULL — Free Study Guide 2026
  17. Indexes — Free Study Guide 2026
  18. Sequences — Free Study Guide 2026
  19. Synonyms — Free Study Guide 2026
  20. INSERT, UPDATE, and DELETE Statements — Free Study Guide 2026
  21. MERGE and Multitable Inserts — Free Study Guide 2026
  22. Transaction Management: COMMIT, ROLLBACK, an
  23. CREATE TABLE & Oracle Built-In Datatypes
  24. Integrity Constraints — Free Study Guide 2026
  25. Modifying Tables & Managing Constraints
  26. Global Temporary Tables & External Tables
  27. Database Normalization & Design Fundamentals
  28. Entity Relationship Modeling & SQL Mapping
  29. Relational Database Architecture & Terminolo
  30. Aggregate Functions & NULL Mechanics — Free Study Guide 2026
  31. GROUP BY Clause & Aggregation Rules — Free Study Guide 2026
  32. Filtering Groups with the HAVING Clause
  33. Logical Conditions & Operator Precedence
  34. Sorting Data with ORDER BY — Free Study Guide 2026
  35. Substitution Variables & Session Directives
  36. WHERE Clause Filtering & Comparison Operator
  37. INTERSECT and MINUS Operators — Free Study Guide 2026
  38. Set Operator Guidelines & ORDER BY Rules
  39. UNION and UNION ALL Operators — Free Study Guide 2026
  40. Character Manipulation & Case Conversion
  41. Date Arithmetic & Date Manipulation Function
  42. Nesting Single-Row Functions — Free Study Guide 2026
  43. Numeric & Mathematical Functions — Free Study Guide 2026
  44. Correlated Subqueries & EXISTS Logic — Free Study Guide 2026
  45. Multiple-Row Subqueries & Inline Views — Free Study Guide 2026
  46. Single-Row Subqueries — Free Study Guide 2026
  47. Subquery Cardinality & NULL Traps — Free Study Guide 2026
  48. Literal Values, Concatenation, and Quote Ope
  49. Handling NULLs & Distinct Rows in Projection
  50. SQL SELECT Fundamentals & Projection — Free Study Guide 2026
  51. Simple vs Complex Views — Free Study Guide 2026
  52. DML Operations on Views & View Constraints