LEADS Corporation Limited
HOME > LTCL > Training > Online Course: Oracle 11g Forms and Reports Developer Training with Real Life Project

Online Course: Oracle 11g Forms and Reports Developer Training with Real Life Project

Last Date of Registration: 24 December, 2020
Start Date: 25 December, 2020
Time: Friday, Saturday (03:00 PM – 06:00 PM)
Duration: 50 Hours
Course Fee: 6,000.00 TK
Contact: 01811449483,01847179477,01811448063

Training  Content:

  1. SQL
  2. PL/SQL
  3. FORMS
  4. REPORTS

SQL:

  1. Work with SQL select statement
Data manipulation language (DML)Select, Insert, Update, Delete, Merge
Data definition language (DDL)Create, Alter, Drop, Rename, Truncate
Data control language (DCL)Grant, Revoke
Transaction control (TC)Commit, Rollback, Savepoint

 

  1. Retrieving data using select statement
  2. Arithmetic Expression
  3. Column Alias
  4. Concatenation
  5. Distinct
  6. Restring and sorting data using where condition order by
  7. Using different type of comparison condition.
  8. Using SQL function like single row function, character function, multiple row function.
  9. Data type conversion.
  10. Group function.
  11. Data type and table creation.
  12. Table constraint
  13. Type of join

 

PL/SQL:

  1. PL/SQL block structure
  2. Function, Procedure, Cursor, Trigger
  3. If/else condition, Loop.

 

Forms and Reports:

  1. Installation oracle developer forms and reports.
  2. Briefly explain about types of forms and reports component and

   work with that component to build up a real life  project.

 

Course Curriculam

Class -01

  1. Introduction to oracle, its history, discus about RDBMS, table, filed and column.
  2. Installing Oracle 11g DB in windows,
  3. Set the environment.
  4. Installing toad,
  5. Create user and grant session
  6. Discus about data type and create table.
  7. Export and import data
  8. Lock and unlock user.

Class-02

  1. Discus about table constraint.
  2. Alter table like column add, rename etc.
  3. Insert, update, delete data from table.
  4. Select data from table using various condition.

Class-03

  1. Overview some basic form of a real life project and discus its pl/sql block, function, procedure, cursor.(just discus why need function, procedure, cursor ).
  2. Hand on practices different type of sql query.

Class -04

  1. Hand on practices different type of sql query.

Class -05

  1. Review our previous class sql query.
  2. Discus about pl/sql block structure and hand on practice it.
  3. Discus about if/else condition and practice it.
  4. Discus function, procedure and cursor.

Class -06

  1. Installing oracle forms and reports developer.
  2. Discus about some basic component of forms and report developer.
  3. Create a basic from and insert and update data into database using this form.

 

Class -07

  1. Review our class 4 where we discus sql query and pl/sql session.
  2. Create a main form for our project.
  3. Creating table login and create and login form according login table. In this form we use function/procedure/cursor/if-else statement.

Class -08:

  1. Discus about menu,
  2. Discus about visual attributes
  3.   Create table dept and also create form manually and insert, update, delete

        into database with form validation.

Class -09:

  1. Create table emp and also create a entry form. On this form we also learn about list item (static/dynamic), checkbox, and radio group.
  2. Learn about auto number generation.

Class -10

  1. In this day we learn about records groups and lovs using our emp entry from.
  2. Creating a master-details forms using dept and emp table.

Class-11

  1. Hand on practices pl/sql trigger and loops.
  2. Create a basic from for learn loops.

Class -12

  1. Brief about reports builder.
  2. Create tabular and group by report.

Class -13

  1. Create a sample from.
  2. Create table salary and also create entry from

Class – 14

  1. Create different parameter wise salary statement or report.
  2. Creating HR related table and build up a entry forms using tab-canvas.

Class -15

  1. Create hr forms using tab canvas and HR reports.

Class -16

  1. Over all review of sql and pl/sql.
  2. Problem solving class.


Start Course