Using Structured Query Language (SQL)

Data Manipulation Language and Transaction Control Language

Using Basic SELECT statements Conversion Functions and Conditional Expressions

Displaying Data from Multiple Tables

Using the Set Operators

Managing Objects with Data Dictionary Views

Managing Schema Objects

Data Definition Language (DDL)

SQL*Plus

Restricting and Sorting Data

Using Single-Row Functions to Customize Output

Reporting Aggregated Data Using the Group Functions

Using Subqueries to Solve Queries

Creating Other Schema Objects

Controlling User Access

Manipulating Data Using Advanced Queries