Oracle 11g R2 for Exp. 9i DBA's
StayAhead Training
Duration: 5 Hours
£1,795
(VAT will be added to this price.)
Detailed information
| Duration: | 5 Hours |
|---|---|
| Price: | £1,795 (VAT will be added to this price.) |
| Type: | Training |
| Method: | In a classroom |
| Accreditation: | See course outline for exam details |
| Prepares for: | This course prepares delegates to use this product in their everyday work environment. |
| Geared towards: | This Oracle Database 11g Release 2 for Experienced 9i Database Administrators course will give experienced Oracle 9i database administrators practical experience in installing, configuring, administering and implementing an Oracle Database 11g. DBAs will gain a practical understanding of the new features of Oracle Database 11g Release 1 and Release 2 and how these can be implemented in their current Oracle installations. |
| Requirements: | Requirements Delegates who wish to attend this Oracle Database 11g Release 2 for Experienced 9i Database Administrators course should have good understanding of Oracle 9i Database Administration. Follow-On Courses • Oracle 11g SQL Performance Tuning • Oracle 10g Application Server Administration |
| Internship: | none |
| Students per class: | 10 |
Do you need further information?
Contact the person in charge , free and at no obligation, for information on how to enroll, enrollment limit/availability and more.
Course program
Skills Gained
The delegate will practise:
• Installing Oracle Database 11g Release 2 Software
• Creating an Oracle Database using New Features
• Using the New Enterprise Manager
• Proactively Monitoring with Database Advisors
• Using New Memory Management Features
• Using New Data Storage Features
• Using New Space Management Features
• Using New Optimizer and Index Features
• Using New SQL and PL/SQL Features
• Using the Data Pump Utility
• Using New Backup and Recovery Features
• Using New Availability Features
• Using New Security Features
• Automating Tasks with the New Scheduler
• Using Real Application Testing
• Using Database Replay to Capture, Process and Replay Workloads
• Using the Data Recovery Advisor and Flashback
• Managing Transactions using Flashback and LogMiner
• Using Performance Tuning New Features
• Implementing New Schema Management Functionality
Who will the Course Benefit?
This Oracle Database 11g Release 2 for Experienced 9i Database Administrators will benefit Database administrators, who need to update their current Oracle 9i skills to create, administer, monitor, backup and support Oracle Database 11g Release 1 and Release 2.
Course Contents - DAY 1
Course Introduction
• Administration and Course Materials
• Course Structure and Agenda
• Delegate and Trainer Introductions
Session 1: NEW MANAGEMENT FEATURES
• Log File Changes
• Parameter File Management Changes
• Automatic Diagnostic Repository
• ADRCI Command Line Tool
• New Memory Management Features
• Memory Advisor Views
• New Management Parameters
Session 2: INSTALLING ORACLE DATABASE 11g
• System Hardware requirements
• Overview of Oracle Grid Infrastructure
• Installing Oracle Database 11g Release 2
• The Database Configuration Assistant
• Database Templates
• Online Patching
Session 3: UPGRADING TO ORACLE DATABASE 11g
• Upgrading to Oracle Database 11g Release 1 and 2
• Upgrade the Time Zone File and Timestamp with Timezone Date
• Oracle Parameter Changes
• Altered Parameter Behaviour
• Online Dictionary View Changes
Session 4: ADMINISTER A DATABASE
• Administrative Tools Available to a DBA
• Use Oracle Enterprise Manager to Manage a Database
• Stop and Start the EM Database Console
• Access Oracle Enterprise Manager
• Grant EM Administrative Privileges
• Control Oracle Restart
• Use the srvctl Utility
• Manually Add Components to the Oracle Restart Configuration
Session 5: NEW DATABASE STORAGE FEATURES
• Default Permanent Tablespace
• Rename a Tablespace
• The SYSAUX Tablespace
• Copy Files Using the Database Server
• Drop an Empty Datafile
• Tablespace Monitoring
• Segment Management Enhancements
• Segment Advisor
• Segment Resource Estimation
• On Line Segment Shrink
• Proactive Tablespace Management
• Automatic Undo Retention
• Table Compression
• Hybrid Columnar Compression
• Segment Creation on Demand
________________________________________
Course Contents - DAY 2
Session 6: SECURITY ENHANCEMENTS
• Connect Role Change
• Default Passwords
• Automatic Secure Configurations
• Case Sensitive Passwords
• Profiles and the Password Verify Function
• Virtual Private Database Enhancements
• Auditing Enhancements
• OS Audit in XML Format
• Uniform Audit Trail
• Default Auditing in Oracle Database 11g
• Tablespace Master Key Re-key
• DBMS_CRYPTO
• Transparent Data Encryption
• Transparent Tablespace Encryption
• Data Masking
• Security and OEM
Session 7: AUTOMATIC DATABASE MANAGEMENT
• Automatic Workload Repository
• AWR 11g New Features
• Automatic Database Diagnostic Monitor
• ADDM 11g New Features
• ADDM Reports
• DBMS_ADVISOR Reports
• DBMS_ADVISOR Views
• Alerts
Session 8: AUTOMATING TASKS WITH THE SCHEDULER
• Scheduler Overview
• DBMS_SCHEDULER
• Scheduler Related Parameters
• Access Rights
• Create a Program
• Enable a Program
• Drop a Program
• Create a Schedule
• Create a Job
• Job Classes
• Resource Windows
• Window Group
• Monitoring and Logging
• AutoTask
Session 9: SCHEMA MANAGEMENT NEW FEATURES
• DDL Wait Option
• Add Columns with a Default Value
• Virtual Columns
• Invisible Indexes
• Improved Online Index Creation and Rebuild
• Read Only Tables
Session 10: APPLICATION DEVELOPMENT NEW FEATURES
• Append, Create and Replace Extensions to Spool/Save
• SQL*Plus Errorlog Table
• Lock Table Parameter
• SQL Query Result Cache
• Client Side Result Cache
• PL/SQL Function Cache
________________________________________
Course Contents - DAY 3
Session 11: UTILITIES FOR TROUBLESHOOTING DATA CORRUPTION
• Automatic Block Corruption Reporting
• Automatic Quarantine of Corrupt Undo Segments
• Protection from Data Corruptions
• Improvements to ANALYZE ... VALIDATE STRUCTURE
• Proactive Monitoring with the Health Monitor
Session 12: BACKUP AND RECOVERY NEW FEATURES
• Recovery Through Reset Logs
• Changes to ALTER DATABASE ARCHIVELOG
• Recovery Manager Enhancements
Session 13: DATA RECOVERY ADVISOR
• Overview of Data Recovery Advisor
• Use the Data Recovery Advisor through the RMAN Command Line
• Run Pro-Active Health Checks with the Validate Command
• Use the Data Recovery Advisor through EM
• Automatic Diagnostic Repository
• Data Recovery Advisor Dictionary Views
Session 14: OVERVIEW OF AUTOMATIC STORAGE MANAGEMENT
• Overview of ASM
• ASM Instance Creation
• SYSASM Role
• Administer ASM Disk Groups
• ASM Files
• ASM Startup and Shutdown
• ASM Disk Failure
• ASM Data Dictionary Tables
• Migrate a Database to ASM Using RMAN
• The asmcmd Command Line Interface
• ASM File Access Control
• Use 4KB Sector Disks
________________________________________
Course Contents - DAY 4
Session 15: DATABASE REPLAY
• Overview of Database Replay
• The Database Replay Process
• Capture a Workload
• Pre-process the Captured Workload
• Replay the Workload
• Database Replay Usage
• The DBMS_WORKLOAD Package
Session 16: DATA PUMP
• The exp Utility Deprecated
• Introduction to Data Pump Import and Export
• Data Pump Architecture
• Data Pump Export
• Data Pump Import
• Data Pump Legacy Mode
Session 17: OVERVIEW OF DATA GUARD NEW FEATURES
• Apply Redo in Real Time
• Redo Transmission Enhancements
• New Standby Database Parameters
• ARCH Process Writes to Standby Redo Logs
• Changes to Standby Database Startups
• Logical Standby Database Enhancements
• Fast Start Failover Enhancements
• Archive Redo Log Compression
• Lost Write Detection
• Real Time Query Capable Physical Standby Database
• Rolling Upgrades to Physical Standby
• SQL Apply Logical Standby
• RMAN and Data Guard
• Snapshot Standby Databases
• Clone a Running Database
• Active Database Duplication
• Oracle Active Data Guard
• Real Time Query
• Block Change Tracking on a Physical Standby Database
Session 18: ORACLE DATABASE ADVISORS
• Repair Advisors and Fault Diagnostics
• The SQL Repair Advisor
• The SQL Access Advisor
• The Streams Performance Advisor
• The Advisor Views
________________________________________
Course Contents - DAY 5
Session 19: FLASHBACK TECHNOLOGY
• Flashback Query
• Flashback Version Query
• Flashback Table
• Flashback Transaction Query
• Flashback Drop
• Flashback Database
• Flashback Restore Points
• Flashback Transaction Backout
• Enterprise Manager Log Miner Interface
• Flashback Data Archive
• Oracle Total Recall
Session 20: DIAGNOSTICS NEW FEATURES
• Oracle Database 11g Fault Diagnostic Automation
• Automatic Diagnostic Workflow
• Problems and Incidents
• Incident Packaging Service
• EM Support Workbench Overview
Session 21: PERFORMANCE TUNING NEW FEATURES
• Rule Based Optimizer Obsolescence
• Automatic Statistics Collection
• Improved Statistics Gathering
• Direct SGA Access
• Application and SQL Tuning
• SQL Tuning Advisor
• SQL Access Advisor
• Real-Time SQL Monitoring
• View the SQL Monitoring Report
• SQL Performance Analyzer
• Intelligent Cursor Sharing
• SQL Plan Management
• Temporary Tablespace Shrink
• Test Case Builder
• New Hints
• View Session Details
Session 22: DATA WAREHOUSE AND BI NEW FEATURES
• Partitioning Enhancements
• Materialized View and Query Rewrite Enhancements
• The PIVOT and UNPIVOT Clauses
• Data Compression
• Parallel Query New Features
• Resource Manager New Features
The delegate will practise:
• Installing Oracle Database 11g Release 2 Software
• Creating an Oracle Database using New Features
• Using the New Enterprise Manager
• Proactively Monitoring with Database Advisors
• Using New Memory Management Features
• Using New Data Storage Features
• Using New Space Management Features
• Using New Optimizer and Index Features
• Using New SQL and PL/SQL Features
• Using the Data Pump Utility
• Using New Backup and Recovery Features
• Using New Availability Features
• Using New Security Features
• Automating Tasks with the New Scheduler
• Using Real Application Testing
• Using Database Replay to Capture, Process and Replay Workloads
• Using the Data Recovery Advisor and Flashback
• Managing Transactions using Flashback and LogMiner
• Using Performance Tuning New Features
• Implementing New Schema Management Functionality
Who will the Course Benefit?
This Oracle Database 11g Release 2 for Experienced 9i Database Administrators will benefit Database administrators, who need to update their current Oracle 9i skills to create, administer, monitor, backup and support Oracle Database 11g Release 1 and Release 2.
Course Contents - DAY 1
Course Introduction
• Administration and Course Materials
• Course Structure and Agenda
• Delegate and Trainer Introductions
Session 1: NEW MANAGEMENT FEATURES
• Log File Changes
• Parameter File Management Changes
• Automatic Diagnostic Repository
• ADRCI Command Line Tool
• New Memory Management Features
• Memory Advisor Views
• New Management Parameters
Session 2: INSTALLING ORACLE DATABASE 11g
• System Hardware requirements
• Overview of Oracle Grid Infrastructure
• Installing Oracle Database 11g Release 2
• The Database Configuration Assistant
• Database Templates
• Online Patching
Session 3: UPGRADING TO ORACLE DATABASE 11g
• Upgrading to Oracle Database 11g Release 1 and 2
• Upgrade the Time Zone File and Timestamp with Timezone Date
• Oracle Parameter Changes
• Altered Parameter Behaviour
• Online Dictionary View Changes
Session 4: ADMINISTER A DATABASE
• Administrative Tools Available to a DBA
• Use Oracle Enterprise Manager to Manage a Database
• Stop and Start the EM Database Console
• Access Oracle Enterprise Manager
• Grant EM Administrative Privileges
• Control Oracle Restart
• Use the srvctl Utility
• Manually Add Components to the Oracle Restart Configuration
Session 5: NEW DATABASE STORAGE FEATURES
• Default Permanent Tablespace
• Rename a Tablespace
• The SYSAUX Tablespace
• Copy Files Using the Database Server
• Drop an Empty Datafile
• Tablespace Monitoring
• Segment Management Enhancements
• Segment Advisor
• Segment Resource Estimation
• On Line Segment Shrink
• Proactive Tablespace Management
• Automatic Undo Retention
• Table Compression
• Hybrid Columnar Compression
• Segment Creation on Demand
________________________________________
Course Contents - DAY 2
Session 6: SECURITY ENHANCEMENTS
• Connect Role Change
• Default Passwords
• Automatic Secure Configurations
• Case Sensitive Passwords
• Profiles and the Password Verify Function
• Virtual Private Database Enhancements
• Auditing Enhancements
• OS Audit in XML Format
• Uniform Audit Trail
• Default Auditing in Oracle Database 11g
• Tablespace Master Key Re-key
• DBMS_CRYPTO
• Transparent Data Encryption
• Transparent Tablespace Encryption
• Data Masking
• Security and OEM
Session 7: AUTOMATIC DATABASE MANAGEMENT
• Automatic Workload Repository
• AWR 11g New Features
• Automatic Database Diagnostic Monitor
• ADDM 11g New Features
• ADDM Reports
• DBMS_ADVISOR Reports
• DBMS_ADVISOR Views
• Alerts
Session 8: AUTOMATING TASKS WITH THE SCHEDULER
• Scheduler Overview
• DBMS_SCHEDULER
• Scheduler Related Parameters
• Access Rights
• Create a Program
• Enable a Program
• Drop a Program
• Create a Schedule
• Create a Job
• Job Classes
• Resource Windows
• Window Group
• Monitoring and Logging
• AutoTask
Session 9: SCHEMA MANAGEMENT NEW FEATURES
• DDL Wait Option
• Add Columns with a Default Value
• Virtual Columns
• Invisible Indexes
• Improved Online Index Creation and Rebuild
• Read Only Tables
Session 10: APPLICATION DEVELOPMENT NEW FEATURES
• Append, Create and Replace Extensions to Spool/Save
• SQL*Plus Errorlog Table
• Lock Table Parameter
• SQL Query Result Cache
• Client Side Result Cache
• PL/SQL Function Cache
________________________________________
Course Contents - DAY 3
Session 11: UTILITIES FOR TROUBLESHOOTING DATA CORRUPTION
• Automatic Block Corruption Reporting
• Automatic Quarantine of Corrupt Undo Segments
• Protection from Data Corruptions
• Improvements to ANALYZE ... VALIDATE STRUCTURE
• Proactive Monitoring with the Health Monitor
Session 12: BACKUP AND RECOVERY NEW FEATURES
• Recovery Through Reset Logs
• Changes to ALTER DATABASE ARCHIVELOG
• Recovery Manager Enhancements
Session 13: DATA RECOVERY ADVISOR
• Overview of Data Recovery Advisor
• Use the Data Recovery Advisor through the RMAN Command Line
• Run Pro-Active Health Checks with the Validate Command
• Use the Data Recovery Advisor through EM
• Automatic Diagnostic Repository
• Data Recovery Advisor Dictionary Views
Session 14: OVERVIEW OF AUTOMATIC STORAGE MANAGEMENT
• Overview of ASM
• ASM Instance Creation
• SYSASM Role
• Administer ASM Disk Groups
• ASM Files
• ASM Startup and Shutdown
• ASM Disk Failure
• ASM Data Dictionary Tables
• Migrate a Database to ASM Using RMAN
• The asmcmd Command Line Interface
• ASM File Access Control
• Use 4KB Sector Disks
________________________________________
Course Contents - DAY 4
Session 15: DATABASE REPLAY
• Overview of Database Replay
• The Database Replay Process
• Capture a Workload
• Pre-process the Captured Workload
• Replay the Workload
• Database Replay Usage
• The DBMS_WORKLOAD Package
Session 16: DATA PUMP
• The exp Utility Deprecated
• Introduction to Data Pump Import and Export
• Data Pump Architecture
• Data Pump Export
• Data Pump Import
• Data Pump Legacy Mode
Session 17: OVERVIEW OF DATA GUARD NEW FEATURES
• Apply Redo in Real Time
• Redo Transmission Enhancements
• New Standby Database Parameters
• ARCH Process Writes to Standby Redo Logs
• Changes to Standby Database Startups
• Logical Standby Database Enhancements
• Fast Start Failover Enhancements
• Archive Redo Log Compression
• Lost Write Detection
• Real Time Query Capable Physical Standby Database
• Rolling Upgrades to Physical Standby
• SQL Apply Logical Standby
• RMAN and Data Guard
• Snapshot Standby Databases
• Clone a Running Database
• Active Database Duplication
• Oracle Active Data Guard
• Real Time Query
• Block Change Tracking on a Physical Standby Database
Session 18: ORACLE DATABASE ADVISORS
• Repair Advisors and Fault Diagnostics
• The SQL Repair Advisor
• The SQL Access Advisor
• The Streams Performance Advisor
• The Advisor Views
________________________________________
Course Contents - DAY 5
Session 19: FLASHBACK TECHNOLOGY
• Flashback Query
• Flashback Version Query
• Flashback Table
• Flashback Transaction Query
• Flashback Drop
• Flashback Database
• Flashback Restore Points
• Flashback Transaction Backout
• Enterprise Manager Log Miner Interface
• Flashback Data Archive
• Oracle Total Recall
Session 20: DIAGNOSTICS NEW FEATURES
• Oracle Database 11g Fault Diagnostic Automation
• Automatic Diagnostic Workflow
• Problems and Incidents
• Incident Packaging Service
• EM Support Workbench Overview
Session 21: PERFORMANCE TUNING NEW FEATURES
• Rule Based Optimizer Obsolescence
• Automatic Statistics Collection
• Improved Statistics Gathering
• Direct SGA Access
• Application and SQL Tuning
• SQL Tuning Advisor
• SQL Access Advisor
• Real-Time SQL Monitoring
• View the SQL Monitoring Report
• SQL Performance Analyzer
• Intelligent Cursor Sharing
• SQL Plan Management
• Temporary Tablespace Shrink
• Test Case Builder
• New Hints
• View Session Details
Session 22: DATA WAREHOUSE AND BI NEW FEATURES
• Partitioning Enhancements
• Materialized View and Query Rewrite Enhancements
• The PIVOT and UNPIVOT Clauses
• Data Compression
• Parallel Query New Features
• Resource Manager New Features
Do you need clarification regarding the course program?
Contact the person in charge , free and at no obligation, for information on how to enroll, enrollment limit/availability and more.
Course location
- c/o YSES, The Enterprise Suite, 9th Floor Centre City Tower, 5-7 Hill Street, Birmingham B5 4UA - B5 4UACity and Borough of Birmingham (England)
- c/o ComputerWorld, Apex House, Westerleigh Business Park, Turner Drive, Yate, Bristol, BS37 5YX - BS37 5YCity of Bristol (England)
- 16 St Mary's Street, Edinburgh, EH1 1SU - EH1 1SUCity of Edinburgh (Scotland)
- Halsbury House, Chancellor Court, 21 The Calls, Leeds, LS2 7EH - LS2 7EHCity and Borough of Leeds (England)
- c/o YSES, St James Court, 30 Brown Street, Manchester, M2 1DH - M2 1DHCity and Borough of Manchester (England)
StayAhead Training
StayAhead Training established 1992, centres throughout the UK...... with a team of full time dedicated professional training consultants......
StayAhead Training has been established since 1992 and is one of the UK's leading independent providers of Oracle, Unix, Linux, MySQL, Java, PHP Web Deveopment, ITIL & Business Analysis training.
Scheduled courses are available in 6 centres throughout the UK including London, Birmingham, Manchester, Bristol, Leeds and Edinburgh. We also provide training on our client's premises, this training can be tailored to the specific needs of the client.
Our courses have been designed to ensure that people can fulfil their job role and also help prepare delegates for certification in Oracle, Red Hat, Solaris, MySQL, Linux, SUSE Linux, Java, ITIL, Business Analysis and HP-UX .
Working in association with both the Oracle (OUG) and Hewlett Packard (HPUG) User Groups, StayAhead Training have a reputation of providing high quality value for money training at a cost effective price.
Our quality is assured by a team of dedicated professional training consultants who work full time for StayAhead Training and who blend their training skills with a wealth of hands-on experience.
StayAhead Training has been established since 1992 and is one of the UK's leading independent providers of Oracle, Unix, Linux, MySQL, Java, PHP Web Deveopment, ITIL & Business Analysis training.
Scheduled courses are available in 6 centres throughout the UK including London, Birmingham, Manchester, Bristol, Leeds and Edinburgh. We also provide training on our client's premises, this training can be tailored to the specific needs of the client.
Our courses have been designed to ensure that people can fulfil their job role and also help prepare delegates for certification in Oracle, Red Hat, Solaris, MySQL, Linux, SUSE Linux, Java, ITIL, Business Analysis and HP-UX .
Working in association with both the Oracle (OUG) and Hewlett Packard (HPUG) User Groups, StayAhead Training have a reputation of providing high quality value for money training at a cost effective price.
Our quality is assured by a team of dedicated professional training consultants who work full time for StayAhead Training and who blend their training skills with a wealth of hands-on experience.