Oracle 11g (Windows)
The Oracle Developer career track includes gaining knowledge and working experience in Oracle Forms and Reports.
The following modules make up the Famsoft's Oracle 11g Developer career track:
1. Introduction to Oracle 11g: SQL
2. Oracle 11g: Program with PL/SQL
3. Oracle 11g: Forms Developer
4. Oracle 11g: Reports Developer
Introduction to Oracle 11g: SQL | Hours: 30 | Sessions: 9
This course introduces students to Relational databases, data server technology, and explores the concepts of relational databases and the powerful SQL and iSQL* PLUS commands.
1. Data Modeling and Normalization
2. Queries against relational tables
3. DDL, DML and Select statements
4. Perfoming joins and grouping
5. Updating Tables
6. Enforcing business rules using declarative constraints
7. Building Reports with SQL*Plus
Course Pre-Requisite: None (Students are assumed to have basic computer knowledge)
Back to Top
Oracle 11G: Program with PL/SQL | Hours: 30 | Sessions: 9
The course teaches students to write PL/SQL procedures, functions and packages. Students create and manage PL/SQL program units and database triggers in both Forms Builder and the SQL*PLUS environment. Students are also taught how to make use some of the Oracle-supplied packages.
1. Creating Procedures
2. Creating Functions
3. Creating Packages
4. Managing Sub Programs
Course Pre-Requisite: Introduction to Oracle 11g: SQLBack to Top
Oracle 11g: Forms Developer | Hours: 30 | Sessions: 9
This course introduces the key features, components and capabilities of the Oracle 10G Forms Developer. Students work with multiple form applications, record groups, and list items , implement methods to use data sources and integrate charts, reports and timers in Forms. In addition, the course covers reusing components, objects and code.
1. Run form Messages and Alerts
2. Debugging PL/SQL code
3. Query Processing
4. Validating and Navigation
5. Transaction Processing
6. Writing Flexible code
7. Windows and Canvases
8. LOVs and Editors
9. Identify non-input item types
10. Form Builder triggers
11. Running and creating a Form Module
12. Forms Builder
13. Menu Module Creation and Management
14. Key Triggers and Mouse events
15. Data Block Relationships
16. Match Form builder variable name with type
17. Working with Multiple Form Applications
18. Record groups and List Items
19. Additional Data Sources
20. Charts, Reports, Timers: Integration in Forms
21. Reusing Components, Objects and Code
22. New Features in Forms Builder
Course Pre-Requisite: Introduction to Oracle 10g: SQL and Oracle 11g: Program with PL/SQL
Back to Top
Oracle 11g: Reports Developer | Hours: 30 | Sessions: 9
This course introduces key features of Report Builder, building a standard tabular report and report layout styles.
1. Report Builder
2. Building a Standard Tabular Report
3. Building Additional Report Layout Styles
4. Report Storage Methods
5. Developing Report Templates
6. Using Oracle blocks effectively
7. Creating and Using Report Parameters
8. Coding PL/SQL Triggers in a Report
9. Report Builder Built-in Package
Course Pre-Requisite: Introduction to Oracle 11g SQL and Oracle 11g: Program with PL/SQL
Back to Top