Certified Oracle Developer
 Oracle Forms and Reports

This Oracle Fusion Middleware 11g: Build Applications with Oracle Forms training explores building Oracle Forms Builder 11g. Expert instructors will teach you how to create high-performance applications for the Web that are also scalable.

In this course, participants will also learn how to design and build a variety of standard and custom Web and paper reports using Oracle Reports Developer (9.0.4.0.1). Working in the declarative environment of Reports Builder, participants learn how to retrieve, display, and format data from any data source in numerous reporting styles and publish the output to any destination.

Schedule

Duration:          8 Weeks

Class Days:       Thursday, Friday  07 to 09 PM

Venue:  Available Online as well as In class at LBS Training Center 67 CCA,  DHA Phase 8 Lahore, Pakistan

Start Date:  April 18, 2024

Fee:  PKR 50,000 per participant. 15% if 2 or more participants. Early bird discount also available till 10th April

Get Registered

Contact For Registration

Whats app +923008041550 eMail; info@lbspak.com

SQL Fundamentals

Module 1 : Introduction

Lesson 1 – Relational Database
Lesson 2 – Using the database interface
Lesson 3 – Introduction to SQL Language
Lesson 4 – Connecting to the Oracle Database Instance
Lesson 5 – Users and Schemas
Lesson 6 – Data Retrieval using SQL (DRL)
Lesson 7 – Restricting and Sorting Data

Module 2 : Joins and Functios

Lesson 1 – Introduction to functions
Lesson 2 – Single Row and Group Functios
Lesson 3 – Data from multiple tables
Lesson 4 – EquiJoins and Nonequijoins
Lesson 5 – Types of Joins with scnerios
Lesson 6 – Introduction of Subquries
Lesson 7 – Quries into single quries
Lesson 8 – DCL and TCL

Oracle Developer Suite 11g

Oracle Report Developer -Basics

  • Introduction to Oracle Reports Developer
  • Designing and Running Reports
  • Exploring Oracle Reports Developer
  • Creating a Paper Report
  • Enhancing a Basic Paper Report
  • Managing Report Templates

Oracle Report Developer – Advanced

  • Creating a Web Report
  • Extending Functionality Using XML
  • Creating and Using Report Parameters
  • Enhancing Matrix Reports
  • Coding PL/SQL Triggers
  • Enhancing Reports Using the Data Model: Queries and Groups
  • Enhancing Reports Using the Paper Layout
  • Web Reporting

Running a Forms Application

  • Running a Form
  • Identifying the Data Elements
  • Navigating a Forms Application
  • Using the Modes of Operation
  • Querying Data
  • Inserting, Updating, and Deleting Records
  • Saving Changes
  • Displaying Errors

Working in the Forms Builder Environment

  • Forms Builder Key Features
  • Forms Builder Components
  • Navigating the Forms Builder Interface
  • Forms Builder Module Object Hierarchy
  • Customizing Your Forms Builder Session
  • Forms Executables and Module Types
  • Defining Environment Variables
  • Testing a Form with the Run Form Button

Creating a Basic Form Module

  • Creating a New Form Module
  • Creating a New Data Bock
  • Using Template Forms
  • Saving and Compiling a Form Module
  • Module Types and Storage Formats
  • Deploying a Form Module
  • Producing Documentation

Creating a Master-Detail Form

  • Creating Data Blocks with Relationships
  • Running a Master-Detail Form Module
  • Modifying the Structure of a Data Block
  • Modifying the Layout of a Data Block

Working Data Blocks and Frames

  • Managing Object Properties
  • Creating Visual Attributes
  • Controlling the Behavior and Appearance of Data Blocks
  • Controlling Frame Properties
  • Displaying Multiple Property Palettes
  • Setting Properties on Multiple Objects
  • Copying Properties
  • Creating Control Blocks

Working with Text Items

  • Creating a Text Item
  • Modifying the Appearance of a Text Item
  • Controlling the Data of a Text Item
  • Altering the Navigational Behavior of a Text Item
  • Enhancing the Relationship between Text Item and Database
  • Adding Functionality to a Text Item
  • Displaying Helpful Messages