Connect with us:

Client Testimonials

"Instructions for labs were very good and helped to reinforce what was being taught. The instructor did an excellent job of using the labs to ensure that we had the necessary hands on experience to help us understand how to use the tools."

Student - Custom Testing Tools Course

View More Testimonials

Oracle 10g Training Courses

Course #	Course Name	Duration
DBOR-440	Oracle 10g Release 2 New Features Overview Training This training course is designed to provide students with the skills necessary to give a sound introduction to the prominent new features available with Oracle 10g. (Both Release 1 and Release 2 features are taught.) Students will also learn about upgrading to Oracle 10g. The primary objective of this training is to provide the students with an understanding of the intended purpose and use of the feature, while adding context from the instructor’s research and / or use of the feature. Most topics are discussed within the context of a working example, so students will have a head-start on implementation.	1 day
DBOR-445	Oracle 10g New Features for Administrators Training This training course is designed to provide the administrator with a practical introduction to upgrading to Oracle 10g and to the approximately 100 new administrative-related enhancements and features available with Oracle 10g. Both Release 1 and Release 2 of Oracle 10g are covered. In addition to DBA-related features, this training includes an overview of more than twenty-five SQL and PL/SQL enhancements offered with Oracle 10g.	4 days
DBOR-455	Oracle 10g SQL Tuning for Developers and DBA's Training This training course is designed to provide students with the skills necessary to create scalable, high performance SQL-based Oracle applications (proactive SQL tuning). They will also learn how to identify existing high-load, poor performing SQL statements and tune them (reactive SQL tuning). Particular attention is paid to making the best use of Oracle architecture, bench-marking various SQL formulations and identifying the best schema object (e.g. heap table, IOT, etc.) for a given situation. The course also includes a lesson on tuning PL/SQL programs such as using bulk processing and profiling to identify high-load statements.	3 days
DBOR-475	Oracle 10g Database Administration Training This training course is designed to provide students the skills necessary to create, maintain, and manage an Oracle10g database. Students will concentrate on the skills necessary for day-to-day database administration tasks such as security, creating, and managing users, creating and managing database objects (tablespaces, tables, indexes, etc.), running utilities, configuring Oracle networking, and simple backup, and recovery techniques. A fairly in-depth discussion of database architecture is also provided.	5 days
DBOR-610	Introduction to Oracle 10g for Developers Training This training course is designed for experienced application developers who are new to Oracle 10g database development. Students will learn the skills required to work as an application developer in an Oracle 10g database environment. At the core of these skills are Oracle's implementation of SQL and Oracle's database programming language, PL/SQL.	5 days
DBOR-615	Oracle 10g: New Features for Developers Training This training course is designed to teach students how to implement the new features provided with Oracle 10g. Both Oracle 10g Release 1 and Release 2 features are covered. An optional review of Oracle 9i features that may be new to many developers is available. Through evenly split lecture and hands-on workshops, students will gain a practical understanding of these features.	4 days
DBOR-620	Backup and Recovery with Oracle 10g RMAN Training This training course is designed for experienced Oracle technologists who need to use or evaluate Recovery Manager, Oracle's utility for backup and recovery. Personnel new to backup and recovery or those currently using user-managed backup techniques will benefit from this class. This Oracle10g compatible course is a comprehensive and practical introduction to RMAN including architecture, setup, backup, restore and recovery, recovery catalog maintenance, debugging, tuning and reporting. Every lesson contains many working examples and at least one hands-on workshop.	3 days
DBOR-625	High Availability Options in Oracle 10g Training This training course is designed to provide an overview of Oracle10g's High Availability (HA) capabilities for experienced Oracle System Architects and IT Administrators. Personnel new to HA concepts, those planning fault-tolerant database installations, and those currently using HA facilities from earlier Oracle releases will benefit from this class. This completely 10g-compatible course is a comprehensive and practical introduction to HA including types of redundancy, Oracle's HA offerings, failover considerations, system and application prerequisites, and example HA configurations. Each chapter contains many working examples and a discussion of pros and cons of each of Oracle's HA features.	1 day
DBOR-635	Oracle 8i to Oracle 10g Migration Overview Training This training course is designed for persons involved in migrating a database and/or database application from Oracle 8i to Oracle 10g. Students will learn about the Oracle 8i to Oracle 10g upgrade methods and the new features delivered with both Oracle 9i and Oracle 10g (including Oracle 10g Release 2 features).	2 days
DBOR-645	Oracle Wait-Event Performance Tuning Training This training course is designed to enable students to solve real performance problems using simple yet extremely powerful Oracle Database tuning techniques.	3 days
DBOR-701	Oracle 10g Basic SQL for Developers Training This training course is designed to give students a comprehensive introduction to Oracle’s implementation of the SQL language. Students will learn how to query and update an Oracle database, create simple database objects such as tables and views. This training course can be taught using SQL Navigator, SQL Plus, or TOAD for developers.	3 days
DBOR-702	Oracle 10g Advanced SQL for Developers Training This training course is designed to provide students, who already know the basics of Oracle SQL, with the skills necessary for proficiency in the more advanced topics. Included here are additional functions, handling many to many relationships and constraints. In addition, Oracle objects such as indexes, sequences and external tables are covered along with utilities including Import, Export and Copy. This training course can be taught using SQL Navigator,SQL Plus, or TOAD for developers.	3 days
DBOR-703	Oracle 10g Basic and Advanced SQL for Developers Training This training course is designed to provide a comprehensive introduction to Oracle’s implementation of the SQL language. Students will learn how to query and update an Oracle database, create simple database objects such as tables and views. Once the basics are mastered, this class covers the material needed to become proficient with the more advanced topics. Included here are additional functions, handling many to many relationships and constraints. In addition, Oracle objects such as indexes, sequences and external tables are covered along with utilities including Import, Export and Copy. This training course can be taught using SQL Navigator, SQL Plus, or TOAD for Developers.	5 days
DBOR-704	Oracle 10g PL/SQL for Developers Training This training course is designed to teach students the critical aspects of Oracle development including cursors, stored procedures and functions, triggers, error handling, packages and collection processing. This class is intended for those entering the world of Oracle application development with previous Oracle or other relational database experience. This training course can be taught using SQL Navigator,SQL Plus, or TOAD for developers.	3 days
DBOR-706	Oracle 10g Basic SQL for Testers and Business Analysts Training This Oracle course is designed to provide a comprehensive introduction to Oracle’s implementation of the SQL language and the common query tool, SQL/Navigator or Developer. The student will learn how to query and update an Oracle database, create simple database objects such as tables and views and to work proficiently with SQL/Navigator or Developer. This training course can be taught using SQL Navigator, SQL Plus, SQL Developer, or TOAD.	3 days
DBOR-715	Oracle 10g Discoverer Administrator Training This training course is designed to provide the skills to effectively administer Oracle’s Graphical User Interface (GUI) based data access tool and ad hoc query.	2 days
DBOR-725	Oracle Database 10g Security and Auditing for Auditors Training This training course is designed to provide the basics of the Structured Query Language, SQL*Plus (the 'query tool') and the general architecture, security and auditing of the database.	2 days
DBOR-730	Oracle 10g Database Administration Fast Track Training This training course is designed to provide identification of the most critical day-to-day tasks facing an Oracle Database Administrator and how to perform those tasks. In a task-based, 'fast-track' style, this training course teaches how to install software and create and manage Oracle databases. Oracle Enterprise Manager and line-mode (SQL*Plus) examples are provided.	4 days
DBOR-735	Oracle Concepts for Non-Programmers Training This training course is designed to provide instruction for end users, managers, help desk, technical and application support personnel, and any other non-programming staff working with an Oracle database but is not faced with the day-to-day task of programming.	1 day
DBOR-740	Oracle 10g/9i Forms Web Development Training This training course is designed to provide students with the instruction necessary for them to create, test and deploy efficient web-based applications using Oracle Forms.	5 days
DBOR-745	Oracle 10g Advanced Performance Tuning Training This training course is designed to provide students with the skills to fully harness the powerful new performance tuning and diagnostic tools in Oracle 10g. In this class, students will learn how to use the Oracle Enterprise Manager performance page, most notably how to interpret the “average active session” (AAS) chart to identify problems and then how to drill down to find resolution either through the Automatic Database Diagnostic Monitor (ADDM) or through direct investigation of the data in the drilldowns. Students will learn an invaluable lesson by learning what AAS is, how to interpret it, how see identify a problem and how to drill down for further analysis and resolution. This training will provide students with advanced detail on how the data is collected, aggregated, displayed and analyzed. This advanced knowledge will deepen the student’s understanding, giving students the ability to manually collect and analyze performance data independently of the Oracle 10g tools and features. This is particularly useful for persons tuning Oracle when auto-data collection is not available (for example Oracle8i, 9i, 10g Standard Edition or Enterprise Edition without the Management Packs installed). The training will include detailed explanations, analysis and solutions of the top thirty wait events. Some of these solutions are only possible with the revolutionary data collection technique of “active session history” (ASH). As with AAS, the training will demonstrate how to collect ASH manually on any version of Oracle (even Oracle9i) and how to analyze the collected data to solve performance bottlenecks. Hands-on case studies are included in the class. Students are provided workloads containing a performance issue. Students are tasked with using the provided performance tools to discover the root cause of the problem and recommend a solution. In summary, students will gain the necessary skills and knowledge to finally conquer their database woes, thus allowing more time and freedom while still looking brilliant to management and end-users.	2 days
DBOR-750	Oracle 10g Real Application Clusters (RAC) Administration Training This training course is designed to provide students with hands-on instruction in all aspects of Oracle 10g Real Application Clusters (RAC) administration. Students will begin with a solid foundation in Oracle Clusterware and RAC architecture. Students will then install and configure both Clusterware and the database software, as well as cover the administration of both pieces of software using command line utilities. Important topics such as failover, flashback, and backup and recovery are all covered in detail. Students will also get hands-on experience with Automatic Storage Management. The course ends with troubleshooting and tuning a RAC system.	5 days