Online Oracle eLearning - Training Resources

Oracle 10g OCA ...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 skills make you  more...

Mastering RoboHelp Office 2002 ...Help features available from WinHelp, HTML Help, WebHelp, Oracle Help and Java Help. Working with Help Projects describes creating projects; compressing and compiling projects in RoboHelp; and generating projects in RoboHelp HTML. Importing Documents, Files and Projects contains Word to Help conversion tips; how to convert Word documents to RoboHelp; how to import Word documents to RoboHelp  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 Database 11g Getting Started with SQL and PL SQL New Features 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 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 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 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 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 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 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 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...

Introducing Oracle9i Database To introduce the components and architecture of Oracle9i, the application of Oracle9i, and migrating and upgrading to Oracle9i  more...

Manageability Enhancements in Oracle9i To describe the manageability enhancements of an Oracle9i database  more...

Availability Features in Oracle9i To explain how the new features of an Oracle9i database support the maximum availability of a database  more...

Scalability and Performance in Oracle9i To describe the scalability and performance enhancements available in an Oracle9i database  more...

Development Platform in Oracle9i To explain the Oracle9i database enhancements that support the Oracle9i database development platform  more...

Security Overview for Oracle9i Administrators To provide an overview of the security features in an Oracle9i database  more...

Introduction to Oracle and SQL in Oracle9i To introduce Oracle as a relational database management system (RDBMS) and to discuss how to use basic SQL statements  more...

SQL Functions in Oracle9i To describe how to use SQL functions for data retrieval  more...

Subqueries Reporting and User-Access Control in Oracle9i To describe the use of subqueries, reporting, and user-access control in an Oracle9i database  more...

Defining and Manipulating Data in Oracle9i To describe how to define database objects and manipulate the data stored within them in an Oracle9i database  more...

Performance Tuning Methodology and Tools in Oracle9i To describe the methods and goals of database tuning and the utilities and tools used to analyze and tune an Oracle9i database  more...

Tuning Memory Structures in Oracle9i To describe how to tune Oracle9i memory structures  more...

Tuning Database Structures in Oracle9i To describe how to tune components of an Oracle9i database  more...

Tuning Systems and Applications in Oracle9i To describe how to tune systems and applications in Oracle9i  more...

Oracle 11i E-Business Suite Introduction 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 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 To create value sets and to perform the tasks to define a structure for descriptive flexfields  more...

Oracle 11i E-Business Suite System Administration 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 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 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 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 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 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 To personalize forms and Oracle Applications (OA) framework pages  more...

Oracle 11i Oracle Workflow 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 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 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 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...

Oracle Database 10g Installing Oracle Database 10g Release 2 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 Release 2 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 Release 2 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 Release 2 To explain the fundamentals of Oracle database control and how to use tablespaces  more...

Oracle Database 10g Users and Security Release 2 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 Release 2 To demonstrate how to manage schema objects and data in an Oracle 10g database  more...

Oracle Database 10g The SQL Loader and PL SQL Release 2 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 Release 2 To provide an overview of Oracle Net Services and Shared Server  more...

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

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

Oracle Database 10g Managing Backup and Recovery Release 2 To discuss how to manage backup and recovery in an Oracle 10g database  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...

Oracle Database 11g SecureFiles and Miscellaneous New Features Recognize the steps for enhancing the performance of large objects, caching query results, and performing other miscellaneous tasks in Oracle Database 11g  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...

Introduction to Oracle and SQL in Oracle Database 10g 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 To describe how to use SQL functions for data retrieval  more...

Displaying Multiple Table Data and Using Set Operators in Oracle Database 10g 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 To demonstrate how to use group and datetime functions in Oracle 10g  more...

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

Regular Expressions and User Access in Oracle Database 10g 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 To demonstrate how to create and manage tables and constraints in Oracle 10g  more...

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

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

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

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

Using PL SQL with an Oracle Server 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 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 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 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 To create and execute a stored function and call, and remove and view stored functions in PL/SQL  more...

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

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

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

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

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

Dynamic SQL and Metadata To write dynamic SQL and use the DBMS_METADATA package  more...

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

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

Oracle Database 10g Miscellaneous New Features To recognize how various new features are used in Oracle 10g  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 Using Data Types INDEX BY Tables and Cursors in PL SQL 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 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 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 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 To discuss the new installation and configuration features of Oracle 10g  more...

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

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

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

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

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

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

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

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

Oracle Database 11g PL SQL Variables Attributes and Executable Statements 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 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 Application Server 10g Infrastructure and Middle Tier Installation 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 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 To demonstrate how to perform general management of Oracle HTTP Server (OHS)  more...

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

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

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

Oracle Application Server 10g Application Management and Deployment To demonstrate how to manage and deploy applications in OracleAS  more...

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

Oracle Application Server 10g DAS and SSO 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 To demonstrate how to manage wallets and certificates and configure components for SSL in OracleAS  more...

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

Oracle 11i Project Management and Projects Integration 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 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 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 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 To define project setup options and project types to manage project structuring, resources, and workflow  more...

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

Oracle 11i User-Defined Attributes Implementation Options and Utilization 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 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 To provide an introduction to OracleAS architecture, components, and installation options  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...

Oracle SQL PL SQL Using Procedure Builder Curriculum ...ulum consists of four Skill Builder courses: Course 61110 Oracle SQL: Basic SELECT Statements Course 61111 Oracle SQL: Data Retrieval Techniques Course 61112 Oracle SQL: DML and DDL Course 61113 Oracle PL/SQL: Basics Certification: This curriculum will help candidates prepare for test 1Z0-001, which applies towards the following Oracle Certified Professional (OCP) Program certification tracks:  more...

Oracle9i Performance Tuning Optimizing Sorts Minimizing Contention ...f this course includes details about each component of an Oracle database instance, such as data blocks, disks, memory, CPU, and dynamic views. Students learn about migration and chaining, reorganizing indexes, optimizing sort operations, tuning rollback segments, managing automatic undo, monitoring activities, implementing the Oracle shared server, and troubleshooting. Learn To: o Match  more...

Oracle9i Peformance Tuning Managing Memory and Disk I O ... initial database design, and the methods used to tune an Oracle9i production database. Students learn how to use the available Oracle tools to recognize, troubleshoot, and resolve common performance-related problems in administering an Oracle database. Learn To: o Match the optimizer modes with their descriptions. o Match the OPTIMIZER_MODE parameter values with their description. o  more...

Oracle9i Performance Tuning Architecture Strategy ...uced to the strategies and techniques used for tuning the Oracle9i server. Learn To: o Match the tuning goals with the appropriate job role. o Identify common tuning problems that directly affect database performance. o Identify appropriate tuning goals. o Identify key information recorded by the alert log. o Identify the parameters that control the location and format of the alert  more...

Oracle9i Database Performance Tuning Curriculum The Oracle9i Database: Performance Tuning Curriculum includes the following courses: Oracle9i Performance Tuning: Architecture and Strategy Oracle9i Performance Tuning: Managing Memory and Disk I/O Oracle9i Performance Tuning: Optimizing Sorts and Minimizing Contention To review individual course descriptions, please return to the previous page and select the desired title(s).  more...

Oracle9i Database Admin Set Up Oracle Net Services ... 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 • Sequence the steps  more...

Oracle9i Database Admin Recover Databases ...Oracle9i database recovery concepts. The recovery concepts course includes recovery with and without archiving, recovery of offline and online databases, recovery with missing data files, and incomplete recovery with and without archiving. Additional concepts covered by this course include time-based recovery, cancel-based recovery, recovery manager components, recovery manager commands, export  more...

Oracle9i Database Admin Perform Database Backups ...w 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 SQL*Plus  more...

Oracle9i Database Fundamentals II Curriculum The Oracle9i Database: Fundamentals II Curriculum includes the following courses: Oracle9i Database Admin.: Perform Database Backups Oracle9i Database Admin.: Recover Databases Oracle9i Database Admin.: Set Up Oracle Net Services To review individual course descriptions, please return to the previous page and select the desired title(s).  more...

Oracle9i Database Admin Manage Security ...base 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 environment. • Define and maintain a named set of resource and password  more...

Oracle9i Database Admin Manage Data Storage ...base 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 components of the row structure in an Oracle database. • Identify  more...

Oracle9i Database Admin Manage Storage Structures ...Oracle 9i Database Administration: Manage Storage Structures course is the third in a five-part series covering the database administration strategies and procedures provided in Oracle9i. In this course, participants learn the concepts associated with storage structure components. In addition, this course teaches users the procedures for managing segment free space, undo space, temporary  more...

Oracle9i Database Admin Create a Database ...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 create and maintain  more...

Oracle9i Database Admin Manage an Instance ...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 performed by using  more...

Oracle9i Database Fundamentals I Curriculum ...Oracle9i Database: Fundamentals I Curriculum includes the following courses: Oracle9i Database Admin.: Manage an Instance Oracle9i Database Admin.: Create a Database Oracle9i Database Admin.: Manage Storage Structures Oracle9i Database Admin.: Manage Data Storage Oracle9i Database Admin.: Manage Security To review individual course descriptions, please return to the previous page and  more...

Oracle9i SQL DML and DDL ...Oracle SQL DML and DDL course is the third in a three-part series covering the Data Manipulation and Data Definition language statements supported by Oracle9i. This course introduces the participants to various objects in a database. The participants learn to create, update, and delete the database objects. The participants also learn to add rows, update, and delete existing rows from a table.  more...

Oracle9i SQL Data Retrieval Techniques ...ate customized queries. Learn To: o Identify the four Oracle join types used to display data from more than one table. o Identify a Cartesian product. o Retrieve rows from two tables by using an equijoin. o Identify the features of a group function. o Write SQL statements that contain common group functions. o Manage null values when using group functions in a SQL statement. o  more...

Oracle9i SQL Basic SELECT Statements ...Oracle concepts; writing basic SQL statements; restricting and sorting data; and using single-row functions. Additionally, this course provides an introduction to relational database concepts and the use of SQL for storing, retrieving, and manipulating data in a relational database. Learn To: o Identify the components of the relational model. o Match the structural elements of a  more...

Oracle9i SQL Curriculum The Introduction to Oracle9i: SQL Curriculum includes the following courses: Oracle9i SQL: Basic SELECT Statements Oracle9i SQL: Data Retrieval Techniques Oracle9i SQL: DML and DDL To review individual course descriptions, please return to the previous page and select the desired title(s).  more...

Oracle9i Certified Database Administrator Track Curriculum ...Oracle9i Certified Database Administrator Track Curriculum includes the following curriculums: Introduction to Oracle9i: SQL Curriculum (ID#8054) Oracle9i Database: Fundamentals I Curriculum (ID#8058) Oracle9i Database: Fundamentals II Curriculum (ID#8064) Oracle9i Database: Performance Tuning Curriculum (ID#8068) To review individual curriculum descriptions, please select the  more...

Oracle Developer R6 Build Forms II Curriculum The Oracle Developer R6: Build Forms II Curriculum includes the following courses: Oracle Developer: Writing and Debugging Code(ID#472) Oracle Developer: Project Builder and Menu Modules(ID#473) Oracle Developer: Including Reuseable Oracle Components(ID#475) To review individual course descriptions, please return to the previous page and select the desired title(s).  more...

Oracle Developer R6 Build Forms I Curriculum The Oracle Developer R6: Build Forms I Curriculum includes the following courses: Oracle Developer: Forms Fundamentals(ID#470) Oracle Developer: Enhancing the User Interface(ID#471) Oracle Developer: Controlling the User Interface Programmatically(ID#474) To review individual course descriptions, please return to the previous page and select the desired title(s).  more...

Oracle Internet App Dev Track for Forms Developer R6 6i Curriculum ...Oracle Internet App. Dev. Track for Forms Developer R6/6i Curriculum includes the following courses: Oracle SQL: Basic SELECT Statements(ID#378) Oracle SQL: Data Retrieval Techniques(ID#379 Oracle SQL: DML and DDL(ID#380) Oracle PL/SQL: Basics(ID#322) Oracle PL/SQL: Procedures, Functions and Packages(ID#7745) Oracle PL/SQL: Database Programming(ID#7746) Oracle Developer: Forms  more...

Oracle PL SQL Database Programming ...d their application to complement the capabilities of the Oracle base product. L earn To: Create subprograms and packages. Manage procedures and functions. Create triggers. C ontent Emphasis Skills-Based A udience Application Developers, Database Administrators, and Technical Support Professionals. Prior to taking this course, students should have knowledge  more...

Oracle PL SQL Procedures Functions Packages ...nt to the computer based training (CBT) courses entitled: Oracle SQL and SQL*Plus: Basic SELECT Statements (course 61110), Oracle SQL and SQL*Plus: DML and DDL (61112). T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: Subprograms: Procedures Duration: 2 - 3 Hour(s) Match the various sections of a subprogram with their contents. Identify the components of  more...

Oracle Designer 6i First Class Design Generation ... material as the second half of the Instructor Led course Oracle Designer6i: First Class. This course takes students along a streamlined path through the Oracle Designer development environment. It follows on from the first title in the series Oracle Designer First Class 6i: Analysis and covers transforming the analysis model into design level definitions, refining the data and application  more...

Oracle Designer 6i First Class Analysis ...e material as the first half of the Instructor Led course Oracle Designer 6i: First Class. The course takes students along a streamlined path through the Oracle Designer development environment. It covers recording business requirements into the Repository including process modeling, entity relationship modeling, and function modeling. This course is part of an Oracle integrated curriculum and  more...

Oracle Designer 6i Curriculum The Complete Oracle Designer 6i Curriculum includes the following courses: Oracle SQL: Basic SELECT Statements Oracle SQL: Data Retrieval Techniques Oracle SQL: DML & DDL Oracle SQL: PL/SQL: Basics Oracle Designer 6i First Class: Analysis Oracle Designer 6i First Class: Design & Generation To review individual course descriptions, please return to the previous page and select the  more...

OCDBA8i Curriculum ...ete 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...

Oracle8i Network Administration Net8 Additional Config Troubleshooting ...erview 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 peers.  more...

Oracle8i Network Administration Net8 Architecture Strategy ...verview 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 peers.  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 Backup and Recovery Troubleshooting Recovery ...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, users will be  more...

Oracle8i Backup and Recovery Strategies Backups ... functions of the various structures and processes in the Oracle architecture. In addition, participants learn to manage archive processing and maintain a recovery catalog. This course also identifies the concepts associated with performing physical backups with or without Recovery Manager (RMAN). L earn To: Identify the features of the Oracle backup and recovery architecture.  more...

Oracle8i Backup and Recovery Curriculum The Oracle 8i Backup and Recovery Curriculum includes the following courses: Oracle 8i Backup and Recovery: Strategies & Backups Oracle 8i Backup and Recovery: Troubleshooting & Recovery To review individual course descriptions, please return to the previous page and select the desired title(s).  more...

Oracle8i Performance Tuning Optimizing Sorts Minimizing Contention ...ourse 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 Performance Tuning Managing Memory Disk I O ...urse 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 Architecture Strategy ...ourse 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 Curriculum The Oracle 8i Performance Tuning Curriculum includes the following courses: Oracle 8i Performance Tuning: Architecture & Strategy Oracle 8i Performance Tuning: Managing Memory & Disk I/O Oracle 8i Performance Tuning: Optimizing Sorts & Minimizing Contention To review individual course descriptions, please return to the previous page and select the desired title(s).  more...

Oracle8i Database Admin Manage Security ...base 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 password limits. Understand the concept of resource limits and how to set  more...

Oracle8i Database Admin Manage Data Storage ...base 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 earn To: Identify the characteristics of various tables and datatypes.  more...

Oracle8i Database Admin Manage Storage Structures ...base 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 the database storage structures and their relationships. Manage rollback  more...

Oracle8i Database Admin Create Databases ...base 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: Identify and create a database. Identify the data dictionary views.  more...

Oracle8i Database Admin Manage an Instance ...base 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: Identify Oracle architectural components. Use the Oracle Enterprise Manager  more...

Oracle8i Database Administration Curriculum ...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...

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 Flashback  more...

Oracle Database 10g Administration Workshop II Part 4 ...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) architecture. Identify key concepts related to  more...

Oracle Reports R6 Control Reports ...ourse Overview This course is the third in a three-part Oracle Reports series that is based on Oracle Reports Release 6. This course introduces the learner to features of Oracle Reports that can be used to control report output. This course covers developing templates, creating and using parameters, coding PL/SQL triggers, exporing built-in package procedures, using the Reports Server, and  more...

Oracle Reports R6 Enhance Reports ...urse Overview This course is the second in a three-part Oracle Reports series that is based on Oracle Reports Release 6. The goal of this course is to enable developers to construct complex reports and charts using Oracle Reports. This course introduces the learner to the key features of the Data Model editor, Layout Model objects and their properties. The course also enables the learner to  more...

Oracle Reports R6 Report Fundamentals ...ourse Overview This course is the first in a three-part Oracle Report Builder series that is based on Oracle Reports Release 6. This course introduces the learner to, the key features of Report Builder, steps involved in building a standard tabular report and report layout styles. In addition, this course will help participants learn how to use the Live Previewer, store reports, and migrate  more...

Oracle Form Builder R6 Including Reusable Oracle Components ... Course Overview This course is the sixth in a six-part Oracle Developer series that is based on Oracle Developer Release 6. This course will enable learners to implement methods to use additional data sources, to work with Oracle8 objects, and to integrate charts, reports, and timers in form modules. In addition, the course covers the procedures to reuse components, objects, and code and to  more...

Oracle Form Builder R6 Controlling the User Interface Programmatically ... Course Overview This course is the fifth in a six-part Oracle Developer series based on Oracle Developer Release 6. This course enables learners to create Key triggers, to write code that responds to mouse events, to manage windows and canvases, and to use the Object Navigator. In addition, learners work with multiple form applications, record groups, and list items. L earn To:  more...

Oracle Form Builder R6 Project Builder and Menu Modules ...Course Overview This course is the fourth in a six-part Oracle Developer series based on Oracle Developer Release 6. This course describes the features and benefits of Oracle Project Builder, how to create and deliver projects, and how to create new file types. In addition, the course describes how to create and manipulate menu modules, and how to manage menu modules. L earn To:  more...

Oracle Form Builder R6 Writing and Debugging Code ... Course Overview This course is the third in a six-part Oracle Developer series that is based on Oracle Developer Release 6. In this course learners will create and control alerts, debug PL/SQL code, and process queries in form modules. In addition, the course will cover transaction processing, Form Builder application customization, and writing flexible code. L earn To: Identify  more...

Oracle Form Builder R6 Enhancing the User Interface ...Course Overview This course is the second in a six-part Oracle Developer series based on Oracle Developer Release 6. This course describes how to create input and non-input items, how to create lists of values (LOVs) and editors to support text items, and how to create forms using multiple windows and a variety of canvas styles. Additionally, this course covers ways to add functionality to  more...

Oracle Form Builder R6 Forms Fundamentals ... Course Overview This course is the first in a six-part Oracle Developer series that is based on Oracle Developer Release 6. This course introduces the learner to the key features, components, and capabilities of Oracle Developer. In addition, this course helps learners to run, create, and customize a form module. L earn To: Identify the key features, components and capabilities of  more...

Oracle8 Performance Tuning Optimizing Sorts and Minimizing Contention ...ourse 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...

Oracle8 Performance Tuning Managing Memory and Disk I O ...urse 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 Curriculum The Oracle8 Performance Tuning Curriculum consists of the following courses: Oracle8 Performance Tuning: Strategies and Techniques Oracle8 Performance Tuning: Managing Memory and Disk I/O Oracle8 Performance Tuning: Optimizing Sorts and Minimizing Contention To review individual course descriptions, please return to the previous page and select the desired title(s).  more...

Oracle8 Performance Tuning Strategies and Techniques ...ourse 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 Network Administration Net8 Configuration and Troubleshooting ... 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 between peers.  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 Architecture Configuration ... 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 peers.  more...

Oracle8 Backup and Recovery - Troubleshooting and Recovery ...nally, users will be introduced to the different types of Oracle recovery methods and how to recover from the loss of a Recovery Catalog and Control File. Finally, this course will present the features and usage guidelines of a standby database and how to manage one. L earn To: Identify the ways of handling different types of errors. Diagnose errors and detect corruption by using  more...

Oracle8 Backup and Recovery Curriculum The Oracle8 Backup and Recovery Curriculum consists of the following courses: Oracle8 Backup and Recovery - Strategies and Backups Oracle8 Backup and Recovery - Troubleshooting and Recovery To review individual course descriptions, please return to the previous page and select the desired title(s).  more...

Oracle8 Backup and Recovery - Strategies and Backups ...urse, 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 be presented with the components and features of Recovery Manager and how to maintain a recovery catalog. Finally, the user will learn how to perform physical backups with and without  more...

Oracle8 Database Administration - Manage Security ...base 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 resources and password limits. Manage system and object privileges. Control the  more...

Oracle8 Database Administration - Manage Data ...base 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 earn To: Identify the characteristics of various tables and datatypes.  more...

Oracle8 Database Administration - Manage Storage Structures ...base 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: Identify how storage structure components work. Manage rollback segments. Manage  more...

Oracle8 Certified Database Administrator Curriculum ...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 - Create Databases ...base 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: Plan and create a database. Create the data dictionary view. Use the  more...

Oracle8 Database Administration Curriculum ...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 - Manage an Instance ...base 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: Identify Oracle architectural components. Use the Server Manager line mode  more...

Oracle Report Builder Controlling Reports ...ourse Overview This course is the third in a three-part Oracle Report Builder series that is based on Oracle Developer/2000 Release 2. This course helps participants learn how to develop report templates, code PL/SQL triggers in a report, and use Report Builder's built-in package. Finally, building reports for different environments will be covered. L earn To: Identify the regions  more...

Oracle Report Builder Enhancing Reports ...urse Overview This course is the second in a three-part Oracle Report Builder series that is based on Oracle Developer/2000 Release 2. This course introduces the learner to the ways to enhance a report using the Data and Layout Model. In addition, this course will help participants learn how to modify layout objects and enhance matrix reports. L earn To: Enhance a report using the  more...

Oracle Developer 2000 Build Reports Curriculum The Developer/2000: Build Reports Curriculum consists of the following courses: Oracle Report Builder: Report Fundamentals Oracle Report Builder: Enhancing Reports Oracle Report Builder: Controlling Reports To review individual course descriptions, please return to the previous page and select the desired title(s).  more...

Oracle Report Builder Report Fundamentals ...ourse Overview This course is the first in a three-part Oracle Report Builder series that is based on Oracle Developer/2000 Release 2. This course introduces the learner to the key features of Report Builder, building a standard tabular report, and report layout styles. In addition, this course will help participants learn how to use the Live Previewer, store reports, and migrate report  more...

Oracle Form Builder Including Reusable Oracle Components ... Course Overview This course is the sixth in a six-part Oracle Form Builder Series that is based on Oracle Developer/2000 Release 2. This course will help participants learn how to implement methods to use data sources, and to integrate charts, reports and timers in Forms. In addition, reusing components, objects and code will be taught. Finally, Form Builder's new features will be covered.  more...

Oracle Form Builder Handling Multiple Object Relationships ... Course Overview This course is the fifth in a six-part Oracle Form Builder Series that is based on Oracle Developer/2000 Release 2. This course will help participants to learn about Key triggers, write applications that respond to mouse events, manage windows and canvases, and use Object Navigator. In addition, users will work with multiple form applications, record groups, and list items.  more...

Oracle Developer 2000 Build Forms II Curriculum The Developer/2000: Build Forms II Curriculum consists of the following courses: Oracle Form Builder: Managing Module Types Oracle Form Builder: Handling Multiple Object Relationships Oracle Form Builder: Including Reusable Oracle Components To review individual course descriptions, please return to the previous page and select the desired title(s).  more...

Oracle Form Builder Managing Module Types ...Course Overview This course is the fourth in a six-part Oracle Form Builder series that is based on Oracle Developer/2000 Release 2. This course will introduce participants to Project Builder and teach them how to create and manage a menu module. In addition, users will learn how to customize and implement menu security. L earn To: Identify the benefits and terminology of Project  more...

Oracle Cert App Developer Track for Developer 2000 R2 Curriculum ...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 Oracle Certified Application Developer Track for Developer/2000 Release 2 consists of the following courses: Oracle SQL:  more...

Oracle Form Builder Writing and Debugging Code ... Course Overview This course is the third in a six-part Oracle Form Builder series that is based on Oracle Developer/2000 Release 2. This course will help participants learn to create and control alerts, debug PL/SQL code, and process queries. In addition, transaction processing, Form Builder application customization, and writing flexible code will be covered. L earn To: Identify  more...

Oracle Form Builder Enhancing the User Interface ...Course Overview This course is the second in a six-part Oracle Form Builder series based on Oracle Developer/2000 Release 2. This course helps participants learn how to create input and non-input items, and support text items with Lists of Values (LOVs) and editors. Additionally, users will learn to create triggers and add functionality to them. L earn To: Create input and non-input  more...

Oracle 11i10 Order to Cash Porcessing Invoices ...unctional Implementers and Implementation Consultants for Oracle eBusiness Suite applications. Deployment: Self-Study Accreditation CEU credits: 0.40 CEUs Language Options: US English Total Learning Time: 4 hours Objectives: Unit 1: Invoicing Process: Fundamentals Identify key concepts of Receivables related to the Invoicing process. Identify key  more...

Oracle 11i10 Order to Cash Invoicing Overview ...unctional Implementers and Implementation Consultants for Oracle eBusiness Suite applications. Deployment: Self-Study Accreditation CEU credits: 0.40 CEUs Language Options: US English Total Learning Time: 4 hours Objectives: Unit 1: AutoInvoicing and Receivables Processes Identify key concepts related to the AutoInvoice process. Identify options for  more...

Oracle 11i10 Order to Cash Shipping Execution ...unctional Implementers and Implementation Consultants for Oracle eBusiness Suite applications. Deployment: Self-Study Accreditation CEU credits: 0.40 CEUs Language Options: US English Total Learning Time: 4.5 hours Objectives: Unit 1: Shipping Execution: Fundamentals Identify key concepts related to the shipping execution flow. Identify key concepts  more...

Oracle 11i10 Order to Cash Shipping Overview Setups ...unctional Implementers and Implementation Consultants for Oracle eBusiness Suite applications. Deployment: Self-Study Accreditation CEU credits: 0.40 CEUs Language Options: US English Total Learning Time: 3.5 hours Objectives: Unit 1: Shipping Fundamentals Identify key concepts related to the shipping process. Identify key concepts related to managing  more...

Oracle Workflow 11i10 Business Event System Subscriptions ...technical consultants and end-users who have knowledge of Oracle 9i, SQL, and programs within PL/SQL. Deployment: Self-Study Accreditation CEU credits: 0.40 CEUs Language Options: US English Total Learning Time: 4 hours Objectives: Unit 1: Events, Subscriptions, and Activities Identify features of business events. Identify options that enable you to  more...

Oracle Workflow 11i10 Interacting with Processes Notifications ...Oracle users and end users with knowledge of Oracle 9i SQL and PL/SQL, navigating Oracle Applications 11i, and Oracle 11i E-Business Essentials for Implementers. Learn To: Identify options for testing a workflow process. Identify options for administering workflow processes by using the Administrator Monitor. Identify options for administering workflow processes by using the  more...