Home    |    Instructor-led Training    |    Online Training     
         
 
Courses
ADA
Adobe
Agile
AJAX
Android
Apache
AutoCAD
Big Data
BlockChain
Business Analysis
Business Intelligence
Business Objects
Business Skills
C/C++/Go programming
Cisco
Citrix
Cloud Computing
COBOL
Cognos
ColdFusion
COM/COM+
CompTIA
CORBA
CRM
Crystal Reports
Data Science
Datawarehousing
DB2
Desktop Application Software
DevOps
DNS
Embedded Systems
Google Web Toolkit (GWT)
IPhone
ITIL
Java
JBoss
LDAP
Leadership Development
Lotus
Machine learning/AI
Macintosh
Mainframe programming
Mobile
MultiMedia and design
.NET
NetApp
Networking
New Manager Development
Object oriented analysis and design
OpenVMS
Oracle
Oracle VM
Perl
PHP
PostgreSQL
PowerBuilder
Professional Soft Skills Workshops
Project Management
Rational
Ruby
Sales Performance
SAP
SAS
Security
SharePoint
SOA
Software quality and tools
SQL Server
Sybase
Symantec
Telecommunications
Teradata
Tivoli
Tomcat
Unix/Linux/Solaris/AIX/
HP-UX
Unisys Mainframe
Visual Basic
Visual Foxpro
VMware
Web Development
WebLogic
WebSphere
Websphere MQ (MQSeries)
Windows programming
XML
XML Web Services
Other
Oracle Database 11g: New & Advanced Features For Developers
Oracle Training Overview

This Oracle 11g courseware training guide book will present some of the most advanced features available to database developers.

Oracle Training Course Objectives

Many of the new features are either newly available with the Oracle 11g release or have been substantially improved with that release. Among the specific subjects presented in this course are:
  • Creating and using directory objects within the database.
  • A comprehensive look at all index types available when building an application schema, including B-tree internals, function-based, compressed, reverse key, invisible, linguistic, bitmap and bitmap join indexes.
  • A comprehensive look at all table types available when building an application schema, including heap-organized tables, index clusters, hash clusters, index-organized tables, external tables, temporary tables, read-only and compressed tables.
  • Advanced SQL hierarchal data processing capabilities available from the CONNECT BY PRIOR and related language structures.
  • Enhanced SQL and transactional capabilities, including asynchronous commits, DML error trapping and use of regular expressions.
  • How to use the result cache to achieve dramatic performance improvement for frequently executed SQL queries and PL/SQL functions.
  • Enhancements to the PL/SQL programming language and coding capabilities.
  • New and advanced SQL language application development capabilities.
  • Review the goals of change management, change assurance and how these are implemented with Real Application Testing technology available with the Oracle 11g database. An entire volume has been dedicated to Real Application Testing
  • Learn how to perform the capture of a production database workload while not interfering with the applications or users involved.
  • Learn how to replay the production workload on a test database configuration, providing a real-world test of how an actual application will function in an envisioned database configuration.
  • Learn how to configure clients which will simulate the network interaction of real-world users in a test configuration.
  • Perform a detailed analysis of application execution within proposed database configurations to assess whether the application performance will progress or regress as a result of the proposed change.
  • Use the SQL Performance Analyzer tool to measure progression or regression of individual SQL statements under a proposed database configuration, providing a detailed level of change assurance before the change ever occurs.
Oracle Training Audience

The target audience for this course is senior application developers. Using these features one can rely upon less-frequently used database options to extend the capabilities and flexibility of business applications. Prerequisites

The following courses are mandatory prerequisites:
  • ORACLE DATABASE 11g: INTRODUCTION TO SQL – COMPLETE LIBRARY
  • ORACLE DATABASE 11g: PROGRAM WITH PL/SQL – COMPLETE LIBRARY
Oracle Training Course duration

5 Days

Oracle Training Course outline

MOVING DATA: EXPORT & IMPORT
  • MANAGE DIRECTORY OBJECTS
  • ABOUT THE DATA PUMP ARCHITECTURE
  • DATA PUMP EXPORT
  • DATA PUMP IMPORT
SECURITY ENHANCEMENTS
  • TRANSPARENT DATA ENCRYPTION
  • What Is A Database Wallet?
  • TDE Encryption Algorithms
  • COLUMN ENCRYPTION
ORACLE SECUREFILES
  • LOB CONCEPTS & TERMINOLOGY
  • BASICFILES LOB
  • Table DDL With LOBs
  • Controlling LOB Physical Storage
  • Initialize Internal LOBs
  • Initialize External LOBs
  • LOB Columns & SQL
  • SECUREFILES LOBS
  • MIGRATING BASICFILES TO SECUREFILES
INDEXES WITHIN THE APPLICATION SCHEMA
  • B-TREE INDEXES
  • Indexes & Performance
  • Rebuild & Coalesce Indexes
  • Creating Very Large Indexes
  • Data Dictionary Storage
  • FUNCTION-BASED INDEXES
  • COMPRESSED INDEXES
  • REVERSE-KEY INDEXES
  • BITMAP INDEXES
  • BITMAP JOIN INDEXES
  • LINGUISTIC INDEXES
  • INVISIBLE INDEXES
ADVANCED TABLES: CLUSTERS & IOTS
  • ABOUT INDEX CLUSTERS
  • ABOUT HASH CLUSTERS
  • ABOUT INDEX-ORGANIZED TABLES
  • Defining Index-Organized Tables
ADVANCED TABLES: EXTERNAL TABLES
  • ABOUT EXTERNAL TABLES
  • Creating The Table
  • ORACLE_LOADER ACCESS PARAMETERS
  • The General Access Parameters
  • Access Parameters Which Define Fields
  • Performance Considerations
  • ORACLE_DATAPUMP ACCESS DRIVER
  • MANAGING EXTERNAL TABLE PROPERTIES
ADVANCED TABLES: SPECIALIZED TABLES
  • TEMPORARY TABLES
  • COMPRESSED TABLES
  • READ-ONLY TABLES
  • COLUMN DEFAULT VALUES
  • VIRTUAL COLUMNS
  • UNUSED COLUMNS
PROCESSING HIERARCHIES
  • WHY WE NEED HIERARCHIES
  • PROCESSING 1:N HIERARCHIES
  • Oracle-Specific Form
  • ANSI/ISO Standard SQL Form
  • PROCESSING M:N HIERARCHIES
  • Bill-of-materials (Explosion & Implosion)
  • More Explosion Examples
  • More Implosion Examples
  • ADVANCED HIERARCHY PROCESSING
USING THE DATABASE RESULT CACHE
  • ABOUT THE RESULT CACHE
  • CONFIGURING THE RESULT CACHE
  • RESULT_CACHE_MAX_SIZE
  • RESULT_CACHE_MODE
  • RESULT_CACHE_MAX_RESULT
  • RESULT_CACHE_REMOTE_EXPIRATION
  • USING THE RESULT CACHE
  • MANAGING & MONITORING RESULT CACHE
  • Managing The Cache With DBMS_RESULT_CACHE()
  • Monitoring The Cache With The System Views
SQL NEW & ADVANCED FEATURES
  • ASYNCHRONOUS COMMIT OPTIONS
  • HANDLING DML ERRORS
  • INFLUENCING LOCKING BEHAVIOR
  • REGULAR EXPRESSIONS
PL/SQL PROGRAMMING ENHANCEMENTS
  • PROGRAM LOGIC ENHANCEMENTS
  • DATABASE-RESIDENT TRIGGERS
  • USING COMPOUND TRIGGERS
EDITION-BASED REDEFINITION
  • WHY ONLINE REDEFINITION?
  • EDITION-BASED ARCHITECTURE
  • IMPLEMENTING EDITIONS
  • USING EDITIONS
REDEFINITION WITH CROSS-EDITION TRIGGERS
  • REDEFINITION THEORETICAL CHALLENGES
  • FORWARD CROSS-EDITION TRIGGERS
  • REVERSE CROSS-EDITION TRIGGERS
  • POST-UPGRADE TASKS
  • Prepare To Transform Legacy Data
  • Transform Legacy Data
  • Retire The Old Application

Please contact your training representative for more details on having this course delivered onsite or online

Training Outlines - the one stop shopping center for IT training.
© Training Outlines All rights reserved