Online Oracle 9i eLearning

Oracle 11i Project Management and Projects Integration Oracle 11i: Project Management and Projects Integration Oracle To recognize the Oracle Enterprise Project Management Solution products, the integration of Oracle Project with other Oracle e-business applications, and how to define an Oracle Applications set of books  more...

Oracle 11i Organization Period and Calendar Definitions in Oracle Projects Oracle 11i: Organization, Period, and Calendar Definitions in Oracle Projects Oracle To recognize how Oracle Projects' multiple organization architecture, periods, and calendars are used for structuring and scheduling, and to implement them in an enterprise  more...

Oracle 11i Resource and Role Management Oracle 11i: Resource and Role Management Oracle To recognize the resources and roles in Oracle Projects, how they are used in project management, and to create and assign them  more...

Oracle 11i Oracle Projects Security Model and Page Layouts Oracle 11i: Oracle Projects Security Model and Page Layouts Oracle To use Oracle Projects to secure function and data access within Projects applications, and use page layouts to manipulate views of project information  more...

Oracle 11i Oracle Projects and Task Definition I Oracle 11i: Oracle Projects and Task Definition I Oracle To define project setup options and project types to manage project structuring, resources, and workflow  more...

Oracle 11i Oracle Projects and Task Definition II Oracle 11i: Oracle Projects and Task Definition II Oracle To recognize how projects are organized, and create and administer them  more...

Oracle 11i User-Defined Attributes Implementation Options and Utilization Oracle 11i: User-Defined Attributes, Implementation Options, and Utilization Oracle To use Oracle Project's user-defined attributes, group implementation options, and utilization reports to capture information, interface with other Oracle applications, and report actual and scheduled utilization and resources  more...

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 Introduction Oracle Application Server 10g: Introduction Oracle To provide an introduction to OracleAS architecture, components, and installation options  more...

Oracle Application Server 10g Infrastructure and Middle Tier Installation Oracle Application Server 10g: Infrastructure and Middle Tier Installation Oracle To demonstrate how to prepare for, execute, and verify OracleAS Infrastructure and Middle Tier installation  more...

Oracle Application Server 10g Management Tools and Oracle Internet Directory Oracle Application Server 10g: Management Tools and Oracle Internet Directory Oracle To demonstrate how to use OracleAS management tools and manage the Oracle Internet Directory (OID)  more...

Oracle Application Server 10g General Management and Directives for the HTTP Se Oracle Application Server 10g: General Management and Directives for the HTTP Se Oracle To demonstrate how to perform general management of Oracle HTTP Server (OHS)  more...

Oracle Application Server 10g OracleAS Web Cache Oracle Application Server 10g: OracleAS Web Cache Oracle To demonstrate how to administer and configure OracleAS Web Cache  more...

Oracle Application Server 10g OracleAS Portal Oracle Application Server 10g: OracleAS Portal Oracle To demonstrate how to manage OracleAS Portal  more...

Oracle Application Server 10g mod_pl sql CGI Scripts and Database Providers Oracle Application Server 10g: mod_pl sql, CGI Scripts, and Database Providers Oracle To demonstrate how to configure mod_plsql, CGI-script execution, and database providers in OracleAS  more...

Oracle Application Server 10g Application Management and Deployment Oracle Application Server 10g: Application Management and Deployment Oracle To demonstrate how to manage and deploy applications in OracleAS  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 Application Server 10g Component Security with SSL Oracle Application Server 10g: Component Security with SSL Oracle To demonstrate how to manage wallets and certificates and configure components for SSL in OracleAS  more...

Oracle Application Server 10g Oracle Certificate Authority Management Oracle Application Server 10g: Oracle Certificate Authority Management Oracle To demonstrate how to manage Oracle Certificate Authority (OCA)  more...

Oracle Database 11g PL SQL Variables Attributes and Executable Statements Oracle Database 11g: PL/SQL Variables, Attributes, and Executable Statements Oracle To identify the steps for getting started with PL/SQL, recognizing the benefits of the available tools, creating basic statements, declaring variables, testing code, and adhering to scoping and nesting rules.  more...

Oracle Database 11g Using DML DDL Cursors Control Structures and Loops Oracle Database 11g: Using DML, DDL, Cursors, Control Structures, and Loops Oracle To identify the steps for using PL/SQL to manipulate data, control transactions, determine the outcome of statements, and create loops and conditional control structures.  more...

Oracle Database 11g Using Data Types INDEX BY Tables and Cursors in PL SQL Oracle Database 11g: Using Data Types, INDEX BY Tables, and Cursors in PL/SQL Oracle To recognize ways to create user-defined PL/SQL records and INDEX BY tables, and identify the steps for declaring and controlling explicit cursors and cursors with parameters.  more...

Oracle Database 11g Controlling User Access and Managing Schema Objects Oracle Database 11g: Controlling User Access and Managing Schema Objects Oracle To recognize the steps for controlling user access to objects and also for maintaining these objects by dropping columns and adding constraints and indexes.  more...

Oracle Database 11g Data Dictionary Views and Large Data Sets Oracle Database 11g: Data Dictionary Views and Large Data Sets Oracle To recognize the steps for querying data dictionary views to viewsschema objects, and for performing operations on large amounts of data, such as inserting data into multiple tables and merging table rows.  more...

Oracle Database 11g Managing Data in Different Time Zones Oracle Database 11g: Managing Data in Different Time Zones Oracle To identify the steps for managing data in different time zones in Oracle Database 11g, for managing time intervals, and for using datetime functions.  more...

Oracle Database 10g New Installation and Configuration Features Oracle Database 10g: New Installation and Configuration Features Oracle To discuss the new installation and configuration features of Oracle 10g  more...

Oracle Database 10g New Data Loading Features Oracle Database 10g: New Data Loading Features Oracle To discuss new data loading features in Oracle 10g  more...

Oracle Database 10g New Automatic Management and Management Infrastructure Feat Oracle Database 10g: New Automatic Management and Management Infrastructure Feat Oracle To identify the new automatic management and management infrastructure features of Oracle 10g  more...

Oracle Database 10g New Resource Scheduling and Task-Management Features Oracle Database 10g: New Resource, Scheduling, and Task-Management Features Oracle To identify the new resource, scheduling, and task-management features of Oracle 10g  more...

Oracle Database 10g New Space Management Features Oracle Database 10g: New Space Management Features Oracle To identify the new space management features of Oracle 10g  more...

Oracle Database 10g New Storage Features Oracle Database 10g: New Storage Features Oracle To identify the new storage features of Oracle Database 10g  more...

Oracle Database 10g New Tuning Performance-monitoring and Analysis Features Oracle Database 10g: New Tuning, Performance-monitoring, and Analysis Features Oracle To use Oracle 10g's new tuning, performance-monitoring, and analysis features  more...

Oracle Database 10g New Backup and Recovery Features Oracle Database 10g: New Backup and Recovery Features Oracle To use Oracle 10g's new backup and recovery features  more...

Oracle Database 10g Using Flashback Oracle Database 10g: Using Flashback Oracle To recognize Oracle 10g's Flashback technology and use Flashback features  more...

Oracle Database 10g New Features in Security and Software Maintenance Oracle Database 10g: New Features in Security and Software Maintenance Oracle To use the new security and software upgrade features in Oracle 10g  more...

Oracle Database 10g New Features in VLDB Support Oracle Database 10g: New Features in VLDB Support Oracle To use Oracle 10g's new VLDB support features  more...

Oracle Database 10g Miscellaneous New Features Oracle Database 10g: Miscellaneous New Features Oracle To recognize how various new features are used in Oracle 10g  more...

Introduction to Oracle and SQL in Oracle Database 10g Introduction to Oracle and SQL in Oracle Database 10g Oracle To introduce Oracle as a relational database management system (RDBMS) and to demonstrate how to use basic SQL statements  more...

SQL Functions in Oracle Database 10g SQL Functions in Oracle Database 10g Oracle To describe how to use SQL functions for data retrieval  more...

Displaying Multiple Table Data and Using Set Operators in Oracle Database 10g Displaying Multiple Table Data and Using Set Operators in Oracle Database 10g Oracle To demonstrate how to retrieve data from multiple tables using joins and how to use set operators in Oracle 10g databases  more...

Group and Datetime Functions in Oracle Database 10g Group and Datetime Functions in Oracle Database 10g Oracle To demonstrate how to use group and datetime functions in Oracle 10g  more...

Subqueries and Hierarchical Queries in Oracle Database 10g Subqueries and Hierarchical Queries in Oracle Database 10g Oracle To demonstrate how to use subqueries and hierarchical queries in Oracle 10g  more...

Regular Expressions and User Access in Oracle Database 10g Regular Expressions and User Access in Oracle Database 10g Oracle To demonstrate how to use regular expression support and control user access in Oracle 10g  more...

Creating and Managing Tables and Constraints in Oracle Database 10g Creating and Managing Tables and Constraints in Oracle Database 10g Oracle To demonstrate how to create and manage tables and constraints in Oracle 10g  more...

Database Objects in Oracle Database 10g Database Objects in Oracle Database 10g Oracle To demonstrate how to create database views, sequences, indexes, and synonyms  more...

Managing Database Objects in Oracle Database 10g Managing Database Objects in Oracle Database 10g Oracle To demonstrate how to create external tables and to use the data dictionary views in Oracle 10g  more...

Manipulating Data in Oracle Database 10g Manipulating Data in Oracle Database 10g Oracle To demonstrate how to modify rows, control database transactions, and manage large data sets and multitable statements  more...

Introduction to PL SQL Introduction to PL/SQL Oracle To introduce PL/SQL and provide an introduction to identifiers and variables in PL/SQL  more...

Using PL SQL with an Oracle Server Using PL/SQL with an Oracle Server Oracle To write lexical units in their correct format in a PL/SQL block, perform data conversion in PL/SQL, write PL/SQL anonymous blocks, and recognize the correct structure of a PL/SQL program block  more...

Using Control Structures Using Control Structures Oracle To implement a suitable conditional control statement in PL/SQL, simple and searched CASE expressions, and a suitable loop construct  more...

Using Composite Data Types Using Composite Data Types Oracle To identify the benefits associated with records and collections, declare and initialize nested tables and VARRAYs, and create and reference an INDEX BY table and table of records  more...

Explicit Cursors and Exception Errors Explicit Cursors and Exception Errors Oracle To use the FOR UPDATE and WHERE CURRENT OF clauses to lock and modify rows, process data using records and cursors, and outline how each of the PL/SQL exception types are raised and handled  more...

Creating Stored Procedures and Functions Creating Stored Procedures and Functions Oracle To create and execute a stored function and call, and remove and view stored functions in PL/SQL  more...

PL SQL Packages PL/SQL Packages Oracle To create and work with Oracle 10g packages  more...

Oracle-Supplied Packages and DBMS_SCHEDULER Oracle-Supplied Packages and DBMS_SCHEDULER Oracle To use Oracle-supplied packages  more...

Managing Dependencies Managing Dependencies Oracle To manage dependencies and recompile PL/SQL units  more...

Manipulating Large Objects in PL SQL Manipulating Large Objects in PL/SQL Oracle To use LOBs and the DBMS_LOB package  more...

PL SQL Triggers PL/SQL Triggers Oracle To create and manage triggers  more...

Dynamic SQL and Metadata Dynamic SQL and Metadata Oracle To write dynamic SQL and use the DBMS_METADATA package  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 Database 11g Getting Started with SQL and PL SQL New Features Oracle Database 11g: Getting Started with SQL and PL/SQL New Features Oracle To recognize the scope and capabilities of enhancements to SQL and PL/SQL, including tools such as SQL*Plus and SQL Developer, and use them to create reports and scripts, browse and manage database objects, find subpatterns, and track dependencies  more...

Oracle Database 11g Using Dynamic SQL and Implementing Performance Improvements Oracle Database 11g: Using Dynamic SQL and Implementing Performance Improvements Oracle To recognize the steps for improving SQL and PL/SQL flexibility, usability, and performance, using dynamic SQL, language enhancements, and a variety of performance enhancements  more...

Oracle Database 11g Using Trigger Data Warehousing and Pivoting Enhancements Oracle Database 11g: Using Trigger, Data Warehousing, and Pivoting Enhancements Oracle To recognize the steps for improving performance, managing scalabilty, enhancing control and processing speed, and reducing network load using enhanced features such as compound triggers, SecureFile LOBs, and PIVOT operations  more...

Oracle Database 11g Using the PL SQL Debugger Collections and Data Warehousin Oracle Database 11g: Using the PL/SQL Debugger, Collections, and Data Warehousin Oracle To recognize ways to utilize the PL/SQL Debugger to analyze your code, identify the uses and benefits of collections, and identify the steps for employing data warehousing enhancements to improve query execution times.  more...

Oracle Database 11g Using SQL to Query Your Database Oracle Database 11g: Using SQL to Query Your Database Oracle To identify the concepts and components of an Oracle Database 11g database, recognize how to retrieve information from it using SQL, and identify the steps for sorting, limiting, modifying, and formatting this information.  more...

Oracle Database 11g Conversion Functions Group Functions and Joins Oracle Database 11g: Conversion Functions, Group Functions, and Joins Oracle To recognize the steps for writing queries that convert data from one type to another, specify conditions, perform calculations on groups of rows or even tables, and return values from more than one table.  more...

Oracle Database 11g Subqueries Set Operators and Data Manipulation Oracle Database 11g: Subqueries, Set Operators, and Data Manipulation Oracle To identify the steps for manipulating queries to return the data you need, using subqueries and set operators, and also for manipulating the actual data using INSERT, UPDATE, DELETE and other data manipulation language (DML) statements.  more...

Oracle Database 11g Using DDL Views Sequences Indexes and Synonyms Oracle Database 11g: Using DDL, Views, Sequences, Indexes, and Synonyms Oracle To recognize the steps for creating, defining, and dropping tables , manipulating how their data can be viewed, and using schema objects to generate integers, improve queries, and rename tables.  more...

Oracle 11i E-Business Suite Introduction Oracle 11i E-Business Suite: Introduction Oracle To identify the main features of 11i E-Business Suite, to perform key navigation tasks, to create a shared entity type, and to recognize the key business flows of 11i E-Business Suite  more...

Oracle 11i E-Business Suite Multi-Org Oracle 11i E-Business Suite: Multi-Org Oracle To identify characteristics and key features of Multi-Org and to identify the considerations to make when implementing Multi-Org  more...

Oracle 11i E-Business Suite Flexfields Oracle 11i E-Business Suite: Flexfields Oracle To create value sets and to perform the tasks to define a structure for descriptive flexfields  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 E-Business Suite Workflow Alerts and Daily Business Intelligence Oracle 11i E-Business Suite: Workflow, Alerts, and Daily Business Intelligence Oracle To identify the key features of the Oracle Workflow architecture, to create alerts in 11i E-Business Suite, to recognize the benefits and characteristics of Daily Business Intelligence (DBI) and, given a scenario, run a report in a DBI environment  more...

Oracle 11i Function Security and Data Security Oracle 11i: Function Security and Data Security Oracle To create users and responsibilities, assign responsibilities, create data groups, create functions and menus, and perform key data-security tasks  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 11i Profile Options DBA Duties and Printer Management Oracle 11i: Profile Options, DBA Duties, and Printer Management Oracle To set and view profile options, perform some Application-DBA tasks, define printers, and print with the pasta.cfg file  more...

Oracle 11i Personalization of Forms and OA Framework Pages Oracle 11i: Personalization of Forms and OA Framework Pages Oracle To personalize forms and Oracle Applications (OA) framework pages  more...

Oracle 11i Oracle Workflow Oracle 11i: Oracle Workflow Oracle To identify the components of Oracle Workflow and to recognize the mandatory the optional steps for configuring Oracle Workflow  more...

Oracle 11i System Monitoring and Troubleshooting in OAM Oracle 11i: System Monitoring and Troubleshooting in OAM Oracle To monitor and manage some of the system components of Oracle E-Business Suite, run some troubleshooting wizards, and use the Support Cart feature in Oracle Applications Manager (OAM)  more...

Oracle 11i Using the Navigator Forms and Online Help Oracle 11i: Using the Navigator, Forms, and Online Help Oracle To define responsibilities and recognize Navigator functionality, enter and work with data using forms, and search for information with Oracle Applications online help  more...

Oracle 11i Concurrent Processing Requests Profiles and Forms Oracle 11i: Concurrent Processing, Requests, Profiles, and Forms Oracle To execute application tasks simultaneously by running concurrent requests and request sets, customize the presentation of data, and manage personal user profiles, form attachments, and form flexfields  more...

OracleAS 10g Managing Customized Topologies and Distributing Infrastructure Com OracleAS 10g: Managing Customized Topologies and Distributing Infrastructure Com Oracle To discuss common deployment topologies and to explain how to install and configure Oracle Application Server components to suit different needs  more...

OracleAS 10g High Availability OracleAS 10g: High Availability Oracle To explain high availability and its importance from the perspective of application servers and discuss the high availability features in Oracle Application Server at the OC4J level  more...

OracleAS 10g Managing and Configuring Clusters OracleAS 10g: Managing and Configuring Clusters Oracle To explain how to manage and configure clusters in OracleAS 10g  more...

OracleAS 10g Business Intelligence Component Management OracleAS 10g: Business Intelligence Component Management Oracle To examine Business Intelligence components such as Oracle AS Discoverer and OracleAS Reports and to describe how to deploy reports and forms applications to OracleAS  more...

OracleAS 10g XML Applications Web Services and Monitoring OracleAS 10g: XML Applications, Web Services, and Monitoring Oracle To describe how to deploy XML applications and web services with Oracle AS and to discuss the monitoring capabilities of Oracle Enterprise Manager Application Server Control  more...

OracleAS 10g Tuning and Reconfiguring the Middle Tier OracleAS 10g: Tuning and Reconfiguring the Middle Tier Oracle To describe how to optimize the performance of Oracle Application Server components and to explain how to perform reconfiguration tasks in the Oracle Application Server middle tier and infrastructure  more...

OracleAS 10g Backup and Recovery OracleAS 10g: Backup and Recovery Oracle To explain how to perform backup and recovery procedures in OracleAS  more...

ORACLE DATABASE 11G PL SQL FUNDAMENTALS ORACLE DATABASE 11G: PL/SQL FUNDAMENTALS Oracle  more...

ORACLE DATABASE 11G SQL FUNDAMENTALS II ORACLE DATABASE 11G: SQL FUNDAMENTALS II Oracle  more...

Oracle 11g DBA OCA Library Oracle 11g DBA OCA Library Oracle Oracle Database 11g Administrator Certified Associate Oracle Database Administrator 11g Certfied Associate Library  more...

ORACLE DATABASE 10g NEW FEATURES ORACLE DATABASE 10g: NEW FEATURES Oracle  more...

ORACLE DATABASE 10g SQL FUNDAMENTALS I II ORACLE DATABASE 10g: SQL FUNDAMENTALS I & II Oracle  more...

ORACLE DATABASE 10g PROGRAMMING WITH PL SQL I ORACLE DATABASE 10g: PROGRAMMING WITH PL/SQL I Oracle  more...

ORACLE DATABASE 10g DEVELOPING PL SQL PROGRAM UNITS ORACLE DATABASE 10g: DEVELOPING PL/SQL PROGRAM UNITS Oracle  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 DATABASE 11g SQL PL SQL NEW FEATURES ORACLE DATABASE 11g: SQL & PL/SQL NEW FEATURES Oracle  more...

ORACLE DATABASE 11g SQL FUNDAMENTALS I ORACLE DATABASE 11g: SQL FUNDAMENTALS I Oracle  more...

ORACLE 11i e-BUSINESS SUITE ESSENTIALS FOR IMPLEMENTERS ORACLE 11i e-BUSINESS SUITE: ESSENTIALS FOR IMPLEMENTERS Oracle  more...

ORACLE 11i e-BUSINESS SUITE SYSTEM ADMINSTRATOR FUNDAMENTALS ORACLE 11i e-BUSINESS SUITE: SYSTEM ADMINSTRATOR FUNDAMENTALS Oracle  more...

ORACLE 11i PROJECT FOUNDATION FUNDAMENTALS ORACLE 11i: PROJECT FOUNDATION FUNDAMENTALS Oracle  more...

ORACLE 11i NAVIGATE ORACLE APPLICATIONS ORACLE 11i: NAVIGATE ORACLE APPLICATIONS Oracle  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 SOA Suite 11g Introduction to SOA Oracle SOA Suite 11g: Introduction to SOA Oracle This course outlines the challenges faced by enterprises in integrating applications, and how Service-Oriented Architecture can provide a solution. The various drivers that enable you to build a reference architecture, which is the first step toward embarking into a Service-Oriented Architecture, will also be covered. This course also  more...

Oracle SOA Suite 11g SOA Governance Service Design Oracle SOA Suite 11g: SOA Governance & Service Design Oracle In this course, the need for governance in a Service-Oriented Architecture environment is highlighted, and the different characteristics related to service management are covered. You are also introduced to the concepts that enable defining and implementing a service. This is an important aspect of designing an SOA system as it  more...

Oracle SOA Suite 11g SOA Composite Applications Oracle SOA Suite 11g: SOA Composite Applications Oracle In this course, the need of governance in a Service-Oriented Architecture environment is highlighted. It also introduces the various service artifacts and service classification in a Service-Oriented Architecture environment.  more...

Oracle SOA Suite 11g Mediator BPEL Components Oracle SOA Suite 11g: Mediator & BPEL Components Oracle This course introduces you to the Mediator component and its routing functionality. You will also be introduced to process orchestration concepts and using the BPEL component.  more...

Oracle SOA Suite 11g Human Task Business Rules Components Oracle SOA Suite 11g: Human Task & Business Rules Components Oracle This course introduces the Human Workflow task component and its functionality. It also introduces you to Oracle Business Rules and its features.  more...

Oracle SOA Suite 11g SOA Security Adoption Planning Oracle SOA Suite 11g: SOA Security & Adoption Planning Oracle This course provides an introduction to the topic of securing services and composite applications. It also describe the activities involved in SOA adoption planning.  more...

ORACLE SOA SUITE 11G ESSENTIAL CONCEPTS ORACLE SOA SUITE 11G: ESSENTIAL CONCEPTS Oracle  more...

Oracle Database 11g Subprograms Packages Exception Handling in PL SQL Oracle Database 11g: Subprograms, Packages & Exception Handling in PL/SQL Oracle To identify the steps for designing, debugging, invoking, and bundling PL/SQL subprograms, procedures and functions, and also for handling their exceptions.  more...

Oracle Database 11g Packages Dynamic SQL Coding Considerations in PL SQL Oracle Database 11g: Packages, Dynamic SQL & Coding Considerations in PL/SQL Oracle To recognize the steps for creating and using efficient PL/SQL packages, including Oracle-supplied packages, executing dynamic SQL, and improving the performance of code.  more...

Oracle Database 11g Using Triggers the PL SQL Compiler Managing Code Oracle Database 11g: Using Triggers, the PL/SQL Compiler & Managing Code Oracle To identify the steps for creating, managing, and using database triggers, and for using the new PL/SQL compiler, its initialization parameters, and its compile time warnings.  more...

Oracle Database 11g Managing PL SQL Code Dependencies Oracle Database 11g: Managing PL/SQL Code & Dependencies Oracle To identify the steps for performing conditional compilation to selectively use PL/SQL code, wrapping code, and tracking dependencies.  more...

ORACLE DATABASE 11G DEVELOP PL SQL PROGRAM UNITS ORACLE DATABASE 11G: DEVELOP PL/SQL PROGRAM UNITS Oracle  more...

Oracle Database 11g Querying a Database with SQL Oracle Database 11g: Querying a Database with SQL Oracle Oracle Database 11g Administrator Certified Associate 1Z0-047 Oracle Database 11g SQL Expert To identify the concepts and components of an Oracle Database 11g database, recognize how to retrieve information from it using SQL, and identify the steps for sorting, limiting, modifying, and formatting this information.  more...

Oracle 11g Conversion Funct Conditional Expressions Group Funct Joins Oracle 11g: Conversion Funct., Conditional Expressions, Group Funct. & Joins Oracle Oracle Database 11g Administrator Certified Associate 1Z0-047 Oracle Database 11g SQL Expert To recognize the steps for writing queries that convert data from one type to another, specify conditions, perform calculations on groups of rows or even tables, and return values from more than one table.  more...

Oracle Database 11g Manipulating Queries Data Oracle Database 11g: Manipulating Queries & Data Oracle Oracle Database 11g Administrator Certified Associate 1Z0-047 Oracle Database 11g SQL Expert To identify the steps for manipulating queries to return the data you need, using subqueries and set operators, and also for manipulating the actual data using INSERT, UPDATE, DELETE and other data manipulation language (DML) statements.  more...

Oracle Database 11g Using DDL Views Schema Objects Oracle Database 11g: Using DDL, Views & Schema Objects Oracle Oracle Database 11g Administrator Certified Associate 1Z0-047 Oracle Database 11g SQL Expert To recognize the steps for creating, defining, and dropping tables , manipulating how their data can be viewed, and using schema objects to generate integers, improve queries, and rename tables.  more...

Oracle Database 11g Controlling User Access Managing Objects Oracle Database 11g: Controlling User Access & Managing Objects Oracle Oracle Database 11g Administrator Certified Associate 1Z0-047 Oracle Database 11g SQL Expert To recognize the steps for controlling user access to objects and also for maintaining these objects by dropping columns and adding constraints and indexes.  more...

Oracle Database 11g Managing Data Dictionary Views Large Data Sets Oracle Database 11g: Managing Data Dictionary Views & Large Data Sets Oracle Oracle Database 11g Administrator Certified Associate 1Z0-047 Oracle Database 11g SQL Expert To recognize the steps for querying data dictionary views to viewsschema objects, and for performing operations on large amounts of data, such as inserting data into multiple tables and merging table rows.  more...

Oracle Database 11g Managing Time Zones Datetime Functions Oracle Database 11g: Managing Time Zones & Datetime Functions Oracle Oracle Database 11g Administrator Certified Associate 1Z0-047 Oracle Database 11g SQL Expert To identify the steps for managing data in different time zones in Oracle Database 11g, for managing time intervals, and for using datetime functions.  more...

Oracle Database 11g Suqueries Regular Expressions Oracle Database 11g: Suqueries & Regular Expressions Oracle Oracle Database 11g Administrator Certified Associate 1Z0-047 Oracle Database 11g SQL Expert To recognize the steps for retrieving data using subqueries and using regular expressions to search for, match, and replace strings.  more...

1Z0-047 Oracle Database 11g SQL Expert 1Z0-047 Oracle Database 11g SQL Expert Oracle Oracle Database 11g Administrator Certified Associate 1Z0-047 Oracle Database 11g SQL Expert  more...

Oracle Database 11g Getting Started with PL SQL Oracle Database 11g: Getting Started with PL/SQL Oracle To identify the steps for getting started with PL/SQL, recognizing the benefits of the available tools, creating basic statements, declaring variables, testing code, and adhering to scoping and nesting rules.  more...

Oracle Database 11g Using DML DDL Cursors Loops Control Structures Oracle Database 11g: Using DML, DDL, Cursors, Loops & Control Structures Oracle To identify the steps for using PL/SQL to manipulate data, control transactions, determine the outcome of statements, and create loops and conditional control structures.  more...

Oracle Database 11g Using Data Types INDEX BY Tables Cursors Oracle Database 11g: Using Data Types, INDEX BY Tables & Cursors Oracle To recognize ways to create user-defined PL/SQL records and INDEX BY tables, and identify the steps for declaring and controlling explicit cursors and cursors with parameters.  more...

Oracle Database 11g Using Exceptions Subprograms JDeveloper REF Cursors Oracle Database 11g: Using Exceptions, Subprograms, JDeveloper & REF Cursors Oracle To recognize ways to handle unanticipated errors in PL/SQL, write stored procedures and functions, deploy Java applications and Web services, and use cursor variables.  more...

Oracle Database 11g Subprograms Packages Exception Handling Oracle Database 11g: Subprograms, Packages & Exception Handling Oracle To identify the steps for designing, debugging, invoking, and bundling PL/SQL subprograms, procedures and functions, and also for handling their exceptions.  more...

Oracle Database 11g Packages Dynamic SQL Coding Considerations Oracle Database 11g: Packages, Dynamic SQL & Coding Considerations Oracle To recognize the steps for creating and using efficient PL/SQL packages, including Oracle-supplied packages, executing dynamic SQL, and improving the performance of code.  more...

Oracle Database 11g Using Triggers the PL SQL Compiler Oracle Database 11g: Using Triggers & the PL/SQL Compiler Oracle To identify the steps for creating, managing, and using database triggers, and for using the new PL/SQL compiler, its initialization parameters, and its compile time warnings.  more...

Oracle Database 11g PL SQL Code Dependency Management Oracle Database 11g: PL/SQL Code & Dependency Management Oracle To identify the steps for performing conditional compilation to selectively use PL/SQL code, wrapping code, and tracking dependencies.  more...

ORACLE DATABASE 11G PROGRAM WITH PL SQL ORACLE DATABASE 11G: PROGRAM WITH PL/SQL Oracle  more...

Oracle Database 11g Performance Tuning Methodology Tools Oracle Database 11g: Performance Tuning Methodology & Tools Oracle Oracle Database 11g provides a variety of tools that can be used for performance tuning in an Oracle database environment. These tools can be used to diagnose and tune common SQL-related and instance-related problems as well as proactively tune an Oracle database. One such tool, Enterprise Manager, can be used to monitor an  more...

Oracle Database 11g Using AWR Defining Problems Oracle Database 11g: Using AWR & Defining Problems Oracle Automatic Workload Repository (AWR) is the infrastructure that provides services to Oracle Database 11g components that collect, maintain, and utilize statistics for problem detection and self-tuning purposes. This course explains how to create and manage AWR snapshots, and demonstrates how to use the snapshots to generate individual  more...

Oracle Database 11g Metrics Alerts Baselines AWR Tools Services Oracle Database 11g: Metrics, Alerts, Baselines, AWR Tools & Services Oracle Metrics, alerts, baselines, and thresholds are monitoring objects that can be used to monitor and manage the performance tuning of an Oracle Database 11g environment. Automatic Workload Repository (AWR) based tools can be used to tune automatic maintenance tasks and generate and read ADDM and ASH reports. This  more...

Oracle Database 11g Problem SQL Statements Oracle Optimizer Oracle Database 11g: Problem SQL Statements & Oracle Optimizer Oracle Oracle Database 11g helps to identify problem SQL statements using Oracle Optimizer and execution plans. This course discusses SQL statement processing and the role of the Oracle Optimizer and execution plans. It also explains how to generate and view execution plans using the DBMS_XPLAN package, the EXPLAIN PLAN command,  more...

Oracle Database 11g SQL Performance Database Replay Oracle Database 11g: SQL Performance & Database Replay Oracle Database Replay allows you to test the impact of a system change by replaying a real-world workload on a test system before it is exposed to a production system. This course demonstrates how to use Database Replay to capture and replay workloads to test the impact of a system change. It also explains how to use SQL Performance  more...

Oracle Database11g Shared Pool Buffer Cache Tuning Oracle Database11g: Shared Pool & Buffer Cache Tuning Oracle The buffer cache is an extremely important component for the performance, scalability, and reliability of the database. This course demonstrates how to identify the symptoms that indicate a buffer cache problem and how to use the various methods available to resolve common performance issues related to the buffer cache. It also  more...

Oracle Database 11g Tuning PGA Temporary Space AMM Oracle Database 11g: Tuning PGA, Temporary Space & AMM Oracle Oracle Database 11g provides various methods for tuning, monitoring and managing memory and temporary tablespaces. Automatic Program Global Area (PGA) memory management adapts the SQL memory allocation based on PGA memory available, SQL operator needs, and system workload. A temporary tablespace is used to store transient data  more...

Oracle Database 11g Segment Space I O and Performance Tuning Oracle Database 11g: Segment Space, I/O and Performance Tuning Oracle Oracle Database 11g provides various methods for tuning segment space usage and input/output (I/O). This course explains how to use Automatic Segment Space Management (ASSM) to tune segment space usage, how to shrink segments using SQL or the Enterprise Manager, and how to use table compression. Automatic Storage  more...

ORACLE DATABASE 11G PERFORMANCE TUNING ORACLE DATABASE 11G: PERFORMANCE TUNING Oracle  more...

Oracle Database 11g Architecture SQL Tuning Optimization Oracle Database 11g: Architecture, SQL Tuning & Optimization Oracle The Oracle Database server consists of an Oracle Database and one or more Oracle Database instances. SQL (Structured Query Language) is the language with which all programs and users access an Oracle Database. Monitoring the performance of and tuning database components, as well as the SQL statements used to access and  more...

Oracle Database 11g Indexes Access Paths and Join Operations Oracle Database 11g: Indexes, Access Paths and Join Operations Oracle Access paths are the ways in which data is retrieved from the database, and there are a number of different access paths which can be used for tables and indexes. This course explores the access paths used for tables, such as full table, rowid, and sample table scan. It also examines the access paths used for indexes, such  more...

Oracle Database 11g Execution Plans and Star Transformations Oracle Database 11g: Execution Plans and Star Transformations Oracle An execution plan is the output of the optimizer and is presented to the execution engine for implementation. The execution plan instructs the execution engine about the operations it must perform for retrieving the data required by a query most efficiently. This course explores gathering, displaying, and interpreting  more...

Oracle Database 11g Optimizer Statistics Hints Cursor Sharing Oracle Database 11g: Optimizer Statistics, Hints & Cursor Sharing Oracle Optimizer statistics describe details about the database and the objects in the database and are used by the query optimizer to select the best execution plan for each SQL statement. This course covers gathering optimizer and system statistics, setting statistic preferences, using dynamic sampling, and manipulating  more...

Oracle Database 11g Application Tracing Automatic SQL Tuning Oracle Database 11g: Application Tracing & Automatic SQL Tuning Oracle Oracle Database implements tracing by generating a trace file for each server process when you enable the tracing mechanism. This course explores configuring the SQL Trace facility to collect session statistics, using the TRCSESS utility to consolidate SQL trace files, formatting trace files using the tkprof utility, and  more...

ORACLE DATABASE 11G SQL TUNING ORACLE DATABASE 11G: SQL TUNING Oracle  more...

Oracle Database 11g Configuring OSB Security Oracle Database 11g: Configuring OSB & Security Oracle Oracle Secure Backup or OSB is centralized tape-management software that allows you to backup and restore data using a variety of machine architectures. This course covers how OSB complements the Oracle backup and recovery options, as well as terminology, interface options, and backup management features. Additionally, it explores how to  more...

Oracle Database 11g Securing Domain Data In Oracle Secure Backup Oracle Database 11g: Securing Domain & Data In Oracle Secure Backup Oracle Oracle Secure Backup (OSB) maintains its own catalog of OSB and their rights on the administrative server. You can preauthorize users for the use of the obtool command line, RMAN, or both. You can also associate an OSB user with multiple Windows domain accounts or a single account that applies to all Windows domains.  more...

Oracle Database 11g RMAN and Oracle Secure Backup Oracle Database 11g: RMAN and Oracle Secure Backup Oracle RMAN manages the disk space in the Flash Recovery Area, and by putting RMAN in control of your backup and restore operations, you simplify your availability-related processes. This course describes integrated disk and tape backup, how to register the administrative server in Enterprise Manager, checking RMAN backup and recovery  more...

Oracle Database 11g Managing Backups Infrastructure Oracle Database 11g: Managing Backups & Infrastructure Oracle Restoring files is easily accomplished using the Oracle Secure Backup catalog. This course demonstrates how to browse the catalog for file-system backup data, create catalog-based restore requests, and perform file-system restoration. In addition, this course explores the Oracle Secure Backup processes, configuring defaults and  more...

Oracle Dabase 11g Tape Vaulting Duplication Tuning Oracle Dabase 11g: Tape Vaulting, Duplication & Tuning Oracle Oracle Secure Backup uses a volume rotation policy to track a backup volume as it moves from its originating location to a storage location and is eventually recycled. This process is known as vaulting. This course covers configuring and using tape vaulting and a tape vaulting environment, viewing tape rotation reports, and  more...

ORACLE DATABASE 11G SECURE BACKUP ORACLE DATABASE 11G: SECURE BACKUP 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 Database Security Oracle Database 11g: Database Security Oracle Oracle Database server is highly secure, but to fully maximize the security features offered, the database must be well protected as well. This course explores how to configure Oracle Database 11g in a secure manner by adhering to industry standard best security practices for operational database deployments. It covers applying the principle of  more...

Oracle Database 11g Database Auditing Oracle Database 11g: Database Auditing Oracle Monitoring or auditing should be an integral part of your security procedures. Oracle Database 11g includes auditing tools for database, user, and fine-grained auditing. This course explores how to implement basic database auditing, privileged user auditing, DML and DDL auditing, and how to send audit records to the operating system files.  more...

Oracle Database 11g Basic User Strong Authentication Oracle Database 11g: Basic User & Strong Authentication Oracle A basic security requirement is that you must know your users. You must identify them before you can determine their privileges and access rights, so that you can audit their actions on the data. This course covers creating and auditing database authenticated users and operating-system-authenticated users. It explores  more...

Oracle Database 11g Enterprise User Security Proxy Authentication Oracle Database 11g: Enterprise User Security & Proxy Authentication Oracle Enterprise User Security addresses the user, the administrative, and the security challenges by centralizing storage and management of user-related information in a Lightweight Directory Access Protocol-compliant directory service. This course describes the basic components of Enterprise User Security. It shows the  more...

Oracle Database 11g Privileges Roles Application Contexts Oracle Database 11g: Privileges, Roles & Application Contexts Oracle Authorization is the process that determines the privileges that the user is allowed to exercise. In the Oracle database, authorization is determined by the grant of system and object privileges. This course covers implementing roles, enterprise roles, and the securing of objects through procedures. It also describes how  more...

Oracle Database 11g Virtual Private Database Oracle Database 11g: Virtual Private Database Oracle A Virtual Private Database (VPD) uses fine-grained access control (FGAC) to limit row and column access and an application context to provide the information that is used to set the policy predicates. This course describes VPD, how to implement VPD, and group policies. It also explores how FGAC is used with VPD, as well as tools, policies,  more...

Oracle Database 11g Oracle Label Security the Data Masking Pack Oracle Database 11g: Oracle Label Security & the Data Masking Pack Oracle Oracle Label Security is a powerful tool for classifying data and mediating access to data based on its classification. It provides an easy-to-implement row-level security solution and is built on the fine-grained access control technology of the virtual private database (VPD). This course describes Oracle Label  more...

Oracle Database 11g Encryption Concepts Oracle Database 11g: Encryption Concepts Oracle All encryption has two parts: an algorithm, which is a procedure or a method of manipulating data, and a key or a secret that allows data to be decrypted. This course discusses the issues and challenges of encryption and describes key management solutions. It also describes the encryption options available with Oracle Database 11g. Using  more...

Oracle Database 11g Transparent Data Encryption Oracle Database 11g: Transparent Data Encryption Oracle Transparent Data Encryption (TDE) is available with Oracle Advanced Security (ASO) and provides easy-to-use protection for your data without requiring changes to your applications. This course demonstrates how to set up the database master encryption key and implement TDE. It also explores how to encrypt column and tablespace data.  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 Firewalls Oracle Connection Manager and SQL Plus Security Oracle Database 11g: Firewalls, Oracle Connection Manager and SQL*Plus Security Oracle There is no single best architecture for accommodating Internet requests requiring access to corporate intranets. Instead, trade-offs must be made between two competing goals: security of the intranet against an Internet attack and ease of access to services by both Internet and intranet clients. This  more...

Oracle Database 11g R2 Installation Oracle Restart Oracle Database 11g R2: Installation & Oracle Restart Oracle Oracle Database 11g Release 2 offers a unique scale-out technology with a single database instance, lower server and storage costs, and increased availability and scalability. It also provides customers with improved user service levels, reduced down-time, and more efficient use of IT resources as well as an increased level of  more...

Oracle Database 11g R2 ASM Storage Partitioning Enhancements Oracle Database 11g R2: ASM, Storage & Partitioning Enhancements Oracle Oracle Database 11g Release 2 provides many improvements from its previous releases. This includes enhancements to ASM and storage to improve performance and to reduce server maintenance down time. This course identifies the enhancements in each of these areas. It also demonstrates how to use ASM fast mirror resync,  more...

Oracle Database 11g R2 Oracle Partioning Security Features Oracle Database 11g R2: Oracle Partioning & Security Features Oracle Oracle Database 11g Release 2 offers more advanced data warehouse, partitioning, security and network feature enhancements to allow the DBA to provide a more efficient way for users to access data in a secure environment. This course covers the enhanced data warehouse and partition enhancements, which includes support for  more...

Oracle Database 11g R2 Using Change Management Solutions Oracle Database 11g R2: Using Change Management Solutions Oracle Oracle Database 11g Release 2 is designed for data center environments that are rapidly evolving and changing to keep up with business demands, enabling DBAs to manage change effectively and efficiently. Oracle Database 11g Release 2 offers significant advances in the areas of automatic diagnostics, supportability, and change  more...

Oracle Database 11g R2 Intelligent Infrastructure Enhancements Oracle Database 11g R2: Intelligent Infrastructure Enhancements Oracle Oracle Database 11g Release 2 offers new intelligent infrastructure features to aid DBAs by automatically gathering performance metrics for problem detection and self-tuning purposes. The information gathered can be viewed by the DBA using either reports or views, as well as the alert log. Oracle Database 11g has expanded  more...

Oracle Database 11g R2 Diagnosability Enhancements Oracle Database 11g R2: Diagnosability Enhancements Oracle Oracle Database 11g Release 2 offers new diagnosability enhancements to help DBAs in diagnosing, resolving, and preventing problems. These new features include enhancements to problem and incident identification, running health checks, and performing repairs on SQL statements. These features enables the DBA to quickly and efficiently  more...

Oracle Database 11g R2 SQL Monitoring Performance Enhancements Oracle Database 11g R2: SQL Monitoring & Performance Enhancements Oracle Oracle Database 11g Release 2 offers improvements and new features to provide DBAs a better way to monitor SQL commands in real-time and to allow the database to automatically manage its own memory and gather optimizer statistics. These features enable the DBA to ensure the optimal memory sizes are being used for the  more...

Oracle Database 11g R2 Application Performance Enhancements Oracle Database 11g R2: Application Performance Enhancements Oracle Oracle Database 11g Release 2 offers improved and new features to provide better application performance. It offers online table redefinition, which allows tables to be modified without affecting the availability of the table to users and does not affect any of its dependencies. This allows for easier application changes and  more...

Oracle Database 11g R2 Backup Recover Archive Repair Data Oracle Database 11g R2: Backup, Recover, Archive & Repair Data Oracle Oracle Database 11g Release 2 offers new and improved features to ensure for continuous data access, even during unplanned failures and scheduled maintenance tasks. New RMAN features make it easier to backup, recover and duplicate databases in a timely manner while minimizing data loss. It also offers Flashback technology,  more...

Oracle Database 11g R2 Oracle Scheduler Secure Backup Oracle Database 11g R2: Oracle Scheduler & Secure Backup Oracle Oracle Database 11g Release 2 offers improvements to Oracle Scheduler that increases efficiency and usability. These include allowing users to get specific email notifications about job activities, triggering jobs to automatically execute when the specified file is received, enabling jobs to run on multiple nodes while managing  more...

ORACLE DATABASE 11G R2 NEW FEATURES FOR ADMINISTRATORS R2 ORACLE DATABASE 11G R2: NEW FEATURES FOR ADMINISTRATORS R2 Oracle  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...

Mastering RoboHelp Office 2002 Why pay hundreds of dollars for basic/intermediate RoboHelp training? Learn the basics of WinHelp, WebHelp and HTML Help development--plus real world tricks and tips--with this 200-page tutorial manual. Provides the basics of online Help development along with fast-paced tutorials that will have the novice Help developer creating RoboHelp and RoboHelp HTML systems in no time! Getting Started  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...

Database and Instance Management in Oracle9i To describe how to manage an Oracle9i database instance and how to plan and create a database  more...

Database Structures in Oracle9i To describe how to use an Oracle9i database data dictionary, the control files, and the redo log files  more...

Data Storage in Oracle9i To describe the data storage structures in an Oracle9i database and explain how to manage them  more...

Tables and Indexes in Oracle9i To describe how to manage tables and indexes in an Oracle9i database  more...

Data Integrity in Oracle9i To describe how to use integrity constraints to enforce business rules on the data in an Oracle 9i database  more...

Users and Profiles in Oracle9i To describe how to use manage users, passwords, and resources in an Oracle9i database  more...

Privileges and Roles in Oracle9i To describe how to manage privileges and roles in an Oracle9i database  more...

Globalization and Auditing in Oracle9i To describe how to manage globalization support in an Oracle9i database and how to audit an Oracle9i database  more...

Networking Overview for Oracle9i Administrators To provide an overview of the networking solutions and the components of the network architecture in an Oracle9i database  more...

Oracle Network Configuration in Oracle9i To explain how to configure client/server Oracle Net Services and a Shared Server for an Oracle9i database  more...

Backup and Recovery Overview and Configuration in Oracle9i To describe backup and recovery operations, the backup components, and how to configure these components in an Oracle9i database  more...

User-Managed and RMAN Backup and Recovery in Oracle9i To describe how to perform user-managed and Recovery Manager backup and recovery in an Oracle9i database  more...

Recovery Manager Maintenance in Oracle9i To describe how to maintain the Recovery Manager (RMAN) and how to create and maintain the recovery catalog in an Oracle9i database  more...

Transporting and Loading Data in Oracle9i To describe how to transport and load data in an Oracle9i database  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 Installation and Upgrade Enhancements Recognize the enhancements to Oracle Database 11g's installation and upgrade processes, as well as its various post-upgrade steps, and recognize how to create a new database.  more...

Oracle Database 11g Storage Enhancements recognize ways in which storage has been enhanced in Oracle Database 11g using Automatic Storage Management's (ASM's) commands and extensions.  more...

Oracle Database 11g Change Management Overview and SQL Plan Management outline the uses of management tools in Oracle Database 11g, such as SQL Performance Analzer, SQL tuning sets, and SQL plan baselines, and outline how you can use them to effectively manage change and execute SQL plans.  more...

Oracle Database 11g Database Replay and Automatic SQL Tuning Explain the benefits and uses of Oracle Database 11g's crucial developer tools, Database Replay and Automatic SQL Tuning, when setting up and testing a database  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 Performance Enhancements identify the scope and capabilities of Oracle Database 11g's performance-enhancing tools, such as those for memory management, performance analysis, and statistics gathering.  more...

Oracle Database 11g Partitioning and Storage-Related Enhancements identify the benefits of Oracle Database 11g's partitioning and storage-related enhancements, and recognize how to use SQL Access Advisor to help you optimize your database in this regard.  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...

Oracle Database 11g Diagnostic Enhancements and Using the Data Recovery Advisor recognize the steps for detecting, diagnosing, and repairing critical errors and data failures in Oracle Database 11g, using its enhanced, proactive, diagnostic tools, such as Automatic Diagnostic Repository, Support Workbench, SQL Repair Advisor, and the Data Recovery Advisor.  more...

Oracle Database 11g New Security Features identify the ways in which Oracle Database has enhanced security, including enhancements to Transparent Data Encryption and password security, and identify the steps for managing all aspects of security.  more...