Data Integrity in Oracle9i To describe how to use integrity constraints to enforce business rules on the data in an Oracle 9i database Anyone wanting to learn about Oracle9i database administration more...
SQL Functions in Oracle 9i To describe how to use SQL functions for data retrieval Junior database administrators, application developers, and database operators more...
Oracle9i Database Admin Manage Storage Structures ...Oracle 9i Database Administration: Manage Storage Structures course is the third in a five-part series covering the database administration strategies and procedures provided in Oracle9i. In this course, participants learn the concepts associated with storage structure components. In addition, this course teaches users the procedures for managing segment free space, undo space, temporary more...
Oracle Workflow 11i10 Communications Function Activities ...technical consultants and end-users who have knowledge of Oracle 9i, SQL, and programs within PL/SQL.
Deployment:
Self-Study
Accreditation
CEU credits: 0.40 CEUs
Language Options:
US English
Total Learning Time:
4 hours
Objectives:
Unit 1: Systems and Agents
Identify features of systems.
Identify features of agents.
Identify options that enable you to more...
Oracle Workflow 11i10 Developing Processes ...technical consultants and end-users who have knowledge of Oracle 9i, SQL, and programs within PL/SQL.
Deployment:
Self-Study
Accreditation
CEU credits: 0.40 CEUs
Language Options:
US English
Total Learning Time:
4 hours
Objectives:
Unit 1: Oracle Workflow Process
Identify guidelines for diagramming a workflow process.
Define an item type.
Define a more...
Oracle 9i New Features Database Administration This course introduces learners to the Oracle9i enhancements in server-side manageability, Oracle Enterprise Manager, and globalization. Learn To Identify memory and space management improvements. Describe segment and index management improvements. Identify improvements in database operations and performance. more...
Oracle 9i New Features Backup Recovery Performance Tuning This course introduces students to high availability and fault recovery, data protection and disaster recovery, LogMiner enhancements, online operations, and Recovery Manager enhancements. Students also learn about schema improvements, system improvements, and scalable session state management. Learn To Identify the new features designed to reduce unplanned more...
Oracle Performance Tuning 1Z0-033 ...Oracle 9i tuning certification examination, including the basics of performance tuning and tuning tools. Memory tuning covers the shared pool, the database buffer cache and other buffers. From an I/O perspective, topics covered are physical file structures of the database, tablespaces, datafiles and at the block level. Also covered are sorting, locking, latches and wait events, shared or more...