www.jbinternational.co.uk sales@jbinternational.co.uk Call Free 0800 028 6400

JB International 1345 High Road London, N20 9HR +44 (0) 20 8446 7555

 

Oracle 10g & 11g DBA - New Features for Database Administrators Training Course UK

Dates and full course list

Oracle 10g & 11g DBA - New Features for Database Administrators Course Overview

Course Code:	ORC0120
Price:	£1995
Duration:	5 Days - custom / on-site options available - please call.
Date:
Who should attend:	The course is suitable for technical personnel involved in the database creation, configuration and maintenance of Oracle Databases and those who have completed the Introduction to SQL and/or SQL*Plus course.
Prerequisite Skills:	Delegates should have a good knowledge of their operating system, SQL*PLUS and PL/SQL and previous versions of Oracle database

The course outlines the major new features of the Oracle 10g and 11g database which are relevant to an Administrator and provides an environment in which to gain hands on experience of there use. Lectures are combined with sets of exercises designed to illustrate the points covered. These exercises are to be completed by the delegate.

Course Content

This course has been developed for real-world, commercial scenarios by our expert instructors. See below for detailed syllabus. If you have a technical question, please email

What you will learn

1. how to make use of 10g database new features.
2. how to make use 10g SQL & PLSQL enhancements
3. the enhancements to the oracle 10g tools set.

10g Backup and Recovery Enhancements

Flash Recovery Area
Simplified Recovery Through RESETLOGS
Compressed Backups
Change Tracking
Incrementally Updated Backups
Encrypted Backups
RMAN Enhancements

10g Flashback Features

Oracle 10g Flashback Version Query
Flashback Table
Oracle 10g Recycle Bin
Flashback Database

10g Automatic Storage Management

ASM Instance Architecture
ASM Diskgroups & Failgroups
Using ASMCMD

10g Job Scheduler

Scheduler Components
Control Resources
Monitoring Jobs

10g Performance and Tuning

Automatic Shared Memory Management
Automatic Optimizer Statistics
End-to-End Application Tracing
Metric Thresholds
Server-Generated Alerts and Notifications
Active Session History
AWR Snapshots
Controlling AWR Snapshots
Oracle 10g Tuning Advisors
ADDM Automatic Database Diagnostic Monitor
Advisor Central
SQL Tuning Advisor
SQL Access Advisor
Memory Advisor
UNDO Advisor
Segment Advisor

10g Security Enhancements

Fine Grained Access Control (FGAC)
Virtual Private Database (VPD)
Oracle 10g Auditing Enhancements
DBMS_CRYPTO Package

10g Tablespace, Table and Segment Management

SYSAUX Tablespace
BIGFILE Tablespace
SMALLFILE Tablespace
Default Tablespace
Rename Tablespace
Temp Tablespace Groups
Online Table Redefinition
Online Segment Shrink

10g Utility Enhancements

Data Pump
Network Export / Import
DBMS_DATAPUMP

10g SQL*Plus Enhancements

SQLPlus Enhancements
Recycle Bin
SPOOL Enhancements

11g Flashback new features

Transaction backout
Data Archives

11g Oracle security enhancements

Fine grained access control new features

11g Data Warehousing new features

Interval,reference,system partitioning
Extended composite partitioning
Virtual columns
Materialized View enhancements
Table Compression

11g SQL enhancements

Invisible Indexes
New table locking parameter
DDl locking changes
New add column functionality
Read-only tables

11g PL/SQL enhancements

Trigger enhancements
Created enabled/disabled
Follows clause
Compound

11g XMLDB new features

Binary XML storage
partitioning support XMP
XML index support
XML columns,tables,partitions
XML schema

11g ASM enhancements

11g ADR Automatic Diagnostic Repository

11g Rman enhacements

11g Tablespace enhancements

11g Tablespace Encryption

11g Temporary Tablespace Shrink

Associated Courses

Oracle 11g New Features Training Course for Programmers and DBAs

Introduction to Oracle SQL

Introduction to Oracle PL/SQL

Oracle 10g DBA Combined ('Fundamentals')

Oracle 10g - New Features for Database Administrators

Oracle 10g DBA - part 1

Oracle 10g DBA - part 2

Oracle 10g Performance & Tuning

Oracle 6i Reports

Oracle 6i Forms

Oracle Forms & Reports 5-day Hybrid

Oracle 9i Intro to SQL

Oracle 9i Intro to PL/SQL

Oracle 9i New Features

Oracle 9i Performance Tuning