|
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
|
