Profile
e-Catalog
Contact
Search
Cart
|
Profile |
|
Contact |
Search |
Cart |
 |
Oracle8i Database Administration: Data Integrity and Loading Techniques |
| Course Status: | Released |
| 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 introduce the student to declarative constraints and the different methods available to load data into an Oracle database |
| Learning Objectives |
| Compare the different methods of enforcing data integrity. Discuss the different types of integrity constraint. Create and modify integrity constraints. Explain direct-load insert. Outline the features of SQL. Loader. Explain the use of Import and Export. Load data using the Import and Export utilities. Describe transportable tablespaces. |
| Topics Covered |
| Data integrity constraints - Constraint types and states - Implementing constraints Loading data - Loading methods - Direct-load insert SQL*Loader - SQL*Loader features - SQL*Loader files - Loading data with SQL*Loader Reorganizing data - Exporting data - Importing data - Using Export and Import - Transportable tablespaces |