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

Change History:

/**************************************************************************

Features added / updated.                                                  

+ Created the course on 07/16/2020

+ Added 18C XE installation Guide (Lecture: 5 Resource) on 01/07/2021

***************************************************************************/

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

Managing Indexes Synonyms and Sequences

Managing Indexes

Managing Synonyms

Managing Sequences

Managing Views

Managing Views

Managing Objects with Data Dictionary Views

Using data dictionary views