Describe the Oracle
implementation of the
RDBMS and ORDBMS

Describe the use and benefits of SQL

Writing Basic SQL Statements

List the capabilities of SQL SELECT statements

Execute a basic SELECT
statement

Differentiate between SQL statements and SQL*Plus commands

Restricting and Sorting Data

Limit the rows retrieved by a query

Sort the rows retrieved by a query

Single Row Functions

Describe various types of functions available in SQL

Use character, number, and date functions in SELECT statements

Describe the use of
conversion functions

View data that generally
does not meet a join
condition by using
outer joins

Join a table to itself

Aggregating Data Using
Group Functions

Identify the available group functions

Describe the use of group functions

Group data using the
GROUP BY clause

Include or exclude grouped rows by using the HAVING clause

Subqueries

Describe the types of
problems that subqueries
can solve

Define subqueries

List the types of subqueries

Write single-row and
multiple-row subqueries

Describe and explain the
behavior of subqueries
when null values are retrieved

Write subqueries in a
FROM clause

Managing Rollback Segments

Produce queries that require an input variable

Customize the SQL*Plus
environment

Produce more readable
output

Create and execute script files

Save customizations

Manipulating Data

Describe each DML
statement

Insert rows into a table

Update rows in a table

Delete rows from a table

Control transactions