User name:
Password:
 

 

Copyright © 2006.
cisco-certificatiom.co.uk
All Rights Reserved
Oracle9i SQL 1Z0-007 Series: Advanced Queries and Views
Product Code: or0706 Time: 2.0 hour(s) CEUs: Available

Summary:

This course provides an in-depth look at using subqueries and views in Oracle9i SQL.

Objectives:

  • List the types of subqueries
  • Use subqueries in Oracle SQL commands
  • Add and drop views
  • Change views
  • Modify data using views


Topics:

  • Subqueries
  • Types and uses of views
  • Simple, constraint and complex views
  • Changing and dropping views
  • Working with views
  • Inserting, updating and deleting in views

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.

Copyright � 2006 Webteks. All rights reserved.