Profile
e-Catalog
Contact
Search
Cart
|
Profile |
|
Contact |
Search |
Cart |
 |
Oracle8 Administration: Data Integrity and Loading Techniques |
| 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 explain methods of implementing data integrity, and to demonstrate data reorganization and loading techniques |
| Learning Objectives |
| Define and use constraints and triggers. Describe and compare data-loading methods. Use direct-load inserts. Demonstrate the use of SQL. Loader. Reorganize data using Export and Import. |
| Topics Covered |
| Defining constraints - Constraint types - Using constraints and triggers - Hands-on: Maintaining data integrity Loading data - Data loading methods - Direct-load insert - Hands-on: Using direct-load insert SQL*Loader - Introducing SQL*Loader - Hands-on: Loading data with SQL*Loader - Troubleshooting Reorganizing data - Exporting data - Importing data - Hands-on: Using Export - Hands-on: Using Import |