[ ]  List the capabilities of SQL
     SELECT statements

[ ]  Execute a basic SELECT
     statement

[ ]   Differentiate between SQL
      statements and iSQL*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

[ ]   Use conversion functions

Displaying Data from Multiple Tables

[ ]   Write SELECT statements to
      access data from more than
      one table using equality and
      nonequality joins

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

[ ]   Join a table to itself using a
      self-join

Aggregating Data using Group Functions

[ ]   Identify the available group
      functions

[ ]   Use group functions

[ ]   Group data using the GROUP
      BY clause

[ ]   Include or exclude grouped
      rows by using the HAVING
      clause