Training

The primary objective of this course is to consider advanced subjects and techniques pertaining to the SQL database language. Even professionals experienced in other implementations of the industry-standard SQL language will benefit from the advanced and Oracle-specific features of SQL discussed in this course.

The purpose of this course is to equip database administrators to recognize, diagnose and remedy performance problems which might arise in the operation of the Oracle database server. Beyond reactive measures, proactive actions which can be taken to avoid performance issues before they arise or are recognized are also considered. 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.

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.

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.

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.

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

This course will teach participants relational database design and data modeling concepts.  This is a common starting point for the entire Oracle database training curriculum.

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.

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.

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.

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. 

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.

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.

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 point for Oracle database administrators and also sets the foundation for advanced administrator training and certification.

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.

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.

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

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.

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

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