Home » Course Catalog » Online Training Course Objectives and Outline
Oracle9i SQL 1Z0-007 Series: Intermediate Queries
Product Code: or0702 Time: 2.0 hour(s) CEUs: Available

Summary:

This course provides information about using the SELECT statement and using the WHERE and ORDER BY clauses in Oracle9i SQL.

Objectives:

  • Use the WHERE clause to filter out rows from query results
  • Format query results
  • Use multiple filters in a query
  • Query the DUAL table
  • Sort query results using the ORDER BY clause
  • Handle null values in query results


Topics:

  • Using the WHERE clause
  • Formatting query results
  • Using multiple filters
  • Dual and pseudocolumns
  • Using the ORDER BY clause
  • Sorting rules for null values

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.



Return To Top

Training Courses | e-Learning Edge | Training Course Certifications | Training Course Sign-up
Student Center | Learning Resources | Free Courses | Privacy Policy | Contact e-Learning Center

Hot Topics
IT Courses
MS Certs
Web Design
MS Office
Programming
Business
Networking
VS .NET
Personal
Full Catalog

Christian Website

Product Spotlight »

Add Instant Mentoring to any new subscription for only $50! Click below for more info.

Read More

Monthly Special - Our best values!! »

We always offer several special offers with savings from $50-$100 & more! Check out this month's special offers...

Read More

© 1999-2008 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

Student Feedback

Certification Info

Other Resources

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