Oracle PL/SQL Training

STAR 5 Star Rating 500+ Learners 

Course Content



Call us

Oracle PL/SQL Training in Chennai at Credo Systemz is the best place to do your Oracle PL/SQL Certification Training because of its practical real time live project training with latest updated PL/SQL Course Content (Free PDF Download). Oracle PL/SQL Training course is designed from basic to advance level topics which suits both beginners and professionals.

Give a call to +91 988 441 2301 to know Oracle PL/SQL course fees with offers.

About Oracle PL/SQL Course

What is Oracle PL/SQL ?

Oracle PL/SQL is a procedural language designed specifically to embrace SQL statements within its syntax.  Oracle PL/SQL program units are compiled by the Oracle Database server and stored inside the database. And at run-time, both PL/SQL and SQL run within the same server process, bringing optimal efficiency.

Key Features

Training from
Industrial Experts


100% Placement

Expert Support

24 x 7
Expert Support

for Course



Section1: Introduction

  • Describe the features of Oracle Database 12c
  • Describe the salient features of Oracle Cloud 12c
  • Explain the theoretical and physical aspects of a relational database
  • Describe Oracle server€™s implementation of RDBMS and object relational database management system (ORDBMS)

Section2: Basic DATABASE Concept and SQL

  • Basic history of database concept: DBMS, RDBMS, ORDBMS
  • Advantage of ORACLE database and version information
  • Interface tools usage: sqlplus, isqlplus, sqldeveloper, Toad
  • SQL Language overview : DQL, DML, DDL, DCL, TCL
  • What is the usage of ANSI standard
  • SELECT Command – Column Alias Rules, String data
  • Concatenations with various data
  • Null Value handling with number and characters
  • Arithmetic Operator
  • Concatenation Operator
  • Eliminating Duplicate Rows

Section3: Restricting and Sorting Data

  • WHERE Clause – Character Strings and Dates, number
  • General Comparison Conditions = > >= < <= <>
  • Other Comparison BETWEEN , IN , LIKE , NULL
  • Logical Conditions AND OR NOT
  • ORDER BY Clause, Sorting by Column Alias , Column Position, Multiple Columns

Section4: Single-Row Functions

  • Number Functions: ROUND, TRUNC, MOD, POWER, CEIL , FLOOR, ABS
  • Conversion Functions: Implicit Data-Type Conversion & Explicit Data-Type Conversion, TO_CHAR ,TO_NUMBER ,TO_DATE
  • General Functions: NVL , NVL2 , NULLIF, COALESCE
  • CASE Expression, DECODE
  • Nested function with real-time usage

Section5: JOINS

  • INNER JOIN, JOIN … USING clause, JOIN … ON clause
  • Multi table Joins, Complex Joins €“ How to simplified complex joins

Section6: Multi-row Functions

  • Group Functions Rules, SUM, MIN, MAX, COUNT, AVG
  • Creating Groups of Data: GROUP BY Clause
  • Filtering Group Results: The HAVING Clause

Section7: Sub-queries

  • Single-Row Subqueries- Rules, Operators : = > >= < <= <>
  • Null Values in a Subquery
  • Multi-Row Subqueries- Rules, Operators : IN, ANY , ALL

Section8: Reporting data using interface commands

  • Pagesize, linesize , column heading , column format , colsep
  • tTitle , bTitle , break on column, spool , CSV file generation, Text file generation

Section9: Data Manipulation Language DML and Transaction Control Language TCL


Section10: Data Definition Language – DDL

  • Constrain table copy

Section11: Constraints

  • Column Level Constraint, Table Level Constraint €“ Naming constraints and usage
  • Adding a Constraint, Dropping a Constraint
  • Disabling Constraints, Enabling Constraints
  • Validating Constraints

Section12: Views

  • Simple Views and Complex Views €“ Create, Drop, Source Code
  • Rules for Performing DML Operations on a View
  • Inline Views
  • Materialized View €“ Create, Refresh, Drop – Usage

Section13: Other Database Objects

  • Sequence- NEXTVAL and CURRVAL
  • Index – When to Create an Index, When Not to Create an Index.
  • Synonyms


  • Creating Users
  • Granting / Revoking Privileges
  • Creating and Granting Privileges to a Role

Section15: Dictionary Tables

  • Tables, Views, Synonyms, Index, Sequence, Constrains, Source and other Dictionary

Section16: SET Operators


Section17: Advanced Date-time Functions

  • Storing time zone data in Table

Impressed with our Course Content?
Attend a Free Demo Session to Experience our Quality!

Section18: Advanced GROUP BY Clause

  • Group by with ROLLUP
  • Group by with CUBE

Section19: Advanced Subqueries

  • Pairwise Comparison Subquery
  • Nonpairwise Comparison Subquery
  • Correlated Subqueries
  • Correlated UPDATE
  • Correlated DELETE
  • EXISTS , NOT EXISTS Operator

Section20: Hierarchical Retrieval

  • Walking the Tree: From the Bottom Up , From the Top Down
  • LEVEL Pseudo column
  • Connect by prior

Section21: Multi-table Insert

  • Unconditional INSERT ALL
  • Conditional INSERT ALL
  • Conditional FIRST INSERT

Section22: DATA LOADER

  • SQLLDR €“ Loading CSV file / Flat file into ORACLE table.

Section23: Analytic Functions

  • Query_by partition_clause with sum, min, max, avg, count
  • order_by_clause with sum, min, max, avg, count
  • Psudo column : Rownum, Rowid, – Elimination duplicate data
  • Connect by rownum , Connect by Level €“ Generating random numbers, random dates
  • Quote Operator syntax and usage

Section24: Backup

  • Export / Import SCHEMA

Section25: General discussion

  • What is migration?
  • Migration Estimating, Planning, Preparation €“ Simple Scenario / Complex Scenario.


Section1: Grouping and Aggregating Data Using SQL

  • Generating Reports by Grouping Related Data
  • Review of Group Functions
  • Reviewing GROUP BY and HAVING Clause
  • Using the ROLLUP and CUBE Operators
  • Using the GROUPING Function
  • Working with GROUPING SET Operators and Composite Columns
  • Using Concatenated Groupings with Example

Section2: Hierarchical Retrieval

  • Using Hierarchical Queries
  • Sample Data from the EMPLOYEES Table
  • Natural Tree Structure
  • Hierarchical Queries: Syntax
  • Walking the Tree: Specifying the Starting Point
  • Walking the Tree: Specifying the Direction of the Query
  • Using the WITH Clause
  • Hierarchical Query Example: Using the CONNECT BY Clause

Section3: Working with Regular Expressions

  • Introducing Regular Expressions
  • Using the Regular Expressions Functions and Conditions in SQL and PL/SQL
  • Introducing Metacharacters
  • Using Metacharacters with Regular Expressions
  • Regular Expressions Functions and Conditions: Syntax
  • Performing a Basic Search Using the REGEXP_LIKE Condition
  • Finding Patterns Using the REGEXP_INSTR Function
  • Extracting Substrings Using the REGEXP_SUBSTR Function

Section4: Analyzing and Reporting Data Using SQL

  • Overview of SQL for Analysis and Reporting Functions
  • Using Analytic Functions
  • Using the Ranking Functions
  • Using Reporting Functions

Section5: Performing Pivoting and Unpivoting Operations

  • Performing Pivoting Operations
  • Using the PIVOT and UNPIVOT Clauses
  • Pivoting on the QUARTER Column: Conceptual Example
  • Performing Unpivoting Operations
  • Using the UNPIVOT Clause Columns in an UNPIVOT Operation
  • Creating a New Pivot Table: Example

Section6: Pattern Matching using SQL

  • Row Pattern Navigation Operations
  • Handling Empty Matches or Unmatched Rows
  • Excluding Portions of the Pattern from the Output
  • Expressing All Permutations
  • Rules and Restrictions in Pattern Matching
  • Examples of Pattern Matching

Section7: Modeling Data Using SQL

  • Using the MODEL clause
  • Demonstrating Cell and Range References
  • Using the CV Function
  • Using FOR Construct with IN List Operator, incremental values and Subqueries
  • Using Analytic Functions in the SQL MODEL Clause
  • Distinguishing Missing Cells from NULLs
  • Using the UPDATE, UPSERT and UPSERT ALL Options
  • Reference Models


Section1: Exploring the Oracle Database Architecture

  • Describe the major architectural components of Oracle Database server
  • Explain memory structures
  • Describe background processes
  • Correlate logical and physical storage structures

Section2: Introduction to SQL Tuning

  • Describe what attributes of a SQL statement can make it perform poorly
  • Describe the Oracle tools that can be used to tune SQL
  • Explain the tuning tasks

Section3: Introduction to the Optimizer

  • Describe the execution steps of a SQL statement
  • Explain the need for an optimizer
  • Explain the various phases of optimization
  • Control the behavior of the optimizer

Section4: Interpreting Execution Plans

  • Gather execution plans
  • Display execution plans, display xplan
  • Interpret execution plans

Section5: Application Tracing

  • Configure the SQL Trace facility to collect session statistics
  • Use the trcsess utility to consolidate SQL trace files
  • Format trace files using the tkprof utility
  • Interpret the output of the tkprof command

Section6: Optimizer Operations

  • Describe the SQL operations for tables and indexes
  • Describe the possible access paths for tables and indexes

Section7: Optimizer: Join Operations

  • Describe the SQL operations for joins
  • Describe the possible access paths for joins

Section8: Other Optimizer Operations

  • Describe Clusters, In-List, Sorts, Filters and Set Operations
  • Use Result Cache operations

Section9: Case Study: Star Transformation

  • Define a star schema, a star query plan without transformation and a star query plan after transformation

Section10: Optimizer Statistics

  • Gather optimizer statistics
  • Gather system statistics
  • Set statistic preferences
  • Use dynamic sampling
  • Manipulate optimizer statistics

Section11: Using Bind Variables

  • Explain the benefits of using bind variables
  • Use bind peeking
  • Use adaptive cursor sharing

Section12: SQL Tuning Advisor

  • Describe statement profiling
  • Use SQL Tuning Advisor

Section13: Using SQL Access Advisor

  • Use SQL Access Advisor

Section14: Automating SQL Tuning

  • Use Automatic SQL Tuning

Section15: SQL Plan Management

  • Manage SQL performance through changes
  • Set up SQL Plan Management
  • Set up various SQL Plan Management scenarios

Section16: Using Optimizer Hints

  • Use hints when appropriate
  • Specify hints for Optimizer mode, Query transformation, Access path, Join orders, Join methods and Views

Section17: Parallel Processing Concepts

  • Explain what parallel processing is and why is it useful

Section18: Basics of Parallel Execution

  • Describe operations that can be parallelized
  • Explain parallel execution theory
  • Understand impact of initiali zation parameter on parallel execution

Section19: Manual DOP Management

  • Understand an explain plan of a parallel query
  • Understand an explain plan of parallel DML and DDL

Section20: Simplified Auto DOP

  • Understand the new parameters of Auto DOP
  • Explain when to use Auto DOP
  • Use Auto DOP

Section21: Statement Queuing

  • Explain statement queuing, concurrency and DBRM

Section22: In-Memory Parallel execution

  • Use in-memory parallel execution

Section23: Partitioning Concepts

  • Explain the available partitioning strategies
  • Explain partition pruning
  • Implement partition enhancements in star query optimization

Section24: Materialized Views

  • Use summaries to improve performance
  • Differentiate materialized view types


Section1: Introduction

  • Course Objectives
  • Course Agenda
  • Human Resources (HR) Schema
  • Introduction to SQL Developer

Section2: Introduction to PL/SQL

  • PL/SQL Overview
  • Benefits of PL/SQL Subprograms
  • Overview of the Types of PL/SQL blocks
  • Create a Simple Anonymous Block
  • Generate Output from a PL/SQL Block

Section3: PL/SQL Identifiers

  • List the different Types of Identifiers in a PL/SQL subprogram
  • Usage of the Declarative Section to define Identifiers
  • Use variables to store data
  • Identify Scalar Data Types
  • The %TYPE Attribute
  • What are Bind Variables?
  • Sequences in PL/SQL Expressions

Section4: Write Executable Statements

  • Describe Basic PL/SQL Block Syntax Guidelines
  • Comment Code
  • Deployment of SQL Functions in PL/SQL
  • How to convert Data Types?
  • Nested Blocks
  • Identify the Operators in PL/SQL

Section5: Interaction with the Oracle Server

  • Invoke SELECT Statements in PL/SQL to Retrieve data
  • Data Manipulation in the Server Using PL/SQL
  • SQL Cursor concept
  • Usage of SQL Cursor Attributes to Obtain Feedback on DML
  • Save and Discard Transactions

Section6: Control Structures

  • Conditional processing Using IF Statements
  • Conditional processing Using CASE Statements
  • Use simple Loop Statement
  • Use While Loop Statement
  • Use For Loop Statement
  • Describe the Continue Statement

Section7: Composite Data Types

  • Use PL/SQL Records
  • The %ROWTYPE Attribute
  • Insert and Update with PL/SQL Records
  • Associative Arrays (INDEX BY Tables)
  • Examine INDEX BY Table Methods
  • Use INDEX BY Table of Records

Section8: Explicit Cursors

  • What are Explicit Cursors?
  • Declare the Cursor
  • Open the Cursor
  • Fetch data from the Cursor
  • Close the Cursor
  • Cursor FOR loop
  • Explicit Cursor Attributes
  • FOR UPDATE Clause and WHERE CURRENT Clause

Section9: Exception Handling

  • Understand Exceptions
  • Handle Exceptions with PL/SQL
  • Trap Predefined Oracle Server Errors
  • Trap Non-Predefined Oracle Server Errors
  • Trap User-Defined Exceptions
  • Propagate Exceptions

Section10: Stored Procedures and Functions

  • Understand Stored Procedures and Functions
  • Differentiate between anonymous blocks and subprograms
  • Create a Simple Procedure
  • Create a Simple Procedure with IN parameter
  • Create a Simple Function
  • Execute a Simple Procedure
  • Execute a Simple Function

Section11: Create Stored Procedures

  • Create a Modularized and Layered Subprogram Design
  • Modularize Development With PL/SQL Blocks
  • Describe the PL/SQL Execution Environment
  • Identity the benefits of Using PL/SQL Subprograms
  • List the differences Between Anonymous Blocks and Subprograms
  • Create, Call, and Remove Stored Procedures Using the CREATE Command and SQL Developer
  • Implement Procedures Parameters and Parameters Modes
  • View Procedures Information Using the Data Dictionary Views and SQL Developer

Section12: Create Stored Functions

  • Create, Call, and Remove a Stored Function Using the CREATE Command and SQL Developer
  • Identity the advantages of Using Stored Functions in SQL Statements
  • List the steps to create a stored function
  • Implement User-Defined Functions in SQL Statements
  • Identity the restrictions when calling Functions from SQL statements
  • Control Side Effects when calling Functions from SQL Expressions
  • View Functions Information

Section13: Create Packages

  • Identity the advantages of Packages
  • Describe Packages
  • List the components of a Package
  • Develop a Package
  • How to enable visibility of a Package€™s components?
  • Create the Package Specification and Body Using the SQL CREATE Statement and SQL Developer
  • Invoke Package Constructs
  • View PL/SQL Source Code Using the Data Dictionary

Section14: Packages

  • Overloading Subprograms in PL/SQL
  • Use the STANDARD Package
  • Use Forward Declarations to Solve Illegal Procedure Reference
  • Implement Package Functions in SQL and Restrictions
  • Persistent State of Packages
  • Persistent State of a Package Cursor
  • Control Side Effects of PL/SQL Subprograms
  • Invoke PL/SQL Tables of Records in Packages

Section15: Implement Oracle-Supplied Packages in Application Development

  • What are Oracle-Supplied Packages?
  • Examples of Some of the Oracle-Supplied Packages
  • How Does the DBMS_OUTPUT Package Work?
  • Use the UTL_FILE Package to Interact With Operating System Files
  • Invoke the UTL_MAIL Package
  • Write UTL_MAIL Subprograms

Section16: Dynamic SQL

  • The Execution Flow of SQL
  • What is Dynamic SQL?
  • Declare Cursor Variables
  • Dynamically executing a PL/SQL Block
  • Configure Native Dynamic SQL to Compile PL/SQL Code
  • Invoke DBMS_SQL Package
  • Implement DBMS_SQL with a Parameterized DML Statement
  • Dynamic SQL Functional Completeness

Section17: Design Considerations for PL/SQL Code

  • Standardize Constants and Exceptions
  • Understand Local Subprograms
  • Write Autonomous Transactions
  • Implement the NOCOPY Compiler Hint
  • Invoke the PARALLEL_ENABLE Hint
  • The Cross-Session PL/SQL Function Result Cache
  • The DETERMINISTIC Clause with Functions
  • Usage of Bulk Binding to Improve Performance

Section18: Triggers

  • Describe Triggers
  • Identify the Trigger Event Types and Body
  • Business Application Scenarios for Implementing Triggers
  • Create DML Triggers Using the CREATE TRIGGER Statement and SQL Developer
  • Identify the Trigger Event Types, Body, and Firing (Timing)
  • Statement Level Triggers Versus Row Level Triggers
  • Create Instead of and Disabled Triggers
  • How to Manage, Test, and Remove Triggers?

Section19: Create Compound, DDL, and Event Database Triggers

  • What are Compound Triggers?
  • Identify the Timing-Point Sections of a Table Compound Trigger
  • Compound Trigger Structure for Tables and Views
  • Implement a Compound Trigger to Resolve the Mutating Table Error
  • Compare Database Triggers to Stored Procedures
  • Create Triggers on DDL Statements
  • Create Database-Event and System-Event Triggers
  • System Privileges Required to Manage Triggers

Section20: The PL/SQL Compiler

  • What is the PL/SQL Compiler?
  • Describe the Initialization Parameters for PL/SQL Compilation
  • List the New PL/SQL Compile Time Warnings
  • Overview of PL/SQL Compile Time Warnings for Subprograms
  • List the benefits of Compiler Warnings
  • List the PL/SQL Compile Time Warning Messages Categories
  • Setting the Warning Messages Levels: Using SQL Developer, PLSQL_WARNINGS Initialization Parameter, and the DBMS_WARNING Package Subprograms
  • View Compiler Warnings: Using SQL Developer, SQL*Plus, or the Data Dictionary Views

Section21: Manage PL/SQL Code

  • What Is Conditional Compilation?
  • Implement Selection Directives
  • Invoke Predefined and User-Defined Inquiry Directives
  • The PLSQL_CCFLAGS Parameter and the Inquiry Directive
  • Conditional Compilation Error Directives to Raise User-Defined Errors
  • The DBMS_DB_VERSION Package
  • Write DBMS_PREPROCESSOR Procedures to Print or Retrieve Source Text
  • Obfuscation and Wrapping PL/SQL Code

Section22: Manage Dependencies

  • Overview of Schema Object Dependencies
  • Query Direct Object Dependencies using the USER_DEPENDENCIES View
  • Query an Object€™s Status
  • Invalidation of Dependent Objects
  • Display the Direct and Indirect Dependencies
  • Fine-Grained Dependency Management in Oracle Database 11g
  • Understand Remote Dependencies
  • Recompile a PL/SQL Program Unit

Section23: Designing PL/SQL Code

  • Describe the predefined data types
  • Create subtypes based on existing types for an application
  • List the different guidelines for cursor design
  • Cursor variables

Section24: Using Collections

  • Overview of collections
  • Use Associative arrays
  • Use Nested tables
  • Use VARRAYs
  • Compare nested tables and VARRAYs
  • Write PL/SQL programs that use collections
  • Use Collections effectively

Section25: Manipulating Large Objects

  • Describe a LOB object
  • Use BFILEs
  • Use DBMS_LOB.READ and DBMS_LOB.WRITE to manipulate LOBs
  • Create a temporary LOB programmatically with the DBMS_LOB package
  • Introduction to SecureFile LOBs
  • Use SecureFile LOBs to store documents
  • Convert BasicFile LOBs to SecureFile LOB format
  • Enable reduplication and compression

Section26: Using Advanced Interface Methods

  • Calling External Procedures from PL/SQL
  • Benefits of External Procedures
  • C advanced interface methods
  • Java advanced interface methods

Section27: Performance and Tuning

  • Understand and influence the compiler
  • Tune PL/SQL code
  • Enable intra unit inlining
  • Identify and tune memory issues
  • Recognize network issues

Section28: Improving Performance with Caching

  • Describe result caching
  • Use SQL query result cache
  • PL/SQL function cache
  • Review PL/SQL function cache considerations

Section29: Analyzing PL/SQL Code

  • Finding Coding Information
  • Collecting PL/Scope Data

Section30: Profiling and Tracing PL/SQL Code

  • Tracing PL/SQL Execution
  • Tracing PL/SQL Steps

Section31: Implementing VPD with Fine-Grained Access Control

  • Understand how fine-grained access control works overall
  • Describe the features of fine-grained access control
  • Describe an application context
  • Create an application context
  • Set an application context
  • List the DBMS_RLS procedures
  • Implement a policy
  • Query the dictionary views holding information on fine-grained access

Section32: Safeguarding Your Code Against SQL Injection Attacks

  • SQL Injection Overview
  • Reducing the Attack Surface
  • Avoiding Dynamic SQL
  • Using Bind Arguments
  • Filtering Input with DBMS_ASSERT
  • Designing Code Immune to SQL Injections
  • Testing Code for SQL Injection Flaws


Best Oracle Pl/SQL Training Institute in Chennai

Our Best Oracle Pl/SQL Training in Chennai also guarantees you providing cost effective training, where you have to get training from top Pl/SQL Corporate Minds. Our satisfied candidate has ranked us as a Best Oracle Pl/SQL Training institute in Chennai with Practical/Hands-on training with free placement support. Check out the free placement drives conducted in our premises.

Check out : Current Job Opportunities in our Client Company

Why Should I Learn PL/SQL From Credo Systemz?

Credo Systemz provides  Best Oracle PL/SQL training. In this Oracle  PL/SQL training will help you master the creation, implementation and management of very large database applications.

Queries You may have

Prerequisites to learn Oracle PL SQL?
This question has been asked frequently by Most of the candidates while enquiring about our Oracle PL/SQL training in Chennai
Here is the answer for you,
  • This is a Beginner course and hence no specific prerequisites
  • Basic computer knowledge is desirable
What are the benefits of Oracle PLSQL?
  • Reduces Network Traffic
  • Error Handling
  • Improved Performance
  • Portability
  • High-Security level
  • Support for object-oriented Programming

Click Here to Join this Course

Book your DEMO session for the Oracle Pl/Sql Training

Related Trainings

Oracle Pl/Sql Training in Credo Systemz – Review

Oracle Pl/SQL Training in velachery  
Author Picture

Hello Everyone, I am Srinithi working in Data Tracks, Came to know about Credo Systemz through my colleague as he did his PL/SQL training previously, Came for a demo session here and satisfied with it and joined in the next batch itself, Session starts from basic topics which helped me to grab the concept easily. My trainer is an experienced guy so can able to understand the real time problems as well. Learned a lot, like a real-time working experience. Thank You, Credo & My Trainer.

Oracle Pl/SQL Training  
Author Picture

Thoroughly enjoyed the course! Excellent coverage by the trainer and constant support by Credo systemz Very happy to have taken this Oracle Pl/SQL  Training in velachery. The course covered majority important topics and helped me build applications very quickly with clear understanding.

Best Oracle PL/SQL Training  
Yadav Krish   
Author Picture

Great learning experience with proficient trainers  for Oracle PL/SQL Training in Credo Systemz. Flexible timings with hands on experience with real time scenarios. Good value for the money paid and I got placed in multi-national company. Thank you Credo Systemz.

Good Learning Experience  
Ashok Kumar   
Author Picture

Hi ,this is Ashok Kumar I did my Oracle Pl/SQL  Training at Credo Systemz and i am very much happy about the experience. Affordable fees and their sessions were more focused on job oriented and practical oriented training. I suggest Credo systemz is the best training institute in chennai

Fantastic course! Really helpful tutors  
Author Picture

My training at CREDO SYSTEMZ for Oracle PL/SQL has been instrumental in my getting placed in Cognizant. Even though Im a fresher, the trainer has given me extensive training on SQL & PL-SQL concepts.
I was confident and clear about my knowledge while appearing for interview. The interview went without any fear. I conquered my interview fear and my job search comes to end. Thanks to CREDO SYSTEMZ for the wonderful transformation of me into a professional.

Check here for candidates feedback on Oracle PL/SQL Training through CREDO SYSTEMZ Reviews, Video Reviews, Google+ Reviews

Most Popular Regions

  • Oracle Training in Velachery
  • Oracle Training in Adyar
  • Oracle Training in Guindy
  • Oracle Training in Taramani
  • Oracle Training in OMR
  • Oracle Training in Pallikarnai
  • Oracle Training in Saidapet
  • Oracle Training in Vadapalani
  • Oracle Training in Koyambedu
  • Oracle Training in Porur