Oracle Form Developer

Module-1 Introduction to SQL
Introduction to Oracle Database
This section introduces Oracle Database 12c, including its key features and the basic design of a database. It explains the different types of SQL statements and the data set used in the course. Students will learn how to log on to the database using SQL Developer, save queries to files, and use script files within SQL Developer.

Retrieve Data Using the SQL SELECT Statement
You will explore the capabilities of SQL SELECT statements, including selecting all columns or specific columns from a table. It covers using arithmetic and concatenation operators and using the DESCRIBE command to display table structures.

Learn to Restrict and Sort Data
This part explains how to limit retrieved output using the WHERE clause, the comparison and logical operators, and their precedence rules. You will also learn to use character string literals in the WHERE clause, sort data with the ORDER BY clause, and apply SQL row-limiting clauses such as FETCH FIRST, OFFSET, and WITH TIES.

Usage of Single-Row Functions to Customize Output
This section differentiates single-row and multiple-row functions and teaches how to manipulate strings, numbers (using ROUND, TRUNC, MOD), and dates with built-in functions. It also includes performing arithmetic operations on date data.

Invoke Conversion Functions and Conditional Expressions
You will learn implicit and explicit data type conversion, using TO_CHAR, TO_NUMBER, and TO_DATE functions, nesting multiple functions, applying NVL, NULLIF, and COALESCE, and using conditional IF THEN ELSE logic in SELECT statements.

Aggregate Data Using the Group Functions
This section explains using aggregation functions, grouping data with GROUP BY clauses, and filtering groups with HAVING clauses to generate meaningful reports.

Display Data From Multiple Tables Using Joins
Students will learn to write SELECT statements accessing multiple tables, including using outer joins and self-joins.

Use Sub-queries to Solve Queries
This part defines sub-queries, describes the problems they solve, explains types of sub-queries, and covers writing single-row and multiple-row sub-queries.

The SET Operators
You will learn SET operators such as UNION, UNION ALL, INTERSECT, and MINUS and how to control the order of returned rows.

Data Manipulation Statements
This section describes DML statements, including INSERT, UPDATE, DELETE, and explains saving or discarding changes using COMMIT and ROLLBACK, along with the concept of read consistency.

Use of DDL Statements to Create and Manage Tables
You will learn creating, altering, truncating, and dropping tables, the concept of the Recyclebin, and preventing invalid data entry using constraints like primary key, foreign key, not null, unique, and check constraints.

Other Schema Objects
This section introduces creating and using views (simple and complex), sequences, indexes, and private/public synonyms.

Module-2 Oracle Database Program with PL/SQL
Introduction to PL/SQL
This section provides an overview of PL/SQL, highlighting the benefits of PL/SQL subprograms and the types of PL/SQL blocks. Students will learn to create simple anonymous blocks and generate output from PL/SQL blocks.

Declare PL/SQL Identifiers
Students will learn the types of identifiers, using the declarative section, defining variables, scalar data types, the %TYPE attribute, bind variables, and sequences in PL/SQL expressions.

Write Executable Statements
This part explains basic PL/SQL block syntax, commenting, deploying SQL functions, data type conversions, nested blocks, PL/SQL operators, cursor concepts, cursor attributes, and transaction control (save and discard).

Control Structures
Students will explore conditional processing using IF and CASE statements, simple loops, WHILE loops, FOR loops, and the CONTINUE statement.

Composite Data Types
This section covers PL/SQL records, the %ROWTYPE attribute, and performing insert and update operations using records.

Overview of Collections
Students will learn about index-by tables (associative arrays), clustered tables, and VARRAYs.

Explicit Cursors
This part explains explicit cursors, including declaration, opening, fetching, closing, cursor FOR loops, cursor attributes (%NOTFOUND, %ROWCOUNT), and using FOR UPDATE and WHERE CURRENT clauses.

Exception Handling
Students will learn to handle exceptions, trap predefined and non-predefined server errors, user-defined exceptions, propagate exceptions, and use the RAISE_APPLICATION_ERROR procedure.

Stored Procedures
This section covers modularized subprogram design, creating, calling, removing stored procedures, procedure parameters, parameter modes, and understanding the differences between anonymous blocks and subprograms.

Triggers
Students will learn about triggers, their event types and body, business scenarios for triggers, creating DML triggers with SQL Developer, trigger firing (timing), statement-level vs row-level triggers, INSTEAD OF and DISABLED triggers, and managing, testing, and removing triggers.

Module-3 Oracle Fusion Middleware 11g: Build Applications with Oracle Forms
Running a Forms Application
This section teaches running forms, identifying data elements, navigating applications, using modes of operation, querying data, performing DML operations, saving changes, and displaying errors.

Working in the Forms Builder Environment
Students will learn about Forms Builder features, components, interface navigation, module object hierarchy, session customization, executables and module types, defining environment variables, and testing forms.

Creating a Basic Form Module
This part covers creating new form modules, data blocks, using template forms, saving and compiling forms, module types and storage formats, deploying modules, and producing documentation.

Creating a Master-Detail Form
Students will learn creating related data blocks, running master-detail forms, and modifying data block structure and layout.

Working Data Blocks and Frames
This section explains managing object properties, creating visual attributes, controlling behavior and appearance of data blocks, frame properties, multiple property palettes, setting properties on multiple objects, copying properties, and creating control blocks.

Working with Text Items
Students will learn creating text items, modifying appearance, controlling data and navigation, enhancing database relationships, adding functionality, and displaying messages.

Creating LOVs and Editors
This part covers creating LOVs and record groups manually or with the LOV wizard, setting LOV properties, mapping LOV columns, defining editors, and associating editors with text items.

Creating Additional Input Items
Students will learn to create check boxes, list items, and radio groups.

Creating Noninput Items
This section explains creating display items, image items, push buttons, calculated items, hierarchical tree items, and bean area items.

Creating Windows and Content Canvases
Students will learn displaying form modules in multiple windows, creating new windows, multiple layouts, and new content canvases.

Working with Other Canvas Types
This part covers stacked canvases, toolbars, and tab canvases.

Producing and Debugging Triggers
Students will learn about triggers, execution hierarchy, PL/SQL editor features, database trigger editor, using variables, built-in subprograms, and using the Forms debugger.

Adding Functionality to Items
This section covers coding item interaction triggers and interacting with noninput items.

Displaying Run-Time Messages and Alerts
Students will learn built-ins, handling system messages, FORM_TRIGGER_FAILURE exception, creating and controlling alerts, and managing server errors.

Validating User Input
This part explains validation processes, property-based and trigger-based validation, client-side validation with PJCs, tracking validation, and controlling validation timing using built-ins.

Writing Flexible Code
Students will learn flexible coding using system variables, built-in subprograms, copying/subclassing objects and code, referencing objects by internal ID, and indirectly referencing items.

Sharing Objects and Code
This section covers reusable objects and code, property classes, object groups, object libraries, smart classes, and working with PL/SQL libraries.

Introducing Multiple Form Applications
Students will learn about multiple forms, starting additional modules, defining functionality, and sharing data among modules.