|
||||
|
||
|
||
| Introduction to RDBMS and SQL *Plus | ||
| Functions, Tables, and Groups | ||
| Advanced SQL, SQL*Plus & Data Dictionary | ||
| DML and DDL Statements | ||
| Database Objects and Security | ||
| Oracle PL/SQL Basic Operations | ||
|
||
| Introducing Procedure Builder | ||
| Oracle Server and Database Architecture | ||
| Oracle Instance, the Start-up and Shutdown Procedure | ||
| Data Dictionary and Database Files | ||
| Oracle Storage Architecture | ||
| Understanding Storage Allocation | ||
| Indexes and Constraints | ||
| Managing Oracle Database Security | ||
| SQL*Loader, Oracle Export and Import, and NLS | ||
| VIEW DEMO To view a demo please visit our website link. To view a demo you need to visit our website and click the link. If you do not have a shockwave player it will ask you to download it. You only need the shockwave player for the online demos only, although they are the same as the product for web purposes we have configured them to play in shockwave. Shockwave is similar to a flash player and can be downloaded free from Macromedia shockwave.com | ||
Oracle 8i DBA - Indexes and Constraints
In this course you will learn to create indexes and enforce various constraints. The course teaches you how to reorganize and manage indexes, and maintaining constraints. You will also learn how to obtain information about indexes and constraints from the data dictionary.
Indexes and Constraints training covers such topics as:
Indexes
Constraint Concepts
Working with Constraints
This course introduces you to the basics of the administration of security, users, roles, and resources in Oracle 8i. The course also provides a list of data dictionary views that help in performing administrative tasks.
Managing Oracle Database Security training covers such topics as:
Managing Password Security
Managing Resources
Managing Users
Managing Privileges
Auditing
Managing Roles
The course is aimed at familiarizing you with the data transfer tools of Oracles. The course will teach you how to use SQL*Loader to load data into an Oracle database. The course will also teach you how to use the Oracle Export and Import Utilities and will explain the NLS feature of Oracle8i.
SQL*Loader, Oracle Export and Import, and NLS training covers such topics as:
Loading Data
Exporting and Importing Data
National Language Support
The course addresses the training needs of IT Professionals who use Oracle 8i. This course also addresses the needs of IT professionals who want to become certified under the Oracle8i Certified Database Administrator (DBA) Track.
Completion of this course and the other course titles from this curriculum prepares the learner for Oracle Exam #1Z0-001: Introduction to Oracle: SQL and PL/SQL