Oracle Database 11g Release 2 for Experienced 10g Database Administrators
|
Summary
|
|
||||||||||||||||
Oracle Database 11g Release 2 for Experienced 10g Database Administ...
This Oracle Database 11g Release 2 for Experienced 10g Database Administrators course is designed to provide the knowledge and skills needed to maintain successful and efficient day-to-day operation of Oracle Database 11g Release 1 and Release 2. The Oracle Database 11g Release 2 for Experienced 10g Database Administrators course will give experienced Oracle database administrators practical experience in installing, configuring, administering and implementing an Oracle Database 11g Release 2. Database administrators will gain a practical understanding of the new features of Oracle Database 11g Release 2 and how these can be implemented in their current Oracle installations.
The delegate will practise:
- Installing Oracle Database 11g Release 2 Software
- Creating an Oracle Database Using New Features
- Using SQL and PL/SQL New Features
- Using New Memory Management Features
- Using Real Application Testing
- Using Database Replay to Capture, Process and Replay Workloads
- Using the Data Recovery Advisor and Flashback
- Using Transaction Management using Flashback and LogMiner
- Using RMAN New Features
- Using Data Pump Data Compression
- Using Performance Tuning New Features
- Using New Security Features
- Using New Schema Management Functionality
- Using AutoTask
- Using Data Warehouse and BI New Features
This Oracle Database 11g Release 2 for Experienced 10g Database Administrators course is designed for experienced Oracle 10g database administrators and technical support staff.
This Oracle Database 11g Release 2 for Experienced 10g Database Administrators course is designed to provide the skills needed install, upgrade, implement and support Oracle Database 11g Release 1 and Release 2.
Database administrators 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.
The Oracle Database 11g Release 2 for Experienced 10g Database Administrators course covers the major topics required for the Oracle examination IZO-050: Oracle Database 11g: New Features for Administrators.
Before taking any exam, ensure you have the recommended experience. The Oracle website lists all exam requirements and these are updated regularly.
Exams are not included as part of the course.
Delegates who wish to attend this Oracle Database 11g Release 2 for Experienced 10g Database Administrators course should have good understanding of Oracle Database 10g administration.
- Oracle 11g SQL Performance Tuning
- Oracle 10g Application Server Administration
NOTE: Course technical content is subject to change without notice.
- Administration and Course Materials
- Course Structure and Agenda
- Delegate and Trainer Introductions
- Log File Changes
- Parameter File Management Changes
- Automatic Diagnostic Repository
- ADRCI Command Line Tool
- Automatic Memory Management
- Memory Advisor Views
- New Management Parameters
- Install Oracle Database 11g
- Deinstall Oracle Database 11g
- The Database Configuration Assistant
- Online Patching
- Upgrading to Oracle Database 11g Release 1 and 2
- Upgrade the Time Zone File and Timestamp with Timezone Date
- Oracle Parameter Changes
- Online Dictionary View Changes
- Control Oracle Restart
- Use the srvctl Utility
- Manually Add Components to the Oracle Restart Configuration
- Automatic Secure Configurations
- Default Passwords
- Case Sensitive Passwords
- Profiles and the Password Verify Function
- Default Auditing
- Tablespace Master Key Re-key
- Transparent Tablespace Encryption
- Data Masking
- Oracle SecureFile LOBs
- Access Control Lists on Network Services
- Oracle Secure File Masking
- Security and OEM
- Use 4KB Sector Disks
- Table Compression
- Hybrid Columnar Compression
- Segment Creation on Demand
- ADDM New Features
- ADDM New Views
- ADDM for RAC
- Manage ADDM through DBMS_ADDM
- Find Classifications
- Directives
- AWR New Features
- Altered Retention of AWR Snapshots
- AWR Baseline New Features
- Adaptive Metric Thresholds
- Scheduler Automated Maintenance Tasks
- Auto Task Architecture
- Auto Task Dictionary Views
- Use OEM to Manage Auto Task
- Manage Auto Task Manually
- The Auto Task Maintenance Windows
- DDL Wait Option
- Add Columns with a Default Value
- Virtual Columns
- Improved Online Index Creation and rebuild
- Invisible Indexes
- Read Only Tables
- SQL
- New SQL*Plus Commands
- Lock Table Parameter
- Client Side Result Cache
- Server Result Cache
- Use Table Automation to Control Result Caching
- Regular Expression Enhancements
- Named Notation
- PL/SQL
- PL/SQL Function Cache
- Automatic Subprogram Inlining
- PL/SQL Scope
- PL/SQL Native Compilation
- Dynamic SQL in PL/SQL
- Dynamic SQL and REF Cursors
- Trigger Enhancements
- Simple Integer Datatype
- PL/SQL CONTINUE Statement
- Natural Sequences
- Automatic Block Corruption Reporting
- Automatic Quarantine of Corrupt Redo Segments
- Protection from Data Corruption
- Improvements to Analyze Validate Structure
- Proactive Monitoring with the Health Monitor
- Automatic Channel Failover
- Parallel Backups
- Compressed Backups
- Improved Handling of Long Term Backups
- Backup Failover of Archived Redo Logs
- Archived Redo Log Deletion Policy
- Undo Backup Optimization
- Improved Block Media Recovery
- Stored Scripts with Substitution Values
- Virtual Private Catalogs
- Merge Catalogs
- Backup up Catalogs
- Active Database Duplication
- TSPITR Enhancements and Modifications
- Overview of the Data Recovery Advisor
- Use the Data Recovery Advisor through OEM
- Use the Data Recovery Advisor through the RMAN Command Line
- Proactive Health Checks with the Validate Command
- Data Recovery Advisor Dictionary Views
- Flashback Transaction Backout
- Flashback Transaction Wizard
- Enterprise Manager Log Miner Interface
- Oracle Total Recall
- Flashback Data Archive Overview
- Flashback Data Archive Architecture
- Flashback Data Archive Workflow
- Overview of Database Replay
- The Database Replay Process
- Capture Workload
- PreProcess the Captured Workload
- Replay Workload
- Database Replay Usage
- The DBMS_Workload Package
- Dump File Set Compression
- Encryption Enhancements
- Data Remapping
- Rename Table
- Dump File Overwrite
- Partitioned Tables
- The Transportable Parameter
- The Data_Options Parameter
- The exp Utility Deprecated
- Data Pump Legacy Mode
- Compression of Archived Redo Logs
- Lost Write Detection
- Higher Availability with Fast Start Failover Enhancements
- Real Time Query Capable Physical Standby Database
- Rolling Upgrades to Physical Standby
- Block Change Tracking on a Physical Standby Database
- SQL Apply Logical Standby
- RMAN and Data Guard
- Snapshot Standby Database
- Clone a Running Database
- Oracle Active Data Guard
- Real Time Query Apply Lag Time
- Repair Advisors and Fault Diagnostics
- The SQL Repair Advisor
- The SQL Access Advisor
- The Streams Performance Advisor
- The Advisor Views
- SYSASM Role
- Disk Group Attributes
- Fast Disk Resync
- Preferred Mirror Read
- Compatibility Settings
- ASM Support for Variable Allocation Unit Sizes
- Drop Diskgroup Force
- The asmcmd Command Line Interface
- New ASM Documentation
- Oracle Database 11g Release 2 New Features
- Oracle Database 11g Fault Diagnostic Automation
- Automatic Diagnostic Workflow
- Problems and Incidents
- Incident Packaging Service
- Temporary Tablespace Shrink
- EM Support Workbench Overview
- Improved Statistics Gathering
- Real-Time SQL Monitoring
- Monitoring and Tuning usage model
- Setting up Notification rules
- Using the Advisors
- The SQL Performance Analyzer
- Automatic SQL Tuning
- Manual Creating and Use of SQL Tuning Sets
- Intelligent Cursor Sharing
- SQL Plan Management
- Temporary Tablespace Shrink
- Test Case Builder
- SQL Monitoring in Oracle Database 11g R2
- View Session Details
- View the SQL Monitoring Report
- Partitioning Enhancements
- Data Pump Single-Partition Imports
- Materialized Views and Query Rewrite Enhancements
- The PIVOT and UNPIVOT Clauses
- Data Compression
- Enhancements to the Degree of Parallelism
- In Memory Parallel Query
- System Managed Indexes for List Partitioning
- I/O Calibration
- Default Maintenance Plan
- Built-In Resource Plans
- Resource Manager Statistics in AWR
- Resource Manager Plan Directive New Features
- Instance Caging
If you want to find out more about Oracle Database 11g Release 2 for Experienced 10g Database Administrators, you can make an information request below and the school will contact you with further information.
Expenses
StayAhead Training
StayAhead Training - SQL, Oracle, UNIX and Linux training courses delivered by IT experts
StayAhead Training are recognised as one of the top 50 IT Training organisations in the UK and the first choice provider of UNIX, Linux, MySQL and Oracle training courses for many of the UK's most prominent organisations.
StayAhead Training was established in 1992 and now have training centres in London, Birmingham, Manchester, Leeds, Edinburgh and Bristol. Because of this, StayAhead are able to offer a large range of scheduled, tailored and onsite training. Independent of where you are based, StayAhead can help you and your firm's IT requirements be reality.
Specialist IT training for professionals
StayAhead Training have a formidable reputation for quality and expertise within the UNIX, Oracle, Linux and MySQL arena.
UNIX training courses not only covers standard UNIX but includes a range of Solaris, AIX, HP-UX, Linux, SUSE, LPI & Red Hat Linux training. The Oracle training courses also have depth with courses available for DBAs, Developers and Designers. If certification is important to you then again we do not disappoint taking delegates to the level required to take the examinations in Solaris, Red Hat, SUSE, LPI, MySQL, Oracle Forms Developer and Oracle DBA. With the Oracle e-business suite growing in popularity a range of Oracle Financials courses are also available.
In-house Professional IT training for your organisation
In addition to the public schedule of courses provided, StayAhead offer all courses in-house at a client's site, or at a StayAhead location. All courses can be tailored to meet our clients' specific needs. For courses at the client's site StayAhead can provide all the necessary hardware and software.
StayAhead's focus on IT training
StayAhead understands the best approach for such technical IT training is always to be enthusiastic, business-like, informal yet professional. StayAhead's style of delivery is designed to foster the development of learning. Instructor led tutorials are followed by practical exercises. The style is experiential allowing delegates to take ownership and solve problems for themselves. Research shows that the pace of learning is greatly accelerated when delegates are shown HOW to solve their problems rather than just why they should.
Show all courses with
StayAhead Training
Request information - obligation free
Contact information for StayAhead Training
Phone no: +44 (0)20 7600 6116 
To request information from Oracle Database 11g Release 2 for Experienced 10g Database Administrators, please fill out the following details:
