Oracle's Training Document for 1Z0-007, Introduction to Oracle9i: SQL

From: Rick He <rickyhe_at_accesscomm.ca>
Date: Sat, 9 Nov 2002 00:16:46 -0600
Message-ID: <3dcca901@news3.accesscomm.ca>

Hi,

This is a very good training material for Oracle's Exam# 1Z0-007: Introduction to Oracle9i: SQL.
It is officially from Oracle University. It covers the following topics:

---

Writing Basic SQL Select Statements
[ ] 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
**********************************

There are 3 files in PDF format (13Mb, 12Mb, 4Mb). So the best way is download from my FTP server.

Ask for $10

Rick Received on Sat Nov 09 2002 - 00:16:46 CST