Oracle APEX Course Fee: : (SQL + PLSQL + HTML + Oracle APEX + Unix + Data Modeling) with a price of Rs. 20,000/-
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-8939915577
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 APEX Training Course Outline
Best Oracle APEX 4.2 Training Institute in Chennai, 100% Job Oriented Training.
ORACLE SQL for Oracle APEX
Unix Shell Scripting
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
Types of Dimension
Oracle APEX Architecture
Oracle APEX Power Center Client Tools
Types of View
Types of Ports
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
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
Types of Ports
Joining two heterogenouse sources
Types of Joins
Sorted input option
Types of Ports
Rank and Dense rank
Usage of Reset
Use of Expression
Usage of Variable Port
IIF and Decode functions
Oracle APEX aggregate functions
Sorted input option
Types of Groups
Types of Groups
Types of Normalizer
Transpose Columns to Rows
Default Output Ports
Connected Vs Unconnected Lookups
Stored Procedure Transformation
Create a Sample Procedure
Update Strategy Transformation
Transaction control Transformation
Dynamic File Generation
Slowly Growing Dimension
Slowly changing Dimension
Create a Reusable Transformation
Create a reusable Mappings
Design Parameter File
Set variables function
File Repository Concepts
Target Load Plan
Types of scheduling
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
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
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
File and directory handling commands
Filename generation characters
I/O Redirection features
What is a shell script?
Creating and editing shell scripts
Naming and storing shell scripts
Executing shell scripts
Exercise: Write a simple shell script
Assigning values to variables
Assessing variable values
Delimiting variable names
Echo control sequences
Exercise: Add variables to a script
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
The if statement
The test command
Other test notations
Default and substitute variables
Exit status codes
Exercise: Adding validation to previous scripts
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
The case statement
Menu driven applications
Exercise: Developing and writing a menu system
What is a function?
Exercise: Add a function to a script
Exercise: Adding traps to the menu script
Additional Features and Facilities
The exec commands
The includes notation
More about loops
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.
Data Warehouse Architect
10 years exp
Working in a reputed MNC in Chennai.
Contact - +91-89399 15577
"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 subject..one last thing Siva,you are a very good instructor..so far in my experience you are the best..thanks for all the support"
""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." "
"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."
Greens Technologys Overall Reviews4.9
out of 5
based on 17 ratings.
17 user reviews.
"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."