ONLINE COURSE ON SOFTWARE PROJECT BASED ORACLE TRAINING

এই কোর্সে কি কি থাকছে ?

এই Project Based Oracle Training এ আমরা শুরু থেকেই একটি সফটওয়্যার প্রজেক্টের (Human Resource, Attendence & Payroll Systems) এর কাজ শুরু করব । এবং প্রজেক্টের কাজ করতে করতেই আমরা শিখবঃ
1-Oracle Database 11g. (Installation, Backup Recovery and Performance Tuning).
2-Oracle Developer Suite 10g upgradable to 11g Fusion Middleware.
3-Oracle Developer Suite and Database Installation Tricks and Tips.
4-Oracle SQL (Structured Query Language).
5-Oracle PLSQL Program Units.
6-Guideline to sit for Oracle Certified Professional (OCP) vendor Examination.
7-How to do freelancing by Oracle.
বিগত ১৫ বছর অরাকল নিয়ে Real Environment এ কাজ করার অভিজ্ঞতা থেকে অরাকলের যে সব বিষয় Real Environment এ কাজে লাগে, তা নিয়ে এই Oracle Made Easy, A Real Life Software Development and Database Administration Training With Project on Human Resource, Attendance and Payroll Systems এর এই তিন মাস ব্যাপি Package Course তৈরি ।

CURRICULUM

Session-1 : Oracle Database –

1. What is Oracle?
2. Who is Oracle?
3. What is Database?
4. Three Tier Architechture.
5. What is RDBMS.
6. What is Table, field and column.
7. Difference between DBMS and RDBMS.
8. The History of Oracle.
9. Normalizations Techniques.
10. Oracle Certification Program
11. Installing Oracle 11g DB in Windows.

Session-2 : Oracle Forms –

1. Installation of Oracle Developer Suite. Forms & Reports.
2. Oracle Developer- Form Builder components.

Session-3 : Oracle Database –

1. Storage Structures.
2. Database Recovery Method.
3. Different kinds of shutdown method.
4. Export and Import.
5. Lock and Unlock Users.
6. Parameter Files. (How to create the database archive.)

Session-4 : Oracle SQL & PLSQL –

1. Script Generations e.g. creating Folder, Tables and constraints.
2. Create the Project Structure.
3. PL/SQL Block Structure,
4. Anonymous Block.
5. Procedure, Function and Packages.

Session-5 : Oracle Developer-Create some Basic form e.g.

1. Department,
2. Dept wise employees (Master Details forms.)
3. Sal grade,
4. Roster type.

Session-6 : Oracle Database-

1. Oracle Instance Management.
2. Basic Networking Components. E.G.
   1. Tnsnames.ora
   2. Net Manager
   3. Net Configuration Assistant.
   4. Listener
   5. Database Configuration Assistant.
   6. Service

Session-7 : Oracle PLSQL and Developer-

1. If Conditions and loops.
2. Creating Menu.
3. Enable and Disable Menu.
4. Creating a Login Form,
5. Creating Main Form with Maximize Procedure.

Session-8 : Oracle SQL Triggers:

1. Application Trigger
2. DML Trigger and
3. Systems Triggers. e.g. Logon and Logoff Triggers.

Session-9 : Oracle Developer-Create Master Details forms and Reports.

1. Master Details Reports.
2. Leave Application,
3. Leave Application Details.

Session-10 : Oracle Developer:

1. Show Images with webutil and file system,
2. Different kinds of canvas and visual attributes.
3. Taking Backup from Forms.

Session-11 : Mock Test.

Session-12 : Oracle SQL, PLSQL and Forms: Demo Employee form –

1. Dynamic List Item, List of Values.
2. Combo Box : Gender Item.
3. Check Box. e.g. Roster type in Employee form.
4. PLSQL Procedure, WNFI AND P_SAVE in Forms.
5. PLSQL Function and Validation (F_VAL function) in Forms.

Session-13 : Oracle Developer:

1. Taking Backup from Forms and
2. Creating URL in Form. e.g. Change Password from User Login.
3. ADD and Drop User in form.
4. CHANGE PASSWORD In form.
5. Details form and Check Box : Active and Inactive in form.

Session-14 : Oracle PLSQL AND FORMS:

1. Creating Loops in PLSQL,
2. Creating “Roster” Procedure with loop in form.
3. PLSQL Cursor and Fetch Data in Forms.

Session-15 : Oracle Developer-Auto Number Generations and Alert Delete.

• Oracle Developer-Auto Number Generations in Loan Entry Screen and
• Alert Delete Data.
• Boolean Functions.
• Tab Canvus form Deptt and Emp Tables.

Session-16 : Attendance Generations (using DBlinks and get data from access DB).

1. Attendance Generations (using DBlinks to get data from access DB).
2. DBLink from another DB.
3. Get data from Excel and Access DB.

Session-17 : Various kinds of Reports without and with parameter.

1. Report Server configurations.
2. Group Above (Department Wise).
3. Group Left Report. (Department Wise).
4. Master Details Report.
5. Run Report with Parameter. E.g. Department wise Employees Report.

Session-18 : Oracle Reports- Function based Reports.

1. Creating some function related to Present, Absent and Late Reports.
2. Tabular Report (Present, Absent & Late reports.).
3. Run Report from Forms by Date or Employee.

Session-19 : Oracle Forms and Reports- Generate Salary

1. Creating Salary or Payroll from PLSQL procedures and procedures in forms.
2. Creating wages Forms and Tabular Report and Generate CSV Excel from forms.
3. Salary Report with Parameter.
4. Generate Manual Report with Parameter. Employee Details.

Muhammad Abdullah Al Noor,
Chief Oracle Trainer and CEO,
www.TrainerBD.com
Dial: +88 017 9072 1177
Skype: ensoftbd

Payment Method :

My Name of Bank Account :
Muhammad Abdullah Al Noor.
Name of Bank : Social Islami Bank.
Branch of Bank : New Eskaton Branch.
Account Number : 0551340007535
Bank Swift Code : SOIVBDDHESK

Paypal  link

Bikash Number : 01712128341

Dutch Bangla Mobile Banking  : 017121283419

Demo Class :

Dial : +88 017 9072 1177
Or Skype : ensoftbd
Or Email noor@trainerbd.com

To Start.

Class Time :

Anytime.