Oracle Training and Courseware

WA1679 Oracle Database 10g: Performance Tuning

This course goes beyond basic automatic tuning techniques discussed elsewhere within our database administrator curriculum and covers the whole range of tuning issues, including manual database tuning techniques, host system tuning, network and listener tuning, and others.
More Info

WA1637 Introduction Oracle Database 10g: SQL

This course is a common starting point in the Oracle database curriculum for administrators, developers and business users. The objective of this course is to provide an introduction to the SQL database language within the context of an Oracle database.
More Info

WA1634 Oracle 11g New Features Overview

This one (1) day course gives students the opportunity to learn about the new features and enhancements in Oracle Database 11g Release 1 to help them plan their use of the Oracle 11g features. This instructor-led lecture is supported by appropriate and detailed demonstrations.
More Info

WA1633 Oracle 11g New Features for Developers

This one (1) day course gives students the opportunity to learn about and practice with the new developer-related features and enhancements in Oracle Database 11g Release 1. Students examine the benefits and use of the new features in hands-on practice sessions to reinforce their understanding of the new developer capabilities in Oracle Database 11g Release 1.
More Info

WA1632 Oracle 11g New Features for Administrators

This three (3) day course gives students the opportunity to learn about and practice with the new features and enhancements in Oracle Database 11g Release 1. Students examine the benefits and use of the new features in hands-on practice sessions to reinforce their understanding of the new capabilities in Oracle Database 11g Release 1.
More Info

WA1476 Oracle Database 10g: Program With PL/SQL Part II

The Oracle PL/SQL language provides for programming logic features not contained within SQL. The grammar, syntax and benefits of using the PL/SQL language within an Oracle database environment are considered.
More Info

WA1475 Oracle Database 10g: Program With PL/SQL Part I

WA1388 Oracle Reports 10g: Build Reports

Sophisticated graphical reports are possible with Oracle10g ODS Reports. This product is one of the most complex yet powerful graphical reporting tools available. With sufficient training, even some of the most complex reporting requirements can be satisfied using this tool. This course is presented in an intensive workshop format where participants absorb the complex topics of object hierarchies, frame hierarchies, field-level control of report output and many other subjects.
More Info

WA1387 Oracle Designer Data Modeling

This course considers all the features of building complex logical data models using sophisticated modeling techniques. Numerous ‘real-world’ problems and special situations are presented along with solutions. Classic structures and common models are also given to assist participants in rapidly completing a data model. Traditional modeling techniques as well as newer object-oriented modeling principles are presented providing state-of-the-art modeling skills to attendees. This course may be presented using the modeling syntax of Oracle Designer or independent of any specific modeling tool.
More Info

WA1386 Oracle Database 10g: SQL Tuning

This course will equip developers to build efficient SQL statements and to tune applications from the standpoint of an application developer. When this effort is complemented by database server and possibly PL/SQL application tuning, then a highly efficient environment has been built.
More Info

WA1385 Oracle Database 10g: New Features For Administrators

This course reviews all of the major administration features and improvements introduced with version 10g of the Oracle database Students will be able to apply their experience with previous releases of the Oracle database to this new release, which offers numerous productivity and manageability improvements
More Info

WA1384 Oracle Database 10g: New & Advanced Features For Developers

The purpose of this course is to present some of the most advanced features available to database developers. Many of these features are either newly available with the Oracle10g release or have been substantially improved with that release.
More Info

WA1383 Oracle Database 10g: Architecture for Developers

This is a special adaptation of the database architecture module normally presented to database administrators but customized for the benefit of developers. With a series of in-depth lectures developers are acquainted with the internal architecture of the Oracle database, including memory structures, data file structures, block and row internals. The objective is to provide developers with the skills needed to properly build and tune applications for optimum performance compatible with the architecture of the Oracle database.
More Info

WA1382 Oracle Database 10g: Advanced PL/SQL Programming & Tuning

The objective of this course is to allow experienced PL/SQL developers to write efficient programs. Advanced techniques which not only improve execution speed but also enhance the functionality of the programs are also discussed.
More Info

WA1381 Oracle Database 10g: Administration II

One of the most challenging tasks ever presented to database administrators is that of recovery from failure, especially if the recovery must not result in a loss of any data. This course presents all the standard failure scenarios and the best recovery strategies for each. Backup strategies for cold backups, on-line backups, complete and partial backups are discussed. Extensive exercises allow students to simulate failures and perform actual recovery within the workshop.
More Info

WA1380 Oracle Database 10g: Administration I

The overall objective of this course is to allow the reader to gain the skills necessary for basic day-to-day administration of an Oracle10g database. This course is the starting for Oracle database administrators and also sets the foundation for advanced administrator training and certification.
More Info

WA1379 Oracle AS Discoverer 10g Create Queries and Reports

This class will teach students the purpose and capabilities of the Discoverer 10g AS tool. Thereafter each user can learn to apply this knowledge to the company's internal data model.
More Info

WA1378 Oracle Application Server 10g: Administration I

This course begins with an in-depth architectural discussion of the Oracle10g Application Server product and the application architectures which are based upon this product. Thereafter, one learns the tasks for basic administration of this environment.
More Info

WA1377 Oracle 10g Forms III: New Features & Web Deployment

The objective of this course is to allow experienced Oracle Forms developers to maximize the performance of their applications in a web environment.
More Info

WA1376 Oracle 10g Forms I: Build Internet Applications

The objective of this course is provide application software developers with the skills to build enterprise-scale Internet applications using the Oracle10g ODS Forms product.
More Info

WA1375 Oracle 10g Designer Systems Analysis & Modeling

Building enterprise-wide system from sophisticated models is now possible with Oracle Designer technology. Participants will be equipped with the skills necessary to develop, maintain and certify process models, function models and data models along with their supporting structures. A complete, functional system will be developed over the course of the week-long seminar allowing participants to see first hand the productivity gains achieved with the tool. All the supporting tools and utilities are also considered, including the navigators, setting preferences and fine-tuning models. Once the models have been developed participants will learn how rapid prototypes can be generated using the Design Wizards.
More Info

WA1373 Oracle Database 10g: Introduction to SQL

This course is a common starting point in the Oracle database curriculum for administrators, developers and business users.
More Info

WA1276 Introduction to Oracle 9i: SQL

The foundation for all Oracle professionals is the SQL language along with Oracle's SQL*Plus extensions. A detailed consideration of these languages includes such topics as creating and maintaining table definitions in the data dictionary, specifying data types, manipulating tables and developing sophisticated queries quickly and accurately.
More Info