Total Time: 1 hour(s)

Summary: 
This course provides questions to prepare users who plan to take exam 1Z0-007: Introduction to Oracle9i: SQL.

Ojectives: 
After completing this course, students will be able to:
Answer practice questions in the format of the 1Z0-007 Introduction to Oracle 9i SQL exam
Assess readiness to take the exam and identify topic areas requiring further practice

Topics: 
SQL Plus reports
Writing basic SQL select statements
Restricting and sorting data
Single-row functions
Displaying data from multiple tables
Aggregating data using group functions
Subqueries
Producing readable output with iSQL Plus
Manipulating data
Creating and managing tables
Including constraints
Creating views
Creating other database objects
Controlling user access

Technical Requirements: 
P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.