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
x

Get in the loop

PLSQL

 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

 

Prerequisites

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