Training

In this course, participants learn to use the advanced features of PL/SQL in order to design and tune PL/SQL to interface with the database and other applications in the most efficient manner. Using advanced features of program design, packages, cursors, and collections, students learn to write powerful PL/SQL programs. Hands-on lab exercises are used to reinforce discussions.

This Oracle 11g courseware training guide book will assist experienced Oracle database administrators to quickly learn the new features and concepts associated with the 11g release of the Oracle database. Based upon this knowledge one will be able to utilize these features and realize the benefits they bring.

This Oracle 11g courseware training guide book will present some of the most advanced features available to database developers.

This three day workshop uses the 'HANDS ON' approach to teach the participant the essential concepts of a relational database and programming using Structured Query Language(SQL).

As the complexity and sophistication of the enterprise-wide database platform for an organization grows, so does the need for a state-of-the-art backup and recovery strategy. Recovery of contemporary databases goes far beyond the relatively limited tasks of years ago. Traditional strategies involved protecting data against failure, and in the event of a failure, recovering all the lost data.

Today one needs to employ far more elaborate techniques. Regulatory compliance requirements call for data preservation through archival backups. Application testing and migration, among other scenarios, requires database duplication and cloning. Strategies to optimize and tune backup and recovery considering availability demands and large data volumes are also needed. And traditional problem-solving for data corruption, media failure, data loss and the like remain necessities.

This course considers the latest and most advanced elements of a robust backup and recovery strategy for the Oracle database platform. It is intended to allow a database administrator to become certified as a backup and recovery specialist.

This course brings database administrators beyond a basic understanding of their environment and to focus attention on more advanced skills needed to effectively configure, administer, monitor and tune the database within a large-scale enterprise.

This course allows the student to gain the skills necessary for day-today administration of an Oracle database. This course is the starting point for Oracle database administrators and also sets the foundation for advanced administrator training and certification.

Get the most out of your Database by learning performance tuning methods that maximize the utility of the database. Students learn how to benefit from Oracle Database automatic tuning features, as well as practicing the manual tuning methods. After clearly defining the various methodologies one can use to tune an Oracle Database, the course covers the various tunable components of an Oracle Database. Throughout the course, students experience hands-on the tuning of an Oracle Database by practicing through a series of workshops.

The objective of this course is to equip students to develop database server-side PL/SQL program units within an Oracle database.

The primary objective of this course is to provide an introduction to the PL/SQL database programming language, based upon the latest features available with the Oracle database. Syntax, structure and features of the language are discussed in the context of database applications and programming.

The primary objective of this course is to consider advanced subjects and techniques pertaining to the SQL database language, based upon the latest features available with the Oracle release. 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.

This course is a common starting point in our 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, based upon the latest features available.

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.

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.

This Oracle 11g courseware training guide book will assist experienced Oracle database administrators to quickly learn the new features and concepts associated with the 11g release of the Oracle database. Based upon this knowledge one will be able to utilize these features and realize the benefits they bring.