Oracle APEX Training in Chennai

ORACLE APEX Training in Chennai

Learn ORACLE APEX At GREENS TECHNOLOGY – No 1 ORACLE APEXTraining and in chennai. Call 89399 15577 For More Details. Register today for learning basic ORACLE APEX Training in chennai

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.

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

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.


Get Trained at GREENS TECHNOLOGY and become a APEX Guru!

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.

Specialties

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

Talk to the Trainer @ +91-89399 15577

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 Syllabus

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

Analytic SQL for Oracle APEX Training in Chennai

  • 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

You can contact us @ 89399 15577 or fill in the Quick Enquiry form to get detailed information about Oracle APEX training in Chennai. Join Greens Technology for Best oracle APEX training in Chennai.

STUDENTS TESTIMONIALS

About INSTRUCTOR




For Chennai Branches
Adyar
+91- 89399 15577
OMR
+91- 89399 25577
Velachery
+91- 89399 15577
Tambaram
+91- 75501 66012

QuickEnquiry




RecentlyPlaced Students




Prakash
Seya Soft Technologies
Android Developer

Siva Kumar
CTS
JAVA Developer

Manish
Pointel
Dot Net Developer

Aishwarya
BNP Paribas
Dot Net Developer

Nithish
Wipro
Java Developer