Relational Databases & SQL

Using SQL*Plus

• About SQL*Plus
• Using the MS Windows SQL*Plus tool
• Using the iSQL*Plus web tool
• Entering commands & syntax

Building a SELECT Statement

• About the SELECT statement
• Selecting columns
• Using alias names

Building a WHERE Clause

• About logical operators
• Equality operator
• Boolean operators
• NULL & BETWEEN operators
• Finding text strings
• IN operator

Ordering the Result Table

• About the ORDER BY clause
• Multiple column sorts
• Specifying the sort sequence
• About NULL values within sorts
• Using column aliases

Pseudo Columns & Functions

• ROWID and ROWNUM
• Using the functions (SYSDATE, USER & UID)
• Using the DUAL table
• SESSIONTIMEZONE function

Joining Tables

• Inner join
• Reflexive join
• Non-key join
• Outer join

Using Set Operators

Summary Functions

• About summary functions
• Summary functions with DISTINCT

Using Subqueries

• About subqueries
• Standard subqueries
• Correlated subqueries

Creating & Selecting Groups

• About summary groups
• Finding groups within the base tables
• Selecting data from the base tables
• Selecting groups from the result table

SQL*Plus Commands

• More about script files
• Invoking operating system commands
• Saving session output

Build Simple SQL*Plus Reports

• About the SQL*Plus report features
• Session output with SET
• Format column output with COLUMN
• Defining report breaks with BREAK
• Produce subtotals with COMPUTE

SQL Data Definition Language

• About SQL DDL
• Create/Alter/Drop the TABLE statement
• Supportive statements

SQL Data Manipulation Language

• About SQL DML
• INSERT/DELETE/UPDATE statements
• About transactions
• TRUNCATE TABLE
• Complex table references