Tuitions / Trainings

Oracle: Regular Program for 10G & 11G

Oracle Database: SQL Fundamentals I
Oracle Database: Program with PL/SQL
Oracle Forms: Build Applications with Oracle Forms
Oracle Reports: Build Reports with Oracle Reports Builder

Fee for Developer Tracks - Beginner
Rs.20,000/- (Twenty Thousand only)
Breakup of Fee Rs.10,000/- Per Month (Two Installments)
Duration: Two Months
Classes: Two days a week
Timing: Will decide on request.


Fee for Developer Tracks - Complete
Rs.32,000/- (Thirty Two Thousand only)
Breakup of Fee Rs.8,000/- Per Month (Four Installments)
Duration: Four Months
Classes: Two days a week
Timing: Will decide on request.

Contact Details:
Mobile : +92 321 2310141
Email   : hasan.jawaid.hj@gmail.com

Course Outline

Oracle Database: SQL Fundamentals I 

• ·         Retrieving Data Using the SQL SELECT Statement
• ·         List the capabilities of SQL SELECT statements
• ·         Execute a basic SELECT statement
• ·         Restricting and Sorting Data
• ·         Limit the rows that are retrieved by a query
• ·         Sort the rows that are retrieved by a query
• ·         Use ampersand substitution to restrict and sort output at runtime
• ·         Using Single-Row Functions to Customize Output
• ·         Describe various types of functions available in SQL
• ·         Use character, number, and date functions in SELECT statements
• ·         Using Conversion Functions and Conditional Expressions
• ·         Describe various types of conversion functions that are available in SQL
• ·         Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
• ·         Apply conditional expressions in a SELECT statement
• ·         Reporting Aggregated Data Using the Group Functions
• ·         Identify the available group functions
• ·         Describe the use of group functions
• ·         Group data by using the GROUP BY clause
• ·         Include or exclude grouped rows by using the HAVING clause
• ·         Displaying Data from Multiple Tables
• ·         Write SELECT statements to access data from more than one table using equijoins and nonequijoins
• ·         Join a table to itself by using a self-join
• ·         View data that generally does not meet a join condition by using outer joins
• ·         Generate a Cartesian product of all rows from two or more tables
• ·         Using Subqueries to Solve Queries
• ·         Define subqueries
• ·         Describe the types of problems that the subqueries can solve
• ·         List the types of subqueries
• ·         Write single-row and multiple-row subqueries
• ·         Using the Set Operators
• ·         Describe set operators
• ·         Use a set operator to combine multiple queries into a single query
• ·         Control the order of rows returned
• ·         Manipulating Data
• ·         Describe each data manipulation language (DML) statement
• ·         Insert rows into a table
• ·         Update rows in a table
• ·         Delete rows from a table
• ·         Control transactions
• ·         Using DDL Statements to Create and Manage Tables
• ·         Categorize the main database objects
• ·         Review the table structure
• ·         List the data types that are available for columns
• ·         Create a simple table
• ·         Explain how constraints are created at the time of table creation
• ·         Describe how schema objects work
• ·         Creating Other Schema Objects
• ·         Create simple and complex views
• ·         Retrieve data from views
• ·         Create, maintain, and use sequences
• ·         Create and maintain indexes
• ·         Create private and public synonyms

Oracle Database: Program with PL/SQL

• Overview of PL/SQL
• Identify the benefits of PL/SQL Subprograms
• Overview of the types of PL/SQL blocks
• Create a Simple Anonymous Block
• How to generate output from a PL/SQL Block?
• Declare PL/SQL Identifiers
• List the different Types of Identifiers in a PL/SQL subprogram
• Usage of the Declarative Section to Define Identifiers
• Use variables to store data
• Identify Scalar Data Types
• The %TYPE Attribute
• What are Bind Variables?
• Sequences in PL/SQL Expressions
• Write Executable Statements
• Describe Basic PL/SQL Block Syntax Guidelines
• Learn to Comment the Code
• Deployment of SQL Functions in PL/SQL
• How to convert Data Types?
• Describe Nested Blocks
• Identify the Operators in PL/SQL
• Interaction with the Oracle Server
• Invoke SELECT Statements in PL/SQL
• Retrieve Data in PL/SQL
• SQL Cursor concept
• Avoid Errors by using Naming Conventions when using Retrieval and DML Statements
• Data Manipulation in the Server using PL/SQL
• Understand the SQL Cursor concept
• Use SQL Cursor Attributes to Obtain Feedback on DML
• Save and Discard Transactions
• Control Structures
• Conditional processing using IF Statements
• Conditional processing using CASE Statements
• Describe simple Loop Statement
• Describe For Loop Statement
• Composite Data Types
• Use PL/SQL Records
• The %ROWTYPE Attribute
• Insert and Update with PL/SQL Records
• Explicit Cursors
• What are Explicit Cursors?
• Declare the Cursor
• Open the Cursor
• Fetch data from the Cursor
• Close the Cursor
• Cursor FOR loop
• The %NOTFOUND and %ROWCOUNT Attributes
• Exception Handling
• Understand Exceptions
• Handle Exceptions with PL/SQL
• Trap User-Defined Exceptions
• Propagate Exceptions
• RAISE_APPLICATION_ERROR Procedure
• Stored Procedures
• Create a Modularized and Layered Subprogram Design
• Modularize Development With PL/SQL Blocks
• Understand the PL/SQL Execution Environment
• List the benefits of using PL/SQL Subprograms
• List the differences between Anonymous Blocks and Subprograms
• Create, Call, and Remove Stored Procedures
• Implement Procedures Parameters and Parameters Modes
• View Procedure Information
• Stored Functions and Debugging Subprograms
• Create, Call, and Remove a Stored Function
• Identify the advantages of using Stored Functions
• Identify the steps to create a stored function
• Packages
• Listing the advantages of Packages
• Describe Packages
• What are the components of a Package?
• Develop a Package
• Create the Package Specification and Body
• Invoke the Package Constructs
• View the PL/SQL Source Code using the Data Dictionary
• Overloading Subprograms in PL/SQL
• Triggers
• Describe Triggers
• Identify the Trigger Event Types and Body
• Business Application Scenarios for Implementing Triggers
• Create DML Triggers using the CREATE TRIGGER Statement and SQL Developer
• Identify the Trigger Event Types, Body, and Firing (Timing)
• Differences between Statement Level Triggers and Row Level Triggers
• How to Manage, Test and Remove Triggers?
• Manage Dependencies
• Overview of Schema Object Dependencies
• Query Direct Object Dependencies using the USER_DEPENDENCIES View
• Query an Object’s Status
• Invalidation of Dependent Objects
• Display the Direct and Indirect Dependencies
• Understand Remote Dependencies
• Recompile a PL/SQL Program Unit

 Oracle Forms: Build Applications with Oracle Forms

• 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
• Creating LOVs and Editors
• LOVs and Record Groups
• Creating an LOV Manually
• Using the LOV Wizard to Create an LOV
• Setting LOV Properties
• LOV Column Mapping
• Defining an Editor
• Setting Editor Properties
• Associating an Editor with a Text Item
• Creating Additional Input Items
• Input Items Overview
• Creating a Check Box
• Creating a List Item
• Creating a Radio Group
• Creating Noninput Items
• Noninput Items Overview
• Creating a Display Item
• Creating an Image Item
• Creating a Push Button
• Creating a Calculated Item
• Creating a Hierarchical Tree Item
• Creating Windows and Content Canvases
• Displaying a Form Module in Multiple Windows
• Creating a New Window
• Displaying a Form Module on Multiple Layouts
• Creating a New Content Canvas
• Working with Other Canvas Types
• Overview of Canvas Types
• Creating a Stacked Canvas
• Creating a Toolbar
• Creating a Tab Canvas
• Producing and Debugging Triggers
• Trigger Overview
• Creating Triggers in Forms Builde
• Specifying Execution Hierarchy
• PL/SQL Editor Features
• Using the Database Trigger Editor
• Using Variables in Triggers
• Adding Functionality with Built-in Subprograms
• Using the Forms Debugger
• Adding Functionality to Items
• Coding Item Interaction Triggers
• Interacting with Noninput Items
• Displaying Run-Time Messages and Alerts
• Built-Ins and Handling Errors
• Controlling System Messages
• The FORM_TRIGGER_FAILURE Exception
• Triggers for Intercepting System Messages
• Creating and Controlling Alerts
• Handling Server Errors
• Using Query Triggers
• Query Processing Overview
• SELECT Statements Issued During Query Processing
• Setting WHERE and ORDER BY clauses and ONETIME_WHERE property
• Writing Query Triggers
• Query Array Processing
• Coding Triggers for Enter-Query Mode
• Overriding Default Query Processing
• Obtaining Query Information at Run Time
• Controlling Navigation
• Using Object Properties to Control Navigation
• Writing Navigation Triggers
• Avoiding the Navigation Trap
• Using Navigation Built-Ins in Triggers
• Overriding or Supplementing Transaction Processing
• Transaction Processing Overview
• Using Commit Triggers
• Testing the Results of Trigger DML
• DML Statements Issued during Commit Processing
• Overriding Default Transaction Processing
• Getting and Setting the Commit Status
• Sharing Objects and Code
• Benefits of Reusable Objects and Code
• Working with Property Classes
• Working with Object Groups
• Copying and Subclassing Objects and Code
• Working with Object Libraries
• Working with SmartClasses
• Reusing PL/SQL
• Working with PL/SQL Libraries
• Introducing Multiple Form Applications
• Multiple Form Applications Overview
• Starting Another Form Module
• Defining Multiple Form Functionality
• Sharing Data among Modules

Oracle Reports: Build Reports with Oracle Reports Builder

• What is Oracle Reports Builder
• OracleAS Reports Services
• OracleAS Reports Services Architecture
• Designing Reports
• Tabular Report Style
• Master Detail Report Style
• Master with Two Details Report Style
• Matrix Report Style
• Report Structures
• Using Common Code
• Using Common Objects
• Running A Report
• Reports Developer Executables
• Report Data and Layout
• Report Builder Components
• PL/SQL Editor
• The Report Editor
• PL/SQL Development Environment
• Setting Pathnames
• Building A Query
• Selecting Displayed Fields
• Labels
• The Data Model Objects
• Modifying Properties of a Query
• Creating a New Group
• Changing the Group Structure
• Using a Packaged Filter
• Data Source Types
• Viewing Output from Multiple Query Reports
• Creating Multiple-Query Linked Report
• Data Model Columns
• Maintaining Data Source Columns
• Producing File Content Output
• Creating Summary Columns
• Creating Formula Columns
• The Paper Layout Sections
• Designing Multipanel Reports
• Different Objects In Paper Layout
• The Paper Layout Layers