Online Oracle 10g eLearning - Training Resources

Oracle 10g OCA ...is 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 attractive to employers. Employers are looking for individuals with a solid foundation of skills needed for effective performance. Specialized Solutions?s course on Oracle 10g will  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...

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 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 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 Application Server 10g Introduction To provide an introduction to OracleAS architecture, components, and installation options  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 This course will teach learners to configure an Oracle database for multilingual applications and distributed database access. Learners will learn how to use various database technologies, such as Resource Manager, the Scheduler, and materialized views. Learn To: Identify features of Automatic Storage Management (ASM). Identify features of Automatic Storage Management (ASM)  more...

Oracle Database 10g Adminsitration Workshop I Part 3 This course provides an understanding of the Database Security. This course will help the learner to understand the benefits of database auditing and monitoring. It also covers Database Listeners and Services. The concept of shared and dedicated servers is also covered. After going through this course, the learners would be able to tune the system for best performance by configuring automatic  more...

Oracle Database 10g SQL Fundamentals I Part 2 In this course, the learner will learn how to use the advanced features of SQL, such as advanced querying and reporting, schema objects, manipulating large data sets, and storing and retrieving dates according to different time zones. The learner will also learn the concepts of controlling access and privileges for schema objects and using advanced subqueries. . Learn To: Identify the  more...

Oracle Database 10g PL SQL Fundamentals Curriculum The Oracle Database 10g: PL/SQL Fundamentals Curriculum includes the following courses: Oracle Database 10g: PL/SQL Fundamentals (Part 1) Oracle Database 10g: PL/SQL Fundamentals (Part 2) Oracle Database 10g: PL/SQL Fundamentals (Part 3) To review individual course descriptions, please return to the previous page and select the desired title(s).  more...

Oracle Database 10g PL SQL Fundamentals Part 1 In this course, the learner will get familiar with the procedural language to access Oracle database. The learner will learn how to write and use anonymous PL/SQL blocks, program constructs, simple and composite PL/SQL data types, programming guidelines, and accessing and manipulating data using PL/SQL. Additionally, the learner will also learn how to write and use PL/SQL program units, such as  more...

Oracle Database 10g SQL Fundamentals I Curriculum The Oracle Database 10g: SQL Fundamentals I Curriculum includes the following courses: Oracle Database 10g: SQL Fundamentals I (Part 1) Oracle Database 10g: SQL Fundamentals I (Part 2) To review individual course descriptions, please return to the previous page and select the desired title(s).  more...

Oracle Database 10g SQL Fundamentals I Part 1 ... hours Objectives: Unit 1: Database Management in Oracle 10g Match the different phases of system development life cycle (SDLC) with their features. Identify features of an Entity Relationship (ER) model. Identify features of Relational Database Management System (RDBMS). Identify the structural components of Oracle 10g. Identify features of iSQL*Plus. Identify options  more...

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

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

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

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

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

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

Oracle Database 10g New Features for Administrators Curriculum The Oracle Database 10g: New Features for Administrators Curriculum includes the following courses: Oracle Database 10g: New Features for Administrators (Part 1) Oracle Database 10g: New Features for Administrators (Part 2) Oracle Database 10g: New Features for Administrators (Part 3) Oracle Database 10g: New Features for Administrators (Part 4) Oracle Database 10g: New Features for  more...

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

Oracle Database 10g New Features for Administrators Part 3 Oracle Database 10g is the first database designed for enterprise grid computing. It is the most flexible and cost-effective way to manage enterprise information. This course covers new features of Resource Manager, job Scheduler, tablespace monitoring, shrinking segments, and partitioning enhancements. Learn To: Identify features of Resource Manager in Oracle Database 10g. Identify  more...

Oracle Database 10g New Features for Administrators Part 4 Oracle Database 10g is the first database designed for enterprise grid computing. It is the most flexible and cost-effective way to manage enterprise information. This course covers new features of Oracle Database 10g such as flash backup and recovery. Learn To: Identify features of the flash backup and recovery strategy. Identify tasks that you perform when using the flash recovery  more...

Oracle Database 10g New Features for Administrators Part 5 Oracle Database 10g is designed for enterprise grid computing. It is the most flexible and cost-effective way to manage enterprise information. Oracle Database 10g supports the Oracle vision of creating a self-aware, self-learning, and completely self-managing database. This course covers new features of Oracle Database 10g such as automatic storage management, upgrade methods, RMAN backup, flash  more...

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

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

Oracle Database 10g PL SQL Fundamentals Part 2 This course introduces learners to PL/SQL and helps them understand the benefits of this programming language. Students learn to create anonymous PL/SQL blocks. They learn to declare variables and trapping exceptions, develop stored procedures, functions, packages and database triggers. Learn To: Identify features of PL/SQL blocks within a subprogram. Match types of PL/SQL named blocks  more...

Oracle Database 10g PL SQL Fundamentals Part 3 In this course, the learner will get familiar with the procedural language to access Oracle database. Students will learn to manage PL/SQL program units manage dependencies, manipulate large objects, and use some of the Oracle-supplied packages. The student will also learn about the compilation tools and their options. Learn To: Match the stages in the execution of SQL statements with  more...

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

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

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

Oracle Application Server 10g Administration Part 3 ...al Learning Time: 4 hours Objectives: Unit 1: Oracle 10g Application Server Identify options for managing Oracle Containers for J2EE (OC4J) instances. Identify tasks to be performed for configuring Oracle Containers for J2EE (OC4J) instances. Identify different properties of an Oracle Containers for J2EE (OC4J) instance. Identify tasks to be performed for maintaining  more...

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

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

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

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

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

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