Oracle 11g New Features Training Workshop – ORA500
This four day workshop will get students hands-on with all of the important new Oracle 11g features they will need. Students will start with upgrades and downgrades and move on to real application testing, diagnosability and failure repair. DBA features for memory management, flashback, tables, and new Enterprise Manager tabs will then be covered. The course covers new performance and security features, backup, recovery, and data pump changes. Students will also work with several ASM and data warehousing changes.
Oracle 11g New Features Workshop – ORA500 – 4 Days Request a Class Date
This four day workshop will get students hands-on with all of the important new Oracle 11g features they will need. Students will start with upgrades and downgrades and move on to real application testing, diagnosability and failure repair. DBA features for memory management, flashback, tables, and new Enterprise Manager tabs will then be covered. The course covers new performance and security features, backup, recovery, and data pump changes. Students will also work with several ASM and data warehousing changes. – See more at: https://www.fireboxtraining.com/oracle-11g-new-features-workshop#sthash.eSLL5CYX.dpuf
Course ID: ORA500
Duration: 4 days
Audience: Oracle 10g database administrators.
There are twenty-one hands-on lab exercises for lots of practice opportunities. Please note that the workbook for this Oracle training course is a companion book to “Oracle Database 11g: New Features for DBAs and Developers.” This textbook is necessary to run the Oracle 11g New Features Workshop; the Instructor Workbook makes specific use of the examples and materials presented in the aforementioned textbook.
Oracle 11g New Features Workshop Training Course – ORA500
Topics Covered in Oracle 11g New Features Workshop Training:
Installing, Upgrading, and Managing Change
- Preinstallation
- Oracle Database 11g Installation
- Database Creation New Features
- Documentation Format
- Upgrading to Oracle Database 11g
- Upgrading with the DBUA
- Downgrading
- Real Application Testing
- Real Application Testing – Capture/Playback
- Real Application Testing – Analysis
Database Diagnosability and Failure Repair
- The Oracle Fault Infrastructure
- ADRCI Command Interpreter
- Recovery Advisors
- Data Corruption
Database Administration
- Memory Management
- Manual Memory Management
- Automated Maintenance Tasks
- Flashback Data Archive
- New DDL Features
- New Index and Table Features
- DB Administration Features
- Miscellaneous New Features
- Advanced Table Compression
- New OEM Features
Performance Management
- SQL and PL/SQL Performance Enhancements
- SQL and PL/SQL Performance
- Adaptive Cursor Sharing
- Result Caching
- Automatic SQL Tuning
- Optimizer Statistics
- OEM Enhancements
Database Security
- Database Security
- Enhanced Default Security
- Password Enhancements
- Tablespace Encryption
- UTL_* Networking Packages
Backup and Recovery
- RMAN Enhancements
- Multisection Backups
- Backup Management
- Active Database Duplication
- Recovery Catalog Management
Data Pump
- Data Pump Enhancements
- Compression and Dump Files
- Remapping Data
- Partition Export/Import
- Ignoring Errors, External Tables
Storage Management and ASM
- General ASM Knowledge
- Storage Management and ASM
- ASM Upgrade
- ASM Preferred Reads
- The ASMCMD Command-Line Tools
- ASMCMD Commands
- Metadata Backup and Restore
- MD_BACKUP and MD_RESTORE
- Oracle Direct NFS
Application Development
- New PL/SQL Features
- Subprogram Call Enhancements
- Trigger Enhancements
- XMLDB Enhancements
- APEX – Application Express
Data Warehousing
- Next-Generation LOBs (SecureFiles)
- Using SecureFiles
- DB_SECUREFILE Parameter
- Partition Change Tracking
- Pivot Operators
- Partitioning
- Extended Composite Partitioning
- Virtual Column and System Partitioning