Oracle Database for Developers Training Program


Oracle Database for Developers	Oracle Training Sitemap

			Advanced search
Technology Driven IT Training	Web-based Training Services	Why SYS-ED for Web-based Training
Definition of Service	Delivery Medium	Contact You

Licensing and Experience

Courseware for Teaching

Quality Control

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 Roadmap and address client project specifications.
For experienced fast-track 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 utilize the full complement of delivery medium: distance-learning, web-based, and technology driven classrooms. In order to accommodate employee workloads and staff in remote geographic locations, component courses can be scheduled over non-consecutive weeks utilizing a combination of classroom instruction and distance-learning. At the client's discretion, checklist of completed tasks, validation assessment, and a final examination can be utilized.

Oracle Database for Developers

Module

Duration

Distance-learning Service

Learning Path

Oracle Database

Technology Updates

Oracle Database

Oracle SOA: Service Oriented Architecture

Oracle Fusion

Teaching Models

Why SYS-ED

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

Oracle Developer: Forms and Reports

5 days

Base Program Duration

19 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. TSQL select statements	2. Data: restricting and sorting	3. Single-row functions
4. Multiple tables	5. Displaying data	6. Group functions
7. Subqueries	8. Readable output with ISQL*Plus	9. Data manipulation
10. Table: creation and management

Module:

Oracle: SQL and PL/SQL Programming

Duration:

4 days

Major Topics:

1. Relational databases	2. SQL statement	3. Restricted sorting of data
3. Single row functions	5. Data from multiple tables	6. Aggregating data
7. Writing subqueries	8. Manipulating data	9. Sort operations
10. Table: creation and management	11. Constraints	12. Views
13. Other database objects	14. Controlling user access	15. Declaring variables
16. Writing executable	17. Statements	17. Oracle server
18. Control structures

Module:

Oracle: PL/SQL Programming - Advanced

Duration:

4 days

Major Topics:

1. Variable declaration	2. Composite data types	3. Referencing non-PL/SQL variables
3. SQL functions in PL/SQL	5. Oracle Server interaction	6. SQL cursor
7. Composite data types	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

Review Additional Content

The course search engine can be utilized for researching hybrid implementations of Java with commercial and free open source combinations of software: operating systems, web servers, development platforms, and databases.

The audience, duration, and content can be used to review and augment an integrated training program and evaluate alternative fast-track courses.

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.

http://www.oracletrainingbysysed.us/commquests.htm