Oracle









Preferred method of contact:

Application Development and Tuning for Oracle Databases

COURSE TYPE

Practitioner

Course Number

492

Duration

5 Days

View Schedule

Create powerful and secure Oracle database applications and tune them for optimal performance. In this Oracle development and tuning training course, you take a deep dive into the essentials of Oracle application development, and gain the knowledge and skills to implement tuning best practices, as well as ensure the development of well-tuned business applications.

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

Important Course Information

Requirements:

  • Experience at the level of:
  • Background working with SQL-based RDBMS and knowledge of Oracle's PL/SQL at the level of:

Software:

  • This course is currently running on Oracle 12c, Release 1 on the windows platform

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

Convenient Ways to Attend This Instructor-Led Course

Hassle-Free Enrollment: No advance payment required to reserve your seat.
Tuition due 30 days after you attend your course.

In the Classroom

Live, Online

Private Team Training

In the Classroom — OR — Live, Online

Tuition — Standard: $3190   Government: $2833

Jul 31 - Aug 4 (5 Days)
9:00 AM - 4:30 PM EDT
Rockville, MD / Online (AnyWare) Rockville, MD / Online (AnyWare) Reserve Your Seat

How would you like to attend?

Live, Online
In-Class

Guaranteed to Run

Private Team Training

Enrolling at least 3 people in this course? Consider bringing this (or any course that can be custom designed) to your preferred location as a private team training.

For details, call 1-888-843-8733 or Click Here »

Tuition

Standard

Government

In Classroom or
Online

Standard

$3190

Government

$2833

Private Team Training

Contact Us »

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

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)

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.

Earn 29 Credits from NASBA

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

- ,

Prev
Next
Chat Now

Please Choose a Language

Canada - English

Canada - Français