iZone Learning Centre

Prerequisites
Experience in Oracle database administration; mastery of Associate level content for Oracle 10g; proficiency in programming with SQL and PL/SQL

Expected Duration (hours)
2.7

Lesson Objectives
Using Flashback Technology in Oracle 10g
• recognize situations that are suited to the use of Flashback Database.
• execute a Flashback Database operation.
• enable Flashback features and perform a Flashback Database operation.
• identify the recommended steps to perform a Flashback Table operation in a given scenario.
• identify the appropriate Flashback Query feature to be used for given scenarios.
• use Flashback features to audit and fix tables.
• use the Recycle Bin to perform a Flashback Drop operation and to purge items.
• determine suitable uses of appropriate Flashback features for given scenarios.

Course Number:
212481_eng

EXECUÇÃO E GESTÃO DE BACKUP’S EM ORACLE 10G - [212479_ENG]

Overview/Description
To outline the processes and considerations for using RMAN to perform and monitor backups

Target Audience
Oracle database administrators and database operators

Prerequisites
Experience in Oracle database administration; mastery of Associate level content for Oracle 10g; proficiency in programming with SQL and PL/SQL

Expected Duration (hours)
1.9

Lesson Objectives
Performing and Managing Backups in Oracle 10g
• identify the characteristics of an example RMAN command.
• use the RMAN command line to create basic backups.
• implement a suitable backup strategy in a given scenario.
• implement a suitable backup strategy in a given scenario.
• use appropriate commands to manage backups in RMAN.
• use RMAN commands to create and manage backups.

Course Number:
212479_eng

RECUPERAÇÃO E REPARO DE BASE DE DADOS EM ORACLE 10G - [212480_ENG]

Overview/Description
To outline the processes for recovering non-critical files, performing incomplete recoveries, and repairing corrupted components of databases

Target Audience
Oracle database administrators and database operators

Prerequisites
Experience in Oracle database administration; mastery of Associate level content for Oracle 10g; proficiency in programming with SQL and PL/SQL

Expected Duration (hours)
2.3

Lesson Objectives
Advanced Database Recovery and Repair in Oracle 10g
• distinguish between the steps to recover non-critical files.
• perform a suitable incomplete recovery in a given scenario.
• perform an appropriate incomplete recovery and recoveries of non-critical files in a given scenario.
• select the appropriate detection method for database corruption scenarios.
• rank appropriate steps and their associated procedures for using DBMS_REPAIR.
• use the BLOCKRECOVER command to restore data blocks.
• implement an appropriate recovery strategy for database corruption.

Course Number:
212480_eng

CONTROLO DO OUVINTE ORACLE E PERMISSÃO DE TRANSAÇÕES DISTRIBUÍDAS EM ORACLE 10G - [212478_ENG]

Overview/Description
To outline the concepts and processes to secure the Oracle listener and to work with remote and distributed transactions

Target Audience
Oracle database administrators and database operators

Prerequisites
Experience in Oracle database administration; mastery of Associate level content for Oracle 10g; proficiency in programming with SQL and PL/SQL

Expected Duration (hours)
2.2

Lesson Objectives
Controlling the Oracle Listener and Enabling Distributed Transactions in Oracle 10g
• set the listener password and specify who can access a database.
• improve the security for external procedures.
• tighten security for the Oracle 10g listener.
• use Net Services to connect to a database.
• create database links and view information about them.
• recognize situations when manual resolution of distributed transactions is required.
• use database links and transactions.

Course Number:
212478_eng

UTILIZAÇÃO DE APOIO GOLOBALIZADO EM ORACLE 10G - [212477_ENG]

Overview/Description
To outline the considerations and procedures for globalizing a database

Target Audience
Oracle database administrators and database operators

Prerequisites
Experience in Oracle database administration; mastery of Associate level content for Oracle 10g; proficiency in programming with SQL and PL/SQL

Expected Duration (hours)
2.2

Lesson Objectives
Using Globalization Support in Oracle 10g
• recognize how Oracle's architecture supports globalization features.
• recognize the appropriate NLS parameter to use in a given scenario.
• specify character sets and use appropriate datatypes to standardize timestamps across timezones.
• determine appropriate methods for implementing a globalization solution for a given database.
• use the appropriate method for configuring linguistic sorting in a given scenario.
• recognize suitable methods for implementing linguistic comparisons and case-insensitive searches, and distinguish between methods to display linguistic settings.
• use the appropriate methods to utilize linguistic support in a given scenario.

Course Number:
212477_eng

OPTIMIZAÇÃO DO DESEMPENHO DE BASE DE DADOS EM ORACLE 10G - [221273_ENG]

Overview/Description
To outline the processes and considerations for optimizing an Oracle database using alerts, trace files, and advisors

Target Audience
Oracle database administrators and database operators

Prerequisites
Experience in Oracle database administration; mastery of Associate level content for Oracle 10g; proficiency in programming with SQL and PL/SQL

Expected Duration (hours)
2.3

Lesson Objectives
Optimizing Database Performance in Oracle 10g
• view and configure alerts.
• identify situations when trace files and SQL tracing are useful.
• use Oracle Database 10g diagnostic tools to resolve database problems in a given scenario.
• recognize situations to run ADDM.
• recognize when to use the SQL Tuning Advisor and Access Advisor.
• use the Segment Advisor and Undo Advisor to implement appropriate space management settings.
• use appropriate Oracle advisor tools in given scenarios.

Course Number:
221273_eng

GESTÃO DO ARMAZENAMENTO E SISTEMA DE RECURSOS EM ORACLE 10G - [221274_ENG]

Overview/Description
To outline the processes and considerations for using the Automatic Storage Management and Database Resource Manager features

Target Audience
Oracle database administrators and database operators

Prerequisites
Experience in Oracle database administration; mastery of Associate level content for Oracle 10g; proficiency in programming with SQL and PL/SQL

Expected Duration (hours)
2.2

Lesson Objectives
Managing Storage and System Resources in Oracle 10g
• define the components of the Automatic Storage Management architecture in Oracle Database 10g.
• identify the processes associated with ASM instance administration, startup, and shutdown.
• create and manage disk groups.
• create a disk group and add a disk in a given scenario.
• create a basic database resource plan.
• recognize suitable Resource Manager configuration options to use in given scenarios.
• create and implement a resource management plan.

Course Number:
221274_eng

UTILIZAÇÃO DE UM PLANIFICADOR PARA AUTOMATIZAR TAREFAS EM ORACLE 10G - [221275_ENG]

Overview/Description
To outline the processes and considerations for using the Scheduler tool

Target Audience
Oracle database administrators and database operators

Prerequisites
Experience in Oracle database administration; mastery of Associate level content for Oracle 10g; proficiency in programming with SQL and PL/SQL

Expected Duration (hours)
2.2

Lesson Objectives
Using the Scheduler to Automate Tasks in Oracle 10g
• define the components of the Oracle Database 10g Scheduler and identify the SQL used to assign privileges to them.
• create jobs, programs, and schedules in Oracle Database 10g.
• create job classes, windows, and job priorities in Oracle Database 10g.
• create a job, job class, and window in Oracle Database 10g Enterprise Manager in a given scenario.
• use the GUI and code-based tools to manage Scheduler components in Oracle Database 10g.
• view information about jobs and purge jobs in Oracle Database 10g.
• use the appropriate tools in Enterprise Manager to drop a job, change Scheduler attributes, and view job details in a given scenario.

Course Number:
221275_eng

UTILIZAÇÃO DE FUNÇÕES AVANÇADAS EM ORACLE 10G - [221276_ENG]

Overview/Description
To outline the processes and considerations for using the advanced features of Oracle Database 10g

Target Audience
Oracle database administrators and database operators

Prerequisites
Experience in Oracle database administration; mastery of Associate level content for Oracle 10g; proficiency in programming with SQL and PL/SQL

Expected Duration (hours)
1.2

Lesson Objectives
Using Advanced Features in Oracle 10g
• identify the steps required to use the resumable statements feature.
• create an external table.
• create and configure materialized views.
• enable resumable statements and create external tables and materialized views.

Course Number:
221276_eng

BASE DE DADOS ORACLE 10G: FUNDAMENTOS SQL I E II

INTRODUÇÃO AO ORACLE E AO SQL NA BASE DE DADOS ORACLE 10G - [216104_ENG]

Overview/Description
To introduce Oracle as a relational database management system (RDBMS) and to demonstrate how to use basic SQL statements

Target Audience
Database administrators, application developers, and database operators

Prerequisites
Familiarity with RDBMS technologies and programming techniques

Expected Duration (hours)
3.3

Lesson Objectives
Introduction to Oracle and SQL in Oracle Database 10g
• identify the basic principles of the relational model for databases.
• identify how to use an entity relationship model to design a relational database.
• list the main features and functions of the Oracle Database 10g release.
• write basic SELECT statements for extracting data from a database.
• enhance SQL statements to refine query results.
• retrieve data from an Oracle 10g database using the SQL SELECT statement.
• interact with script files in iSQL*Plus.
• use iSQL* Plus in an Oracle 10g database to execute SQL statements and interact with script files.
• use the WHERE clause to restrict the data returned by a SQL statement.
• use the ORDER BY clause and substitution variables in SQL statements.
• restrict and sort data using WHERE and ORDER BY clauses and substitution variables.

Course Number:
216104_eng

FUNÇÕES SQL NA BASE DE DADOS ORACLE 10G - [216206_ENG]

Overview/Description
To describe how to use SQL functions for data retrieval

Target Audience
Database administrators, application developers, and database operators

Prerequisites
Familiarity with RDBMS technologies and programming techniques

Expected Duration (hours)
3.0

Lesson Objectives
SQL Functions in Oracle Database 10g
• use case and character-manipulation functions in SQL statements.
• use number and date functions in SQL statements.
• use number, character, and date functions to manipulate data values.
• identify the purpose of SQL datatype conversion functions in Oracle 10g.
• use the TO_CHAR conversion function with dates and numbers.
• use the TO_NUMBER and TO_DATE conversion functions.
• use conversion functions to convert values in SQL statements.
• use general functions in SQL statements.
• use conditional expressions in SQL statements.
• use general and conditional functions in SQL statements.

Course Number:
216206_eng

INICIAÇÃO DE MÚLTIPLAS TABELAS DE DADOS E UTILIZAÇÃO DE OPERADORES AJUSTADOS NA BASE DE DADOS ORACLE 10G - [216164_ENG]

Overview/Description
To demonstrate how to retrieve data from multiple tables using joins and how to use set operators in Oracle 10g databases

Target Audience
Database administrators, application developers, and database operators

Prerequisites
Familiarity with RDBMS technologies and programming techniques

Expected Duration (hours)
2.2

Lesson Objectives
Displaying Multiple Table Data and Using Set Operators in Oracle Database 10g
• retrieve records using the NATURAL JOIN and USING clauses.
• retrieve data by creating joins with the ON clause.
• use outer joins and generate Cartesian products.
• use joins to retrieve data from multiple tables.
• write SQL queries using set operators.
• identify how to comply with rules for using set operators.
• use the UNION, UNION ALL, INTERSECT, and MINUS operators in SQL queries

Course Number:
216164_eng

GRUPO E FUNÇÕES DE DATETIME NA BASE DE DADOS ORACLE 10G - [216205_ENG]

Overview/Description
To demonstrate how to use group and datetime functions in Oracle 10g

Target Audience
Database administrators, application developers, and database operators

Prerequisites
Familiarity with RDBMS technologies and programming techniques

Expected Duration (hours)
3.2

Lesson Objectives
Group and Datetime Functions in Oracle Database 10g
• retrieve data using group functions.
• write SQL queries that group and restrict output rows.
• write SQL queries that use group functions, the GROUP BY clause, and the HAVING clause
• use the ROLLUP and CUBE operations and the GROUPING function in SQL queries.
• use the GROUPING SETS function and specify composite columns and concatenated grouping sets.
• write queries using ROLLUP and CUBE operators, GROUPING functions, and GROUPING SETS.
• set time zone values and retrieve date and time values.
• use date-related datatypes.
• use date-related functions in Oracle 10g.
• write SQL queries using datetime functions.

Course Number:
216205_eng

SUBQUERIES E CONSULTAS DE HIERARQUIAS NA BASE DE DADOS ORACLE 10G - [223292_ENG]

Overview/Description
To demonstrate how to use subqueries and hierarchical queries in Oracle 10g

Target Audience
Database administrators, application developers, and database operators

Prerequisites
Familiarity with RDBMS technologies and programming techniques

Expected Duration (hours)
2.2

Lesson Objectives
Subqueries and Hierarchical Queries in Oracle Database 10g
• write single-row and multiple-row subqueries.
• use subqueries to solve queries in an Oracle database.
• write multiple-column, scalar, and correlated subqueries.
• use the EXISTS, UPDATE, DELETE, and WITH clauses.
• solve problems using multiple-column, correlated, and scalar subqueries and using the WITH clause.
• use hierarchical queries to create tree-structured reports.
• write hierarchical queries.

Course Number:
223292_eng

EXPRESSÕES REGULARES E ACESSO A UTILIZADORES NA BASE DE DADOS ORACLE 10G - [223293_ENG]

Overview/Description
To demonstrate how to use regular expression support and control user access in Oracle 10g

Target Audience
Database administrators, application developers, and database operators

Prerequisites
Familiarity with RDBMS technologies and programming techniques

Expected Duration (hours)
1.9

Lesson Objectives
Regular Expressions and User Access in Oracle Database 10g
• identify how to use regular expression support in SQL.
• use regular expression functions to search, match, and replace strings.
• use regular expression support to search for and manipulate strings.
• create users, grant system privileges, assign roles, and change passwords.
• grant, pass on, confirm, and revoke object privileges.
• write SQL statements to control user access to an Oracle database.

Course Number:
223293_eng

CRIAÇÃO E GESTÃO DE TABELAS E CONDICIONALISMOS NA BASE DE DADOS ORACLE 10G - [223294_ENG]

Overview/Description
To demonstrate how to create and manage tables and constraints in Oracle 10g

Target Audience
Database administrators, application developers, and database operators

Prerequisites
Familiarity with RDBMS technologies and programming techniques

Expected Duration (hours)
2.0

Lesson Objectives
Creating and Managing Tables and Constraints in Oracle Database 10g
• create simple tables in Oracle 10g.
• modify table structure and drop tables.
• create, modify, and drop a table.
• create table constraints.
• manage constraints in an Oracle 10g database.
• create and manage table constraints.

Course Number:
223294_eng

OBJECTOS DE BASE DE DADOS NA BASE DE DADOS ORACLE 10G - [223295_ENG]

Overview/Description
To demonstrate how to create database views, sequences, indexes, and synonyms

Target Audience
Database administrators, application developers, and database operators

Prerequisites
Familiarity with RDBMS technologies and programming techniques

Expected Duration (hours)
1.9

Lesson Objectives
Database Objects in Oracle Database 10g
• create simple and complex views in Oracle 10g.
• modify, remove, and perform DML operations on views.
• create and modify views in Oracle 10g.
• use sequences in Oracle 10g.
• create and remove indexes and synonyms.
• create a sequence, index, and synonym.

Course Number:
223295_eng

GESTÃO DE OBJECTOS DE BASE DE DADOS NA BASE DE DADOS ORACLE 10G - [223296_ENG]

Overview/Description
To demonstrate how to create external tables and to use the data dictionary views in Oracle 10g

Target Audience
Database administrators, application developers, and database operators

Prerequisites
Familiarity with RDBMS technologies and programming techniques

Expected Duration (hours)
1.8

Lesson Objectives
Managing Database Objects in Oracle Database 10g
• create external tables and identify how to query them.
• create and query external tables in Oracle 10g.
• view information about user objects, tables, and columns using data dictionary views.
• query the dictionary views for object, table, and column information.
• view information about constraints, views, sequences, synonyms, and comments using data dictionary views.
• query the data dictionary view for information about constraints, views, sequences, synonyms, and comments.

Course Number:
223296_eng

MANIPULAÇÃO DE DADOS NA BASE DE DADOS ORACLE 10G - [223297_ENG]

Overview/Description
To demonstrate how to modify rows, control database transactions, and manage large data sets and multitable statements

Target Audience
Database administrators, application developers, and database operators

Prerequisites
Familiarity with RDBMS technologies and programming techniques

Expected Duration (hours)
2.8

Lesson Objectives
Manipulating Data in Oracle Database 10g
• insert rows into a table.
• update and delete rows in a table.
• insert, update, and delete data.
• control data changes and identify how read consistency is implemented.
• control data changes using the COMMIT, SAVEPOINT, and ROLLBACK statements.
• manipulate data in Oracle 10g by using subqueries.
• use various types of multitable inserts.
• use the MERGE statement and the Flashback Version Query feature.
• perform multitable INSERT and MERGE operations, and track row versions.

Course Number:
223297_eng

BASE DE DADOS ORACLE 10G: PROGRAMAÇÃO COM PL/SQL I

INTRODUÇÃO AO PL/SQL - [216518_ENG]

Overview/Description
To introduce PL/SQL and provide an introduction to identifiers and variables in PL/SQL

Target Audience
Database administrators, application developers, and database operators

Prerequisites
Familiarity with Oracle Database 10g database technology; an understanding of the basic concepts of relational databases and the SQL programming language; ability to write queries against single and multiple tables, manipulate data in tables, create database objects, and query metadata

Expected Duration (hours)
2.2

Lesson Objectives
Introduction to PL/SQL
• recognize the correct structure of a PL/SQL program block.
• use iSQL*Plus to display the output of a PL/SQL anonymous block.
• declare and initialize a variable in a given scenario.
• declare and initialize scalar data types and Boolean variables.
• declare and initialize scalar types.
• use bind and substitution variables and the DEFINE command to assign values in PL/SQL code.
• match the composite and LOB data types with their associated functionality.
• pass runtime values in and out of PL/SQL code.

Course Number:
216518_eng

UTILIZAÇÃO DE PL/SQL COM SERVIDOR ORACLE - [216530_ENG]

Overview/Description
To write lexical units in their correct format in a PL/SQL block, perform data conversion in PL/SQL, write PL/SQL anonymous blocks, and recognize the correct structure of a PL/SQL program block

Target Audience
Database administrators, application developers, and database operators

Expected Duration (hours)
2.0

Lesson Objectives
Using PL/SQL with an Oracle Server
• write lexical units in their correct format in a PL/SQL block.
• perform data conversion in PL/SQL.
• use qualifiers to access and evaluate variables in PL/SQL blocks.
• convert and evaluate variables in PL/SQL.
• use a SELECT statement in a PL/SQL block to retrieve data from a database.
• use implicit SQL cursor attributes to determine the outcome of DML commands.
• use PL/SQL to perform database operations and use SQL cursor attributes to evaluate results.

Course Number:
216530_eng

UTILIZAÇÃO DE ESTRUTURAS DE CONTROLO - [217616_ENG]

Overview/Description
To implement a suitable conditional control statement in PL/SQL, simple and searched CASE expressions, and a suitable loop construct

Target Audience
Database administrators, application developers, and database operators

Expected Duration (hours)
1.9

Lesson Objectives
Using Control Structures
• implement a suitable conditional control statement in PL/SQL for a given scenario.
• implement simple and searched CASE expressions and statements in PL/SQL.
• identify the situations that can cause errors when handling nulls in PL/SQL.
• implement suitable control structures in PL/SQL.
• implement a suitable loop construct in PL/SQL for a given scenario.
• identify the characteristics of FOR and nested loops in PL/SQL.
• implement suitable loop structures in PL/SQL.

Course Number:
217616_eng

UTILIZAÇÃO DE TIPOS DE DADOS COMPOSTOS - [216540_ENG]

Overview/Description
To identify the benefits associated with records and collections, declare and initialize nested tables and VARRAYs, and create and reference an INDEX BY table and table of records

Target Audience
Database administrators, application developers, and database operators

Expected Duration (hours)
2.0

Lesson Objectives
Using Composite Data Types
• identify the benefits associated with records and collections in PL/SQL.
• create and populate a user-defined record in PL/SQL.
• create a record using the %ROWTYPE attribute and use it to insert and update a row.
• create a record and use it to update a table.
• create and reference an INDEX BY table and table of records.
• declare and initialize nested tables and VARRAYs.
• create and reference a table in PL/SQL.

Course Number:
216540_eng

CURSORES EXPLICITOS E ERROS EXCEPCIONAIS - [216554_ENG]

Overview/Description
To use the FOR UPDATE and WHERE CURRENT OF clauses to lock and modify rows, process data using records and cursors, and outline how each of the PL/SQL exception types are raised and handled

Target Audience
Database administrators, application developers, and database operators

Expected Duration (hours)
3.1

Lesson Objectives
Explicit Cursors and Exception Errors
• use explicit cursors to retrieve data.
• process data using records, cursor attributes, and cursor FOR loops.
• use parameters to make cursors reusable in a given scenario.
• use the FOR UPDATE and WHERE CURRENT OF clauses to lock and modify rows.
• use an explicit cursor to retrieve and update data.
• outline how each of the PL/SQL exception types are raised and handled.
• trap predefined and non-predefined exceptions in PL/SQL.
• trap user-defined exceptions and identify error codes and messages.
• use nested blocks and the RAISE_APPLICATION_ERROR procedure when handling exceptions in PL/SQL.
• handle exceptions in PL/SQL.

Course Number:
216554_eng

CRIAÇÃO DE ARMANEZAMENTO DE PROCEDIMENTOS E FUNÇÕES - [216563_ENG]

Overview/Description
To create and execute a stored function and call, and remove and view stored functions in PL/SQL

Target Audience
Database administrators, application developers, and database operators

Expected Duration (hours)
2.8

Lesson Objectives
Creating Stored Procedures and Functions
• create, remove, and view PL/SQL stored procedures.
• use IN, OUT, and IN OUT parameter modes to pass values to and from stored procedures and programs.
• outline how to view values returned by OUT parameters.
• create stored procedures with suitable parameters.
• assign values to multiple parameters in a stored procedure and invoke that procedure.
• handle exceptions in stored procedures.
• execute a stored procedure in which you have assigned parameter values and handled exceptions.
• create and execute a stored function.
• call, remove, and view stored functions in PL/SQL.
• create, call, and remove stored functions in PL/SQL.

Course Number:
216563_eng

BASE DE DADOS ORACLE 10G: DESENVOLVIMETO DE UNIDADES DE PROGRAMA PL/SQL

PACOTES PL/SQL - [216687_ENG]

Overview/Description
To create and work with Oracle 10g packages

Target Audience
Database administrators, application developers, and database operators

Prerequisites
Familiarity with Oracle Database 10g database technology; an understanding of the basic concepts of relational databases, the SQL programming language, and stored procedures; ability to write queries against single and multiple tables, manipulate data in tables, create database objects, and query metadata

Expected Duration (hours)
2.8

Lesson Objectives
PL/SQL Packages
• recognize the structure of a package and outline the visibility of its components.
• create a package in PL/SQL for a given scenario.
• select the code required to invoke a package subprogram and view and remove packages in PL/SQL.
• create, invoke, and view a package.
• use PL/SQL overloading and the standard package to declare and access subprograms.
• implement a forward declaration in a PL/SQL package and initialize package variables.
• identify the functions of the PL/SQL wrapper and the features of the wrapped code.
• overload a subprogram in a package, initialize package variables, and wrap PL/SQL code.
• outline the role of package functions and identify the restrictions associated with calling package and stored functions from SQL expressions.

Course Number:
216687_eng

PACOTES DE ORACLE-SUPPLIED E DBMS_SCHEDULER - [216700_ENG]

Overview/Description
To use Oracle-supplied packages

Target Audience
Database administrators, application developers, and database operators

Expected Duration (hours)
2.8

Lesson Objectives
Oracle-Supplied Packages and DBMS_SCHEDULER
• use the DBMS_OUTPUT package to send a message from a subprogram and a trigger.
• use the UTL_FILE package to access and modify a text file in a given scenario.
• generate and invoke an HTML document using the HTP package in iSQL*Plus.
• install the UTL_MAIL package and use it to send mail.
• use the UTL_FILE, HTP, and UTL_MAIL packages to interact with system files, generate HTML, and send mail.
• identify the architectural components of DBMS_SCHEDULER and recognize their associated features and functionality.
• use DBMS_SCHEDULER procedures to create a job.
• use DBMS_SCHEDULER to schedule, manage, and view a job.
• create and administer jobs using DBMS_SCHEDULER.

Course Number:
216700_eng

DEPENDÊNCIAS DE CONTROLO - [216717_ENG]

Overview/Description
To manage dependencies and recompile PL/SQL units

Target Audience
Database administrators, application developers, and database operators

Expected Duration (hours)
1.4

Lesson Objectives
Managing Dependencies
• retrieve local dependency information for a given scenario.
• set an appropriate remote dependency mode in a given scenario.
• display and interpret local dependency information and set a remote dependency mode.
• explicitly recompile a PL/SQL program unit and recognize when a recompilation is successful.
• identify the best practices used to minimize recompilation and simplify dependency management between packages and standalone procedures.

Course Number:
216717_eng

MANIPULAÇÃO DE OBJECTOS DE GRANDE TAMANHO EM PL/SQL - [216725_ENG]

Overview/Description
To use LOBs and the DBMS_LOB package

Target Audience
Database administrators, application developers, and database operators

Expected Duration (hours)
1.9

Lesson Objectives
Manipulating Large Objects in PL/SQL
• associate internal and external LOBs with their corresponding data types and interfaces and distinguish between the features of external and internal LOB components.
• create a DIRECTORY object and initialize and populate a BFILE data type.
• reference and update a BFILE data type.
• associate DBMS_LOB mutators and observers with their corresponding functions and procedures and outline the rules associated with using DBMS_LOB routines.
• initialize, insert, and update LOB columns and content using SQL and the DBMS_LOB package.
• create and test a temporary LOB and remove LOB values.
• initialize, update, and remove LOBs.

Course Number:
216725_eng

TRIGGERS PL/SQL - [216739_ENG]

Overview/Description
To create and manage triggers

Target Audience
Database administrators, application developers, and database operators

Expected Duration (hours)
3.8

Lesson Objectives
PL/SQL Triggers
• identify the function, benefits, and enhancements provided by triggers in PL/SQL.
• distinguish between DML row and statement triggers and the way that they execute and associate the main types of DML trigger timing with the instances in which each is used.
• identify the differences between the features of database triggers and those of stored procedures and Oracle's Forms triggers.
• specify the code required to create a DML statement trigger for a given scenario.
• specify the code required to create a DML row trigger and use a DML row trigger to implement an integrity constraint.
• specify the code required to create an INSTEAD OF trigger.
• create DML and INSTEAD OF triggers.
• specify the code required to create a trigger on a DDL statement and a system event.
• specify the code required to invoke a procedure in a trigger using a CALL statement and identify the rules that enable triggers to read and write data to a mutating table.
• specify the code required to view trigger information and manage trigger code for a given scenario.
• identify the best practices associated with testing trigger code.
• create and manage triggers in a given scenario.
• develop a suitable trigger for a given scenario.
Course Number:
216739_eng

SQL DINÂMICOS E METADADOS - [218842_ENG]

Overview/Description
To write dynamic SQL and use the DBMS_METADATA package

Target Audience
Database administrators, application developers, and database operators

Expected Duration (hours)
2.2

Lesson Objectives
Dynamic SQL and Metadata
• identify the execution flow of SQL and distinguish between the PL/SQL statements used to support Native Dynamic SQL.
• use EXECUTE IMMEDIATE to dynamically build DDL and DML statements.
• write and execute dynamic SQL queries and PL/SQL blocks.
• use the DBMS_SQL package to dynamically execute a DML statement.
• write dynamic SQL for a given scenario.
• use the DBMS_METADATA programming interface to generate DDL from metadata.
• generate DDL from metadata using the DBMS_METADATA browsing interface.
• generate DDL from metadata using the DBMS_METADATA package.

Course Number:
218842_eng

BASE DE DADOS ORACLE 10G: NOVAS FUNCIONALIDADES

BASE DE DADOS ORACLE 10G: NOVA INSTALAÇÃO E CONFIGURAÇÃO DE FUNCIONALIDADES - [210040_ENG]

Overview/Description
To discuss the new installation and configuration features of Oracle 10g

Target Audience
Oracle 8i or 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g

Prerequisites
Experience in the administration of Oracle 8i or 9i databases

Expected Duration (hours)
2.3

Lesson Objectives
Oracle Database 10g: New Installation and Configuration Features
• identify the products and components of the Oracle 10g grid computing infrastructure.
• identify the installation improvements to Oracle Database 10g.
• identify the key grid and installation features of Oracle 10g and make the necessary installation considerations in a given scenario.
• identify the key upgrades to the Database Configuration Assistant (DBCA) in Oracle 10g.
• identify the key areas of the new Enterprise Manager GUI and use some of its new deployment features.
• use the new features of Enterprise Manager to review database feature usage, manage policies, and modify initialization parameters.
• launch and use the new features of Oracle 10g Enterprise Manager.

Course Number:
210040_eng

BASE DE DADOS ORACLE 10G: NOVAS CARACTERISTICAS DE CARREGAMENTO DE DADOS - [210050_ENG]

Overview/Description
To discuss new data loading features in Oracle 10g

Target Audience
Oracle 8i or 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g

Prerequisites
Experience in the administration of Oracle 8i or 9i databases

Expected Duration (hours)
2.0

Lesson Objectives
Oracle Database 10g: New Data Loading Features
• take the preparatory steps for transporting tablespaces from one platform to another in Oracle 10g.
• identify the key processes and file issues associated with Oracle Database 10g Data Pump.
• use the code that allows you to import and export data with Oracle Database 10g Data Pump.
• perform a data-only unload of data in Oracle 10g.
• populate an external table and project column data in Oracle Database 10g.
• perform an external table population in Oracle Database 10g in a given scenario.

Course Number:
210050_eng

BASE DE DADOS ORACLE 10G: NOVA GESTÃO DE RECURSOS AUTOMÁTICOS - [210057_ENG]

Overview/Description
To identify the new automatic management and management infrastructure features of Oracle 10g

Target Audience
Oracle 8i or 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g

Prerequisites
Experience in the administration of Oracle 8i or 9i databases

Expected Duration (hours)
3.2

Lesson Objectives
Oracle Database 10g: New Automatic Management and Management Infrastructure Features
• work with the Automatic Database Diagnostic Monitor (ADDM) in Oracle Database 10g.
• perform the tasks and calculations associated with the configuration and management of Automatic Shared Memory Management in Oracle Database 10g.
• view Automatic Database Diagnostic Monitor (ADDM) findings and manage shared memory in Oracle Database 10g in a given scenario.
• perform the key tasks associated with Oracle Database 10g's new statistics collection feature.
• use the appropriate code to lock and view automatically gathered statistics in Oracle Database 10g.
• identify the key components and concepts of Oracle 10g's new Automatic Workload Repository (AWR) feature.
• set AWR statistics capturing and snapshot purging in Oracle Database 10g.
• perform the tasks in a typical advisor tuning session in Oracle Database 10g.
• manually invoke the ADDM advisor to analyze an Oracle system in a given scenario.
• identify the alert process and alert types in Oracle Database 10g.
• set alerts and view metrics and server alert information in Oracle Database 10g.
• change an alert threshold and edit a notification rule in a given scenario in Oracle Database 10g.

Course Number:
210057_eng

BASE DE DADOS ORACLE 10G: NOVOS RECURSOS, PROGRAMAÇÃO E TAREFA DE GESTÃO DE RECURSOS - [210074_ENG]

Overview/Description
To identify the new resource, scheduling, and task-management features of Oracle 10g

Target Audience
Oracle 8i or 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g

Prerequisites
Experience in the administration of Oracle 8i or 9i databases

Expected Duration (hours)
3.2

Lesson Objectives
Oracle Database 10g: New Resource, Scheduling, and Task-Management Features
• use the new resource-plan timeout and session mapping features of Resource Manager in Oracle Database 10g.
• use the new group switching and CPU allocation features of Resource Manager in Oracle Database 10g.
• set idle time outs for a consumer group and create a mapping between a consumer group and a session attribute in Oracle Database 10g.
• define the components of the Oracle Database 10g Scheduler and identify the SQL used to assign privileges to them.
• create jobs, programs, and schedules in Oracle Database 10g.
• create job classes, windows, and job priorities in Oracle Database 10g.
• create a job class, job, and window in Oracle 10g Enterprise Manager in a given scenario.
• use the GUI and code-based tools to manage Scheduler components in Oracle Database 10g.
• use the tools to manage Scheduler component attributes and global attributes in Oracle Database 10g.
• view information about jobs and purge jobs in Oracle Database 10g.
• manage and view Scheduler components in Oracle Database 10g in a given scenario.

Course Number:
210074_eng

BASE DE DADOS ORACLE 10G: NOVO ESPAÇO DE GESTÃO DE RECURSOS
- [210086_ENG]

Overview/Description
To identify the new space management features of Oracle 10g

Target Audience
Oracle 8i or 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g

Prerequisites
Experience in the administration of Oracle 8i or 9i databases

Expected Duration (hours)
2.3

Lesson Objectives
Oracle Database 10g: New Space Management Features
• identify the new features of undo management and their functions in Oracle Database 10g.
• set tablespace space usage thresholds in Oracle Database 10g.
• set a space usage threshold for a tablespace in a given scenario in Oracle Database 10g.
• use the appropriate code to define sorted hash clusters in Oracle Database 10g.
• perform a segment shrink operation in Oracle Database 10g.
• access the tools used to optimize segment space in Oracle Database 10g.
• perform a segment shrink operation in a given scenario in Oracle Database 10g.

Course Number:
210086_eng

BASE DE DADOS ORACLE 10G: NOVAS CARACTERÍSTICAS DE ARMAZENAMENTO - [210095_ENG]

Overview/Description
To identify the new storage features of Oracle Database 10g

Target Audience
Oracle 8i or 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g

Prerequisites
Experience in the administration of Oracle 8i or 9i databases

Expected Duration (hours)
3.0

Lesson Objectives
Oracle Database 10g: New Storage Features
• use the tools to manage the SYSAUX tablespace and its occupants in Oracle Database 10g.
• rename a tablespace and define a default permanent tablespace in Oracle Database 10g.
• identify the code used to copy and transfer database files in Oracle Database 10g.
• move a tablespace occupant and edit the tablespace properties in a given scenario in Oracle Database 10g using EM.
• differentiate the components of the new Automatic Storage Management (ASM) architecture in Oracle Database 10g.
• identify the processes associated with ASM instance administration, startup, and shutdown.
• follow the GUI-based and code-based steps to administer disk groups in Oracle Database 10g.
• use the appropriate commands and views to administer Automatic Storage Management (ASM) files and templates in Oracle Database 10g.
• create a disk group and add a disk in Oracle Database 10g in a given scenario.

Course Number:
210095_eng

BASE DE DADOS ORACLE 10G: AJUSTAMENTO, ACOMPANHAMENTO DE DESEMPENHO E ANÁLISE DE FUNCIONALIDADES - [220637_ENG]

Overview/Description
To use Oracle 10g's new tuning, performance-monitoring, and analysis features

Target Audience
Oracle 8i or 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g

Prerequisites
Experience in the administration of Oracle 8i or 9i databases

Expected Duration (hours)
3.0

Lesson Objectives
Oracle Database 10g: New Tuning, Performance-monitoring, and Analysis Features
• identify how to use the new optimizer statistics in Oracle Database 10g.
• use the SQL Tuning Advisor in a given scenario.
• use the SQL Access Advisor in a given scenario.
• recognize how Oracle 10g database performance is monitored.
• use the SQL Tuning Advisor and the SQL Access Advisor in a given scenario.
• use MERGE and partitioned outer joins in a given scenario.
• use group mapping in interrow calculations in a given scenario.
• recognize materialized view operations in a given scenario.
• use analytical calculations and fast refresh capabilities in a given scenario.

Course Number:
220637_eng

BASE DE DADOS ORACLE 10G: NOVO BACKUP E RECUPERAÇÃO DE FUNCIONALIDADES - [220638_ENG]

Overview/Description
To use Oracle 10g's new backup and recovery features

Target Audience
Oracle 8i or 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g

Prerequisites
Experience in the administration of Oracle 8i or 9i databases

Expected Duration (hours)
2.3

Lesson Objectives
Oracle Database 10g: New Backup and Recovery Features
• recognize flash backup and recovery in Oracle Database 10g.
• use new features associated with incremental backups in a given scenario.
• maintain backups in Oracle Database 10g in a given scenario.
• recognize simplified recovery, database dropping, and enhanced RMAN scripts.
• implement backup and recovery with Oracle Database 10g in a given scenario.
• create and manage compressed backups in a given scenario.
• manage backup operations in a given scenario.

Course Number:
220638_eng

BASE DE DADOS ORACLE 10G: UTILIZAÇÃO DE FLASHBACK - [220639_ENG]

Overview/Description
To recognize Oracle 10g's Flashback technology and use Flashback features

Target Audience
Oracle 8i or 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g

Prerequisites
Experience in the administration of Oracle 8i or 9i databases

Expected Duration (hours)
2.3

Lesson Objectives
Oracle Database 10g: Using Flashback
• recognize flashback technology and its features.
• use Flashback Database in a given scenario.
• use Enterprise Manager to flash back a dropped table in a given scenario.
• use Flashback Database and Flashback Drop in a given scenario.
• use Flashback Versions Query and Flashback Transaction Query in a given scenario.
• use Flashback Table in a given scenario.
• use Flashback Versions Query and Flashback Table in a given scenario.

Course Number:
220639_eng

BASE DE DADOS ORACLE 10G: NOVAS FUNCIONALIDADES EM SEGURANÇA E NA MANUTENÇÃO DE SOFTWARE - [220640_ENG]

Overview/Description
To use the new security and software upgrade features in Oracle 10g

Target Audience
Oracle 8i or 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g

Prerequisites
Experience in the administration of Oracle 8i or 9i databases

Expected Duration (hours)
2.7

Lesson Objectives
Oracle Database 10g: New Features in Security and Software Maintenance
• create a column-level VPD policy in a given scenario.
• identify the policy type to use in a given scenario.
• create a fine-grained auditing policy in a given scenario.
• create a column-level VPD policy and a fine-grained auditing policy in a given scenario.
• point out why a column-level VPD policy and a fine-grained auditing policy are incorrect in a given scenario.
• use the Database Upgrade Assistant to perform a database upgrade to Oracle Database 10g in a given scenario.
• identify the order of the principal tasks required to manually upgrade a database to Oracle Database 10g.
• upgrade a database to Oracle Database 10g using Database Upgrade Assistant in a given scenario.

Course Number:
220640_eng

BASE DE DADOS ORACLE 10G: NOVAS FUNCIONALIDADES EM APOIO VLDB - [220641_ENG]

Overview/Description
To use Oracle 10g's new VLDB support features

Target Audience
Oracle 8i or 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g

Prerequisites
Experience in the administration of Oracle 8i or 9i databases

Expected Duration (hours)
2.0

Lesson Objectives
Oracle Database 10g: New Features in VLDB Support
• use bigfile tablespaces in Oracle Database 10g in a given scenario.
• use Enterprise Manager to create and manage temporary tablespace groups in a given scenario.
• use Enterprise Manager to create and manage partitions in a given scenario.
• use Enterprise Manager to create VLDB objects in a given scenario.
• recognize range, hash, and bitmap index enhancements in Oracle Database 10g.
• recognize how to manage range, hash, and bitmap indexes in a given scenario.

Course Number:
220641_eng

BASE DE DADOS ORACLE 10G: DIVERSAS NOVAS FUNCIONALIDADES - [220642_ENG]

Overview/Description
To recognize how various new features are used in Oracle 10g

Target Audience
Oracle 8i or 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g

Prerequisites
Experience in the administration of Oracle 8i or 9i databases

Expected Duration (hours)
2.3

Lesson Objectives
Oracle Database 10g: Miscellaneous New Features
• recognize the new transaction and statistics monitoring enhancements in Oracle Database 10g.
• recognize how tracing, statistical information gathering, and client and shared server configuration is achieved in multi-tier environments in a given scenario.
• enable tracing and statistics aggregation in a given scenario.
• recognize the enhancements to resumable statements, buffer cache management, and large objects in Oracle Database 10g.
• recognize regular expression support and linguistic sorting in Oracle Database 10g.
• recognize the new e-mail, compression, LogMiner, and quotation mark enhancements in Oracle Database 10g.
• recognize regular expression, sorting, and e-mail usage in a given scenario.

Course Number:
220642_eng

BASE DE DADOS ORACLE 10G: WORKSHOP DE ADMINISTRAÇÃO I - LANÇAMENTO 2

BASE DE DADOS ORACLE 10G: INSTALAÇÃO DA BASE DA DADOS ORACLE 10G - LANÇAMENTO 2 - [249293_ENG]

Overview/Description
To introduce the concepts of RDBMS and Oracle database administration, and explain how to install Oracle Database 10g software

Target Audience
Anyone wanting to learn about Oracle Database 10g database administration

Prerequisites
An understanding of database concepts and technologies

Expected Duration (hours)
2.3

Lesson Objectives
Oracle Database 10g: Installing Oracle Database 10g Release 2
• recognize the characteristics of a relational database system.
• identify the basic tasks and tools involved in Oracle database administration.
• identify the basic concepts involved in RDBMS and Oracle database administration.
• identify the components involved in the Oracle preinstall process.
• recognize how to configure the Oracle install environment using the Oracle Universal Installer.
• recognize how to configure the Oracle Database 10g installation.
• install Oracle Database 10g on a UNIX operating system.

Course Number:
249293_eng

BASE DE DADOS ORACLE 10G: CRIAÇÃO DE BASES DE DADOS - LANÇAMENTO 2 - [249294_ENG]

Overview/Description
To provide an overview of Oracle database and instance architecture and demonstrate how to use the Database Configuration Assistant

Target Audience
Anyone wanting to learn about Oracle Database 10g database administration

Prerequisites
An understanding of database concepts and technologies

Expected Duration (hours)
2.3

Lesson Objectives
Oracle Database 10g: Creating Databases Release 2
• identify the files and logical storage units that make up the Oracle database.
• recognize the characteristics of the Oracle instance and its management interfaces.
• distinguish between the basic components of Oracle database architecture.
• recognize how to configure database identification, management, password, and storage options using the Database Configuration Assistant.
• recognize how to use the Database Configuration Assistant to set file locations and parameters.
• recognize how to set database storage settings and creation options, and delete a database using the Database Configuration Assistant.
• create an Oracle database, and delete one, using the Database Configuration Assistant.

Course Number:
249294_eng

BASE DE DADOS ORACLE 10G: LANÇAMENTO DE INTERFACES DE BASE DE DADOS 2 - [249295_ENG]

Overview/Description
To explain how to use SQL and SQL*Plus to access an Oracle 10g database and introduce other common database interfaces

Target Audience
Anyone wanting to learn about Oracle Database 10g database administration

Prerequisites
An understanding of database concepts and technologies

Expected Duration (hours)
3.0

Lesson Objectives
Oracle Database 10g: Database Interfaces Release 2
• identify ways of sending SQL commands to a database and recognize how to start SQL*Plus and iSQL*Plus.
• recognize how to use the DESCRIBE, PROMPT, and SELECT commands to work with data.
• recognize how to join tables and use DML and DDL statements to manipulate and define data.
• identify the functions of different SQL statements and recognize the function of data locking.
• identify ways of sending SQL commands to a database and recognize how to start SQL*Plus and iSQL*Plus.
• use SQL*Plus and iSQL*Plus to manage data.
• identify the basic elements of PL/SQL and recognize the uses of PL/SQL.
• identify the characteristics of some common database interfaces.
• identify how Oracle works with common database interfaces.

Course Number:
249295_eng

BASE DE DADOS ORACLE 10G: LANÇAMENTO DE CONTROLO DE BASE DE DADOS E ESTRUTURA DE ARMAZENAMENTO 2 - [249296_ENG]

Overview/Description
To explain the fundamentals of Oracle database control and how to use tablespaces

Target Audience
Anyone wanting to learn about Oracle Database 10g database administration

Prerequisites
An understanding of database concepts and technologies

Expected Duration (hours)
2.3

Lesson Objectives
Oracle Database 10g: Database Control and Storage Structures Release 2
• recognize how to use the Oracle Database 10g management framework.
• recognize how to start up and shut down an Oracle 10g database.
• identify the characteristics of initialization parameters and the alert log and recognize how to view them.
• start and stop the Oracle Enterprise Manager Database Control, Oracle Listener, and Oracle Database 10g instance.
• recognize how table data is stored and create tablespaces.
• recognize how to manipulate tablespaces in an Oracle database.
• view tablespace information and create a tablespace.

Course Number:
249296_eng

BASE DE DADOS ORACLE 10G: LANÇAMENTO DE UTILIZADORES E SEGURANÇA 2 - [249297_ENG]

Overview/Description
To explain how to manage users, implement security, and audit database activity on an Oracle 10g database

Target Audience
Anyone wanting to learn about Oracle Database 10g database administration

Prerequisites
An understanding of database concepts and technologies

Expected Duration (hours)
3.3

Lesson Objectives
Oracle Database 10g: Users and Security Release 2
• recognize how to create user accounts and profiles.
• recognize how to grant privileges and assign quotas to users.
• recognize how to create a role and assign it to a user.
• administer user accounts on an Oracle 10g database.
• recognize how to restrict access to an Oracle database.
• recognize how to implement database security by configuring user profiles.
• implement password security by configuring user profiles.
• recognize how to monitor database activity using Oracle's built-in audit tools.
• recognize how to implement fine-grained auditing in an Oracle 10g database.
• audit database activity in an Oracle 10g database.

Course Number:
249297_eng

BASE DE DADOS ORACLE 10G: LANÇAMENTO DE ESQUEMA DE GESTÃO DE OBJECTOS E DADOS 2 - [249298_ENG]

Overview/Description
To demonstrate how to manage schema objects and data in an Oracle 10g database

Target Audience
Anyone wanting to learn about Oracle Database 10g database administration

Prerequisites
An understanding of database concepts and technologies

Expected Duration (hours)
3.0

Lesson Objectives
Oracle Database 10g: Managing Schema Objects and Data Release 2
• identify the basic features of objects in a database schema.
• recognize how to create and modify tables in an Oracle 10g database.
• create, delete, and modify tables in an Oracle 10g database.
• recognize the most common index types, create indexes and views, and use sequences in an Oracle 10g database.
• work with indexes, views, and sequences in an Oracle 10g database.
• manipulate tables, views, and indexes in an Oracle 10g database.
• recognize how to manage data using the INSERT, UPDATE, DELETE, COMMIT, and ROLLBACK commands.
• recognize how to use Oracle's Data Pump to export and import data.
• export and import data using Oracle's Data Pump utility.

Course Number:
249298_eng

BASE DE DADOS ORACLE 10G: LANÇAMENTO DO SQL*LOADER E PL/SQL 2 - [249299_ENG]

Overview/Description
To provide an overview of how to use the SQL*Loader and PL/SQL in an Oracle 10g database

Target Audience
Anyone wanting to learn about Oracle Database 10g database administration

Prerequisites
An understanding of database concepts and technologies

Expected Duration (hours)
2.0

Lesson Objectives
Oracle Database 10g: The SQL*Loader and PL/SQL Release 2
• identify the function of the SQL*Loader and the files it uses.
• recognize how to load data using the SQL*Loader.
• load data using the SQL*Loader.
• identify the characteristics of PL/SQL objects, functions, and procedures.
• recognize the characteristics of PL/SQL packages and triggers and identify the configuration options that control PL/SQL performance.
• recognize the basic concepts of PL/SQL.

Course Number:
249299_eng

BASE DE DADOS ORACLE 10G: LANÇAMENTO DE SERVIÇOS COMPARTILHADOS ORACLE NET SERVICES 2 - [249300_ENG]

Overview/Description
To provide an overview of Oracle Net Services and Shared Server

Target Audience
Anyone wanting to learn about Oracle Database 10g database administration

Prerequisites
An understanding of database concepts and technologies

Expected Duration (hours)
2.8

Lesson Objectives
Oracle Database 10g: Oracle Net Services and Shared Servers Release 2
• recognize how to create and configure an Oracle Net listener in Oracle Database 10g.
• recognize how to monitor Oracle Net Services using the Listener Control utility.
• create and configure an Oracle Net Listener.
• configure local name resolution in a given scenario.
• configure local Oracle Net Services aliases.
• recognize how to configure advanced connection options and test Oracle Net connectivity.
• distinguish between Oracle server connection types.
• distinguish between the initialization parameters used to configure Shared Server.
• recognize how to monitor Shared Server.
• configure and verify Shared Server.

Course Number:
249300_eng

BASE DE DADOS ORACLE 10G: LANÇAMENTO DE MONIORIZAÇÃO E MANUTENÇÃO 2 - [249301_ENG]

Overview/Description
To demonstrate how to control database performance and configure proactive database maintenance

Target Audience
Anyone wanting to learn about Oracle Database 10g database administration

Prerequisites
An understanding of database concepts and technologies

Expected Duration (hours)
2.7

Lesson Objectives
Oracle Database 10g: Monitoring and Maintenance Release 2
• repair invalid and unusable objects.
• detect and repair unusable indexes.
• recognize how to monitor performance using dynamic performance views, Enterprise Manager, and optimizer statistics.
• gather optimizer statistics for a database schema.
• set thresholds and baselines for performance metrics.
• identify the functions of various tuning and diagnostic advisors, and use them in a given scenario.
• recognize how to manage the AWR and use the ADDM to review database performance in Oracle Database 10g.
• configure a database for proactive maintenance.

Course Number:
249301_eng

BASE DE DADOS ORACLE 10G: LANÇAMENTO DA GESTÃO DA REPARAÇÃO DE DADOS E DO BLOQUEIO DE CONFLITOS 2 - [249302_ENG]

Overview/Description
To discuss how to manage undo data and manage lock conflicts in an Oracle database

Target Audience
Anyone wanting to learn about Oracle Database 10g database administration

Prerequisites
An understanding of database concepts and technologies

Expected Duration (hours)
1.8

Lesson Objectives
Oracle Database 10g: Managing Undo Data and Lock Conflicts Release 2
• identify factors to take into consideration when managing undo.
• recognize how to estimate required tablespace size and resize a tablespace in a given scenario.
• calculate undo tablespace sizing and resize an undo tablespace.
• recognize how locks are used to ensure concurrent user access to a database.
• manage lock conflicts.
• detect and resolve lock conflicts.

Course Number:
249302_eng

BASE DE DADOS ORACLE 10G: LANÇAMENTO DA GESTÃO DE BACKUP E RECUPERAÇÃO 2 - [249303_ENG]

Overview/Description
To discuss how to manage backup and recovery in an Oracle 10g database

Target Audience
Anyone wanting to learn about Oracle Database 10g database administration

Prerequisites
An understanding of database concepts and technologies

Expected Duration (hours)
4.0

Lesson Objectives
Oracle Database 10g: Managing Backup and Recovery Release 2
• recognize the types of database failure that can occur in an Oracle 10g database and identify possible solutions.
• recognize how to tune instance recovery and configure a database for maximum recoverability.
• recognize how to multiplex the Oracle 10g redo log and archive redo log files.
• configure a database for backup and recovery.
• recognize how to configure and manage database backups.
• recognize how to schedule database backups and back up control files to trace.
• configure database backups.
• back up a database.
• identify the types of media failure that can cause an instance to fail.
• recover from the loss of control files, redo log files, and datafiles.
• recognize how to perform flashback recovery operations in Oracle database 10g.
• recover a database.

Course Number:
249303_eng

ORACLE 11G

BASE DE DADOS ORACLE 11G: NOVAS FUNCIONALIDADES PARA ADMINISTRADORES

BASE DA DADOS ORACLE 11G: MELHORIAS NA INSTALAÇÃO E ACTUALIZAÇÃO - [255352_ENG]

Overview/Description
Recognize the enhancements to Oracle Database 11g's installation and upgrade processes, as well as its various post-upgrade steps, and recognize how to create a new database.

Target Audience
Oracle Database certified professionals who wish to upgrade to Oracle Database 11g certification; developers interested in the technical aspects of Oracle Database 11g; DBA's considering upgrading their systems to 11g

Prerequisites
The learner should have knowledge of Oracle Database 10g at least commensurate with that required to perform an administrator role

Expected Duration (hours)
2.3

Lesson Objectives
Oracle Database 11g: Installation and Upgrade Enhancements
• recognize the benefits of Oracle's Infrastructure grid and self-tuning capabilities.
• identify the changes to the Oracle database installation process and recognize the steps for installing Oracle Database 11g.
• recognize Oracle Database 11g's upgrade enhancements and identify the steps for performing an upgrade.
• recognize the steps for running the Oracle Database Upgrade Assistant as part of an upgrade.
• recognize the common post-upgrade steps and adjustments to initialization parameters, and identify the steps for creating a database.
• identify the steps for enabling Direct Network File System and installing a hot patch.
• identify the best practices and recommendations for testing and analyzing an Oracle Database 11g installation.
• create a new Oracle Database 11g database.

Course Number:
255352_eng

BASE DA DADOS ORACLE 11G: MELHORIAS DE ARMAZENAMENTO - [255364_ENG]

Overview/Description
recognize ways in which storage has been enhanced in Oracle Database 11g using Automatic Storage Management's (ASM's) commands and extensions.

Prerequisites
The learner should have knowledge of Oracle Database 10g at least commensurate with that required to perform an administrator role

Expected Duration (hours)
1.7

Lesson Objectives
Oracle Database 11g: Storage Enhancements
• recognize the ways to enhance efficiency and performance of Oracle Database 11g by using Automatic Storage Management (ASM) Fast Mirror Resync and ASM Preferred Mirror Read.
• identify ways to use ASM to enhance scalability and performance and control disk group attributes and compatibility.
• identify the steps for adding an offlined disk without ASM and also with ASM, following a nondata issue.
• recognize the syntax for performing disk group checks, mounting disk groups for fast rebalance, and forcing a disk group drop.
• identify the correct method for backing up ASM metadata using ASMCMD extensions.
• back up ASM metadata using ASMCMD extensions.

Course Number:
255364_eng

BASE DA DADOS ORACLE 11G: MUDANÇA NA GESTÃO GERAL E PLANO DE GESTÃO SQL - [255373_ENG]

Overview/Description
outline the uses of management tools in Oracle Database 11g, such as SQL Performance Analzer, SQL tuning sets, and SQL plan baselines, and outline how you can use them to effectively manage change and execute SQL plans.

Prerequisites
The learner should have knowledge of Oracle Database 10g at least commensurate with that required to perform an administrator role

Expected Duration (hours)
2.5

Lesson Objectives
Oracle Database 11g: Change Management Overview and SQL Plan Management
• recognize the steps for managing change when upgrading or reconfiguring Oracle Database, including the setting up a snapshot standby database as a test environment.
• recognize the general uses and benefits of SQL Performance Analyzer for ascertaining performance gains following a database change.
• identify the steps for capturing the SQL workload using SQL tuning sets.
• identify the different tasks that can be performed when managing components using the SQL Performance Analyzer.
• recognize the ways in which the different phases of the SQL Performance Analyzer help to assess the SQL performance impact of change.
• identify the elements of SQL plan management and recognize the steps for seeding SQL plan baselines.
• recognize ways to load and evolve SQL plan baselines, select SQL plans, and set up various SQL plan management scenarios.
• recognize the steps for executing all phases of SQL plan management.
• seed SQL Plan Baselines for your most regressing statements.

Course Number:
255373_eng

BASE DA DADOS ORACLE 11G: REPETIÇÃO DE BASE DE DADOS E AJUSTE AUTOMÁTICO SQL - [255385_ENG]

Overview/Description
Explain the benefits and uses of Oracle Database 11g's crucial developer tools, Database Replay and Automatic SQL Tuning, when setting up and testing a database

Prerequisites
The learner should have knowledge of Oracle Database 10g at least commensurate with that required to perform an administrator role

Expected Duration (hours)
2.6

Lesson Objectives
Oracle Database 11g: Database Replay and Automatic SQL Tuning
• recognize the benefits of using Database Replay and the concepts and reasons behind recreating a production database workload in a test environment.
• identify the scope of Database Replay's capabilities by recognizing the supported database changes and workloads, as well as some of the considerations and available options during capture, replay and replay analysis.
• identify the steps for running Database Replay using the Capture Wizard in Enterprise Manager.
• recognize the steps for replaying workload using the Replay Workload Wizard and also using PL/SQL to do the same, as well as calibrating replay clients.
• identify the steps for capturing the workload for a small application using Database Replay and replaying it to get the same results as during the original execution.
• run Database Replay in Enterprise Manager.
• recognize how SQL tuning can benefit developers in improving the performance of SQL statements, and identify the methods and DBA controls that you can use in Oracle Database 11g to run the Automatic SQL Tuning feature.
• identify the general steps and concepts behind configuring Automatic SQL Tuning, reviewing results, and performing a fine tune using PL/SQL.
• recognize the steps for executing Automatic SQL Tuning and viewing its results.

Course Number:
255385_eng

BASE DA DADOS ORACLE 11G: MELHORIA DA INFRA-ESTRUTURA INTELIGENTE - [255397_ENG]

Overview/Description
Identify how to to monitor performance, automate maintenance, calibrate and manage resources, and streamline job scheduling using Oracle Database 11g's intelligent infrastructure enhancements.

Prerequisites
The learner should have knowledge of Oracle Database 10g at least commensurate with that required to perform an administrator role

Expected Duration (hours)
2.0

Lesson Objectives
Oracle Database 11g: Intelligent Infrastructure Enhancements
• recognize the scope of Oracle Database 11g's AWR Baselines feature, which includes baseline template creation options and baseline views.
• recognize the steps for creating an AWR Baseline and using it to define alert thresholds.
• recognize the benefits of the Automatic Maintenance Tasks feature for statistics collection, segment advisor, and Automatic SQL Tuning, and identify how to control such tasks.
• recognize the steps for calibrating I/O resources in Oracle Database 11g.
• recognize how to manage resources and streamline schedules using the Resource Manager and lightweight jobs.
• identify the steps for creating and running lightweight scheduler jobs.
• calibrate I/O Resources in Oracle Database 11g.

Course Number:
255397_eng

BASE DA DADOS ORACLE 11G: MELHORIA DO DESEMPENHO - [255408_ENG]

Overview/Description
identify the scope and capabilities of Oracle Database 11g's performance-enhancing tools, such as those for memory management, performance analysis, and statistics gathering.

Prerequisites
The learner should have knowledge of Oracle Database 10g at least commensurate with that required to perform an administrator role

Expected Duration (hours)
1.6

Lesson Objectives
Oracle Database 11g: Performance Enhancements
• recognize the different ways to use Automatic Database Diagnostic Monitor to analyze Oracle Real Application Clusters (RACs) and report on issues affecting the entire database as well as individual instances.
• identify the benefits of Oracle Database 11g's Automatic Memory Management system.
• identify the concepts and methods employed in Oracle database 11g for gathering and publishing various kinds of statistics.
• identify the steps for observing memory distribution patterns using Automatic Memory Management and also for testing various statistic gatherings on a particular table.
• use Automatic Memory Management to observe memory distribution patterns.

Course Number:
255408_eng

BASE DA DADOS ORACLE 11G: MELHORIAS DE SEPARAÇÃO E ARMAZENAMENTO RELACIONADO - [255415_ENG]

Overview/Description
identify the benefits of Oracle Database 11g's partitioning and storage-related enhancements, and recognize how to use SQL Access Advisor to help you optimize your database in this regard.

Prerequisites
The learner should have knowledge of Oracle Database 10g at least commensurate with that required to perform an administrator role

Expected Duration (hours)
1.8

Lesson Objectives
Oracle Database 11g: Partitioning and Storage-Related Enhancements
• identify the steps for employing Oracle Database's new partitioning scheme to perform interval partitioning.
• recognize the steps for performing system and virtual column-based partitioning, using Oracle Database 11g's new partitioning scheme.
• identify the steps for performing reference partitioning, using Oracle Database 11g's new partitioning scheme.
• recognize the steps for performing extended composite partitioning, using Oracle Database 11g's new partitioning scheme, and for compressing tables.
• recognize the steps for using SQL Access Advisor to help you to decide which partitions, indexes, materialized views, and materialized view logs you need to optimize your database's workload.
• use the SQL Access Advisor to get partitioning recommendations.

Course Number:
255415_eng

BASE DA DADOS ORACLE 11G: MELHORUAS DE UTILIZAÇÃO DE RMAN, DE FLASHBACK E DE LOGMINER - [255423_ENG]

Overview/Description
identify ways of using Oracle Database 11g's enhanced RMAN, Flashback and LogMiner tools to clone databases, create backups and catalogs, archive historical data, and roll back transactions.

Prerequisites
The learner should have knowledge of Oracle Database 10g at least commensurate with that required to perform an administrator role

Expected Duration (hours)
2.1

Lesson Objectives
Oracle Database 11g: Using RMAN Enhancements, Flashback and LogMiner
• recognize the ways in which enhancements to RMAN in Oracle Database 11g can help you perform faster and optimized backups.
• identify the steps for duplicating an active Oracle Database 11g database.
• identify the steps for creating and managing archival backups and RMAN catalogs in Oracle Database 11g.
• duplicate an active Oracle Database 11g database.
• recognize the benefits of Flashback Data Archives in Oracle Database 11g for retaining historical data.
• identify the steps for using Flashback Data Archives.
• identify the steps for using the Flashback Transaction Backout and LogMiner features to locate and roll back transactions and user errors in Oracle Database 11g.

Course Number:
255423_eng

BASE DA DADOS ORACLE 11G: MELHORIAS DE DIAGNÓSTICO E UTILIZAÇÃO DE CONSULTOR DE RECUPERADOR DE DADOS - [255433_ENG]

Overview/Description
recognize the steps for detecting, diagnosing, and repairing critical errors and data failures in Oracle Database 11g, using its enhanced, proactive, diagnostic tools, such as Automatic Diagnostic Repository, Support Workbench, SQL Repair Advisor, and the Data Recovery Advisor.

Prerequisites
The learner should have knowledge of Oracle Database 10g at least commensurate with that required to perform an administrator role

Expected Duration (hours)
2.1

Lesson Objectives
Oracle Database 11g: Diagnostic Enhancements and Using the Data Recovery Advisor
• recognize the scope and capabilities of the Automatic Diagnostic Repository (ADR) feature in Oracle Database 11g.
• identify the tasks that can be performed, using the Support Workbench wizard, to handle critical errors in Oracle Database 11g.
• identify the steps for configuring incident packages and for creating, manipulating, and modifying custom packages.
• identify the steps for dealing with critical errors in Oracle Database 11g, using the Health Monitor and SQL Repair Advisor tools.
• recognize your options for assessing data failures in Oracle Database 11g, using the Data Recovery Advisor.
• identify the steps for getting advice on repairing data failures, executing these repairs using RMAN data repair commands, and setting parameters to detect further corruption.
• repair a down database via Enterprise Manager.

Course Number:
255433_eng

BASE DA DADOS ORACLE 11G: NOVOS RECURSOS DE TRADUÇÃO - [255444_ENG]

Overview/Description
identify the ways in which Oracle Database has enhanced security, including enhancements to Transparent Data Encryption and password security, and identify the steps for managing all aspects of security.

Prerequisites
The learner should have knowledge of Oracle Database 10g at least commensurate with that required to perform an administrator role

Expected Duration (hours)
1.4

Lesson Objectives
Oracle Database 11g: New Security Features
• recognize ways to configure a password file to use case-sensitive passwords and also how to configure security settings in Oracle Database 11g.
• recognize the different types of encryption in Oracle Database 11g, and identify the steps for managing fine-grained access to external network services.
• recognize ways for setting up administrator authentication and managing transparent data encryption and other security settings.
• identify the steps for increasing the security of passwords and implementing tablespace encryption in Oracle Database 11g.
• identify the best approach to take to encrypt a tablespace in Oracle Database 11g.

Course Number:
255444_eng

BASE DA DADOS ORACLE 11G: FICHEIROS SEGUROS E DIVERSAS NOVAS FUNCIONALIDADES - [255451_ENG]

Overview/Description
Recognize the steps for enhancing the performance of large objects, caching query results, and performing other miscellaneous tasks in Oracle Database 11g.

Prerequisites
The learner should have knowledge of Oracle Database 10g at least commensurate with that required to perform an administrator role

Expected Duration (hours)
2.3

Lesson Objectives
Oracle Database 11g: SecureFiles and Miscellaneous New Features
• identify the ways in which SecureFiles enhance the performance of large object (LOB) data types.
• recognize the steps for migrating to SecureFiles and for creating, altering, accessing, and monitoring them.
• identify the steps for using SecureFiles for compression, data encryption, and performance.
• identify the benefits of SQL Query Result Cache and PL/SQL Function Cache, as well as using other Oracle Database 11g enhancements to online redefinition, locking mechanisms, and invisible indexes.
• recognize the benefits of PL/SQL native compilation enhancements, Adaptive Cursor sharing, and temporary tablespace shrink.
• identify the steps using the SQL Query Result Cache in Oracle Database 11g.
• identify ways of employing the SQL Query Result Cache in a given scenario.

Course Number:
255451_eng

BASE DE DADOS ORACLE 11G: WORKSHOP DE ADMINISTRAÇÃO I

BASE DE DADOS ORACLE 11G: ARQUITECTURA E INSTALAÇÃO DE BASE DE DADOS - [255701_ENG]

Overview/Description
Identify the elements of the Oracle Database 11g architecture and recognize the tools and steps required to install the Oracle Database 11g software

Target Audience
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators

Prerequisites
A working knowledge of SQL

Expected Duration (hours)
2.0

Lesson Objectives
Oracle Database 11g: Database Architecture and Installation
• identify the main structural components of Oracle Database 11g.
• identify the components of the Oracle Database 11g memory structures.
• identify the functions of the Oracle Database 11 server and background processes.
• recognize how information is stored and structured within the Oracle Database 11g storage architecture.
• identify the necessary tasks and essential tools required to administer an Oracle Database 11g database.
• recognize the steps for planning and carrying out an installation of Oracle Database 11g software using the Oracle Universal Installer (OUI).
• install Oracle Database 11g software in a given scenario.

Course Number:
255701_eng

BASE DE DADOS ORACLE 11G: CRIAÇÃO, GESTÃO DE INSTÂNCIA E CONECTIVIDADE DE BASE DE DADOS - [255770_ENG]

Overview/Description
Identify the steps for creating a new Oracle Database 11g database and then configuring it and managing the instance, and also recognize the steps for configuring new Oracle Net Listeners and database connectivity.

Target Audience
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators

Prerequisites
A working knowledge of SQL

Expected Duration (hours)
2.5

Lesson Objectives
Oracle Database 11g: Database Creation, Instance Management, and Connectivity
• recognize the steps for creating, configuring, or deleting a database using the Database Configuration Assistant (DBCA), and also for managing a database instance using various Oracle tools.
• recognize the scope and capabilities of Oracle Database 11g initialization parameters and identify the steps for maintaining them.
• recognize the steps for configuring database startup and shutdown options, administering a blackout, and using alerts and dynamic data to assess database performance.
• recognize the steps for using the Data Dictionary to find information about users, objects, constraints, and storage.
• create a database using the DBCA and manage instances using Enterprise Manager.
• recognize ways of configuring and managing the Oracle network, and identify the steps for creating a new Oracle Net Listener via Enterprise Manager.
• identify the steps for connecting to an Oracle Database 11g database using different naming methods as well as advanced connection options, and identify when to employ connection pooling.
• identify the steps for using and configuring Oracle Net Services in a given scenario.

Course Number:
255770_eng

BASE DE DADOS ORACLE 11G: ESTRUTURAS DE ARMAZENAMENTO E SEGURANÇA DO UTILIZADOR - [255814_ENG]

Overview/Description
identify the steps for maintaining storage structures and automating storage management in Oracle Database 11g, and for managing privileges, roles, and other security features for users.

Target Audience
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators

Prerequisites
A working knowledge of SQL

Expected Duration (hours)
2.5

Lesson Objectives
Oracle Database 11g: Storage Structures and User Security
• recognize the purposes of table spaces and datafiles.
• recognize the steps for creating a new tablespace.
• recognize how to manage the storage of information by maintaining tablespaces and viewing their information, and automating manual storage using Automatic Storage Management (ASM).
• view tablespace information and create a new tablespace.
• recognize the steps for creating and authenticating database user accounts.
• recognize the steps for granting and revoking privileges and creating and managing roles.
• recognize the steps for creating and managing profiles, implementing password security, and assigning quotas.
• grant privileges to users in a given scenario.

Course Number:
255814_eng

BASE DE DADOS ORACLE 11G: GESTÃO DE ESQUEMA, DADOS E OCORRÊNCIAS - [255825_ENG]

Overview/Description
Identify the steps for managing schema objects, such as tables, views, and indexes, and recognize ways to use SQL and PL/SQL commands to manipulate data and ensure data concurrency

Target Audience
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators

Prerequisites
A working knowledge of SQL

Expected Duration (hours)
2.0

Lesson Objectives
Oracle Database 11g: Managing the Schema, Data, and Concurrency
• recognize the features and functions of schemas and data types, and identify the steps for modifying a table.
• recognize the steps for using constraints to maintain data integrity, viewing the contents of a table, and perform actions on the table.
• recognize ways of improving data update and retrieval, storing queries, speeding up performance by creating and using indexes, views, sequences, and temporary tables.
• create a table with columns and also create constraints and indexes, in a given scenario.
• recognize ways for manipulating data with SQL commands and for administering PL/SQL objects.
• recognize the steps for triggering events, and for monitoring and resolving locking conflicts.

Course Number:
255825_eng

BASE DE DADOS ORACLE 11G: GESTÃO DE REPARAÇÃO DE DADOS, DE SEGURANÇA DE BASE DE DADOS E MANUTENÇÃO - [255834_ENG]

Overview/Description
recognize the steps required to manage undo information, secure an Oracle Database 11g database, and maintain it by monitoring statistics, automated tasks and alert thresholds.

Target Audience
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators

Prerequisites
A working knowledge of SQL

Expected Duration (hours)
2.4

Lesson Objectives
Oracle Database 11g: Managing Undo Data, Database Security, and Maintenance
• recognize the steps for managing undo operations in Oracle Database 11g to allow users to roll back transactions.
• recognize the requirements and best practices for implementing database security according to international and regional laws.
• recognize the steps for enabling, specifying, maintaining, and reviewing database auditing.
• recognize the process for obtaining and applying Critical Patch Updates (CPUs).
• configure an Oracle Database 11g database to support retention and implement database security in a given scenario.
• recognize the steps for managing and gathering optimizer statistics.
• identify the steps for managing Automatic Workload Repository (AWR) statistics, using the Automatic Database Diagnostic Monitor (ADDM), and utilizing advisors.
• identify the steps for viewing and configuring automated tasks and setting alert thresholds.

Course Number:
255834_eng

BASE DE DADOS ORACLE 11G: MONITORIZAÇÃO DE DESEMPENHO, CONCEITOS RECUPERADOS E BACKUP’S - [255845_ENG]

Overview/Description
identify the steps for ensuring an Oracle Database 11g database is available to users when needed, by monitoring its performance, anticipating and avoiding database failure, setting up instance recovery options, and creating backups.

Target Audience
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators

Prerequisites
A working knowledge of SQL

Expected Duration (hours)
2.0

Lesson Objectives
Oracle Database 11g: Performance Monitoring, Recovery Concepts and Backup
• identify the steps for monitoring and analyzing performance, managing memory, and troubleshooting invalid objects that affect performance.
• recognize ways to anticipate and avoid various types of failure that can occur in Oracle Database 11g.
• recognize the process used to configure an Oracle Database 11g database for instance recovery.
• recognize the features of different backup strategies you can employ in Oracle Database 11g.
• recognize the steps for using RMAN to configure, schedule, manage, and view backup operations.
• resolve performance issues, prepare the database for recovery, and perform a database backup in a given scenario.

Course Number:
255845_eng

BASE DE DADOS ORACLE 11G: RECUPERAÇÃO, MUDANÇAS E MELHORIS DA BASE DE DADOS ORACLE - [255854_ENG]

Overview/Description
recognize ways to make use of Oracle Database 11g's tools for moving and recovering data, reporting on problems, and installing updates to enhance a database.

Target Audience
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators

Prerequisites
A working knowledge of SQL

Expected Duration (hours)
2.2

Lesson Objectives
Oracle Database 11g: Recovering, Moving, and Enhancing the Oracle Database
• recognize the tools required and steps performed in identifying whether a recovery is necessary, and then recovering various types of database files.
• recognize the features of the various options for moving data in Oracle Database 11g.
• recognize the steps for importing, exporting, and moving data between Oracle databases using Oracle Data Pump.
• recover the database from a media failure and move data using the Data Pump Wizard in a given scenario.
• recognize the steps for using the Enterprise Manager Support Workbench and Oracle Support to investigate, report on, and resolve problems.
• recognize the steps for searching MetaLink for new critical patches and for logging service requests.
• recognize ways for managing and applying patches in Oracle Database 11g.

Course Number:
255854_eng

BASE DE DADOS ORACLE 11G: WORKSHOP DE ADMINISTRAÇÃO II

BASE DE DADOS ORACLE 11G: ARQUITECTURA DE BASE DE DADOS E ASM - [256882_ENG]

Overview/Description
To recognize the structural elements in Oracle Database 11g's architecture, including and Automatic Storage Management (ASM), and recognize the steps for managing storage using disk groups.

Target Audience
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.

Prerequisites
Working knowledge of SQL. Oracle Database 11g: Introduction to SQL. Oracle Database 11g: Administration Workshop I

Expected Duration (hours)
1.7

Lesson Objectives
Oracle Database 11g: Database Architecture and ASM
• identify the characteristics of elements of the Oracle Database 11g architecture.
• recognize the steps for managing database files using Automatic Storage Management (ASM) and disk groups.
• identify ways to manage disk groups and their attributes and also configure and manage ASM instances.
• recognize the steps for managing ASM storage, scalability, and performance using the ALTER command and also the ASMCMD utility.
• create an ASM instance and disk group and use the ASMCMD to view disk group data.

Course Number:
256882_eng

BASE DE DADOS ORACLE 11G: CONFIGURAÇÃO PARA RECUPERAÇÃO - [256975_ENG]

Overview/Description
To recognize the steps for configuring all aspects of backup and recovery functionality in Oracle Database 11g, using ARCHIVELOG mode, retention policies, a Flash Recovery Area, and an RMAN recovery catalog.

Target Audience
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.

Prerequisites
Working knowledge of SQL. Oracle Database 11g: Introduction to SQL. Oracle Database 11g: Administration Workshop I

Expected Duration (hours)
1.8

Lesson Objectives
Oracle Database 11g: Configuring for Recovery
• identify the benefits of Oracle Database 11g's backup and recovery functionality.
• recognize the steps for configuring a database for backup.
• recognize the steps for configuring the Flash Recovery Area.
• recognize the steps for creating an RMAN recovery catalog and using it to store database backups.
• identify the steps for resynchronizing a recovery catalog, using RMAN stored scripts, and backing up a recovery catalog.
• create and configure a recovery catalog and register a database in the recovery catalog in a given scenario.

Course Number:
256975_eng

BASE DE DADOS ORACLE 11G: CONFIGURING PARA BACKUP’S - [257033_ENG]

Overview/Description
To identify the steps for preparing a database for backup and then for performing various types of RMAN backups and monitoring them using reports and dynamic performance views, and also for performing user-managed backups and recoveries.

Target Audience
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.

Prerequisites
Working knowledge of SQL. Oracle Database 11g: Introduction to SQL. Oracle Database 11g: Administration Workshop I

Expected Duration (hours)
2.7

Lesson Objectives
Oracle Database 11g: Configuring for Backups
• recognize the steps for preparing and optimizing a database for a backup.
• recognize the steps for creating fast incremental backup and duplex backup sets using RMAN.
• recognize the steps for creating archival and multisection backups and also for compressing and encrypting backups using RMAN.
• recognize the steps for backing up to sequential media, such as tape drives, and for using reports and views to monitor backups.
• identify the different types of file loss that can occur and the steps for restoring the files and recovering the database in a given scenario.
• recognize the steps involved in a complete and an incomplete recovery, and identify the steps for performing a user-managed backup.
• recognize the steps for performing different types of user-managed recoveries.
• back up a database and recover a lost online redo log file in a given scenario.

Course Number:
257033_eng

BASE DE DADOS ORACLE 11G: UTILIZAÇÃO DE RMAN PARA RECUPERAÇÃO - [257046_ENG]

Overview/Description
To identify ways to use RMAN to ensure that data is not lost in Oracle Database 11g, by performing complete and incomplete recoveries as well as disaster recoveries, by cloning databases, and by restoring a tablespace to a particular point in time.

Target Audience
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.

Prerequisites
Working knowledge of SQL. Oracle Database 11g: Introduction to SQL. Oracle Database 11g: Administration Workshop I

Expected Duration (hours)
1.8

Lesson Objectives
Oracle Database 11g: Using RMAN for Recovery
• identify the steps for performing a complete recovery using RMAN.
• recognize the steps for using RMAN to perform an incomplete recovery, restore a database to a new host, and perform a disaster recovery.
• identify the steps for using RMAN to recover a database in a given scenario.
• recognize the steps for creating a duplicate database using RMAN and Enterprise Manager.
• recognize the steps for performing a tablespace point-in-time recovery (TSPITR).
• clone a database and complete a tablespace point-in-time recovery (TSPITR) in a given scenario.

Course Number:
257046_eng

BASE DE DADOS ORACLE 11G: APOIO A RMAN E UTILIZAÇÃO DE TECNOLOGIA FLASHBACK - [257060_ENG]

Overview/Description
To recognize the steps for making sure that you can recover data quickly by tuning RMAN to avoid bottlenecks, and also for making sure that any changes to a database can be easily reversed, if necessary, using Oracle Database 11g's flashback features.

Target Audience
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.

Prerequisites
Working knowledge of SQL. Oracle Database 11g: Introduction to SQL. Oracle Database 11g: Administration Workshop I

Expected Duration (hours)
2.2

Lesson Objectives
Oracle Database 11g: Supporting RMAN and Using Flashback Technology
• recognize the steps for monitoring RMAN.
• recognize the benefits of RMAN backup and restore operations in terms of performing RMAN tuning operations, such as multiplexing.
• identify the steps for performing RMAN tuning operations.
• recognize the steps for enabling flashback features and for using the recycle bin in Oracle Database 11g.
• recognize the steps for using flashback to query data, retrieve versions of rows, view changes made at the transaction level, and reverse a transaction.
• use flashback to reverse a transaction in a given scenario.
• recognize the steps for recovering a set of tables or an entire database to a specific point in time, using Flashback Tables and Flashback Database.
• identify the steps for using guaranteed restore points, for monitoring Flashback Database, and for tracking and archiving data with Flashback Data Archive.

Course Number:
257060_eng

BASE DE DADOS ORACLE 11G: DIAGNÓSTICO DE BASE DE DADOS E GESTÃO DE MEMÓRIA - [257071_ENG]

Overview/Description
To identify the steps for diagnosing and repairing database problems with the help of Oracle Support using Automatic Diagnostic Repository, Support Workbench, and health checks, and also for enabling and configuring automatic memory management and automatic shared memory management.

Target Audience
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.

Prerequisites
Working knowledge of SQL. Oracle Database 11g: Introduction to SQL. Oracle Database 11g: Administration Workshop I

Expected Duration (hours)
2.2

Lesson Objectives
Oracle Database 11g: Diagnosing the Database and Managing Memory
• identify the steps for viewing diagnostic data and incidents associated with a database problem via Automatic Diagnostic Repository and Support Workbench.
• identify the steps for creating a service request (SR) for an incident and packaging and uploading the associated diagnostic data to Oracle Support, and also for monitoring your database's health.
• recognize the steps for handling block corruption and for detecting, analyzing, and repairing failures with the help of Data Recovery Advisor.
• identify the functions of different memory structures in Oracle Database 11g.
• recognize the steps for enabling and monitoring automatic memory management (AMM) and for enabling, configuring, and disabling automatic shared memory management (ASMM).
• identify the steps for controlling automatic memory management in the PGA and for sizing the SGA and PGA, and recognize the guidelines for efficient memory usage.
• enable automatic memory management and view automatic memory settings in a given scenario.

Course Number:
257071_eng

BASE DE DADOS ORACLE 11G: DESEMPENHO DE BASE DE DADOS E GESTÃO DE ESPAÇO - [257081_ENG]

Overview/Description
To identify the steps for making sure your Oracle Database 11g database is performing well and has adequate space, by monitoring statistics, tuning SQL, testing workloads, managing space, and transporting tablespaces.

Target Audience
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.

Prerequisites
Working knowledge of SQL. Oracle Database 11g: Introduction to SQL. Oracle Database 11g: Administration Workshop I

Expected Duration (hours)
2.7

Lesson Objectives
Oracle Database 11g: Database Performance and Space Management
• identify the tuning steps required to establish the Oracle Database 11g environment.
• identify the steps for monitoring and managing session performance using Enterprise Manager, views, Automatic Workload Repository (AWR) statistics, and SQL advisors.
• recognize the steps for using the SQL Tuning Advisor and SQL Access Advisors to analyze SQL statements and improve data retrieval.
• recognize the general steps required to capture a production workload and replay it in a test environment, using the Database Replay feature.
• identify a high load SQL statement and then tune it using the SQL Tuning Advisor.
• recognize the steps for generally managing and monitoring space in Oracle Database 11g.
• recognize the steps for shrinking segments and reclaiming available space using the Segment Advisor and resumable statements.
• identify the steps for moving large volumes of data between two Oracle Database 11g databases, using transportable tablespaces.

Course Number:
257081_eng

BASE DE DADOS ORACLE 11G: GESTÃO DE RECURSOS E AUTOMATIZAÇÃO DE TAREFAS - [257108_ENG]

Overview/Description
To identify ways to ensure that resources are being put to best use and database jobs are performed when they should be, using the Database Resource Manager and the Scheduler.

Target Audience
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.

Prerequisites
Working knowledge of SQL. Oracle Database 11g: Introduction to SQL. Oracle Database 11g: Administration Workshop I

Expected Duration (hours)
1.9

Lesson Objectives
Oracle Database 11g: Managing Resources and Task Automation
• identify the steps for accessing and creating resource plans and consumer groups using the Database Resource Manager.
• identify the steps for planning and monitoring resource allocation to consumer groups, using resource plan directives.
• use the Database Resource Manager to address system resource utilization and control in a given scenario.
• recognize the steps for using the Scheduler to create, schedule and monitor regular and lightweight jobs.
• distinguish between time-based and event-based schedules for executing jobs and job chains using the Scheduler.
• recognize the steps for performing advanced Scheduler administration to manage job windows, prioritize jobs, and make the best use of resources.

Course Number:
257108_eng

BASE DE DADOS ORACLE 11G: GLOBALIZAÇÃO - [257117_ENG]

Overview/Description
To recognize the steps for utilizing Oracle Database 11g's globalization support features to ensure that information and data is displayed in a user's native language, and that territory and language-dependent conventions are adhered to.

Target Audience
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.

Prerequisites
Working knowledge of SQL. Oracle Database 11g: Introduction to SQL. Oracle Database 11g: Administration Workshop I

Expected Duration (hours)
1.2

Lesson Objectives
Oracle Database 11g: Globalization
• identify the steps for selecting the database character set that meets your needs and for specifying language-dependent behavior.
• recognize the steps for performing and customizing linguistic searches and sorts.
• identify the steps for performing multiple character set conversions, and for scanning an unknown file set to determine its language.
• modify language, date, and time formats for a session and perform a linguistic sort in a given scenario.

Course Number:
257117_eng

BASE DE DADOS ORACLE 11G: NOVAS FUNCIONALIDADES SQL E PL/SQL

BASE DE DADOS ORACLE 11G: INÍCIO COM AS NOVAS FUNCIONALIDADES SQL E PL/SQL - [257179_ENG]

Overview/Description
To recognize the scope and capabilities of enhancements to SQL and PL/SQL, including tools such as SQL*Plus and SQL Developer, and use them to create reports and scripts, browse and manage database objects, find subpatterns, and track dependencies

Target Audience
PL/SQL developers, developers, system analysts, data warehouse administrators, and application developers

Prerequisites
The learner should have experience and knowledge of SQL and PL/SQL from prior Oracle releases, and hands on experience using PL/SQL

Expected Duration (hours)
1.8

Lesson Objectives
Oracle Database 11g: Getting Started with SQL and PL/SQL New Features
• recognize ways for using SQL*Plus commands to display the structure of a table and perform some editing and file management tasks.
• recognize the steps for using SQL Developer and SQL Worksheet to connect to a database, browse and export database objects, and use SQL*Plus to enter and execute SQL and PL/SQL statements.
• identify the steps for using SQL Developer to create reports and migrate to an Oracle Database 11g database.
• recognize the steps for using Oracle Database 11g's new SQL and PL/SQL language functionality enhancements.
• recognize the scope and uses of Data Change Notification (DCN) and lock enhancements.
• use SQL and PL/SQL language functionality enhancements to connect to a database and create a report, examine dependency at the element level, and modify an exception handler.

Course Number:
257179_eng

BASE DE DADOS ORACLE 11G: UTILIZAÇÃO DE SQL DINÂMICOS E IMPLEMENTAÇÃO DE MELHORIAS DE DESEMPENHO - [257188_ENG]

Overview/Description
To recognize the steps for improving SQL and PL/SQL flexibility, usability, and performance, using dynamic SQL, language enhancements, and a variety of performance enhancements

Target Audience
PL/SQL developers, developers, system analysts, data warehouse administrators, and application developers

Prerequisites
The learner should have experience and knowledge of SQL and PL/SQL from prior Oracle releases, and hands on experience using PL/SQL

Expected Duration (hours)
1.3

Lesson Objectives
Oracle Database 11g: Using Dynamic SQL and Implementing Performance Improvements
• recognize the steps for using native dynamic SQL and the DBMS_SQL package to specify dynamic SQL statements, using CLOB data types and also abstract data types.
• identify the steps for using language enhancements to improve sequence usability, control loop iterations, employ named and mixed notation in calls to PL/SQL, and place a table in read-only mode.
• recognize the steps for improving the performance of SQL and PL/SQL with a new compiler, a new, faster data type, inlining for faster performance, caching, and flashback enhancements.
• examine and then improve performance in Oracle Database 11g.

Course Number:
257188_eng

BASE DE DADOS ORACLE 11G: UTILIZAÇÃO DE DISPARADOR, DADOS ARMAZENADOS E MELHORIAS - [257195_ENG]

Overview/Description
To recognize the steps for improving performance, managing scalabilty, enhancing control and processing speed, and reducing network load using enhanced features such as compound triggers, SecureFile LOBs, and PIVOT operations

Target Audience
PL/SQL developers, developers, system analysts, data warehouse administrators, and application developers

Prerequisites
The learner should have experience and knowledge of SQL and PL/SQL from prior Oracle releases, and hands on experience using PL/SQL

Expected Duration (hours)
1.3

Lesson Objectives
Oracle Database 11g: Using Trigger, Data Warehousing, and Pivoting Enhancements
• identify the steps for creating and enabling a compound trigger and control its firing order using new trigger clauses.
• recognize the steps for implementing SecureFile LOBs.
• recognize the steps for performing PIVOT and UNPIVOT operations in various ways on the server side.
• create reports with the PIVOT operator.

Course Number:
257195_eng

BASE DE DADOS ORACLE 11G: UTILIZAÇÃO DO DEPURADOR PL/SQL, COLECÇÕES E DADOS ARMAZENADOS - [257202_ENG]

Overview/Description
To recognize ways to utilize the PL/SQL Debugger to analyze your code, identify the uses and benefits of collections, and identify the steps for employing data warehousing enhancements to improve query execution times.

Target Audience
PL/SQL developers, developers, system analysts, data warehouse administrators, and application developers

Prerequisites
The learner should have experience and knowledge of SQL and PL/SQL from prior Oracle releases, and hands on experience using PL/SQL

Expected Duration (hours)
1.2

Lesson Objectives
Oracle Database 11g: Using the PL/SQL Debugger, Collections, and Data Warehousing
• identify the steps for using the PL/SQL Debugger tool in SQL Developer.
• debug a procedure using the PL/SQL Debugger.
• recognize the steps for making effective use of collections in PL/SQL and deciding which is the best collection to use in a given scenario.
• recognize the steps for using materialized views and query rewrite enhancements to improve query execution times.

Course Number:
257202_eng

BASE DE DADOS ORACLE 11G: FUNDAMENTOS SQL I

BASE DE DADOS ORACLE 11G: UTILIZAÇÃO DE SQL PARA QUESTIONAR A SUA BADE DE DADOS - [257492_ENG]

Overview/Description
To identify the concepts and components of an Oracle Database 11g database, recognize how to retrieve information from it using SQL, and identify the steps for sorting, limiting, modifying, and formatting this information.

Target Audience
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.

Prerequisites
Familiarity with Data Processing Concepts and Techniques. Ability to use a graphical user interface (GUI)

Expected Duration (hours)
2.2

Lesson Objectives
Oracle Database 11g: Using SQL to Query Your Database
• identify the functions, capabilities, and terminology associated with Oracle Database 11g's components and relational databases in general.
• recognize the steps for using Oracle SQL Developer to create a new database connection and browse tables.
• recognize the steps for using the SQL SELECT statement to retrieve different sets of data from a database.
• recognize the steps for limiting and ordering the rows returned by a SQL query.
• recognize ways to sort data returned by a SQL query, using substitution variables as well as the DEFINE and VERIFY commands.
• recognize the steps for using SQL functions to modify, format, and otherwise manipulate returned data.
• identify and write SQL queries to display, sort, and format output in a given scenario.

Course Number:
257492_eng

BASE DE DADOS ORACLE 11G: FUNÇÕES DE TRANSFORMAÇÃO, FUNÇÕES DE GRUPO E UNIÕES - [257503_ENG]

Overview/Description
To recognize the steps for writing queries that convert data from one type to another, specify conditions, perform calculations on groups of rows or even tables, and return values from more than one table.

Target Audience
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.

Prerequisites
Familiarity with Data Processing Concepts and Techniques. Ability to use a graphical user interface (GUI)

Expected Duration (hours)
2.0

Lesson Objectives
Oracle Database 11g: Conversion Functions, Group Functions, and Joins
• identify the steps for using functions to convert character, date, and numeric values and perform operations pertaining to null values.
• recognize the steps for using the CASE expression and the DECODE function to implement conditional processing.
• identify and write queries that convert data types and implement conditional processing, in a given scenario.
• recognize the benefits of using group functions to return values for groups of rows.
• identify the steps for creating, restricting, and nesting group functions.
• identify the steps for using joins to return data from more than one table.
• write queries that calculate values for groups of data and return values from multiple tables in a given scenario.

Course Number:
257503_eng

BASE DE DADOS ORACLE 11G: SUBQUERIES, OPERADORES SET E MANIPULAÇÃO DE DADOS - [257513_ENG]

Overview/Description
To identify the steps for manipulating queries to return the data you need, using subqueries and set operators, and also for manipulating the actual data using INSERT, UPDATE, DELETE and other data manipulation language (DML) statements.

Target Audience
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.

Prerequisites
Familiarity with Data Processing Concepts and Techniques. Ability to use a graphical user interface (GUI)

Expected Duration (hours)
1.9

Lesson Objectives
Oracle Database 11g: Subqueries, Set Operators, and Data Manipulation
• recognize the steps for using subqueries inside other queries to perform various actions.
• identify the steps for using set operators to combine the results of two or more queries.
• write queries using set operators.
• identify the steps for adding new rows to a table, modifying table data, and removing rows.
• recognize the steps for controlling database transactions, and implementing read consistency.
• insert, update and delete rows in a table, and control data transactions to it.

Course Number:
257513_eng

BASE DE DADOS ORACLE 11G: UTILIZAÇÃO DE DDL, VISTAS, SEQUÊNCIAS, ÍNDICES E SINÓNIMOS - [257522_ENG]

Overview/Description
To recognize the steps for creating, defining, and dropping tables , manipulating how their data can be viewed, and using schema objects to generate integers, improve queries, and rename tables.

Target Audience
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.

Prerequisites
Familiarity with Data Processing Concepts and Techniques. Ability to use a graphical user interface (GUI)

Expected Duration (hours)
1.8

Lesson Objectives
Oracle Database 11g: Using DDL, Views, Sequences, Indexes, and Synonyms
• recognize the steps for creating, defining, and naming a table, and for specifying data types for its columns.
• recognize the steps for using constraints to prevent invalid data entry into tables.
• recognize the steps for altering or dropping a table.
• identify the steps for creating and manipulating views to view or hide a table's data.
• recognize the steps for using sequences to create integers, using indexes to improve the performance of queries, and using synonyms to give a table an alternative name.
• create a new table and create and use a sequence, index, and synonym.

Course Number:
257522_eng

BASE DE DADOS ORACLE 11G: FUNDAMENTOS SQL II

BASE DE DADOS ORACLE 11G: CONTROLO DO ACESSO DO UTILIZADOR E GESTÃO DE OBJECTOS DE ESQUEMA - [257867_ENG]

Overview/Description
To recognize the steps for controlling user access to objects and also for maintaining these objects by dropping columns and adding constraints and indexes.

Target Audience
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.

Prerequisites
Familiarity with Data Processing Concepts and Techniques. Ability to use a graphical user interface (GUI).

Expected Duration (hours)
1.8

Lesson Objectives
Oracle Database 11g: Controlling User Access and Managing Schema Objects
• identify the steps for granting and revoking system and object privileges.
• grant privileges to users in a given scenario.
• recognize the steps for altering a table by adding, modifying, and dropping columns.
• recognize the steps for adding and manipulating constraints and for creating indexes.
• identify the steps for recovering your database using flashback, and for manipulating external data.
• alter a table by dropping columns and adding constraints and indexes.

Course Number:
257867_eng

BASE DE DADOS ORACLE 11G: OPINIÕES DE DICIONÁRIO DE DADOS E GRANDES SÉRIES DE DADOS - [257876_ENG]

Overview/Description
To recognize the steps for querying data dictionary views to viewsschema objects, and for performing operations on large amounts of data, such as inserting data into multiple tables and merging table rows.

Target Audience
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.

Prerequisites
Familiarity with Data Processing Concepts and Techniques. Ability to use a graphical user interface (GUI).

Expected Duration (hours)
1.7

Lesson Objectives
Oracle Database 11g: Data Dictionary Views and Large Data Sets
• identify the steps for using data dictionary views to find information about tables, constraints, views, sequences, and synonyms.
• query the appropriate dictionary views to find information about schema objects in a given scenario.
• recognize the steps for manipulating data using subqueries and explicit default values.
• identify the steps for inserting into multiple tables, merging rows in tables, and tracking changes in data.
• manipulate large data sets using multitable INSERT and MERGE operations.

Course Number:
257876_eng

BASE DE DADOS ORACLE 11G: GESTÃO DE DADOS EM FUSOS HORÁRIOS DIFERENTES - [257884_ENG]

Overview/Description
To identify the steps for managing data in different time zones in Oracle Database 11g, for managing time intervals, and for using datetime functions.

Target Audience
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.

Prerequisites
Familiarity with Data Processing Concepts and Techniques. Ability to use a graphical user interface (GUI).

Expected Duration (hours)
1.3

Lesson Objectives
Oracle Database 11g: Managing Data in Different Time Zones
• recognize the steps for managing time zones and time intervals.
• recognize the steps for using datetime functions to manage dates and time in Oracle Database 11g.
• display time zone offsets in a given scenario.
• extract and return the value of a datetime field in a given scenario.

Course Number:
257884_eng

BASE DE DADOS ORACLE 11G: UTILIZAÇÃO DE SUBQUERIES E EXPRESSÕES REGULARES - [257896_ENG]

Overview/Description
To recognize the steps for retrieving data using subqueries and using regular expressions to search for, match, and replace strings.

Target Audience
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.

Prerequisites
Familiarity with Data Processing Concepts and Techniques. Ability to use a graphical user interface (GUI).

Expected Duration (hours)
1.8

Lesson Objectives
Oracle Database 11g: Using Subqueries and Regular Expressions
• identify the steps for writing multiple-column and scalar subqueries.
• recognize the steps for solving problems by using correlated subqueries and the WITH clause.
• write multiple-column, correlated, and scalar subqueries in a given scenario and solve a problem using the WITH clause.
• recognize the benefits of implementing complex match logic in the database, using regular expressions.
• identify the steps for using regular expressions functions and for accessing subexpressions.
• use regular expression functions to search for, replace, and manipulate data, and also add a CHECK constraint to a column.

Course Number:
257896_eng

BASE DE DADOS ORACLE 11G: FUNDAMENTOS PL/SQL

BASE DE DADOS ORACLE 11G: VARIÁVEIS, ATRIBUTOS E INDICAÇÕES EXECUTÁVEIS PL/SQL - [257801_ENG]

Overview/Description
To identify the steps for getting started with PL/SQL, recognizing the benefits of the available tools, creating basic statements, declaring variables, testing code, and adhering to scoping and nesting rules.

Target Audience
Application developers, database designers, database administrators, forms developers, PL/SQL developers, and technical consultants

Prerequisites
The learner should have experience and knowledge with SQL, specifically the Oracle Database 11g: SQL Fundamentals I and Oracle Database 11g: SQL Fundamentals II learning paths.

Expected Duration (hours)
1.9

Lesson Objectives
Oracle Database 11g: PL/SQL Variables, Attributes, and Executable Statements
• recognize the features and capabilities of SQL Developer, SQL*Plus, and JDeveloper.
• identify the features and benefits of PL/SQL and identify the steps for building basic PL/SQL blocks.
• identify the steps for declaring and initializing PL/SQL variables.
• identify the uses of different PL/SQL data types, the %TYPE attribute, and BIND variables.
• identify the steps for constructing executable statements using various PL/SQL block elements.
• evaluate a block of PL/SQL code with respect to scoping and nesting rules, and write and test PL/SQL blocks.

Course Number:
257801_eng

BASE DE DADOS ORACLE 11G: UTILIZANDO DML, DDL, CURSORES, ESTRUTURAS DE CONTROLO E LOOPS - [257810_ENG]

Overview/Description
To identify the steps for using PL/SQL to manipulate data, control transactions, determine the outcome of statements, and create loops and conditional control structures.

Target Audience
Application developers, database designers, database administrators, forms developers, PL/SQL developers, and technical consultants

Prerequisites
The learner should have experience and knowledge with SQL, specifically the Oracle Database 11g: SQL Fundamentals I and Oracle Database 11g: SQL Fundamentals II learning paths.

Expected Duration (hours)
1.3

Lesson Objectives
Oracle Database 11g: Using DML, DDL, Cursors, Control Structures, and Loops
• recognize the steps for performing basic data manipulation and transaction control in PL/SQL, and for determining the outcome of SQL statements.
• identify the steps for writing control structures, such as IF statements and CASE expressions, in a PL/SQL block.
• recognize the steps for writing and identifying loop statements.
• create PL/SQL blocks that incorporate loops and conditional control structures.

Course Number:
257810_eng

BASE DE DADOS ORACLE 11G: UTILIZANDO TIPOS DE DADOS, ÍNDICES POR TABELA E CURSORES EM PL/SQL - [257817_ENG]

Overview/Description
To recognize ways to create user-defined PL/SQL records and INDEX BY tables, and identify the steps for declaring and controlling explicit cursors and cursors with parameters.

Target Audience
Application developers, database designers, database administrators, forms developers, PL/SQL developers, and technical consultants

Prerequisites
The learner should have experience and knowledge with SQL, specifically the Oracle Database 11g: SQL Fundamentals I and Oracle Database 11g: SQL Fundamentals II learning paths.

Expected Duration (hours)
1.7

Lesson Objectives
Oracle Database 11g: Using Data Types, INDEX BY Tables, and Cursors in PL/SQL
• recognize the steps for creating user-defined PL/SQL records and records with the %ROWTYPE attribute.
• recognize the steps for creating an INDEX BY table and table of records, and identify the uses of nested tables and VARRAYs.
• define, create, and use INDEX BY tables and a PL/SQL record in a given scenario.
• identify the steps for declaring and controlling explicit cursors, and for writing FOR loops to fetch data from them.
• recognize the steps for declaring and using cursors with parameters, locking rows, and referencing the current row in an explicit cursor.

Course Number:
257817_eng

BASE DE DADOS ORACLE 11G: TRABALHANDO COM EXCEPÇÕES, SUB PROGRAMAS, PRODUTOR J E CURSORES REF - [257825_ENG]

Overview/Description
To recognize ways to handle unanticipated errors in PL/SQL, write stored procedures and functions, deploy Java applications and Web services, and use cursor variables.

Target Audience
Application developers, database designers, database administrators, forms developers, PL/SQL developers, and technical consultants

Prerequisites
The learner should have experience and knowledge with SQL, specifically the Oracle Database 11g: SQL Fundamentals I and Oracle Database 11g: SQL Fundamentals II learning paths.

Expected Duration (hours)
2.0

Lesson Objectives
Oracle Database 11g: Working with Exceptions, Subprograms, JDeveloper, and REF Cursors
• identify the steps for trapping non-predefined exceptions in PL/SQL.
• recognize the steps for trapping user-defined exceptions.
• create an exception handler in a given scenario.
• identify the steps for creating and invoking simple stored procedures and functions.
• recognize the scope and capabilities of JDeveloper for developing and deploying Java applications and Web services.
• recognize the steps for using cursor variables to pass query result sets, and for fetching rows from them.

Course Number:
257825_eng

BASE DE DADOS ORACLE 11G: DESENVOLVIMENTO DE UNIDADES DE PROGRAMA PL/SQL

BASE DE DADOS ORACLE 11G: SUB PROGRAMAS, PACOTES, E AND MANIPULAÇÃO DE EXCEPÇÃO EM PL/SQL - [259958_ENG]

Overview/Description
To identify the steps for designing, debugging, invoking, and bundling PL/SQL subprograms, procedures and functions, and also for handling their exceptions.

Target Audience
Application developers, database designers, database administrators, forms developers, PL/SQL developers, and technical consultants

Prerequisites
The learner should have experience and knowledge with SQL, specifically the Oracle Database 11g: SQL Fundamentals I and Oracle Database 11g: SQL Fundamentals II learning

Expected Duration (hours)
2.3

Lesson Objectives
Oracle Database 11g: Subprograms, Packages, and Exception Handling in PL/SQL
• identify the benefits of modularized and layered subprogram design.
• recognize the steps for creating and calling procedures and passing parameters.
• identify the steps for handling exceptions in procedures and for dropping procedures.
• recognize the steps for creating and invoking functions.
• recognize the steps for using SQL Developer to debug PL/SQL subprograms.
• identify the benefits and components of a package, and recognize the steps for creating one.
• create a package specification and package body in a given scenario, and invoke the package's constructs.

Course Number:
259958_eng

BASE DE DADOS ORACLE 11G: PACOTES, SQL DINÂMICO, E CONSIDERAÇÕES DE CÓDIGO EM PL/SQL - [259959_ENG]

Overview/Description
To recognize the steps for creating and using efficient PL/SQL packages, including Oracle-supplied packages, executing dynamic SQL, and improving the performance of code.

Target Audience
Application developers, database designers, database administrators, forms developers, PL/SQL developers, and technical consultants

Prerequisites
The learner should have experience and knowledge with SQL, specifically the Oracle Database 11g: SQL Fundamentals I and Oracle Database 11g: SQL Fundamentals II learning

Expected Duration (hours)
2.3

Lesson Objectives
Oracle Database 11g: Packages, Dynamic SQL, and Coding Considerations in PL/SQL
• recognize the steps for overloading subprograms, using forward declarations, writing package initialization blocks, and maintaining persistent package state.
• identify the steps for using the Oracle-supplied packages DBMS_OUTPUT, UTL_FILE, and UTL_MAIL.
• recognize the steps for using Oracle-supplied packages to generate a simple Web page and schedule PL/SQL code for execution.
• identify the steps for constructing and executing SQL statements at run time, using Native Dynamic SQL (NDS) statements in PL/SQL.
• alter a package so that it contains overloaded subprograms, use an Oracle-supplied package, and execute dynamic SQL in a given scenario.
• identify the steps for designing packages so that code is easy to maintain, efficient, and readable, and so that PL/SQL applications perform better.
• identify the steps for binding whole arrays of values in a single operation, and for retrieving information about a row affected by a SQL operation.

Course Number:
259959_eng

BASE DE DADOS ORACLE 11G: UTILIZAÇÃO DE TRIGGERS, DO COMPILADOR PL/SQL E GESTÃO DE CÓDIGO - [259960_ENG]

Overview/Description
To identify the steps for creating, managing, and using database triggers, and for using the new PL/SQL compiler, its initialization parameters, and its compile time warnings.

Target Audience
Application developers, database designers, database administrators, forms developers, PL/SQL developers, and technical consultants

Prerequisites
The learner should have experience and knowledge with SQL, specifically the Oracle Database 11g: SQL Fundamentals I and Oracle Database 11g: SQL Fundamentals II learning

Expected Duration (hours)
2.0

Lesson Objectives
Oracle Database 11g: Using Triggers, the PL/SQL Compiler, and Managing Code
• identify the steps for creating and using database triggers.
• recognize the steps for enabling, disabling, testing, managing, and removing database triggers.
• identify the steps for creating and using compound, DDL, and event database triggers.
• create statement and row triggers, including a trigger for a business rule and a package with triggers that resolve a mutating table issue.
• recognize the benefits and capabilities of the PL/SQL compiler and its parameters.
• recognize the steps for using the PL/SQL compiler initialization parameters, compiling a procedure, and managing compiler warnings.

Course Number:
259960_eng

BASE DE DADOS ORACLE 11G: GESTÃO DE CÓDIGO CODE E DEPENDÊNCIAS - [259961_ENG]

Overview/Description
To identify the steps for performing conditional compilation to selectively use PL/SQL code, wrapping code, and tracking dependencies.

Target Audience
Application developers, database designers, database administrators, forms developers, PL/SQL developers, and technical consultants

Prerequisites
The learner should have experience and knowledge with SQL, specifically the Oracle Database 11g: SQL Fundamentals I and Oracle Database 11g: SQL Fundamentals II learning

Expected Duration (hours)
1.3

Lesson Objectives
Oracle Database 11g: Managing PL/SQL Code and Dependencies
• identify the steps for selectively including PL/SQL source code by using conditional compilation, and for wrapping a PL/SQL unit.
• recognize the steps for predicting how changing a database object affects procedures and functions by tracking procedural dependencies.
• recognize the steps for managing remote dependencies and recompiling a PL/SQL program unit.
• use conditional compilation, wrap PL/SQL code, and manage dependencies in a given scenario.

Course Number:
259961_eng

BASE DE DADOS ORACLE 11G: INTRODUÇÃO AO SQL

BASE DE DADOS ORACLE 11G: CONSULTA DE UMA BASE DE DADOS COM SQL - [260277_ENG]

Target Audience
Business and systems analysts, application developers, PL/SQL developers, forms developers, and data warehouse administrators.

Prerequisites
Familiarity with data processing concepts and techniques

Expected Duration (hours)
2.2

Lesson Objectives
Oracle Database 11g: Querying a Database with SQL
• identify the functions, capabilities, and terminology associated with Oracle Database 11g's components and relational databases in general.
• recognize the steps for using Oracle SQL Developer to create a new database connection and browse tables.
• recognize the steps for using the SQL SELECT statement to retrieve different sets of data from a database.
• recognize the steps for limiting and ordering the rows returned by a SQL query.
• recognize ways to sort data returned by a SQL query, using substitution variables as well as the DEFINE and VERIFY commands.
• recognize the steps for using SQL functions to modify, format, and otherwise manipulate returned data.
• identify and write SQL queries to display, sort, and format output in a given scenario.

Course Number:
260277_eng

BASE DE DADOS ORACLE 11G: FUNÇÕES DE CONVERSAÇÃO, EXPRESSÕES CONDICIONAIS, FUNÇÕES DE GRUPO E UNIÕES - [260278_ENG]

Target Audience
Business and systems analysts, application developers, PL/SQL developers, forms developers, and data warehouse administrators.

Prerequisites
Familiarity with data processing concepts and techniques

Expected Duration (hours)
2.0

Lesson Objectives
Oracle Database 11g: Conversion Functions, Conditional Expressions, Group Functions, and Joins
• identify the steps for using functions to convert character, date, and numeric values and perform operations pertaining to null values.
• recognize the steps for using the CASE expression and the DECODE function to implement conditional processing.
• identify and write queries that convert data types and implement conditional processing, in a given scenario.
• recognize the benefits of using group functions to return values for groups of rows.
• identify the steps for creating, restricting, and nesting group functions.
• identify the steps for using joins to return data from more than one table.
• write queries that calculate values for groups of data and return values from multiple tables in a given scenario.

Course Number:
260278_eng

BASE DE DADOS ORACLE 11G: MANIPULAÇÃO DE QUESTIONÁRIOS E DADOS - [260279_ENG]

Target Audience
Business and systems analysts, application developers, PL/SQL developers, forms developers, and data warehouse administrators.

Prerequisites
Familiarity with data processing concepts and techniques

Expected Duration (hours)
1.9

Lesson Objectives
Oracle Database 11g: Manipulating Queries and Data
• recognize the steps for using subqueries inside other queries to perform various actions.
• identify the steps for using set operators to combine the results of two or more queries.
• write queries using set operators.
• identify the steps for adding new rows to a table, modifying table data, and removing rows.
• recognize the steps for controlling database transactions, and implementing read consistency.
• insert, update and delete rows in a table, and control data transactions to it.

Course Number:
260279_eng

BASE DE DADOS ORACLE 11G: UTILIZAÇÃO DE DDL, VISTAS E OBJECTOS DE ESQUEMA - [260280_ENG]

Target Audience
Business and systems analysts, application developers, PL/SQL developers, forms developers, and data warehouse administrators.

Prerequisites
Familiarity with data processing concepts and techniques

Expected Duration (hours)
1.8

Lesson Objectives
Oracle Database 11g: Using DDL, Views, and Schema Objects
• recognize the steps for creating, defining, and naming a table, and for specifying data types for its columns.
• recognize the steps for using constraints to prevent invalid data entry into tables.
• recognize the steps for altering or dropping a table.
• identify the steps for creating and manipulating views to view or hide a table's data.
• recognize the steps for using sequences to create integers, using indexes to improve the performance of queries, and using synonyms to give a table an alternative name.
• create a new table and create and use a sequence, index, and synonym.

Course Number:
260280_eng

BASE DE DADOS ORACLE 11G: CONTROLO DE ACESSO DE UTILIZADOR E GESTÃO DE OBJECTOS - [260281_ENG]

Overview/Description
To recognize the steps for controlling user access to objects and also for maintaining these objects by dropping columns and adding constraints and indexes.

Target Audience
Business and systems analysts, application developers, PL/SQL developers, forms developers, and data warehouse administrators.

Prerequisites
Familiarity with data processing concepts and techniques

Expected Duration (hours)
1.8

Lesson Objectives
Oracle Database 11g: Controlling User Access and Managing Objects
• identify the steps for granting and revoking system and object privileges.
• grant privileges to users in a given scenario.
• recognize the steps for altering a table by adding, modifying and dropping columns.
• recognize the steps for adding and manipulating constraints and for creating indexes.
• identify the steps for recovering your database using flashback, and for manipulating external data.
• alter a table by dropping columns and adding constraints and indexes.

Course Number:
260281_eng

BASE DE DADOS ORACLE 11G: GESTÃO DE VISTAS DE DICIONÁRIOS DE DADOS E GRANDES SÉRIES DE DADOS - [260282_ENG]

Target Audience
Business and systems analysts, application developers, PL/SQL developers, forms developers, and data warehouse administrators.

Prerequisites
Familiarity with data processing concepts and techniques

Expected Duration (hours)
1.7

Lesson Objectives
Oracle Database 11g: Managing Data Dictionary Views and Large Data Sets
• identify the steps for using data dictionary views to find information about tables, constraints, views, sequences, and synonyms.
• query the appropriate dictionary views to find information about schema objects in a given scenario.
• recognize the steps for manipulating data using subqueries and explicit default values.
• identify the steps for inserting into multiple tables, merging rows in tables, and tracking changes to data.
• manipulate large data sets using multitable INSERT and MERGE operations.

Course Number:
260282_eng

BASE DE DADOS ORACLE 11G: GESTÃO DE FUSO HORÁRIO E FUNÇÕES DE DATETIME - [260283_ENG]

Overview/Description
To identify the steps for managing data in different time zones in Oracle Database 11g, for managing time intervals, and for using datetime functions.

Target Audience
Business and systems analysts, application developers, PL/SQL developers, forms developers, and data warehouse administrators.

Prerequisites
Familiarity with data processing concepts and techniques

Expected Duration (hours)
1.3

Lesson Objectives
Oracle Database 11g: Managing Time Zones and Datetime Functions
• recognize the steps for managing time zones and time intervals.
• recognize the steps for using datetime functions to manage dates and times in Oracle Database 11g.
• display time zone offsets in a given scenario.
• extract and return the value of a datetime field in a given scenario.

Course Number:
260283_eng

BASE DE DADOS ORACLE 11G: SUBQUERIES E EXPRESSÕES REGULARES - [260284_ENG]

Overview/Description
To recognize the steps for retrieving data using subqueries and using regular expressions to search for, match, and replace strings.

Target Audience
Business and systems analysts, application developers, PL/SQL developers, forms developers, and data warehouse administrators.

Prerequisites
Familiarity with data processing concepts and techniques

Expected Duration (hours)
1.8

Lesson Objectives
Oracle Database 11g: Subqueries and Regular Expressions
• identify the steps for writing multiple-column and scalar subqueries.
• recognize the steps for solving problems by using correlated subqueries and the WITH clause.
• write multiple-column, correlated, and scalar subqueries in a given scenario and solve a problem using the WITH clause.
• recognize the benefits of implementing complex match logic in the database, using regular expressions.
• identify the steps for using regular expressions functions and for accessing subexpressions.
• use regular expressions functions to search for, replace, and manipulate data, and also add a CHECK constraint to a column.

Course Number:
260284_eng

BASE DE DADOS ORACLE 11G: PROGRAMAÇÃO COM PL/SQL

BASE DE DADOS ORACLE 11G: ÍNICIO COM PL/SQL - [260269_ENG]

Target Audience
System analysts, PL/SQL developers, forms and application developers, database administrators, technical consultants, and portal developers.

Prerequisites
Previous programming experience and knowledge of SQL

Expected Duration (hours)
1.9

Lesson Objectives
Oracle Database 11g: Getting Started With PL/SQL
• recognize the features and capabilities of SQL Developer, SQL*Plus, and JDeveloper.
• identify the features and benefits of PL/SQL and identify the steps for building basic PL/SQL blocks.
• identify the steps for declaring and initializing PL/SQL variables.
• identify the uses of different PL/SQL data types, the %TYPE attribute, and BIND variables.
• identify the steps for constructing executable statements using various PL/SQL block elements.
• evaluate a block of PL/SQL code with respect to scoping and nesting rules, and write and test PL/SQL blocks.

Course Number:
260269_eng

BASE DE DADOS ORACLE 11G: UTILIZAÇÃO DE DML, DDL, CURSORES, LOOPS, E ESTRTURAS DE CONTROLO - [260270_ENG]

Overview/Description
To identify the steps for using PL/SQL to manipulate data, control transactions, determine the outcome of statements, and create loops and conditional control structures.

Target Audience
System analysts, PL/SQL developers, forms and application developers, database administrators, technical consultants, and portal developers.

Prerequisites
Previous programming experience and knowledge of SQL

Expected Duration (hours)
1.3

Lesson Objectives
Oracle Database 11g: Using DML, DDL, Cursors, Loops, and Control Structures
• recognize the steps for performing basic data manipulation and transaction control in PL/SQL, and for determining the outcome of SQL statements.
• identify the steps for writing control structures, such as IF statements and CASE expressions, in a PL/SQL block.
• recognize the steps for writing and identifying loop statements.
• create PL/SQL blocks that incorporate loops and conditional control structures.

Course Number:
260270_eng

BASE DE DADOS ORACLE 11G: UTILIZAÇÃO DE TIPOS DE DADOS, ÍNDICE POR TABELA E CURSORES - [260271_ENG]

Overview/Description
To recognize ways to create user-defined PL/SQL records and INDEX BY tables, and identify the steps for declaring and controlling explicit cursors and cursors with parameters.

Target Audience
System analysts, PL/SQL developers, forms and application developers, database administrators, technical consultants, and portal developers.

Prerequisites
Previous programming experience and knowledge of SQL

Expected Duration (hours)
1.7

Lesson Objectives
Oracle Database 11g: Using Data Types, INDEX BY Tables, and Cursors
• recognize the steps for creating user-defined PL/SQL records and records with the %ROWTYPE attribute.
• recognize the steps for creating an INDEX BY table and table of records, and identify the uses of nested tables and VARRAYs.
• define, create, and use INDEX BY tables and a PL/SQL record in a given scenario.
• identify the steps for declaring and controlling explicit cursors, and for writing FOR loops to fetch data from them.
• recognize the steps for declaring and using cursors with parameters, locking rows, and referencing the current row in an explicit cursor.

Course Number:
260271_eng

BASE DE DADOS ORACLE 11G: UTILIZAÇÃO DE EXCEPÇÕES, SUB PROGRAMAS, PRODUTORES J, E CURSORES REF - [260272_ENG]

Overview/Description
To recognize ways to handle unanticipated errors in PL/SQL, write stored procedures and functions, deploy Java applications and Web services, and use cursor variables.

Target Audience
System analysts, PL/SQL developers, forms and application developers, database administrators, technical consultants, and portal developers.

Prerequisites
Previous programming experience and knowledge of SQL

Expected Duration (hours)
2.0

Lesson Objectives
Oracle Database 11g: Using Exceptions, Subprograms, JDeveloper, and REF Cursors
• identify the steps for trapping non-predefined exceptions in PL/SQL.
• recognize the steps for trapping user-defined exceptions.
• create an exception handler in a given scenario.
• identify the steps for creating and invoking simple stored procedures and functions.
• recognize the scope and capabilities of JDeveloper for developing and deploying Java applications and Web services.
• recognize the steps for using cursor variables to pass query result sets, and for fetching rows from them.

Course Number:
260272_eng

BASE DE DADOS ORACLE 11G: SUB PROGRAMAS, PACOTES E MANUTENÇÃO EXCEPCIONAL - [260273_ENG]

Overview/Description
To identify the steps for designing, debugging, invoking, and bundling PL/SQL subprograms, procedures and functions, and also for handling their exceptions.

Target Audience
System analysts, PL/SQL developers, forms and application developers, database administrators, technical consultants, and portal developers.

Prerequisites
Previous programming experience and knowledge of SQL

Expected Duration (hours)
2.3

Lesson Objectives
Oracle Database 11g: Subprograms, Packages, and Exception Handling
• identify the benefits of modularized and layered subprogram design.
• recognize the steps for creating and calling procedures and passing parameters.
• identify the steps for handling exceptions in procedures and for dropping procedures.
• recognize the steps for creating and invoking functions.
• recognize the steps for using SQL Developer to debug PL/SQL subprograms.
• identify the benefits and components of a package, and recognize the steps for creating one.
• create a package specification and package body in a given scenario, and invoke the package's constructs.

Course Number:
260273_eng

BASE DE DADOS ORACLE 11G: PACOTES, SQL DINÂMICO, E CONSIDERAÇÕES DE CÓDIGO - [260274_ENG]

Overview/Description
To recognize the steps for creating and using efficient PL/SQL packages, including Oracle-supplied packages, executing dynamic SQL, and improving the performance of code.

Target Audience
System analysts, PL/SQL developers, forms and application developers, database administrators, technical consultants, and portal developers.

Prerequisites
Previous programming experience and knowledge of SQL

Expected Duration (hours)
2.3

Lesson Objectives
Oracle Database 11g: Packages, Dynamic SQL, and Coding Considerations
• recognize the steps for overloading subprograms, using forward declarations, writing package initialization blocks, and maintaining persistent package state.
• identify the steps for using the Oracle-supplied packages DBMS_OUTPUT, UTL_FILE, and UTL_MAIL.
• recognize the steps for using Oracle-supplied packages to generate a simple Web page and schedule PL/SQL code for execution.
• identify the steps for constructing and executing SQL statements at run time, using native dynamic SQL statements in PL/SQL.
• alter a package so that it contains overloaded subprograms, use an Oracle-supplied package, and execute dynamic SQL in a given scenario.
• identify the steps for designing packages so that code is easy to maintain, efficient, and readable, and so that PL/SQL applications perform better.
• Identify the steps for binding whole arrays of values in a single operation, and for retrieving information about a row affected by a SQL operation.

Course Number:
260274_eng

BASE DE DADOS ORACLE 11G: UTILIZAÇÃO DE TRIGGERS E DO COMPILADOR PL/SQL - [260275_ENG]

Overview/Description
To identify the steps for creating, managing, and using database triggers, and for using the new PL/SQL compiler, its initialization parameters, and its compile time warnings.

Target Audience
System analysts, PL/SQL developers, forms and application developers, database administrators, technical consultants, and portal developers.

Prerequisites
Previous programming experience and knowledge of SQL

Expected Duration (hours)
2.0

Lesson Objectives
Oracle Database 11g: Using Triggers and the PL/SQL Compiler
• identify the steps for creating and using database triggers.
• recognize the steps for enabling, disabling, testing, managing, and removing database triggers.
• identify the steps for creating and using compound, DDL, and event database triggers.
• create statement and row triggers, including a trigger for a business rule and a package with triggers that resolve a mutating table issue.
• recognize the benefits and capabilities of the PL/SQL compiler and its parameters.
• recognize the steps for using the PL/SQL compiler initialization parameters, compiling a procedure, and managing compiler warnings.

Course Number:
260275_eng

BASE DE DADOS ORACLE 11G: CÓDIGO E DEPENDÊNCIA DE GESTÃO PL/SQL - [260276_ENG]

Overview/Description
To identify the steps for performing conditional compilation to selectively use PL/SQL code, wrapping code, and tracking dependencies.

Target Audience
System analysts, PL/SQL developers, forms and application developers, database administrators, technical consultants, and portal developers.

Prerequisites
Previous programming experience and knowledge of SQL

Expected Duration (hours)
1.3

Lesson Objectives
Oracle Database 11g: PL/SQL Code and Dependency Management
• identify the steps for selectively including PL/SQL source code by using conditional compilation, and for wrapping a PL/SQL unit.
• recognize the steps for predicting how changing a database object affects procedures and functions by tracking procedural dependencies.
• recognize the steps for managing remote dependencies and recompiling a PL/SQL program unit.
• use conditional compilation, wrap PL/SQL code, and manage dependencies in a given scenario.

Course Number:
260276_eng

BASE DE DADOS ORACLE 11G: AJUSTE DO DESEMPENHO

BASE DE DADOS ORACLE 11G: METODOLOGIA E FERRAMENTAS DO AJUSTE DE DESEMPENHO - [od_odpt_a01_it_enus]

Overview/Description
Oracle Database 11g provides a variety of tools that can be used for performance tuning in an Oracle database environment. These tools can be used to diagnose and tune common SQL-related and instance-related problems as well as proactively tune an Oracle database. One such tool – Enterprise Manager – can be used to monitor an Oracle database using the many performance-related pages it provides via a user-friendly graphical user interface. This course provides an introduction to performance tuning methodologies, effective tuning goals, and the types of performance data that can be gathered by diagnostic tools available in Oracle Database 11g. It also demonstrates how to use Time Model and Enterprise Manager to diagnose performance issues, and discusses using the various dynamic performance views (V$ views) to perform statistical analysis when diagnosing problems. The use of alert logs, user trace files, and wait events analysis are also explored in this introduction to performance tuning. This course helps to prepare you for the Oracle Database 11g: Performance Tuning exam which counts towards the Oracle Database 11g Performance Tuning Certified Expert designation.

Target Audience
A range of in-training or established IT professionals; Database Administrators; Support Engineers; Technical Consultants.

Prerequisites
Oracle Database 11g: Administration Workshop I Oracle Database 11g: Administration Workshop II

Expected Duration (hours)
1.5

Lesson Objectives
Oracle Database 11g: Performance Tuning Methodology and Tools
• identify the steps in both the general and Oracle tuning methodologies
• identify the characteristics of effective tuning goals
• recognize the three types of performance data gathered by diagnostic tools
• recognize the factors to consider when tuning DB time
• recognize how to use the time model to diagnose performance issues
• recognize how to view diagnostic information in Enterprise Manager
• recognize how you can use dynamic performance to view statistics
• recognize how to use dynamic performance views to display wait events
• recognize how to use Alert Logs to perform tuning
• identify ways to generate user trace files
• view diagnostic information in a given scenario
Course Number:
od_odpt_a01_it_enus

BASE DE DADOS ORACLE 11G: UTILIZAÇÃO AWR E DEFINIÇÃO DE PROBLEMAS - [od_odpt_a02_it_enus]

Overview/Description
Automatic Workload Repository (AWR) is the infrastructure that provides services to Oracle Database 11g components that collect, maintain, and utilize statistics for problem detection and self-tuning purposes. This course explains how to create and manage AWR snapshots, and demonstrates how to use the snapshots to generate individual AWR reports as well as AWR compares period reports. It discusses the identification of performance issues, setting the tuning priorities, how to tune depending on the particular application life cycle phase, and the steps involved in implementing migration, upgrade, and environment changes. The course also delves into the area of interpreting tuning diagnostics using Statspack – a set of scripts and PL/SQL packages that allow you to capture point-in-time performance data. It explains how to capture and manage Statspack snapshots and the generation and usage of Statspack reports for diagnostic analysis.

Target Audience
A range of in-training or established IT professionals; Database Administrators; Support Engineers; Technical Consultants.

Prerequisites
Oracle Database 11g: Administration Workshop I Oracle Database 11g: Administration Workshop II

Expected Duration (hours)
1.5

Lesson Objectives
Oracle Database 11g: Using AWR and Defining Problems
• identify the features of the AWR
• recognize how to create and manage AWR snapshots
• recognize how to run an AWR report
• recognize how to generate a Compare Periods report
• generate an AWR report in a given scenario
• generate a Compare Periods report in a given scenario
• recognize how to define problems
• recognize how to set tuning priorities
• identify factors to consider when tuning for different application life cycle phases
• identify the seven steps for implementing migration, upgrade, and environment changes
• recognize how business requirements affect performance
• identify how to file a performance service request
• recognize how to install Statspack
• recognize how to capture and manage Statspack snapshots
• recognize how to read Statspack performance reports

Course Number:
od_odpt_a02_it_enus

BASE DE DADOS ORACLE 11G: METRICAS, ALERTAS, LINHAS DE BASE, FERRAMENTAS AWR E SERVIÇOS - [od_odpt_a03_it_enus]

Overview/Description
Metrics, alerts, baselines, and thresholds are monitoring objects that can be used to monitor and manage the performance tuning of an Oracle Database 11g environment. Automatic Workload Repository (AWR) based tools can be used to tune automatic maintenance tasks and generate and read ADDM and ASH reports. This course demonstrates how to create static and repeating baselines, compute baseline statistics, define alert thresholds, and generate ADDM and ASH reports. In Oracle Database 11g you can configure, manage, and implement services to work with client applications using Database Resource Manager and the Scheduler. This course discusses the use of services for monitoring applications and demonstrates how to set performance-metric thresholds on services. It also explains how to configure services aggregation and tracing.

Target Audience
A range of in-training or established IT professionals; Database Administrators; Support Engineers; Technical Consultants.

Prerequisites
Oracle Database 11g: Administration Workshop I Oracle Database 11g: Administration Workshop II

Expected Duration (hours)
2.5

Lesson Objectives
Oracle Database 11g: Metrics, Alerts, Baselines, AWR Tools, and Services
• identify the features of metrics, alerts, and baselines
• recognize how to view metric history information, metric details, and histogram views
• recognize how to receive an alert when a specified threshold is exceeded
• identify the features of AWR baselines
• recognize how to create AWR baselines
• recognize how to manage AWR baselines
• recognize how to manage thresholds
• create and manage AWR baselines and thresholds
• recognize how to tune automatic maintenance tasks
• recognize how to generate and read ADDM reports
• identify the features of the Active Session History
• recognize how to generate ASH reports
• recognize how to configure and manage services
• recognize how to use services with client applications, the Database Resource Manager, and the Scheduler
• recognize how to set performance-metric thresholds on services
• recognize how to configure services aggregation and tracing

Course Number:
od_odpt_a03_it_enus

BASE DE DADOS ORACLE 11G: PROBLEMA COM INDICAÇÕES SQL E COM OPTIMIZADOR ORACLE - [od_odpt_a04_it_enus]

Overview/Description
Oracle Database 11g helps to identify problem SQL statements using Oracle Optimizer and execution plans. This course discusses SQL statement processing and the role of the Oracle Optimizer and execution plans. It also explains how to generate and view execution plans using the DBMS_XPLAN package, the EXPLAIN PLAN command, SQL*Plus AUTOTRACE command options, and the V$SQL_PLAN view. The functions of the Optimizer and how to influence and control the optimizer's behavior is discussed in detail, including the various query access paths that can be used, when to use different join methods and sort operations, how to manage and maintain indexes, and how to reorganize tables to optimize the processing of SQL statements.

Target Audience
A range of in-training or established IT professionals; Database Administrators; Support Engineers; Technical Consultants.

Prerequisites
Oracle Database 11g: Administration Workshop I Oracle Database 11g: Administration Workshop II

Expected Duration (hours)
2.5

Lesson Objectives
Oracle Database 11g: Problem SQL Statements and Oracle Optimizer
• match each phase in SQL statement processing with its features
• identify the steps in DML processing
• identify the operations performed by the Oracle optimizer
• recognize the features of execution plans
• recognize how to generate and view execution plans
• recognize how to use the SQL*Plus AUTOTRACE command options to view execution plans and statistics
• identify the steps involved in using the SQL Trace facility
• identify the functions of the query optimizer
• recognize how to influence and control the optimizer's behavior
• identify the scan types for retrieving data from the database
• recognize how to work with bitmap and B*Tree indexes
• identify when to use different join methods
• identify common sort operations
• recognize how to manage and maintain indexes
• recognize how to reorganize tables
• use AUTOTRACE to analyze statistics and execution plans in a given scenario

Course Number:
od_odpt_a04_it_enus

BASE DE DADOS ORACLE 11G: GESTÃO DE DESEMPENHO SQL E REPETIÇÃO DE BASE DE DADOS- [od_odpt_a05_it_enus]

Overview/Description
Database Replay allows you to test the impact of a system change by replaying a real-world workload on a test system before it is exposed to a production system. This course demonstrates how to use Database Replay to capture and replay workloads to test the impact of a system change. It also explains how to use SQL Performance Analyzer to ascertain performance gains following a database change and to test the impact of proposed changes. Maintaining SQL performance by managing changes to optimizer statistics, using Automatic SQL Tuning to automate the SQL tuning process, and setting up SQL plan management are also covered.

Target Audience
A range of in-training or established IT professionals; Database Administrators; Support Engineers; Technical Consultants.

Prerequisites
Oracle Database 11g: Administration Workshop I Oracle Database 11g: Administration Workshop II

Expected Duration (hours)
2.0

Lesson Objectives
Oracle Database 11g: SQL Performance Management and Database Replay
• recognize the steps in the SQL Performance Analyzer process
• recognize how to use the SQL Performance Analyzer with PL/SQL
• recognize how to manage changes to optimizer statistics to maintain SQL performance
• recognize how to use Automatic SQL Tuning to automate the SQL tuning process
• recognize how to set up SQL plan management
• seed SQL plan baselines from SQL Performance Analyzer in a given scenario
• recognize the steps in using Database Replay to test the impact of a system change
• recognize how to use the Enterprise Manager to capture workloads
• recognize how to replay workloads using the Enterprise Manager
• recognize how to use PL/SQL to capture and replay workloads

Course Number:
od_odpt_a05_it_enus

BASE DE DADOS ORACLE 11G: COMBINAÇÃO PARTILHADA E AJUSTE DOP AMORTECEDOR CACHE - [od_odpt_a06_it_enus]

Overview/Description
The buffer cache is an extremely important component for the performance, scalability, and reliability of the database. This course demonstrates how to identify the symptoms that indicate a buffer cache problem and how to use the various methods available to resolve common performance issues related to the buffer cache. It also discusses the sizing of the buffer cache and using views to analyze the buffer cache, and briefly covers multiple pool management. The fundamental purpose of the shared pool is to serve as a metadata cache. This course explains how to diagnose and resolve hard and soft-parsing problems and shared pool fragmentation issues. It also discusses various methods of tuning the shared pool, including sizing the shared pool, sizing the reserved area of the shared pool, keeping objects in the shared pool, and managing the results cache.

Target Audience
A range of in-training or established IT professionals; Database Administrators; Support Engineers; Technical Consultants.

Prerequisites
Oracle Database 11g: Administration Workshop I Oracle Database 11g: Administration Workshop II

Expected Duration (hours)
2.0

Lesson Objectives
Oracle Database 11g: Shared Pool and Buffer Cache Tuning
• recognize the features of the shared pool
• identify the role of AWR and Statspack reports indicators when diagnosing problems
• recognize how to avoid hard parses
• recognize how to avoid soft parses
• recognize how to reserve space in the shared pool
• recognize how to manage the results cache
• recognize the features of the buffer cache architecture
• identify the symptoms that indicate a buffer cache problem
• identify methods to resolve common performance issues related to the buffer cache
• recognize how to properly size the buffer cache
• manage the buffer cache in given scenarios

Course Number:
od_odpt_a06_it_enus

BASE DE DADOS ORACLE 11G: AJUSTE PGA, ESPAÇO TEMPORÁRIO E AMM - [od_odpt_a07_it_enus]

Overview/Description
Oracle Database 11g provides various methods for tuning, monitoring and managing memory and temporary tablespaces. Automatic Program Global Area (PGA) memory management adapts the SQL memory allocation based on PGA memory available, SQL operator needs, and system workload. A temporary tablespace is used to store transient data generated explicitly by the user and implicitly by the system. This course explains how to diagnose PGA memory and temporary tablespace issues and demonstrates how to size the PGA memory and manage temporary tablespaces. In addition, in Oracle 11g, Automatic Shared Memory Management (ASMM) uses dynamic System Global Area (SGA) and memory advisors to automatically adapt to workload changes. Automatic Memory Management (AMM) automates the sizing of PGA and SGA according to your workload. This course demonstrates the methods for enabling and configuring ASMM and AMM using Enterprise Manager, memory advisors, SQL, and V-dollar views for monitoring memory management.

Target Audience
A range of in-training or established IT professionals; Database Administrators; Support Engineers; Technical Consultants.

Prerequisites
Oracle Database 11g: Administration Workshop I Oracle Database 11g: Administration Workshop II

Expected Duration (hours)
1.5

Lesson Objectives
Oracle Database 11g: Tuning PGA, Temporary Space, and AMM
• identify how to diagnose PGA memory issues
• recognize how to size the PGA memory
• recognize how to manage temporary tablespaces
• identify the components of Automatic Shared Memory Management
• recognize how to configure Automatic Shared Memory Management (ASMM)
• recognize how to configure Automatic Memory Management
• configure memory in a given scenario
• tune PGA memory in a given scenario
• create a temporary tablespace group in a given scenario

Course Number:
od_odpt_a07_it_enus

BASE DE DADOS ORACLE 11G: SEGMENTO DE ESPAÇO, I/O E DESEMPENHO DOS AJUSTES - [od_odpt_a08_it_enus]

Overview/Description
Oracle Database 11g provides various methods for tuning segment space usage and input/output (I/O). This course explains how to use Automatic Segment Space Management (ASSM) to tune segment space usage, how to shrink segments using SQL or the Enterprise Manager, and how to use table compression. Automatic Storage Management (ASM) capabilities save you time by automating manual storage and thereby increasing your ability to manage larger databases (and more of them) with increased efficiency. This course discusses the implementation and tuning of ASM using a variety of Redundant Array of Independent Disks (RAID) solutions, depending on the business requirements of the organization. This course also explores the performance tuning methodology and identifies industry-recognized best practices for performance tuning.

Target Audience
A range of in-training or established IT professionals; Database Administrators; Support Engineers; Technical Consultants.

Prerequisites
Oracle Database 11g: Administration Workshop I Oracle Database 11g: Administration Workshop II

Expected Duration (hours)
2.5

Lesson Objectives
Oracle Database 11g: Segment Space, I/O, and Performance Tuning
• identify the characteristics of extents
• identify the characteristics of blocks
• identify the characteristics of Automatic Segment Space Management (ASSM)
• recognize how to manage row migration and chaining
• recognize how to shrink segments using SQL or the Enterprise Manager
• recognize how to use table compression
• identify the characteristics of I/O
• recognize how to tune I/O effectively
• identify the characteristics of RAID
• recognize how to manage and monitor ASM
• recognize best practices for performance tuning
• tune I/O in a given scenario
• view I/O statistics in a given scenario

Course Number:
od_odpt_a08_it_enus

BASE DE DADOS ORACLE 11G: AJUSTAMENTO DO SQL

BASE DE DADOS ORACLE 11G: ARQUITECTURA, AJUSTE DE SQL E OPTIMIZAÇÃO - [od_ortw_a01_dt_enus]

Overview/Description
The Oracle Database server consists of an Oracle Database and one or more Oracle Database instances. SQL (Structured Query Language) is the language with which all programs and users access an Oracle Database. Monitoring the performance of and tuning database components, as well as the SQL statements used to access and manipulate the database, helps to ensure the Oracle Database server runs efficiently and as expected. This course explores the major architectural components of the Oracle Database server, memory structures, background processes, and physical and logical storage structures. It also examines SQL tuning, identifying the attributes of a SQL statement that can make it perform poorly, SQL tuning tools, and common tuning tasks. The steps involved in the execution of a SQL statement, the optimizer and its phases, and controlling optimizer behavior are also covered.

Target Audience
Support engineers, developers, technical consultants, data warehouse developers, and application developers.

Prerequisites
Oracle Database 11g: Introduction to SQL Oracle Database 11g: SQL Fundamentals I

Expected Duration (hours)
2.0

Lesson Objectives
Oracle Database 11g: Architecture, SQL Tuning, and Optimization
• recognize Oracle database structures
• recognize how to manage memory and database structures
• identify SQL statements that cause poor performance
• identify tools and tasks in SQL tuning
• recognize how SQL statement execution works
• recognize the basic features of the optimizer
• avoid common SQL mistakes
• recognize optimizer decisions in a given scenario

Course Number:
od_ortw_a01_dt_enus

BASE DE DADOS ORACLE 11G: ÍNDICES, CAMINHOS DE ACESSO, E JUNÇÃO DE OPERAÇÕES - [od_ortw_a02_dt_enus]

Overview/Description
Access paths are the ways in which data is retrieved from the database, and there are a number of different access paths which can be used for tables and indexes. This course explores the access paths used for tables, such as full table, rowid, and sample table scan. It also examines the access paths used for indexes, such as unique, range, full, fast full, skip, and index join index scans, as well as bitmap indexes and combining bitmap indexes. Additionally, this course discusses B*-tree, bitmap, composite, and invisible indexes and nullable columns when using indexes. Bitmap operations, guidelines for managing indexes, index usage, clusters, sorting operators, join methods, and other n-array operations are also covered.

Target Audience
Support engineers, developers, technical consultants, data warehouse developers, and application developers.

Prerequisites
Oracle Database 11g: Introduction to SQL Oracle Database 11g: SQL Fundamentals I

Expected Duration (hours)
2.5

Lesson Objectives
Oracle Database 11g: Indexes, Access Paths, and Join Operations
• identify the functions of table scans in the optimizer
• recognize types of indexes and how index scans work
• recognize the features of index-organized tables and bitmap and composite indexes
• use different acces paths
• recognize how clusters and sorting operators work
• recognize how joins and N-array operations work
• recognize how to cache query results in the SGA

Course Number:
od_ortw_a02_dt_enus

BASE DE DADOS ORACLE 11G: PLANOS DE EXECUÇÃO E TRANSFORMAÇÕES DE ESTRELA - [od_ortw_a03_dt_enus]

Overview/Description
An execution plan is the output of the optimizer and is presented to the execution engine for implementation. The execution plan instructs the execution engine about the operations it must perform for retrieving the data required by a query most efficiently. This course explores gathering, displaying, and interpreting execution plans. It also covers the EXPLAIN PLAN command and the PLAN_TABLE, using AUTOTRACE, dynamic performance views that contain execution plan information, the Automatic Workload Repository (AWR), and SQL monitoring. The star schema is the simplest data warehouse schema. Defining a star schema and star transformation requirements, as well as star query plans without transformation and after transformation, are also covered.

Target Audience
Support engineers, developers, technical consultants, data warehouse developers, and application developers.

Prerequisites
Oracle Database 11g: Introduction to SQL Oracle Database 11g: SQL Fundamentals I

Expected Duration (hours)
2.0

Lesson Objectives
Oracle Database 11g: Execution Plans and Star Transformations
• recognize how to gather execution plans
• recognize how to display execution plans
• recognize the views containing execution plan information
• recognize how to use the AWR
• recognize how to perform SQL monitoring
• interpret execution plans
• extract an execution plan used by the optimizer to execute a query
• recognize how to use star transformation
• use star transformation and access the benefits of using this optimizer technique

Course Number:
od_ortw_a03_dt_enus

BASE DE DADOS ORACLE 11G: OPTIMIZADOR DE ESTATÍSTICAS, SUGESTÕES E PARTILHA DE CURSOR - [od_ortw_a04_dt_enus]

Overview/Description
Optimizer statistics describe details about the database and the objects in the database and are used by the query optimizer to select the best execution plan for each SQL statement. This course covers gathering optimizer and system statistics, setting statistic preferences, using dynamic sampling, and manipulating optimizer statistics. if you use SQL statements where literal values are provided for the WHERE clause conditions, you get results in many versions of almost identical SQL to be stored in the library cache. If, instead of issuing different statements for each literal, you use a bind variable, then in theory that extra parse activity is eliminated. Listing the benefits of using bind variables, as well as using bind peeking and adaptive cursor sharing are examined in this course. Optimizer hints enable you to influence decisions made by the optimizer and provide a mechanism to direct the optimizer to select a certain query execution plan based on the specific criteria. The use of optimizer hints, including specifying hints for optimizer mode, query transformation, access path, join orders, and join methods is also covered.

Target Audience
Support engineers, developers, technical consultants, data warehouse developers, and application developers.

Prerequisites
Oracle Database 11g: Introduction to SQL Oracle Database 11g: SQL Fundamentals I

Expected Duration (hours)
3.0

Lesson Objectives
Oracle Database 11g: Optimizer Statistics, Hints, and Cursor Sharing
• recognize how to gather optimizer statistics
• recognize how to gather system statistics
• use dynamic sampling
• use system statistics
• identify the features of bind variables
• use cursor sharing
• use optimizer hints
• use hints and views
• recognize how adaptive cursor sharing, the CURSOR_SHARING initialization parameter, and hints are used

Course Number:
od_ortw_a04_dt_enus

BASE DE DADOS ORACLE 11G: DETECÇÃO DA APLICAÇÃO E AJUSTE AUTOMÁTICO DE SQL - [od_ortw_a05_dt_enus]

Overview/Description
Oracle Database implements tracing by generating a trace file for each server process when you enable the tracing mechanism. This course explores configuring the SQL Trace facility to collect session statistics, using the TRCSESS utility to consolidate SQL trace files, formatting trace files using the tkprof utility, and interpreting the output of the tkprof command. Tuning statements automatically eases the entire SQL tuning process and replaces manual SQL tuning. Statement profiling, and using the SQL Tuning Advisor, the SQL Access Advisor, and Automatic SQL Tuning are also covered in this course.

Target Audience
Support engineers, developers, technical consultants, data warehouse developers, and application developers.

Prerequisites
Oracle Database 11g: Introduction to SQL Oracle Database 11g: SQL Fundamentals I

Expected Duration (hours)
2.5

Lesson Objectives
Oracle Database 11g: Application Tracing and Automatic SQL Tuning
• recognize how to configure the SQL trace facility
• recognize how to use the trcsess utility
• recognize how to use the tkprof utility
• perform application tracing
• recognize how statement profiling works
• recognize how to use the SQL Tuning Advisor
• recognize the features of the SQL Access Advisor
• recognize the features of Automatic SQL Tuning
• perform SQL tuning and use the SQL Access Advisor

Course Number:
od_ortw_a05_dt_enus

BASE DE DADOS ORACLE 11G: ADMINISTRAÇÃO RAC

BASE DE DADOS ORACLE 11G: INSTALAÇÃO DO CLUSTERWARE E RAC - [od_orac_a01_it_enus]

Overview/Description
Oracle Database 11g: Real Application Clusters (RAC) enable high utilization of a cluster of standard, low-cost modular servers and offers high availability, scalability, and important grid computing features. This course provides an introduction to Oracle Database 11g: Real Application Clusters (RAC) and demonstrates how to fulfill the pre-installation requirements for Oracle Clusterware as well as how to install and configure Clusterware. It also demonstrates the installation of Automatic Storage Management (ASM) and Oracle Database software and then explains how to install the Enterprise Manager agent on each cluster node. The creation of a cluster database including discussion of the cluster database post installation tasks are also topics that are explored.

Target Audience
Database administrators, consultants, and IT professionals who are personally interested in updating their Oracle skills.

Prerequisites
Before taking this course, it is recommended that the student have a general understanding of database administration, as well as the skills and knowledge commensurate with Oracle’s Database 11g: Administration Workshop I and Workshop II, or equivalent experience.

Expected Duration (hours)
3.0

Lesson Objectives
Oracle Database 11g: Installation of Clusterware and RAC
• identify key concepts related to Real Application Clusters
• recognize the main features and functions of RAC
• identify the requirements for installing Oracle Clusterware
• recognize how to install and configure Oracle Clusterware
• install Oracle Clusterware
• recognize how to install Automatic Storage Management
• recognize how to install Oracle database software
• recognize how to install Enterprise Manager
• recognize how to create a cluster database
• identify the tasks you perform after creating a cluster database
• install Automatic Storage Management and Oracle database software

Course Number:
od_orac_a01_it_enus

BASE DE DADOS ORACLE 11G: BASE DE DADOS RAC E ADMINISTRAÇÃO DO CLUSTERWARE ORACLE - [od_orac_a02_it_enus]

Overview/Description
Oracle Database 11g has many tools available for administering a RAC Database and Oracle Clusterware, including Oracle Enterprise Manager. This course explains how to use Enterprise Manager cluster database pages to administer a RAC database and how to carry out various administration tasks on Oracle Clusterware. It discusses how to manage RAC instances, Oracle Clusterware and resources, voting disks, VIP addresses and the CRS framework, and initialization parameters. This course also demonstrates how to configure backup and recovery in a RAC environment.

Target Audience
Database administrators, consultants, and IT professionals who are personally interested in updating their Oracle skills.

Expected Duration (hours)
3.0

Lesson Objectives
Oracle Database 11g: RAC Database and Oracle Clusterware Administration
• identify how to use Enterprise Manager cluster database pages
• recognize how to start and stop RAC databases and instances
• recognize how to modify initialization parameters in a RAC environment
• identify ways to manage instances in a RAC environment
• identify ways to manage Oracle Clusterware and resources
• identify the functions of the voting disk and important CSS parameters
• recognize steps you take to configure voting disks
• recognize how to manage OCR files and locations
• recognize the procedure for changing VIP addresses
• recognize how to use the CRS framework to register an application
• recognize RAC recovery and backup settings
• identify how to use RMAN in a RAC environment
• recognize how to configure backup and recovery in RAC
• perform RAC backup and recovery using Enterprise Manager

Course Number:
od_orac_a02_it_enus

BASE DE DADOS ORACLE 11G: AJUSTE DO DESEMPENHO RAC - [od_orac_a03_it_enus]

Overview/Description
Performance Tuning uses diagnostic tools to gather statistics, statistic rates, and sampled statistics in order to tune the database system to provide the best performance as efficiently as possible. Although there are specific tuning areas for Oracle Database 11g: RAC, such as instance recovery and interconnect traffic, you will get the best performance by tuning your RAC system the same as you would with a single-instance system. The same tuning tools are available for RAC as would be for a single-instance system. This course explains instance recovery in RAC, describes RAC wait events and latencies, and provides the most common RAC tips for tuning performance in a RAC environment. It also discusses how to monitor and diagnose RAC performance using Enterprise Manager and Automatic Database Diagnostic Monitor (ADDM). In addition, it demonstrates in detail how to use the Cluster Database Performance pages to monitor RAC database and cluster performance.

Target Audience
Database administrators, consultants, and IT professionals who are personally interested in updating their Oracle skills.

Expected Duration (hours)
1.5

Lesson Objectives
Oracle Database 11g: RAC Performance Tuning
• identify how instance recovery works in a RAC environment
• recognize typical wait events and latencies for RAC
• identify the most common RAC tuning tips
• identify factors that affect tuning in a RAC environment
• recognize how to use the Cluster Database Performance pages to monitor RAC database and cluster performance
• recognize how to discover RAC performance problems using ADDM and Enterprise Manager
• recognize how to fix performance problems in RAC
• discover RAC performance problems using Enterprise Manager

Course Number:
od_orac_a03_it_enus

BASE DE DADOS ORACLE 11G: CONFIGURAÇÃO, GESTÃO E UTILIZAÇÃO DOS SERVIÇOS EM RAC - [od_orac_a04_it_enus]

Overview/Description
A service is a grouping of related tasks within a database with common functionality, quality expectations, and priority relative to other services. It provides a single-system image for managing competing applications running within a single instance and across multiple instances and databases. Using standard interfaces, such as the Database Configuration Assistant, Enterprise Manager, and SRVCTL, services can be configured, administered, enabled, disabled, and measured as a single entity. This course provides an introduction to services and discusses how to configure, modify, and use services in a RAC environment. It explains how to use services with client applications, Resource Manager, and the Scheduler, and explores service aggregation and tracing. This course also demonstrates how to create and relocate a service, as well as how to set alert thresholds for a service.

Target Audience
Database administrators, consultants, and IT professionals who are personally interested in updating their Oracle skills.

Expected Duration (hours)
1.5

Lesson Objectives
Oracle Database 11g: Configure, Manage, and Use Services in RAC
• identify the role of services in a RAC environment
• recognize how to use distributed transactions with RAC
• recognize how to create and modify services in a RAC environment
• recognize how to use services with RAC client applications, Resource Manager, and the Scheduler
• recognize how to set alert thresholds for a RAC service
• recognize the function of service aggregation and tracing in a RAC environment
• recognize how to use Enterprise Manager and SRVCTL to manage services in a RAC environment
• create and manage services in RAC

Course Number:
od_orac_a04_it_enus

BASE DE DADOS ORACLE 11G: DIAGNÓSTICO DO CLUSTERWARE ORACLE E GESTÃO DO PONTO DE INTERSECÇÃO - [od_orac_a05_it_enus]

Overview/Description
Problems that occur with Oracle RAC instances can be difficult to diagnose because they span across two or more nodes in a cluster. Oracle Database 11g provides various methods for diagnosing and debugging Oracle Clusterware and RAC components. This course discusses the basics of debugging and the use of diagnostics in a RAC environment, including how to use Oracle Clusterware diagnostic files, the DIAG process, and the Cluster Verification Utility (CVU). In addition, it explains and demonstrates in detail the steps involved in adding and removing nodes and instances in a RAC cluster using the Database Configuration Assistant (DBCA). Adding an instance to a RAC Database using Enterprise Manager (EM) is also covered.

Target Audience
Database administrators, consultants, and IT professionals who are personally interested in updating their Oracle skills.

Expected Duration (hours)
1.5

Lesson Objectives
Oracle Database 11g: Diagnosing Oracle Clusterware and Node Management
• recognize how to carry out diagnostics-related activities on Oracle Clusterware components
• identify how to enable debugging in RAC
• add a node to a RAC cluster
• recognize how to add nodes and instances in a RAC database
• recognize how to delete nodes and instances in a RAC database

Course Number:
od_orac_a05_it_enus

BASE DE DADOS ORACLE 11G: ALTA DISPONIBILIDADE EM RAC - [od_orac_a06_it_enus]

Overview/Description
In Oracle Database 11g, RAC and Data Guard together provide the benefits of system-level, site-level, and data-level protection, resulting in high levels of availability and disaster recovery without loss of data. This course explains how to configure connections for high availability using various types of workload distribution and load balancing, including Fast Application Notification (FAN), Fast Connection Failover (FCF), and Transparent Application Failover (TAF). It also discusses designing for high availability by minimizing downtime using Data Guard, Data Guard Broker, rolling upgrades, ASM, various forms of RAID, and Extended RAC.

Target Audience
Database administrators, consultants, and IT professionals who are personally interested in updating their Oracle skills.

Expected Duration (hours)
2.0

Lesson Objectives
Oracle Database 11g: High Availability in RAC
• recognize how to configure workload distribution features
• identify the characteristics and benefits of Fast Application Notification
• recognize how to configure server-side callouts
• recognize how to use the Load Balancing Advisory
• recognize how to configure TAF
• download patch updates and set ASM preferred disks
• identify how RAC and Data Guard provide protection during downtime
• recognize the function of the Oracle Data Guard Broker
• recognize how to perform rolling upgrades
• recognize which mirroring and striping configurations provide the best availability
• identify how to use extended RAC connectivity
• recognize how to configure preferred mirror reads

Course Number:
od_orac_a06_it_enus

ORACLE 11 I

SÉRIE DE NEGÓCIO ORACLE 11I: FUNDAMENTOS PARA APLICADORES

SÉRIE DE NEGÓCIO ORACLE 11I: INTRODUÇÃO - [232548_ENG]

Overview/Description
To identify the main features of 11i E-Business Suite, to perform key navigation tasks, to create a shared entity type, and to recognize the key business flows of 11i E-Business Suite

Target Audience
Technical consultants on Oracle 11i implementation projects; IT professionals requiring an overview of Oracle 11i E-Business Suite

Prerequisites
Familiarity with Oracle applications and web browsers

Expected Duration (hours)
2.1

Lesson Objectives
Oracle 11i E-Business Suite: Introduction
• recognize the benefits and products associated with 11i E-Business Suite.
• identify the characteristics of the business and technical architectures of 11i E-Business Suite.
• perform key navigation tasks in 11i E-Business Suite.
• log in to Oracle Applications from the 11i E-Business Suite, and open a form before logging out.
• create a shared entity in 11i e-Business Suite, given a scenario.
• identify the key business flows and their associated products in the 11i E-Business Suite.
• create an employee-shared entity, assign it to an organization, and create a resource in the Oracle 11i e-Business Suite.

Course Number:
232548_eng

SÉRIE DE NEGÓCIO ORACLE 11I: MULTI-ORG - [232549_ENG]

Overview/Description
To identify characteristics and key features of Multi-Org and to identify the considerations to make when implementing Multi-Org

Target Audience
Technical consultants on Oracle 11i implementation projects; IT professionals requiring an overview of Oracle 11i E-Business Suite

Prerequisites
Familiarity with Oracle applications and web browsers

Expected Duration (hours)
1.3

Lesson Objectives
Oracle 11i E-Business Suite: Multi-Org
• distinguish between the characteristics of the key entities in the Multi-Org model.
• recognize how Multi-Org secures data and identify the characteristics of the reporting options available in the Multi-Org model.
• identify the main considerations to make when implementing Multiple Organization Support in Oracle applications.
• determine a Multi-Org organizational model that best represents an organization, and the most appropriate reporting options for that model.

Course Number:
232549_eng

SÉRIE DE NEGÓCIO ORACLE 11I: CAMPOS DE CABO FLEXÍVEIS - [232550_ENG]

Overview/Description
To create value sets and to perform the tasks to define a structure for descriptive flexfields

Target Audience
Technical consultants on Oracle 11i implementation projects; IT professionals requiring an overview of Oracle 11i E-Business Suite

Prerequisites
Familiarity with Oracle applications and web browsers

Expected Duration (hours)
2.0

Lesson Objectives
Oracle 11i E-Business Suite: Flexfields
• distinguish between the types of flexfields available in 11i E-Business Suite.
• create flexfield value sets.
• create an independent and dependent flexfield value set, given a scenario.
• define a structure for key flexfields.
• perform the tasks to define the structure for a key flexfield, given a scenario.
• identify how to gather and group information when planning a descriptive flexfield.
• define a structure for descriptive flexfields.
• perform the tasks to define the structure for a descriptive flexfield.

Course Number:
232550_eng

SÉRIE DE NEGÓCIO ORACLE 11I: ADMINISTRAÇÃO DE SISTEMA - [232551_ENG]

Overview/Description
To identify – and in some cases perform – key system-administration tasks in 11i E-Business Suite

Target Audience
Technical consultants on Oracle 11i implementation projects; IT professionals requiring an overview of Oracle 11i E-Business Suite

Prerequisites
Familiarity with Oracle applications and web browsers

Expected Duration (hours)
1.8

Lesson Objectives
Oracle 11i E-Business Suite: System Administration
• recognize the features of Oracle application security and, given a scenario, create a new application user in Oracle 11i E-Business Suite.
• create a responsibility in a given scenario.
• create a responsibility and assign it to a new user, in a given scenario.
• recognize how attributes can be managed and identify the best practices associated with defining a new menu structure in Oracle 11i E-Business Suite.
• identify how profiles are set in 11i E-Business Suite.
• determine how to manage an attribute for a responsibility and define a new menu structure.

Course Number:
232551_eng

SÉRIE DE NEGÓCIO ORACLE 11I: WORKFLOW, ALERTAS E INTELIGÊNCIA EMPRESARIAL NO DIA-A-DIA - [232552_ENG]

Overview/Description
To identify the key features of the Oracle Workflow architecture, to create alerts in 11i E-Business Suite, to recognize the benefits and characteristics of Daily Business Intelligence (DBI) and, given a scenario, run a report in a DBI environment

Target Audience
Technical consultants on Oracle 11i implementation projects; IT professionals requiring an overview of Oracle 11i E-Business Suite

Prerequisites
Familiarity with Oracle applications and web browsers

Expected Duration (hours)
2.4

Lesson Objectives
Oracle 11i E-Business Suite: Workflow, Alerts, and Daily Business Intelligence
• recognize the main features of the Oracle Workflow management system.
• recognize components of the Oracle Server and Workflow Development Client areas of the Oracle Workflow architecture.
• recognize components of the Application Server and End-User Client areas of the Oracle Workflow architecture and, given a scenario, use Workflow Monitor to view a requisition approval.
• create an alert in Oracle 11i E-Business Suite.
• create a periodic alert that can be run on demand with alert actions.
• identify how the product areas of the 11i E-Business Suite are enhanced by Daily Business Intelligence (DBI).
• recognize the characteristics of Daily Business Intelligence (DBI) report components and, given a scenario, run a report in a DBI environment.
• run reports in a Daily Business Intelligence (DBI) environment that give profit margin figures, expenses, and revenues for certain time periods.

Course Number:
232552_eng

SÉRIE DE NEGÓCIO ORACLE 11I: FUNDAMENTOS DO ADMINISTRADOR DO SISTEMA

ORACLE 11I: SEGURANÇA DAS FUNÇÕES E DOS DADOS - [234037_ENG]

Overview/Description
To create users and responsibilities, assign responsibilities, create data groups, create functions and menus, and perform key data-security tasks

Target Audience
Technical consultants; functional implementers; system analysts and any individual who is responsible for implementing and managing the 11i E-Business Suite

Prerequisites
Familiarity with the Oracle 11i E-Business Suite to a level commensurate with the SkillSoft 11i E-Business Suite: Essentials for Implementers learning path

Expected Duration (hours)
2.7

Lesson Objectives
Oracle 11i: Function Security and Data Security
• distinguish between the different layers of access control in Oracle Applications security.
• create application users and assign responsibilities, given a scenario.
• create a data group, given a scenario.
• create a data group and responsibility, given a scenario.
• create a function and assign a function to a menu, given a scenario.
• create a custom menu with submenus, given a scenario.
• perform key data security tasks.
• create a customized menu system and view a data security policy implementation, given a scenario.

Course Number:
234037_eng

ORACLE 11I: PAPÉIS, ADMINISTRAÇÃO DELEGADA, REGISTO E AUDITORIA - [234038_ENG]

Overview/Description
To create roles, set up Delegated Administration, create registration processes for roles, run audit reports, monitor users, and enable the AuditTrail feature

Target Audience
Technical consultants; functional implementers; system analysts and any individual who is responsible for implementing and managing the 11i E-Business Suite

Prerequisites
Familiarity with the Oracle 11i E-Business Suite to a level commensurate with the SkillSoft 11i E-Business Suite: Essentials for Implementers learning path

Expected Duration (hours)
3.3

Lesson Objectives
Oracle 11i: Roles, Delegated Administration, Registration, and Auditing
• recognize the advantages associated with using roles as a method of user management and access control.
• create a role, given a scenario.
• complete the tasks for creating a role, given a scenario.
• recognize the characteristics of Delegated Administration and identify some of the permissions that can be delegated to local administrators.
• implement Delegated Administration, given a scenario.
• create a registration process for a role, given a scenario.
• perform the preliminary steps for setting up Delegated Administration and create a registration process for a role, given a scenario.
• run Sign-On Audit reports and monitor users, given a scenario.
• enable the AuditTrail feature, given a scenario.
• run and view the appropriate Sign-On Audit report, given a scenario.

Course Number:
234038_eng

ORACLE 11I: ELEMENTOS SIMULTÂNEOS - [234039_ENG]

Overview/Description
To submit and manage requests, create request groups and request sets, and identify the concepts and tools associated with concurrency and concurrency administration

Target Audience
Technical consultants; functional implementers; system analysts and any individual who is responsible for implementing and managing the 11i E-Business Suite

Prerequisites
Familiarity with the Oracle 11i E-Business Suite to a level commensurate with the SkillSoft 11i E-Business Suite: Essentials for Implementers learning path

Expected Duration (hours)
3.0

Lesson Objectives
Oracle 11i: Concurrent Elements
• use Standard Request Submission (SRS) to submit and schedule requests.
• perform request-management tasks.
• schedule and manage concurrent requests, given a scenario.
• identify the methods for monitoring concurrent requests.
• create standard and coded request groups.
• perform the tasks to create request sets.
• create a standard request group and finish creating a request set, given a scenario.
• identify the key concepts associated with concurrent processing.
• recognize key concepts associated with specializing a concurrent manager, action types, and request types.
• identify the means by which concurrency can be managed.

Course Number:
234039_eng

ORACLE 11I: OPÇÕES DE PERFIL, DEVERES DBA E GESTÃO DE IMPRESSORA - [234040_ENG]

Overview/Description
To set and view profile options, perform some Application-DBA tasks, define printers, and print with the pasta.cfg file

Target Audience
Technical consultants; functional implementers; system analysts and any individual who is responsible for implementing and managing the 11i E-Business Suite

Prerequisites
Familiarity with the Oracle 11i E-Business Suite to a level commensurate with the SkillSoft 11i E-Business Suite: Essentials for Implementers learning path

Expected Duration (hours)
1.5

Lesson Objectives
Oracle 11i: Profile Options, DBA Duties, and Printer Management
• set and view profile options, given a scenario.
• perform some Application DBA tasks.
• set some user-related profile options and assign a user to a resource consumer group, given a scenario.
• define printers with Oracle's printing setup windows and the pasta.cfg file.
• define a printer style, driver, and type.

Course Number:
234040_eng

ORACLE 11I: PERSONALIZAÇÃO DE FORMULÁRIOS E PÁGINAS OA - [234041_ENG]

Overview/Description
To personalize forms and Oracle Applications (OA) framework pages

Target Audience
Technical consultants; functional implementers; system analysts and any individual who is responsible for implementing and managing the 11i E-Business Suite

Prerequisites
Familiarity with the Oracle 11i E-Business Suite to a level commensurate with the SkillSoft 11i E-Business Suite: Essentials for Implementers learning path

Expected Duration (hours)
2.5

Lesson Objectives
Oracle 11i: Personalization of Forms and OA Framework Pages
• personalize a form by setting rules and actions.
• personalize a form by setting conditions and a debug message.
• perform some advanced form personalization tasks, given a scenario.
• personalize a form, given a scenario.
• identify how Oracle Application (OA) framework pages can be personalized.
• perform administrator-level personalization tasks for Oracle Application (OA) framework pages.
• perform user-level personalization tasks for Oracle Application (OA) framework pages.
• customize an Oracle Applications (OA) framework page with administrator-level and user-level personalizations, given a scenario.

Course Number:
234041_eng

ORACLE 11I: WORKFLOW ORACLE - [234043_ENG]

Overview/Description
To identify the components of Oracle Workflow and to recognize the mandatory the optional steps for configuring Oracle Workflow

Target Audience
Technical consultants; functional implementers; system analysts and any individual who is responsible for implementing and managing the 11i E-Business Suite

Prerequisites
Familiarity with the Oracle 11i E-Business Suite to a level commensurate with the SkillSoft 11i E-Business Suite: Essentials for Implementers learning path

Expected Duration (hours)
1.3

Lesson Objectives
Oracle 11i: Oracle Workflow
• identify some of the functions of Oracle Workflow.
• identify the roles of the components in the Oracle Workflow architecture.
• recognize the mandatory steps for configuring Oracle Workflow.
• recognize optional steps for configuring Oracle Workflow.
• configure global workflow and Business Events System preferences for Oracle Workflow.

Course Number:
234043_eng

ORACLE 11I: MONITORIZAÇÃO DE SISTEMA E RESOLUÇÃO DE PROBLEMAS EM OAM - [234044_ENG]

Overview/Description
To monitor and manage some of the system components of Oracle E-Business Suite, run some troubleshooting wizards, and use the Support Cart feature in Oracle Applications Manager (OAM)

Target Audience
Technical consultants; functional implementers; system analysts and any individual who is responsible for implementing and managing the 11i E-Business Suite

Prerequisites
Familiarity with the Oracle 11i E-Business Suite to a level commensurate with the SkillSoft 11i E-Business Suite: Essentials for Implementers learning path

Expected Duration (hours)
2.3

Lesson Objectives
Oracle 11i: System Monitoring and Troubleshooting in OAM
• recognize how to configure the key aspects of Oracle Applications Manager (OAM).
• access the pages used to view and monitor general system performance, alerts, metrics, logs, and database status with Oracle Applications Manager (OAM).
• access the pages used to view and monitor critical activities, security, and application services with Oracle Applications Manager (OAM).
• access the pages used to view and monitor forms, monitor JServ, and manage the state of hosts with Oracle Applications Manager (OAM).
• set up monitoring for critical activities, configure the Forms Runaway Process Detection feature, and configure settings for a host, given a scenario.
• identify the appropriate troubleshooting wizard to use, given a scenario, and use the Support Cart feature in Oracle Applications Manager (OAM).
• run the appropriate troubleshooting wizard, given a scenario, and use the Support Cart feature to create a zip file for Oracle Support.

Course Number:
234044_eng

• ORACLE 11I: FUNDAMENTOS DA INICIAÇÃO DE PROJECTO

ORACLE 11I: GESTÃO E INTEGRAÇÃO DE PROJECTO - [238819_ENG]

Overview/Description
To recognize the Oracle Enterprise Project Management Solution products, the integration of Oracle Project with other Oracle e-business applications, and how to define an Oracle Applications set of books

Target Audience
Functional Implementers; Project Managers; Sales Consultants

Prerequisites
Familiarity with the Oracle 11i E-Business Suite to a level commensurate with the SkillSoft 11i E-Business Suite: Essentials for Implementers learning path, and a basic knowledge of project management

Expected Duration (hours)
1.9

Lesson Objectives
Oracle 11i: Project Management and Projects Integration
• identify the key features of Oracle Project Foundation, Costing, Billing, and Resource Management applications.
• identify the key features of Oracle Project Management, Project Collaboration, and Daily Business Intelligence for Projects applications.
• recognize Oracle Project's integration with Oracle APC, Assets, Cash Management, General Ledger, Grants Accounting, HR, Internet Expenses, and Inventory applications.
• recognize Oracle Project's integration with Oracle Payables, Project Contracts, Project Manufacturing, Purchasing, Receivables, Sales, Time & Labor, and Workflow applications.
• recognize how an Oracle Applications set of books is defined.
• administer profile options and dynamic insertion in a given scenario.

Course Number:
238819_eng

ORACLE 11I: ORGANIZAÇÃO, PERÍODO, E DEFINIÇÕES DE CALENDÁRIO EM PROJECTOS ORACLE - [238828_ENG]

Overview/Description
To recognize how Oracle Projects' multiple organization architecture, periods, and calendars are used for structuring and scheduling, and to implement them in an enterprise

Target Audience
Functional Implementers; Project Managers; Sales Consultants

Expected Duration (hours)
1.9

Lesson Objectives
Oracle 11i: Organization, Period, and Calendar Definitions in Oracle Projects
• recognize what organizations are and how they are used in Oracle Projects.
• recognize how to define organizations and assign project-related organization classifications.
• recognize multiple organization installation and how organization hierarchies are assigned.
• define organizations and assign hierarchies in a given scenario.
• recognize the use of periods and how they are defined.
• recognize the use of calendars and how they are defined.

Course Number:
238828_eng

ORACLE 11I: GESTÃO DE RECURSOS E PAPÉIS - [238838_ENG]

Overview/Description
To recognize the resources and roles in Oracle Projects, how they are used in project management, and to create and assign them

Target Audience
Functional Implementers; Project Managers; Sales Consultants

Expected Duration (hours)
1.7

Lesson Objectives
Oracle 11i: Resource and Role Management
• recognize the use of resources in Oracle Projects and how to define jobs, job levels, job groups, and job mapping.
• recognize how to define competencies and employees.
• create a job, and define and record competencies in a given scenario.
• recognize the use of roles in Oracle Projects, and how to define and assign them.
• recognize the use of project roles and project organization roles, and how to define them.

Course Number:
238838_eng

ORACLE 11I: MODELO DE SEGURANÇA DE PROJECTOS ORACLE E LAYOUTS DE PÁGINAS - [238847_ENG]

Overview/Description
To use Oracle Projects to secure function and data access within Projects applications, and use page layouts to manipulate views of project information

Target Audience
Functional Implementers; Project Managers; Sales Consultants

Expected Duration (hours)
1.9

Lesson Objectives
Oracle 11i: Oracle Projects Security Model and Page Layouts
• recognize the security mechanisms of the Oracle Projects security model.
• recognize how responsibility-based security operates and set a profile option.
• recognize how role-based security operates and define an organization authority.
• define an organization authority and set a profile option in a given scenario.
• recognize how page layout types, sections, and shortcut links are used in Oracle Projects.
• configure a page layout and match predefined page layouts to sections.

Course Number:
238847_eng

ORACLE 11I: PROJECTOS ORACLE E DEFINIÇÃO DE TAREFAS I - [238856_ENG]

Overview/Description
To define project setup options and project types to manage project structuring, resources, and workflow

Target Audience
Functional Implementers; Project Managers; Sales Consultants

Expected Duration (hours)
2.0

Lesson Objectives
Oracle 11i: Oracle Projects and Task Definition I
• recognize how to define a project status.
• recognize how to define a classification, a service type, and a probability list.
• recognize how to define a resource list, a cycle, and a work type.
• define a project status, a classification, and a cycle in a given scenario.
• recognize how project types are defined using the Details, Costing Information, Budget Option, Classifications, and Budgetary Control tabs.
• recognize how project types are defined using the Project Status, Workflow, Capitalization Information, Billing Information, Billing Assignments, and Distribution Rules tabs.

Course Number:
238856_eng

ORACLE 11I: PROJECTOS ORACLE E DEFINIÇÃO DE TAREFAS II - [238857_ENG]

Overview/Description
To recognize how projects are organized, and create and administer them

Target Audience
Functional Implementers; Project Managers; Sales Consultants

Expected Duration (hours)
1.7

Lesson Objectives
Oracle 11i: Oracle Projects and Task Definition II
• recognize how to define a project template.
• recognize how project templates are administered and used to create a project.
• define a project template and create a project in a given scenario.
• recognize how to organize a Work Breakdown Structure and define tasks.
• recognize how project extensions, workflow, profiles, phases, and lifecycles are implemented.

Course Number:
238857_eng

ORACLE 11I: ATRIBUTOS, OPÇÕES DE IMPLEMENTAÇÃO E UTILIZAÇÃO DAS DEFINIÇÕES DO UTILIZADOR - [238858_ENG]

Overview/Description
To use Oracle Project's user-defined attributes, group implementation options, and utilization reports to capture information, interface with other Oracle applications, and report actual and scheduled utilization and resources

Target Audience
Functional Implementers; Project Managers; Sales Consultants

Expected Duration (hours)
2.3

Lesson Objectives
Oracle 11i: User-Defined Attributes, Implementation Options, and Utilization
• recognize how to create user-defined attributes, and define value sets and functions.
• recognize how to define attribute groups and context.
• define value sets, functions, and attribute groups in a given scenario.
• recognize how system, project, staffing, and cross change implementation options are used and defined.
• recognize how currency, expenditures, costing, and billing implementation options are used and defined.
• recognize how to define a utilization category and unassigned time options.
• recognize how utilization reporting, workbooks, and profile options are used in Oracle Projects.

Course Number:
238858_eng

ORACLE 11I: PREVISÃO DA ORGANIZAÇÃO E INTEGRAÇÃO - [238869_ENG]

Overview/Description
To use organization forecasting for project planning and administration, and integrate Oracle Projects with Oracle Sales and Oracle Advanced Product Catalog to manage sales and product lifecycles

Target Audience
Functional Implementers; Project Managers; Sales Consultants

Expected Duration (hours)
2.0

Lesson Objectives
Oracle 11i: Organization Forecasting and Integration
• recognize the use of organization forecasting and how an organization forecast is viewed.
• recognize how organization forecasting options are defined and reviewed, and how forecast adjustments and amounts are determined.
• recognize the advantages of Oracle Projects' integration with Oracle Sales, and how to create and manage project requests.
• recognize how to implement Oracle Projects' integration with Oracle Sales.
• recognize the advantages of Oracle Projects' integration with Oracle Advanced Product Catalog and how it is implemented.
• implement Oracle Sales and Oracle Advanced Product Catalog integration in a given scenario.

Course Number:
238869_eng

ORACLE 11I: NAVEGAÇÃO DAS APLICAÇÕES ORACLE

ORACLE 11I: UTILIZAÇÃO DO NAVEGADOR, FORMULÁRIOS E AJUDA ONLINE - [242461_ENG]

Overview/Description
To define responsibilities and recognize Navigator functionality, enter and work with data using forms, and search for information with Oracle Applications online help

Target Audience
Functional implementers; project managers; sales consultants; end-users

Prerequisites
Familiarity with popular graphical user interfaces

Expected Duration (hours)
1.6

Lesson Objectives
Oracle 11i: Using the Navigator, Forms, and Online Help
• log on to Oracle Applications, specify responsibilities, recognize Navigator functionality, and then log off.
• recognize the features of Oracle Applications forms and perform basic tasks.
• log on to Oracle Applications, switch responsibilities, and access online help in a given scenario.
• perform data entry, editing, duplication, and clearance using forms.
• perform data searches and use Oracle Applications online help.

Course Number:
242461_eng

ORACLE 11I: PROCESSAMENTO SIMULTÂNEO, PEDIDOS, PERFIS, E FORMULÁRIOS - [242480_ENG]

Overview/Description
To execute application tasks simultaneously by running concurrent requests and request sets, customize the presentation of data, and manage personal user profiles, form attachments, and form flexfields

Target Audience
Functional implementers; project managers; sales consultants; end-users

Prerequisites
Familiarity with popular graphical user interfaces

Expected Duration (hours)
2.0

Lesson Objectives
Oracle 11i: Concurrent Processing, Requests, Profiles, and Forms
• identify the features of concurrent processing and standard request submission, and submit requests and request sets.
• define stages and request parameters, and manage request processing tasks.
• create a personal Navigator top ten list, and create and work with folders.
• configure request sets and view request set details.
• manage personal profiles and form attachments.
• use flexfields to customize and search for data.

Course Number:
242480_eng

ORACLE DATABASE SYSTEMS

SERVIDOR DA APLICAÇÃO ORACLE10G: ADMINISTRAÇÃO II

ORACLEAS 10G: GESTÃO DE TOPOLOGIAS PERSONALIZADAS E COMPONENTES DE DISTRIBUIÇÃO DA INFRA-ESTRUTURA - [222590_ENG]

Overview/Description
To discuss common deployment topologies and to explain how to install and configure Oracle Application Server components to suit different needs

Target Audience
DBAs, developers, and other IT professionals planning to take Oracle Application Server 10g certification examinations; anyone interested in the technical aspects of Oracle Application Server 10g

Prerequisites
Working experience with Linux operating systems; some experience in Internet-based-application administration and development would be beneficial; a good understanding of Oracle Application Server components and concepts

Expected Duration (hours)
3.1

Lesson Objectives
OracleAS 10g: Managing Customized Topologies and Distributing Infrastructure Components
• identify some of the new features available for managing customized topologies and recognize some of the key deployment considerations.
• identify the main considerations for evaluating general development topologies.
• identify key considerations when evaluating the departmental, development life cycle, and data centre topologies.
• evaluate recommended development and deployment topologies.
• recognize the features of Cold Failover Clusters, Active Failover Clusters, and Identity Management replication as part of high availability deployments.
• identify how to use multiple metadata repositories and list the requirements for installing OracleAS Infrastructure using an existing Oracle9i database.
• install OracleAS Infrastructure by using an existing Infrastructure component.
• install a Metadata Repository into an existing database and install the Infrastructure using the existing repository.
• identify how to upgrade a distributed OracleAS environment and recognize the effect of an upgrade on system availability.
• identify the steps involved in the procedure for upgrading the middle tier, Metadata Repository, and Identity Management Services.
• identify how to upgrade a system to Oracle AS 10g.

Course Number:
222590_eng

ORACLEAS 10G: ALTA DISPONIBILIDADE - [222604_ENG]

Overview/Description
To explain high availability and its importance from the perspective of application servers and discuss the high availability features in Oracle Application Server at the OC4J level

Expected Duration (hours)
2.5

Lesson Objectives
OracleAS 10g: High Availability
• recognize the concepts associated with high availability and identify the features of Oracle's end-to-end high availability solution.
• determine the appropriate method of providing high availability for applications and the middle tier.
• determine the appropriate method of providing high availability for OracleAS Infrastructure using clustering.
• outline the site-to-site high availability solution for OracleAS Infrastructure.
• determine a high availability solution for a given scenario.
• identify the benefits of J2EE clustering and the configuration of islands.
• recognize the concepts involved in session and application replication for high availability solutions.
• create an OC4J island, configure state replication, and monitor virtual machine metrics.
• configure clustering of OC4J Java Virtual Machines.

Course Number:
222604_eng

ORACLEAS 10G: GESTÃO E CONFIGURAÇÃO DE CLUSTERS - [222605_ENG]

Overview/Description
To explain how to manage and configure clusters in OracleAS 10g

Expected Duration (hours)
3.2

Lesson Objectives
OracleAS 10g: Managing and Configuring Clusters
• explain clustering and describe how OracleAS Web Cache clusters work.
• configure Web Cache cluster members and settings, and identify how to invalidate the cache.
• configure session binding and monitor cache cluster performance.
• configure web cache cluster settings, add an additional web cache to a cache cluster, and obtain performance statistics for the web cache.
• create an OracleAS Farm using a file-based repository.
• identify the characteristics of OracleAS clusters managed using a repository.
• identify the role of OPMN, DCM, and mod_oc4j in OracleAS cluster management.
• create, stop, and start an OracleAS cluster, add and remove instances, and identify how to create an OracleAS cluster using dcmct1.
• create clusters and add standalone instances.
• outline the architecture of OracleAS Infrastructure Cold Failover Clusters and identify how to install middle tiers in a CFC environment.
• identify the steps involved in installing and starting an OracleAS Infrastructure in a Cold Failover Cluster and identify how to manage and test a failover.

Course Number:
222605_eng

ORACLEAS 10G: GESTÃO DO COMPONENTE DA INTELIGÊNCIA EMPRESARIAL- [222606_ENG]

Overview/Description
To examine Business Intelligence components such as Oracle AS Discoverer and OracleAS Reports and to describe how to deploy reports and forms applications to OracleAS

Expected Duration (hours)
4.0

Lesson Objectives
OracleAS 10g: Business Intelligence Component Management
• monitor OracleAS Report Services and control and configure OracleAS Discoverer.
• configure OracleAS Discoverer Plus, Discoverer Viewer, and Discoverer Portlet Provider, and register Discoverer Portlet Provider.
• control OracleAS Discoverer services.
• identify features for monitoring OracleAS Discoverer, identify the configuration files used with Discoverer, and use the EUL command-line tool for Java.
• identify the capabilities of OracleAS Reports Services and determine how its components contribute to the running of a report.
• identify Reports Services configuration files and configure the Reports Server and the Reports Servlet.
• identify how to deploy reports using OracleAS Reports Services.
• configure Reports Services and deploy a Reports application.
• outline the architecture of Forms Services and identify the role of each Forms Service component in running an application.
• identify the configuration files and the levels of configuration associated with OracleAS Forms Services, identify how the configuration files are used at runtime, and use Application Server Control for configuration tasks.
• configure the Forms Servlet using Application Server Control.
• configure environmental variables in a Forms runtime environment, manage user sessions, and identify how to deploy Forms applications and their associated files.
• configure the Forms Servlet for a new testing environment.

Course Number:
222606_eng

ORACLEAS 10G: APLICAÇÕES XML, SERVIÇOS WEB E MONITORIZAÇÃO - [222607_ENG]

Overview/Description
To describe how to deploy XML applications and web services with Oracle AS and to discuss the monitoring capabilities of Oracle Enterprise Manager Application Server Control

Expected Duration (hours)
2.7

Lesson Objectives
OracleAS 10g: XML Applications, Web Services, and Monitoring
• define terms associated with XML, identify the Oracle XML and XDK components, and identify the steps in the XML parsing process.
• recognize how an XSQL servlet functions, initialize the XSQL demo application, and create and access an XSQL page.
• define the Web services standards, identify why organizations use Web services, and outline the Web services architecture and communication flow.
• identify the main features of SOAP, and describe how to invoke, manage, and deploy Web services, and how to implement a stateless Java Web service.
• use Web services and XSQL.
• identify Log Loader tasks and search log files.
• configure diagnostic message correlation.
• manage and troubleshoot the Log Loader.
• use the log repository to monitor OracleAS.

Course Number:
222607_eng

ORACLEAS 10G: AJUSTE E RECONFIGURAÇÃO DE NÍVEL MÉDIO - [222608_ENG]

Overview/Description
To describe how to optimize the performance of Oracle Application Server components and to explain how to perform reconfiguration tasks in the Oracle Application Server middle tier and infrastructure

Prerequisites
Working experience with Linux operating systems; some experience in Internet-based-application