Oracle

In this course students learn the basics of writing Oracle SQL statements. This course provides the SQL skills that allow developers, database administrators and end-users to write queries against single and multiple tables, manipulate data in tables and take advantage of Oracle supplied row functions.

Module 00: Oracle 11g/12c: Introduction to SQL Online Training - Course Introduction

Module 01: Writing SQL SELECT Statements

• Review the basic SQL SELECT statement syntax
• Select all columns using a wildcard notation from a table
• Valid SELECT statement expressions
• Write a query containing the arithmetic operators
• Use aliases to customize column headings
• Create a character expression with the concatenation operator
• Use the CASE Expression
• Lab Exercise

Module 02: Writing SQL SELECT Statements Demo

Module 03: Restricting Data

• Use the WHERE Clause
• WHERE clause operators
• =, <>, >, < operators
• BETWEEN, IN, LIKE, IS NULL operators
• Adding ANY or ALL to an operator
• List the Logical Conditions AND, OR, NOT
• Use Multiple Conditions in the WHERE clause
• Describe the Rules of Precedence
• Lab Exercise

Module 04: Restricting Data Demo

Module 05: Sorting Data

• Discuss default order of result sets
• Sort Rows with the ORDER BY Clause
• ORDER BY valid expressions
• DISTINCT and UNIQUE clauses
• Lab Exercise

Module 06: Sorting Data Demo

Module 07: Displaying Data from Multiple Tables

• Identify Types of Joins
• ANSI standard join operators vs. non-standard join methods
• Using the non-standard join methods
• Inner join vs. Outer join
• Generating a Cartesian Product
• ANSI standard join operators
• NATURAL JOIN, JOIN USING, JOIN ON, LEFT/RIGHT/FULL OUTER joins
• Lab Exercise

Module 08: Displaying Data from Multiple Tables Demo

Module 09: Character Row Functions

• Categories of row functions
• Statement behavior of row functions
• Useful / common character row functions
• Nest Functions to perform multiple tasks in one statement
• Lab Exercise

Module 10: Character Row Functions Demo

Module 11: Numeric Row Functions

• Where numeric row functions can and cannot be used
• Helpful numeric row functions in SQL statements
• Functionalities of common numeric row functions
• Explain Implicit and Explicit conversion
• Lab Exercise

Module 12: Numeric Row Functions Demos

Module 13: Date/Time Row Functions

• Where date/time row functions can and cannot be used
• Helpful date/time row functions in SQL statements
• Functionalities of common date/time row functions
• Lab Exercise

Module 14: Date/Time Row Functions Demo

Module 15: Miscellaneous Row Functions

• Using conversion functions
• Using conversion functions to format date/time data
• Environment and Data specific row functions
• The Decode function versus the Case Option
• Lab  Exercise

Module 16: Miscellaneous Row Functions Demo

Module 17: Aggregating Data Using Group Functions

• Categorize the Types of Group Functions
• Use the AVG, SUM, MAX, MIN, and COUNT Functions in a Query
• Utilize the DISTINCT Keyword with the Group Functions
• Describe how Nulls are handled with the Group Functions
• Create Groups of Data with the GROUP BY Clause
• Group Data by more than one column
• Exclude Groups of Data with the HAVING Clause
• Differences between the HAVING clause and the WHERE clause
• Lab Exercise

Module 18: Aggregating Data Using Group Functions Demo

Module 19: Extensions to the GROUP BY Clause

• Using the CUBE option
• Using the ROLLUP option
• CUBE vs. ROLLUP output
• The GROUPING BY option
• Lab Exercise

Module 20: Extensions to the GROUP BY Clause Demo

Module 21: Manipulating Data I

• Write INSERT statements to add rows to a table
• Insert Special Values
• Copy Rows from Another Table
• Update Rows in a Table
• Use DELETE statements to remove rows from a table
• Delete Rows Based on Another Table
• The COMMIT and ROLLBACK statements
• Using the SAVEPOINT statement
• Lab Exercise

Module 22: Manipulating Data I Demo

Module 23: Manipulating Data II

• Describe the TRUNCATE Statement
• TRUNCATE vs. DELETE
• Using the Multi-table INSERT statement
• Using the MERGE statement
• Show how Read Consistency works
• Lab Exercise

Module 24: Manipulating Data II Demo

Module 25: 12c New Features

• Top-n Query
• Cascading Truncate Statement
• Native Left Outer Join

You need to have equivalent experience or have taken the following GogoTraining course:

• Introduction to Programming and Coding for Everyone with JavaScript

In this course, students learn how to use the advanced features of SQL in order to query and manipulate data within the database. Advanced querying and reporting techniques including using SET operators, writing hierarchical queries and using the Flashback Query feature are explained. Schema objects such as Tables, Indexes and Constraints are discussed in detail. 

In order to take this course you need to have taken Oracle 11g/12c: Introduction to SQL and have experience in writing Oracle SQL statements.

Module 00: Oracle 11g/12c: Advanced SQL Online Training - Course Introduction

Module 01: Using the Set Operators
•    Use the UNION operator to return all rows from multiple tables and eliminate any duplicate rows
•    Use the UNION ALL operator to return all rows from multiple tables (with duplicates)
•    Describe and use the INTERSECT operator
•    Explain and use the MINUS operator
•    List the SET operator guidelines
•    Order results when using the UNION operator
•    Using the ORDER BY clause with SET operators
•    Lab Exercise

Module 02: Using the Set Operators Demo

Module 03: Flashback Query
•    Prerequisites for using the Flashback Query feature
•    Uses for the Flashback Query feature
•    Limitations of the Flashback Query feature
•    Statement level vs. session level usage
•    Using statement level Flashback Query
•    The AS OF TIMESTAMP option
•    Using session level Flashback Query
•    The DBMS_FLASHBACK Oracle supplied package
•    Lab Exercise

Module 04: Flashback Query Demo

Module 05: Using Subqueries
•    Use a subquery to solve a problem
•    Identify where subqueries can be placed in a SELECT statement
•    Describe the types of subqueries (single row, multiple row)
•    The single row subquery operators
•    The multiple row subquery operators
•    Using multi-column subqueries
•    Writing a correlated subquery
•    Lab Exercise

Module 06: Using Subqueries Demo

Module 07: Hierarchical Retrieval
•    Hierarchical Queries
•    Ranking Rows with LEVEL
•    Formatting Hierarchical Reports Using LEVEL and LPAD
•    Pruning Branches with the WHERE and CONNECT BY clauses
•    Lab Exercise

Module 08: Hierarchical Retrieval Demo

Module 09: Using the Data Dictionary Views
•    Types of Data Dictionary Views
•    Privileges needed to access the Data Dictionary Views
•    Using the Data Dictionary Views to view database metadata information
•    Helpful Data Dictionary Views
•    Lab Exercise

Module 10: Using the Data Dictionary Views Demo

Module 11: Creating Database Objects I (Views)
•    Creating a view syntax
•    View options
•    Privileges needed to create a view
•    Benefits of views
•    Limitations of views
•    Using views in SQL statements
•    Retrieving View definitions from the Data Dictionary
•    Lab Exercise

Module 12: Creating Database Objects I (Views) Demos

Module 13: Creating Database Objects II (Sequences)
•    Creating a sequence syntax
•    Privileges needed to create a sequence
•    Sequence usage
•    Sequence options
•    Using sequences in SQL statements
•    Retrieving Sequence definitions from the Data Dictionary
•    Lab Exercise

Module 14: Creating Database Objects II (Sequences) Demo

Module 15: Creating Database Objects III (Synonyms)
•    Types of synonyms
•    Private vs. Public synonyms
•    Creating a synonym syntax
•    Privileges needed to create a synonym
•    Synonym usage
•    Using synonyms in SQL statements
•    Retrieving Synonym definitions from the Data Dictionary
•    Lab Exercise

Module 16: Creating Database Objects III (Synonyms) Demo

Module 17: Creating Database Objects IV (Tables)
•    Types of Tables
•    The Basic Heap Table
•    Creating a table syntax
•    Valid column datatypes
•    Privileges needed to create a table
•    Retrieving Table definitions from the Data Dictionary
•    Lab Exercise

Module 18: Creating Database Objects IV (Tables) Demo

Module 19: Creating Database Objects V (Indexes)
•    Types of Indexes
•    Benefits of Indexes
•    The B-Tree Index
•    Creating an index syntax
•    Privileges needed to create a index
•    Retrieving Index definitions from the Data Dictionary
•    Lab Exercise

Module 20: Creating Database Objects V (Indexes) Demo

Module 21: Creating Database Objects VI (Constraints)
•    Types of Constraints
•    Primary Key, Foreign Key, Unique, NOT NULL, Check constraints
•    Review constraint purposes
•    Creating a constraint syntax
•    CREATE vs. ALTER syntax
•    Retrieving Constraint definitions from the Data Dictionary
•    Lab Exercise

Module 22: Creating Database Objects VI (Constraints) Demo

Module 23: Regular Expression Support
•    Regular Expression Support Overview
•    Describing simple patterns for searching and manipulating data
•    Describing complex patterns for searching and manipulating data
•    Lab Exercise

Module 24: Regular Expression Support Demo

Module 25: Advanced Oracle: 12c New Features

•    Row Pattern Matching

•    A Sequence Change

•    Invisible Columns

•    Data Type Changes

•    UNION/UNION All Changes

You need to have equivalent experience or have taken the following GogoTraining courses:

• Introduction to Programming for Non-Programmers
• Introduction to Programming and Coding for Everyone with JavaScript
• Oracle 10g/11g: Introduction to SQL
• Oracle 11g/12c: Introduction to SQL

This Oracle 11g PL/SQL programming Part 1 online training course introduces you to PL/SQL and helps you understand the benefits of Oracle’s proprietary database language. You will learn to create PL/SQL blocks of application code that can be shared by multiple users, forms, reports, and data management applications. In addition you will create anonymous PL/SQL blocks as well as named stored procedures, functions, packages and triggers.  This Oracle course also covers learning to develop, execute, and manage PL\SQL stored program units, subprograms, triggers, declaring identifiers and both user-defined and pre-defined exceptions. You will be introduced to the utilization of some of the more useful Oracle-supplied packages.

Once you have completed Oracle 11g PL/SQL Programming Part 1 the next course in this series is Oracle 11g PL/SQL Programming Part 2.  The Oracle 11g PL/SQL Programming Part 2 course will continue to guide you through more intermediate PL/SQL topics.  You will learn how to handle runtime errors, cursor processing, stored procedures and functions, and design and use PL/SQL packages.  Also, you will learn how to manage dependencies between stored units, manage security, and create automatic triggers to solve business requirement.  Click here to learn more about Oracle 11g PL/SQL Programming Part 2.

Module 00: Oracle 11g PL/SQL programming Part 1 online training - Course Introduction

Module 01: PL/SQL Overview Part 1

• Define PL/SQL
• Identify Advantages of Using PL/SQL
• Basic PL/SQL Commands
• Discuss where PL/SQL is used
• Exercise

Module 02: PL/SQL Overview Part 2

• Understand PL/SQL Block Structure
• List the Four Main Parts of a PL/SQL Block
• State the Purpose of each Part
• Write Anonymous Blocks
• Nested Blocks
• Use DBMS_OUTPUT.PUT_LINE Procedure
• Exercise

Module 03: I/O Within PL/SQL and Overview of Sample Environment

• I/O Within PL/SQL
• Overview of Sample Environment
• Exercise: PL/SQL Overview

Module 04: Datatypes and Scalar Variables

• Datatypes
• Declare Scalar Variables

Module 05: Composite Variables

• Create Composite Variables
• Assign and update Values for Variables
• Reference PL/SQL Table Variables

Module 06: Datatypes and Scalar Variables Exercise and Exercise Review

Module 07: SQL Statements in PL/SQL

• Select Data from the Database into PL/SQL Variables
• The INTO Clause
• Using SQL in PL/SQL: SELECT
• Exercise Review

Module 08: DML Commands and Transaction Processing

• DML Commands
• Using RETURNING Clause
• Transaction Processing Statements: COMMIT, ROLLBACK, and SAVEPOINT

Module 09: DML Commands and Transaction Processing Exercise and Exercise Review

Module 10: IF and CASE Statements

• Use IF..THEN..ELSE Logic in PL/SQL
• Use the CASE Statement
• Exercise: IF and CASE
• Exercise Review

Module 11: Loops and Labels

• Labels and GOTO Statement
• Looping Statements
• Simple Loops, Numeric FOR Loops, WHILE Loops
• Exercise: Loops
• Exercise Review
• What Should I Know about Conditional Logic and Loops?

Module 12: Exception Handling

• Exception Handling
• Define and Code Exceptions
• The OTHERS Exception

Module 13: Pre-Defined Exceptions

• Pre-Defined Exceptions
• Exercise: Pre-Defined Exceptions
• Exercise Review

Module 14: Using SQL code, SQLERRM and User-defined Exceptions

• SQL code
• SQLERRM
• User-defined exceptions

Module 15: User-Defined Exceptions Exercise and Exercise Review

• What Should I Know about Exceptions?

o Identify and code exceptions
o Use pre-defined exceptions
o Declare exceptions
o Write exception handlers
o Implement exception handler for OTHERS exception
o Create and handle user-defined exceptions
o Report error messages - both user and system

Module 16: Exception Propagation and Displaying Errors

• Exception Propagation
• Using Nested Blocks
• Using RAISE_APPLICATION_ERROR
• Display errors with DBMS_UTILITY

Module 17: Exception Propagation and Displaying Errors Exercise and Exercise Review

You need to have equivalent experience or have taken the following GogoTraining courses:

• Oracle 10g/11g: Introduction to SQL
• Oracle 10g/11g: Advanced SQL
• Oracle 11g/12c: Introduction to SQL
• Oracle 11g/12c: Advanced SQL

Oracle 11g PL/SQL Programming Part 2 online training picks up right where Part 1 completes and continues to guide you through more intermediate PL/SQL topics. Through hands-on exercises, you learn to handle all types of runtime errors, use explicit cursor processing including cursor FOR loops, create and use stored procedures and functions, and design and use PL/SQL packages as well as understand the benefits of using packages. This Oracle programming course teaches you to manage dependencies between these PL/SQL stored units, and understand and manage security for them as well. Also covered in this Oracle training is learning how to automate processing by creating triggers to solve business requirements including 11g compound triggers.

In order to take this course you need to have taken Oracle 11g PL/SQL Programming Part 1 and have experience in some high-level programming such as SQL.

Module 00: Oracle 11g PL/SQL Programming Part 2 online training - Course Introduction

Module 01: Cursor Basics

• Learn How Oracle uses Cursors to Process SQL
• Identify when to use an Explicit Cursor
• Describe an Implicit Cursor
• Use Cursor OPEN, FETCH, and CLOSE Statements
• Identify and Use Cursor Attributes
• Use Parameters with Cursors
• Use Cursor FOR Loops

Module 02: Cursor Basics Exercise and Exercise Review

Module 03: Advanced Cursor Topics

• Using %ROWTYPE
• Cursor FOR Loops
• Cursors with Parameters

Module 04: Advanced Curser Topics Part 2

• Using "Where Current of" Option
• Exercise Cursors
• Exercise Review
• What Should I Know about Cursor Processing?

Module 05: Stored Procedures and Functions Basics

• Create Stored Procedures
• Create Stored Functions
• Use a Function in a SQL Statement
• Shared SQL Area
• Pass Parameters to Procedures and Functions
• Locate Source Code in the Database

Module 06: Stored Procedures and Functions Basics Exercise and Exercise Review

Module 07: Passing Parameters to Stored Procedures and Functions

• Using Parameters
• Formal Parameter Modes

Module 08: Passing Parameters to Stored Procedures and Functions Exercise and Exercise Review

Module 09: Dependencies and Security

• Source Code and Dependencies
• security for Stored Program Units
• Implementing Invoker's Rights
• DETERMINISTIC Functions

Module 10: Stored Procedure and Functions Exercise and Exercise Review

• What Should I Know about Stored Procedures and Functions?

Module 11: Trigger Basics

• Triggers
• Define Characteristics of Database Triggers

Module 12: Trigger Basics Part 2

• Row vs. Statement Triggers
• Trigger Types
• Understand the Difference between Statement Level and Row Level Triggers
• Identify Restrictions for Triggers

Module 13: Advanced Trigger Concepts

• Use Trigger Predicates
• Retrieve Trigger Definitions from the Data Dictionary
• Enable and Disable Triggers
• Execution Order of Triggers- Using FOLLOWS clause Compound Triggers (11g)
• Other Events and Triggers

Module 14: Triggers Exercise and Exercise Review

• What Should I Know about Triggers?

Module 15: PL/SQL Packages

• Identify Advantages of Using Packages
• Define a Package Specification
• Define a Package Body

Module 16: PL/SQL Packages Part 2

• Implement Public and Private Elements
• Understand Persistent State of Packaged Objects
• Execute Procedures and Functions in a Package

Module 17: Packages Exercise and Exercise Review

• What Should I Know about Packages?

You need to have equivalent experience and have taken Oracle 11g PL/SQL Programming Part 1 or taken the following GogoTraining courses:

• Oracle 10g/11g: Introduction to SQL
• Oracle 10g/11g: Advanced SQL
• Oracle 11g/12c: Introduction to SQL
• Oracle 11g/12c: Advanced SQL
• Oracle 11g PL/SQL Programming Part 1

In this Oracle database administration course, Part 1 of a two part online training series, you will explore how an Oracle Database applies 'grid computing' to multiple computers to provide fast, efficient, secure data storage and manipulation that easily scales to thousands of clients. In this Oracle training, students learn how to install, administer and maintain an Oracle 10g or 11g database in an effective and efficient manner. Topics such as the interaction among Oracle components, an understanding of Oracle's architecture and user management are covered. Students learn to install, administer and maintain an Oracle 10g or 11g database in an effective and efficient manner. Performance monitoring, database security and backup and recovery techniques are covered. This course will assist those preparing to take the Oracle Certified Associate (OCA) certification examination.

Once you have completed Oracle 10g/11g Database Administration I Part 1 the next course is this series is Oracle 10g/11g Database Administration I Part 2. The Oracle 10g/11g Database Administration I Part 2 course will contiue to build your knowledge in shared server, database performance monitoring, database maintenace, how to use the undo management feature, how to deal with locking conflicts and finishing up with backups and database recovery. Click here to learn more about Oracle 10g/11g Database Administration I Part 2.

Module 00: Oracle 10g/11g Database Administration I Part 1 Online Training - Course Introduction

Module 01: Architectural Components Part 1

• Physical Structure

• Memory Structure

• Process Structure

• Logical Structure

Module 02: Architectural Components Part 2

• Stages of a SQL Statement

• Defining the Database, Instance and Server

Module 03: Administration and Installation Tools for Oracle Server Part 1

• Administration Tools

• The Oracle Universal Installer

Module 04: Administration and Installation Tools for Oracle Server Part 2

• SQL*Plus

• Configuration Assistants

Module 05: Database Architecture and Creation Part 1

• Optimal Flexible Architecture

• Syntax

• Demo: Create User and Drop User

• Demo: Create Table and Drop Table

Module 06: Database Architecture and Creation Part 2 

• Automatic Storage Management

• Oracle Architectures

Module 07: Database Interfaces

• SQL Interface

• Java Interface

• C++ Interface

• PL/SQL Interface

Module 08: Database Control Part 1 

• Controlling the Agents

• Exercise: Multithreaded agents

• Controlling the Database

• Startup

Module 09: Database Control Part 2

• Shutdown mechanisms

• Exercise: Database Startup and Shutdown

• Controlling the listener

• Exercise: Controlling the Listener

Module 10: Storage Structures

• Tablespace Creation

• Exercise: Tablespace Creation

• Exercises: Tablespace Object Space Utilization

• Tablespace Management

• Exercise: Restoring Objects from the Recycle Bin

• Tablespace Information

• Exercise: Tablespace Information

Module 11: User Management Part 1

• Managing Users

• Exercises: New User

• Managing Roles

• Exercise: Locking / Unlocking Accounts

• Exercise: Working with Profiles

• Managing Privileges

• Demo: Find the Database Statistics

• Demo: Validate System Objects

• Exercise: Common System Privileges

Module 12: User Management Part 2

• Common Object Privileges

• Exercises: Object Privileges

• Taking Away Privileges

• Exercises: Taking Away Privileges

• Creating and Managing Roles

• Exercise: Creating and Managing Roles

Module 13: Schema Object Management

• Managing Tables

• Exercise: Modifying Tables

• Managing Constraints

• Exercise: Working with Constraints

Module 14: Schema Object Management Part 2

• Managing Indexes

• Exercise: Constraint-Related Indexes

• Managing Views

Module 15: Data Management using SQL*Loader Part 1

• Using SQL*Loader to Import Information

• Control Files

• Quiz

Module 16: Data Management using SQL*Loader Part 2

• Managing Data Loads

• Tuning Data Loads

• Direct Data Loading

• Demo: Enable ARCHIVELOAD Mode 

• Exercise: Using SQL*Loader to Load a Table

Module 17: Data Management Using the Data Pump

• Data Pump Export

• Exercises: Performing a Data Pump Export

• Data Pump Import

• Exercise: Performing a Data Pump Import

• Demo: Using the Data Pump

Module 18: PL/SQL Overview

• PL/SQL Declarations

• Quiz

• PL/SQL Code

Module 19: PL/SQL Exceptions

• Creating Exceptions

• Handling Exceptions

• Built-In Exceptions

• Exercises: Exception Handling

Module 20: Database Security Management Part 1

• Authentication

• System Schema

• System Privilege

Module 21: Database Security Management Part 2

• Password Security –Profiles

• Password Storage and Verification

• Exercise: Utilizing Local Password Storage

• Exercises: Protecting the SYS Password

Module 22: Database Security Management Part 3

• Database Auditing

• Auditing Tables and Records

• Exercise: Database Auditing

Module 23: Oracle Net Services Part 1

• Oracle Net Services Overview and Concepts

• Oracle Listener Creation and Configuration

• Exercises: Listener Security

Module 24: Oracle Net Services Part 2

• Oracle Net Manager

• Exercise: Starting Oracle Net Manager

• Using TNSPING

You need to have equivalent Oracle 9i database experience or have taken the following GogoTraining courses:

• Oracle 10g/11g: Introduction to SQL
• Oracle 10g/11g: Advanced SQL
• Oracle 11g PL/SQL Programming Part 1
• Oracle 11g PL/SQL Programming Part 2

In this Oracle database administration online training course, Part 2 of a two part series, you will explore how an Oracle Database applies 'grid computing' to multiple computers to provide fast, efficient, secure data storage and manipulation that easily scales to thousands of clients. Students will learn how to install, administer and maintain an Oracle 10g or 11g database in an effective and efficient manner. Training topics such as performance monitoring, database security and backup and recovery techniques are covered. This Oracle training will assist those preparing to take the Oracle Certified Associate (OCA) certification examination.

Once you have completed Oracle 10g/11g Database Administration I Part 2 the next course you will want to take is Oracle 10g/11g Database Administration II Part 1. The Oracle 10g/11g Database Administration II is a 2 part series that will enhance your knowledge further with more advance Oracle database topics. Click here to learn more about Oracle 10g/11g Database Administration II Part 1 and Part 2.

Module 00: Oracle 10g/11g Database Administration I Part 2 Online Training - Course Introduction

Module 01: Oracle Shared Server
•    Architecture
•    Benefits and Features

Module 02: Configuration, Tuning and Monitoring
•    Oracle Shared Server Configuration
•    Tuning the Oracle Shared Server
•    Demo: Tuning the Oracle Shared Server
•    Exercise: Tuning MAX_SHARED_SERVERS
•    Monitoring the Oracle Shared Server
•    Exercise: Tuning Shared Servers

Module 03: Database Performance Monitoring, Part 1
•    Database Statistics: Manual vs. Automatic
•    Demo: Viewing Database Statistics
•    Exercise: Database Statistics
•    Exercise: V$OSSTAT View
•    Analyzing Objects

Module 04: Database Performance Monitoring, Part 2
•    Validating Database Structure
•    Demo: Validating Database Structure
•    Exercise: Validating Structure
•    Validating System Objects

Module 05: Database Maintenance Techniques
•    Alerts
•    Exercise: Alerts
•    Enterprise Manager
•    Threshold Information
•    Demo: Recovering from Non-Critical Losses
•    Exercises: Threshold Alerts and Views

Module 06: Using Advisors
•    SQL Access Advisor Package
•    Diagnostic Advisor
•    SQL Advisor
•    Tuning Advisor
•    Demo: Diagnostic and SQL Tuning Advisors
•    Exercise: SQL Tuning Advisor

Module 07: Using the Automatic Database Diagnostic Monitor (ADDM)
•    ADDM and AWR
•    ADDM Features
•    Reports
•    Demo: Automatic Database Management
•    Exercise: Working with ADDM

Module 08: Using the Workload Repository
•    Components
•    Snapshots
•    Views
•    Reports
•    Demo: Recovering from User Errors
•    Exercise: Generating an AWR report

Module 09: Configuring Database Undo Management
•    Definition of Database Undo Management
•    Exercises: Monitoring Database Undo
•    Configuration of Database Undo Management
•    Demo: Using Recovery Manager
•    Exercises: UNDO_RETENTION
•    Exercise: Undo Retention and Tablespace

Module 10: Administering Database Undo Management
•    Flashback
•    Flashback Mechanism
•    Flashback Query
•    Demo: Table Flashback
•    Exercise: Using Table Flashback
•    Undo Advisor

Module 11: Detecting Database Locking Conflicts
•    Detecting Database Locking Conflicts
•    Database Locking Modes

Module 12: Resolving Database Locking Conflicts
•    Detecting Deadlocks
•    Designing Avoidance of Deadlocks
•    Manual Locking

Module 13: Database Backup and Recovery Concepts
•    Overview
•    Control Files
•    Sizing Control Files

Module 14:  Data and Log Files
•    Data Files
•    Exercise: Viewing Absolute File Numbers
•    DB_ Files
•    Log Files
•    Listing Data Files
•    Exercises: Listing and Viewing Files

Module 15: Writer and Archiver Processes
•    Log Writer Processes
•    Archiver Processes
•    Demo: Performing Critical Database Recoveries
•    Exercise: Adjusting Archiver Processes

Module 16: NOARCHIVELOG and ARCHIVELOG Mode
•    NOARCHIVELOG mode
•    ARCHIVELOG mode
•    Implications of ARCHIVELOG mode and Automatic Archival

Module 17: Constituent Elements
•    Overview
•    Data Files
•    Redo Logs
•    Control Files

Module 18: Database Backups
•    Consistent Backups vs. Inconsistent Backups
•    Full Backups vs. Incremental Backups
•    Demo: Performing Backups

Module 19: User-Managed Backups and Individual Tablespaces
•    Performing User-Managed Backups
•    Configuring a Flash Recovery Area
•    Demo: Configuring a Flash Recovery Area
•    Exercises: Flash Recovery Area
•    Backing Up Individual Tablespaces
•    Demo: Backing Up Individual Tablespaces
•    Exercise: Backing Up Individual Tablespaces

Module 20: Server-Managed Backups
•    Performing Server-Managed Backups (RMAN)
•    Demo: Configure RMAN for Complete Backup
•    Exercise: Configure RMAN for Complete Backup

Module 21: Types of Database Recovery
•    General Categories of Recovery
•    Datafile Recovery
•    Demo: Restoring a Data File by its File Number
•    Exercise: Restoring a Datafile by Filenumber
•    Using RMAN for Recovery
•    Fast Database Recovery
•    Using Flashback
•    Demo: Flashback Database
•    Exercise: Fast Database Recovery

Module 22:  Using Flashback
•    Methodology
•    Flashback Drop
•    Recovering Objects from Recycle Bin
•    Demo: Recovering Objects from Recycle Bin
•    Exercise: Flashback Table

Module 23: Incarnations and Log Sequence Numbers
•    Incarnations
•    Log Sequence Numbers
•    Exercise: Log Sequence Numbers

You need to have equivalent Oracle 9i database experience and have taken Oracle 10g/11g Database Administration I Part 1 or have taken the following GogoTraining courses:
•    Oracle 10g/11g: Introduction to SQL
•    Oracle 10g/11g: Advanced SQL
•    Oracle 11g PL/SQL Programming Part 1
•    Oracle 11g PL/SQL Programming Part 2
•    Oracle 10g/11g Database Administration I Part 1

This Oracle online training course explains advanced Oracle database topics. Oracle 10g/11g Database Administration II Part 1 provides an in-depth look into Oracle’s backup and recovery architecture as well as advanced DBA issues, and discusses facets of advanced database administration tasks. This Oracle online training is designed for the Oracle database administrator with some experience.

In order to take this course you need to have taken Oracle 10g/11g Database Administration I Part1 and Part 2, Oracle 10g/11g: Introduction to SQL, Oracle 10/11g: Advanced SQL, Oracle 11g PL/SQL Programming Part 1 and Part 2 or equivalent experience.

Once you have completed the Oracle 10g/11g Database Administration II Part 1 the next course in this  series is Oracle 10g/11g Database Administration II Part 2.  Part 2 provides an in-depth look into Oracle’s advanced memory architecture, database advisors, and job scheduler. Click here to learn more about Oracle 10g/11g Database Administration II Part 2.

Module 00: Oracle 10g/11g Database Administration II Part 1 Online Training - Course Introduction

Module 01: Introduction to Oracle

• Oracle products
• Oracle Enterprise Solutions
• PeopleSoft
• Oracle Applications
• JD Edwards
• Siebel

Module 02: Oracle Database Management Products

• Oracle Universal Installer
• Oracle Enterprise Manager
• Oracle Grid Solution
• Oracle Database: Enterprise and Standard Editions

Module 03: Database Creation Assistant

• Database Utilities
• Database Configuration Assistant(DBCA)
• Networking Assistant(NETCA)
• Lab: Database Creation

Module 04: Oracle Architecture/ASM

• Oracle Instance
• SGA
• Background processes
• ASM instance architecture

Module 05: ASM Disks/DiskGroups

• ASM disks
• ASM diskgroups
• External
• Normal
• High

Module 06: Managing ASM Part 1

• Administer the ASM instance
• Add disks
• Rebalance disks
• Disk re sync
• •asmcmd

Module 07: Managing ASM Part 2

• ASM and SQL Plus
• ASM CMD
• ASM and Enterprise Manager

Module 08: Database Recovery

• Archivelog mode
• NoArchivelog mode
• Configure multiple archivelog destinations
• Lab: Archivelog mode

Module 09: Flash Recovery Area

• Configure flash recovery area
• Configure flashback database
• Lab: Archivelog and flashback mode

Module 10: Recovery Catalog

• Definition of recovery catalog
• Recovery catalog meta data
• Create the recovery catalog

Modules 11: Recovery Catalog Scripts and Databases

• Create recovery catalog scripts
• Register target databases
• Synchronizing the recovery catalog

Module 12: Administering the Recovery Catalog

• Backup the recovery catalog
• Configure recovery catalog settings
• Create a virtual private catalog

Module 13: RMAN Backups

• Backup sets
• Image copies
• Non-compressed backups
• Compressed backups
• Incremental backups
• Lab: Database backup

Module 14: RMAN Recovery

• Non-critical recovery
• RMAN restore/recover command

Module 15: RMAN Critical Recovery

• Recover a critical data file
• Incremental recovery
• Image copy recovery
• Recovery to an alternate location

Module 16: RMAN Incomplete Recovery

• Time based recovery
• Duplicate database
• Restoring a controlfile
• Recovery in NoArchivelog mode

Module 17: User Managed Recovery

• Complete database recovery
• Incomplete database recovery
• Backup the controlfile
• Backup database in archivelog/noarchivelog

Module 18: Tuning RMAN

• Multiple channels
• Long running backups
• Async I/O
• SYNC I/O

Module 19: Additional RMAN Features

• Cloning a database
• Tablespace Point in Time Recovery(TSPITR)

Module 20: Recyclebin

• Define the recyclebin
• Retrieve objects from the recyclebin
• Define protected objects in the recyclebin
• Lab: Creating a table drop and recover the table

Module 21: Flashback Query

• Undo_retention
• Flashback query
• Flashback versions query
• Flashback transactions query

Module 22: Flashback Data Archives

• Define flashback data archives
• Manage flashback data archives
• Flashback data archives administration

Module 23: Flashback Database

• Configure flashback database
• Monitor flashback database
• Perform flashback database

Module 24: Oracle 10g/11g Database Administration II Part 1 Online Training - Course Summary

You need to have equivalent experience or have taken the following GogoTraining courses:

• Oracle 10g/11g: Introduction to SQL
• Oracle 10g/11g: Advanced SQL
• Oracle 11g PL/SQL Programming Part 1
• Oracle 11g PL/SQL Programming Part 2
• Oracle 10g/11g Database Administration I Part 1
• Oracle 10g/11g Database Administration I Part 2

This Oracle online training course explains advanced Oracle database topics. Oracle 10g/11g Database Administration II Part 2 provides an in-depth look into Oracle’s advanced memory architecture, database advisors, and job scheduler. This training is designed for the experienced Oracle database administrator.

In order to take this course you need to have taken Oracle 10g/11g Database Administration I Part1 and Part 2, Oracle 10g/11g: Introduction to SQL, Oracle 10/11g: Advanced SQL, Oracle 11g PL/SQL Programming Part 1 and Part 2 or equivalent experience.

Module 00: Oracle 10g/11g Database Administration II Part 2 Online Training - Course Introduction

Module 01: Oracle Advanced Memory Management
• Oracles memory structure
• Initialization parameters

Module 02: Automatic Memory Tuning
• Automatic Shared Memory Management (ASMM)
• Memory_Target
• SGA_TARGET
• Auto-tuned memory parameters

Module 03: Program Global Area (PGA)
• Understanding the PGA
• Configuring automatic tuning for the PGA

Module 04: Database Tuning
• Understand the advisor framework
• Define the contents of the automatic database advisors
• Lab: Advisor framework

Module 05: Automatic Tuning Optimizer
• SQL tuning advisor
• SQL tuning sets
• SQL tuning tasks

Module 06: Physical SQL Tuning
• SQL access advisor
• AWR
• ADDM
• SQL workloads

Module 07: Database Impact Advisors
• SQL performance analyzer
• Database replay process

Module 08: Memory Advisors
• Database memory advisors
• Mean time to recover advisors
• Undo management advisors

Module 09: Oracle and Resumable Space
• Understanding resumable space
• Configuring the database for resumable space allocation

Module 10: Reclaiming Space
• Reclaiming wasted spaced in tables
• Reclaiming wasted space in indexes
• Using the automatic segment advisor

Module 11: Resource Management
• Understand the resource management architecture
• Determine allocation methods

Module 12: Advanced Resource Management
• Understand the resource plans
• Create a resource plan
• Lab: Creating a resource group and plan

Module 13: Database Diagnostics
• Understand the Automatic Diagnostic Repository(ADR)
• Create the ADR
• ADR contents
• ADR tools

Module 14: Database Health Checkers
• Oracle support workbench
• Oracle health monitor
• Identify and correct block corruption

Module 15: Database Recovery Advisors
• Benefits of using the Database Recovery Advisor (DRA)
• DRA features
• Using DRA

Module 16: Oracle Job Scheduler
• Understand the job scheduler framework
• Program
• Job
• Schedule
• Window
• Lab: Creating a default schedule

Module 17: Oracle Job Scheduling Options
• Time based jobs
• Event driven jobs

Module 18: Oracle Jobs
• Oracle pre-defined jobs
• Oracle pre-defined windows
• Oracle maintenance tasks

Module 19: Oracle Job Definitions
• Understanding job chains
• Dependant jobs
• Define and create job classes
• Define and create windows
• Job priorities

Module 20: Oracle Globalization Support
• Define Oracle globalization support
• Creating a database that uses globalization support
• Database character sets

Module 21: Time Zone Support
• Define time zone support
• Use Oracle locale builder
• Support for databases in different time zones

Module 22: Oracle 10g/11g Database Administration II Part 2 Online Training - Course Summary

You need to have equivalent experience and have taken Oracle 10g/11g Database Administrtion II Part 1 or have taken the following GogoTraining courses:

• Oracle 10g/11g: Introduction to SQL
• Oracle 10g/11g: Advanced SQL
• Oracle 11g PL/SQL Programming Part 1
• Oracle 11g PL/SQL Programming Part 2
• Oracle 10g/11g Database Administration I Part 1
• Oracle 10g/11g Database Administration I Part 2
• Oracle 10g/11g Database Administration II Part 1

In this Oracle database administration course, Part 1 of a two part online training series, you will explore how an Oracle Database applies 'cloud computing' to multiple computers to provide fast, efficient, secure data storage and manipulation that easily scales to thousands of clients. In this Oracle training, students learn how to install, administer and maintain an Oracle 12c database in an effective and efficient manner. Topics such as the interaction among Oracle components, an understanding of Oracle's architecture and user management are covered. This course will assist those preparing to take the Oracle Certified Associate (OCA) certification examination.

Once you have completed Oracle 12c: Database Administration I Part 1 the next course is this series is Oracle 12c: Database Administration I Part 2. The Oracle 12c: Database Administration I Part 2 course will continue to build your knowledge in shared server, database performance monitoring, database maintenance, how to use the undo management feature, how to deal with locking conflicts and finishing up with backups and database recovery. Click here to learn more about Oracle 12c: Database Administration I Part 2.

Module 00: Course Introduction - Oracle 12c: Database Administration I Part 1

Module 01: Database Architecture

• Oracle Architecture
• Memory Components
• Background Processes
• Quiz: Database Architecture

Module 02: Oracle Physical and Logical Structures

• Oracle Logical Storage Structures
• Oracle Physical Storage Structures

Module 03: Oracle and ASM

• ASM Instance
• ASM parameters
• ASM Components
• Quiz: Oracle and ASM

Module 04: Container Databases and Pluggable Databases

• Define Container databases
• Define Pluggable databases

Module 05: Oracle 12c Installing ASM

• Define ASM
• Install ASM
• Lab Exercise: Create and Install ASM 
• Lab Exercise Solution: Create and Install ASM Demo

Module 06: Installing the Database Software

• Define database software requirements
• Install Oracle database Software
• Lab Exercise: Installing the Database Software 
• Lab Exercise Solution: Installing the Database Software Demo

Module 07: Creating a Container Database

• Define Database Requirements
• Create a Container Database using DBCA

Module 08: Creating a Traditional Database 

• Define Database Requirements
• Create a Traditional Database using DBCA
• Lab Exercise: Create a Database 
• Lab Exercise Solution: Create a Database Demo

Module 09: Oracle 12c Database Tools

• Define SQLPLUS
• Use Enterprise Manager Express
• Demo: Use Enterprise Manager Express 

Module 10: Manage your Database with SQL Developer

• Manage Database with SQL Developer
• Understanding SQL Developer
• Demo: Use SQL Developer

Module 11: Manage your Database with Cloud Control

• Manage your database with Cloud Control
• Cloud Control Architecture
• Demo: Use Cloud Control

Module 12: Managing the Database Instance

• Define the components of the SGA
• Identify initialization parameters

Module 13: Start/Stop the Database 

• Start/Stop the database
• Identify the Location of the Alert.log file
• Use Dynamic Performance Views
• Quiz: Managing the Database Instance

Module 14: Maintaining Data Files

• Create tablespaces
• Create Container Databases
• Create Pluggable databases
• Lab Exercise: Create Container Databases, Pluggable Database and Tablespaces 

Module 15: Container Database Architecture

• Identify CDB_* views
• Utilize CDB security

Module 16: Database Security

• Identify Oracle Default accounts
• Create Database Users
• Create database Roles
• Assign database privileges
• Lab Exercise: Create DB Users 

Module 17: Database Profiles

• Identify Database Profiles
• Uses for Database Profiles
• Create Database Profiles

Module 18: Database Undo Components

• Identify Oracle's Undo Segments
• Identify Undo Parameters
• How Undo and Flashback Query Work Together
• Quiz: Database Undo Components

Module 19: Database Networking Components Part 1

• Identify the networking components
• Set up a Listener

Module 20: Database Networking Components Part 2

• Create a tnsnames files
• Use Oracle's EZ Connect

Module 21: Oracle Database Concurrency

• Identify Oracle's Locking Mechanism
• Monitor Row Locks
• Resolve Row Locks

In order to successfully complete Oracle 12c Database Administraion 1 Part 1 you will need to have equivalent experience in or have taken:

• Oracle 10g/11g: Introduction to SQL
• Oracle 10g/11g: Advanced SQL
• Oracle 11g PL/SQL Programming Part 1
• Oracle 11g PL/SQL Programming Part 2

In this Oracle database administration online training course, Part 2 of a two part series, you will explore how an Oracle Database applies 'cloud computing' to multiple computers to provide fast, efficient, secure data storage and manipulation that easily scales to thousands of clients. Students will learn how to install, administer and maintain an Oracle 12c database in an effective and efficient manner. Training topics such as performance monitoring, database security and backup and recovery techniques are covered. This Oracle training will assist those preparing to take the Oracle Certified Associate (OCA) certification examination.

Once you have completed Oracle 12c Database Administration I Part 2 the next course you will want to take is Oracle 12c Database Administration II Part 1. The Oracle 12c Database Administration II is a 2 part series that will enhance your knowledge further with more advance Oracle database topics. Click here to learn more about Oracle 12c Database Administration II Part 1 and Part 2.

Module 00: Course Introduction - Oracle 12c: Database Administration I Part 2

Module 01: Oracle 12c Enterprise Express

• Install Enterprise Express
• Use Enterprise Express
• Lab Exercise: Use Enterprise Manager Express (DEMO)

Module 02: Oracle 12c Cloud Control

• Identify the components of Cloud Control
• Install Cloud Control
• Set up targets within Cloud Control

Module 03: Undo Tablespaces

• Create undo tablespaces
• Manage Undo Tablespaces
• Change Undo Tablespaces
• Lab Exercise: Create Undo Tablespaces
• Lab Exercise: Change Undo Tablespaces

Module 04: Database Auditing

• Define Database Auditing
• Identify Database Auditing Parameters
• Set up database auditing
• Lab Exercise: Setup Database Auditing

Module 05: Database Backups

• Backup concepts
• User managed Backups
• Oracle Managed Backups
• Archivelog Mode and No Archivelog Mode
• Lab Exercise: Place the Database in Archivelog Mode

Module 06: RMAN Concepts

• Identify Backupsets
• Identify Image Copies
• Incremental Backups
• Quiz: RMAN Concepts

Module 07: RMAN Backups

• Create RMAN Backups command Line
• Create RMAN backups with Cloud Control
• Lab Exercise Perform a database backup

Module 08: Database Recovery

• User Managed Complete Recovery
• User Managed Incomplete Recovery
• RMAN complete Recovery
• RMAN incomplete Recovery
• Quiz: Database Recovery

Module 09: Additional Database Recovery

• Definition of non-critical loss
• Definition of Critical Loss
• Using Data Recovery Advisor
• Quiz: Data Recovery Advisor

Module 10: Oracle Data Pump

• Define Oracle's Data Pump Architecture
• Data Pump features
• Perform a data pump export
• Perform a data pump import
• Lab Exercise: perform a database export
• Lab Exercise: perform a database import

Module 11: Oracle Scheduling

• Define the Scheduling components
• Identify the differences between a: (Job, Program, Schedule, Window)
• Identify how Oracle performs resource management with  Job Scheduling
• Create Schedule
• Create a Job Chain

Module 12: Oracle 12 Performance Tuning

• Identify the components of the SGA for tuning
• Identify tuning parameters
• Oracle 12c Tuning Tools

Module 13: Advisory Framework

• Automatic Workload Repository (AWR)
• Automatic Database Diagnostic Monitory (ADDM)
• Real Time ADDM
• Lab Exercise:  Create and run an AWR report.

Module 14: Tuning Framework Tools

• SQL Tuning Advisor
• SQL Access Advisor
• Quiz: Tuning Advisor Framework

Module 15: Plan Management

• Identify SQL Baselines
• Use SQL Baselines
• Identify SQL Plan Management
• Use SQL Plan Management

Module 16: Tune SQL Statements

• Use DBMS_STATS
• Set DBMS_STATS parameters
• Create invisible indexes

In order to successfully complete Oracle 12c Database Administraion 1 Part 2 you will need to have equivalent experience in or have taken:

• Oracle 12c: Database Administration I Part 1
• Oracle 10g/11g: Introduction to SQL
• Oracle 10g/11g: Advanced SQL
• Oracle 11g PL/SQL Programming Part 1
• Oracle 11g PL/SQL Programming Part 2

In this Oracle database administration course, Part 1 of a two part online training series, you will explore how an Oracle Database applies 'cloud computing' to multiple computers to provide fast, efficient, secure data storage and manipulation that easily scales to thousands of clients. In this Oracle training, students learn how to perform complete and incomplete backup and recovery operations, utilize Oracles new FLEX ASM technology, and utilize Oracles new 12 tuning features such as heat map real time ADDM.

Once you have completed Oracle 12c: Database Administration II Part 1 the next course is this series is Oracle 12c: Database Administration II Part 2. The Oracle 12c: Database Administration II Part 2 course will continue to build your knowledge in backup and recovery operations, Oracle’s flashback technology, and advanced resource management.

Module 00: Course Introduction - Oracle 12c Database Administration II Part 1

Module 01: Installing the Database Software and Creating a Database

• Demo: Installing the Database
• Demo: Creating a Database
• Lab Exercise: Installing the Database Software
• Lab Exercise: Create a Database

Module 02: Multitenant Architecture

• Define Oracle’s Multitenant Architecture
• Root Containers
• Container databases/Pluggable databases

Module 03: Managing Container Databases

• Connect to a container/pluggable databases
• Startup/Shutdown a container database
• Preservation of PDB mode upon restart of CDB
• Lab: Start/Stop a container database
• Lab: Preserve Pluggable open mode
• Lab Demo Solution: Start/Stop a container database
• Lab Demo Solution: Preserve Pluggable open mode

Module 04:  Container Users and Roles

• Create container users
• Create Container Roles
• Lab: Create local users
• Lab: Create local roles
• Lab Demo Solution: Create local users
• Lab Demo Solution: Create local roles

Module 05: Container Profiles and Privileges

• Create Container Profiles
• Grant local privileges
• Lab: Grant local privileges
• Lab Demo Solution: Grant local privileges

Module 06: ASM Overview

• ASM Overview
• ASM Privileges
• ASM Components
• ASM Quiz

Module 07: ASM Instance Management

• ASM Instance Administration
• ASM Instance Parameters
• ASM diskgroups
• ASM Startup and Shutdown

Module 08: FLEX ASM

• FLEX ASM Architecture
• FLEX ASM Overview
• Configuring Flex ASM
• Managing Flex ASM
• Quiz Flex ASM

Module 09: ASM Files and Directories

• Using asmcmd
• ASM Directory Structure
• Creating ASM files
• Creating ASM directories
• Lab: Using asmcmd
• Lab Demo Solution: Using asmcmd

Module 10: Oracle Cloud File System

• Cloud File System Overview
• Cloud File System Components
• Using ACFS with Oracle ASM
• Oracle Cloud File System Quiz

Module 11: Fast Recovery Area

• Configure fast recovery area
• Configure flashback database
• Lab: Archivelog and flashback mode
• Lab Demo Solution: Archivelog and flashback mode

Module 12: Recovery Catalog

• Definition of recovery catalog
• Recovery catalog meta data
• Create the recovery catalog

Modules 13: Recovery Catalog Scripts and Databases

• Create recovery catalog scripts
• List target databases
• Synchronizing the recovery catalog

Module 14: Administering the Recovery Catalog

• Backup the recovery catalog
• Configure recovery catalog settings
• Create a virtual private catalog
• Recovery Catalog Quiz

Module 15: RMAN Backups Part 1

• Backup sets
• Image copies
• Non-compressed backups
• Compressed backups
• Incremental backups
• Backup ASM files
• Backup the Recovery Area
• Lab: Database backup

Module 16: Lab Demo Solution: Database Backup

Module 17: RMAN Backups Part 2

• RMAN encrypted backups
• Oracle Transparent Data Encryption
• Password Encryption
• Dual Mode Encryption
• RMAN Backups Quiz

Module 18: RMAN Critical Recovery

• Recover a critical data file
• Incremental recovery
• Image copy recovery
• Recovery to an alternate location
• Oracle’s Data Recovery Advisor
• Oracle Block Corruption

Module 19: Demo: Recover a non-critical file

Module 20: Diagnosing Backup Issues

• Using Oracles ADR
• Using RMAN DEBUG feature
• Reading Backup messages and Output
• Diagnosing Backups Quiz

Module 21: RMAN Recovery Concepts

• Instance Recovery
• Complete Database Recovery
• Incomplete database Recovery
• Recovery through Resetlogs.
• RMAN Recovery Quiz

Module 22: RMAN Recovery

• Recovery in NoArchivelog mode
• Recovery in Archivelog Mode
• Recovery of ASM disk Groups
• Point in Time recovery
• Table recovery using RMAN
• Lab:  Perform Complete Recovery
• Lab Demo Solution: Demo on Complete Recovery

Module 23: Additional Recovery Concepts

• Parameter file recovery
• Control file Recovery
• Non-critical loss recovery
• Disaster Recovery
• Encrypted backup recovery
• Recovery Concepts Quiz

You need to have equivalent Oracle 9i database experience, taken training in 12c: SQL and PL/SQL and have taken the following courses from GogoTraining:

• Oracle 12c: Database Administration I Part 1
• Oracle 12c: Database Administration I Part 2

In this Oracle database administration course, Part 2 of a two part online training series, you will explore how an Oracle Database applies 'cloud computing' to multiple computers to provide fast, efficient, secure data storage and manipulation that easily scales to thousands of clients. In this Oracle training, students learn how to perform Oracle’s Flashback Technology, Recyclebin, Flashback Data Archives, and how to tune backup and recovery operations and utilize Oracle’s tuning tools such as AWR, SQL tuning Advisor and SQL Access Advisor.

Once you have completed Oracle 12c: Database Administration II Part 2 the next course is this series would be Oracle Enterprise Manager 12c Cloud Control and Oracle APEX.

Module 00: Course Introduction - Oracle 12c: Database Administration II Part 2

Module 01: Installing the Database Software and Creating a Database

• Demo: Installing the Database
• Demo: Creating a Database
• Lab Exercise: Installing the Database Software
• Lab Exercise: Create a Database

Module 02: Flashback Technology

• Flashback Overview
• Flashback Terms
• Flashback Table
• Lab: Perform a Flashback Table
• Lab Demo Solution: Perform a flashback Table

Module 03: Flashback Recyclebin and Query Backout

• Recyclebin Concepts
• Retrieve Objects From the recyclebin
• Define Protected Objects in the recyclebin
• Query Backup Concepts
• Transaction Backout
• Lab: Retrieve a table from the recyclebin
• Lab Demo Solution: Retrieve a Table From the recyclebin
• Lab: Perform Transaction Backout
• Lab Demo Solution: Perform Transaction Backup

Module 04: Flashback Data Archives

• Define Flashback Data Archives
• Manage Flashback Data Archives
• Flashback Data Archives Administration
• Flashback Quiz

Module 05: Flashback Database

• Configure Flashback Database
• Monitor Flashback Database
• Perform Flashback Database
• Lab: Configure Flashback Database
• Lab Demo Solution: Configure Flashback Database

Module 06: Database Duplication Part 1

• Define Database Duplication
• Database Duplicate Techniques

Module 07: Database Duplication Part 2

• More on Database Duplicate Techniques
• Using Cloud Control to Perform Database Duplication
• Using RMAN to Perform Database Duplication
• RMAN Duplicate Quiz

Module 08: Tuning RMAN

• Parallel Backups
• RMAN Multiplexing
• RMAN Performance Bottlenecks
• Recovery and Restore Best Practices
• Tuning RMAN Quiz

Module 09: Overview Oracle Database Architecture

• Oracle Database Memory Structures: Overview
• Automatic Shared Memory Management
• Database Storage Architecture, Logical and Physical Database Structures
• Segments, Extents, and Blocks & SYSTEM and SYSAUX Tablespaces

Module 10: Query Optimizer

• SQL Parsing
• Optimizing Terms
• Optimizing Methods
• Query Plan Generation
• Query Plan Control
• Query Optimizer Quiz

Module 11: Oracle 12c Tuning Features

• Identifying and Using Oracle's Heat Map
• 12c Compression Levels and Types

Module 12: Oracle Tuning Tools Part 1

• Monitoring tools overview
• Enterprise Manager
• Dynamic Performance Views
• Automatic Database Diagnostic Monitor

Module 13: Oracle Tuning Tools Part 2

• Automatic Workload Repository
• SQL Tuning Advisor
• Lab: Using SQL Tuning Advisor

Module 14: Lab Demo Solution: SQL Tuning Advisor

Module 15: Using Automatic Workload Repository

• Defining AWR
• AWR Settings
• Creating AWR Snapshots
• Lab Create AWR Report
• Lab Demo Solution: Create AWR Report

Module 16: Metrics, Alerts, and Thresholds

• Defining Metrics
• Setting Alerts
• Setting Corrective Action Thresholds
• Using Defined Metrics
• Dynamic Views Associated to Metrics and Alerts
• Lab Create Metrics and Alerts
• Lab Demo Solution: Create Metrics and Alerts

Module 17: AWR Baselines

• Creating AWR baselines
• Creating AWR Repeating baselines
• Moving Window Baseline
• Lab Create AWR Baseline
• Lab Demo Solution: AWR Baselines

Module 18: Additional AWR Performance Tools

• Automatic Maintenance Tasks
• Segment Advisor
• Statistics Gathering
• Automatic Tuning Optimizer
• Automatic Database Diagnostic Monitor
• Active Session History (ASH)

Module 19: Optimizer Statistics

• Optimizer Statistics Overview
• Table and Index Statistics
• Statistic Preferences and Gathering
• Locking Statistics, Export/Import Statistics
• Pending and Published Statistics
• Optimizer Hints and Paths
• Cost Base Optimization
• Lab: Reading Query Plan
• Lab Demo Solution: Reading Query Plan

Module 20: SQL Tuning Advisor

• SQL Tuning Advisor: Overview
• SQL Tuning Advisor Limited Mode
• SQL Tuning Advisor Comprehensive mode
• SQL Tuning Profiles
• Lab Create  a SQL Tuning Profile

Module 21: Lab Demo Solution: Create a SQL Tuning Profile

Module 22: SQL Access Advisor

• SQL Access Advisor: Overview
• SQL Access Advisor options
• SQL Access Advisor and SQL Tuning Sets
• SQL Access Advisor and AWR
• Results and Implementation
• Lab Use SQL Access Advisor

Module 23: Lab Demo Solution: Use SQL Access Advisor

Module 24: Automatic SQL Tuning

• Automatic SQL Tuning Maintenance Task
• Automatic Tuning Optimization Implementation(ATO)
• Automatic Tuning Optimization Results
• Enable/Disable Automatic Tuning Optimization
• Lab: Enable ATO
• Lab Demo Solution: Enable ATO

Module 25: SQL Plan Management

• SQL Plan Management and Baseline Overview
• Enable SQL Plan Management
• Loading SQL Plan Baselines into the SGA
• Adaptive Plan Management

Module 26: Shared Pool Tuning

• Shared Pool Architecture
• Shared Pool Parameters
• Library Cache
• Dictionary Cache
• Large Pool Considerations and Contents

Module 27: Tuning the Database Buffer Cache Part 1

• Database Buffer Cache Overview
• Database Buffer Cache Parameters
• Oracle and Dirty Reads and Writes
• Automatic Shared Memory Management (ASMM)

Module 28: Tuning the Database Buffer Cache Part 2

• Buffer Cache Goals and Responsibility
• Buffer Cache Pools
• Buffer CacheTuning Quiz

Module 29: Automatic Memory Management (AMM)

• Oracle's Automatic Memory Management Overview
• Database Autotuned Parameters
• Database Non Autotuned Parameters
• Automatic Memory Management Hints and Sizing suggestions
• AMM versus ASMM
• AMM Quiz

Module 30: Tuning Segment Space Utilization (ASSM)

• Overview of Automatic Segment Space Management
• Defining the DB_BLOCK_SIZE
• Defining DB_nk_CACHE_SIZE parameter
• The DB_BLOCK_SIZE Parameter
• Overview of Table Compression, Block Chaining, and Block Migration
• ASSM Quiz

You need to have equivalent Oracle 9i database experience, taken training in 12c: SQL and PL/SQL and have taken the following courses from GogoTraining:

• Oracle 12c: Database Administration I Part 1
• Oracle 12c: Database Administration I Part 2
• Oracle 12c: Database Administration II Part 1

This Oracle 12c: Enterprise Manager Cloud Control course provides you with a detailed look at one of Oracle’s newest products, 12c Cloud control.  In this course, you will look at the new features within Cloud Control, and learn to identify Cloud Targets, set up notification schedules and help create reports within the Cloud.  You will also learn how to install and configure Oracle Enterprise Manager 12c Cloud Control, configure Cloud systems and services, create notification schedules and incident reports, and discover the new features of 12c Cloud control such as new Cloud targets as well as pluggable and container databases. 

Oracle Enterprise Manager is Oracle’s integrated enterprise IT management product line, which provides a complete, integrated and business-driven enterprise cloud management solution. It creates business value from IT by leveraging the built-in management capabilities of the Oracle stack for traditional and cloud environments, allowing customers to achieve unprecedented efficiency gains while dramatically increasing service levels. It is expected to reduce downtime by up to 90% improve staff productivity by up to 75%, reduce capital expenditures on servers by 20% or more and increase IT agility while lowering the cost of managing IT by an order of magnitude.

Module 00: Course Introduction - Oracle 12c: Enterprise Manager Cloud Control 

Module 01: Cloud Control Overview

• What is Cloud Control?
• Why Use Oracle Cloud Control?
• What are the Cloud Control Components?

Module 02: Oracle 12c Cloud Control Architecture

• Overview of Cloud Architecture
• Install the Cloud
• System Requirements

Module 03: Cloud Control Features

• Define Cloud Objects
• Identify Cloud Features
• Identify Cloud Targets
• Lab Exercise: Install and Configure Cloud Control

Module 04: Lab Exercise Demo Review: Install and Configure Cloud Control

Module 05: Cloud Control Pluggable Databases

• Container Databases
• Pluggable Databases
• Common Database objects within Pluggable databases

Module 06: Cloud Control Targets Part 1 

• Define Cloud Targets
• Define Cloud Groups
• Define Cloud Hosts
• Lab Exercise: Review Web Logic and Cloud Control Settings

Module 07: Lab Exercise Demo Review: Review Web Logic and Cloud Control Settings

Module 08: Cloud Control Targets Part 2

• Cloud System Targets
• Cloud Service Targets
• Configure Grid Infrastructure Software

Module 09: Cloud Database Targets 

• Configure Database targets
• Monitor Database Targets
• Perform Database Availability Tasks
• Perform Database Administrative Tasks
• Lab Exercise: Configure a Cloud Control Database Target

Module 10: Lab Exercise Demo Review: Configure a Cloud Control Database Target

Module 11: Cloud Control Systems/Services

• Define a Cloud System
• Define a Cloud Service
• Establish Metrics for Systems and Services
• Lab Exercise: Create a Cloud Control System

Module 12: Lab Exercise Demo Review: Create a Cloud Control System
 

Module 13: Cloud Control Monitoring 

• Monitor the Cloud Control Environment
• Setting Default Credentials
• Setting Preferences
• Lab Exercise: Set Cloud Control Default Credentials

Module 14: Lab Exercise Demo Review: Set Cloud Control Default Credentials

Module 15: Cloud Control Preferences 

• Define Common Cloud Control Accounts
• Setting Default Preferences
• Set user preferences
• Lab Exercise: Create a new Cloud Control Account

Module 16: Lab Exercise Demo Review: Create a new Cloud Control Account

Module 17: Cloud Control Security 

• Create Cloud Control Users
• Set Cloud Control Privileges
• Establish Cloud Control Roles

Module 18: Cloud Control Notifications

• Create Cloud Control Notifications
• Identify Cloud Control Incidents
• Create Cloud Control Schedules
• Lab Exercise: Define a new Cloud Control Schedule and Incidents

Module 19: Lab Exercise Demo Review: Define a new Cloud Control Schedule and Incidents

Module 20: Cloud Control Monitoring Templates

• Create Cloud Control Monitoring Templates
• Deploy Cloud Control Monitoring Templates
• Set Alerts and Metrics
• Lab Exercise: Create and Deploy a Database Monitoring Template

Module 21: Lab Exercise Demo Review: Create and Deploy a Database Monitoring Template

Module 22: Cloud Control Agent Deployment 

• Define the use of a Cloud Control Agent
• Deploy a Cloud Control Agent
   

Module 23: Cloud Control Reports

• Identify Common Cloud Control Reports
• Compare Configurations using Cloud Control
• Edit existing reports within Cloud Control
   

You need to have experience or have taken the following GogoTraining Courses:

• Oracle 10g/11g Database Administration I Part 1
• Oracle 10g/11g Database Administration I Part 2
• Oracle 10g/11g Database Administration II Part 1
• Oracle 10g/11g Database Administration II Part 2

This Oracle online training course, Part 1 of a two-part series explains Oracle 11g R2 Real Application Clusters (RAC). This course provides a detailed look at installing and configuring Oracle’s RAC environment. Topics covered in part 1 include system requirements, installation, troubleshooting, utilities, Grid infrastructure and architecture.

Once you have completed Oracle 11g R2Real Application Clusters Part 1 the next course in this series is Oracle 11g R2 Real Application Clusters Part 2.  Presented in the Oracle 11g R2 Real Application Clusters Part 2 course is advanced topics including how to administer the RAC environment, adding and deleting nodes from your RAC and configuring for high availability.   Click here to learn more about Oracle 11g R2 Real Application Clusters Part 2.

Module 00: Course Introduction

Module 01: Real Application Cluster Overview
•    What is Real Application Clusters
•    Why use RAC
•    What are RAC requirements

Module 02: RAC System Requirements
•    System Requirements
•    Oracle Requirements
•    Host Requirements

Module 03: Establish User Equivalence
•    Define User Equivalence
•    Establish SSH
•    What is SSH used for?

Module 04: Install Grid Infrastructure Software
•    Define CRS requirements
•    Install CRS
•    Identify CRS components
•    Lab Exercise: Configure ASM

Module 05: Identify Voting Disk and OCR
•    Define the Voting Disk
•    Define the OCR
•    Voting Disk and OCR locations

Module 06: Install ASM and Configure Grid Infrastructure Software
•    Define ASM RAC needs
•    Install ASM for RAC
•    Create ASM Database
•    Configure Grid Infrastructure Software
•    Lab Exercise: Install Grid Infrastructure

Module 07:   Install the Database
•    Install the database software
•    Create the RAC database
•    Identify RAC database specific components
•    Lab Exercise: Install the Database Software

Module 08: Creating the Database
•    Identify DBCA
•    Use DBCA to create a RAC database
•    Lab Exercise: Create Additional Disk Groups
•    Lab Exercise: Create the Cluster Database

Module 09: RAC Listener
•    Define the RAC listener
•    Create the RAC Listener
•    Start the RAC listener

Module 10:  Use SRVCTL
•    Identify the uses of SRVCTL
•    SRVCTL commands
•    Stop and Stop RAC components with SRVCTL
•    Lab Exercise: Use SRVCTL

Module 11: RAC components
•    Identify RAC components
•    Start RAC components
•    Stop RAC components

Module 12: Backup RAC
•    Identify RAC backup needs
•    Configure RAC Backups with RMAN
•    Identify RAC channels with RMAN
•    Lab Exercise: Backup RAC

Module 13: Tuning RAC
•    Identify RAC performance tuning needs
•    Tune the RAC environment
•    Identify RAC specific tuning parameters

Module 14: Identify the RAC Services
•    Identify the location of the RAC software
•    Identify Grid Infrastructure Services

Module 15: Configure TAF
•    What is Transaction Application Failover
•    Configure Transaction Application Failover
•    Define the different TAF components

Module 16: RAC Diagnostics
•    Identifying potential RAC problems
•    Diagnosing RAC issues
•    Correcting RAC problems

Module 17: RAC and Grid
•    Using RAC with GRID
•    Using RAC with Enterprise Manager
•    Deploying RAC with GRID

Module 18: Shared Devices
•    Establishing Shared devices with RAC
•    RAC and the init.ora file
•    RAC and ASM files

Module 19: RAC and Tools
•    Using RAC and ADDM
•    Using RAC and AWR
•    Using RAC with Memory Advisors
•    Lab Exercise: RAC Tools

Module 20: RAC Utilities
•    RAC and cluster verify utility
•    RAC Availability
•    Post Installation tips with RAC

Module 21: RAC Architecture
•    Use CRSCTL
•    Cache Fusion
 

You need to have experience or have taken the following GogoTraining Courses:
•Oracle 10g/11g Database Administration I Part 1
•Oracle 10g/11g Database Administration I Part 2
•Oracle 10g/11g Database Administration II Part 1
•Oracle 10g/11g Database Administration II Part 2

This Oracle 11g R2 Real Application Clusters (RAC) online training course, Part 2 of a two-part series, discusses RAC components, nodes, diagnosing issues, RAC and DataGuard, RAC and Data Broker, ASM,  node management and removing RAC. Advanced topics include how to administer the RAC environment, and how to implement RAC in a virtual environment. 

Module 00: Oracle 11g R2 Real Application Clusters Part 2 - Course Introduction

Module 01: SRVCTL

• Using SRVCTL to Identify Node Status
• Using SRVCTL to Start/Stop Node Components
• Using SRVCTL to Start/Stop the Listeners
• Lab Exercise: Using Srvctl

Module 02: Lab Exercise Demo Review: Using Srvctl

Module 03: RAC Performance

• Identifying RAC Performance Needs
• Determining the Cause of Poor Performance with RAC
• Determining if Additional Nodes are Required
• Lab Exercise: RAC and AWR/ADDM

Module 04: Lab Exercise Demo Review: RAC and AWR/ADDM

Module 05: Adding Nodes 

• Extending your RAC with Command Line Utilities
• Extending your RAC using GRID
• Extending your RAC with Enterprise Manager

Module 06: Reducing RAC Components 

• Determining Reasons to Reduce the RAC
• Removing a RAC node
• Removing RAC with Enterprise Manager
• Removing RAC with GRID
• Lab Exercise: Reducing RAC Components
• Lab Exercise: Extending Database Software to New Nodes
• Lab Exercise: Extending the Database Instance

Module 07: Lab Exercise Demo Review:  Reducing RAC Components

Module 08: Lab Exercise Demo Review:  Extending Database Software to New Nodes

Module 09: Lab Exercise Demo Review:  Extending the Database Instance

Module 10: Diagnosing RAC Issues 

• Understanding the CRS Log Files
• Understanding the Directory Architecture
• Reviewing the RAC Dictionary Views
• Lab Exercise: RAC Diagnosis

Module 11:  Lab Exercise Demo Review: RAC Diagnosis

Module 12:  RAC Parameter Files 

• Identifying RAC Specific Parameters
• Create a Common Parameter File
• Create a Separate Parameter File
• Quiz: RAC Parameter Files

Module 13:  RAC and High Availability

• Define the High Availability Architecture (HAA)
• Identify the DataGuard Components
• Define Uses for HAA

Module 14:  RAC and DataGuard 

• Describe RAC and DataGuard Configurations
• DataGuard and Maximum Performance
• DataGuard and Maximum Protection
• Quiz: RAC and DataGuard

Module 15: Configure DataGuard and RAC

• DataGuard Options
• Configuring DataGuard
• DataGuard and the Command Line

Module 16: DataGuard and Data Broker 

• Configuring DataGuard and Data Broker
• Data Broker and RAC
• DataGuard and RAC
• Quiz: DataGuard and Data Broker

Module 17: RAC and ASM 

• Configure RAC and ASM
• Defining ASM for RAC
• ASM Devices
• Lab Exercise: Using ASM

Module 18: Lab Exercise Demo Review: Using ASM

Module 19: Patching RAC

• Identify RAC Patching Needs
• Perform a Rolling Patch for RAC
• RAC Patch Locations

Module 20: RAC and VMWare

• Identifying the VMWare Components of RAC
• Selecting the VM Operating System
• VMWare and RedHat

Module 21: VMWare Requirements 

• VMWare and VM Server Requirements
• Configuring VM Networking
• Lab Exercise: Configuring VM Networking

Module 22: Lab Exercise Demo Review: Configuring VM Networking

Module 23: Configuring VMWare

• Modifying the VMWare VMX File
• Configuring VMWare Drives

Module 24: Why VMWare and RAC

• Determining the Benefits of VMWare and RAC
• Determining the Risks of VMWare and RAC
• License Concerns with VMware and RAC

Module 25: RAC and Oracle Editions 

• Enterprise Edition and RAC
• Standard Edition and RAC
• RAC and Grid Control

Module 26: Node Management and RAC 

• Starting/Stopping Individual Components of the RAC Node
• Changing the orapwd File in a RAC environment
• RAC and Listeners
• Lab Exercise: Srvctl and SCAN Listeners

Module 27: Lab Exercise Demo Review: Srvctl and SCAN Listeners

Module 28: Removing RAC  

• Removing the Entire RAC Configuration
• Stopping all Components
• Verify the RAC Components are Removed

Module 29: RAC and Applications 

• Identify RAC issues and Applications
• Improving Application Performance by Deploying RAC
• Database Performance and RAC

You need to have experience or have taken the following GogoTraining Courses:

• Oracle 11g R2 Real Application Clusters Part 1
• Oracle 10g/11g Database Administration I Part 1
• Oracle 10g/11g Database Administration I Part 2
• Oracle 10g/11g Database Administration II Part 1
• Oracle 10g/11g Database Administration II Part 2

Oracle 12c Real Application Clusters Part 1: Installation and Configuration training is a two (2) part series.  In Part 1, you will learn how to install and configure Oracle’s 12c RAC environment and install Oracle’s Grid Infrastructure architecture.  Topics covered include:

• Creating ASM diskgroups
• Installing Oracle Database software
• Creating a RAC database
• RAC administration tools such as SRVCTL,CRSCTL, and OCRCHECK
• Oracle’s new FLEX ASM architecture.

Part 2 of this series, Oracle 12c Real Application Clusters Part 2: Performance Tuning, Administration and Backup, completes your Oracle 12c RAC education by covering these topics:

• Backup and tuning the Oracle clustered environment  
• Oracle RAC and RAC One Node
• Application continuity and its application in an Oracle 12c Database and applications
• Extending the RAC and RAC consolidation
• Using SRVCTL, CRSCTL, Sql Advisor, Real Time ADDM and optimizing the Cluster

The Oracle Database with Real Application Clusters (RAC) is and has been a top solution for thousands of customers worldwide. With Oracle Real Application Cluster 12c you now have a more flexible architecture that is able to fulfill numerous requirements using different configurations. It is also capable of providing the infrastructure to host other applications.

Module 00: Course Introduction – Oracle 12c Real Application Clusters Part 1: Installation and Configuration

Module 01: System Requirements

Module 02: Real Application Cluster Overview

• Oracle 12c Cluster
• Flex Cluster
• Cluster Characteristics

Module 03: RAC System Requirements

• System Requirements
• Oracle Requirements
• Oracle RAC Node One
• Host Requirements

Module 04: ASM Overview

• ASM Overview
• ASM Privileges
• ASM Components
• Quiz: ASM

Module 05: Flex ASM

• Flex ASM Architecture
• FLEX ASM Overview
• Configuring Flex ASM
• Managing Flex ASM

Module 06:  ASM Files

• Using ASMCMD
• ASM Directory Structure
• Creating ASM Files
• Creating ASM Directories

Module 07: Lab Exercise and Solution: Using ASMCMD

Module 08: Install Grid Infrastructure Software

• Define Grid Infrastructure Requirements
• Install GI
• Identify GI Components

Module 09: Lab Exercise and Solution: Install and Configure Grid Infrastructure

Module 10: Install Database Software

• Define Database Software Requirements
• Install Database Software
• Configure Database Software

Module 11: Lab Exercise and Solution: Install and Configure Database Software

Module 12: Creating the Database

• Identify DBCA
• Use DBCA to Create a RAC Database

Module 13: Lab Exercise and Solution: Create Additional Disk Groups

Module 14: Lab Exercise and Solution: Create the Cluster Database

Module 15:  Use SRVCTL

• Identify the Uses of SRVCTL
• SRVCTL Commands
• Stop and Stop RAC Components with SRVCTL
• SRVCTL and Pluggable Databases

Module 16: Lab Exercise and Solution: Use SRVCTL

Module 17:  Administer Oracle 12c RAC

• Alert.log Files
• Redo Log Threads
• Undo Tablespace
• RAC Alerts
• RAC Metrics
• Instance Failure LMON, SMON
• Spfile Management

Module 18: Lab Exercise and Solution: Start/Stop RAC Instance and Database

Module 19: Lab Exercise and Solution: Review Alert.log

In order to effectively understand and use the knowledge provided in these courses, you should have a minimum of 1 year Oracle DBA experience, knowledge of Oracle’s database architecture or completed of the following GogoTraining courses:

• Oracle 12c: Database Administration I Part 1
• Oracle 12c: Database Administration I Part 2
• Oracle 12c: Database Administration II Part 1
• Oracle 12c: Database Administration II Part 2

In this Oracle 12c Real Application Clusters Part 2: Performance Tuning, Administration and Backup course, you will learn how to backup and tune the Oracle clustered environment.  In order to be prepared for this course, you’ll need to have completed Oracle 12c Real Application Clusters Part 1: Installation and Configuration.

In this course you will learn:

• The differences between Oracle RAC and RAC One Node.  
• Application continuity and how it works and applies in an Oracle 12c Database and applications
• RAC and RAC consolidation
• SRVCTL, CRSCTL, Sql Advisor
• Real Time ADDM 
• Cluster optimization

Oracle’s Database with Real Application Clusters (RAC) is and has been a top solution for thousands of customers worldwide. With Oracle’s Real Application Cluster 12c you now have a more flexible architecture that is able to fulfill numerous requirements using different configurations. It is also capable of providing the infrastructure to host other applications.

Module 00: Course Introduction – Oracle 12c Real Application Clusters Part 2: Installation and Configuration

Module 01: System Requirements

Module 02:  Backup Oracle 12c

• Identify RAC Backup Needs
• Configure RAC Backups with RMAN
• Identify RAC Channels with RMAN

Module 03: Lab Exercise and Solution: Configure RAC Archivelog

Module 04: Lab Exercise and Solution: Backup Database

Module 05: Tuning RAC

• Identify RAC Performance Tuning Needs
• Tune the RAC Environment
• Identify RAC Specific Tuning Parameters

Module 06: Lab Exercise and Solution: Run AWR Reports

Module 07: Diagnosis RAC Issues  

• Identify CRS Log Files
• Understand the Directory Structure
• Review RAC Dictionary Views

Module 08: Lab Exercise and Solution: Diagnosis RAC

Module 09: Using CRSCTL/OCRCHECK

• Overview of Cache Fusion
• Oracle 12c New Features to Cache Fusion
• Overview of CRSCTL

Module 10: Lab Exercise and Solution: Use CRSCTL/OCRCHECK

Module 11: High Availability of Services

• Define Oracle 12c RAC Services
• Policy Managed Databases
• Admin Managed Databases
• Load Balancing Client Side/Server Side
• Fast Application Notification

Module 12: Lab Exercise and Solution: Create and Use Services Container/Pluggable

Module 13: RAC Node One

• What is Oracle’s RAC Node One
• Converting a RAC Database to RAC Node One
• Converting a RAC Node One Database to RAC Database
• Benefits of RAC Node One
• Quiz: RAC Node One 

Module 14: Node Management

• Reasons for Extending RAC
• Extending the RAC
• Reasons for Reducing the RAC
• Reducing the RAC

Module 15: Lab Exercise and Solution: Reducing the RAC

Module 16: Lab Exercise and Solution: Extending the RAC

Module 17: Application Continuity (AC)

• What is Application Continuity?
• How is AC Configured?
• Benefits of AC
• AC Requirements
• AC Restrictions
• Quiz: Application Continuity

Module 18: Where Do You Go From Here? 

In order to effectively understand and use the knowledge provided in these courses, you should have a minimum of 1 year Oracle DBA experience, knowledge of Oracle’s database architecture or completed of the following GogoTraining courses:

• Oracle 12c Database Administration I Part 1
• Oracle 12c Database Administration I Part 2
• Oracle 12c Database Administration II Part 1
• Oracle 12c Database Administration II Part 2
• Oracle 12c: Real Application Clusters Installation and Configuration

This Oracle 11g Fusion Middleware Administration course covers the management and configuration of the basic components of Oracle Fusion Middleware. Oracle Fusion Middleware is the leading business innovation platform for the enterprise and the cloud. It enables enterprises to create and run agile, intelligent business applications while maximizing IT efficiency through full utilization of modern hardware and software architectures. In this course, we will discuss the security, applications, ports, servers and agents. You will also learn about deploying and monitoring Oracle Fusion Middleware (OFM) and diagnosing problems in OFM and managing diagnostic data including log files.

Oracle Fusion Middleware is the only middleware available from any vendor that provides a complete, open, and integrated approach across social, mobile, and cloud technologies. It offers the efficiency of working with a single, strategic partner for all of your middleware requirements, as well as the cost effectiveness of certified integrations with Oracle Database, Oracle Applications, and Oracle Engineered Systems. With best-in-class offerings across every product line, Oracle Fusion Middleware can enable you to maximize the processes and applications that drive your business today and provide a foundation for innovation in the future.

Module 00: Oracle Fusion Middleware Administration - Course Introduction

Module 01: Introduction and Overview of Oracle Fusion Middleware (OFM) 

• OFM Components
• Model View Controller (MVC) Design
• Oracle Application Development Framework (ADF)

Module 02: ADF Functionality

• ADF Faces
• ADF Views
• ADF Controller

Module 03: Starting a Project in JDeveloper

• ADF Business Components
• JDeveloper Wizards
• Building the Business Model
• Exercise: Installing JDeveloper

Module 04: Starting and Stopping Oracle Fusion Middleware Components

• Oracle WebLogic Server Instances
• Administration Servers
• Managed Servers

Module 05: Starting and Stopping Oracle Fusion Oracle Fusion Middleware Agents

• Components
• Oracle Managed Agents
• Applications and Environments
• Special Topics

Module 06: Managing the OFM Listening Ports

• Viewing Port Numbers
• Changing Port Numbers
• Viewing Port Usage Pages

Module 07:  Managing the Oracle Web Cache 

• Using the Fusion Middleware Control
• Changing Oracle Process Manager and Notification Server (OPMN) Ports
• Changing Oracle Portal Ports

Module 08: Managing Oracle Metadata Ports

• Changing the Repository Listener Port
• Changing the Oracle Internet Directory Port
• Changing the System Data Source
• Updating Oracle Single Sign-on
• Exercise: Starting and Stopping OFM Components and Port Connections

Module 09: Benefits of Security 

• Why use security in OFM?
• Security Components and Tools
• Security Management using Keystores

Module 10: Establishing Security 

• Configuring Security Tools
• Configuring Security in the Web Cache
• Configuring Security for the Middle Tier

Module 11: Enabling Security in OSM Applications 

• SSL in the Data Tier
• SSL in the Database
• SSL in Oracle Forms
• SSL in Oracle Portal
• SSL Best Practices for Administrators
• Exercise: Configuring Secure Socket Layer (SSL)

Module 12: Configuring the SSL Automation Tool 

• Benefits of the Tool
• Variables of the Tool
• Components Effected by the Tool

Module 13: Using the Certificate Authority

• Generating the CA Certificate
• Configuring a Component Server
• Configuring a Client
• Exercise: Using the SSL Automation Tool

Module 14: Managing KeyStores 

• Overview of KeyStore Management
• Oracle Wallet as a KeyStore
• KeyStore Management Tools

Module 15: Using Java KeyStores 

• JKS Management
• JKS Lifecycle
• Common JKS Operations

Module 16: Managing Certificates

• Common Certificate Operations
• Generating a Certificate
• Importing a Certificate
• Certificates and KeyStores
• Exercise: Managing KeyStores, Wallets and Certificates

Module 17: The Process of Deployment 

• Deployable Applications
• Data Source Management
• Configuring the Data Storage
• Java Naming and Directory Interface (JNDI)

Module 18: Deploying and Un-deploying Applications

• Planning the Deployment Process
• Automating the Deployment Process
• Configuring the Deployment Process

Module 19: Automating Application Deployment 

• Managing Deployment Plans,
• Common Deployment Tasks
• Managing Metadata Storage Attributes
• Exercise: Understanding the Deployment Process

Module 20: Monitoring System Components in OFM

• What are system components?
• Monitoring Administration Servers
• Monitoring Clusters
• Monitoring Domains

Module 21: Monitoring Non-System Applications in OFM

• What are the non-system applications?
• Monitoring Application Developer Framework (ADF) Applications
• Monitoring Service Oriented Architecture (SOA) Composite Applications
• Monitoring the Performance of OFM
• Viewing the Topology of OFM
• Exercise: Monitoring Oracle Fusion Middleware

Module 22: Searching Log Files 

• Content of Log Files
• Viewing Log Files
• Filtering Log Files

Module 23: Working with Log Files 

• Downloading Log Files
• Log File Locations
• Configuring Log Files

Module 24: Configuring Log Files 

• Configuring Log File Rotation
• Setting Log File Levels
• Exercise: Managing Log Files and Diagnostic Data

Module 25: Understanding the Diagnostic Framework 

• Terminology
• Elements      
• Commands
• How it Works

Module 26: Using the Diagnostic Framework

• Configuration
• Best Practices
• Viewing Diagnostic Dumps
• Executing Diagnostic Dumps
• Reporting to Oracle Support
• Exercise: Oracle Fusion Middleware Administration –Diagnosing Problems

Familiarity with Java or:

• Introduction to Programming in Java 5 Part 1
• Introduction to Programming in Java Part 2

and:

• Oracle 10g/11g Database Administration I Part 1
• Oracle 10g/11g Database Administration I Part 2
• Oracle 10g/11g Database Administration II Part 1
• Oracle 10g/11g Database Administration II Part 2

This Oracle online training course teaches you how to address Oracle Backup and Recovery issues. You will learn how to perform user managed backups and recoveries as well as Oracle managed backup and recoveries(RMAN).

Module 00: Oracle Backup and Recovery Online Training - Course Introduction

Module 01: Backup methods

• User Managed Backups
• Oracle Managed Backups Types of Failures
• Types of Recoveries

Module 02: Recovery Configuration

• Configuring the Database for Archivelog
• Configuring the Database for No-Archivelog
• Configuring the Flash Recovery Area

Module 03: Configuring RMAN

• RMAN Default Settings
• Command Line
• Enterprise Manager

Module 04: RMAN Backups

• Full RMAN Backup
• Compressed Backups
• Uncompressed Backups
• Partial RMAN Backup
• Incremental Backups
• Change Tracking File

Module 05: Managing Backups

• Backup Reports
• Backup Maintenance
• Backup Catalog
• Backup Crosscheck

Module 06: RMAN Complete Recovery

• RMAN Complete Recovery
• Database Recovery
• Tablespace Recovery
• Datafile Recovery

Module 07: RMAN In-Complete Recovery

• Time Based Recovery
• Sequence Based Recovery
• SCN Based Recovery

Module 08: Non-Database File Recovery

• Spfile Recovery
• Controlfile Recovery
• Incremental Recovery
• Flash Recovery Area for a Fast Recovery

Module 09: User Managed Backup

• Configuring User Managed Backups
• Perform a User Managed Backup

Module 10: User Managed Recovery

• User Managed Complete Recovery
• User Managed Incomplete Recovery

Module 11: Configuring Flashback

• Flashback Query
• Flashback Drop
• Flashback Database

Module 12: Performing Flashback Recoveries

• Flashback Query
• Flashback Drop
• Flashback Transaction Query
• Flashback Versions Query

Module 13: Performing Flashback Database

• Determining the FRA Size
• FRA Retention
• Performing a Flashback Database

Module 14: RMAN Duplicate Command

• Setting up for a Duplicate Database
• Creating the Duplicate spfiles
• Performing the Duplicate Command.

Module 15: RMAN Recovery Catalog

• Configuring for the Recovery Catalog
• Creating the Recovery Catalog

Module 16: Backups with the Recovery Catalog

• Registering the Database with the Recovery Catalog
• Performing Backups with the Recovery Catalog

Module17: Recoveries with the Recovery Catalog

• Identifying Type of Recoveries with the Recovery Catalog
• Performing Recoveries with the Recovery Catalog

Module 18: Recovery Catalog Maintenance

• Registering Additional Databases with the Recovery Catalog
• Cataloging Additional Backups with the Recovery Catalog
• Recovery Catalog Scripts

Module 19: DataPump

• Configuring Datapump
• DataPump Exports
• DataPump Imports

Module 20: Tuning RMAN

• RMAN Sessions
• RMAN Channels
• RMAN Job Progress

Module 21: Oracle Backup and Recovery Online Training - Course Summary

You need to have equivalent experience or have taken the following GogoTraining courses:

• Oracle 10g/11g Database Administration I Part 1
• Oracle 10g/11g Database Administration I Part 2

This Oracle online training course will describe the components of Oracles’ Data Guard tool. This training covers the differences between the physical and logical databases and the overall architecture of Data Guard. You will also learn how to use Oracle’s Data Guard with Grid Control. This course uses Enterprise Manager 1g Grid Control (10.2.0.x) and Grid Release 10.2.0.2.1.

In order to take this course you need to have taken Oracle 10g/11g Database Administration I Part 1 and Part 2 and Oracle 10g/11g Database Administration II Part 1 and Part 2 and have six months database administrator experience.

Once you have completed the  Oracle Data Guard Part 1 the next course in this series is Oracle Data Guard Part 2.  Oracle Data Guard Part 2 will continue to build your skills through learning how to backup an Oracle data guard environment, implementing a failover and switchover, and utilizing data guard with flashback database technology as well as RMAN commands. Click here to learn more about Oracle Data Guard Part 2.

Download the course outline.

Module 00: Oracle Data Guard Part 1 Online Training - Course Introduction

Module 01: Data Guard Components

• Identify what is Oracles' Data Guard
• Describe the differences between a physical and logical standby
• Quiz

Module 02: Data Guard Transport Method

• Redo Transport Services
• Apply Services
• Role Management Services

Module 03: Differences between Failover and Switchover

• Database Failover
• Database Switchover

Module 04: Demo: Failover and Switchover

Module 05: Data Guard Framework

• Data Guard Broker
• Standby Database
• Oracles Grid
• Quiz

Module 06: Data Guard Broker Configuration

• Using Data Guard Broker
• Non Data Guard Broker

Module 07: Defining Gap Resolution

• Resolving Gaps with Redo Apply
• Resolving Gaps with Archive Apply

Module 08: Defining Protection Modes

• Maximum Protection
• Maximum Availability
• Maximum Performance
• Quiz

Module 09: Operating System Requirements

• CPU Requirements
• Memory Requirements
• Operating System Binaries
• Oracle Binaries

Module 10: Manually Creating a Physical Standby Database

• Create a Physical Standby database
• Modify initialization parameters
• Verify the Standby database is receiving logs

Module 11: Physical Standby Database and Grid

• Creating a Standby database with Grid
• Verify the Standby Databases
• View the configuration Status
• Quiz

Module 12: Demo: Creating a Physical Standby with Grid

Module 13: Logical Standby Database

• Manually Create a Logical Standby Database
• Create the Standby Database using SQL/RMAN
• Verify the Standby database is functional

Module 14: Using Grid to Create a Logical Database

• Set up the Logical Standby database
• Configure the Logical Standby Database
• Create the Standby Database with Grid
• Quiz

Module 15: Demo: Creating a Logical Standby with Grid

You need to have six months database administrator experience or have taken the following GogoTraining courses:

• Oracle 10g/11g Database Administration I Part 1
• Oracle 10g/11g Database Administration I Part 2
• Oracle 10g/11g Database Administration II Part 1
• Oracle 10g/11g Database Administration II Part 2

This Oracle online training course will explain how to backup an Oracle Data Guard environment. This training also discusses how to implement failover and switchover. Additionally, we will utilize data guard with flashback database technology as well as RMAN commands. This course uses Enterprise Manager 1g Grid Control (10.2.0.x) and Grid Release 10.2.0.2.1.

In order to take this course you need to have taken Oracle Data Guard Part 1, Oracle 10g/11g Database Administration I Part 1 and Part 2 and Oracle 10g/11g Database Administration II Part 1 and Part 2 and have six months database administrator experience.

Download the course outline.

Module 00: Oracle Data Guard Part 2 Online Training - Course Introduction

Module 01: Backup Methods and Data Guard

• Flashback database and Data Guard
• RMAN commands and Data Guard
• SQL Commands and Data Guard
• Quiz

Module 02: Flashback Database and Data Guard

• Using Flashback database instead of Apply Delay
• Recover the database from a prior point in time
• Use Real-time Apply
• Quiz

Module 03: Demo: Implementing Flashback Database

Module 04: Backing up in a Data Guard Environment

• Oracle Managed Backups
• User Managed Backups
• Recovery in a Data Guard Environment
• Quiz

Module 05: Demo: Backing up a Data Guard Database

Module 06: Data Guard and Failover

• Define Failover
• Define Failover versus Switchover
• Perform a manual Failover

Module 07: Grid and Failover

• Identify Failover needs
• Perform a Failover using Grid

Module 08: Data Guard and Switch Over

• Define Switchover
• Define Switchover versus Failover
• Perform a manual Switchover

Module 09: Grid and Switch Over

• Identify Switchover requirements
• Perform a Switchover using Grid

Module 10: Define Fast Start Failover

• Configure Fast Start Failover
• Monitor Fast Start Failover
• Re-instating the database
• Quiz

Module 11: Failover Client

• Configure automatic failover for OCI Clients
• Configure automatic failover for JDBC clients
• Design database mirroring
• Quiz

Module 12: Define a Snapshot Standby Database

• Convert a physical Standby Database to a Snapshot DB
• Using a Snapshot Database
• Monitoring the Snapshot Database

Module 13: Oracle Active Data Guard

• Define Oracle Active Data Guard
• Implement Active Data Guard

Module 14: Managing Data Guard Components

• Data Guard Monitoring Tools
• Using Grid and Data Guard
• View Dynamic performance views

Module 15: Demo: Monitoring Data Guard Components

Module 16: Upgrading databases with Data Guard

• Use SQL apply to upgrade
• Use Physical Standby for rolling upgrades

You need to have six months database administrator experience and have taken Oracle Data Guard Part 1 or have taken the following GogoTraining courses:

• Oracle 10g/11g Database Administration I Part 1
• Oracle 10g/11g Database Administration I Part 2
• Oracle 10g/11g Database Administration II Part 1
• Oracle 10g/11g Database Administration II Part 2
• Oracle Data Guard Part 1

In this Oracle online training course, you will learn about Oracle's Grid control architecture. During this training you will learn in detail how to install and configure Oracle's Grid control, how to deploy grid agents, users and groups. You will also learn how to configure grid targets.

Once you have completed Oracle Grid Control Part 1 the next course in this series is Oracle Grid Control Part 2. In Oracle Grid Control Part 2 you will enhance your knowledge by configuring Grid services, beacons, set up Grid patching, upgrading to Grid 10.2.0.5 and monitoring grid. Click here to learn more about Oracle Grid Control Part 2.

Module 00: Oracle Grid Control Part 1 Online Training - Course Introduction

Module 01: Describing Oracle's Grid Architecture

• Oracle Management Service
• Oracle Management Repository
• Oracle Management Agent

Module 02: Defining Grid Targets

• Database Targets
• Host Targets
• Application Server Targets
• Web Server Targets
• Third Party Targets

Module 03: Understanding Grid's Home Page

• Reading Grid's Home Page
• Targets
• Jobs
• Alerts

Module 04: Installing Oracle's Grid Control

• Oracle's Universal Installer
• Oracle Management Service
• Oracle Management Repository
• Oracle Management Agent
• Accessing Grid Control
• Exercise: Installing Grid Control

Module 05: Monitoring Grid Targets

• Defining Metrics
• Setting Metrics
• User Defined Metrics

Module 06: Host Target

• Configuring the Host Target
• Administering the Host Target
• Maintaining the Host Target

Module 07: Database Target

• Configuring the Database Target
• Administering the Database Target
• Maintaining the Database Target

Module 08: Application Server/Web Server Target

• Configuring the App/Web Server Target
• Administering the App/Web Server Target
• Maintaining the App/Web Server Target

Module 09: Defining Grid Users

• Creating Grid Administrators
• Creating Grid Roles
• Creating Grid Privileges
• Exercise: Defining Grid Users

Module 10: Defining Notification Rules/Methods

• Creating Notification Methods
• Defining Notification Rules
• Exercise: Define Notification Rules

Module 11: Defining Notification Schedules

• Creating a Grid notification schedule

Module 12: Monitoring the Grid

• Monitoring the Grid Agent
• Monitoring Grid performance

Module 13: Creating Templates

• Understanding Templates
• Creating Templates
• Deploying Templates
• Exercise: Create Templates

Module 14: Grid Groups

• Creating Grid Groups
• Maintaining Grid Groups
• Assign Privileges to a Group
• Group Dashboard
• Exercise: Create Grid Groups

Module 15: Grid Jobs

• Creating Grid Jobs
• Creating Library Jobs
• Exercise: Create Grid Jobs

Module 16: Grid Deployments

• Cloning Database
• Cloning Home
• Agent Deploy

Module 17: Grid Policy Violations

• Understand Grid Policy violations
• Enable/Disable Policy Violations

Module 18: Grid Blackouts

• Defining a blackout
• Creating a blackout
• Terminating a blackout

Module 19: Patching Grid

• Understanding the Patch Cache
• Creating the Patch Cache

Module 20: Upgrading Grid

• Upgrading Grid to 10.2.0.4
• Upgrade OMS
• Upgrade the Agents

Module 21: Relocating Grid

• Moving the OMS/OMR
• Re-connecting the Agents to the new OMS

You need to have equivalent experience or have taken the following GogoTraining courses:

• Oracle 10g/11g Database Administration I Part 1
• Oracle 10g/11g Database Administration I Part 2
• Oracle 10g/11g Database Administration II Part 1
• Oracle 10g/11g Database Administration II Part 2

This Oracle online training course explains Oracle's Grid control architecture. You are provided with a detailed look on installing and configuring Oracle's Grid control. At the end of this course you will have a well rounded knowledge of services, beacons, grip patching and preferences, and reporting.

In order to take this course you need to have take Oracle Grid Control Part 1 and have experience in Oracle database administration.  Click here to learn more about Oracle Database Administration.

Module 00: Oracle Grid Control Part 2 Online Training - Course Introduction

Module 01: Defining a Service

• Service Architecture
• Definition of a service

Module 02: Creating a Service

• Generic Service
• Aggregate Service

Module 03: Creating a Service and Forms Application

• OCS Service
• Identity Management Service
• Forms Applications

Module 04: Service Beacons

• Defining a Beacon
• Creating a Beacon
• Applying a Beacon to a Service

Module 05: Types of Beacons

• Testing a Beacon
• Service Beacon
• System Beacons

Module 06: Defining a System

• Definition of a System
• System Components
• Types of Systems

Module 07: Grid Patching

• Defining the Patch Cache
• Registering Grid with Metalink

Module 08: Monitoring Grid Components

• Monitoring the OMS
• Monitoring the OMR
• Monitoring Agents

Module 09: Enterprise Manager Configuration

• Roles/Administers
• Notification Methods
• Email Customization

Module 10: Grid Configuration

• Registration Passwords
• Management Pack Access
• Management Plugins

Module 11: Grid Preferences

• Preferred Credentials
• Target Subtabs

Module 12: Web Applications

• Defining Web Applications
• Monitoring Web Applications

Module 13: All Targets

• Monitoring All Targets
• Configure All Targets

Module 14: Monitoring Grid Targets

• Defining Metrics
• Setting Metrics
• User Defined Metrics

Module 15: Reports

• Oracle Supplied Reports
• User Defined Reports
• Report Configuration

Module 16: Report Creation

• Creating Reports
• Modifying Reports
• Scheduling Reports

Module 17: Report Access

• Assigning Reports
• Emailing Reports
• Generic Access to Reports

Module 18: Agent Deployment

• Agent Push
• Agent Pull

Module 19: Patching

• Patching Linux
• Patching the Agent

Module 20: Upgrading Grid

• Upgrading Grid to 10.2.0.5
• Upgrade OMS
• Upgrade the OMR

You need to have equivalent experience and have taken Oracle Grid Control Part 1 or have taken the following GogoTraining courses:

• Oracle 10g/11g Database Administration I Part 1
• Oracle 10g/11g Database Administration I Part 2
• Oracle 10g/11g Database Administration II Part 1
• Oracle 10g/11g Database Administration II Part 2
• Oracle Grid Control Part 1

This Oracle online training course will describe the components of Oracles’ Application Express tool V3.  Oracle Application Express covers the methods used within APEX to quickly and efficiently develop web based applications. This training covers how to install and configure APEX, build an application, create forms, reports, buttons, and templates, work with session states, page processing, navigation and utilities and handle security.

Module 00: Oracle Application Express Online Training - Course Introduction

Module 01: Introduction to Application Express

• Application Express Concepts
• Application Express Architecture
• Create Workspace and Workspace Admin

Module 02: Using SQL Workshop

• Creating Objects
• Processing Ad Hoc SQL Statements
• Managing SQL Scripts
• Running Queries
• Lab: Using SQL Workshop

Module 03: Building a Application

• Components of an application
• Creating an application
• Creating an application from a spreadsheet
• Lab: Building an Application

Module 04: Creating Reports

• Report Types
• Interactive Reports
• Report Wizards
• Customizing Reports
• Lab: Creating Reports

Module 05: Creating Forms

• Form types
• Creating a form on a table
• Tabular forms
• Master detail form
• Form attributes
• Lab: Creating Forms

Module 06: Page and Regions

• Page definitions
• Editing Page attributes
• Region Attributes
• Comments

Module 07: Items and Buttons

• Creating Items
• Creating Buttons

Module 08: Session State and Debugging

• Implementing Session State
• Clearing Session State
• Reviewing Session State

Module 09: Page Processing

• Page rendering and Page processing
• Computations for the applications
• Validating input data
• Process data

Module 10: Shared Components

• List of Values for an applications
• Creating Trees
• Shared component reports
• User Defaults

Module 11: Dynamic Content

• Filtering reports
• Creating charts from a wizard
• Creating a calendar

Module 12: Themes

• Explaining Themes
• Switching Themes
• Custom Themes
• Lab: Working with Themes

Module 13: Templates

• Creating a template
• Modifying a template
• Cascading style sheet

Module 14: APEX Admin

• Managing Users
• Requesting Schema and storage
• Clearing Session State
• Lab: Using Admin APEX

Module 15: Implementing Security

• Authentication versus Authorization
• Authentication Scheme
• Access Control
• Session State Protection

Module 16: Deploying Applications

• Define supporting objects
• Exporting the application
• Importing the application
• Installing supporting objects

Module 17: Utilities

• Importing and exporting data
• Generate DDL
• View objects
• Monitor the database

You need to have six months of development experience or have taken the following GogoTraining courses:

• Oracle 10g/11g Database Administration I Part 1
• Oracle 10g/11g Database Administration I Part 2