Duration: 5 Days

What you will learn
This course offers students an introduction to the general features and capabilities of Oracle Database 10g Release 1 for Oracle Real Application Clusters (RAC).
Students learn how to configure and administer a database for use with Real Application Clusters. The course also explains how to setup and use Automatic Storage Management (ASM) in a Real Application Clusters environment. Lectures are reinforced with hands-on practices designed to walk the student through the RAC administration.

Target Audience
Database Administrators

Required Prerequisites
Oracle Database 10g: New Features for Administrators
Oracle Database 10g: Administration Workshop I Release 2

Course Objectives

• Identify Real Application Clusters components
• Install, create, administer, and monitor a Real Application Clusters database
• Use configuration and management tools for Real Application Clusters databases
• Migrate your database storage to Automatic Storage Management
• Setup services for workloads management, and applications high availability
• Develop a backup and recovery strategy for Real Application Clusters databases
• Review high availability best practices

Course Topics

• Introduction
• Architecture and Concepts
• RAC Installation and Configuration Part I
• RAC Installation and Configuration Part II
• RAC Database Instances Administration
• Administering Storage in RAC Part I
• Administering Storage in RAC Part II
• Services
• High Availability of Connections
• Managing Backup and Recovery in RAC
• RAC Performance Tuning
• Design for High Availability

 Print this page

Duration: 3 Days

In this course, students learn how to use Oracle Data Guard to help protect their Oracle Database against planned and unplanned downtimes. Data Guard architecture is discussed, as well as the creation of physical and logical standby databases. In addition, the course examines the performance implications of using various Data Guard features and offers some troubleshooting tips. Students use Enterprise Manager Grid Control to create and manage their Data Guard configuration in the classroom. The course includes a workshop where students have the opportunity to apply what they have learned to meet stated business requirements.

• Prepare the primary database for a Data Guard Configuration
• Monitor a Standby configuration
• Create a Physical Standby database
• Create a Logical Standby database

This course counts towards the Hands-on course requirement for the Oracle Database 10g Administrator certification.

Target Audience
• Technical Consultant
• Database Administrators
• Support Engineer

Prerequisite
Oracle Database 10g: Administration Workshop I Release 2

Course Objectives

• Configure Primary Database
• Create physical Standby
• Create logical standby
• Manage Data Guard configuration with Enterprise Manager Grid Control
• Use Data Guard with Real Application Clusters

Course Outline

• Oracle Data Guard: Overview
• Understanding the Oracle Data Guard Architecture
• Data Guard Broker and Enterprise Manager
• Creating a Configuration with Enterprise Manager
• Creating a Physical Standby Database by Using SQL
• Data Protection Modes and Log Transport Services
• Data Guard SQL Apply Architecture
• Creating a Logical Standby Database by Using SQL
• Switchover and Failover
• Using Data Guard with RAC
• Other Considerations for Oracle Data Guard
• Workshop

 Print this page

Duration: 4 Days

In this course, the students learn how they can use Oracle database features to meet the security and compliance requirements of their organization. The current regulatory environment of the Sarbanes-Oxley Act, HIPPA, the UK Data Protection Act, and others requires better security at the database level. Students learn how to secure their database and how to use the database features that enhance security. The course provides suggested architectures for common problems.

This course explains the security features of the database like auditing, column and file encryption, virtual private database, label security and enterprise user security. Some of the Oracle Network security topics like securing the listener and restricting connections by IP address are also covered.

Target Audience
• Database Administrators
• Support Engineer
• Technical Consultant
• System Analysts

Prerequisites
Oracle Database 10g: Administration Workshop I
Oracle Database 10g: Administration Workshop I Release 2

Course Objectives

• Use basic database security features
• Choose a user authentication model
• Secure the database and its listener
• Use the Enterprise Security Manager tool
• Manage users using proxy authentication
• Implement Enterprise User Security
• Describe the benefits and requirements associated with the Advanced Security Option
• Manage secure application roles
• Implement fine-grain access control
• Manage the Virtual Private Database (VPD)
• Implement fine-grain auditing
• Use Transparent Data Encryption
• Use file encryption
• Encrypting and Decrypt table columns
• Setup a simple Label Security policy

Course Outline

• Security Requirements
• Security Solutions
• Internal Database Security
• Database Auditing
• Fine-Grained Auditing
• Basic User Authentication
• Strong Authentication
• Enterprise User Security
• Proxy Authentication
• Authorization Methods
• Using Application Context
• Fine-Grained Access Control
• Installing Label Security
• Implementing Label Security
• Encrypting Data: Concepts
• Use Application Based Encryption
• Use Transparent Data Encryption
• Use File Encryption
• Oracle Net Services Security Checklist
• Securing the Listener
• Using Connection Manager as a Firewall
• Securing SQL*Plus and iSQL*Plus

Duration: 5 Days

This course offers students an introduction to Oracle Database 10g database technology. In this class students learn the concepts of relational databases and the powerful SQL programming language. This course provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, create database objects, and query meta data.
In addition, the advanced features of SQL in order to query and manipulate data within the database are taught. Advanced querying and reporting techniques are explained. Schema objects that are useful for data warehousing and other application areas are discussed in detail. Students learn about manipulating large data sets and storing and retrieving dates according to different time zones.

Target Audience
• Application Developers
• Business Intelligence Developer
• Database Administrators
• End Users
• Forms Developer
• PL/SQL Developer
• Portal Developer

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

Course Objectives
• Retrieve row and column data from tables with the SELECT statement.
• Employ SQL functions to generate and retrieve customized data.
• Run data manipulation statements (DML) to update data in the Oracle Database 10g.
• Control user access and manage schema objects
• Search data using advanced sub queries

Course Outline

• Introduction
• Writing SQL SELECT Statements
• Restricting and Sorting Data
• Using Single-Row Functions to Customize Output
• Reporting Aggregated Data Using the Group Functions
• Displaying Data from Multiple Tables
• Using Sub queries to Solve Queries
• Using the SET Operators
• Manipulating Data
• Using DDL Statements to Create and Manage Tables
• Creating Other Schema Objects
• Managing Objects with Data Dictionary Views
• Controlling User Access
• Manage Schema Objects
• Manipulating Large Data Sets
• Generating Reports by Grouping Related Data
• Managing Data in Different Time Zones
• Searching Data Using Advanced Sub queries
• Hierarchical Retrieval
• Regular Expression Support

Suggested Follow-Up Course
Oracle Database 10g: Program with PL/SQL [NEW]

Duration: 5 Days

Get the most out of your 10g Database by learning performance tuning methods that maximize the utility of the database. Students learn how to benefit from Oracle Database 10g automatic tuning features, as well as practicing the manual tuning methods using the statspack tool. After clearly defining the various methodologies one can use to tune an Oracle Database, the course covers the various tunable components of an Oracle Database. Throughout the course, students experience hands-on the tuning of an Oracle Database by practicing through a series of workshops.

Target Audience
• Database Administrators
• Support Engineer
• Technical Consultant

Prerequisites
Knowledge of Database Administration
Oracle Database 10g: Administration Workshop I
Oracle Database 10g: Administration Workshop II

Course Objectives

• Use the Oracle Database tuning methodology appropriate to the available tool
• Utilize database advisors to proactively tune an Oracle database
• Use the tools based on the Automatic Workload Repository to tune the database
• Use Statspack reports to tune the database
• Diagnose and tune common database performance problems
• Use Enterprise Manager performance-related pages to monitor an Oracle database

Course Outline

• Performance Tuning Overview
• Statistics and Wait Events
• Metrics, Alerts, and Baselines
• Using Statspack
• Using AWR
• Reactive Tuning
• Tuning the Shared Pool
• Tuning the Buffer Cache
• Automatic Shared Memory
• Checkpoint and Redo Tuning
• Tuning I/O
• Tuning PGA and Temporary Space
• Tuning Block Space Usage
• Initial Configuration

Suggested Follow-Up Courses
Oracle Enterprise Manager 10g Grid Control
Oracle Enterprise Manager 10g Grid Control Release 2
Oracle Database 10g: SQL Tuning Workshop
Oracle Database 10g: Real Application Clusters

Duration: 5 Days Instructor Led

Oracle DBAs manage the industry’s most advanced information systems and command some of the highest salaries. This course advances your success as an Oracle professional in the area of database administration.

In this class, you’ll learn how to configure an Oracle database for multilingual applications. Students will practice various methods of recovering the database, using RMAN, SQL, and Flashback technology. Tools to monitor database performance and the steps to take to improve database performance are also covered in this course. Students will also learn how to use various database technologies, such as Resource Manager, the Scheduler, and Automatic Storage Management (ASM). The lesson topics are reinforced with structured hands-on practices and a workshop. This course is designed to prepare you for the corresponding Oracle Certified Professional exam.

Target Audience

• Database Administrators

• Sales Consultants
• Support Engineer
• Technical Consultant

Prerequisites

• Oracle Database 10g: SQL Fundamentals I

• Oracle Database 10g: Administration Workshop I
• Oracle Database 10g: SQL and PL/SQL Fundamentals

Course Objectives

• Use RMAN to create and manage backup sets and image copies

• Recover the database to a previous point in time
• Use Oracle’s Flashback technology to recover your database
• Detect block corruptions and take appropriate measures to correct them
• Use the various Database advisors and views to monitor and improve database performance
• Control database resource usage with the Resource Manager
• Simplify management tasks by using the Scheduler
• Improve the security of the listener
• Review database log files for diagnostic purposes
• Customize language-dependent behavior for the database and individual sessions

Course Outline

• Using Globalization Support

• Securing the Oracle Listener
• Configuring Recovery Manager
• Using Recovery Manager
• Diagnostic Sources
• Recovering from non-critical losses
• Database Recovery
• Flashback database
• Recovering from User Errors
• Dealing with Database Corruption
• Automatic Database Management
• Monitoring and Managing Storage
• Automatic Storage Management
• Monitoring and Managing Memory
• Managing Resources
• Automating Tasks with the Scheduler

 Print this page

Duration: 5 Days
This class is applicable to Oracle8i, Oracle9i and Oracle Database 10g users. This course introduces students to PL/SQL and helps them understand the benefits of this powerful programming language. In the class, students learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications.

Students learn to create anonymous PL/SQL blocks, stored procedures, and functions. They learn about declaring variables and trapping exceptions. Students will also learn to develop stored procedures, functions, packages and database triggers. Students will learn to manage PL/SQL program units manage dependencies, manipulate large objects, and use some of the Oracle-supplied packages. Students use iSQL*Plus to develop these program units. Demonstrations and hands-on practice reinforce the fundamental concepts.

Target Audience

• Database Designers
• Forms Developer
• PL/SQL Developer
• Technical Consultant

Prerequisite
Oracle Database 10g: Introduction to SQL

Course Objectives

• Design PL/SQL anonymous blocks that execute efficiently
• Write PL/SQL code to interface with the database
• Describe the features and syntax of PL/SQL
• Use PL/SQL programming constructs and conditionally control code flow (loops, control structures, and explicit cursors)
• Handle runtime errors
• Create simple procedures and functions
• Design PL/SQL packages to group and contain related constructs
• Categorize and Use the Oracle supplied PL/SQL packages to generate screen output, file output, web output, and mail output
• Schedule PL/SQL jobs to run independently
• Write dynamic SQL for more coding flexibility
• Create triggers to solve business challenges
• Manage dependencies between PL/SQL subprograms

Course Outline

• Introduction to PL/SQL
• Declaring PL/SQL Identifiers
• Writing Executable Statements
• Interacting with the Oracle Server
• Writing Control Structures
• Working with Composite Data Types
• Using Explicit Cursors
• Handling Exceptions
• Creating Stored Procedures
• Creating Stored Functions
• Creating Packages
• Using More Package Concepts
• Utilizing Oracle Supplied Packages in Application Development
• Dynamic SQL and Metadata
• Design Considerations for PL/SQL Code
• Managing Dependencies
• Manipulating Large Objects
• Creating Triggers
• Applications for Triggers
• Understanding and Influencing the PL/SQL Compiler

 Print this page

Duration: 5 Days

Oracle DBAs manage the industry’s most advanced information systems and command some of the highest salaries. This course is your first step towards success as an Oracle professional, designed to give you a firm foundation in basic database administration. In this class, you’ll learn how to install and maintain an Oracle database.

Students will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Students will also 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. This course is designed to prepare you for the corresponding Oracle Certified Associate exam.

Target Audience

• Database Administrators
• Sales Consultants
• Support Engineer
• Technical Consultant

Prerequisite
Oracle 10g Program with PL/SQL

Course Objectives

• Install and configure the Oracle Database 10g
• Create and administer user accounts in the Oracle Database 10g
• Backup and Recovery of the Oracle Database 10g
• Monitor, troubleshoot, and maintain the Oracle Database 10g
• Configure Oracle Net services for the Oracle Database 10g

Course Outline

• Introduction
• Installing Oracle Database 10g Software
• Create an Oracle Database
• Database interfaces
• Controlling the database
• Storage Structures
• Administering users
• Managing Schema Objects
• Managing Data
• PL/SQL
• Oracle Database Security
• Oracle Net Services
• Oracle Shared Server
• Performance Monitoring
• Proactive Maintenance: Objectives
• Undo Management
• Monitoring and Resolving Lock Conflicts
• Backup and Recovery Concepts
• Database backups
• Database Recovery

Suggested Follow-Up Course
Oracle Database 10g: Administration Workshop II

 Print this page

Duration: 3 Days Instructor-Led

This course is designed to give the experienced SQL Developer or DBA a firm foundation in SQL tuning techniques. The participant learns the necessary knowledge and skills to effectively tune SQL in the Oracle Database 10g. They learn about tuning methodology as well as proactive and reactive tuning methods. Students are introduced to the benefits of the new automatic tuning mechanisms available in Oracle Database 10g.

On completion of the course students are able to compare and contrast the steps involved to tune manually as in prior releases as well as use the automatic SQL tuning features provided in the current release. Students gain a thorough conceptual understanding of the Oracle Optimizer, and reinforce instructor-led learning with structured hands-on practices. The course uses a series of challenge-level workshops, allowing students to “play, discover, and learnat their own level and pace. The students learn to use the Oracle diagnostic tools and facilities: Automatic SQL Tuning components, EXPLAIN, SQL Trace and TKPROF, SQL*Plus AUTOTRACE. Students also learn to influence the behavior of the Optimizer by changing the physical schema and modifying SQL statement syntax.

This course counts towards the Hands-on course requirement for the Oracle Database 10g Administrator Certification. Only instructor-led in-class or instructor-led online formats of this course will meet the Certification Hands-on Requirement. Self Study CD-ROM and Knowledge Center courses DO NOT meet the Hands-on Requirement.

Target Audience

• PL/SQL Developer
• Technical Consultant
• Reports Developer
• Business Intelligence Developer
• Java Developer
• Forms Developer

Required Prerequisite
Oracle Database 10g: SQL Fundamentals I

Suggested Prerequisite
Oracle Database 10g: PL/SQL Fundamentals

Course Objectives

• Describe the basic steps in processing SQL statements
• Describe the causes of performance problems
• Understand where SQL tuning fits in an overall tuning methodology
• Describe Automatic SQL Tuning
• Use the diagnostic tools to gather information about SQL statement processing
• Understand Optimizer behavior
• Influence the optimizer behavior
• Influence the physical data model so as to avoid performance problems

Course Outline

• Database Architecture overview
• Following a Tuning Methodology
• Designing Applications for performance
• Introducing the optimizer
• Optimizer Operations
• Displaying Execution plans
• Gathering Statistics
• Application Tracing
• Identifying High Load SQL
• Automatic SQL Tuning
• Introduction to Indexes
• Advanced Indexes
• Optimizer Hints and Plan Stability
• Materialized Views and Temporary Tables

 Print this page

Duration: 3 Days Instructor-Led

Practical introduction to fundamental Oracle concepts. Students learn how to create a data model, and how to implement it as a database.

Target Audience
Database administrators, programmers and system administrators who want an introduction to Oracle and its use, and an introduction to SQL.

Prerequisites
Computing background, preferably with some database or programming experience.

Course Outline

• Database Concepts
• Data Normalization
• Data Modelling and Design
• Introduction to SQL
• PL/SQL
• Database Objects
• Oracle Architecture

Practical Skills Gained

• Create a basic data model
• Implement model as functioning Oracle database
• Write SQL queries
• Create and modify tables
• Manage user privileges
• Understand Oracle architecture

 Print this page