Training

Oracle 11g Training and Courseware

Popular Courses

Browse Our Free Resources

  • whitepapers
  • whitepapers
  • webinars
  • blogs

Our Locations

Training Centres

Vancouver, BC
Calgary, AB
Edmonton, AB
Toronto, ON
Ottawa, ON
Montreal, QC
Hunt Valley
Columbia

locations map

Calgary

550 6th Av SW
Suite 475
Calgary, AB
T2P 0S2

Toronto

821A Bloor Street West
Toronto, ON
M6G 1M1

Vancouver

409 Granville St
Suite 902
Vancouver, BC
V6C 1T2

U.S. Office

436 York Road
Suite 1
Jenkintown, PA
19046

Other Locations

Dallas, TX
Miami, FL

Home > Training > Oracle Database > Oracle 11g

WA1809 Oracle Database 11g R2: RMAN Backup & Recovery

All of the data within a database installation is at risk unless one has designed, tested and implemented a robust backup and recovery strategy. The objective of this training module is to assist you in doing just that. Furthermore, when a major failure occurs, a variety of recovery and troubleshooting techniques must be employed. The focus of this course is the Oracle Recovery Manager (RMAN) tool. Additional facilities covered include the Data Recovery Advisor, Redo Log File Size Advisor and MTTR Advisor. It is tempting to short-cut appropriate backup procedures if they perform poorly, so special attention is giving to performance optimization.

More Info

WA1808 Oracle Database 11g R2: Administration II

This course brings database administrators beyond a basic understanding of their duties and to transfer advanced skills needed to effectively administer an Oracle database installation within a large-scale enterprise. Important subject areas include advanced database configuration, performance monitoring and tuning, configuring for recovery, troubleshooting and fault diagnosis, and use of the extensive advisory framework. Sometimes configuration and operational problems can exist within an Oracle database installation because important technologies are either not fully understood or not properly implemented. Advanced technologies which should be applied to any mission-critical database installation. The Database Resource Manager is an essential tool for database tuning and achieving optimum performance, and is often used in combination with the advisors. The Database Scheduler is a sophisticated tool which can automate many administration tasks and integrate the database into the larger data center and systems infrastructure. All of the data within a database installation is at risk unless one has designed, tested and implemented a robust backup and recovery strategy. When a major failure occurs, a variety of recovery and troubleshooting techniques must be employed. The Oracle Recovery Manager (RMAN) tool is discussed with additional facilities including the Data Recovery Advisor, Redo Log File Size Advisor and MTTR Advisor. It is tempting to short-cut appropriate backup procedures if they perform poorly, so special attention is giving to performance optimization.

More Info

WA1807 Oracle Database 11g: Administration I

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.

More Info

WA1805 Oracle 11g Database Performance Tuning

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.

More Info

WA1737 Oracle Database 11g: PL/SQL Fundamentals II - Develop Program Units

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

More Info

WA1736 Oracle Database 11g: PL/SQL Fundamentals I

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.

More Info

WA1706 Oracle Database 11g: SQL Fundamentals II

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.

More Info

WA1705 Oracle Database 11g: SQL Fundamentals I

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.

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 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.

More Info

WA1911 SQL Programming Workshop

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).

More Info

WA1977 Oracle Database 11g R2 - New and Advanced Features For Developers

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

More Info

WA1978 Oracle Database 11g R1 and R2 - New Features For Administrators

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.

More Info

WA2081 Oracle 10g Advanced PL/SQL Programming

This advanced course helps PL/SQL programmers take advantage of language features, advanced techniques, and packages and facilities provided by Oracle® to develop and tune efficient and effective PL/SQL subprograms. Students will learn the fundamentals of the PL/SQL programming language. Students will write stored procedures, functions, packages, and triggers, and implement complex business rules in Oracle. Students will learn programming, management, and security issues of working with PL/SQL program units. Programming topics will include the built-in packages that come with Oracle, the creation of triggers, and stored procedure features.

More Info