Objectives
The Oracle Applications Development course is designed to enable delegates to build
high-performance database applications which extract and present information from an
Oracle database in a distributed environment. The course also prepares delegates for the
relevant OCP examination. A thorough grounding in the SQL language will be included as SQL
is essential for the creation, manipulation, extraction of data from an Oracle database.
Extensive hands-on exercises are included for each section of the course.
Duration
5 Days
Target Audience
The Oracle Application Development training course is suitable for any personnel involved
in the maintenance of Oracle applications and databases and for users who wish to extend
their existing knowledge. Also end users who wish to construct their own reports.
What You Will Learn
1. Thorough grounding in the languages for Oracle programming (SQL and PL/SQL), when to
use which, and how to structure and package code.
2. In-depth knowledge of how to extract Oracle data and present it in the desired format
such as reports.
3. In-depth knowledge of how to manipulate data in an Oracle database.
4. How to recover from errors which occur part-way through a complex series of database
processes.
5. How to secure an Oracle database, ensuring that only registered users have access, and
safeguard against access conflicts.
6. How to improve the efficiency and performance of Oracle database applications.
7. Understand Oracle's remote web capabilities.
8. How to implement complex business contraints.
9. Prepare for OCP examination.
Exercises
1. Use various commands and functions to extract information from a relational Employee
database.
2. Present information in a formatted display.
3. Insert, update, delete data from database using Transaction Control statements.
4. Use locking mechanisms to control/resolve access conflicts.
5. Create PL/SQL procedural program using loops, branches and conditional branches to
manipulate data in the employee database.
6. Create a package to incorporate procedures and functions, and to modularize code.
7. Use bind, lexical and global variables.
8. Define schemas and system / object level permissions to restrict access.
9. Use indexes to provide performance enchancement and data normalisation.
10. Use the data dictionary in your application.
11. Use triggers to implement data constraints.
Course Content
Course content has been developed for real-world, commercial scenarios by our expert instructors. See below for detailed syllabus, or if you have a technical query email .
Pre Requisite skills
A programming background, and knowledge of SQL preferred.
Associated Course(s)
Oracle Database Administration
Oracle Performance Tuning
Oracle Backup and Recovery
What is SQL and what is it used for?
Lexical and Bind variables
Nesting Functions
|
|
|