1-800-THE-TREE (1-800-843-8733)
 

Application Development and Tuning for Oracle Databases: Hands-On

 
Course: 492     Type: Hands-On Training     Duration: 5 Days

Quick Enroll    

You Will Learn How To
  • Design and implement efficient applications while incorporating Oracle features
  • Load data into Oracle databases using SQL*Loader or external tables
  • Maintain and secure the database with advanced application techniques
  • Enhance applications with key Oracle-provided packages
  • Improve query performance using the Oracle-provided toolset
  • Tune applications for optimal performance

Course Benefits
Developing efficient, secure, high-performance database applications is essential to the effectiveness of an organization's information structure. In this hands-on course, you gain the skills to create powerful and secure Oracle database applications, and tune them for optimal performance. You learn to load, maintain and secure your valuable data by leveraging advanced application techniques.

Who Should Attend
Developers and others interested in increasing the performance and efficiency of their Oracle database applications. A working knowledge of SQL and PL/SQL as well as experience with a SQL-based RDBMS is assumed.

Hands-On Training
A continuous case study provides experience building and tuning applications, including:
  • Loading data into an Oracle database
  • Managing constraint-based indexes
  • Developing procedures, functions and packages
  • Resolving critical PL/SQL problems
  • Generating optimizer statistics with DBMS_STATS
  • Using performance diagnostic tools
  • Optimizing Oracle applications
  • Implementing tuning techniques
  • Identifying PL/SQL bottlenecks using DBMS_PROFILER

Course 492 Content
Introduction to the Application Environment
The Oracle database environment
  • Reviewing basic architecture concepts
  • Examining existing databases using the Data Dictionary
Database design considerations
  • Designing for performance
  • Managing basic storage structures
  • Storage management issues
Preparing the Database
Maintaining the application schema
  • Managing dependencies
  • Migrating LONG to LOB datatypes
Populating the database
  • Loading data from other sources using SQL*Loader or external tables
  • Writing to external tables using Data Pump
  • Importing other Oracle database content
Maintaining the Database
Applying advanced programming techniques
  • Developing modular code using packages
  • Managing default, serializable and autonomous transactions
  • Resolving potential trigger problems
Securing the database
  • Enforcing security using PL/SQL
  • Implementing row-level security applications
  • Controlling access with Oracle Label Security
Locking and read consistency
  • Implicit vs. explicit locking
  • Avoiding deadlocks
Exploiting Oracle Built-In Packages
Handling other media types
  • Accessing operating system files
  • Programming with LOBs
Automating routine processing
  • Scheduling routines with DBMS_JOB or Oracle Scheduler
  • Starting jobs based on system or application events
Enhancing application capabilities
  • Controlling the application schema with invoker's rights
  • Generating DDL for existing objects
Improving Query Performance
Identifying basic tuning techniques
  • Developing a tuning methodology
  • Planning and managing the tuning process
  • Initialization parameters
Employing tuning tools
  • Running EXPLAIN PLAN and autotrace
  • SQL Trace and TKPROF output
Query tuning techniques
  • Improving subqueries
  • Optimizing join operations
  • Partitioning data to improve access to frequently used data
  • Storing rows in sorted sequence with sorted hash clusters
Deciphering and Controlling the Optimizer
Optimizer concepts
  • Fundamentals of access paths
  • Gathering object and system statistics with DBMS_STATS
  • Managing low-selectivity columns with histograms
Influencing the Optimizer
  • Utilizing hints and optimizer mode
  • Specifying first-rows optimization
  • Determining the driving table
Tuning the Application
Optimizing performance
  • Partitioned, function-based and other indexing options
  • Monitoring index usage
  • Reducing heavy I/O operations
  • Exploring B+Trees
  • Parallel DML
PL/SQL tuning techniques
  • Generating dynamic SQL
  • Binding variables to enable SQL statement reuse

Related Courses
Oracle is a registered trademark of Oracle Corporation.
  
 
Request More Info

Salutation

First Name

Last Name

Company

Zip Code

Country
   Codes
Work Phone

Extension

E-mail

A representative will contact you to follow up your request.
Privacy Statement

Save Up to 40% per course on the Training Passport!

Application Development and Tuning for Oracle Databases: Hands-On
Upcoming Dates
Oct 20 - 24, 2008
 Washington, DC (Reston, VA)
Nov 17 - 21, 2008
 Los Angeles
Dec 15 - 19, 2008
 Ottawa
Jan 12 - 16, 2009
 New York
Feb 9 - 13, 2009
 Toronto
Mar 2 - 6, 2009
 Philadelphia
Mar 16 - 20, 2009
 Washington, DC (Rockville, MD)
Apr 20 - 24, 2009
 Washington, DC (Reston, VA)
Jun 8 - 12, 2009
 New York
Jun 15 - 19, 2009
 Ottawa

Application Development and Tuning for Oracle Databases: Hands-On
Bring Learning Tree On-Site

Course Tuition
$ 3,090 Standard Tuition
Tuition with a Savings Plan
$ 2,250 10-Day Pass
$ 1,670 Training Passport
$ 1,700 Premium-Pass
$ 2,200 Voucher 10-Pack
$ 2,785 Alumni Gold Discount
$ 2,744 Government Discount
 

 

Application Development and Tuning for Oracle Databases: Hands-On
Application Development and Tuning for Oracle Databases: Hands-On
Participants tuning an Oracle database application.
The most recent 100 evaluations scored this course at:

  (3.73/4.00)


Oracle Today


Certification Core Course CPE 29 Credits 2 Hour(s) College Credit
Customer Service or Enroll: 1-800-843-8733