Type to search LearningTree.com

Do you mean "{{response.correctedQuery}}" ?

Sorry, no results were found for your query.

Please check your spelling and try your search again.

 

Oracle Databases Training









Preferred method of contact?

Application Development and Tuning for Oracle Databases

COURSE TYPE

Practitioner

Course Number

492

Duration

5 Days

Enroll

About This Course: In this hands-on course, you will gain the skills to create powerful and secure Oracle database applications and tune them for optimal performance. Through a continuous case study, you learn to maintain and secure the database with advanced application techniques, load data into Oracle databases using SQL*Loader and improve query performance using the Oracle-provided toolset.

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 techniques
  • Enhance applications with key Oracle-provided packages
  • Improve query performance using the Oracle-provided toolset

Course Outline

  • Introduction to the Application Environment

The Oracle database environment

  • Reviewing basic architecture concepts
  • Examining existing databases using the Data Dictionary

Database design considerations

  • Managing basic storage structures
  • Enhancing performance with optional storage structures
  • Preparing the Database

Populating the database

  • Loading data from other sources using SQL*Loader
  • Writing to external tables using Data Pump
  • Upgrading to Data Pump with legacy mode

Maintaining the application schema

  • Implementing best practices for PL/SQL structures
  • Generating DDL for existing objects
  • Exploiting Oracle Built-In Packages

Automating routine processing

  • Scheduling routines with Oracle Scheduler
  • Starting jobs based on system or application events
  • Grouping scheduled jobs

Handling other media types

  • Programming with LOBs
  • Providing transparent compression, encryption and deduplication with SecureFiles
  • 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

Upgrading the application

  • Building a new application version using Edition-Based Redefinition
  • Implementing the new version
  • Improving Query Performance

Identifying basic tuning techniques

  • Developing a tuning methodology
  • Planning and managing the tuning process

Employing tuning tools

  • Running EXPLAIN PLAN and autotrace
  • SQL Trace and TKPROF output

Query tuning techniques

  • 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

  • Gathering system statistics with DBMS_STATS
  • Managing low-selectivity columns with histograms

Influencing the optimizer

  • Utilizing hints and optimizer mode
  • Determining the driving table
  • Tuning the Application

Optimizing performance

  • Exploring B-Trees
  • Bitmapped, function-based and other indexing options
  • Partitioning indexes with virtual columns
  • Monitoring index usage with invisible indexes

Tuning with the automated tools

  • Tuning SQL with the SQL Tuning Advisor and the SQL Access Advisor
  • Identifying performance problems with Real-Time SQL Monitoring
Show complete outline
Show Less

Course Schedule

Attend this live, instructor-led course In-Class or Online via AnyWare.

Hassle-Free Enrollment: No advance payment required.
Tuition due 30 days after your course.

Nov 14 - 18 Herndon, VA/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Dec 5 - 9 Toronto/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Mar 13 - 17 New York/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Apr 24 - 28 Ottawa/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

May 15 - 19 Herndon, VA/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Jun 19 - 23 Toronto/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Aug 28 - Sep 1 New York/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Guaranteed to Run

Bring this Course to Your Organization and Train Your Entire Team
For more information, call 1-888-843-8733 or click here

Tuition

Standard

$3190

Government

$2833

Course Tuition Includes:

After-Course Instructor Coaching
When you return to work, you are entitled to schedule a free coaching session with your instructor for help and guidance as you apply your new skills.

Free Course Exam
You can take your course exam on the last day of your course and receive a Certificate of Achievement with the designation "Awarded with Distinction."

Prev
Next

Questions

Call 1-888-843-8733 or click here »

An experienced training advisor will happily answer any questions you may have and alert you to any tuition savings to
which you or your organization may be entitled.

Training Hours

Standard Course Hours: 9:00 am – 4:30 pm
*Informal discussion with instructor about your projects or areas of special interest: 4:30 pm – 5:30 pm


FREE Online Course Exam (if applicable) – Last Day: 3:30 pm – 4:30 pm
By successfully completing your FREE online course exam, you will:

  • Have a record of your growth and learning results.
  • Bring proof of your progress back to your organization
  • Earn credits toward industry certifications (if applicable)
  • Make progress toward one or more Learning Tree Specialist & Expert Certifications (if applicable)

Enhance Your Credentials with Professional Certification

Learning Tree's comprehensive training and exam preparation guarantees that you will gain the knowledge and confidence to achieve professional certification and advance your career.

This course qualifies for 29 CPE credits from the National Association of State Boards of Accountancy CPE program. Read more ...

- ,

Prev
Next