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
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