After completing Oracle8: Database Schema Objects, the user should be able to:
| Create tables |
| Manage different table views and types |
| Create indexes |
| Identify and use index types |
|
Understanding Tables
| Parts of a table |
| How tables work |
| Oracle data types |
Creating Tables
| Enterprise Manager |
| Schema Manager |
| CREATE TABLE command |
| Including the STORAGE clause |
Special Tables and Table Views
| Partitioned tables |
| Object tables |
| Views |
Indexes
| Using indexes |
| Index types |
| How the Oracle index works |
| Deciding what to index |
Creating Indexes
| Taking advantage of indexes |
| Creating indexes with Schema Manager |
| CREATE INDEX command |
Special Indexes
| Partitioned indexes |
| Bitmap indexes |
Synonyms and Table Sequences
| Synonyms |
| Table sequences |
|
This course is distributed with:
| Exercises that allow users to practice in Oracle8 |
| A file containing the text of the exercises |
| Simulations that allow users to practice course skills, even if they don't have access to the Oracle8 product |
| An Oracle8 glossary |
|