Computer Based Training - Oracle9i SQL 1Z0-007: SQL*Plus And iSQL*Plus Reporting and PL/SQL

Summary:

This course examines how to use environment settings, variables, and special SQL Plus commands to generate professional looking reports in Oracle9i SQL.

Objectives:

After completing this course, students will be able to:

Create a well formatted report with SQL Plus
Know when and how to use variables
Use iSQL Plus
Use Top-N Analysis
Identify the basic concepts of PL/SQL

Outline:

SQL Plus reports
Environment settings
Using environment settings
Variables and scripts
Generating reports
Reporting features
Running reports
Top-N queries
PL/SQL
Retrieving data in PL/SQL
Dynamic SQL
Control structures
Iteration and repitition

Features:

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

Applicability:

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.

Prerequisites:

Oracle9i SQL 1Z0-007: Introduction to SQLOracle9i SQL 1Z0-007: Intermediate QueriesOracle9i SQL 1Z0-007: Queries with Single-Row FunctionsOracle9i SQL 1Z0-007: Combining TablesOracle9i SQL 1Z0-007: Grouping and Summarizing DataOracle9i SQL 1Z0-007: Advanced Queries and ViewsOracle9i SQL 1Z0-007: Working with DataOracle9i SQL 1Z0-007: Creating Tables and ConstraintsOracle9i SQL 1Z0-007: Database Objects and User Security

Technical Requirements:

200MHz Pentium with 32MB Ram. 640 x 480 256-color video (800 x 600 is recommended). Windows 95, 98, NT, 2000, or XP. Minimum Connection Speed: 28.8k. Internet Explorer 5.0 or higher required. Authorware and Macromedia Flash player recommended but not required. JavaScript must be enabled. Netscape and AOL browsers not supported.

Copyright Information:

Oracle9i™ is a trademark of the Oracle Corporation.

Terms of Use:

None