Oracle Training Courses and Workshops

Schools providing training courses, certificates, diplomas or degree programs of DBA/OCA/OCP




Total 800 training courses and degree programs available around the world.

United States - United Kingdom - Canada - Australia - India

Popular courses:
Oracle
Oracle DBA
Oracle Database Administration
Oracle Database 10g - Administration
Oracle Database 10g
Oracle Database 10g: Administration


Oracle WebLogic Server 11g Administration (Certificate)

Course Format: Online
School/Trainer: Intertech, Inc.
Training Center(s)/Venue(s): Eagan, United States
  V


Learning Objectives

Understand WebLogic architecture
Understand deployments of EJB and Web applications
Understand how to run WebLogic as a Web server
Set up WebLogic Server test environments for developers
Start/stop servers, problem detection and trouble shooting
Use the WLST for command-line administration
Use clustering for fault tolerance and load balancing
Configure and monitor resources in a production environment
Conduct security planning and implementation
Handle large throughput and concurrency
Understand performance tuning

Audience

Web server administrators, project managers, developers and consultants who want to gain the knowledge of WebLogic Server administration.

Oracle 11g OCP (Certificate)

Course Format: Online
School/Trainer: Intertech, Inc.
Training Center(s)/Venue(s): Eagan, United States
  V

This course includes exam 1Z0-053.

Oracle Database Architecture Overview
ASM General Architecture
ASM Storage Concepts
ASM Scalability and Performance

Configuring for Recoverability
Oracle Backup and Recovery Solutions
Using Recovery Manager (RMAN)
Using a Flash Recovery Area
Flash Recovery Area Space Management

Using the RMAN Recovery Catalog
RMAN Repository Data Storage: Comparison of Options
Storing Information in the Recovery Catalog
Registering a Database in the Recovery Catalog
Recovery Catalog Resynchronization: Concepts
Using RMAN Stored Scripts

Configuring Backup Specifications
Using RMAN to Create Backups
Configuring Persistent Settings for RMAN
Using Enterprise Manager to Configure RMAN Settings
Control File Auto-backups
Configuring Backup Optimization

Creating Backups
Creating an Oracle-Suggested Backup
Creating Backup Sets &, Image Copies
Creating a Whole Database Backup
RMAN Backup Types
Monitoring Block Change Tracking
Creating Duplex Backup Sets

Perfor... [Read More]

Oracle 11g OCA / SQL / OCP Boot Camp (Certificate)

Course Format: Online
School/Trainer: Intertech, Inc.
Training Center(s)/Venue(s): Eagan, United States
  V

Oracle Database 11g, building on Oracle&,#146,s unique ability to deliver Grid Computing, gives Oracle customers the agility to respond faster to changing business conditions, gain competitive advantage through technology innovation, and reduce costs.

With Oracle Database 11g you can:
Adopt new technology faster with Real Application Testing
Manage more data for less with advanced compression and partitioning
Simplify systems by storing all your data in the Oracle Database with Oracle Secure Files
Maximize the ROI of disaster recovery resources with Oracle Active Data Guard
Free critical personnel for strategic tasks with management automation

This course includes exam 1Z0-052.

Describing the Oracle Architecture
Oracle Server
SGA
Datafiles
Background Processes

Creating an Oracle Database
Database Configuration Assistance
Database Templates

Managing an Oracle Instance
Oracle Enterprise Manager

Database Storage Structures
Tablespaces
Datafiles
Tempfiles

Database Security
System Accounts
Application A... [Read More]

Oracle 11g DBA (Certificate)

Course Format: Online
School/Trainer: Intertech, Inc.
Training Center(s)/Venue(s): Eagan, United States
  V

Oracle Database 11g, building on Oracle&,#146,s unique ability to deliver Grid Computing, gives Oracle customers the agility to respond faster to changing business conditions, gain competitive advantage through technology innovation, and reduce costs.

With Oracle Database 11g you can:
Adopt new technology faster with Real Application Testing
Manage more data for less with advanced compression and partitioning
Simplify systems by storing all your data in the Oracle Database with Oracle Secure Files
Maximize the ROI of disaster recovery resources with Oracle Active Data Guard
Free critical personnel for strategic tasks with management automation

PL/SQL

Course Format: Online
School/Trainer: Intertech, Inc.
Training Center(s)/Venue(s): Eagan, United States
  V

PL/SQL is Oracle&,#146,s extension language for standard SQL.

In this PL/SQL training class, students who already know SQL, learn to use PL/SQL to write sophisticated queries against an Oracle database.

The Environment for PL/SQL Development
Prerequisites
File Naming Conventions
Connecting to Oracle
SQL*Developer
SQL*Plus
Executing PL/SQL Code
SQL Developer Configuration
The PL/SQL Development Cycle

PL/SQL Basics
PL/SQL Block
Anonymous Block Structure
Named Block Structure
Executing Blocks
Calling PL/SQL Functions
Executing PL/SQL Blocks and Functions

Declaring Variables
Variable Usage
Variable Data Types
Variable Naming
Variable Assignment
Variable Display
Complex Variable Types
More Information
Variable Declaration, Initialization and Display

Within the Block
Conditional Processing
The IF Statement
The CASE Statement
Iterative Processing
The LOOP Statement
The WHILE Statement
The FOR Statement
Salary C... [Read More]

Oracle Database Administration

Course Format: Online
School/Trainer: Intertech, Inc.
Training Center(s)/Venue(s): Eagan, United States
  V

This Oracle Database Administration Training will develop the key fundamental skills necessary to be an Oracle DBA. Students will design and create a server using the Optimal Flexible Architecture (OFA), configure logical and physical structures, set up database and user security, add and administer users, and monitor and tune main server areas. Each student will create a toolkit of administration scripts for database management and tuning by the end of this class.

The course is inteded for non-Oracle database administrators, application developers, and system administrators.

Overview of Oracle Database
ORACLE_HOME and ORACLE_SID
The Oracle Database vs. The Oracle Instance
Instance Memory Structures
Background Processes
Server Processes
Datafiles
Blocks, Extents, and Segments
Control Files
Redo Logs
The Oracle Architecture
SYS and SYSTEM Users

Starting and Shutting Down an Oracle Database
SYSDBA and SYSOPER System Privileges
Oracle Database Startup
Oracle Database Shutdown
Altering Database Availability
Suspending and Resuming... [Read More]

Oracle Database 11g: Administration Workshop 1

Course Format: Online
School/Trainer: Intertech, Inc.
Training Center(s)/Venue(s): Eagan, United States
  V

This course is designed to give students a firm foundation in basic administration of Oracle Database 11g. In this class, students learn how to install and maintain Oracle Database 11g. Students gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Students learn how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques. The lesson topics are reinforced with structured hands-on practices.

Learning Objectives

Describe Oracle Database Architecture
Install and configure Oracle Database 11g
Configure Oracle Net services
Manage the database storage structures
Create and administer user accounts
Perform basic backup and recovery of a database
Manage users and schemas
Manage data and concurrency
Monitor and administer undo data
Backup and recover a database
Monitor performance
Use the database diagnostic monitor

Oracle Database 11g R2: PL/SQL Fundamentals

Course Format: Online
School/Trainer: Intertech, Inc.
Training Center(s)/Venue(s): Eagan, United States
  V

This Oracle 11g course will provide an introduction to the PL/SQL database programming language, based upon the latest features available with the Oracle database. Syntax, structure and features of the language are discussed in the context of database applications and programming.

This course equips students to develop database server-side PL/SQL program units within an Oracle database. In addition to receiving the print copy of this course book, all students will receive e-Learning modules.

Course Outline

Choosing a SQL &, PL/SQL Interface
Using SQL Developer
Using SQL *Plus
Using Application Express
Using JDeveloper Studio

Language Features
Understanding PL/SQL
Structure of a PL/SQL Program Block
Using PL/SQL from SQL *Plus

Declare Clause
About the Declare Clause
Declare Simple Types
Declare Complex Types
Type ... Table
Type ... Record

Begin Clause
About the Begin Clause
Performing Data Manipulation
Logic Control &, Branching
Loop
If-Then-Else
Case

Exception Cl... [Read More]

Oracle Database 11g R2: Grid Infrastructure & ASM

Course Format: Online
School/Trainer: Intertech, Inc.
Training Center(s)/Venue(s): Eagan, United States
  V



This training course provides a step-by-step guide for configuring and using the Oracle Grid Infrastructure in a single server environment, and it forms the basis for expanding this infrastructure to a clustered server configuration.

Advanced database and storage administration tasks are considered, including Oracle Restart and Automatic Storage Management (ASM).

With this course you will learn about:
Preparing a host system for the Grid Infrastructure and Oracle RDBMS installations and performing those installations.
Preparing a host system for ASM storage management.
Partitioning and configuration of storage devices for ASM storage on both Linux and MS Windows servers.
Utilizing Oracle Restart for automatic sequencing and restarting of Oracle software components.
Obtain an introduction to Oracle High-Availability Services including the Server Control and Clusterware Control utilities.
Review the Oracle server stack architecture including operating system virtualization and storage subsystem virtualization layers.
Using ASM for storage of some or all database files, thereby providing a d... [Read More]

Oracle Database 11g R2: Encryption & Advanced Data Security

Course Format: Online
School/Trainer: Intertech, Inc.
Training Center(s)/Venue(s): Eagan, United States
  V

Threats to data security abound and are increasing in sophistication and frequency. Organizations have both an ethical and oftentimes a legal responsibility to understand the countermeasures available, to compare these against those threats to which they are exposed, and to properly apply such countermeasures.

This training course module considers how encryption technology should, and should not, be employed within an Oracle database environment in response to known threats and risks. It will also discuss other best security practices which pertain to application security, host system configuration and the database installation.

Within this training course we will discuss these topics:
Consider examples of common security threats and sensitive data which might exist within an organization.
Review the essentials of a sound and secure database installation.
Consider known database security weaknesses and how these may be addressed.
Consider examples of specific attacks which could be launched against individual components within a data center or within the public networks.
Review the theory and concepts which underl... [Read More]

Oracle Database 11g R2: Data Warehousing & Oracle Warehouse Builder

Course Format: Online
School/Trainer: Intertech, Inc.
Training Center(s)/Venue(s): Eagan, United States
  V

This Oracle 11g course will highlight the features within the Oracle database specifically intended to support data warehouses and data mining operations.

Concepts include data warehousing and the requirements to initially configure a data warehouse installation. Aditionnal concepts are how the Oracle Warehouse Builder (OWB) product may be used to implement and maintain both transactional and warehouse databases, and the movement of data between those two different types of installations.

This course highlights the features within the Oracle database specifically intended to support data warehouses and data mining operations.
Data warehousing concepts and the requirements to initially configure a data warehouse installation.
How the Oracle Warehouse Builder (OWB) product may be used to implement and maintain both transactional and warehouse databases, and the movement of data between those two different types of installations.

Among the specific topics considered within this course are:
Understanding star and snowflake schemas and other data warehouse physical and logical database objects.
Understanding and enc... [Read More]

Oracle Database 11g R2: Advanced PL/SQL Programming & Tuning

Course Format: Online
School/Trainer: Intertech, Inc.
Training Center(s)/Venue(s): Eagan, United States
  V

This Oracle 11g course will give attention to three fundamental pillars of effective implementation of PL/SQL applications. The PL/SQL programming language is at the core of most Oracle database applications.

First, we will explore the advanced features of the language which allow powerful and effective database applications to be built.

Next, we will discuss performance tuning techniques which allows these applications to run efficiently.

Finally, we will consider critical security measures which should be implemented to counter hacker attacks and other security threats. In addition to receiving the print copy of this course book, all students will receive e-Learning modules.

Among the specific topics contained within these training materials are:
Invoking external procedures and integrating these into PL/SQL applications. These include external Java classes using the JDBC interface and external C programs contained within DLL libraries.
Using dynamic SQL to extend the functionality and flexibility of database programs, including the DBMS_SQL() system-supplied package for maximum flexibility.
Identifyin... [Read More]

Oracle Database 11g R2: Administration I

Course Format: Online
School/Trainer: Intertech, Inc.
Training Center(s)/Venue(s): Eagan, United States
  V

Administration of the Oracle database management system (DBMS) software environment and of the server systems on which the DBMS runs is one of the primary tasks required of database administrators. While it is true that the hardware and software platforms on which the DBMS runs have become increasingly complex, as has the database software itself, the capabilities provided by the Oracle database have correspondingly become more sophisticated.

The overall objective of this training course is to allow the student to gain the skills necessary for day-to-day administration of an Oracle database. These training materials are the starting point for Oracle database administrators and sets the foundation for advanced administrator training and certification. Major tasks to be considered within this course are:
Configuration of the Linux and MS Windows operating systems in anticipation of a database installation
Server Class installation of the Oracle 11g R2 Enterprise Edition database
Verification of a valid database installation
Database administrator interface options, including the use of Enterprise Manager, command-line SQL*Plus, and te... [Read More]

Oracle Database 11g R2: Administration II

Course Format: Online
School/Trainer: Intertech, Inc.
Training Center(s)/Venue(s): Eagan, United States
  V

This course brings database administrators beyond a basic understanding of their duties and to transfer advanced skills needed to effectively administer an Oracle database installation within a large-scale enterprise. Important subject areas include advanced database configuration, performance monitoring and tuning, configuring for recovery, troubleshooting and fault diagnosis, and use of the extensive advisory framework. Sometimes configuration and operational problems can exist within an Oracle database installation because important technologies are either not fully understood or not properly implemented.

Advanced technologies which should be applied to any mission-critical database installation. The Database Resource Manager is an essential tool for database tuning and achieving optimum performance, and is often used in combination with the advisors. The Database Scheduler is a sophisticated tool which can automate many administration tasks and integrate the database into the larger data center and systems infrastructure. All of the data within a database installation is at risk unless one has designed, tested and implemented a robust backup and recovery s... [Read More]

Oracle Business Intelligence (OBIEE): Interactive Dashboards & Answers

Course Format: Online
School/Trainer: Intertech, Inc.
Training Center(s)/Venue(s): Eagan, United States
  V


Learning Objectives

Background discussion of relational databases, the SQL database language, data warehousing, business intelligence (BI) and data analytics presented in a form that business professionals can readily understand.
Background concepts regarding logical data models, physical data models, star schema and snowflake schema warehouse models.
Important data concepts including fact tables, dimensions, cubes, measures and other dimensional data model objects.
An introduction to Oracle BI concepts, including the Oracle BI repository layers, Oracle BI Presentation Services, Oracle BI Presentation Catalog and basic navigation of the Oracle BI Answers and Dashboards interface.
Use interactive Dashboards to analyze warehouse data, uncover trends and reach important business decisions.
Design customized Dashboards to reflect an individual&,#146,s role, perspective or business interest.
Creating requests and viewing answers produced from Oracle BI.
Formatting requests using sorts, filters and prompts.
Formatting column output and modifying column data using formulas.
Creating report result... [Read More]

Oracle 11g OCA & 10g SQL (Certificate)

Course Format: Online
School/Trainer: Intertech, Inc.
Training Center(s)/Venue(s): Eagan, United States
  V

Oracle Database 11g, building on Oracle&,#146,s unique ability to deliver Grid Computing, gives Oracle customers the agility to respond faster to changing business conditions, gain competitive advantage through technology innovation, and reduce costs.

With Oracle Database 11g you can:
Adopt new technology faster with Real Application Testing
Manage more data for less with advanced compression and partitioning
Simplify systems by storing all your data in the Oracle Database with Oracle Secure Files
Maximize the ROI of disaster recovery resources with Oracle Active Data Guard
Free critical personnel for strategic tasks with management automation

Oracle Database SQL Certified Experts demonstrate the complete set of skills required for working with the powerful SQL programming language and have mastered the key concepts of a relational database. SQL Experts understand how to use the advanced features of SQL in order to query and manipulate data within the database, control privileges at the object and system level, and use advanced querying and reporting techniques. They are able to manipulate large data sets and understand st... [Read More]

Oracle 10g SQL Expert Boot Camp (Certificate)

Course Format: Online
School/Trainer: Intertech, Inc.
Training Center(s)/Venue(s): Eagan, United States
  V

Oracle Database SQL Certified Experts demonstrate the complete set of skills required for working with the powerful SQL programming language and have mastered the key concepts of a relational database. SQL Experts understand how to use the advanced features of SQL in order to query and manipulate data within the database, control privileges at the object and system level, and use advanced querying and reporting techniques. They are able to manipulate large data sets and understand storing and retrieving dates according to different time zones. They are also knowledgeable about the concepts of controlling access and privileges for schema objects.

Oracle 10g Real Application Clusters

Course Format: Online
School/Trainer: Intertech, Inc.
Training Center(s)/Venue(s): Eagan, United States
  V

This course offers students an introduction to the general features and capabilities of Oracle Database 10g Release 2 for Oracle Real Application Clusters (RAC). Students learn how to install and administer OracleClusterware, Real Application Clusters, and Automatic Storage Management. Students also learn how to administer their Database in a Real Application Clusters environment using Enterprise Manager Grid Control. Increase your efficiency by learning how to configure and use database services as well as the Load Balancing Advisory in a RAC environment. Learn how to add and remove nodes in clusters and how to patch both Oracle Clusterware and Real Application Clusters software in a rolling fashion.

RAC Installation
Install and Configure ASM
Install the Oracle database software
Perform pre-creation tasks

Database Creation
Install Enterprise Manager
Create a cluster database
Post database creation tasks

RAC DB Administion
Manage Undo Tablespaces with RAC
Start and Stop RAC Databases
Modify RAC initialization parameters
Create and Manage ASM Disk Groups and ASM Files

Ba... [Read More]

Oracle 10g Database on Enterprise Linux

Course Format: Online
School/Trainer: Intertech, Inc.
Training Center(s)/Venue(s): Eagan, United States
  V

This course is designed to give the Database Administrator a firm understanding of the components required to successfully deploy an Oracle 10g Database on Enterprise Linux. Students will learn how to configure the Linux operating system for optimal performance with an Oracle database. Then they will install and create an Oracle 10g database on Linux. In addition, the students will also learn how to tune the database to take advantage of the Linux operating system and the Enterprise level features of the OS.

Introduction to Linux
Kernel Version Information
Common Linux Commands
Navigating the File System
Using the Virtual File System
The Basics of Bash Shell Scripting

Preparing Oracle
Setting Shared Memory Parameters
Setting Semaphore Parameters
Managing Packages
Configuring the X Window System
Creating the Necessary Linux Users

Installing Oracle on Linux
File System Security
Setting Environment Variables
Creating Oracle Directories
Managing Multiple Version of Oracle Software
Using the Oracle Universal Installer
Installation Pre-requisites
Read More]

Advanced Oracle SQL Queries

Course Format: Online
School/Trainer: Intertech, Inc.
Training Center(s)/Venue(s): Eagan, United States
  V

Users and Schemas
Introduction to Users and Schemas
Definitions and Client Tools
SQL Developer Login
About the HR Schema
Sample Schemas
HR Schema Entities
Creating An Application Schema
Exercise: Create a User

Pseudo Columns &, Functions
Using The Dual Table
Functions
Exercise: Use the SYSCONTEXT function
Pseudo-Columns
Using Rowid
Using Rownum
Exercise: Use ROWNUM

Using Subqueries
Simple Subqueries
Definition
Nested Subquery
Inline Views
Subquery in the HAVING clause
Correlated Subqueries
Scalar Subquery
Exercise: Subqueries

Joining Tables
Review of Joins
Equijoins
Inner Joins
Outer Joins
Cross Joins
Reflexive Join
Non-Key Join
Natural Joins
Semijoins and Antijoins
Using Named Subqueries
Exercise: Join Exercises

Rollup &, Cube
About Group Processing
EMP_DETAILS_VIEW
Simple GROUP BY
ROLLUP Function
GROUPING Function
Using Cube
Exercise: ... [Read More]

Pages: 1 2 3 4 5 6 ...


Find Oracle training courses, certificates, diplomas and degrees in Countries:



Australia - Canada - India - Indonesia - Ireland - Malaysia - New Zealand
Pakistan - Philippines - Singapore - South Africa - United Arab Emirates
United Kingdom - United States



Facts:
We serve the schools and students around the world. Major visitors come from India, United States, United Kingdom, Canada, Australia, Philippines, Malaysia, Singapore and South Africa.



- Other Topics -
- Online/E-learning -
Oracle
Ask for Training
Add Courses