Computer Training Computer Tutorials
Computer Lessons
CD Training CD Learning Elearning CD-ROM Computer Training Online Training
Education Information Learn Information
Career Training Career Skills
Keyword Search
All Training Products
New Releases
Top Sellers

Adobe
Animation & 3D
Applications
Business
Certification
Databases
Documentary History
Educational
General Interest
Graphics & Page Layout
Internet
Macromedia
Microsoft Office
Multimedia & Video
Online Technical
Online General
Operating System
Programming
Software & Design
Technical
Web Design

Webmaster Resources
Free Downloads
Website Promotions
Dictionary Terms
Forum Links
Articles
Free Training Quizzes
About / Demos
SiteMap
Order Info
Online Course Login
Amazon eMall
Add to Favorites

Newsletter Signup
Oracle9i SQL 1Z0-007: Database Objects and User Security
Product Code: OR0709 Time: 4 Hour(s) CEUs: .40

Summary:

This training course examines how to create database objects including sequences, synonyms, and indexes in Oracle9i SQL. It also covers sharing table data with other users through privileges and roles.

Objectives:

After completing this training course , students will be able to:
  • Create, modify, and delete sequences
  • Create, modify, and delete synonyms
  • Create, modify, and delete indexes
  • Create, modify, and delete users
  • Grant and revoke system and object privileges
  • Create, grant, revoke, enable, disable, and delete roles

Outline:

  • Working with sequences
  • Working with synonyms
  • Understanding indexes
  • Working with indexes
  • Understanding users
  • Working with users
  • Granting privileges
  • Revoking privileges
  • Creating, granting, and revoking roles
  • Enabling, disabling, and dropping roles

Features:

  • Exercises that allow users to practice the application
  • A file containing the text of the exercises
  • Simulations that allow users to practice training course skills, even if they don't have access to the application
  • A glossary
  • A Skill Assessment

Applicability:

This training 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 Constraints

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 © 2004 Discoveryvip.com Online Training All rights reserved.

Featured Computer Training Products

Application Training: Flash MX Software Training, Dreamweaver MX Software Training, Fireworks MX Software Training
Computer Skills Development
: Computer Basics Training, Everything Desktop (Microsoft Training), Everything Handheld
Business Skills Development Training: Everything Quick Business, Everything OSHA, Everything HR/Legal, Everything Management Skills, Everything Sales Skills, Everything Basic Finance
Certification Training Everything MCSE, Everything MCSD, Everything O/S 390, Everything Programming, Everything Cisco, Everything UNIX, Everything Oracle, Computer Technician Training, Network Technician Training