Students attending this workshop enhance their skills in Oracle Application Express. Students examine topics on using application navigation to build site maps and dashboards. In addition, students learn about AJAX and Javascript and how these can be used in an APEX application.Students learn to...

Oracle Application Express is a rapid web application development tool for the Oracle database. This course is designed to introduce the students to Oracle Application Express 3.2. The course covers various Application Express components and wizards to build applications and database objects that...

This course advances your success as an Oracle professional in the area of database administration. In this class, you’ll learn how to configure an Oracle database for multilingual applications. You will practice various methods of recovering the database using RMAN and Flashback technology....

This course introduces students to the new features in Oracle Database 10g Release 2 – the database for Grid computing. Students learn how to use Oracle Database 10g new features to increase database availability, to simplify database performance monitoring and tuning through the use of...

This course is designed to give the experienced SQL Developer or DBA a firm foundation in SQL tuning techniques. The participant learns the necessary knowledge and skills to effectively tune SQL in the Oracle Database 10g Release 2. They learn about tuning methodology as well proactive tuning and...

The course starts with an unknown database that requires tuning. The lessons will proceed through the steps a DBA will perform to acquire the information needed to identify problem areas, to diagnose common problems, and remedy those problems....

In this course, students will learn about RAC database administration in the Oracle Grid Infrastructure environment. Students will learn to administer cluster databases using Enterprise Manager and command-line utilities like SRVCTL, CRSCTL,...

The goal of this course is to teach Database Administrators how to install the Oracle Database 11g software and perform the tasks required to manage an Oracle database. Enterprise Manager is used throughout to teach students how to quickly accomplish the required task. Emphasis is on the...

This course is your first step towards success as an Oracle professional, designed to give you a firm foundation in basic database administration. In this class, you’ll learn how to install and maintain an Oracle database. You will gain a conceptual understanding of the Oracle database...

This course takes the database administrator beyond the basic tasks covered in the first workshop. The student begins by gaining a much deeper understanding of possibly the most important job of a DBA - backup and recovery. The concepts and architecture that support backup and recovery, along with...

In this course, students learn how to use Oracle Data Guard to help protect their Oracle database against planned and unplanned downtimes. They also learn how Data Guard standby databases can be used to support production functions such as reporting, querying, and testing, while in a standby...

In this course, students learn the basic concepts of a data warehouse and study the issues involved in planning, designing, building, populating, and maintaining a successful data warehouse. Students learn to improve performance or manageability in a data warehouse using various Oracle Database...

This five-day classroom course gives you the opportunity to learn about and practice with the new change management features and other key enhancements in Oracle Database 11g Release 1 and Release 2. Topics covered include the benefits and use of the new features in managing change, diagnosing and...

Understanding the basic concepts of relational databases ensure refined code by developers. This course helps the participants to write subqueries, combine multiple queries into a single query using SET operators and report aggregated data...

This course starts with an introduction to PL/SQL and proceeds to list the benefits of this powerful programming language. Participants are made aware of how to create PL/SQL blocks of application code that can be shared by multiple forms,...

In this course, students learn how to design and build a variety of standard and custom Web and paper reports using Oracle Reports Developer. Working in the declarative environment of Reports Builder, students learn how to retrieve, display, and format data from any data source in numerous...

The Solaris(TM) 10 Containers Administration course provides a practical, hands-on, guided experience working with Sun’s virtualization capabilities, collectively known as Solaris Containers. Solaris(TM) Zones and Solaris Resource Controls combine to create Solaris(TM) Containers. In this...