Application Development and Tuning for Oracle^® Databases: Hands-On

What is this course about?

In this course, you gain in-depth knowledge of Oracle application development. The extensive hands-on exercises provide you with valuable opportunities to practice solving business problems related to application development issues. You work with a number of Oracle-provided utilities for application maintenance and security including job scheduling, working with LOBs, managing statistics, and others.

In addition, you gain an extensive background in tuning. You work with the tuning diagnostic tools including several of Oracle's automated tuning tools, understand and influence the optimizer, work with indexes and alternative storage structures, and examine and work with application tuning examples.

What background should I have?

This course concentrates on a selection of topics applicable to application development using Oracle. This is not an introductory course.

If you are new to Oracle or want to review the basics of SQL and/or PL/SQL, you should take Course 926: Oracle^® Database 11g: A Comprehensive Hands-On Introduction, or Course 925: SQL Programming Language: A Comprehensive Hands-On Introduction.

You should have some background and experience working with a SQL-based RDBMS and a working knowledge of Oracle's PL/SQL. Course 493: Oracle^® PL/SQL Programming: Hands-On, provides extensive hands-on experience writing PL/SQL programs.

Who will benefit from this course?

This course benefits a wide range of professionals including:

• Programmers, application designers, developers and systems analysts who are designing and writing Oracle applications using Oracle
• Those who are migrating from earlier releases to Oracle10g or Oracle 11g
• Data processing professionals who may have many years' experience working with traditional database systems (relational, hierarchical or network) and who are now moving to Oracle
• Database administrators who want to acquire a deeper understanding of Oracle development concepts
• Managers and project leaders who need a general overview of the application development process

What version of Oracle is used?

This course is currently running on Oracle 11g, Release 2 on the Windows platform.

Is this course useful if I'm working with an earlier version of Oracle?

This course covers application development and tuning using Oracle databases. In addition, the features useful for developers introduced in Oracle9i,Oracle 10g and Oracle 11g are covered and identified using "9i", "10g ", and "11g" icons. If you are currently on an earlier version but are planning to migrate to a later version, this course is for you.

Will the material I learn be relevant for my UNIX (or VMS) shop?

Yes, Oracle and the topics covered are platform-independent. Everything you learn is applicable to a UNIX, Windows, or VMS environment.

How much time is spent on each topic?

What kinds of hands-on exercises are included in the course?

Approximately 40 percent of class time is spent in hands-on exercises. Throughout the course, a continuos case study provides in-depth and hands-on experience building and tuning applications in an Oracle environment. Exercises include:

• Using SQL*Loader and external tables
• Enhancing applications using Oracle-provided packages
• Dealing with common problems
• Establishing database and program-enforced security
• Using the tuning diagnostic tools including the Oracle automated tuning tools
• Understanding and influencing the optimizer
• Creating indexes and alternative storage structures
• Query and application tuning techniques

How does this course relate to other Learning Tree courses?

• 926: Oracle® Database 11g: A Comprehensive Hands-On Introduction , offers a comprehensive introduction to the relational features of Oracle Database 10g.
• 927: Oracle® Database 11g Administration: Hands-On , provides the fundamental knowledge and skills to create and configure Oracle Database 10g, manage memory and storage effectively, and deploy essential procedures to maintain your organization's data.
• 234: Developing SQL Queries for Oracle® Databases: Hands-On , offers the skills needed to write robust, reliable and efficient SQL queries.
• 140: SQL Server® 2008 Reporting Services: Hands-On  provides the skills to seamlessly deliver reports to customers, partners, suppliers and employees across the enterprise.
• 493: Oracle® PL/SQL Programming: Hands-On  provides advanced techniques for programming using the PL/SQL language. Courses 492 and 493 are complimentary to one another and can be taken in any order.

US Dates