From 123-CBT Computer Based Training
Oracle9i SQL Basic SELECT Statements 

...e with their descriptions. o
Sequence the phases of the system development life cycle. o
Match the types of
SQL statements with their descriptions. o Match the capabilities of
SQL SELECT statements with their functions. o
Identify the guidelines for constructing basic SQL SELECT statement. o
Write a query that restricts rows returned by using the WHERE clause. o Write a WHERE clause
more...
Oracle Database 10g SQL Fundamentals I Part 1 

...atures.
Learn To:
Match the different phases of system development life cycle (
SDLC) with their features.
Identify features of an
Entity Relationship (ER) model.
Identify features of Relational Database Management System (
RDBMS).
Identify the
SQL statement to retrieve data from tables.
Identify arithmetic expressions used to perform operations on data.
Identify operators
more...
SQL and PL SQL Basic SELECT 

...s. Describe database design processes by explaining the system development life cycle and entity relationship modeling. Describe the concept of object relational database management systems. Write
SQL SELECT queries. Customize
SQL queries when selecting data from a table. Identify SQL*Plus environment, features, and commands. Restrict rows retrieved by a query. Identify comparison
more...
Oracle SQL for End Users--Part 1 

...element with its description. Sequence the phases of the system development life cycle. Match components of the
EMPLOYEE and
DEPARTMENT entity relationship model with their description. Define structured query language (
SQL). Match SQL statement types with their appropriate SQL commands. Identify the capabilities of the
Oracle implementation of
ORDBMS and
RDBMS. Match database column
more...