This 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:
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
Topics:
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
Technical Requirements:
P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 6.0 or higher; Windows Media Player 9.0 or higher; Adobe Flash Player 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Cookies enabled; Sound card with speakers or headphones strongly recommended.
