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

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

Oracle Database (commonly referred to as Oracle RDBMS or simply as Oracle) is a proprietary multi-model database management system produced and marketed by Oracle Corporation.

course at a glance

  • Date : 20 Sep - 30 Nov 2019
  • No. of Classes/ Sessions : 22
  • Total Hours : 64
  • Last Date of Registration : 21 Sep 2019
  • Class Schedule :
    • Saturday - 6:30 PM - 9:30 PM
    • Friday - 6:30 PM - 9:30 PM
  • venue : Rupayan Trade Center; 16th Floor, 114, Kazi Nazrul Islam Avenue, Bangla Motor, Dhaka 1000. (At Bangla Motor Roundabout).

Price: TK. 13,000
(including VAT & TAX)

This training is jointly organized by BITM & Leads Training & Consulting Ltd

Training will be held in Leads Training & Consulting Ltd.



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.

 

 

Class cariculam

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.

Curriculum

Oracle DBA 11g Oracle 11g Forms and Reports Developer Training with Real Life Project 64 Hrs

Tentative Class Start

20th September, 2019

Available Seat

10 / 18

who can join

  • যে কোন group  থেকে পাশ করলেও আপনি এই course টি করতে পারেন । কোন Programming language জেনে  আসার প্রয়োজন নেই ।
  • যারা University এর final year এ আছেন এবং নিজেদের প্রজেক্ট নিয়ে ভাবছেন তারা করতে পারেন । কারন আপনি এই course টি করে খুব সহজেই একটি real life project সম্পর্কে ধারনা পাবেন । যা ব্যবহার করে আপনি একটি ভাল প্রজেক্ট তৈরি করতে পারবেন।
  • যারা application developer/forms developer হিসেবে নিজের ক্যারিয়ার গড়তে চান।
  • যারা  programming কে ভয় পান তারা কারন এখানে programming কে , আপনার বাস্তব জীবনের  সাথে তুলনা করে বোঝানো হবে যা আপনি সহজেই বুঝতে পারবেন ।
  • যারা Hardware Engineer or Network Engineer হিসেবে জব করছেন । তারা সহজেই oracle শিখে  software Engineer হতে পারেন ।

Meet the Instructor