Online Using Oracle eLearning - Training Resources

Oracle Database 11g Supporting RMAN and Using Flashback Technology To recognize the steps for making sure that you can recover data quickly by tuning RMAN to avoid bottlenecks, and also for making sure that any changes to a database can be easily reversed, if necessary, using Oracle Database 11g's flashback features.  more...

Oracle Database 11g Intelligent Infrastructure Enhancements Identify how to to monitor performance, automate maintenance, calibrate and manage resources, and streamline job scheduling using Oracle Database 11g's intelligent infrastructure enhancements.  more...

Oracle Database 11g Using RMAN Enhancements Flashback and LogMiner identify ways of using Oracle Database 11g's enhanced RMAN, Flashback and LogMiner tools to clone databases, create backups and catalogs, archive historical data, and roll back transactions.  more...

Oracle9i Performance Tuning Optimizing Sorts Minimizing Contention ... Learning Time 6 to 8 hours 64333 Objectives Unit 1: Using Oracle Data Blocks Efficiently 1.5 - 2 hours o Match the component of database storage with its definition. o Avoid dynamic allocation of extents by using the ALTER TABLE command. o Avoid the dynamic allocation disadvantages by creating a locally managed tablespace. o Select the advantages of incorporating large extents into  more...

Oracle9i Database Admin Manage Security ...y the steps for creating a user. • Create a user by using Oracle Security Manager. • Identify the security feature available to an operating system user when a value for the OS_AUTHENT_PREFIX parameter is given. • Identify the guidelines for creating a user. • Maintain passwords by using Oracle Security Manager. • Maintain account locks by using Oracle Security  more...

Oracle9i Database Admin Manage Data Storage ...PK-FK relationship information and trigger information by using Oracle SQL*Plus Worksheet. • Load data by using direct-load inserts, identify the concepts associated with SQL*Loader, and use SQL*Loader to load data into tables. • Identify the uses of the export and import utilities, the export modes, and the export paths. • Reorganize data using export and import, identify  more...

Oracle9i Database Admin Create a Database ...content after creation. • Identify the benefits of using Oracle-Managed Files and manage data files, control files, and online redo log files using OMF. • Describe the data dictionary structure, identify the data dictionary categories, and retrieve data dictionary information. • Execute catproc.sql and identify the uses of administrative scripts categories. •  more...

Oracle8i Network Administration Net8 Additional Config Troubleshooting ...eps in resolving a client request to connect to a service using Oracle Names. Match the Oracle Names directory object with the appropriate definition. Identify the features of two domain naming models. Sequence the steps involved in discovering a Names server on the network by an Oracle Names client. Sequence the events that occur when an Oracle Names client uses its cache to retrieve Names  more...

Oracle8i Performance Tuning Optimizing Sorts Minimizing Contention ... arising from deadlock. Gather data and tune a database using Oracle Expert. C ontent Emphasis Skills-Based A udience Database Administrators, System Administrators, Network Administrators, and Technical Support Professionals. Participants should have completed the Oracle8i Database Administration Series (courses 63311-63315) prior to taking this course, and Oracle8i  more...

Oracle8i Performance Tuning Architecture Strategy ... 63311-63315) prior to taking this course, and experience using Oracle Enterprise Manager (OEM). This course will help candidates prepare for the Oracle8i Certified Database Administrator (DBA) Track Exam 4, 1Z0-024. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: Tuning the Oracle8i Server: Overview Duration: 1.5 - 2 Hour(s) Match the tuning goals with the  more...

Oracle8i Database Admin Manage Security ...Identify the steps for creating a user. Create a user by using Oracle Security Manager. Identify the security feature available to an operating system user when a value for the OS_AUTHENT_PREFIX parameter is given. Identify the guidelines for creating a user. Maintain passwords by using Oracle Security Manager. Maintain account locks by using Oracle Security Manager. Change the user quota  more...

Oracle8i Database Admin Manage Data Storage ...tinguish the two collection datatypes. Create a table by using Oracle Schema Manager. Identify the guidelines to be followed while creating tables. Identify the value for the PCTFREE parameter in a given situation. Match the row chaining and row migration events with the situations that trigger them. Copy an existing table by using Oracle Schema Manager. Identify the storage parameters  more...

Oracle8i Database Admin Manage Storage Structures ...parameters. Coalesce free space in a given tablespace by using Oracle Tablespace Manager. Identify the correct sets of objects and their fragmentation propensity levels. Match the data block contents with their features. Match the block space utilization parameters with the information that they provide. Sequence the steps used by the Oracle Server to manage data within a block. Retrieve  more...

Oracle8i Database Admin Create Databases ... file. Start a specified instance in the NOMOUNT mode by using Oracle SQL*Plus Worksheet. Identify the functionality of the CREATE DATABASE command options. Create a database with specified parameter values by using the CREATE DATABASE command. Identify the commonly encountered situations in which the CREATE DATABASE command fails. Identify the contents of a database after its creation.  more...

Oracle Reports R6 Enhance Reports ...enable developers to construct complex reports and charts using Oracle Reports. This course introduces the learner to the key features of the Data Model editor, Layout Model objects and their properties. The course also enables the learner to enhance matrix reports by modifying the objects in Data Model editor and the Layout Model editor. This course is based on Oracle's ILT course, Oracle  more...

Oracle8 Performance Tuning Optimizing Sorts and Minimizing Contention ...ning Time 6 - 7 Hour(s) Course Contents Unit 1: Using Oracle Data Blocks Efficiently Duration: 1 Hour(s) Match components of database storageunits to their definition. Query the dba_tables to display segments with less than 10% free blocks. Manually allocate an extent. Choose the advantages of incorporating large extents into database design. Identify characteristics of  more...

Oracle8 Performance Tuning Strategies and Techniques ...ith administering an Oracle8 database and have experience using Oracle Enterprise Manager (OEM), or have taken the Oracle8 Database Administration series (courses 61311-61315). T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: Oracle Performance Tuning Methodology Duration: 1.5 - 2 Hour(s) List the different roles associated with the tuning process. List examples  more...

Oracle8 Database Administration - Manage Security ...Sequence the steps for creating a user. Create a user by using Oracle Security Manager. Given a value for the OS_AUTHENT_PREFIX parameter, identify the security feature available to the operating system user with a given user name. Maintain passwords by using Oracle Security Manager. Maintain account locks by using Oracle Security Manager. Change the user quota on a tablespace by using  more...

Oracle8 Database Administration - Manage Data ...tinguish the two collection datatypes. Create a table by using Oracle Schema Manager. Identify the guidelines to be followed while creating tables. Identify the value for the PCTFREE parameter in a given situation. Match the row chaining and row migration events with the situations that trigger them. Copy an existing table by using Oracle Schema Manager. Identify the storage parameters  more...

Oracle8 Database Administration - Manage Storage Structures ...parameters. Coalesce free space in a given tablespace by using Oracle Tablespace Manager. Identify the correct sets of objects and their fragmentation propensity levels. Match the data block contents with their features. Match the block space utilization parameters with the information that they provide. Sequence the steps used by the Oracle Server to manage data within a block. Retrieve  more...

Oracle8 Database Administration - Create Databases ... file. Start a specified instance in the NOMOUNT mode by using Oracle SQL Worksheet. Identify the functionality of the CREATE DATABASE command options. Create a database with specified parameter values by using the CREATE DATABASE command. Identify the commonly encountered situations in which the CREATE DATABASE command fails. Identify the contents of a database after its creation.  more...

Oracle Workflow 11i10 Components Planning Workflow Processes ...using Oracle Workflow in an e-business environment. It provides an overview of the architecture and components of Oracle Workflow. It also covers the components of a workflow process. Further, it covers the steps to plan a workflow process. It also covers various standard activities. Learn To: Identify benefits of Oracle Workflow. Identify features of workflow processes. Identify  more...

Oracle 11i10 System Admin Personalization Workflow Components ...trator-level page personalization. Identify benefits of using Oracle Workflow. Match tiers of Oracle Workflow architecture with their features. Match components of Oracle Workflow with their features. Audience: This course is intended for functional and technical consultants and individuals responsible for administering an Oracle 11i environment. Deployment: Self-Study  more...

Oracle SQL Specifics Creating and Managing Database Objects ...ENT ON statement to add a comment to a table. Unit 2: Using Oracle Database Objects Duration: 1.5 - 2 Hour(s) Identify the advantages of views. Use the CREATE VIEW statement to create a view. Differentiate between a single view and a complex view. Use the CREATE OR REPLACE VIEW statement to modify a view. Use the CREATE OR REPLACE VIEW statement with the WITH CHECK OPTION clause  more...

SQL and PL SQL PL SQL Basics ...ics of PL/SQL. The course builds the necessary skills for using Oracle PL/SQL. It will help the learner acquire the expertise to design, develop, and implement Oracle Server applications by using Oracle Structured Query Language (SQL) and PL/SQL. The learner is guided step-by-step through the various aspects of PL/SQL programming. Numerous easy-to-understand examples ensure that the concepts  more...

Oracle 11i 2 6 Implement Workflow Fundamentals Part 1 ...es. Identify features of business processes integration using Oracle Workflow. Match Oracle Workflow database components with their features. Identify features of Oracle Workflow business events. Identify issues related to managing business events in Oracle Workflow. Identify issues involved in raising an Oracle Workflow business event. Identify features of item type attributes.  more...

Oracle Database 10g Administration Workshop II Part 1 .... Identify key concepts related to data conversion done using Oracle utilities. Identify key concepts related to data conversion performed using Data Pump. Unit 3: Controlling Access and Transactions Identify listener security features in Oracle Database 10g. Sequence the steps to set the listener password by using Enterprise Manager (EM). Identify steps to set the listener  more...

Oracle Database 10g Administration Workshop I Part 1 ...ware. Identify the steps to install Oracle Database 10g using Oracle Universal Installer (OUI). Identify the steps to create a database using the Database Configuration Assistant (DBCA). Match the files that constitute an Oracle database with their descriptions. Identify features of a tablespace structure in Oracle Database 10g. Identify features of memory structures associated with  more...

Oracle 9i New Features Database Administration ...ents. Identify enhancements in using Oracle Names Servers as LDAP proxies. Explain Oracle Enterprise Manager installation and configuration features in Oracle9i. Identify Oracle Enterprise Manager console database and enterprise administration features in Oracle9i. Describe Oracle  more...