Greens Technologys phone
Greens Technologys Whatsapp

"Call us for course fees and attractive discounts"

Oracle APEX Training In Chennai

Best Oracle APEX training institute in Chennai offers Job Oriented Hands-on Oracle APEX training in Chennai with Oracle SQL, PLSQL, HTML, Javascript by well experienced Oracle APEX professionals having 12 years of Oracle experience.

Try two Oracle APEX FREE CLASS to see for yourself the quality of training

About Oracle APEX Trainer

Dinesh work as a Oracle APEX Developer for a Leading MNC in Chennai with 10+ years experience in Oracle and contributing to the best Oracle APEX training in Chennai.

Oracle SQL, PLSQL, HTML & Oracle APEX and other ETL tools. 10+ years Oracle APEX experience Including Version 4.2

Talk to the Trainer @ +91-8939915572

Our Oracle APEX Training

Passionate about Oracle and especially Oracle Application Express (APEX). Founder and CEO of APEX RD, a company that provides Development, Training and Consulting in APEX.

Oracle APEX training benefits

  • My batch sizes are generally very small size 5-7 members OR 1 to 1 also, so students receive direct, hands-on training from us.
  • 100% practical training only. It is not a slide show training program / theory class program. At the end of this class, definitely you will refer your colleagues / friends / relatives for my training.
  • Conducting regularly online- training for US peoples in all time zones (PST,CST,EST,HST,MST)
  • Installation of Softwares in your desktop / laptop will be done.
  • Will be provided self evaluation testing software, exam simulator, dumps & books with this training.
  • Continuous support is provided for any of your on-site problems. assistance will be provided and you will be recommended to some of IT development firms.

For Oracle APEX Corporate Training

  • I will be more comfortable, if you could restrict the group not to exceed 20 persons.
  • Training hours will be 40 Hrs/paper in view of 20 participants.
  • Hardware for the required training should be provided by you, like Hall, Projector, and Furniture.
  • I will be bringing my laptop for training purpose, which should be allowed in to your premises.

    We offer job assistance (subject to project availability and partner requirements) for positions in India, Singapore, USA and the UK.

Oracle Application Express Teacher Guide

Oracle APEX Training Course Outline

Best Oracle APEX 4.2 Training Institute in Chennai, 100% Job Oriented Training.

  • ORACLE SQL for Oracle APEX
  • Oracle PLSQL
  • Oracle APEX
  • Unix Shell Scripting
  • Business Intelligence

Datawarehousing Concepts

  • What is DWH?
  • Characteristics of Datawarehouse
  • Difference between OLTP and DWH
  • Architecture of DWH
  • Various BI tools
  • Types of DWH
  • Types of Dimensional Data Modeling
  • Surrogate key
  • Types of Dimension

Oracle APEX Architecture

Oracle APEX Power Center Client Tools

  • Repository Manager
  • Manage Folders
  • Designer
  • Source Analyzer
  • Target Designer
  • Mapping Designer
  • Workflow Manager
  • Task Developer
  • Workflow Designer
  • Workflow Monitor
  • Workflow Log
  • Session Log
  • Types of View

Transformation Basics

  • Classification
  • Types of Ports
  • Data Types

Types of Transformations

Source Qualifier Transformation

  • Creating Simple Pass through Mapping
  • Apply Various Filter Conditions
  • Specify sorted ports
  • Eliminate Duplicate Values
  • Creating Custom SQL Query
  • Joining two or more tables

Filter Transformation

  • Compare with Source Filter
  • Types of Tracing Level
  • Types of Flatfiles
  • File Import Wizard
  • Load data from Flat File to Database
  • Load data from Database to Flat File

Sorter Transformation

  • Types of Ports
  • Multiple Sorting

Joiner Transformation

  • Joining two heterogenouse sources
  • Types of Joins
  • Sorted input option

Rank Transformation

  • Types of Ports
  • Rank Index
  • Rank and Dense rank

Sequence Generator

  • cycle option
  • Usage of Reset

Expression Transformation

  • Use of Expression
  • Usage of Variable Port
  • IIF and Decode functions

Aggregator Transformation

  • Oracle APEX aggregate functions
  • Sorted input option

Router Transformation

  • Types of Groups
  • Group Conditions

Union Transformation

  • Types of Groups

Normalizer Transformation

  • Types of Normalizer
  • Transpose Columns to Rows
  • Default Output Ports

Lookup Transformation

  • Connected Vs Unconnected Lookups
  • Unconnected Procedure
  • Lookup Caches

Stored Procedure Transformation

  • Create a Sample Procedure
  • DBA Script

Update Strategy Transformation

  • Database opertations
  • Data Driven

Transaction control Transformation

  • Dynamic File Generation

Slowly Growing Dimension

Slowly changing Dimension

  • Type 1
  • Type 2
  • Type 3

Transformation Developer

  • Create a Reusable Transformation
  • Promoting Transformations

Mapplet Designer

  • Create a reusable Mappings

Mapping Parameters

  • Design Parameter File

Mapping Variables

  • Set variables function

Session variables

  • Setting Connections
  • Workflow variables

File Repository Concepts

  • Indirect loading

Target Load Plan

  • Types of scheduling
  • Time-based schedule
  • Event -based schedule

Mapping Migration Process

  • Copy from Folder
  • Import and Export

Analytic SQL for Oracle APEX Training in Chennai

  • Course Objectives, Course Agenda and Class Account Information
  • Describe the Schemas and Appendices used in the Lesson
  • Overview of SQL*Plus Environment
  • Overview of SQL Developer
  • Overview of Analytic SQL
  • Oracle Database SQL and Data Warehousing Documentation

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

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

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

Analyzing and Reporting Data Using SQL

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

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

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

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

UNIX Shell Scripting for Oracle APEX Training

Unix Command Review

  • Basic Unix commands
  • General commands
  • File and directory handling commands
  • Filename generation characters
  • I/O Redirection features
  • Other commands

Getting Started

  • What is a shell script?
  • Development guidelines
  • Creating and editing shell scripts
  • Naming and storing shell scripts
  • Executing shell scripts
  • Exercise: Write a simple shell script

Using Variables

  • Environment variables
  • Local variables
  • Assigning values to variables
  • Assessing variable values
  • Using quotes
  • Delimiting variable names
  • Echo control sequences
  • Exercise: Add variables to a script

Integer Arithmetic

  • Using the expr command
  • Using the (( )) notation
  • Exercise: Add integer arithmetic to a shell script

Handling Run Time Data

  • The read command
  • Command line arguments
  • Exercise: Writing a generic shell script
  • Exercise: Writing an interactive shell script

Condition Execution

  • The if statement
  • The test command
  • Other test notations
  • Default and substitute variables
  • Exit status codes
  • Exercise: Adding validation to previous scripts

Loop Constructs

  • The while loop
  • The until loop
  • The for loop
  • The while true and until false loops
  • Loop control commands
  • Exercise: Enhancing the previously written scripts
  • Exercise: Writing a guess-the-number game

Multi-Branch Decisions

  • The case statement
  • Menu driven applications
  • Exercise: Developing and writing a menu system


  • What is a function?
  • Syntax
  • Examples
  • Exercise: Add a function to a script

Interrupt Handling

  • Interrupt signals
  • Trapping interrupts
  • Exercise: Adding traps to the menu script

Additional Features and Facilities

  • The exec commands
  • The includes notation
  • More about loops
  • Arrays
  • Here Documents
  • Exercise: Create a here script

Oracle APEX Training Course Highlights:

We are committed to provide Complete PRACTICAL Training and Complete REALTIME Training exclusively on Oracle APEX. Study Material and Practice Material included during the course. We are proud to mention that we are the Best institutes to provide Oracle APEX COMPLETE PRACTICAL REALTIME TRAINING and hence, closely working with various companies in India. Most of the trainees are references from our previous students. You can trust us for your Oracle APEX Trainings! We are, today, one of the few best training companies providing complete practical trainings on Oracle APEX

  • 1) Two days free trial - If candidate likes this course, these days are adjusted in his actual schedule.
  • 2) Live Project Exposure of Fortune companies.
  • 3) Training by Subject Matter experts from CMM Level 5 companies
  • 4) Running in two major financial cities of India – Chennai and Mumbai
  • 5) Worldwide online training of Oracle APEX and corporate classes at affordable fees.
  • 6) Our basic course worth more than the advanced course of other institutes/freelancers.
  • 7) Free Interview preparations.
  • 8) 100% free assistance for Oracle APEX certifications.
  • 9) 100 % guarantee in succeeding the certification at affordable fees.
  • 10) Also provide online training to students of foreign countries.
  • Learn Oracle APEX training from the Best Oracle APEX Institute in Chennai

    We teach Data Warehousing Oracle APEX Training courses with real time scenarios and give interview guidance. Join us to shape your career in Datawarehousing (DWH).

We are the Best Oracle APEX Corporate Training Institute In Chennai

Oracle APEX Training in Chennai is one of the best Oracle APEX training institute in Chennai which offers complete Oracle APEX training in Chennai by well experienced Oracle APEX Consultants having more than 12+ years of IT experience. We provide best and high quality Oracle APEX training based on current industry standards. You can gain more knowledge about Oracle APEX, its implementation process on joining out Oracle APEX course.

Oracle APEX ETL Current Market

Oracle APEX ETL Technology has been the most in thing in the world from past 2-4 years. Oracle APEX ETL Power Centre picked up its demand in recent times and now it is the most accepted and famous technology in the world of Business Intelligence (BI).

Demand Supply curve is very prominent in this technology. Demand is huge and supply is very less, thus in recent times all ETL resources have scruffled the market by taking huge returns as justified the theory i.e. when deman is more and supply is less, the supply will get fruitful results.

Oracle APEX ETL: Oracle APEX is a corporation which provides tool to ETL technology. The most famous product of Oracle APEX ETL is Oracle APEX Power Centre version 9.x.

Oracle APEX Developers are enjoying the positive trend of the market these days but in coming times, they will have to develop more skills as Oracle APEX MDM is also picking up the market and also the most in things i.e. Big Data.

Oracle APEX Power Center is most accepted in banking, healthcare , insurance, Research and development, credit card service providers and more., all the major banks are using this technology and have accepted it with glee.

Sai Ravi
Data Warehouse Architect
10 years exp
Working in a reputed MNC in Chennai.
Contact - +91-89399 15572

Oracle APEX Training Reviews

Greens Technology Oracle APEX Reviews given by our students already completed Oracle APEX training with us. Please give your feedback as well if you are a student.

best OBIEE training center in chennai "I started OBIEE course with no knowledge at all,and i completed with lot of knowledge..this all because of Siva..who is very good at explaining subject very clearly..Siva--i know many people who knows subject and cannot express or explain it to students in an understandable way..but you rock the last thing Siva,you are a very good far in my experience you are the best..thanks for all the support"

OBIEE training chennai ""Sai! I am really delighted about the Teradata course and i am surprised to see the depth of your knowledge in all aspects of the Teradata. I see that many database architects with over 15+ yrs experience doesn't have the knowledge that you have. I really enjoyed your sessions, definitely look forward to learn more from you in the future. Thanks again." "

OBIEE training classes in chennai "Dear Sai! This e-mail is to say BIG THANK YOU..for all teaching you done in our Teradata training sessions. I GOT JOB as Tearadata Developer after almost 6 months of struggle here in Chennai. I must Thank you for such a good and rocking lessons. to tell you frankly you made me to like/love/crazy about Tearadata though i have no idea about it before joining your classes." This is my first job in IT after my studies and i am a bit tensed how things will be after joining in the company. your suggestions are more helpful for me to get on well in the company as good developer."

OBIEE training chennai "Greens technology the best OBIEE training in chennai. I have seen many training institutions in Chennai. But GREENS TECHNOLOGY is the best institute for OBIEE. Especially the Trainer Mr. Siva is Excellent. He has such huge experience in real time. The training method was very good. They are providing latest version of tool with project support."