English French German Spanish Italian Russian Korean Japanese China
 

Main Menu

Help Desk

Education Services

Welcome to Digitaal Dreams After the successful completion of the first Oracle Course, Digitaal Dreams proudly offers three more programming courses.1.PL/ SQL & FORMS ,2. PL/SQL& Reports 3. Web Development Useing .NET (Starting from 12th November 2007) Education by Industry Professionals to Future Industry Professionals Starting from Nov 12, 2007 for Limited Available Seats

EDUCATION BY INDUSTRY PROFESSIONALS TO FUTURE INDUSTRY PROFESSIONALS

After the successful completion of the first Oracle Course, Digitaal Dreams proudly offers three more programming courses. (Starting from 12 th November 2007)

• PL/SQL and Forms
• PL/SQL and Reports
• Web Development Using .Net
All courses have limited seats. Get your Free Registration for the course.
Salient Features of the Course
  • Certificate for successful candidates
  • Course being taught by industry professionals
  • For students appearing in an optional exam at the end of the course:
  • 50% fee waive-off scholarship for 1 st position holder
  • 25% fee waive-off scholarship for 2 nd and 3 rd position holders
  • Hands on experience through sufficient number of lab sessions
  • Heavily discounted fee for the first time
  • Major emphasis on practical aspects of the courses
  • Air-conditioned class rooms and labs
Who is fit for the Course?
  • The students having a background of Computer Science are eligible for this course
  • The students frustrated for their final projects are specially invited to go along with this course
  • Enhance your skills, Empower yourself with Digitaal Dreams

 

PL/SQL Forms Course Contents

  • PL/SQL Structure
  • PL/SQL BLOCK Structure
  • PL /SQL: Data types and Variables
  • Programs in PL/SQL
  • PL/SQL blocks
  • Anonymous Block
  • Anonymous PL/SQL block - using SQL*Plus defined variables
  • PL/SQL Subprogram
  • Creating Procedure
  • Parameters MODES for formal parameters
  • Use of IN OUT
  • Procedure Execution/OUTPUT
  • Methods for passing Parameters
  • Invoking a procedure from Anonymous PL/SQL Block
  • Drop Procedure
  • Select the Nth highest value from a table
  • Grant privileges on object to user
  • Protecting PL/SQL source code?
  • Control Flow in PL/SQL
  • IF THEN ELSE
  • IF THEN ELSIF
  • PL/SQL Loops
  • LOOP Example
  • WHILE LOOP
  • Loop-forming statements
  • A Simple FOR loop in PL/ SQL
  • PL/SQL Cursors
  • A Simple Cursor
  • PL/SQL Cursors
  • Varieties of cursors
  • Explicit Cursor Operations
  • Writing complete Explicit Cursor
  • Practice Exercises
  • Creating Functions
  • Function Syntax, Simple Function example
  • PACKAGES
  • CREATE A PACKAGE
  • Create Package Specification
  • Create Package Body
  • Examples
  • Oracle Predefined Exceptions
  • Creating Database Triggers
  • Triggers Overview
  • Database triggers and their use
  • How to create database triggers
  • Triggers firing rules
  • Triggering Event
  • Triggering Time
  • Trigger Body
  • Statement & Row level trigger
  • Creating Trigger
  • Creating Row Trigger
  • Syntax for creating ROW Trigger
  • DML operations by different users on a database table
  • Difference between Triggers and Procedures
  • OLD & NEW
  • Use Trigger to Track Users Activities
  • Managing Triggers
  • Introduction to Developer
  • Common builder components
  • Environment variables
  • Controlling the Data of a Text Item
  • Altering the Navigational Behavior of a Text Item
  • Enhancing the relationship between Text Item and Database
  • Introduction to LOVs and Editors
  • Defining an LOV
  • Defining an Editor
  • Running a Form Builder Application
  • Navigating a Form Builder Application
  • Modes of Operation
  • Retrieving Data
  • Inserting, Updating and Deleting Records
  • Displaying Errors
  • Form Builder Executables
  • Form Builder Module Types
  • Form Builder Components
  • Creating a new Form Module
  • Creating a new Data Block
  • Modifying the Layout
  • Template Forms
  • Saving, Compiling and Running a Form Module
  • Creating Data Blocks with Relationships
  • Running a Master Detail Form Module
  • Managing object properties
  • Controlling the behavior of Data Blocks
  • Controlling the appearance of Data Blocks
  • Controlling Frame Properties
  • Creating Control Blocks
  • Working with Text Items
  • Creating a Text Item
  • Introduction to Input Items
  • Creating a Check Box
  • Creating a List Item
  • Creating a Radio Group
  • Introduction to Non Input Items
  • Creating a Display Item
  • Creating an Image Item
  • Creating a Sound Item
  • Creating a Button
  • Creating a Calculated Field
  • Introduction to Windows and Content Canvases
  • Displaying a Form Module In Multiple Windows
  • Displaying a Form Module on Multiple Layouts
  • Creating a Stacked Canvas
  • Creating a Toolbar
  • Introduction to trigger
  • Trigger Scope Component
  • Trigger Component
  • Defining Triggers in Form Builder
  • Writing the Trigger Code
  • Using the Pre and Post Triggers
  • Navigation in Triggers
  • Introduction to Transaction Processing
  • The Commit sequence of Events
  • Characteristics and Uses of Commit Triggers
  • DML Statements Issued During Commit Processing
  • Overriding Default Transaction Processing
  • Array Processing
  • Introduction to Flexible Code
  • Using System Variables and Built-In Sub Programs for Flexible Coding
  • Referencing Objects by Internal ID
  • Adding Functionality Using Built-in Sub-Programs
  • Using Triggers
  • Debugging Triggers
  • Item Interaction Triggers
  • Defining Functionality for Input Items
  • Defining Functionality for Non Input Items
  • Runtime 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
  • Introduction to Query Triggers
  • Select statement issued During Query Processing
  • Writing Query Triggers
  • Query Array Processing
  • Overriding Default Query Processing
  • Obtaining Query Information at Runtime
  • Introduction to Validation
  • Using Object Properties to Control Validation
  • Controlling Validation by Using Triggers
  • Validating User Input
  • Built-Ins for Validation
  • Introduction to Controlling Navigation
  • Navigation Triggers
  • Using the When-New-Object-Instance Triggers
  • Referencing Items Indirectly
  • Reusable Objects and Code Overview
  • Property Class
  • Creating a Property Class
  • Inheriting a Property Class
  • Creating an Object Group
  • Copying and SubClassing Objects and Code
  • Introduction to Objects Library
  • Working with Object Libraries
  • Introduction to SmartClass
  • Reusing PL/SQL
  • PL/SQL Libraries

 

 

PL/SQL and Reports Course Contents

  • Introduction to PL/SQL
  • PL/SQL Structure
  • PL/SQL BLOCK Structure
  • PL /SQL: Data types and Variables
  • Programs in PL/SQL
  • PL/SQL blocks
  • Anonymous Block
  • Anonymous PL/SQL block - using SQL*Plus defined variables
  • PL/SQL Subprogram
  • Creating Procedure
  • Parameters MODES for formal parameters
  • Use of IN OUT
  • Procedure Execution/OUTPUT
  • Methods for passing Parameters
  • Invoking a procedure from Anonymous PL/SQL Block
  • Drop Procedure
  • Select the Nth highest value from a table
  • Grant privileges on object to user
  • Protecting PL/SQL source code?
  • Control Flow in PL/SQL
  • IF THEN ELSE
  • IF THEN ELSIF
  • PL/SQL Loops
  • LOOP Example
  • WHILE LOOP
  • Loop-forming statements
  • A Simple FOR loop in PL/ SQL
  • PL/SQL Cursors
  • A Simple Cursor
  • PL/SQL Cursors
  • Varieties of cursors
  • Explicit Cursor Operations
  • Writing complete Explicit Cursor
  • Practice Exercises
  • Creating Functions
  • Function Syntax, Simple Function example
  • PACKAGES
  • CREATE A PACKAGE
  • Create Package Specification
  • Create Package Body
  • Examples
  • Oracle Predefined Exceptions
  • Creating Database Triggers
  • Triggers Overview
  • Database triggers and their use
  • How to create database triggers
  • Triggers firing rules
  • Triggering Event
  • Triggering Time
  • Trigger Body
  • Statement & Row level trigger
  • Creating Trigger
  • Creating Row Trigger
  • Syntax for creating ROW Trigger
  • DML operations by different users on a database table
  • Difference between Triggers and Procedures
  • OLD & NEW
  • Use Trigger to Track Users Activities
  • Managing Triggers
  • Introduction to Reports
  • Designing Reports
  • Retrieving and Sharing Data
  • Running a Report
  • Viewing the Report Output
  • Report Executables
  • Report Builder Components
  • Object Categories
  • Invoking Report Builder and Report Wizard
  • Creating Tabular Report Using Wizard
  • Creating Other Report Styles
  • Introduction to Live Previewer
  • Modifying a Report in Live Previewer
  • Using Report Templates
  • Modifying a Template
  • Predefining Our Own Templates
  • Report Storage Methods
  • Documenting our Reports
  • File Portability
  • Converting Report Definitions
  • Describing the Reports Data Model
  • Modifying Properties of a Query
  • Changing the Group Structure
  • The Group Hierarchy
  • Ordering Data in a Group Hierarchy
  • Filtering Data in a Group
  • Adding New Data
  • Using Data Links to Structure Data
  • The Data Model Column Types
  • Maintaining Database Columns
  • Using a Database Column to Output Contents of a File
  • Creating a Column
  • Creating Summary Columns
  • Creating Formula Columns
  • Creating Placeholder Columns
  • Viewing the Layout Model Regions
  • Designing Multipanel Reports
  • The Layout Model Layers
  • Creating Layout Objects
  • Creating Additional Layouts in a Report
  • Creating Variable Length Lines
  • Displaying a Multimedia Fie from a Button
  • Creating Explicit Anchors
  • Modifying Layout Object Properties
  • Displaying File Contents with a Link File
  • Modifying Common Layout Properties
  • Sizing Objects
  • Layout Objects Relationships
  • Creating User Parameters
  • Referencing Parameters in a Report Query
  • Creating a LOV
  • Referencing System Parameters
  • Building a Parameter Form
  • Creating and Embedding a Graphics Chart in a Report
  • Embedding an Existing Chart in a Report
  • Introduction to Matrix Data Model
  • Creating Matrix Summaries
  • Types of Triggers in Reports
  • Using Report Triggers
  • Using Data Model Triggers
  • Using Layout Model Triggers
  • Writing Common Code
  • Setting Format attribut

 


» Hafeez Ghee and General Mills (Pvt.) Ltd
» Hamaz Pharmaceuticals (Pvt.) Ltd.
» Multan Hide Company
» Multan Apex Ltd.
» S.G.Polysacks (Pvt) Ltd.
» Rotary Club of Multan Midtown
» Multan Dry Port Trust
» Khawaja Bashir Group
» MAS Automotive Ltd.
» University of Southern Punjab
» Mehr Dastgir Textile Mills Ltd
» Al-Hilal Vagetable Ghee Mills (Pvt.) Ltd.
» Maqbool Textile Mills Ltd.
» Shangrilla Gardens and BarBQ Restaurant
» Shangrilla Snack Bar Restaurant
» Lucky Devil Tattoo
» Kaltenbock Opticians
» SunglassSpecialist.com
» PC Corner Inc.
» UKIPS (UK Investment Property Service)
» Allah Wasaya Textile Mills Ltd.
» Shangrilla Restaurant
» Multan Chamber of Commerce
» Mehr Dastgir Goup of Industries (Pvt) Ltd
» Institute of Management Sciences (BZU)
» Ashhub enterprise
» Rommi Group of Industries (Pvt) Ltd
» M Hassan Din & Sons
» Zakarian Business Graduates Alumni
Â