Oracle APEX Training Course Outline

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

• ORACLE SQL for Oracle APEX
• Oracle APEX
• 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

Functions

• 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