Oracle 9i SQL SQL*Plus And iSQL*Plus Reporting and PL/SQL

computer training tutorials Computer Training

Course List
Value Packages
Site Map
Oracle Certification
Free Training

Online Training Series:
Oracle 9i SQL 1Z0-007 Training

Oracle 9i > SQL 1Z0-007 > SQL*Plus And iSQL*Plus Reporting and PL/SQL

This Oracle 9i SQL 1Z0-007 Training Course on SQL*Plus And iSQL*Plus Reporting and PL/SQL is part of a 11 course, 24 hour online training series. This complete online training series can be purchased for only $59.95.



Length: 3 Hour

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
  • Online computer glossary
  • Online skill assessment testing
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: None

Technical Requirements: (Minimum)
  • Computer: 200MHz Pentium with 32MB Ram. 640 x 480 256-color video
  • Operating System: Windows 95, 98, NT, ME, 2000, or XP.
  • Minimum Connection Speed: 28.8k.
  • Browser: 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.

Need help or have questions about Oracle 9i SQL 1Z0-007? How about 24x7 access worldwide to our instructors! Now you can get answers from real experts within minutes via our online chat service. For just $40.00 additional you add our Instant Mentoring service and get your Oracle 9i SQL 1Z0-007 training courses questions quickly answered anytime from anywhere.

You might also be interested in our Technical Package which includes all of our Oracle 9i SQL 1Z0-007 courses plus over 800 hours of additional courses.

Retake any or all of our computer training as often as you want. Our online tutorials allow you to learn anywhere, anytime from any computer with internet access. All courses allow for 1 year unlimited access (1 user), includes a variety of features and all courses qualify for Continuing Education Units - CEU credit..
continuing education unit CEU credit

StaffKit is a worldwide leader in providing computer training, online tutorials and career education. StaffKit has satisifed customers in over 30 countries.

online training
Back to Oracle 9i SQL 1Z0-007 Training

About Us
News
Contact Us
Features
Certification

Reviews:

"The course material is very well organized and covers each objective in great detail"
MidWest Technology Journal

"this is a must have resource"
TheTechMag.com

Great Service and Excellent Training Product - Great People
Kenosha, WI

Great Training Product
Metuchen, NJ

Read more customer reviews about our e-learning training tutorials.

e-learning tutorial