Online Course: Creating Report using Crystal Report & PL/SQL

Online Course: Creating Report using Crystal Report & PL/SQL

PL/SQL training introduces you to PL/SQL and explains the benefits of this programming language.

course at a glance

  • Date : 12 Dec - 30 Jan 2021
  • No. of Classes/ Sessions : 15
  • Total Hours : 30
  • Last Date of Registration : 11 Dec 2020
  • Class Schedule :
    • Saturday - 7.00 PM - 9.00 PM
    • Friday - 7.00 PM - 9.00 PM
  • venue : Online Platform.

Price: TK. 6,000
(Excluding VAT & TAX)
10% Discount for Group Admission (4 person)

Training Outline:

PL/SQL

  • Introduction to PL/SQL
  • Declaring PL/SQL Variables
  • Writing Executable Statements
  • Writing Control Structures
  • Using Explicit Cursors
  • Handling Exceptions
  • Introducing Stored Procedures and Functions
  • Creating procedures
  • Creating functions and debugging subprograms
  • Creating packages
  • Use existing report related package.
  • Add new functions and procedure to existing package.
  • How to use MIS library in creating procedure.

Creating Report using Crystal Report 

  • Crystal report options
  • Connect to oracle database
  • Use SQL command
  • Use table & store procedure
  • Field explorer dialogue box
  • Basic conventions for BankUltimus
  • Section expert option
  • Adding Group
  • Sample report
  • How to add sub-report
  • Link main report with sub-report
  • How to add formula
  • Apply sample formula
  • Briefly describe the MIS library and its utilization.

Curriculum

Training On Creating Report using Crystal Report & PL/SQL 30 Hrs

Tentative Class Start

12th December, 2020

Available Seat

10 / 15

who can join

  • Technical Consultant
  • System Analysts
  • PL/SQL Developer
  • Forms Developer

Meet the Instructor