Oracle APEX Training in OMR Chennai

ORACLE APEX TRAINING COURSE OUTLINE

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