BC Upgrading to Oracle 11g Class
May 8-16, 2015

The world's best Oracle training comes from practicing Oracle consultants, real Oracle experts and authors who combine years of experience with outstanding communications skills.  The problem is that the top Oracle experts are busy working with mission critical databases and rarely do public training. 

About the Oracle 11g training

The first day of class begins in Port Canaveral on May 8, 2015 and concludes on May 16, 2015.   To book your seat, simply call 800-766-1884.  This advanced Oracle DBA training features one-on-one personal interaction and this class is created specifically for the needs of DBAs and technical managers:

Upgrading to Oracle11g

Copyright � 2007-2010 by Burleson Consulting

New Features for Database Creation and Deletion   �        SYSAUX Tablespace �        Automated Storage Management Configuration �        Automated RAC Services Configuration �        Simplified Upgrade for RAC and OPS Databases �        Drop Database   Database Tuning and Performance Improvements   Database Resource Manager Improvements   �        Database Resource Manager Overview �        Adaptive Consumer Group Mapping �        Fixed CPU Quota �        Integration of Resource Manager and Profiles   Tuning Improvements   �        Buffer Cache Flushing - User Initiated �        Automated Checkpoint Tuning �        CPU Costing �        Dynamic Sampling   Tuning Transaction Recovery   �        Easy Transaction Recovery Monitoring   Oracle Enterprise Manager Changes   �        Overview of the changes �        SQL Reporting �        New Performance Overview Charts   Single-Set Aggregates in DML Returning Clause   New and Updated Optimizer Hints   Wait Model Improvements   �        Overview of enhancements �        Changes and updates   Application Tuning   �        Overview of improvements �        SQL Access Advisor �        Materialized View Tuning API - The new            TUNE_MVIEW API   New Static Data Dictionary Views   �        Overview �        List of Views and Explanation   New Dynamic Performance Views   �        Overview �        List of Views   Static data dictionary views have new columns   Dynamic performance views have new columns     Oracle11g New Features for Tablespace Management   Temporary Tablespace   �        Temporary Tablespace Group Overview �        Temporary Tablespace Group Benefits �        Examples   Rename Tablespace   �        Tablespace Rename Overview �        Tablespace Rename Benefits �        Examples   Bigfile Tablespace   �        Bigfile Tablespace Overview �        Bigfile Tablespace Benefits �        Extended ROWID Format �        Examples   Automated Storage Management (ASM)   �        Automated Storage Management Overview �        Automated Storage Management Benefits �        ASM Disk Group �        ASM Disk �        ASM Files �        ASM Instance   New Oracle11g Table and Index Features   Creating a Sorted Hash Cluster   �        Benefits �        Examples   Partitioning Improvement   �        Overview of Improvements in Partitioning �        Global Partitioned Indexes - Hash Partitioning �        Enhancements for Partitioned Index-Organized Tables    - List Partitioning    - LOB Support    - Global Index Maintenance �        Local Partitioned Indexes Manageability Improvements �        Enhanced Partition Management in Enterprise Manager   Enhanced Bitmap Index Performance and Space Management

New Oracle11g DML Features: Insert, Update and Delete   Single-Set Aggregates in DML Returning Clause Upsert through SQL Interrow Calculations   New Oracle11g SELECT features   SQLAccess Advisor Materialized View Tuning API Grouped Table Outer Join Increased Number of Aggregates per Query SQL Interrow Calculations Remote Stored Functions in SELECT Statements Native Net Over Fast Interconnects Native Net Over TCP/IP Case-Insensitive and Accent-Insensitive Query and Sort Enhanced Collections Enhanced CONNECT BY Support Oracle Expression Filter SQL Regular Row Timestamp     Improved Features: MERGE, EXTERNAL TABLES, MINSERT   Asynchronous Change Data Cross-Platform Transportable Tablespaces Enhanced Table Functions External Tables Unload Enhanced MERGE Functionality     New Oracle11g Initialization Parameters   Type of Initialization Parameters Twenty New Parameters             CREATE_STORED_OUTLINES             DB_ALLOWED_LOGIN_VERSION             DB_FLASHBACK_RETENTION_TARGET             DB_RECOVERY_FILE_DEST             DB_RECOVERY_FILE_DEST_SIZE            DDL_WAIT_FOR_LICKS             INSTANCE_TYPE             LDAP_DIRECTORY_ACCESS             LOG_ARCHIVE_CONFIG            OSM_DISK_REPARIR_TIME            OSM_DISKGROUPS            OSM_DISKSTRING            OSM_POWER_LIMIT             PLSQL_OPTIMIZE_LEVEL             PLSQL_WARNINGS             RESUMABLE_TIMEOUT             SKIP_UNUSABLE_INDESES              SMTP_OUT_SERVER              SP_NAME             STREAMS_POOL_SIZE     New Oracle11g Management Features   Database Startup and Shutdown   �        Overview of enhancements �        Database Automated Startup and Shutdown Configuration   Database Install   �        Simplified Database Install   Improvements in Auditing   �        Uniform Audit Trail �        Extended SQL Support in FGA   Easier Database Registration   Unified User Model     New Oracle11g Network Features   Database Authentication with Standard LDAP Password Verifiers Single Station Administration for Password Authentication to Oracle Database SSL Session Renegotiation Performance Improvements 4096-Bit Key Size Support     Oracle11g Backup and Recovery New Features   Extended Flashback Functions   �        Flashback Database �        Flashback Standby Database �        Flashback Re-instantiation �        Flashback Drop �        Flashback Table �        Flashback Row History �        Flashback Transaction History   RMAN Enhancements   �        Automated Channel Failover for Backup and Restore �        Automated File Creation During Recovery �        Simplified Backups to Disk �        Simplified Recovery Manager Cataloging of Backup Files

About your instructors

Only once per year, Burleson Consulting offers a public training class, a rare opportunity to learn the secrets of Oracle from some of the world's most highly regarded Oracle experts and authors, people who have managed some of the world's largest and complex databases.

Donald K. Burleson is one of the world's best known Oracle experts and authors.  A retired Adjunct Professor Emeritus, Burleson has more than 20 years of full-time DBA experience, authored 32 Oracle database books, written over 100 Oracle articles, and serves as Editor-in-Chief of Rampant TechPress. 

BC has some of the top Oracle experts in the world, and this is a not-to-miss class with expert advise for working DBA professionals.  Unlike traditional Oracle DBA training, the BC Oracle DBA training is taught by practicing Oracle DBA consultants with decades of hands-on, real-world experience.

The BC Oracle DBA training is better quality training at an even better price.  With course costs of $1,995 (with discounts for multiple attendees) plus travel and expenses, the BC Oracle training is far less expensive than a traditional DBA class, with an unparalleled intimate learning experience.