erpinfotek

[erpinfotek]

ERP Infotek offers SAP FICO Online Training by experienced and SAP certified trainers. We provide end to end implementation training with GL Accounting, Accounts Payable, Accounts receivables, Asset accounting, cost center accounting and other technologies.

#SAP FICO Online Training #SAP FICO Online Training in india

[erpinfotek]

ERP Infotek provides Data Ware House Business Objects online training classes by certified experts with strong Business Objects experience. Our MicroStrategy online training is regarded as one of the best online training in Bangalore offering for US, UK, UAE etc.

#Data Ware House Business Objects online training #Data Ware House Business Objects online training in India #Data Ware House Business Objects online training in Bangalore

[erpinfotek]

ERP Infotek provides MicroStrategy online training classes by certified experts with strong MicroStrategy experience. Our MicroStrategy online training is regarded as one of the best online training in Bangalore offering for US, UK, UAE etc.

#MicroStrategy online training #MicroStrategy online training in india #MicroStrategy online training in Bangalore

[erpinfotek]

ERP Infotek provides Data Ware House DataStage classes by certified experts with strong DataStage experience. Our Data Stage online training is regarded as one of the best online training in Bangalore, India offering for US, UK, UAE etc.

#online training #online training in india #online training in Bangalore

[erpinfotek]

ERP Infotek provides Ab Initio online training classes by certified experts with strong Ab Initio experience. Our Ab Initio online training is regarded as one of the best online training in Bangalore offering for US, UK, UAE etc.

#Ab Initio online training #Ab Initio online training in india #Ab Initio online training in bangalore

[erpinfotek]

ERP Infotek provides Cognos online training classes by certified experts with strong Cognos experience. Our Cognos online training is regarded as one of the best online training in Bangalore offering for US, UK, UAE etc.

#Cognos online training #Cognos online training in india #Cognos online trainingin bangalore

[erpinfotek]

ERP Infotek provides Informatica online training classes by certified experts with strong Informatica experience. Our Informatica online training is regarded as one of the best online training in Bangalore offering for US, UK, UAE etc.

#Informatica online training #Informatica online training in india

[erpinfotek]

ERP Infotek provides PeopleSoft GL (General Ledger) online training classes by certified experts with strong PeopleSoft experience. Our PeopleSoft General Ledger online training is regarded as one of the best online training in Bangalore offering for US, UK, UAE etc.

#PeopleSoft GL (General Ledger) online training

[erpinfotek]

ERP Infotek provides PeopleSoft HRMS Functional online training classes by certified experts with strong PeopleSoft experience. Our PeopleSoft HRMS Functional online training is regarded as one of the best online training in India offering for US, UK, UAE etc.

#PeopleSoft HRMS Functional online training

[erpinfotek]

ERP Infotek provides PeopleSoft HRMS Technical online training classes by certified experts with strong PeopleSoft experience. Our PeopleSoft HRMS Technical online training is regarded as one of the best online training in India offering for US, UK, UAE etc.

#PeopleSoft HRMS Technical online training

[erpinfotek]

ERP Infotek provides PeopleSoft Security online training classes by certified experts with strong PeopleSoft experience. Our PeopleSoft Security online training is regarded as one of the best online training in Bangalore offering for US, UK, UAE etc.

#PeopleSoft Security online training #PeopleSoft Security training #PeopleSoft Security online training in India

[erpinfotek]

ERP Infotek provides PeopleSoft Admin online training classes by certified experts with strong PeopleSoft experience. Our PeopleSoft Admin

#PeopleSoft Admin online PeopleSoft Admin online training PeopleSoft Admin training PeopleSoft Admin online

[erpinfotek]

SAP online Training in india

[erpinfotek]

Hyperion Online Training in India

[erpinfotek]

Hyperion Essbase Online Training

Hyperion Essbase Online Training at ERP Infotek ERP Infotek providing Hyperion Essbase online training classes by certified experts with strong industry experience. Our Hyperion Essbase online training is regarded as the one of the best online training in India. ERP Infotek online training have one to one classes, batch classes

Data Warehousing Concepts

Introduction of Data-Warehousing Concepts

Schema Models

OLAP Models and brief explanation on ROLAP and MOLAP

Identification of Dimensions and Facts and create the Model to build cubes based on Real-Scenarios

Introduction to Hyperion Tools and Advantages

Essbase Architecture and Flow of Development Life Cycle of Essbase Cubes

Essbase Installation and Configuration Procedure

  Essbase Storage Properties

Essbase Terminology and Family Tree Relationships

Introduction of Database Design

Data Storage Properties

Time Balance and Expense Reporting Properties

UDAS, Attribute and Alternate Hierarchies

Introduction to ASO and BSO Options

Creating Essbase Applications and Databases

Understanding the Time, Scenario and Measures Dimension Concepts

Creating and building the dimensions rule files using Essbase Administration Services Console

Loading the data in Different Methods

Consolidation Operators

Duplicate Member Name Support

  Essbase Cube Implementation from Scratch

Creating Standard and Attribute Hierarchies

Creating Accounts Hierarchies

ETL Operations while Rule File Building

Dimensional and Data Loading using Interface tables and Flat Files

BSO Cube Implementation

Dense and Sparse Concept, Block Structure

Data Storage Properties

Calculation Scripts

Hour-Glass Method Importance

Design and  Optimization Technique

Partitions and there types

 ASO Cube Implementation

Aggregations

ASO Physical Structure

Table space and Restructuring

MDX Scripts

Design and Optimization

 Scripts

Automation of Cube Loading using MaxL Scripts

Report Scripts

 Security and Administration

Introduction to Shared Services Console

Creating Users and Groups

Assign Cube and Filter Access to Groups

Essbase Configuration, Server and Application Log Files

Locks and Sessions

Backup and Recovery Methods

Introduction to Life Cycle Management and Usage

 Introduction to Excel-Addin and Smart View

Accessing Cubes using Essbase Excel-Addin and generate Reports

Performing Adhoc Analysis using Smart View Tool

Various Options that is available in Essbase Excel-Addin and Smart-View Tools

[erpinfotek]

Oracle PL/SQL Online Training:

ERP Infotek provides Oracle PL/SQL Online Training by Oracle certified professionals with strong Oracle PL/SQL experienced trainers. ERP Infotek Oracle PL/SQL training is regarded as one of the best and excellent online training and classroom training institute for Oracle PL/SQL in Bangalore, India, UK, and USA.

Basics of PL/SQL

PL/SQL architecture

PL/SQL and SQL Plus

PL/SQL Basics, Variables, Constants, data types & error handling

PL/SQL wrapper utility

PL/SQL structures

Simple blocks

Control structures

PL/SQL records

Recognizing the Basic PL/SQL Block and Its Sections

Describing the Significance of Variables in PL/SQL

PL/SQL Vs Non-PL/SQL Variables

Variables and Constants

PL/SQL Block

Error checking and exception handling

Defining exceptions

Using the when others clause

Ensuring complete error checking

Passing error messages to calling routine

Boolean logic in PL/SQL

Identifying the Uses and Types of Control Structures

Constructing an IF Statement

Constructing and Identifying Different Loop Statements

Controlling Block Flow Using Nested Loops and Labels

Using Logic Tables

If-then-else structure

Testing for numbers characters and Booleans

Cursors in PL/SQL

Cursor basics

Using a cursor for a multi-row SQL query

Iteration in PL/SQL

For loop

While loop

PL/SQL tables

Defining PL/SQL tables

Use of PL/SQL tables

Populating a PL/SQL table

Retrieving from a PL/SQL table

Dynamic SQL in PL/SQL

Introduction to the dbms_sql package

Creating a dynamic SQL statement

Nested blocks in PL/SQL

Introduction to the dbms_sql package

Creating a dynamic SQL statement

Triggers in PL/SQL

Triggers and database events

Defining a trigger

Timing a trigger

Enabling and disabling a trigger

Stored procedures, functions and packages

Basics of stored procedures, functions and packages

Defining stored procedures & functions

Function and stored procedures prototypes

Passing arguments to functions and stored procedures

Recompiling functions and stored procedures

Pinning packages in the SGA with dbms_shared_pool.keep

Package forward declaration

Package dependency

Package overloading

Listing package information

Bulking in PL/SQL

Bulk queries

Bulk DML (forall statement)

Using cursor attributes

Analyzing impact of bulk operations

[erpinfotek]

Oracle DBA (11g) Online Training: ERP Infotek provides Oracle 11g DBA Online Training by Oracle certified professionals with strong Oracle 11g DBA experienced trainers. ERP Infotek Oracle 11g training is regarded as the one of the best and excellent training institute in Bangalore, India, UK, and USA etc.

ERP Infotek Oracle 11g Online Training: • Using script files, START, GET, SAVE, LIST, PROMPT, PAUSE, ACCEPT, DEFINE, SPOOL • Writing the statement in sql plus, Running the SELECT statement • Single Column, Descending order, multiple column sorts • Working with complex conditions, AND OR NOT LIKE BETWEEN • Creating and using variables, Command substitution • Pseudo Columns, Row num, Sys date, User & UID, the Dual Table • Working with character functions • Working with date functions • Using non-character function • Using the Union, Intersect, minus SET operators • Aggregating data using group functions • Creating Single Row sub queries, Multiple row Sub queries • Processing hierarchies • INSERT, UPDATE, DELETE the Data Manipulation Language • CREATE, TRUNCATE, ALTER, DROP, RENAME, DESCRIBE Data Definition Language • Using Views, Sequences, Synonyms, Indexes Declarative Constraints • Create Object Privileges, Granting access to objects Database Security

Introduction to ORACLE DBA • Roles and Responsibilities of Oracle DBA • Oracle Architecture • Types of Datafiles • System Global Area and Background Process

Database Creation • Types of Startup Modes • Types of Shutdown Modes • Types of Database Creation • Manual Method of Creation

Tablespace Management • Table space introduction • Table space types • Temporary Table space • Altering/Renaming a Table space • Renaming a data file • Temporary Groups • 11g Table space Encryption

Storage Parameters • segments • Oracle Blocks • Estimation of Extents • Dictionary Managed and Locally Managed Table space • Storage Parameters

User Management • Database Users management • Creation of Users • Assigning Privileges • Creating and granting Roles • Allocating table space Quotas to Users • Assigning default table space for the Users • Setting Profiles for the Users • Levels of Authentication • 11g Schema Management • 11g Security

Undo Management • Undo overview • Pending offline status • Brief idea about Rollback segments • Flashback Features about Table, query, Version query • SPFILE and OMF • spfile • spfile Vs pfile • OMF • Advantages of OMF • Files conventions of OMF

Networking in Oracle • Introduction to Oracle Networking • Network default location • Editing Network file • Listener.ora • Tnsnames.ora • Introduction to Database Links • Database Links types • Materialized views and advantages • Refresh Modes

Redo Log and Control File Management • Introduction and Status to Redo log • Multiplexing the Redo log files and Control file • Re-creation of Control file • Renaming the Database

Logical Backup • Logical backup introduction • Export and import Utility • Data Pump • Data Pump Vs Traditional Export and import • Impdp and expdp • Transportable Table spaces

Physical Backup • Introduction to Physical backup • Types of Physical backup • Cold & Hot backup • Recovery scenarios • RMAN backup • RMAN Point in time recovery • RMAN 11g new features

Performance Tuning • Performance Tuning introduction • Database Tuning • SQL Tuning • Memory Tuning • Network Tuning • Partitioning and Indexes • Partitioning Enhancements • AWR/ASH/ASMM/ADDM • 11g RAT (Real Application Testing) • 11g SQL Performance Analyses • Row chaining and Row migration • Resemble Table spaces