Oracle Forms & Reports Developer

Module-1 Introduction to SQL
Introduction to Oracle Database
This section introduces Oracle Database 12c, discussing its features, basic database design, and categorization of SQL statements. It also covers the data set used in the course, logging on using SQL Developer, and saving queries or using script files.

Retrieve Data Using the SQL SELECT Statement
You will learn the capabilities of SQL SELECT statements, selecting table data with all or specific columns, using arithmetic and concatenation operators, and employing the DESCRIBE command to display table structures.

Learn to Restrict and Sort Data
This part explains limiting output with the WHERE clause, comparison and logical operators, rules of precedence, character string literals, sorting data with ORDER BY, and SQL row-limiting clauses such as FETCH FIRST, OFFSET, and WITH TIES.

Usage of Single-Row Functions to Customize Output
It describes differences between single-row and multiple-row functions, manipulating strings, numbers, and dates using built-in functions, and applying arithmetic and DATE functions.

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

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

Display Data From Multiple Tables Using Joins
You will learn to write SELECT statements that access multiple tables, including outer joins and self-joins.

Use Sub-queries to Solve Queries
This section explains types of problems sub-queries solve, defining sub-queries, types of sub-queries, and writing single-row and multiple-row sub-queries.

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

Data Manipulation Statements
This part covers DML statements (INSERT, UPDATE, DELETE), saving and discarding changes with COMMIT and ROLLBACK, and understanding read consistency.

Use of DDL Statements to Create and Manage Tables
You will learn to create, alter, truncate, and drop tables, including the concept of Recyclebin. The section also covers enforcing data integrity with constraints: primary key, foreign key, not null, unique, and check constraints.

Other Schema Objects
This section explains creating and using views, sequences, indexes, and private/public synonyms for database management.

Module-2 Oracle Database Program with PL/SQL
Introduction to PL/SQL
PL/SQL extends SQL with procedural capabilities. You will learn its overview, benefits of subprograms, types of PL/SQL blocks, creating anonymous blocks, and generating output.

Declare PL/SQL Identifiers
This section explains different types of identifiers, using the declarative section, variables, scalar data types, the %TYPE attribute, bind variables, and sequences in PL/SQL expressions.

Write Executable Statements
You will learn basic PL/SQL block syntax, commenting, using SQL functions, data type conversion, nested blocks, operators, cursors, cursor attributes, and transaction control.

Control Structures
This part covers conditional processing using IF and CASE statements, simple loops, WHILE loops, FOR loops, and the CONTINUE statement.

Composite Data Types
You will learn to use PL/SQL records, the %ROWTYPE attribute, and perform insert/update operations with records.

Overview of Collections
This section explains associative arrays (index-by tables), nested tables, and VARRAYs.

Explicit Cursors
You will learn what explicit cursors are, how to declare, open, fetch, close them, use cursor FOR loops, cursor attributes (%NOTFOUND, %ROWCOUNT), and FOR UPDATE/WHERE CURRENT clauses.

Exception Handling
This section covers handling exceptions, predefined and user-defined exceptions, propagating exceptions, and using RAISE_APPLICATION_ERROR.

Stored Procedures
You will learn modularized subprogram design, creating, calling, removing procedures, parameter modes, and differences between anonymous blocks and subprograms.

Triggers
This section explains triggers, event types, trigger body, business scenarios, creating DML triggers, firing timings, statement-level vs row-level triggers, INSTEAD OF and DISABLED triggers, and managing triggers.

Module-3 Oracle Fusion Middleware 11g: Build Applications with Oracle Forms
Running a Forms Application
You will learn to run forms, identify data elements, navigate applications, use modes of operation, query data, perform DML operations, save changes, and display errors.

Working in the Forms Builder Environment
This section introduces Forms Builder features, components, interface navigation, module object hierarchy, session customization, executables and module types, environment variables, and testing forms.

Creating a Basic Form Module
You will learn to create form modules and data blocks, use template forms, save/compile modules, understand module types and storage, deploy modules, and produce documentation.

Creating a Master-Detail Form
This section covers creating related data blocks, running master-detail forms, and modifying structure/layout of data blocks.

Working Data Blocks and Frames
You will learn to manage object properties, visual attributes, data block behavior/appearance, frame properties, multiple property palettes, property copying, and creating control blocks.

Working with Text Items
This section explains creating/modifying text items, controlling data, navigation, database relationships, adding functionality, and displaying messages.

Creating LOVs and Editors
You will learn about LOVs, record groups, creating LOVs manually or via wizard, setting properties, mapping columns, defining editors, and associating them with text items.

Creating Additional Input Items
This section covers check boxes, list items, and radio groups.

Creating Noninput Items
You will learn display items, image items, push buttons, calculated items, hierarchical tree items, and bean area items.

Creating Windows and Content Canvases
This part explains multiple windows, new window creation, multiple layouts, and content canvases.

Working with Other Canvas Types
You will learn stacked canvases, toolbars, and tab canvases.

Producing and Debugging Triggers
This section covers triggers, execution hierarchy, PL/SQL editor, database trigger editor, variables, built-in subprograms, and using the Forms debugger.

Adding Functionality to Items
You will learn item interaction triggers and noninput item interactions.

Displaying Run-Time Messages and Alerts
This section explains handling built-ins, controlling system messages, FORM_TRIGGER_FAILURE exceptions, creating alerts, and managing server errors.

Validating User Input
You will learn validation processes, property/trigger-based validation, client-side validation with PJCs, tracking validation, and using built-ins.

Writing Flexible Code
This section covers flexible coding with system variables, built-in subprograms, copying/subclassing objects, and referencing objects indirectly.

Sharing Objects and Code
You will learn reusable objects, property classes, object groups/libraries, smart classes, and PL/SQL libraries.

Introducing Multiple Form Applications
This section explains multiple forms, starting additional modules, defining functionality, and sharing data among modules.

Module-4 Oracle Reports Developer 11g: Build Reports
Introduction to Oracle Reports Developer
You will learn business intelligence concepts, enterprise reporting, Oracle Reports Developer, Oracle Database 11g, Developer Suite, Application Server, OracleAS Reports Services, and its web architecture.

Designing and Running Reports
This section explains understanding requirements, designing tabular, master-detail, master with two details, matrix reports, retrieving/sharing data, and running reports.

Enhancing Reports Using the Data Model: Queries and Groups
You will learn data model objects, modifying query properties, changing group structure, group hierarchy, ordering/filtering data, and query modifications.

Enhancing Reports Using the Data Model: Creating Columns
This section covers data model columns, maintaining source columns, file content output, creating columns, summary columns, subtotals, percentages, and formula columns.

Controlling the Paper Layout: Common Properties
You will learn modifying paper layout object properties and using common layout properties.

Coding Reports Triggers
This section explains sizing objects, anchors, layout relationships, pagination, print frequency, and format triggers.

Controlling the Paper Layout: Specific Properties
You will learn repeating frame properties, print direction, records per page, spacing, widow records, system variables, valid source columns, and displaying file contents.

Web Reporting
This section covers static vs dynamic reporting, adding dynamic content, creating report blocks, using the report block wizard, examining web source code, rw:foreach and rw:field tags, and customizing JSPs.

Creating and Using Report Parameters
You will learn creating user parameters, referencing parameters (bind/lexical), creating lists of values, referencing system parameters, building paper parameter forms, triggers, trigger code, using report/data model/layout/format triggers, and event-based reporting.

Extending Functionality Using the SRW Package
This section covers SRW package contents, outputting messages, executing nested reports, restricting data, initializing fields, creating a table of contents, performing DDL statements, and setting format attributes.