Oracle Database for Developers Training Program

Oracle Database for Developers Training Program

Oracle Database for Developers

Home
     

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

SYS-ED’s Oracle training programs utilize the full complement of delivery medium - traditional, web-based, and technology driven classrooms.

The client organization selects the modules to comprise the training program which then are tailored to specific training needs and operational objectives. The Oracle courses which comprise a program do not have to be conduced on consecutive weeks and can be coordinated with project requirements. At the client's discretion, validation assessment and a final examination can be utilized.

Oracle Database for Developers
Module Duration


Oracle Web Server for Administrators and Developers Training Program

Traditional Classroom Training


Oracle Database for Developers Training Program

Blended Content Delivery
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
Module: Oracle: Relational Concepts
Duration: 2 days
Audience: Database administrators, designers, managers and application programmers
Prerequisites: Programming language
Topics:
1. DBMS technology 2. Relational data model 3. Relational database structure
3. Designing relational databases 5. Accessing a relational database 6. OOPs technology
7. Relational database: implementation    
Module: Oracle: SQL: Introduction
Duration: 2 days
Audience: Database administrators - DBA, designers and application programmers
Prerequisites: Windows operating system
Topics:
1. SQL select statements 2. Data: restricting/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/management    
Module: Oracle: SQL and PL/SQL Programming
Duration: 4 days
Audience: DBA, designers, web administrators and application programmers
Prerequisites: SQL: Structured Query Language
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/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: Oracle Advanced PL/SQL
Duration: 3 days
Audience: Database administrators - DBA, designers and application programmers
Prerequisites: SQL
Topics:
1. Variable declaration 2. Referencing non-PL/SL variables 3. SQL functions in PL/QLS
3. Oracle Server interaction 5. SQL cursor 6. Composite data types
7. Explicit cursors 8. Handling exceptions with PL/SQL 9. Procedures
10. Procedures with Parameters 11. Function creation 12. Subprograms
13. Packages 14. Manipulating large objects 15. Database triggers
Module: Oracle: SQL Tuning Workshop
Duration: 3 days
Audience: Database administrator and application programmers
Prerequisites: SQL and PL/SQL
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
Audience: Database administrators - DBA , designers and application programmers
Prerequisites: SQL
Topics:
1. Developer concepts 2. GUI - graphical user interface design 3. Form Builder GUI features
3. User feedback 5. Building menus 6. Form Builder
7. Form creation 8. Layout Editor 9. PL/SQL - Form Builder operations
10. PL/SQL programming 11. Procedures and functions 12. Form Builder debugging
13. Form Builder development techniques 14. Block and relation properties 15. List of values and record group objects
16. Designing windows and canvases 17. Reports - designing and building 18. Designing report layout
19. Building applications 20. Developer modules - integration 21. Developer integration with the web

Technology Exchange Websites
SYS-ED's technology exchange 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
www.xmltrainingbysysed.us www.unixtrainingbysysed.us
www.msnetworkstrainingbysysed.us www.mqseriestrainingbysysed.us

www.javatrainingbysysed.us

 www.dotnettrainingbysysed.us

http://www.sysed.com/tech_assessments/leader/internet_programming.asp