MP9003: Network and Database (General) - Database Objects and User Security > Oracle9i SQL 1Z0-007

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. 

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

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

Duration:
4 Hours