A PHP Error was encountered

Severity: Notice

Message: Only variable references should be returned by reference

Filename: core/Common.php

Line Number: 257

LumexTech Solutions Ltd. | PLSQL

Get in the loop


 Home / Pages / PLSQL

Training Overview

Database Management system is the heart and core of any dynamic website or application. If you are planning to develop any application you need to have idea about database management. This course is just what you need to get a headstart.


Training Objective

Learn DB management in general. Learn the query language SQL and differences of SQL between major DB servers MySQL,MSSQL Oracle. Learn to create Database and Optimize it for best performance



Attendes must have atleast some programming skills. Having


Hands-On/Lecture Ratio

This training class is 60% hands on 40% lecture. The training materials will be applied in real world problems on the class.


Training Materials

All related software lecture sheets and free e-book will be provided in class. Video recording of session can also be provided on specific occasions.

Course Content

Day 1
  • Introduction to the course
  • Familiarizing the concept of database server.
  • Examples of database servers
  • Setting up servers
Day 2
  • MySQL overview
  • Advantages of using Database PLSQL Procedures
Day 3
  • Creating Procedures in PLSQL
  • PLSQL syntax
Day 4
  • Query data with PLSQL
Day 5
  • Datatype, Condition and Looping in PLSQL
Day 6
  • Functions, Procedures and Blocks in PLSQL
Day 7
  • Practical Application of PLSQL procedures
Day 8
  • Re using queries with PLSQL
Day 9
  • Running PLSQL from PHP
Day 10
  • Building a simple Model Class PLSQL