Login to Course Campus | Call Us: 1-877-797-2799  

 

Everything IT

Oracle 10g


Oracle Application Server 10g: Administration I

In this course you will learn:
  • Oracle Application Server 10g: Introduction
  • Oracle Application Server 10g: Infrastructure and Middle Tier Installation
  • Oracle Application Server 10g: Management Tools and Oracle Internet Directory
  • Oracle Application Server 10g: General Management and Directives for the HTTP Server
  • Oracle Application Server 10g: OracleAS Web Cache
  • Oracle Application Server 10g: OracleAS Portal
  • Oracle Application Server 10g: mod_plsql, CGI Scripts, and Database Providers
  • Oracle Application Server 10g: Application Management and Deployment
  • Oracle Application Server 10g: Component Administration in Oracle Internet Directory
  • Oracle Application Server 10g: DAS and SSO
  • Oracle Application Server 10g: Component Security with SSL
  • Oracle Application Server 10g: Oracle Certificate Authority Management
Duration: 29:00 hrs
Oracle Database 10g: Administration Workshop II

In this course you will learn:
  • Using Flashback Technology in Oracle 10g
  • Performing and Managing Backups in Oracle 10g
  • Advanced Database Recovery and Repair in Oracle 10g
  • Controlling the Oracle Listener and Enabling Distributed Transactions in Oracle 10g
  • Using Globalization Support in Oracle 10g
  • Optimizing Database Performance in Oracle 10g
  • Managing Storage and System Resources in Oracle 10g
  • Using the Scheduler to Automate Tasks in Oracle 10g
  • Using Advanced Features in Oracle 10g
Duration: 19:20 hrs
Oracle Database 10g: SQL Fundamentals I and II

In this course you will learn:
  • Introduction to Oracle and SQL in Oracle Database 10g
  • SQL Functions in Oracle Database 10g
  • Displaying Multiple Table Data and Using Set Operators in Oracle Database 10g
  • Group and Datetime Functions in Oracle Database 10g
  • Subqueries and Hierarchical Queries in Oracle Database 10g
  • Regular Expressions and User Access in Oracle Database 10g
  • Creating and Managing Tables and Constraints in Oracle Database 10g
  • Database Objects in Oracle Database 10g
  • Managing Database Objects in Oracle Database 10g
  • Manipulating Data in Oracle Database 10g
Duration: 24:30 hrs
Oracle Database 10g: Programming with PL/SQL I

In this course you will learn:
  • Introduction to PL/SQL
  • Using PL/SQL with an Oracle Server
  • Using Control Structures
  • Using Composite Data Types
  • Explicit Cursors and Exception Errors
  • Creating Stored Procedures and Functions
Duration: 14:00 hrs
Oracle Database 10g: Developing PL/SQL Program Units

In this course you will learn:
  • PL/SQL Packages
  • Oracle-Supplied Packages and DBMS_SCHEDULER
  • Managing Dependencies
  • Manipulating Large Objects in PL/SQL
  • PL/SQL Triggers
  • Dynamic SQL and Metadata
Duration: 15:30 hrs
Oracle Database 10g: New Features

In this course you will learn:
  • Oracle Database 10g: New Installation and Configuration Features
  • Oracle Database 10g: New Data Loading Features
  • Oracle Database 10g: New Automatic Management Features
  • Oracle Database 10g: New Resource, Scheduling, and Task-Management Features
  • Oracle Database 10g: New Space Management Features
  • Oracle Database 10g: New Storage Features
  • Oracle Database 10g: New Tuning, Performance-monitoring, and Analysis Features
  • Oracle Database 10g: New Backup and Recovery Features
  • Oracle Database 10g: Using Flashback
  • Oracle Database 10g: New Features in Security and Software Maintenance
  • Oracle Database 10g: New Features in VLDB Support
  • Oracle Database 10g: Miscellaneous New Features
Duration: 31:00 hrs
Oracle Database 10g: Administration Workshop I Release 2

In this course you will learn:
  • Oracle Database 10g: Installing Oracle Database 10g Release 2
  • Oracle Database 10g: Creating Databases Release 2
  • Oracle Database 10g: Database Interfaces Release 2
  • Oracle Database 10g: Database Control and Storage Structures Release 2
  • Oracle Database 10g: Users and Security Release 2
  • Oracle Database 10g: Managing Schema Objects and Data Release 2
  • Oracle Database 10g: The SQL*Loader and PL/SQL Release 2
  • Oracle Database 10g: Oracle Net Services and Shared Servers Release 2
  • Oracle Database 10g: Monitoring and Maintenance Release 2
  • Oracle Database 10g: Managing Undo Data and Lock Conflicts Release 2
  • Oracle Database 10g: Managing Backup and Recovery Release 2
Duration: 29:50 hrs
Oracle Application Server 10g: Administration II

In this course you will learn:
  • OracleAS 10g: Managing Customized Topologies and Distributing Infrastructure Components
  • OracleAS 10g: High Availability
  • OracleAS 10g: Managing and Configuring Clusters
  • OracleAS 10g: Business Intelligence Component Management
  • OracleAS 10g: XML Applications, Web Services, and Monitoring
  • OracleAS 10g: Tuning and Reconfiguring the Middle Tier
  • OracleAS 10g: Backup and Recovery
Duration: 21:40 hrs
Oracle Database 10g

In this course you will learn:
  • Oracle Database 10g R2: SQL Tuning Course 1
  • Oracle Database 10g R2: SQL Tuning Course 2
  • Oracle Database 10g R2: SQL Tuning Course 3
  • Oracle Database 10g R2: SQL Tuning Course 4
  • Oracle Database 10g R2: SQL Tuning Course 5
  • Oracle Database 10g Performance Tuning: Tools and Techniques
  • Oracle Database 10g Performance Tuning: Tuning Data
  • Oracle Database 10g Performance Tuning: Tuning Infrastructure
  • Oracle Database 10g Performance Tuning: Instance Tuning
  • Oracle Database 10g Performance Tuning: Memory Management
  • Oracle Database 10g Performance Tuning: Performance Management
Duration: 41:20 hrs
Oracle Database Server 10g

In this course you will learn:
  • Migrating to Oracle DB 10g: Oracle Database Architectural Framework
  • Migrating to Oracle DB 10g: Schema Objects and Planning Migration
  • Migrating to Oracle DB 10g: Performing Migrations with OMWB
  • Migrating to Oracle DB 10g: Migrating and Testing Oracle Database
  • Migrating to Oracle DB 10g: Securing and Managing Oracle Database
  • Migrating to Oracle DB 10g: Oracle Database Backup and Recovery
Duration: 24:00 hrs
Oracle Development 10g

In this course you will learn:
  • Oracle Forms Developer 10g: Architectural Environment and Services
  • Oracle Forms Developer 10g: Building Internet Applications
  • Oracle Forms Developer 10g: Creating and Working with Form Elements
  • Oracle Forms Developer 10g: Working with Canvases and Triggers
  • Oracle Forms Developer 10g: Interacting with Form Components
  • Oracle Forms Developer 10g: Working with Validation and Navigation
  • Oracle Forms Developer 10g: Object Sharing, WebUtil, Multiple Forms
  • Oracle Forms Developer 10g: Query Builder Features
Duration: 32:00 hrs
Oracle Discoverer 10g

In this course you will learn:
  • OracleBI Discoverer Plus 10g: Queries
  • OracleBI Discoverer Plus 10g: Reports
  • OracleBI Discoverer Plus 10g: Calculations, Graphs, and Drills
  • OracleBI Discoverer Plus 10g: OLAP
  • OracleBI Discoverer Plus 10g: Viewer and Portlets
  • OracleBI Discoverer Admin 10g: Create EULs & Business Areas
  • OracleBI Discoverer Admin 10g: Work with LOVs, Items, & Folders
  • OracleBI Discoverer Admin 10g: Manage Items, Drills & Summaries
  • OracleBI Discoverer Admin 10g: Manage & Maintain EULs
  • OracleBI Discoverer Admin 10g: Advanced Administration
Duration: 29:50 hrs
Oracle Development

In this course you will learn:
  • Oracle Reports Developer 10g: Working with Oracle Reports Developer
  • Oracle Reports Developer 10g: Paper, Web Reports, and Templates
  • Oracle Reports Developer 10g: Working with the Data Model
  • Oracle Reports Developer 10g: Working with Layout Objects
  • Oracle Reports Developer 10g: Web and XML Report, Report Parameters
  • Oracle Reports Developer 10g: Matrix Reports, Triggers, SRW Package
  • Oracle Reports Developer 10g: OracleAS Reports Services, Guidelines
Duration: 28:00 hrs