Oracle SQL – A Complete Developer’s Guide (2023)

ORACLE UNIVERSITY COURSE (1Z0-071)

Relational Database concepts

• Explaining the theoretical and physical aspects of a relational database
• Relating clauses in SQL Select Statement to Components of an ERD
• Explaining the relationship between a database and SQL

Restricting and Sorting Data

• Applying Rules of precedence for operators in an expression
• Limiting Rows Returned in a SQL Statement
• Using Substitution Variables
• Using the DEFINE and VERIFY commands
• Sorting Data

Using Conversion Functions and Conditional Expressions

• Applying the NVL, NULLIF, and COALESCE functions to data
• Understanding implicit and explicit data type conversion
• Using the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
• Nesting multiple functions

Displaying Data from Multiple Tables

• Using Self-joins
• Using Various Types of Joins
• Using Non equijoins
• Using OUTER joins
• Understanding and Using Cartesian Products

Using SET Operators

• Matching the SELECT statements
• Using the ORDER BY clause in set operations
• Using The INTERSECT operator
• Using The MINUS operator
• Using The UNION and UNION ALL operators