1-800-THE-TREE (1-800-843-8733)
TRAINING YOU CAN TRUST
 
 

Application Development and Tuning for Oracle Databases: Hands-On

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

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

Related Courses

 
Oracle is a registered trademark of Oracle Corporation. 		 

Upcoming Dates

Sep 15 - 19, 2008
 Washington, DC (Rockville, MD)
Sep 22 - 26, 2008
 New York
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
Apr 20 - 24, 2009
 Washington, DC (Reston, VA)
Jun 8 - 12, 2009
 New York

For complete schedule, please visit www.learningtree.com
 
http://www.learningtree.com/courses/492pf.htm
 
 
1-800-THE-TREE (1-800-843-8733)
TRAINING YOU CAN TRUST
 
 

Application Development and Tuning for Oracle Databases: Hands-On

 
Course: 492   Type: Hands-On Training   Duration: 5 Days
 
 
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
 
http://www.learningtree.com/courses/492pf.htm
 
 
1-800-THE-TREE (1-800-843-8733)
TRAINING YOU CAN TRUST
 
 

Application Development and Tuning for Oracle Databases: Hands-On Tuition

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

Course Tuition
$ 2,950 Standard Tuition
Tuition with a Savings Plan
$ 1,580 10-Day Pass
$ 1,665 Training Passport
$ 1,830 Flex-Pass
$ 2,095 Voucher 10-Pack
$ 2,655 Alumni Gold Discount
$ 2,620 Government Discount
 

 

Your Course Tuition Entitles You To...

  • Class participation
  • Team workshops
  • Use of in-class hands-on equipment
  • Comprehensive course materials
  • Morning and afternoon refreshments
  • Course Completion Certificate awarding Continuing Education Units
  • FREE participation in Professional Certification
  • FREE participation in College Credit programs (including related exams)
  
 

Tuition Savings Plans

Training Passport
  • 3 courses in 12 months
  • As little as $1,665 per course
  • Savings as much as 40%
  • Only $4,990
Flex Pass
  • 3 courses in 24 months
  • As little as $1,830 per course
  • Save as much as 35%
10-Day Pass
  • A NEW way to save on training
  • 10 days of training for one person
  • Save as much as $1,070 per course
  • Only $3,950
Training Vouchers
  • Save as much as $960 per course
  • Fully transferable
  • As low as $2,095 per course
Alumni Gold Discount Attend your first course and you'll receive a personalized Alumni Gold Discount card, entitling you to save as much as $295 on each course you take within the following 12 months. Take just one course each year and you'll be entitled to ongoing discounts...year after year!

Your Guarantee of Satisfaction

Unless you feel 100% satisfied that Learning Tree delivered even more than you expected, there is no fee for your course attendance. Our Guarantee of Quality lets you experience the value of the course--and then pay only if you feel the course was well worth the tuition.

Enrolling is Easy and Flexible!

Enroll by phone or online. If your plans change, just let us know and, without a fee, you can transfer to another course or cancel your enrollment. Pay after you've taken the course, and then only if you are 100% satisfied.
 
http://www.learningtree.com/courses/492pf.htm