Oracle Database for Developers Training Program

Oracle Database for Developers Training Program

Oracle Database for Developers

Oracle Training Sitemap

Oracle Database for Developers Advanced search

Technology Driven IT Training

Web-based Training Services

Why SYS-ED for Web-based Training

Definition of Service

Delivery Medium

Contact You

The Oracle Database for Developers training program is comprised of relational concepts, SQL and PL/SQL programming, application development and tuning, and Oracle Forms; the standard duration is 19 days. A lesson plan based upon the standards of the New York State Department of Education will be provided as part of qualifying the subject matter, examples, exercises, and program duration.

  • Industry standard content can be extended to include educational consultancy topics and guidelines to implement the Oracle database development platform and address client project specifications.
  • For experienced information technology professionals, the training program can be tailored for migrating applications from an IBM DB2 mainframe system to the Oracle database and PL/SQL platform.

SYS-ED's training programs are taught using multiple delivery medium: distance-learning, classroom instruction, and blended learning. In order to accommodate employee workloads and staff in remote geographic locations, component courses can be scheduled over non consecutive weeks combining  classroom instruction and distance-learning. At the client's discretion, a record of completed tasks, validation assessment, and a final examination can be utilized.

Oracle Database for Developers Training Program
Base Program Duration
Distance-learning Service
Learning Path
Oracle Database
Technology Updates
Oracle Database
Oracle SOA: Service Oriented Architecture
Oracle Fusion
Oracle Web Server for Administrators and Developers Training Program

Teaching Models

Why SYS-ED Oracle Database for Developers Training


Oracle: Relational Concepts 2 days
Oracle: SQL - Introduction 2 days
Oracle: SQL and PL/SQL Programming 4 days
Oracle: Oracle Advanced PL/SQL 3 days
Oracle: SQL Tuning Workshop 3 days

Base Program Duration

14 days
Oracle Developer: Forms and Reports (Optional) 5 days

Module: Oracle: Relational Concepts
Duration: 2 days
Major Topics:
1. DBMS technology 2. Relational data model 3. Relational database structure
3. Designing relational databases 5. Accessing a relational database 6. Object oriented programming technology
7. Relational database: implementation    

Module: Oracle: SQL - Introduction
Duration: 2 days
Major Topics:
1. SQL SELECT statements 2. Data: restricting and sorting 3. Single and multiple row functions
4. Multiple tables 5. Displaying data 6. Group functions
7. Subqueries 8. SQL Developer 9. Data manipulation
10. Table: creation and management    

Module: Oracle: SQL and PL/SQL Programming
Duration: 4 days
Major Topics:
1. Introduction 2. SQL 3. Program structure
4. Functions 5. Coding techniques 6. Tables
7. Composite datatypes 8. Nesting 9. Packages
10. Triggers 11. Object oriented programming  

Module: Oracle: PL/SQL Programming - Advanced
Duration: 4 days
Major Topics:
1. Variable declaration 2. Composite datatypes 3. Referencing non-PL/SQL variables
3. SQL functions in PL/SQL 5. Oracle server interaction 6. SQL cursor
7. Composite datatypes 8. Explicit cursors 9. Handling exceptions with PL/SQL
10. Procedures 11. Procedures with parameters 12. Function creation
13. Subprograms 14. Packages 15. Manipulating large objects
16. Database triggers    

Module: Oracle: SQL Tuning
Duration: 3 days
Major Topics:
1. Tuning methodology 2. SQL statement processing 3. EXPLAIN and autotrace
4. SQL Trace and TKPROF 5. Cost-based and rule-based optimization 6. Indexes and basic access methods
7. Optimizer - influencing 8. Sorting and joining 9. Optimizer plan stability
10. Advanced indexes 11. Materialized views and temporary tables 12. Alternative storage techniques
13. SQL analyze    

Module: Oracle Developer: Forms and Reports
Duration: 5 days
Major Topics:
1. Oracle AS architecture and components 2. GUI: graphical user interface design 3. User feedback
3. Building menus 5. Form Builder 6. Form creation
7. Layout Editor 8. Templates 9. Master-detail relationships
10. PL/SQL programming 11. LOVS: list of values 12. Canvasses and windows
13. Triggers and procedures 14. Report parameters 15. Debugging triggers

Technology Exchange Websites
SYS-ED websites compile, organize, and present software specific and established operational categorizations of information technology. They provide a framework for assessing knowledge transfer in a variety of delivery formats: web-based training, classroom instruction, technology updates, courseware, training aids, learning paths, and validation assessment.