Online Administration Ii Oracle eLearning

Oracle 11i Organization Forecasting and Integration Oracle 11i: Organization Forecasting and Integration Oracle To use organization forecasting for project planning and administration, and integrate Oracle Projects with Oracle Sales and Oracle Advanced Product Catalog to manage sales and product lifecycles  more...

Oracle Application Server 10g Component Administration in Oracle Internet Direc Oracle Application Server 10g: Component Administration in Oracle Internet Direc Oracle To demonstrate how to configure Oracle Internet Directory (OID) components in OracleAS  more...

Oracle Application Server 10g DAS and SSO Oracle Application Server 10g: DAS and SSO Oracle To demonstrate how to manage users and groups with Delegated Administration Service (DAS) and administer the Single Sign-On feature of OracleAS  more...

Oracle Database 10g Installing Oracle Database 10g Oracle Database 10g: Installing Oracle Database 10g Oracle To introduce the concepts of RDBMS and Oracle database administration, and explain how to install Oracle Database 10g software  more...

Oracle Database 10g Creating Databases Oracle Database 10g: Creating Databases Oracle To provide an overview of Oracle database and instance architecture and demonstrate how to use the Database Configuration Assistant  more...

Oracle Database 10g Database Interfaces Oracle Database 10g: Database Interfaces Oracle To explain how to use SQL and SQL*Plus to access an Oracle 10g database and introduce other common database interfaces  more...

Oracle Database 10g Database Control and Storage Structures Oracle Database 10g: Database Control and Storage Structures Oracle To explain the fundamentals of Oracle database control and how to use tablespaces  more...

Oracle Database 10g Users and Security Oracle Database 10g: Users and Security Oracle To explain how to manage users, implement security, and audit database activity on an Oracle 10g database  more...

Oracle Database 10g Managing Schema Objects and Data Oracle Database 10g: Managing Schema Objects and Data Oracle To demonstrate how to manage schema objects and data in an Oracle 10g database  more...

Oracle Database 10g The SQL Loader and PL SQL Oracle Database 10g: The SQL*Loader and PL/SQL Oracle To provide an overview of how to use the SQL*Loader and PL/SQL in an Oracle 10g database  more...

Oracle Database 10g Oracle Net Services and Shared Servers Oracle Database 10g: Oracle Net Services and Shared Servers Oracle To provide an overview of Oracle Net Services and Shared Server  more...

Oracle Database 10g Monitoring and Maintenance Oracle Database 10g: Monitoring and Maintenance Oracle To demonstrate how to control database performance and configure proactive database maintenance  more...

Oracle Database 10g Managing Undo Data and Lock Conflicts Oracle Database 10g: Managing Undo Data and Lock Conflicts Oracle To discuss how to manage undo data and manage lock conflicts in an Oracle database  more...

Oracle Database 10g Managing Backup and Recovery Oracle Database 10g: Managing Backup and Recovery Oracle To discuss how to manage backup and recovery in an Oracle 10g database  more...

Oracle 11i E-Business Suite System Administration Oracle 11i E-Business Suite: System Administration Oracle To identify ? and in some cases perform ? key system-administration tasks in 11i E-Business Suite  more...

Oracle 11i Roles Delegated Administration Registration and Auditing Oracle 11i: Roles, Delegated Administration, Registration, and Auditing Oracle To create roles, set up Delegated Administration, create registration processes for roles, run audit reports, monitor users, and enable the AuditTrail feature  more...

Oracle 11i Concurrent Elements Oracle 11i: Concurrent Elements Oracle To submit and manage requests, create request groups and request sets, and identify the concepts and tools associated with concurrency and concurrency administration  more...

ORACLE DATABASE 10g ADMINISTRATION WORKSHOP I RELEASE 2 ORACLE DATABASE 10g: ADMINISTRATION WORKSHOP I RELEASE 2 Oracle  more...

Oracle Database 11g R2 Database Architecture Recovery Operations Oracle Database 11g R2: Database Architecture & Recovery Operations Oracle An important aspect of Oracle Database administration is to understand how a database and its major components function. Also as an Oracle Database administrator, you need to be able to recover when problems occur in the database. This is accomplished using backups, which are used to protect against problems such as  more...

Oracle Database 11g R2 The RMAN Catalog Creataing Backups Oracle Database 11g R2: The RMAN Catalog & Creataing Backups Oracle RMAN uses a recovery catalog to store metadata about Oracle databases, and allows stored scripts to be used to run sequences of RMAN commands stored in the catalog. When administering an Oracle Database, it is important to be familiar with what a backup is, how the process of creating a backup is completed, and the various  more...

ORACLE DATABASE 11G ADMINISTRATION WORKSHOP II R2 ORACLE DATABASE 11G: ADMINISTRATION WORKSHOP II R2 Oracle  more...

Oracle Database 11g R2 Managing Database Space Duplication Oracle Database 11g R2: Managing Database Space & Duplication Oracle To effectively manage space, you can configure automatic management by the Oracle database server. This allows you to generate alerts about potential problems and recommend possible solutions. This course explores how to use the Oracle database server for automatic space management, proactively monitor and manage tablespace  more...

Oracle Database 11g R2 Managing Databse Resources The Scheduler Oracle Database 11g R2: Managing Databse Resources & The Scheduler Oracle By using the Database Resource Manager, you have more control over the allocation of machine resources than is normally possible through operating system resource management alone. Many tasks in the Oracle environment need job-scheduling capabilities. Using advanced Scheduler features, you can exercise more control  more...

Oracle Database 11g R2 Managing Database Memory Performance Oracle Database 11g R2: Managing Database Memory & Performance Oracle Because there is a finite amount of memory available on a database server and on an Oracle Database 11g instance, you must pay attention to how memory is allocated. Also, database planning must include a balance between performance, cost, and reliability. You must consider the investment in the system architecture, which  more...

Oracle Database 11g R2 Database Diagnostics Flashsback Technologies Oracle Database 11g R2: Database Diagnostics & Flashsback Technologies Oracle Administering an Oracle database requires monitoring and diagnosing data failures and recovering from them. Oracle Database 11g Release 2 provides the Data Recovery Advisor which eases this task by automatically detecting errors when they occur and providing repair advice. The use of the Automatic Diagnostic  more...

Oracle Database 11g R2 Performing Restore Recovery Tasks Oracle Database 11g R2: Performing Restore & Recovery Tasks Oracle As a database administrator it is very important to understand how to restore and recover your database in the event of a loss of a file due to media, hardware, or user error. The restoration process involves moving a backup into place to be used by the database when a file is damaged. The recovery process involves applying  more...

Oracle Database 11g R2 Using Monitoring Tuning RMAN Oracle Database 11g R2: Using, Monitoring & Tuning RMAN Oracle Reconstructing the contents of all or part of a database from a backup typically involves two phases. The first phase is the retrieval of a copy of the data file from the backups. The second involves reapplying changes to the file that occurred since the backup, using archived and online redo logs. To effectively administer an  more...

ORACLE APPLICATION SERVER 10G ADMINISTRATION I ORACLE APPLICATION SERVER 10G: ADMINISTRATION I Oracle  more...

ORACLE APPLICATION SERVER 10G ADMINISTRATION II ORACLE APPLICATION SERVER 10G: ADMINISTRATION II Oracle  more...

Oracle Database 11g Installation of Clusterware RAC Oracle Database 11g: Installation of Clusterware & RAC Oracle Oracle Database 11g: Real Application Clusters (RAC) enable high utilization of a cluster of standard, low-cost modular servers and offers high availability, scalability, and important grid computing features. This course provides an introduction to Oracle Database 11g: Real Application Clusters (RAC) and demonstrates how to  more...

Oracle Database 11g RAC Database Oracle Clusterware Admin Oracle Database 11g: RAC Database & Oracle Clusterware Admin. Oracle Oracle Database 11g has many tools available for administering a RAC Database and Oracle Clusterware, including Oracle Enterprise Manager. This course explains how to use Enterprise Manager cluster database pages to administer a RAC database and how to carry out various administration tasks on Oracle Clusterware. It  more...

Oracle Database 11g RAC Performance Tuning Oracle Database 11g: RAC Performance Tuning Oracle Performance Tuning uses diagnostic tools to gather statistics, statistic rates, and sampled statistics in order to tune the database system to provide the best performance as efficiently as possible. Although there are specific tuning areas for Oracle Database 11g: RAC, such as instance recovery and interconnect traffic, you will get the  more...

Oracle Database 11g Configure Manage Use Services in RAC Oracle Database 11g: Configure, Manage & Use Services in RAC Oracle A service is a grouping of related tasks within a database with common functionality, quality expectations, and priority relative to other services. It provides a single-system image for managing competing applications running within a single instance and across multiple instances and databases. Using standard interfaces,  more...

Oracle Database 11g Diagnosing Oracle Clusterware Node Management Oracle Database 11g: Diagnosing Oracle Clusterware & Node Management Oracle Problems that occur with Oracle RAC instances can be difficult to diagnose because they span across two or more nodes in a cluster. Oracle Database 11g provides various methods for diagnosing and debugging Oracle Clusterware and RAC components. This course discusses the basics of debugging and the use of diagnostics  more...

Oracle Database 11g High Availability Oracle Database 11g: High Availability Oracle In Oracle Database 11g, RAC and Data Guard together provide the benefits of system-level, site-level, and data-level protection, resulting in high levels of availability and disaster recovery without loss of data. This course explains how to configure connections for high availability using various types of workload distribution and load  more...

ORACLE DATABASE 11G RAC ADMINISTRATION ORACLE DATABASE 11G: RAC ADMINISTRATION Oracle  more...

Oracle Database 11g Oracle Net Services Listener Security Oracle Database 11g: Oracle Net Services & Listener Security Oracle When considering Oracle security, you must also consider the security of the listener, which is the gateway to the network and the network itself. This course describes the items on the client, listener, and network security checklists. It demonstrates how to secure administration of the network, restrict access by IP  more...

Oracle Database 11g R2 Database Architecture Installation Oracle Database 11g R2: Database Architecture & Installation Oracle Oracle Database 11g Administrator Certified Associate 1Z0-052 Oracle Database 11g: Administration Workshop I Release 2 To understand how an Oracle Database functions, it is important to gain a basic understanding of its major components. This course identifies the major architectural components of the Oracle Database 11g  more...

Oracle Database 11g R2 Database Creation Instance Management Oracle Database 11g R2: Database Creation & Instance Management Oracle Oracle Database 11g Administrator Certified Associate 1Z0-052 Oracle Database 11g: Administration Workshop I Release 2 As an Oracle Database administrator, it is important to plan the database to ensure that the database software is installed properly. Planning involves the logical storage structure, the overall design,  more...

Oracle Database 11g R2 The ASM Instance Network Connectivity Oracle Database 11g R2: The ASM Instance & Network Connectivity Oracle Oracle Database 11g Administrator Certified Associate 1Z0-052 Oracle Database 11g: Administration Workshop I Release 2 Oracle Database 11g Release 2 offers Automatic Storage Management (ASM), which eliminates the need for many tasks that are required on a non-ASM storage environment by the DBA. Some of these tasks include  more...

Oracle Database 11g R2 Storage Structures User Security Oracle Database 11g R2: Storage Structures & User Security Oracle Oracle Database 11g Administrator Certified Associate 1Z0-052 Oracle Database 11g: Administration Workshop I Release 2 An Oracle database is divided into logical storage units called tablespaces. Oracle also provides Oracle-Managed Files (OMF), which eliminate the need for the DBA to directly manage the operating system files  more...

Oracle Database 11g R2 Managing Concurrency Undo Auditing Oracle Database 11g R2: Managing Concurrency, Undo & Auditing Oracle Oracle Database 11g Administrator Certified Associate 1Z0-052 Oracle Database 11g: Administration Workshop I Release 2 Oracle Database 11g Release 2 is designed to prevent multiple users from changing the same data at the same time by implementing locks. These locks are used to manage data concurrency and are implemented  more...

Oracle Database 11g R2 Managing Database Maintenance Performance Oracle Database 11g R2: Managing Database Maintenance & Performance Oracle Oracle Database 11g Administrator Certified Associate 1Z0-052 Oracle Database 11g: Administration Workshop I Release 2 General database maintenance and performance monitoring are important Oracle DBA tasks. Proactive and reactive database maintenance is made easy by the sophisticated infrastructure of Oracle Database  more...

Oracle Database 11g R2 Backup Recovery Oracle Database 11g R2: Backup & Recovery Oracle Oracle Database 11g Administrator Certified Associate 1Z0-052 Oracle Database 11g: Administration Workshop I Release 2 Preparing for and performing data recovery and completing database backups are expected job duties of an Oracle Database 11g Database Administrator (DBA) to ensure that the database is available for users when they require it.  more...

Oracle Database 11g R2 Moving Data Oracle Support Oracle Database 11g R2: Moving Data & Oracle Support Oracle Oracle Database 11g Administrator Certified Associate 1Z0-052 Oracle Database 11g: Administration Workshop I Release 2 From time to time Oracle DBAs are required to move data. Oracle Database 11g Release 2 offers various ways to complete this task, including Oracle Data Pump, SQL*Loader, and the use of external tables. DBAs are also  more...

1Z0-052 ORACLE DATABASE 11G ADMINISTRATION WORKSHOP I R2 1Z0-052 ORACLE DATABASE 11G: ADMINISTRATION WORKSHOP I R2 Oracle Oracle Database 11g Administrator Certified Associate 1Z0-052 Oracle Database 11g: Administration Workshop I Release 2  more...

Oracle 10g OCA The demand for Oracle technical professionals is growing fast. Experienced or new to the profession you need to know what skills make you more attractive to employers. You will have 1 year access to this course but can complete it as quickly as you like to. Oracle 10g OCA The demand for Oracle technical professionals is growing fast. Experienced or new to the profession you need to know what  more...

Architecture and Administration Tools in Oracle9i To describe the Oracle9i database architecture and how to use the database administration tools  more...

Using Flashback Technology in Oracle 10g To outline the considerations and procedures for using Flashback features  more...

Performing and Managing Backups in Oracle 10g To outline the processes and considerations for using RMAN to perform and monitor backups  more...

Advanced Database Recovery and Repair in Oracle 10g To outline the processes for recovering non-critical files, performing incomplete recoveries, and repairing corrupted components of databases  more...

Controlling the Oracle Listener and Enabling Distributed Transactions in Oracle To outline the concepts and processes to secure the Oracle listener and to work with remote and distributed transactions  more...

Using Globalization Support in Oracle 10g To outline the considerations and procedures for globalizing a database  more...

Optimizing Database Performance in Oracle 10g To outline the processes and considerations for optimizing an Oracle database using alerts, trace files, and advisors  more...

Managing Storage and System Resources in Oracle 10g To outline the processes and considerations for using the Automatic Storage Management and Database Resource Manager features  more...

Using the Scheduler to Automate Tasks in Oracle 10g To outline the processes and considerations for using the Scheduler tool  more...

Using Advanced Features in Oracle 10g To outline the processes and considerations for using the advanced features of Oracle Database 10g  more...

Oracle Database 11g Database Architecture and Installation Identify the elements of the Oracle Database 11g architecture and recognize the tools and steps required to install the Oracle Database 11g software  more...

Oracle Database 11g Database Creation Instance Management and Connectivity Identify the steps for creating a new Oracle Database 11g database and then configuring it and managing the instance, and also recognize the steps for configuring new Oracle Net Listeners and database connectivity  more...

Oracle Database 11g Storage Structures and User Security identify the steps for maintaining storage structures and automating storage management in Oracle Database 11g, and for managing privileges, roles, and other security features for users.  more...

Oracle Database 11g Managing the Schema Data and Concurrency Identify the steps for managing schema objects, such as tables, views, and indexes, and recognize ways to use SQL and PL/SQL commands to manipulate data and ensure data concurrency  more...

Oracle Database 11g Managing Undo Data Database Security and Maintenance recognize the steps required to manage undo information, secure an Oracle Database 11g database, and maintain it by monitoring statistics, automated tasks and alert thresholds.  more...

Oracle Database 11g Performance Monitoring Recovery Concepts and Backup identify the steps for ensuring an Oracle Database 11g database is available to users when needed, by monitoring its performance, anticipating and avoiding database failure, setting up instance recovery options, and creating backups.  more...

Oracle Database 11g Recovering Moving and Enhancing the Oracle Database recognize ways to make use of Oracle Database 11g's tools for moving and recovering data, reporting on problems, and installing updates to enhance a database.  more...

Oracle Database 11g Database Architecture and ASM To recognize the structural elements in Oracle Database 11g's architecture, including and Automatic Storage Management (ASM), and recognize the steps for managing storage using disk groups.  more...

Oracle Database 11g Configuring for Recovery To recognize the steps for configuring all aspects of backup and recovery functionality in Oracle Database 11g, using ARCHIVELOG mode, retention policies, a Flash Recovery Area, and an RMAN recovery catalog.  more...

Oracle Database 11g Configuring for Backups To identify the steps for preparing a database for backup and then for performing various types of RMAN backups and monitoring them using reports and dynamic performance views, and also for performing user-managed backups and recoveries.  more...

Oracle Database 11g Using RMAN for Recovery To identify ways to use RMAN to ensure that data is not lost in Oracle Database 11g, by performing complete and incomplete recoveries as well as disaster recoveries, by cloning databases, and by restoring a tablespace to a particular point in time.  more...

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 Diagnosing the Database and Managing Memory To identify the steps for diagnosing and repairing database problems with the help of Oracle Support using Automatic Diagnostic Repository, Support Workbench, and health checks, and also for enabling and configuring automatic memory management and automatic shared memory management.  more...

Oracle Database 11g Database Performance and Space Management To identify the steps for making sure your Oracle Database 11g database is performing well and has adequate space, by monitoring statistics, tuning SQL, testing workloads, managing space, and transporting tablespaces.  more...

Oracle Database 11g Managing Resources and Task Automation To identify ways to ensure that resources are being put to best use and database jobs are performed when they should be, using the Database Resource Manager and the Scheduler.  more...

Oracle Database 11g Globalization To recognize the steps for utilizing Oracle Database 11g's globalization support features to ensure that information and data is displayed in a user's native language, and that territory and language-dependent conventions are adhered to.  more...

Oracle 11i10 System Administration Curriculum The Oracle 11i10 System Administration Curriculum includes the following courses: Oracle 11i10 System Admin.: Application, Function & Data Security Oracle 11i10 System Admin.: User Management & Resource Auditing Oracle 11i10 System Admin.: Concurrent Management & Profile Options Oracle 11i10 System Admin.: Printer Management & Form Personalization Oracle 11i10 System Admin.:  more...

Oracle 11i10 System Admin DBA Activities In this course, learners will be introduced to different tasks and duties a DBA and a system administrator perform to administer Oracle Applications. The tasks and duties discussed in this course are Application DBA duties, folder administration, custom program addition, help customization, and document sequencing. Learn To: Identify the steps for assigning resource consumer groups.  more...

Oracle 11i10 System Admin Workflow Applications Manager This course covers the mandatory and optional tasks that are performed to set up Oracle Workflow. It also introduces the learners to Oracle Applications Manager (OAM) and its benefits. In addition, it explores options to monitor system performance, critical activities, and business flows of an organization. Finally, it covers features that help in diagnosing and resolving system issues.  more...

Oracle 11i10 System Admin Application Function Data Security In this course, learners will be introduced to the concepts and fundamentals of Oracle Applications Security. This course will also cover various layers of access control in Oracle Applications Security. In addition, it will provide detailed information on two core security layers of access control, Function Security and Data Security. Learn To: Identify features of Core Security  more...

Oracle 11i10 System Admin User Management Resource Auditing In the Oracle 11i10 Sys Admin: User Management and Resource Auditing course, learners will be introduced to the concepts and implementation of Oracle User Management and resource auditing. Learn To: Identify privileges of different types of users in Oracle User Management. Identify steps in different phases of Oracle User Management implementation. Identify features of roles.  more...

Oracle 11i10 System Admin Concurrent Management Profile Options In this course, the learner will be introduced to the concepts and setup of concurrent programs and profile options management. Learn To: Identify features of concurrent processing. Schedule concurrent requests. Identify the uses of different options in the Requests window. Identify features of defining a concurrent manager. Identify benefits of parallel concurrent  more...

Oracle 11i10 System Admin Printer Management Form Personalization The course covers concepts and tasks associated with printer management, such as registering a new printer, printing with the pasta utility, and customizing print options. The course also focuses on demonstrations essential for personalizing forms. In addition, the course contains information about the basic, intermediate, advanced, and administrative concepts related to forms personalization.  more...

Oracle 11i10 System Admin Personalization Workflow Components In this course, learners will be introduced to the concept and configuration of personalizations at different levels. The course also introduces the learners to the benefits of the workflow process and describes different types of workflow components. Learn To: Identify features of personalizations. Match the profile options configured to enable or disable page personalization  more...

Oracle Database 10g Administration Workshop II Part 4 This course will teach learners to configure an Oracle database for multilingual applications and distributed database access. Learners will learn how to use various database technologies, such as Resource Manager, the Scheduler, and materialized views. Learn To: Identify features of Automatic Storage Management (ASM). Identify features of Automatic Storage Management (ASM)  more...

Oracle Database 10g Administration Workshop II Part 3 This course covers various functions of the Flashback technology. In addition to performing flashback operations at the database level, you can flash back a table or recover a table that has been dropped by mistake. The course also covers the tools used to monitor and improve database performance as well as detect and repair database corruption. Learn To: Identify features of  more...

Oracle Database 10g Administration Workshop II Part 2 This course will teach learners to use RMAN and explain the various RMAN commands. Diagnostic sources, non-critical recovery, and incomplete recovery concepts are also covered in this course. Learners will also learn how to perform incomplete recovery. Learn To: Match various RMAN commands with their features. Distinguish between the methods for issuing RMAN commands. Identify  more...

Oracle Database 10g Administration Workshop I Part 4 Learners will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Learners will also be taught about undo management, lock management, and backup and recovery techniques. Learn To: Identify benefits of undo data. Identify features of undo segments. Identify undo management tasks that a DBA should perform  more...

Oracle Database Administration Workshop I Part 2 Oracle Database 10g is the first database designed for enterprise grid computing, the most flexible and cost-effective way to manage enterprise information. This course covers salient aspects of Oracle Database 10g such as user and data management. The basic aspects of database management such as database integrity constraints, transferring data, and defining tables and schemas has been discussed  more...

Oracle8 Database Administration - Manage an Instance Course Overview This course is the first in a five-part series covering the database administration strategies and procedures provided in Oracle8. In this course, participants will learn about the concepts and procedures associated with Oracle architectural components, using the database administration tools, managing an Oracle instance, and using National Language Support. L earn To:  more...

Oracle8 Database Administration Curriculum The Oracle8 Certified Database Administration Curriculum consists of the following courses: Oracle8 Database Administration - Manage and Instance Oracle8 Database Administration - Create Database Oracle8 Database Administration - Manage Storage Structures Oracle8 Database Administration - Manage Data Oracle8 Database Administration - Manage Security To review individual course  more...

Oracle8 Database Administration - Create Databases Course Overview This course is the second in a five-part series covering the database administration strategies and procedures provided in Oracle8. In this course, participants will learn about the concepts associated with storage structure components, managing rollback segments, temporary segments, and indexes. In addition, creating and maintaining databases will be covered. L earn To:  more...

Oracle8 Certified Database Administrator Curriculum NETg is Oracle's partner in offering interactive TBT preparation courses for this important certification program. Each of these TBT courses has been co-developed by Oracle Education and NETg to offer step-by-step instruction and hands-on practice in key topic areas. The Complete Oracle8 Certified Database Administrator Curriculum consists of the following courses: Oracle SQL: Basic SELECT  more...

Oracle8 Database Administration - Manage Storage Structures Course Overview This course is the third in a five-part series covering the database administration strategies and procedures provided in Oracle8. In this course, participants will learn the concepts associated with storage structure components. In addition, this course will teach users how to create and maintain rollback segments, temporary segments and indexes. L earn To:  more...

Oracle8 Performance Tuning Strategies and Techniques Course Overview This course is the first in a three-part Oracle8 Performance Tuning series. This course will introduce participants to tools and techniques used to improve the performance of the Oracle8 server. Participants will be introduced to files and events that support the tuning process. In addition, students will learn considerations for tuning applications. Finally, students will  more...

Oracle8 Performance Tuning Managing Memory and Disk I O Course Overview This course is the second in a three-part Oracle8 Performance Tuning series. This course introduces the learner to the application tuning issues that will impact database performance. In addition, participants will be introduced to tuning components and functions of the shared pool and the buffer cache. Students will learn how to monitor the contents and usage of the Redo Log  more...

Oracle8 Performance Tuning Optimizing Sorts and Minimizing Contention Course Overview This course is the third in a three-part Oracle8 Performance Tuning series. This course introduces the participants improving performance for sort operations. The student will be able to identify the SQL operations that require sorts, ensure that sorting is done in memory where possible, use direct writes for large sorts and allocate temporary space appropriately. The student  more...

Oracle e-Business 11i System Admin Fundamentals 2 This is the second course of five that teaches 11i System Administrators the concepts and fundamentals of their role. The first unit covers the definition and management of Concurrent Managers. The second unit covers managing profile options and creating and incorporating custom programs. The final unit covers user auditing and resource monitoring. Learn To: Identify key features of  more...

Oracle8i Database Admin Create Databases Course Overview This course is the second in a five-part series covering the database administration strategies and procedures provided in Oracle8i. In this course, participants will learn about the concepts associated with storage structure components, managing rollback segments, temporary segments, and indexes. In addition, creating and maintaining databases will be covered. L earn To:  more...

Oracle 11i e-Business Suite Essentials for Implementers Part 1 This course provides an overview of the 11i e-Business Suite architecture, shared entities and basic integration, and Multi-Org for functional implementers. It also covers the fundamentals of system administration. The e-Business Essentials for Implementers course provides a foundation for any e-Business Suite Fundamentals course, and is a prerequisite for any functional implementer new to Oracle  more...

Oracle8i Database Admin Manage Storage Structures Course Overview This course is the third in a five-part series covering the database administration strategies and procedures provided in Oracle8i. In this course, participants will learn the concepts associated with storage structure components. In addition, this course will teach users how to create and maintain rollback segments, temporary segments and indexes. L earn To: Identify  more...

Oracle8i Database Admin Manage Data Storage Course Overview This course is the fourth in a five-part series covering the database administration strategies and procedures provided in Oracle8i. In this course, participants will learn about the concepts associated with tables. In addition, this course will teach users about maintaining data integrity, clusters and index-organized tables, and methods for loading and reorganizing data. L  more...

Oracle8i Database Admin Manage Security Course Overview This course is the last in a five-part series covering the database administration strategies and procedures provided in Oracle8i. In this course, participants will learn about the concepts and tasks associated with managing security. L earn To: Define and maintain the security domains for users in a given environment. Define and maintain a named set of resources and  more...

Oracle8i Performance Tuning Architecture Strategy Course Overview This course is the first in a three-part Oracle8i Performance Tuning series. This interactive course will introduce participants to tools and techniques used to improve the performance of the Oracle8i server. Participants will be introduced to files and events that support the tuning process. In addition, students will learn considerations for tuning applications. Finally,  more...

Oracle8i Performance Tuning Managing Memory Disk I O Course Overview This course is the second in a three-part Oracle8i Performance Tuning series. This course introduces the learner to the application tuning issues that will impact database performance. In addition, participants will be introduced to tuning components and functions of the shared pool and the buffer cache. Students will learn how to monitor the contents and usage of the Redo Log  more...

Oracle8i Performance Tuning Optimizing Sorts Minimizing Contention Course Overview This course is the third in a three-part Oracle8i Performance Tuning series. This interactive course introduces the participants improving performance for sort operations. The student will be able to identify the SQL operations that require sorts, ensure that sorting is done in memory where possible, use direct writes for large sorts and allocate temporary space appropriately.  more...

Oracle8i Backup and Recovery Strategies Backups Course Overview This is the first course in a two-part series that covers the critical skills in planning and implementing database backup and recovery strategies. This course introduces the learners to the backup and recovery goals and functions of the various structures and processes in the Oracle architecture. In addition, participants learn to manage archive processing and maintain a  more...

Oracle8i Backup and Recovery Troubleshooting Recovery Course Overview Oracle's computer-based training course Oracle8i Backup and Recovery: Troubleshooting and Recovery is the second course in a two part series that introduces participants to the critical task of planning and implementing database recovery strategies. This course will identify ways of handling different types of failures, diagnosing errors and detecting corruption. Additionally,  more...

Oracle8i Network Administration Curriculum The Oracle 8i Network Administration Curriculum includes the following courses: Oracle 8i Network Administration: Net8 Architecture & Strategy Oracle 8i Network Administration: Net8 Additional Config. & Troubleshooting To review individual course descriptions, please return to the previous page and select the desired title(s).  more...

Oracle8i Network Administration Net8 Architecture Strategy Course Overview This is the first in a two-part series based on Oracle8i Network Administration. This series introduces participants to the trends and problems associated with business networking and presents the various solutions required to address these problems. This series explains in detail the architecture of Net8 and describes the steps in which connections are established between  more...

Oracle8i Network Administration Net8 Additional Config Troubleshooting Course Overview This is the second in a two-part series based on Oracle8i Network Administration. This series introduces participants to the trends and problems associated with business networking and presents the various solutions required to address these problems. This series explains in detail the architecture of Net8 and describes the steps in which connections are established between  more...

OCDBA8i Curriculum The Complete OCDBA8i Curriculum includes the following courses: Oracle SQL: Basic SELECT Statements (ID#378) Oracle SQL: Data Retrieval Techniques (ID#379) Oracle SQL: DML & DDL (ID#380) Oracle SQL: PL/SQL: Basics(ID#322) Oracle 8i Backup and Recovery: Strategies & Backups(ID#7486) Oracle 8i Backup and Recovery: Troubleshooting & Recovery(ID#7487) Oracle 8i Database Admin.: Manage an  more...

Oracle 11i 2 6 Implement Workflow Fundamentals Part 4 The course deals with fundamentals of Oracle Workflow 2.6, which is provided by Oracle E-Business Suite for Oracle Application 11i. Oracle Workflow enables you to create, modify and automate business processes. In part 4, you will learn about workflow configuration, Workflow Manager, and utilities. Learn To: Identify necessary setup steps for Oracle Workflow. Identify issues  more...

Oracle Database 10g Administration Workshop II Curriculum The Oracle Database 10g: Administration Workshop II Curriculum includes the following courses: Oracle Database 10g: Administration Workshop II(Part 1) Oracle Database 10g: Administration Workshop II (Part 2) Oracle Database 10g: Administration Workshop II (Part 3) Oracle Database 10g: Administration Workshop II (Part 4) To review individual course descriptions, please return to  more...

Oracle Database 10g Administration Workshop II Part 1 This course will teach learners to configure an Oracle database for multilingual applications and distributed database access. Students will also practice various methods of recovering the database, using RMAN, SQL, and Flashback technology. Learn To: Match goals of Oracle Database 10g manageability features with the methods of achieving them. Identify features of the Oracle  more...

Oracle Database 10g New Features for Administrators Part 1 Oracle Database 10g is the first database designed for enterprise grid computing. It is the most flexible and cost-effective way to manage enterprise information. This course covers the new features of Oracle Database 10g that are applicable to database administration. The features include Manageability concepts, Grid computing, enhanced installation features, configuration and performance  more...

Oracle Database 10g New Features for Administrators Part 2 Oracle Database 10g is the first database designed for enterprise grid computing. It is the most flexible and cost-effective way to manage enterprise information. This course covers new features of Oracle Database 10g such as automatic management, manageability infrastructure, and application tuning and monitoring. Learn To: Identify features of Automatic Database Diagnostic Monitor  more...

Oracle Database 10g Administration Workshop I Curriculum The Oracle Database 10g: Administration Workshop I Curriculum includes the following courses: Oracle Database 10g: Administration Workshop I (Part 1) Oracle Database 10g: Administration Workshop I (Part 2) Oracle Database 10g: Administration Workshop I (Part 3) Oracle Database 10g: Administration Workshop I (Part 4) To review individual course descriptions, please return to the  more...

Oracle Database 10g Administration Workshop I Part 1 Learners will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Learners will be taught to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques. Learn To:  more...

Oracle e-Business 11i System Administration Curriculum The Oracle e-Business 11i System Administration Curriculum includes the following courses: Oracle e-Business 11i System Admin.: Fundamentals 1 Oracle e-Business 11i System Admin.: Fundamentals 2 Oracle e-Business 11i System Admin.: Fundamentals 3 Oracle e-Business 11i System Admin.: Fundamentals 4 Oracle e-Business 11i System Admin.: Fundamentals 5 To review individual course  more...

Oracle e-Business 11i System Admin Fundamentals 1 This is the first course of five that teaches 11i System Administrators the concepts and fundamentals of their role. The basics of managing application security are covered in the first unit: creating users, customizing responsibilities, and managing menus and forms. The second unit of the course covers the management of requests, request groups, and request sets. Learn To: Identify  more...

Oracle9i Database Admin Manage an Instance Course Overview The Oracle9i Database Administration: Manage An Instance course is the first in a five-part series covering the database administration strategies and procedures provided in Oracle9i. This course introduces the participants to the concepts and procedures associated with Oracle architectural components. The participants learn the various tasks of a database administrator that are  more...

Oracle9i Database Admin Create a Database Course Overview The Oracle9i Database Administration: Create a Database course is the second in a five-part series covering the database administration strategies and procedures provided in Oracle9i. Participants learn about the concepts associated with storage structure components, management of rollback segments, temporary segments, and indexes. In addition, this course discusses how to  more...

Oracle9i Database Admin Manage Storage Structures Course Overview The 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  more...

Oracle9i Database Admin Manage Data Storage Course Overview This course is the fourth in the series covering the database administration strategies and procedures provided in Oracle9. This course covers the concepts associated with tables, maintaining data integrity, clusters and index-organized tables, and methods for loading and reorganizing data. Learn To • Identify the row storage method used by the various tables and the  more...

Oracle9i Database Admin Manage Security Course Overview This course is the last in a five-part series covering the database administration strategies and procedures provided in Oracle9i. In this course you will learn the concepts and methods associated with implementing security and resource consumption in an Oracle9i database. Learn To • Define and maintain the five components of the security domain of a user in a given  more...

Oracle9i Database Admin Perform Database Backups Course Overview This course introduces students to backup methods for Oracle9i database administration. The backup concepts covered by this course include backup strategies and requirements, Oracle Architecture, archiving data, backup methods, and working with a standby database. Students perform backup procedures using operating system utilities, Oracle9i utilities such as RMAN, standard  more...

Oracle9i Database Admin Set Up Oracle Net Services Course Overview This course covers the architecture and configuration of Oracle Net Services. It details client-server and web implementations, in addition to additional features such as Dynamic Service Registration and the use of the Oracle Names Server as an LDAP Proxy. This course also discusses the configuration of the Oracle Shared Server and Oracle Names Server. Learn To •  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 e-Business 11i System Admin Fundamentals 3 This is the third course of five that teaches 11i System Administrators the concepts and fundamentals of their role. This course focuses on the management of printers and various DBA miscellaneous duties such as application-related duties, incorporating custom Help files, and managing folders and document sequences. Learn To: Identify fundamental features of printers in an Oracle  more...

Oracle e-Business 11i System Admin Fundamentals 4 This is the fourth course of five that teaches 11i System Administrators the concepts and fundamentals of their role. It concentrates on Flexfields. The first unit covers the basics of Flexfields and defining value sets. Key Flexfield definition and management is covered in units two and three. The fourth unit covers defining Descriptive Flexfields. The course closes with coverage of advanced  more...

Oracle8 Database Administration - Manage Data Course Overview This course is the fourth in a five-part series covering the database administration strategies and procedures provided in Oracle8. In this course, participants will learn about the concepts associated with tables. In addition, this course will teach users about maintaining data integrity, clusters and index-organized tables, and methods for loading and reorganizing data. L  more...

Oracle8 Database Administration - Manage Security Course Overview This course is the last in a five-part series covering the database administration strategies and procedures provided in Oracle8. In this course, participants will learn about the concepts and tasks associated with managing security. L earn To: Define and maintain the security domains for users in a given environment. Define and maintain a named set of  more...

Oracle8 Backup and Recovery - Strategies and Backups Course Overview This is the first course in a two-part series that will introduce participants to the critical task of planning and implementing database backup strategies. In this course, users will be introduced to backup concepts and the Oracle architecture. They will learn how to change the archive mode of a database and configure a database for archive processing. Additionally, users will  more...

Oracle8 Backup and Recovery - Troubleshooting and Recovery Course Overview This course is the second course in a two-part series that introduces participants to the critical task of planning and implementing database recovery strategies. This course will identify ways of handling different types of failures, diagnosing errors and detecting corruption. Additionally, users will be introduced to the different types of Oracle recovery methods and how to  more...

Oracle8 Network Administration Net8 Architecture Configuration Course Overview This is the first course in a two-part series based on Oracle8 Network Administration. This course introduces participants to the trends and problems associated with business networking and presents the various solutions required to address these problems. This series explains in detail the architecture of Net8 and describes the steps in which connections are established between  more...

Oracle8 Network Administration Curriculum The Oracle8 Network Administration Curriculum consists of the following courses: Oracle8 Network Administration: Net8 Architecture and Configuration Oracle8 Network Administration: Net8 Configuration and Troubleshooting To review individual course descriptions, please return to the previous page and select the desired title(s).  more...

Oracle8 Network Administration Net8 Configuration and Troubleshooting Course Overview This is the second course in a two-part series based on Oracle8 Network Administration. This course introduces participants to the trends and problems associated with business networking and presents the various solutions required to address these problems. This series explains in detail the architecture of Net8 and describes the steps in which connections are established  more...

Oracle e-Business 11i System Admin Fundamentals 5 This is the fifth course of five that teaches 11i System Administrators the concepts and fundamentals of their role. Its area of coverage is Workflow. The first unit covers the key components of Oracle workflow. The second unit covers the management of Workflow processes and notifications. The third unit covers guidelines for using Workflow Manager and Oracle Alert. Learn To:  more...

Oracle8i Database Administration Curriculum The Oracle 8i Database Administration Curriculum includes the following courses: Oracle 8i Database Admin.: Manage an Instance Oracle 8i Database Admin.: Create Databases Oracle 8i Database Admin.: Manage Storage Structures Oracle 8i Database Admin.: Manage Data Storage Oracle 8i Database Admin.: Manage Security To review individual course descriptions, please return to the previous page  more...

Oracle8i Database Admin Manage an Instance Course Overview This course is the first in a five-part series covering the database administration strategies and procedures provided in Oracle8i. In this course, participants will learn about the concepts and procedures associated with Oracle architectural components, using the database administration tools, managing an Oracle instance, and using National Language Support. L earn To:  more...

Oracle Application Server 10g Administraton Curriculum The Oracle Application Server 10g Administration Curriculum includes the following courses: Oracle Application Server 10g Administration: Part 1 Oracle Application Server 10g Administration: Part 2 Oracle Application Server 10g Administration: Part 3 Oracle Application Server 10g Administration: Part 4 To review individual course descriptions, please return to the previous page  more...

Oracle Application Server 10g Administration Part 1 Oracle Application Server 10g is an integrated, standards-based software platform that allows organizations of all sizes to be more responsive to changing business requirements. It provides all the middleware services you need to deploy and manage applications and Web services, deliver personalized applications through enterprise portals and mobile devices, provide real-time business intelligence,  more...

Oracle Application Server 10g Administration Part 2 Oracle Application Server 10g is an integrated, standards-based software platform that allows organizations of all sizes to be more responsive to changing business requirements. This course covers managing application server, Oracle iHat tool, Lightweight Directory Access Protocol (LDAP), Oracle Internet Directory (OID), Oracle HTTP server, and Oracle Web Cache. The course encourages  more...

Oracle Application Server 10g Administration Part 3 Oracle Application Server 10g is an integrated, standards-based software platform that allows organizations of all sizes to be more responsive to changing business requirements. This course covers managing, configuring OC4J applications, maintaining OC4J Application pages, OracleAS Portal, managing portal users and groups, exporting and importing portal objects, and Oracle portal advanced  more...

Oracle Application Server 10g Administration Part 4 Oracle 10g Application Server is an integrated, standards-based software platform that allows organizations of all sizes to be more responsive to changing business requirements. This course covers J2EE Applications, Oracle Internet Directory, Delegated Administration Service, Single Sign-On, and Secure Sockets Layer. Learn To: Sequence the steps to deploy Web application modules.  more...

Oracle Application Server 10g Administration II Curriculum The Oracle Application Server 10g: Administration II Curriculum includes the following courses: Oracle Application Server 10g: Administration II (Part 1) Oracle Application Server 10g: Administration II (Part 2) Oracle Application Server 10g: Administration II (Part 3) Oracle Application Server 10g: Administration II (Part 4) To review individual course descriptions, please return  more...

Oracle Application Server 10g Administration II Part 1 This course describes the advanced administration concepts. In addition, you are introduced to common deployment topologies of Oracle Application Server 10g to enable choosing the appropriate topology according to your business needs. To provide a stable and highly available environment that performs well, you learn the concepts for high availability (HA) and scalability. You also learn to  more...

Oracle Application Server 10g Administration II Part 2 This course introduces learners to Web Cache clusters and OracleAS Clusters. The participants learn to configure these clusters and manage them in OracleAS 10g. The participants also learn to configure J2EE clustering, OC4J, and manage OracleAS in a CFC environment. Learn To: Identify features of Oracle Application Server (OracleAS) 10g Web Cache clusters. Identify benefits of  more...

Oracle Application Server 10g Administration II Part 3 This course introduces the various Business Intelligence components such as Discoverer, Reports, Forms, and XML applications. The users learn about configuring and managing OracleAS Discoverer, OracleAS Reports Services, OracleAS Forms, and XML applications. They also learn how to deploy and manage OracleAS Web Services. Learn To: Match the components of Oracle Application Server  more...

Oracle Application Server 10g Administration II Part 4 This course covers how to monitor the OracleAS components and processes. It also covers tuning the various components of the OracleAS, as well as backup and recovery of OracleAS. Finally, it provides guidance on reconfiguring the OracleAS middle-tier components. Learn To: Identify features of Oracle Diagnostic Logging (ODL). Identify options for configuring component logging.  more...

Certification in Oracle Applications Technologies Hello, Greetings from iWare Logic !!! We are Oracle Approved Education Center which provide Trainings & Certifications in Oracle Applications in 11i & R12 Codes Exams IZ0-007 Introduction to 9i- SQL IZ0-147 Oracle 9i Program with PL/ SQL IZ0-031 Oracle 9i- Database Fundamentals -I IZ0-032 Oracle 9i- Database Fundamentals -II IZ0-033 Oracle 9i Database- Performance Tuning  more...