From 123-CBT Computer Based Training
Oracle Database 10g SQL Fundamentals I Part 1 

...methods of sorting the result set of a query by using the
ORDER BY clause.
Identify substitution variables that are used while retrieving data by using
SQL statements.
Unit 3:
SQL Functions
Identify features of single-row functions.
Match the character functions with their uses.
Match the number functions with their purpose.
Identify features of the date functions.
Identify
more...
Oracle SQL Specifics Retrieving and Formatting Data 

...ondition.
Perform a query using a
SQL operator.
Use the
ORDER BY clause to sort query results.
Use a join to query data from multiple tables.
Use an outer join to return records without a direct match.
Identify the features of the SQL*Plus environment.
Log in to SQL*Plus.
Use the
DESCRIBE command to display the structure of a table.
Match SQL*Plus editing commands to their
more...
CIW Database Specialist Part 3 Database Interaction JDBC 

This is the third course in a four part series that teaches students about
SQL, relational algebra, transactions and database security, and an introduction to the
JDBC. This course covers
SQL DDL commands, inserting, updating, and querying with
DML statements, granting and revoking privileges with
DCL statements. The course also teaches about relational algebra concepts, to include joins,
more...