Profile
e-Catalog
Contact
Search
Cart
|
Profile |
|
Contact |
Search |
Cart |
 |
Oracle8 Administration: Creating Tables and Indexes |
| Course Status: | Released | Course Features |
| Course Language: | English | |
| Course Duration: | 4 Hours | |
| Deployment Options: | Online, Interactive CDs, Network, Downloads, Intranet |
| Audience |
| Database administrators |
| Prerequisites |
| Completion of the Oracle Introduction curriculum |
| Course Aim |
| To illustrate how to create and maintain tables and indexes |
| Learning Objectives |
| Distinguish between different Oracle datatypes. Understand the storage settings available. Create, alter, and analyze tables. Create and maintain indexes. Control the use of extents by segments. |
| Topics Covered |
| Datatypes and tables - Tables and rows - Built-in datatypes Creating and altering tables - Designing and creating tables - Altering tables - Hands-on: Creating tables Managing space - Freeing unused space - Gathering statistics - Hands-on: Analyzing tables Indexes - Index types - Creating indexes - Managing indexes - Hands-on: Creating an index - Hands-on: Analyzing and rebuilding an index |