Oracle Career Path Courses:

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.

View all course details Enroll Now
Video Title
Length
00: Oracle 11g/12c: Introduction to SQL Online Training - Course Introduction
6 min
01: Writing SQL SELECT Statements
18 min
02: Writing SQL SELECT Statements Demo
15 min
03: Restricting Data
16 min
04: Restricting Data Demo
15 min
05: Sorting Data
13 min
06: Sorting Data Demo
13 min
07: Displaying Data from Multiple Tables
21 min
08: Displaying Data from Multiple Tables Demo
20 min
09: Character Row Functions
12 min
10: Character Row Functions Demo
15 min
11: Numeric Row Functions
11 min
12: Numeric Row Functions Demos
9 min
13: Date/Time Row Functions
8 min
14: Date/Time Row Functions Demo
17 min
15: Miscellaneous Row Functions
17 min
16: Miscellaneous Row Functions Demo
18 min
17: Aggregating Data Using Group Functions
13 min
18: Aggregating Data Using Group Functions Demo
18 min
19: Extensions to the GROUP BY Clause
12 min
20: Extensions to the GROUP BY Clause Demo
11 min
21: Manipulating Data I
14 min
22: Manipulating Data I Demo
19 min
23: Manipulating Data II
12 min
24: Manipulating Data II Demo
15 min
25: 12c New Features
21 min
Course Survey
View all course details

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
View all course details

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

View all course details

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.

View all course details Enroll Now
Video Title
Length
00: Oracle 11g/12c: Advanced SQL Online Training - Course Introduction
8 min
01: Using the Set Operators
19 min
02: Using the Set Operators Demo
17 min
03: Flashback Query
19 min
04: Flashback Query Demo
18 min
05: Using Subqueries
18 min
06: Using Subqueries Demo
20 min
07: Hierarchical Retrieval
17 min
08: Hierarchical Retrieval Demo
16 min
09: Using the Data Dictionary Views
13 min
10: Using the Data Dictionary Views Demo
18 min
11: Creating Database Objects I (Views)
14 min
12: Creating Database Objects I (Views) Demos
15 min
13: Creating Database Objects II (Sequences)
18 min
14: Creating Database Objects II (Sequences) Demo
14 min
15: Creating Database Objects III (Synonyms)
16 min
16: Creating Database Objects III (Synonyms) Demo
14 min
17: Creating Database Objects IV (Tables)
24 min
18: Creating Database Objects IV (Tables) Demo
19 min
19: Creating Database Objects V (Indexes)
16 min
20: Creating Database Objects V (Indexes) Demo
14 min
21: Creating Database Objects VI (Constraints)
14 min
22: Creating Database Objects VI (Constraints) Demo
12 min
23: Regular Expression Support
12 min
24: Regular Expression Support Demo
10 min
25: Advanced Oracle: 12c New Features
28 min
Course Survey
View all course details

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
View all course details

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.

View all course details Enroll Now
Video Title
Length
00: Oracle 11g PL/SQL Programming Part 1 Online Training - Course Introduction
6 min
01: PL/SQL Overview Part 1
22 min
02: PL/SQL Overview Part 2
30 min
03: I/O Within PL/SQL and Overview of Sample Environment
23 min
04: Datatypes and Scalar Variables
25 min
05: Composite Variables
22 min
06: Datatypes and Scalar Variables Exercise and Exercise Review
7 min
07: SQL Statements in PL/SQL
15 min
08: DML Commands and Transaction Processing
22 min
09: DML Commands and Transaction Processing Exercise and Exercise Review
6 min
10: IF and CASE Statements
22 min
11: Loops and Labels
29 min
12: Exception Handling
25 min
13: Pre-Defined Exceptions
18 min
14: Using SQL code, SQLERRM and User-defined Exceptions
15 min
15: User-Defined Exceptions Exercise and Exercise Review
12 min
16: Exception Propagation and Displaying Errors
16 min
17: Exception Propagation and Displaying Errors Exercise and Exercise Review
10 min
Course Survey
View all course details

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

 

 

 

 

 

 

 

View all course details

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.

View all course details Enroll Now
Video Title
Length
00: Oracle 11g PL/SQL Programming Part 2 Online Training - Course Introduction
5 min
01: Cursor Basics
21 min
02: Cursor Basics Exercise and Exercise Review
4 min
03: Advanced Cursor Topics
27 min
04: Advanced Curser Topics Part 2
26 min
05: Stored Procedures and Functions Basics
31 min
06: Stored Procedures and Functions Basics Exercise and Exercise Review
8 min
07: Passing Parameters to Stored Procedures and Functions
26 min
08: Passing Parameters to Stored Procedures and Functions Exercise and Exercise Review
13 min
09: Dependencies and Security
28 min
10: Stored Procedure and Functions Exercise and Exercise Review
17 min
11: Trigger Basics
26 min
12: Trigger Basics Part 2
20 min
13: Advanced Trigger Concepts
25 min
14: Triggers Exercise and Exercise Review
30 min
15: PL/SQL Packages
21 min
16: PL/SQL Packages Part 2
12 min
17: Packages Exercise and Exercise Review
19 min
Course Survey
View all course details

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?
View all course details

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.

View all course details Enroll Now
Video Title
Length
00: Course Introduction
6 min
01: Architectural Components Part 1
22 min
02: Architectural Components Part 2
21 min
03: Administration and Installation Tools for Oracle Server Part 1
15 min
04: Administration and Installation Tools for Oracle Server Part 2
12 min
05: Database Architecture and Creation Part 1
35 min
06: Database Architecture and Creation Part 2
23 min
07: Database Interfaces
9 min
08: Database Control Part 1
21 min
09: Database Control Part 2
18 min
10: Storage Structures
10 min
11: User Management Part 1
24 min
12: User Management Part 2
17 min
13: Schema Object Management Part 1
18 min
14: Schema Object Management Part 2
14 min
15: Data Management using SQL*Loader Part 1
12 min
16: Data Management using SQL*Loader Part 2
14 min
17: Data Management Using the Data Pump
19 min
18: PL/SQL Overview
18 min
19: PL/SQL Exceptions
7 min
20: Database Security Management Part 1
15 min
21: Database Security Management Part 2
15 min
22: Database Security Management Part 3
23 min
23: Oracle Net Services Part 1
20 min
24: Oracle Net Services Part 2
6 min
Course Survey
View all course details
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
View all course details

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

View all course details

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.

View all course details Enroll Now
Video Title
Length
00: Course Introduction
7 min
01: Oracle Shared Server
8 min
02: Configuration, Tuning and Monitoring
18 min
03: Database Performance Monitoring, Part 1
25 min
04: Database Performance Monitoring, Part 2
12 min
05: Database Maintenance Techniques
16 min
06: Using Advisors
18 min
07: Using the Automatic Database Diagnostic Monitor (ADDM)
22 min
08: Using the Workload Repository
11 min
09: Configuring Database Undo Management
14 min
10: Administering Database Undo Management
23 min
11: Detecting Database Locking Conflicts
7 min
12: Resolving Database Locking Conflicts
7 min
13: Database Backup and Recovery Concepts
13 min
14: Data and Log Files
12 min
15: Writer and Archiver Processes
24 min
16: NOARCHIVELOG and ARCHIVELOG Mode
7 min
17: Constituent Elements
10 min
18: Database Backups
20 min
19: User-Managed Backups and Individual Tablespaces
24 min
20: Server-Managed Backups
12 min
21: Types of Database Recovery
26 min
22: Using Flashback
15 min
23: Incarnations and Log Sequence Numbers
12 min
Course Survey
View all course details

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

View all course details

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

View all course details

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.

View all course details Enroll Now
Video Title
Length
00: Course Introduction
7 min
01: Introduction to Oracle
13 min
02: Database Management Products
19 min
03: Database Creation Assistant
20 min
04: Oracle Architecture/ASM
23 min
05: ASM Disks/DiskGroups
16 min
06: Managing ASM Part 1
15 min
07: Managing ASM Part 2
13 min
08: Database Recovery
18 min
09: Flash Recovery Area
12 min
10: Recovery Catalog
17 min
11: Recovery Catalog Scripts and Databases
18 min
12: Administering the Recovery Catalog
18 min
13: RMAN Backups
21 min
14: RMAN Recovery
18 min
15: RMAN Critical Recovery
15 min
16: RMAN Incomplete Recovery
15 min
17: User Managed Recovery
23 min
18: Tuning RMAN
15 min
19: Additional RMAN Features
20 min
20: Recyclebin
10 min
21: Flashback Query
14 min
22: Flashback Data Archives
11 min
23: Flashback Database
14 min
24: Course Summary
6 min
Course Survey
View all course details

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

View all course details

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.

View all course details Enroll Now
Video Title
Length
00: Course Introduction
5 min
01: Oracle Advanced Memory Management
15 min
02: Automatic Memory Tuning
12 min
03: Program Global Area (PGA)
16 min
04: Database Tuning
23 min
05: Automatic Tuning Optimizer
12 min
06: Physical SQL Tuning
19 min
07: Database Impact Advisors
18 min
08: Memory Advisors
17 min
09: Oracle and Resumable Space
18 min
10: Reclaiming Space
21 min
11: Resource Management
10 min
12: Advanced Resource Management
19 min
13: Database Diagnostics
16 min
14: Database Health Checkers
15 min
15: Database Recovery Advisors
14 min
16: Oracle Job Scheduler
14 min
17: Oracle Job Scheduling Options
11 min
18: Oracle Jobs
16 min
19: Oracle Job Definitions
14 min
20: Oracle Globalization Support
15 min
21: Time Zone Support
11 min
22: Course Summary
5 min
Course Survey
View all course details

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

View all course details
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.
View all course details Enroll Now
Video Title
Length
00: Course Introduction - Oracle 12c: Database Administration I Part 1
5 min
01: Database Architecture
23 min
Quiz: Database Architecture
02: Oracle Physical and Logical Structures
20 min
03: Oracle and ASM
18 min
Quiz: Oracle and ASM
04: Container Databases and Pluggable Databases
12 min
05: Oracle 12c Installing ASM
23 min
06: Installing the Database Software
16 min
07: Creating a Container Database
5 min
08: Creating a Traditional Database
19 min
09: Oracle 12c Database Tools
18 min
10: Manage your Database with SQL Developer
14 min
11: Manage your Database with Cloud Control
20 min
12: Managing the Database Instance
14 min
Quiz: Managing the Database Instance
13: Start/Stop the Database
11 min
14: Maintaining Data Files
12 min
15: Container Database Architecture
13 min
16: Database Security
15 min
17: Database Profiles
8 min
18: Database Undo Components
13 min
Quiz: Database Undo Components
19: Database Networking Components Part 1
9 min
20: Database Networking Components Part 2
10 min
21: Oracle Database Concurrency
7 min
Course Survey
View all course details
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
View all course details
In order to successfully complete Oracle 12c Database Administraion 1 Part 1 you will need to have equivalent experience in or have taken:
View all course details
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.
View all course details Enroll Now
Video Title
Length
00: Course Introduction - Oracle 12c: Database Administration I Part 2
5 min
01: Oracle 12c Enterprise Express
13 min
02: Oracle 12c Cloud Control
16 min
03: Undo Tablespaces
19 min
04: Database Auditing
22 min
05: Database Backups
22 min
06: RMAN Concepts
19 min
Quiz: RMAN Concepts
07: RMAN Backups
15 min
08: Database Recovery
19 min
Quiz: Database Recovery
09: Additional Database Recovery
15 min
Quiz: Data Recovery Advisor
10: Oracle Data Pump
20 min
11: Oracle Scheduling
11 min
12: Oracle 12 Performance Tuning
19 min
13: Advisory Framework
16 min
14: Tuning Framework Tools
11 min
Quiz: Tuning Advisory Framework
15: Plan Management
9 min
16: Tune SQL Statements
13 min
Course Survey
View all course details
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
View all course details
In order to successfully complete Oracle 12c Database Administraion 1 Part 2 you will need to have equivalent experience in or have taken:
View all course details

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.

View all course details Enroll Now
Video Title
Length
00: Course Introduction - Oracle 12c Database Administration II Part 1
5 min
01: Installing the Database Software and Creating a Database
15 min
02: Multitenant Architecture
12 min
03: Managing Container Databases
15 min
04: Container Users and Roles
20 min
05: Container Profiles and Privileges
8 min
06: ASM Overview
12 min
Quiz: ASM
07: ASM Instance Management
13 min
08: FLEX ASM
9 min
Quiz: Flex ASM
09: ASM Files and Directories
14 min
10: Oracle Cloud File System
6 min
11: Fast Recovery Area
15 min
12: Recovery Catalog
15 min
13: Recovery Catalog Scripts and Databases
10 min
14: Administering the Recovery Catalog
14 min
Quiz: Recovery Catalog
15: RMAN Backups Part 1
17 min
16: Lab Demo Solution: Database Backup
8 min
17: RMAN Backups Part 2
12 min
Quiz: RMAN Backups
18: RMAN Critical Recovery
13 min
19: Demo: Recover a non-critical file
6 min
20: Diagnosing Backup Issues
14 min
21: RMAN Recovery Concepts
15 min
Quiz: RMAN Recovery
22: RMAN Recovery
23 min
23: Additional Recovery Concepts
17 min
Quiz: Recovery Concepts
Course Survey
View all course details
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
View all course details
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:
View all course details
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.
View all course details Enroll Now
Video Title
Length
00: Course Introduction - Oracle 12c: Database Administration II Part 2
5 min
01: Installing the Database Software and Creating a Database
15 min
02: Flashback Technology
19 min
03: Flashback Recyclebin and Query Backout
21 min
04: Flashback Data Archives
9 min
Quiz: Flashback Data Archives
05: Flashback Database
14 min
06: Database Duplication Part 1
10 min
07: Database Duplication Part 2
8 min
Quiz: RMAN Duplicate
08: Tuning RMAN
12 min
Quiz: Tuning RMAN
09: Overview Oracle Database Architecture
12 min
10: Query Optimizer
15 min
Quiz: Query Optimizer
11: Oracle 12c Tuning Features
8 min
12: Oracle Tuning Tools Part 1
9 min
13: Oracle Tuning Tools Part 2
8 min
14: Lab Demo Solution: SQL Tuning Advisor
5 min
15: Using Automatic Workload Repository
12 min
16: Metrics, Alerts, and Thresholds
13 min
17: AWR Baselines
11 min
18: Additional AWR Performance Tools
14 min
19: Optimizer Statistics
17 min
20: SQL Tuning Advisor
11 min
21: Lab Demo Solution: Create a SQL Tuning Profile
5 min
22: SQL Access Advisor
8 min
23: Lab Demo Solution: Use SQL Access Advisor
20 min
24: Automatic SQL Tuning
9 min
25: SQL Plan Management
8 min
26: Shared Pool Tuning
10 min
27: Tuning the Database Buffer Cache Part 1
12 min
28: Tuning the Database Buffer Cache Part 2
10 min
Quiz: Buffer Cache Tuning
29: Automatic Memory Management (AMM)
10 min
Quiz: Automatic Memory Management
30: Tuning Segment Space Utilization (ASSM)
10 min
Quiz: Automatic Segment Space Management
Course Survey
View all course details
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

 

View all course details
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:
View all course details

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.

View all course details Enroll Now
Video Title
Length
00: Course Introduction - Oracle Cloud Control 12c
7 min
01: Cloud Control Overview
18 min
02: Oracle 12c Cloud Control Architecture
17 min
03: Cloud Control Features
21 min
04: Lab Exercise Demo Review: Install and Configure Cloud Control
15 min
05: Cloud Control Pluggable Databases
13 min
06: Cloud Control Targets Part 1
15 min
07: Lab Exercise Demo Review: Review Web Logic and Cloud Control Settings
9 min
08: Cloud Control Targets Part 2
17 min
09: Cloud Database Targets
24 min
10: Lab Exercise Demo Review: Configure a Cloud Control Database Target
7 min
11: Cloud Control Systems/Services
18 min
12: Lab Exercise Demo Review: Create a Cloud Control System
9 min
13: Cloud Control Monitoring
14 min
14: Lab Exercise Demo Review: Set Cloud Control Default Credentials
5 min
15: Cloud Control Preferences
13 min
16: Lab Exercise Demo Review: Create a new Cloud Control Account
5 min
17: Cloud Control Security
14 min
18: Cloud Control Notifications
11 min
19: Lab Exercise Demo Review: Define a new Cloud Control Schedule and Incidents
11 min
20: Cloud Control Monitoring Templates
14 min
21: Lab Exercise Demo Review: Create and Deploy a Database Monitoring Template
7 min
22: Cloud Control Agent Deployment
16 min
23: Cloud Control Reports
17 min
Course Survey
View all course details

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
     
View all course details

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.

View all course details Enroll Now
Video Title
Length
00: Oracle 11g R2 Real Application Clusters Part 1-Course Introduction
6 min
01: Real Application Cluster Overview
19 min
02: RAC System Requirements
21 min
03: Establish User Equivalence
13 min
04: Install Grid Infrastructure Software
23 min
05: Identify Voting Disk and OCR
19 min
06: Install ASM and Configure Grid Infrastructure Software
18 min
07: Install the Database
15 min
08: Creating the Database
19 min
09: RAC Listener
15 min
10: Use SRVCTL
16 min
11: RAC components
18 min
12: Backup RAC
17 min
13: Tuning RAC
18 min
14: Identify the RAC Services
20 min
15: Configure TAF
13 min
16: RAC Diagnostics
16 min
17: RAC and Grid
18 min
18: Shared Devices
13 min
19: RAC and Tools
19 min
20: RAC Utilities
14 min
21: RAC Architecture
11 min
Course Survey
View all course details

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
 

View all course details

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. 

View all course details Enroll Now
Video Title
Length
00: Oracle 11g R2 Real Application Clusters Part 2 - Course Introduction
10 min
01: SRVCTL
20 min
02: Lab Exercise Demo Review: Using SRVCTL
6 min
03: RAC Performance
20 min
04: Lab Exercise Demo Review: RAC and AWR/ADDM
10 min
05: Adding Nodes
11 min
06: Reducing RAC Components
16 min
07: Lab Exercise Demo Review: Reducing RAC Components
14 min
08: Lab Exercise Demo Review: Extending Database Software to New Nodes
12 min
09: Lab Exercise Demo Review: Extending the Database Instance
7 min
10: Diagnosing RAC Issues
14 min
11: Lab Exercise Demo Review: RAC Diagnosis
7 min
12: RAC Parameter Files
14 min
Quiz: RAC Parameter Files
13: RAC and High Availability
14 min
14: RAC and DataGuard
12 min
Quiz: RAC and DataGuard
15: Configure DataGuard and RAC
13 min
16: DataGuard and Data Broker
19 min
Quiz: DataGuard and Data Broker
17: RAC and ASM
19 min
18: Lab Exercise Demo Review: Using ASM
4 min
19: Patching RAC
14 min
20: RAC and VMWare
17 min
21: VMWare Requirements
16 min
22: Lab Exercise Demo Review: Configuring VM Networking
10 min
23: Configuring VMWare
14 min
24: Why VMWare and RAC
16 min
25: RAC and Oracle Editions
13 min
26: Node Management and RAC
15 min
27: Lab Exercise Demo Review: Srvctl and SCAN Listeners
6 min
28: Removing RAC
8 min
29: RAC and Applications
11 min
Course Survey
View all course details

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
View all course details
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.
View all course details Enroll Now
Video Title
Length
00: Course Introduction
3 min
01: System Requirements
17 min
02: Real Application Cluster Overview
10 min
03: RAC System Requirements
18 min
04: ASM Overview
15 min
Quiz: Oracle and ASM
05: Flex ASM
13 min
06: ASM Files
14 min
07: Lab Exercise and Solution: Using ASMCMD
4 min
08: Install Grid Infrastructure Software
21 min
09: Lab Exercise and Solution: Install and Configure Grid Infrastructure
18 min
10: Install Database Software
5 min
11: Lab Exercise and Solution: Install and Configure Database Software
6 min
12: Creating the Database
13 min
13: Lab Exercise and Solution: Create Additional Disk Groups
2 min
14: Lab Exercise and Solution: Create the Cluster Database
4 min
15: Use SRVCTL
15 min
16: Lab Exercise and Solution: Use SRVCTL
5 min
17: Administer Oracle 12c RAC
19 min
18: Lab Exercise and Solution: Start/Stop RAC Instance and Database
8 min
19: Lab Exercise and Solution: Review Alert.log
5 min
View all course details
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

 

View all course details
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:
View all course details
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.
View all course details Enroll Now
Video Title
Length
00: Course Introduction
5 min
01: System Requirements
17 min
02: Backup Oracle 12c
17 min
03: Lab Exercise and Solution: Configure RAC Archivelog
5 min
04: Lab Exercise and Solution: Backup Database
5 min
05: Tuning RAC
19 min
06: Lab Exercise and Solution: Run AWR Reports
9 min
07: Diagnosis RAC Issues
11 min
08: Lab Exercise and Solution: Diagnosis RAC
7 min
09: Using CRSCTL/OCRCHECK
20 min
10: Lab Exercise and Solution: Use CRSCTL/OCRCHECK
8 min
11: High Availability of Services
17 min
12: Lab Exercise and Solution: Create and Use Services Container/Pluggable
7 min
13: RAC Node One
12 min
Quiz: RAC Node One
14: Node Management
19 min
15: Lab Exercise and Solution: Reducing the RAC
11 min
16: Lab Exercise and Solution: Extending the RAC
14 min
17: Application Continuity (AC)
15 min
Quiz: Application Continuity (AC)
18: Where Do You Go From Here?
1 min
View all course details
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? 
View all course details
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:
View all course details

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.

View all course details Enroll Now
Video Title
Length
Configuring Your System for Lab Exercises
5 min
01: Introduction and Overview of Oracle Fusion Middleware (OFM)
13 min
02: ADF Functionality
15 min
03: Starting a Project in JDeveloper
13 min
04: Starting and Stopping Oracle Fusion Middleware Components
14 min
05: Starting and Stopping Oracle Fusion Oracle Fusion Middleware Agents
19 min
06: Managing the OFM Listening Ports
13 min
07: Managing the Oracle Web Cache
15 min
08: Managing Oracle Metadata Ports
21 min
09: Benefits of Security
12 min
10: Establishing Security
13 min
11: Enabling Security in OSM Applications
17 min
12: Configuring the SSL Automation Tool
6 min
13: Using the Certificate Authority
10 min
14: Managing KeyStores
12 min
15: Using Java KeyStores
18 min
16: Managing Certificates
18 min
17: The Process of Deployment
14 min
18: Deploying and Un-deploying Applications
10 min
19: Automating Application Deployment
14 min
20: Monitoring System Components in OFM
14 min
21: Monitoring Non-System Applications in OFM
17 min
22: Searching Log Files
12 min
23: Working with Log Files
9 min
24: Configuring Log Files
9 min
25: Understanding the Diagnostic Framework
14 min
26: Using the Diagnostic Framework
15 min
Course Survey
View all course details

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
View all course details

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

View all course details Enroll Now
Video Title
Length
00: Course Introduction
8 min
01: Backup Methods
27 min
02: Recovery Configuration
27 min
03: Configuring RMAN
24 min
04: RMAN Backups
31 min
05: Managing Backups
24 min
06: RMAN Complete Recovery
32 min
07: RMAN Incomplete Recovery
28 min
08: Non-Database File Recovery
28 min
09: User Managed Backup
18 min
10: User Managed Recovery
30 min
11: Configuring Flashback
28 min
12: Performing Flashback Recoveries
23 min
13: Performing Flashback Database
27 min
14: RMAN Duplicate Command
17 min
15: RMAN Recovery Catalog
29 min
16: Backups with the Recovery Catalog
22 min
17: Recoveries with the Recovery Catalog
16 min
18: Recovery Catalog Maintenance
28 min
19: Data Pump
21 min
20: Tuning RMAN
19 min
21: Course Summary & Evaluation
2 min
Course Survey
View all course details

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

 

View all course details

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

View all course details

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.

View all course details Enroll Now
Video Title
Length
00: Oracle Data Guard Part 1 Online Training - Course Introduction
5 min
01: Data Guard Components
28 min
02: Data Guard Transport Method
25 min
03: Differences between Failover and Switchover
24 min
04: Demo: Failover and Swithcover
18 min
05: Data Guard Framework
23 min
06: Data Guard Broker Configuration
25 min
07: Defining Gap Resolution
23 min
08: Defining Protection Modes
22 min
09: Operating System Requirements
24 min
10: Manually Creating a Physical Standby Database
24 min
11: Physical Standby Database and Grid
24 min
12: Demo: Creating a Physical Standby with Grid
17 min
13: Logical Standby Database
24 min
14: Using Grid to Create a Logical Database
21 min
15: Demo: Creating a Logical Standby with Grid
12 min
Course Survey
View all course details

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

 

View all course details

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.

View all course details Enroll Now
Video Title
Length
00: Oracle Data Guard Part 2 Online Training - Course Introduction
4 min
01: Backup Methods and Data Guard
22 min
02: Flashback Database and Data Guard
21 min
03: Demo: Implementing Flashback Database
19 min
04: Backing up in a Data Guard Environment
24 min
05: Demo: Backing up a Data Guard Database
21 min
06: Data Guard and Failover
23 min
07: Grid and Failover
23 min
08: Data Guard and Switch Over
20 min
09: Grid and Switch Over
21 min
10: Define Fast Start Failover
21 min
11: Failover Client
23 min
12: Define a Snapshot Standby Database
22 min
13: Oracle Active Data Guard
21 min
14: Managing Data Guard Components
22 min
15: Demo: Monitoring Data Guard Components
18 min
16: Upgrading databases with Data Guard
22 min
Course Survey
View all course details

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
View all course details

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.

View all course details Enroll Now
Video Title
Length
00: Oracle Grid Control Part 1 Online Training - Course Introduction
5 min
01: Describing Oracle's Grid Architecture
18 min
02: Defining Grid Targets
15 min
03: Understanding Grid's Home Page
14 min
04: Installing Oracle's Grid Control
17 min
05: Monitoring Grid Targets
13 min
06: Host Target
18 min
07: Database Target
19 min
08: Application Server/Web Server Target
15 min
09: Defining Grid Users
20 min
10: Defining Notification Rules/Methods
16 min
11: Defining Notification Schedules
15 min
12: Monitoring the Grid
21 min
13: Creating Templates
16 min
14: Grid Groups
17 min
15: Grid Jobs
15 min
16: Grid Deployments
15 min
17: Grid Policy Violations
14 min
18: Grid Blackouts
15 min
19: Patching Grid
15 min
20: Upgrading Grid
13 min
21: Relocating Grid
15 min
Course Survey
View all course details

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

 

View all course details

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.

View all course details Enroll Now
Video Title
Length
00: Course Introduction
6 min
01: Defining a Service
18 min
02: Creating a Service
20 min
03: Creating a Service and Forms Application
17 min
04: Service Beacons
15 min
05: Types of Beacons
16 min
06: Defining a System
18 min
07: Grid Patching
15 min
08: Monitoring Grid Components
21 min
09: Enterprise Manager Configuration
17 min
10: Grid Configuration
16 min
11: Grid Preferences
13 min
12: Web Applications
19 min
13: All Targets
17 min
14: Monitoring Grid Targets
20 min
15: Reports
15 min
16: Report Creation
21 min
17: Report Access
16 min
18: Agent Deployment
20 min
19: Patching
19 min
20: Upgrading Grid
15 min
Course Survey
View all course details

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
View all course details

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.

View all course details Enroll Now
Video Title
Length
00: Course Introduction
4 min
01: Introduction to Application Express
23 min
02: Using SQL Workshop
24 min
03: Building a Application
22 min
04: Creating Reports
22 min
05: Creating Forms
20 min
06: Page and Regions
20 min
07: Items and Buttons
18 min
08: Session State and Debugging
20 min
09: Page Processing
22 min
10: Shared Components
20 min
11: Dynamic Content
23 min
12: Themes
22 min
13: Templates
15 min
14: APEX Admin
24 min
15: Implementing Security
18 min
16: Deploying Applications
18 min
17: Utilities
14 min
Course Survey
View all course details

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

 

View all course details

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

View all course details

Get Started Learning

Oracle Today!

John Mullins

John is an Oracle Instructor, DBA, and Developer with more than 25 years of Oracle experience. His credentials include the Oracle Certified Professional DBA and Certified Technical Trainer certifications.

Mary Gable

Mary Hunsaker Gable has been designing, administering, and developing applications, databases, and education solutions for the Oracle database for over twenty-three years beginning with version 5 of the database. With no choice but to use Pro*PL/1 and Pro*C, she was excited to take advantage of PL/SQL when it was initially released and used it along with Oracle’s Forms and Reports tools to develop her company’s custom accounting software. While watching PL/SQL grow into a robust (and sane) environment for Oracle development, Mary combined her passion for Oracle with her passion for teaching and created Preferred Training Solutions in 1993. In addition to PL/SQL, her favorite, she regularly teaches the full curriculum of Oracle database administration and application development courses worldwide for many Fortune 100 companies such as Hewlett-Packard, IBM, Fannie Mae, Northrop Grumman, various universities, and local, state, and federal government. Mary is active in the Oracle user group community and has authored and presented dozens of papers for various Oracle user groups. She founded the Hampton Roads Oracle User Group (HROUG) in 1993 and continues to serve the local user group community as a board member, frequent presenter, and IOUG representative.  She has been chosen by Steven Feuerstein to lead the PL/SQL Fundamentals track at OPP conferences OPP '07, OPP '08, and OPP '09 being held in Atlanta, Nov. 10-11, 2009.

Steve Hamilton

Steve Hamilton, a consultant and database administrator, has over 20 years of practical experience with Oracle, Sybase and SQL Server. He is certified in Oracle version 8 through 11g and is a charter member of the Nebraska Oracle User Group. He also holds a MCITP SQL Server DBA/Developer certification, Linux certification and a Real Application Clusters (RAC) certification. Steve has consulted for many fortune 500 companies including ConAgra, FDR, Sitel and TDAmeritrade. Since 1995 he has taught nationally in cities such as Atlanta, Los Angeles, Chicago, Denver and New York. Through his experience using these products in both small and large organizations, Steve delights students by bringing 'real world' examples to the classroom. He enjoys preparing students so they can immediately be productive when they return to their work environment. He received a bachelor of science degree in business administration with a specialization in management information systems from the University of Nebraska at Omaha.

Transcript

This course comes with a Transcript that tracks your progress. You can use your transcript to view and monitor your progress and when you complete the course, you can print or email the transcript, or print a course completion certificate.

Certificate of Completion

When you complete this course you will receive a Course Completion Certificate Download Link so you can print and/or email your Certificate of Completion.

Sample of Certification of Completion

QA Forum

When you purchase this course you will be able to use the QA Forum and have direct access to the instructor.

Certification

Obtaining certification in Oracle technologies is an established and validated way of adding value to your resume. Oracle certification allows employers to distinguish a professional from peers who may or may not have the verified skill sets needed.
 
The benefits are best expressed by Oracle certified professionals, of whom:
  • 97% say they have benefited from their certification.
  • 96% say they would recommend certification to a colleague.
  • 89% say they gained more confidence in Oracle expertise with certification.
Source: Highlights From The OCP Benefit Survey
 
Perhaps most importantly, Oracle-certified professionals held the highest average salaries compared to other developer or DBA professionals, according to a salary report by Certification Magazine. Net gains following certification were examined and Oracle professionals were found at the top of the list for salary promotions.
 
Employers know that having those with Oracle certification on staff means tangible value is realized by the business. A research study by IDC suggests:
  • Companies advocating certification had 49% less downtime than those that did not.
  • For the majority surveyed, savings from increased performance recaptured certification costs in less than nine months.
  • Those with Oracle certification handled 40% more support calls per person per day than those without certification.
Source: "Benefits and Productivity Gains Realized Through IT Certification," International Data Corporation
 
Those with Oracle certification will realize the following benefits:
  • Increased credibility
  • Stronger advantage in great job opportunities
  • Use of the Oracle Certification logo to endorse your verified skills
  • Open line of communication with Oracle Corporation
  • Special discounts and offers, hospitality at Oracle Open World events, and more