Oracle8i: SQL Queries




Distance-learning Center

Submit IT Questions

DURATION: 4 days

FEE: $1,980


  • Programmer
  • Web Developer
  • System Designer
  • System Analyst
  • IT Professional


  • SQL queries
  • Query performance
  • Read consistency
  • SQL functions for building queries
  • Aggregate functions
  • Single row functions
  • Analytical functions
  • Calculating ranks
  • Aggregates
  • Sliding window boundaries - definitions
  • SQL - extending with user-written functions
  • Functions - creating
  • PL/SQL functions within SQL
  • Inner and outer joins
  • Set operators
  • Subqueries - building
  • Correlated subqueries
  • Subqueries in the FROM-clause
  • Views and temporary tables
  • Temporary tables - alternatives to views

Contact Me
Send Outline
Private Course - Tailored
Cost Analysis

Effective February 27, 2012, the course dates listed on the SYS-ED schedules only will be available based upon approved and authorized user ID.

The course material and training aids utilized in SYS-ED courses are from multiple sources: courseware generated by staff members, licensed materials, public sources from the Internet, textbooks, and source vendor's documentation.

Not all courses are available for delivery in a distance-learning medium.
Copyright Acknowledgement: The software product(s) listed in this outline are owned and copyrighted by their respective companies. SYS-ED makes no representation regarding ownership in any of the software products that we train on.
SYS-ED courses are not intended for or open to the general public. They are intended for employees of Fortune 1000 companies, government municipalities, consulting companies, software companies, healthcare providers, and mid-sized businesses.

Individuals attending a SYS-ED course will be required to execute a statement that the employer has a licensed version of the software.