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

Audience
This course is for anyone who is interested in learning more about Oracle9i SQL and in taking the Oracle 9i exam 1Z0-007: Introduction to Oracle 9i:SQL.

Time
1 Hour(s)

Product Code:or0711
After completing this course, the user should 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

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

Exercises that allow users to practice the application
A file containing the text of the exercises
Simulations that allow users to practice course skills, even if they don't have access to the application
A glossary
A Skill Assessment

Oracle9i SQL 1Z0-007: Introduction to SQL
Oracle9i SQL 1Z0-007: Intermediate Queries
Oracle9i SQL 1Z0-007: Queries with Single-Row Functions
Oracle9i SQL 1Z0-007: Combining Tables
Oracle9i SQL 1Z0-007: Grouping and Summarizing Data
Oracle9i SQL 1Z0-007: Advanced Queries and Views
Oracle9i SQL 1Z0-007: Working with Data
Oracle9i SQL 1Z0-007: Creating Tables and Constraints
Oracle9i SQL 1Z0-007: Database Objects and User Security
Oracle9i SQL 1Z0-007: SQL*Plus And iSQL*Plus Reporting and PL/SQL


Oracle9i™ is a trademark of the Oracle Corporation.

© 1999-2004 SK Max. All rights reserved.

General IT

Web Design

Microsoft Certs

Desktop Computing

Business Skills

Personal Skills

Combo Packages

Business Videos

Articles

Features

Instant Mentoring

Benefits

FAQs

HTML

A+

Windows 2000

Excel 2000

Office 2000

More Courses

e-Learning Links

e-Learning Forum

Certification Info

Other Resources

Home PageContact InformationSearch the Site
HomeOur Course Cataloge-Learning EdgeFree CoursesStudent Centere-ResourcesCorporate Information