Ruby on Rails realtime online training, job support & interview support, Corporate Training


Ruby On Rails Frameworks and find out how to make killer web applications, Ruby On Rails API, server-side web application frameworks, making building blocks for plug-and-play functionality and enabling skills in crafting rails applications., etc.and exposure to industry based mostly real-time projects in varied verticals.


FOR FREE DEMO contact :
Email : raj@apex-online-it-training.com
Phone/WhatsApp : +91-(850) 012-2107
USA Number : 214-628-3894
Gtalk : raavi.sriraja@gmail.com
Blog: http://apex-it-online-trainings..in
Website: www.apex-online-it-trainings.com


ROR Course Outline/Agenda

(course agenda will be modified as per your requirements)



Ruby On Rails Course Content



INTRODUCTION:
Introduction to RUBY Environment
Syntax, Variables
Operators, Comments
Conditional Statements, if…else, if modifier
Unless Statement, Unless modifier
Case Statement
Loops
While Statement, While modifier
Until Statement, Until modifier
For Statement, Break Statement
Next Statement, Redo Statement
Methods, Blocks, Strings, Arrays, Hashes
Date & Time, Ranges, Iterators, File I/O

RUBY ADVANCED:
Classes
Instance Variables, Class Variables, Global Variables
Constants, OBJECT ORIENTED, Class definition
Ruby objects, Initialize method, Instance variables
Accessor & setter methods
Instance methods, Class methods & Variables, To_s Method
Access Control, Class Inheritance
Methods Overriding, Operator Overloading
Freezing Objects

RAILS:
Rails Installation, SQLITE3 or MySQL (As per Requirement)
File Structure, Controller and Views and Models
Routes, Databases and Migrations
Configuring a project for Databases
Creating a database, Generating Migration
Associations, layouts, Forms, Data Validation,
CRUD USING SCAFFOLDING, Create_action, Read_action, Update_action, Delete_action
Login and Logout complete example
Project Oriented Training

Practice Assignments and Interview Questions

Informatica live online training, job support & interview support by realtime corporate professionals


Informatica coaching causes you to professional in all the concepts relating to integration of heterogeneous data sources and changing the information into helpful info. This tool provides a whole information integration solution and information management system.


FOR FREE DEMO contact :
Email : raj@apex-online-it-training.com
Phone/WhatsApp : +91-(850) 012-2107
USA Number : 214-628-3894
Gtalk : raavi.sriraja@gmail.com
Blog: http://apex-it-online-trainings..in
Website: www.apex-online-it-trainings.com


Informatica Interview queries and Answers, Recorded Video Sessions, Materials, Mock Interviews Assignments are provided


INFORMATICA COURSE course of study

(As per your needs the course content will be changed):



Introduction to data warehousing
Characteristics of data warehouse
How to design a data warehouse
Top down and Bottom up approach
What is a data mart
ETL fundamentals
Data Acquisition, Data Merging, Data Cleansing, Data Scrubbing, Data Aggregation
Dimensional Modeling (Dimensions, Facts)
Star Schema
Snowflake Schema
Slowly Changing Dimensions


PowerCenter Components
PowerCenter Client Tools
PowerCenter Designer
Workflow Manager
Workflow Monitor
Repository Manager
Excercise1: Pass-through Mapping
Working with source analyzer
Working with target designer
Working with mapping designer
Working with task developer
Working with workflow designer
Creating Data Source Names
Creating Relational Connections


Types of transformations (Active, Passive)
Excercise2: Expression Transformation Usage
Excercise3: Aggregator Transformation Usage
Excercise4: Filter Transformation Usage
Excercise5: Router Transformation Usage
Excercise6: Sorter Transformation Usage
Excercise7: Rank Transformation Usage
Excercise8: Joiner Transformation Usage
Excercise9: Union Transformation Usage
Excercise10: Lookup Transformation Usage (Connected, Unconnected)
Excercise11: Stored procedure Transformation Usage (Connected, Unconnected)
Excercise12: Sequence generator Transformation Usage
Excercise13: Update Strategy Transformation Usage
Excercise14: Source Qualifier Transformation Usage
Excercise15: Transactional control Transformation usage


Real time Mappings
SCD type-I
SCD type-II


Working with flat files
How to create flat file as target
How to read flat file data
File list (Working With Multiple Files)


Transformation Developer
How to create a reusable transformation
How to use reusable transformation in a mapping
Advantages of reusable transformations


Mapplet Designer
How to create a mapplet (reusable business logic)
How to use a mapplet in a mapping
Advantages of mapplets


Tasks
How to work with command task
How to work with email task
How to work with session task
How to work with decision task
How to work with link task
How to work with timer task
How to work with control task
How to work with event-wait task
How to create reusable tasks
How to create non-reusable tasks


Workflows
How to create parallel workflows
How to create sequential workflows
How to schedule workflows


Worklets
How to create a worklet
How to use a worklet in a workflow
Nesting of worklets


Types of caches
Data Cache
Index Cache
Static Cache
Persistent Cache
Dynamic Cache


Working with functions
Performance Tuning
How to tune source
How to tune target
How to tune transformations
How to tune session
How to tune workflow


Realtime Scenarios

IBM Netezza hands-on online training by realtime corporate faculty | 100% practical


IBM Netezza DBA training focuses on the way to effectively exploit the IBM Netezza platform to build, test, and score analytic models in-database. This Course causes you to to find out the way to use In-Database Analytics totally scalable and parallelized, In-database analytics package etc.


FOR FREE DEMO contact :
Email : raj@apex-online-it-training.com
Phone/WhatsApp : +91-(850) 012-2107
USA Number : 214-628-3894
Gtalk : raavi.sriraja@gmail.com
Blog: http://apex-it-online-trainings..in
Website: www.apex-online-it-trainings.com


IBM Netezza Interview queries and Answers, Recorded Video Sessions, Materials, Mock Interviews, Assignments are provided.



IBM NETEZZA DBA curriculum / programme

(we will customise the course programme as per your requirements)



 IBM Netezza Overview

 Netezza Architecture

 Connecting to Netezza

 Databases,Tables and Database Objects


 Data Distribution

 Loading and Unloading Tables

 Statistics

 Zone Maps and Clustered Base Tables

 Materialized Views

 Groom

 Sequences

 Transactions

 Query and System Optimization

 nz Commands

 Backup and Restore

 Creating User and User Management

 Query History

 Managing WorkLoads

 Managing Events

Business Analyst BA hands-on live online training, Corporate Training by hands-on Professionals


Business Analyst course explains the techniques for distinguishing and analysing potential projects and make sure it meets the business needs. training is needed in analyzing business domain and to realize organization strategic goals.


FOR FREE DEMO contact :
Email : raj@apex-online-it-training.com
Phone/WhatsApp : +91-(850) 012-2107
USA Number : 214-628-3894
Gtalk : raavi.sriraja@gmail.com
Blog: http://apex-it-online-trainings..in
Website: www.apex-online-it-trainings.com


Business Analyst: BA Course Content

(Course content can be customized as per your need)


IT Industry & Business Analysis Role – A Practitioner's Perspective
• International Institute of Business Analyst (IIBA) and Role of a Business Analyst
• Client Organization
• IT Company Organization
• Project Governance Structure
• SDLC Models
• Waterfall
• V Model
• Prototype Model
• Iterative Model
• Spiral Model
• Agile Methodologies – Scrum

2. Introduction to IIBA Body of Knowledge (BOK)
• Enterprise Analysis
• Requirements Planning and Management
• Requirements Elicitation
• Requirements Communication
• Requirements Analysis and Documentation
• Solution Assessment and Validation

3. Requirements Planning and Management
• Understand Team Roles and Stakeholder Analysis (RACI Matrix)
• Identify Requirement Activities and Estimation Technique
• Scope Management and Traceability Matrix
• Change Management Process
• Risk Management Process
• Real Time Case Study to understand the above concepts

4. Requirements Elicitation Models
• Interviews
• Observation
• Prototyping
• Document Analysis
• Focus Groups
• Brainstorming
• Interface Analysis
• Workshops
• Reverse Engineering
• Surveys / Questionnaires
• Real Time Case Study to understand the above concepts

5. Requirements Analysis and Documentation
• Structured Analysis
• Data Flow Diagrams & Flowcharts
• ER Diagrams
• Object Oriented Analysis
• Introduction to Object Orientation Concepts
• Advantages of OO over Structured Analysis
• Introduction to UML
• UML Diagrams relevant to a Business Analyst
• Use Case Diagrams and Use Case Stories
• Class & Object Diagrams
• Sequence & Collaboration Diagrams
• State Transition Diagrams
• Activity Diagrams
• Case Studies

6. Requirements Communication
• Preparing Communication Plan
• Defining Communication Requirements of Project
• Conflict Management
• Approvals & Signoffs

7. Solution Assessment & Validation
• Role of Business Analyst in Testing
• Stages of Testing
• Unit Testing
• Integration Testing
• System Testing and
• User Acceptance Testing
• Testing Process
• Test Strategy & Plan
• Test Case Preparation
• Test Execution
• Defect Fixing
• Testing Types
• Functional Testing
• UI Testing
• Performance Testing
• Access Control & Security Testing
• Regression Testing
• Testing Techniques
• Black box Testing
• White Box Testing
• Test Metrics

8. Enterprise Analysis
• Enterprise Analysis Process
• Maintaining Business Architecture
• Zachman Framework
• POLDAT Framework

Oracle PL SQL hands-on Online Training, Job Support, Interview Support & Corporate Training


Oracle PL SQL Training makes you building the applications by leveraging capabilities of transaction control Language, database Security, Error Handling, Oracle supplied Packages and etc. you may additionally learn collection Datatypes and the way to Use Declarative Constraints and Non-Character function. This Course additionally includes making Subqueries, Aggregating data using group Functions, operating With Character Functions. you may get active exposure to Oracle PL SQL.



FOR FREE DEMO contact :
Email : raj@apex-online-it-training.com
Phone/WhatsApp : +91-(850) 012-2107
USA Number : 214-628-3894
Gtalk : raavi.sriraja@gmail.com
Blog: https://apex-online-it-trainings..com
Website: www.apex-online-it-trainings.com


Oracle PL SQL Interview queries and Answers, Recorded Video Sessions, Materials, Mock Interviews Assignments are going to be provided
ORACLE PL SQL COURSE program
(the course content may be changed as per your requirements):


Intro to PL/SQL
=======================
Advantages of PL/SQL
PL/SQL architecture
Datatypes in PL/SQL
PL/SQL program structure
Simple PL/SQL programs
Embedding SQL statements in PL/SQL
Conditional statements
Loops

Cursors :
========
About cursors in PL/SQL
Explicit cursors
For loop cursor
Cursor paramenters
For update clause
Where current of clause
Ref cursors
Implicit cursors
Exception Handling :
System defined exceptions
User defined exceptions
Sqlcode & sqlerrm
Pragma exception_init

Subprograms :
=============
Introduction to subprograms
Difference between anonymous & named blocks
Stored procedures :-
Creatng procedures
Working with IN , OUT ,INOUT parameters
Procedures with cursors
Procedures returning records
Pragma autotnomous transaction
Functions :
Difference b/w procedures and functions
Inline functions

Packages :
==========
Introduction to packages
Package specification and package body
Overloading package members

Triggers :
==========
Introduction to triggers
DML triggers
DDL triggers
Db auditing using triggers
DB level triggers
Collections in PL/SQL
Built-in packages in PL/SQL
Oracle 10g features
Oracle 11g features

DBA concepts

Oracle PL SQL hands-on Online Training, Job Support, Interview Support & Corporate Training


Oracle PL SQL Training makes you building the applications by leveraging capabilities of transaction control Language, database Security, Error Handling, Oracle supplied Packages and etc. you may additionally learn collection Datatypes and the way to Use Declarative Constraints and Non-Character function. This Course additionally includes making Subqueries, Aggregating data using group Functions, operating With Character Functions. you may get active exposure to Oracle PL SQL.



FOR FREE DEMO contact :
Email : raj@apex-online-it-training.com
Phone/WhatsApp : +91-(850) 012-2107
USA Number : 214-628-3894
Gtalk : raavi.sriraja@gmail.com
Blog: https://apex-online-it-trainings..com
Website: www.apex-online-it-trainings.com


Oracle PL SQL Interview queries and Answers, Recorded Video Sessions, Materials, Mock Interviews Assignments are going to be provided
ORACLE PL SQL COURSE program
(the course content may be changed as per your requirements):


Intro to PL/SQL
=======================
Advantages of PL/SQL
PL/SQL architecture
Datatypes in PL/SQL
PL/SQL program structure
Simple PL/SQL programs
Embedding SQL statements in PL/SQL
Conditional statements
Loops

Cursors :
========
About cursors in PL/SQL
Explicit cursors
For loop cursor
Cursor paramenters
For update clause
Where current of clause
Ref cursors
Implicit cursors
Exception Handling :
System defined exceptions
User defined exceptions
Sqlcode & sqlerrm
Pragma exception_init

Subprograms :
=============
Introduction to subprograms
Difference between anonymous & named blocks
Stored procedures :-
Creatng procedures
Working with IN , OUT ,INOUT parameters
Procedures with cursors
Procedures returning records
Pragma autotnomous transaction
Functions :
Difference b/w procedures and functions
Inline functions

Packages :
==========
Introduction to packages
Package specification and package body
Overloading package members

Triggers :
==========
Introduction to triggers
DML triggers
DDL triggers
Db auditing using triggers
DB level triggers
Collections in PL/SQL
Built-in packages in PL/SQL
Oracle 10g features
Oracle 11g features

DBA concepts

UiPath online training, Job & Interview Support, Corporate training from India | USA | UK | Canada | Aus


UiPath course causes you to learn automation advantages, design, UiPath Studio, configuration of workflows, Cloud & on-premise deployment additionally experience in uipath rpa release management, uipath orchestrator, remote control, queue/robot workload, scheduling, custom roles authorization and asset management.


FOR FREE DEMO contact :
Email : raj@apex-online-it-training.com
Phone/WhatsApp : +91-(850) 012-2107
USA Number : 214-628-3894
Gtalk : raavi.sriraja@gmail.com
Blog: https://apex-online-it-trainings..com
Website: www.apex-online-it-trainings.com


Interview queries and Answers, Recorded Video Sessions, Materials, Mock Interviews Assignments are provided


UI Path COURSE outline
(the course content will be changed as per your requirements):


Basic Concepts:
Introduction
Basic familiarization to RPA
Control Flow

UI Automation:
Recording
UI Elements

Selectors and Screen Scraping:
Selectors
Screen Scraping

Image Automation:
Image and Test based Automation
Advanced Citrix automation

Data Manipulation:
Data Table
Excel

Mail, PDF, User Events:
Mail PDF
User Events

Putting It all Together:
Project Organization
Exceptions And Debugging

UI Path Infrastructure and administration:
UI Path and Area of RPA
UI Path Setup
Connecting Different Systems and Problems
Managing Solutions
UI Path RPA Features
Problem Solving

Salesforce CRM live Online Training, Corporate Training from India,Usa,Uk,Canada,Aus


Salesforce training can facilitate to induce hands-on experience in developing and managing apps for core administrative options of CRM using Salesforce. This course is meant to confirm that you simply learn and masters the ideas like analytics and customization apps, Salesforce AppExchange, Salesforce Lightning App Builder, Salesforce Service Cloud, Salesforce Reports & Dashboard.


FOR FREE DEMO contact :
Email : raj@apex-online-it-training.com
Phone/WhatsApp : +91-(850) 012-2107
USA Number : 214-628-3894
Gtalk : raavi.sriraja@gmail.com
Website: www.apex-online-it-trainings.com


Salesforce CRM Interview Questions and Answers, Recorded Video Sessions, Materials, Mock Interviews,Assignments Will be provided


SFDC COURSE AGENDA
(the course content can be modified as per your requirements):

Salesforce Administration

Introduction
• Introduction to Cloud Computing
• What is Cloud Computing
• Advantages
• Layers – Client, Application(Software as a Service (SaaS)), Platform (platform as a service (PaaS)), InfraStructure(infrastructure as a service” (IaaS)), Server
• Deployment Models – Public cloudm Community Cloud, Hybrid Cloud, Private Cloud
• Introduction to Salesforce Admin
• What is Salesforce Admin.com
• Advantages
• Products and Services
• Customer Relationship Management(CRM) – Salesforce Admin CRM and other CRM
• The Sales Cloud
• The Service Cloud
• Force.com Platform
• Chatter
• AppExchange
• Configuration
• Web services
• Mobile support

Introduction to Force.com Platform
• Registering Developer Edition with Salesforce Admin.com
• Standard applications
• Standard Tabs
• Standard Objects and relationships, Links
• Setup page – Personal Setup, Application Setup and Administration Setup

Personal Setup
• Personal Information
• Change Password
• Reset my security Token
• Change My Display
• Grant Login Access
• Calendar Access
• Reminders
• Email Settings

Designing Applications on Force.com – I
• Creating new application
• Creating Custom objects
• Creating Tabs – Custom Tabs, Web tabs
• Adding text ,Currency,Checkbox,Date fields
• Creating Picklists
• Field Dependencies

Designing Applications on Force.com – II
• Encrypted fields, field help, and field history tracking
• Use master detail, lookup, and many-to-many Relationships
• Custom button and links Creation
• Rollup Summary field

Designing Applications on Force.com – III
• Develop custom formulas
• Use the vlookup, regex, ischanged, isnew, and priorvalue functions to build business processes
• Validation Rules – Creating rule by applying formulas
• Payelayouts – Payelayout Editor,Grouping fields into New Section, adding spece between Fields, Editing Field properties
• Search Layouts

Designing Applications on Force.com – IV
• Workflows
• Introducing Workflow Rules and work flow actions
• Email Alerts – Email templates
• Tasks
• Field Updates – Queues and Time Dependent Workflow Actions

Designing Applications on Force.com – V
• Creating an approval Process
• Create an Email template for approvals
• Create an Approval Process
• Create a Custom Profile
• Create User
• Test the Approval Process

Reports
• Introducing Reports and Custom Reports
• Create a tabular Report
• Create a Summary Report – Adding Summary fields and adding Columns and Filters
• Create Matrix Report
• Exporting Reports
• Dashboards – Creating and Editing Dashboards, Adding Dashboard SnapShots to Home Page, Creating Additional Reports
• Creating Custom Report Types

Sharing and Security data – I
• Creating User Accounts
• Controlling Access to Data
• Controlling Access to Objects
• Introducing Profiles
• Standard Profiles
• Custom Profiles
• Controlling Access to Fields
• Introducing Filed Level Security
• Accessing Field-Level Security Settings

Sharing and Security data – II
• Controlling Access to Records
• Introducing Organization-Wide Defaults
• Introducing Role Hierarchies
• Company Roles and Profiles
• Sharing Rules
• Manual Sharing

Sharing and Security data – III
• Displaying Field values and Page Layouts according to Profiles –
• Overriding Sharing with Object Level Permissions
• Administration Groups – Managing Groups(Public and Personal)

Sharing and Security data – IV
• Login History
• Password Policies
• User session Settings
• Set Trusted Ip range

Administration Setup – Mobile, Desktop and Email administration
• Mobile Administration:
• Configuring Mobile user
• User Settings
• Desktop Administration:
• Configuring for outlook
• Offline Briefcase configuration
• Email Administration
• Testing Deliverability
• Deliverability Settings
• Setting Organization-Wide addresses
• Compliance BCC
• Setting Enail Footers

Company Profile and Monitoring
• Editing Company Information
• Settings Fiscal Year
• Settings Business Hours and Holis
• Language Settings
• Debug Logs
• Email Log files

Managing data – I
• Importing data to Salesforce Admin.com from external Sources
• Import Custom objects
• Data Export
• Mass Transfer Records
• Mass Delete Records
• Mass Trnasfer Approval
• Mass Update addresses

Managing data – II
• Data Loader
• Data loader Overview
• When to use Data Loader
• Installing and Configuraing dayta Loader
• Use Data Loader to create mapping files and upsert data
• Running Batch Processes
• Command Line Quick start

Salesforce Development

Overview of Apex
Apex Language basics
• Variables
• Operators
• Arrays and Collections
• Control Logic
• Understanding Governor Limits

Database Integration in Apex
• Database Records as objects
• Database Queries – SOQL(Query results, Relationships, Filtering)
• Persisting Database Records – DML(Insert, Update, Upsert, Delete, UnDelete
• Database Triggers – Trigger Definition, Batch Processing, Error Handling, Governor Limits)
• Database Security in Apex

Debugging and Testing
• Debugging
• Viewing Logs
• Logging
• Handling Uncaught Exceptions
• Understanding Execution Governors and Limits
• Using Governor Limit Email Warnings
• Testing
• Understanding Testing in Apex
• Why Test Apex?
• What to Test in Apex
• Unit Testing Apex
• Isolation of Test Data from OrganizationData in Unit Tests
• Using the runAs Method
• Using Limits, startTest, and stopTest
• Adding SOSL Queries to Unit Tests
• Running Unit Test Methods
• Testing Best Practices
• Testing Example

Advanced Business Logic – I
• SOQL
• Inner and Outer Join
• Semi- Join and Anti Join
• Multi- Select Picklists
• Transaction Processing
• DML Databasse Methods
• points
• Record Locking

Designing Advanced Business Logic – II
• Apex Managed Sharing
• Sharing Objects
• Creating Sharing Rules in Apex
• Sending and Receiving Email
• Sending Email – SingleEmailMessage, SingleEmailMessage with Template and MassEmailMessage
• Receiving Email
• Dynamic Apex – Dynamic Database queries, Schema Meta data

Introduction to Visualforce – I
• Introducing Visualforce and the MVC model
• VisualForce Controllers
• Standard Controller
• Associating a Standard Controllerwith a Visualforce Page
• Accessing Data with a Standard Controller
• Using Standard Controller Actions
• Validation Rules and Standard Controllers
• Styling Pages that Use Standard Controllers
• Checking for Object Accessibility
• Standard List Controller
• Associating a Standard List Controller with a Visualforce Page
• Accessing Data with List Controllers
• Using Standard List Controller Actions
• Pagination with a List Controller
• Using List Views with Standard List Controllers
• Editing Records with List Controllers
• Custom Controller
• Controller Extensions

Introduction to visualForce – II
• View Components
• View Component Basics
• Data Components
• Action Components
• Force.com Styles Components
• Force.com User Interface Components
• Using Static Resources
• Creating a Static Resource
• Referencing a Static Resource in Visualforce Markup

Introduction to visualForce – II
• Visualforce and the Native user Interface
• Standard Pages
• Standard Buttons
• Page layouts
• Custom buttons and links
• Custom tabs
• VisualForce in Production
• Security
• Error Handling
• Governor Limits
• Unit tests
• Overriding Buttons, Links,and Tabs with Visualforce
• Overriding Tabs Using a Standard ListController
• Defining Custom Buttons and Links for Visualforce
• Adding Custom List Buttons using StandardList Controllers
• Displaying Record Types

Python with R Online Training, Job and Interview support, Corporate Training by hands-on experts


Python training covers Python high-level programing language. Get deeper information of the core Python language. This Python Course causes you to write and execute high-quality code in Python. Our content is a perfect way to begin, whether or not you’re unaccustomedprogramming or knowledgeable developer., etc. you may additionally get an exposure to industry based real-time comes in numerous domains.


FOR FREE DEMO contact :
Email : raj@apex-online-it-training.com
Phone/WhatsApp : +91-(850) 012-2107
USA Number : 214-628-3894
Gtalk : raavi.sriraja@gmail.com
Website: www.apex-online-it-trainings.com


Python with R-programming Interview Q’s and A’s, Recorded Video Sessions, Materials, Interviews, Assignments provided

PYTHON COURSE OUTLINE
(the course content can be modified as per your requirements):



Core Python Contents
INTRODUCTION TO PYTHON
• Features of Python
• Python Virtual Machine (PVM)
• Frozen Binaries
• Memory Management in Python
• Garbage Collection in Python

Writing Our First Python Program
• Writing Our First Python Program
• Executing a Python Program
• Getting Help in Python
• Reopening the Python Program in IDLE

Datatypes in Python
• Comments in Python
• Docstrings
• How Python Sees Variables
• Datatypes in Python
• Built-in datatypes
• The None Type
• bool Datatype
• Sequences in Python
• Sets
• Literals in Python
• Determining the Datatype of a Variable
• Characters in Python
• User-defined Datatypes
• Constants in Python
• Identifiers and Reserved words
• Naming Conventions in Python

Operators in Python
• Arithmetic Operators
• Using Python Interpreter as Calculator
• Assignment Operators
• Unary minus Operator
• Relational Operators
• Logical Operators
• Boolean Operators
• Membership Operators
• Identity Operators
• Operator Precedence and Associativity
• Mathematical Functions

Input and Output
• Output statements
• Various formats of The print()
• Input Statements
• Command Line Arguments

Control Statements
• If Statement
• If … else Statement
• If … elif … else Statement
• While Loop
• For Loop
• Infinite Loops
• Nested Loops
• Else Suite
• Break Statement
• Continue Statement
• Pass Statement
• Assert Statement
• Return Statement

Arrays in Python
• Creating an Array
• Importing the Array Module
• Indexing and Slicing on Arrays
• Types of Arrays
• Working with Arrays using numpy
• Creating Arrays using linspace
• Creating Arrays using logspace
• Creating Arrays using arange() Function
• Creating Arrays using zeros() and ones() Functions
• Mathematical Operations on Arrays
• Comparing Arrays
• Aliasing the Arrays
• Viewing and Copying Arrays
• Slicing and Indexing in numpy Arrays
• Dimensions of Arrays
• Attributes of an Array
• Reshape() Method
• Flatten() Method
• Working with Multi-dimensional Arrays
• The array() Function
• The ones() and zeros() Functions
• The eye() Function
• The reshape() Function
• Indexing in Multi-dimensional Arrays
• Slicing the Multi-dimensional Arrays
• Matrices in numpy

Strings and Characters
• Creating Strings
• Length of a String
• Indexing in Strings
• Repeating the Strings
• Concatenation of Strings
• Checking Membership
• Comparing Strings
• Removing Spaces from a String
• Finding Sub Strings
• Strings are Immutable
• Replacing a String with another String
• Splitting and Joining Strings
• Changing Case of a String
• Checking Starting and Ending of a String
• String Testing Methods
• Formatting the Strings
• Sorting Strings

Functions
• Defining a Function
• Calling a Function
• Returning Results from a Function
• Returning Multiple Values from a Function
• Functions are First Class Objects
• Pass by Object Reference
• Formal and Actual Arguments
• Positional Arguments
• Default Arguments
• Variable Length Arguments
• Local and Global Variables
• The Global Keyword
• Passing a Group of Elements to a Function
• Recursive Functions
• Lambdas
• Using Lambdas with filter() Function
• Using Lambdas with map() Function
• Using Lambdas with reduce() Function
• Function Decorators
• Generators
• Structured Programming
• Creating our Own Modules in Python
• The Special Variable __name__

Lists and Tuples
• Creating Lists using range() Function
• Updating the Elements of a List
• Concatenation of Two Lists
• Repetition of Lists
• Membership in Lists
• Aliasing and Cloning Lists
• Methods to Process Lists
• Nested Lists
• List Comprehensions
• Tuples
• Creating Tuples
• Accessing the Tuple Elements
• Basic Operations on Tuples
• Functions to Process Tuples
• Nested Tuples

Dictionaries
• Operations on Dictionaries
• Dictionary Methods
• Using for Loop with Dictionaries
• Sorting the Elements of a Dictionary using Lambdas
• Converting Lists into Dictionary
• Converting Strings into Dictionary
• Ordered Dictionaries


Advanced Python Contents

Introduction to Oops
• Problems in Procedure Oriented Approach
• Features of Object Oriented Programming System (OOPS)
• Classes and Objects
• Encapsulation
• Abstraction
• Inheritance
• Polymorphism

Classes and Objects
• Self Variable
• Constructor
• Types of Variables
• Namespaces
• Types of Methods
• Passing Members of One Class to Another Class
• Inner Classes

Inheritance and Polymorphism
• Constructors in Inheritance
• Overriding Super Class Constructors and Methods
• Super() Method
• Types of Inheritance
• Method Resolution Order (MRO
• Duck Typing Philosophy of Python
• Operator Overloading
• Method Overloading
• Method Overriding

Abstract Classes and Interfaces
• Abstract Method and Abstract Class
• Interfaces in Python
• Abstract Classes vs. Interfaces

Exceptions
• Errors in a Python Program
• Exceptions
• Exception Handling
• Types of Exceptions
• The Except Block
• Assert Statement
• User-Defined Exceptions
• Logging the Exceptions

Files in Python
• Types of Files in Python
• Working with Text Files Containing Strings
• Knowing Whether a File Exists or Not
• Working with Binary Files
• Pickle in Python
• Seek() and tell() Methods
• Random Accessing of Binary Files
• Random Accessing of Binary Files using mmap
• Zipping and Unzipping Files
• Running Other Programs from Python Program

Regular Expressions in Python
• Sequence Characters in Regular Expressions
• Quantifiers in Regular Expressions
• Special Characters in Regular Expressions
• Using Regular Expressions on Files
• Retrieving Information from a HTML File

Date and Time
• The epoch
• Date and Time Now
• Combining Date and Time
• Formatting Dates and Times
• Finding Durations using timedelta
• Comparing Two Dates
• Sorting Dates
• Stopping Execution Temporarily
• Knowing the Time taken by a Program
• Working with Calendar Module

Threads
• Differences between a Process and a Thread
• Concurrent Programming and GIL
• Uses of Threads
• Creating Threads in Python
• Thread Class Methods
• Single Tasking using a Thread
• Multitasking using Multiple Threads
• Thread Synchronization
• Avoiding Deadlocks in a Program
• Communication between Threads
• Thread Communication using nofity() and wait() Methods
• Thread Communication using a Queue
• Daemon Threads

Graphical User Interface
• GUI in Python
• The Root Window
• Fonts and Colors
• Working with Containers
• Canvas
• Frame
• Widgets
• Button Widget
• Label Widget
• Message Widget
• Text Widget
• Scrollbar Widget
• Checkbutton Widget
• Radiobutton Widget
• Entry Widget
• Spinbox Widget
• Listbox Widget
• Menu Widget

Python’s Database Connectivity
• Advantages of a DBMS over Files
• Working with MySQL Database
• Operations on rows of a Table
• Creating Database Tables through Python
• Working with Oracle Database in Python
• Stored Procedures

Dotnet (ASP.NET, ADO.NET, VB.NET, C#) realtime online training, job support & interview support by corporate working professional


ASP.NET training makes you an expert in Programming Configuration Files, Displaying XML Data Using the XML Data Source Control, Using Visual Studio 2008\'s Tools for Working with Styles,etc.
VB.NET Training makes you an expert in concepts like Runtime Callable Wrapper (RCW), COM Callable Wrapper (CCW), Remoting Architecture, Hands-on Remoting, .Net Framework Architecture, and Exception Handling….etc.



FOR FREE DEMO contact :
Email : raj@apex-online-it-training.com
Phone/WhatsApp : +91-(850) 012-2107
USA Number : 214-628-3894
Gtalk : raavi.sriraja@gmail.com
Blog: http://apex-it-online-trainings..in
Website: www.apex-online-it-trainings.com


.Net Interview Questions and Answers, Recorded Video Sessions, Materials, Mock Interviews, Assignments Will be provided.

.Net Agenda/Syllabus
(we can customize the course Curriculum as per your requirements)


DOTNET COURSE CONTENT

Introduction to .NET
C#.NET Basics
C# - Flow Control and Exceptions
C# OOPS (Part 1)
C# - OOPS (Part 2)
C# and Generics
Module2: Windows Forms App and ADO.NET

Target Audience: This module is meant for the programmers, who are interested to develop graphical applications using C# and want to connect them with databases such as SQL Server and Oracle.

Pre-requisite: Good knowledge in “C#” language basics and OOPS. (refer Module1)

Goals: To develop Windows Forms Applications with Database interaction.

GUI Application Development
• Introduction to Windows Forms Applications
• Form Properties
• Event Handling and Form Events
• Working with Multiple Forms
• Working with Common Controls
• Working With List Controls
• Working With Menu Controls
• Working with Dialog controls
• Working with other controls
• MDI Applications

User Controls and Event Handling
• User Defined Control
• Inherited Control
• Inherited forms
• Event handling
• Windows Forms Control Library

Data Base Programming (ADO.NET)
• ADO .NET Introduction
• Data Providers in .Net
• Introduction to Managed and Unmanaged Providers
• Passing Commands to the Database
• Data Readers
• Dataset and Data Adapters
• Creating Relations and Transactions

File Handling
• System .IO namespace
• FileStream
• StreamReader
• StreamWriter
• FileInfo
• DirectoryInfo

Dtrsing Handlings
• System.Text
• string reader
• string writer
• string.join
• string.split
• string comparisions
• vSearch string

.NET Remoting
• Understanding the need of Remoting
• Channels (TCP and HTTP)
• Server Activated Object and Client Activated Object
• Remoting Architecture
• Demo on Remoting

Multi Threading
Windows Services
• Service base class
• Service Process installer
• Service Installer
• Creating a Windows Service
• Installutill.exe

Advanced .NET
Anonymous Method

Module3: ASP.NET
Target Audience: This module is meant for the programmers, who are interested to develop web applications using C#.

Pre-requisite: Good knowledge in “C#” language basics, OOPS, Windows Forms Applications and ASP.NET. (refer Module1 and Module2). In additional to this, this module demands some intermediate level knowledge in HTML.
Goals: To develop Web Applications.

INTRO TO WEB TECHNOLOGIES
• Overview of HTML
• Client side scripting langs
• Overview llS
• Overview of ASP

ASP.NET INTRO
• What is ASP.NET
• ASP VS ASP.NET
• Image Technique and code behind technique

SERVER SIDE CONTROLS
• Client side control vs Server side controls.
• Type of server controls - HTML server controls,
• Examples on Web server controls.
• ASP.NET Page Execution Architecture

STATE MANAGEMENT
• Cookies
• Session State
• Application object
• Session and App events
• Global. AJAX
• viewstate

ADO.NET Usage in Web Applications
• Datalist
• Repeater
• Datasource Controls
• GridView
• DetailsView
• Listview
• Crystal Reports

CACHING
• Importance of Caching
• Type of Caching in ASP.NET
• Output Caching
• Fragment caching
• Data caching

ASP.NET CONFIGURATION
• Machine config vs Web config
• App Settings
• Compilation setting
• Custom error setting
• Session State Setting
• Enhancement in ASP.NET
• Inprocess VS out process session state
• State server and SQL Server

ASP.NET TRACING
• Page Level
• Application Level

SECURITY IN ASP.NET
• Authentication & Authorization
• Windows Based Authentication
• Form Based Authentication

THEME AND SKIN

MASTER PAGES

SITE NAVIGATION

WEB PARTS
• Web part manager
• Zone Types

Web Services Development using ASP.NET
Ø Web Services Introduction, WSDL and SOAP
Ø Creating and Using Web Services

Examples on Linq .wpf , ajax and silverlight

Microsoft SCCM hands-on online training, job support & interview support by corporate Professionals


SCCM Training makes you Experience the real-time implementation of Microsoft System Center Configuration Manager (SCCM) 2016, Configuring Wake On LAN, Power Management, Remote Control and the course will go through the step-by-step creating and deploying Applications and managing software updates., etc.



FOR FREE DEMO contact :
Email : raj@apex-online-it-training.com
Phone/WhatsApp : +91-(850) 012-2107
USA Number : 214-628-3894
Gtalk : raavi.sriraja@gmail.com
Blog: http://apex-it-online-trainings..in
Website: www.apex-online-it-trainings.com


SCCM Interview Questions and Answers, Recorded Video Sessions, Materials, Mock Interviews Assignments Will be provided


System Center Configuration Management-SCCM COURSE OUTLINE
(the course content can be modified as per your requirements):


Overview of System Center 2012 Configuration Manager
• Introduction to System Center 2012 Configuration Manager
• Overview of System Center 2012 Configuration Manager Architecture
• purpose and functionality of System Center 2012 Configuration Manager.
• System Center 2012 Configuration Manager architecture

Planning & Deploying SCCM Site
• Installing a Configuration Manager 2012 Central Admin Site(CAS),Primary Site & Secondary Sites
• Configuring the Prerequisites for Configuration Manager 2012 Deployment
• Extending the Active Directory Schema
• Installing a Configuration Manager 2012 Stand-Alone Primary Site
• Performing Post-Setup Configuration Tasks
• Validating the Installation of the Primary Site
• Performing the Initial Configuration of the Primary Site

Discovering and Organizing Resources
• Configuring Resource Discovery and Boundaries
• Configuring Active Directory Discovery Methods
• Configuring Boundaries and Boundary Groups
• Configuring User and Device Collections
• Creating a Device Collection
• Creating a User Collection
• Configuring a Maintenance Window
• Configuring Role-Based Administration

Managing the Configuration Manager Client
• Overview of the Configuration Manager Client
• Deploying the Configuration Manager Client
• Managing Client Agents
• Configuring and Monitoring Client Status

Managing Inventory and Software Metering
• Overview of Inventory Collection
• Configuring Hardware Inventory
• Configuring Software Inventory
• Managing Inventory Collection
• Configuring Asset Intelligence
• Configuring Software Metering

Configuring & Managing Reports :
• SCCM Manager Console Reporting node
• Adding a Reporting Point
• Running reports from the SCCM Manager Console
• Running reports from a web browser

Managing Software Deployments by Using Packages and Programs
• Configuring Software Distribution
• Creating a Package and Configuring Programs
• Configuring Packages and Programs
• Distributing Content to Distribution Points
• Deploying Programs to Configuration Manager Clients

Creating and Deploying Applications Overview of Application Management
• Creating and Deploying an Application
• Creating and Deploying a Required Application
• Creating and Deploying an Available Application
• Installing and Configuring the Application Catalog
• Creating and Deploying Applications to the Application Catalog
• Installing Applications from the Application Catalog

Managing Application Deployment
• Configuring User Device Affinity
• Creating Applications with Requirements
• Deploying Required Applications to Users
• Creating an Application with Multiple Deployment Types

Deploying and Managing Software Updates
• Overview of Software Updates
• Preparing the Configuration Manager Site for Software Updates
• Configuring the Site for Software Updates
• Configuring and Synchronizing the Software Update Point
• Deploying and Managing Software Updates
• Determining Software Update Compliance
• Deploying Software Updates to Clients
• Configuring Automatic Deployment Rules

Managing Operating System Deployment
• Overview of Operating System Deployment
• Preparing the Site for Operating System Deployment
• Capturing an Operating System Image

Managing Mobile Devices
• Preparing the Infrastructure for Mobile Device Management
• Enrolling a Mobile Device
• Managing Compliance Settings for a Mobile Device
• Deploying an Application to a Mobile Device

Configuring Wake On LAN, Power Management, and Remote Control
• Configuring Wake On LAN
• Overview of Out of Band Management
• Configuring Power Management Settings
• Configuring Remote Control

Migrating from System Center Configuration Manager 2007 to System Center 2012
• Configuration Manager Overview of the Migration Process
• Preparing Configuration Manager 2007 Sites for Migration
• Configuring Migration Settings
• Migrating Objects
• Configuring the Source Hierarchy
• Creating a Migration Job and Performing Migration

MuleSoft/Mule ESB hands-on on-line training, job support & interview support, corporate training by IT operating professionals

MULE ESB coaching information is framed to share basic information on Anypoint Studio Integration, Testing and debugging Mule applications, Deploying and running applications on CloudHub and Mule ESB at the side of JMS, JDBC, web Services, HTTP, and more. enter for MuleSoft Course at Apex, become MuleSoft Certified Developer.



FOR FREE DEMO contact :
Email : raj@apex-online-it-training.com
Phone/WhatsApp : +91-(850) 012-2107
USA Number : 214-628-3894
Gtalk : raavi.sriraja@gmail.com
Blog: http://apex-it-online-trainings..in
Website: www.apex-online-it-trainings.com


Mulesoft Interview Q’s and A’s, Recorded Video Sessions, Materials, Mock Interviews, Assignments are provided


Mule ESB COURSE CONTENT
(the course curriculum can be modified as per your requirements):


Introduction
• Solving Problem with integrtion.
• Understanding EIP Pattern using mule.
• Understanding Anypoint Platform.
• Getting familiar with the components of Anypoint Studio

Building Integration Applications with Anypoint Studio
• Understanding Mule application, message structure, flows, Sub-flows, Private Flows and mule Components
• Creating flows graphically.
• Building, running, testing, and debugging Mule applications
• Understanding message properties(Inbound and Out bound) , Variables.
• Understanding Mule Expression Language (MEL)

Connecting to Additional Resources
• Understanding Anypoint connectors.(HTTP,File,FTP,JDBC, JMS, VM, Salesforce,SAP)
• Discovering and installing connectors not bundled with Anypoint Studio

Transforming Data
• Getting familiar with the different types of transformers
• Creating custom transformers with Java
• Understanding dataSense
• Transforming Data with DataWeave

Refactoring Mule Applications
• Separating applications into multiple configuration files
• Encapsulating global elements in a separate configuration file
• Creating and referencing flows and subflows
. Understanding variable persistence through subflows and flows and across transport barriers

Controlling Message Flow
• Understanding and creating synchronous and asynchronous flows
• Multicasting a message (Scatter-Gather, All)
• Routing message based on conditions( CBR-Choice)
• Splitter & Aggregator
• Filtering messages
• Scopes, Validatros

Handling Errors
• Handling messaging exceptions in flows
• Creating and using global exception handlers
• Specifying a global default exception strategy

Processing Records
• Processing items in a collection individually
• Understanding what batch jobs are and when to use them

Web-Services
• Understanding RESTful and SOAP web services
• Consuming RESTful web services with and without RAML definitions
• Using the API Designer to define APIs with RAML
• Implementing a RAML file as a RESTful web service with Anypoint Studio and APIkit
• Learning about what RAML is and how it can be used
• Consuming SOAP web services

Deploying Applications
• Understanding Cloudhub. Static IP, Load Balancer etc.
• Understanding the options for deploying applications
• Adding application properties
• Deploying and running applications on CloudHub
• Deploying and running applications on Mule ESB

Microstrategy live online training, job support & interview support, Corporate Training by Industrial Experts


MicroStrategy Training makes you Learn how to create interactive dashboards in different business domains using Microstrategy. In this training you will learn microstrategy architecture, scorecards, highly formatted reports, designing schema objects using Microstrategy web and desktop., etc.


FOR FREE DEMO contact :
Email : raj@apex-online-it-training.com
Phone/WhatsApp : +91-(850) 012-2107
USA Number : 214-628-3894
Gtalk : raavi.sriraja@gmail.com
Blog: http://apex-it-online-trainings..in
Website: www.apex-online-it-trainings.com


MicroStrategy Interview Questions and Answers, Recorded Video Sessions, Materials, Mock Interviews Assignments Will be provided


MICROSTRATEGY COURSE CONTENT
(the course agenda can be modified as per your requirements):

1. INTRODUCTION TO MICROSTRATEGY
1.1 Business Intelligence
1.1.1 BI Architecture
1.1.2 MicroStrategy
1.2 Product Overview
1.2.1 Intelligence Server
1.2.2 MicroStrategy Desktop
1.2.3 MicroStrategy Web
1.2.4 MicroStrategy Office
1.2.5 MicroStrategy Architect
1.2.6 MicroStrategy Object manager
1.2.7 MicroStrategy Enterprise manager
1.2.8 MicroStrategy Command manager
1.2.9 MicroStrategy SDK
1.3 History
1.4 System Requirements
1.4.1 Hardware
1.4.2 Software

2. PROJECT DESIGN PROCESS
2.1 Metadata
2.1.3 Object Types stored in Metadata
2.2 Project Source
2.3 Project
2.4 Project Creation Assistant
2.4.1 Create Project
2.4.2 Adding Tables using warehouse catalog

3. MICROSTRATEGY ARCHITECT
3.1 Project Layers
3.2 Features
3.3 Facts Creation in Architect
3.4 Attributes Creation in Architect
3.5 Attribute Relations in Architect
3.6 User hierarchies in Architect
3.7 Update Project Schema
3.8 Additional Concepts in Architect
3.8.1 Partition Mapping
3.8.2 Transformations

4. BASIC REPORTING
4.1 Report
4.1.1 Report Components
4.1.2 Report Types
4.1.3 Report Services Document
4.1.4 HTML Documents
4.2 OLAP Services
4.2.1 View Filters
4.2.2 Derived Metrics
4.2.3 Derived Elements
4.2.4 Dynamic Aggregation
4.3 Formatting a Report
4.3.1 Thresholds
4.3.2 Renaming Row and Column headers
4.3.3 Hiding a metric column
4.3.4 Banding
4.3.5 Auto-styles
4.4 Analyzing Data
4.4.1 Sorting
4.4.2 Searching
4.4.3 Outlining
4.4.4 Page-By
4.4.5 Pivoting Data
4.4.6 Report Limits
4.4.7 Calculating Data
4.5 Answering Question about Data
4.5.1 Report Filters
4.5.2 Hierarchies
4.5.3 Drilling
4.6 Refresh data on the report
4.6.1 Report Cache
4.6.2 Answering Report Prompts
4.7 Table of Features
4.8 Create sample report
4.8.1 Report Builder

5. MICROSTRATEGY DESKTOP
5.1 Navigating through Desktop
5.2 Report Editor Interface
5.3 Project objects
5.3.1 Attributes
5.3.2 Metrics
5.3.3 Filters
5.3.4 Prompts
5.3.5 Templates
5.3.6 Custom Groups & Consolidations
5.3.7 Drill Maps
5.4 Reports
5.4.1 Creating new report
5.4.2 Basic Report
5.4.3 Graphs
5.4.4 Free Form SQL and Query Builder
5.4.5 VLDB Properties
5.5 Report Service Documents

6. MICROSTRATEGY INTELLIGENCE SERVER
6.1 MicroStrategy architecture
6.2 MicroStrategy metadata
6.3 What happens when Intelligence Server starts?
6.4 Intelligence Server job processing
6.5 Processing report execution
6.6 Processing object browsing
6.7 MicroStrategy User Model
6.7.1 MicroStrategy users
6.7.2 MicroStrategy user groups
6.7.3 Controlling access to objects: Permissions
6.7.4 Controlling access to functionality: Privileges
6.7.5 Defining sets of privileges: Security roles
6.8 Modes of Authentication
6.9 Managing and verifying your licenses
6.10 Caching
6.11 Scheduling
6.12 Clustering

7. MICROSTRATEGY NARROWCAST SERVER

DataScience with R-Programing hands-on online training, job support & interview support by realtime professionals


Become an expert in data analytics using the R programming language in this data science certification training course. You’ll master data exploration, data visualization, predictive analytics and descriptive analytics techniques with the R language. With this data science course, you’ll get hands-on practice on R CloudLab by implementing various real-life, industry-based projects in the domains of healthcare, retail, insurance, finance.


FOR FREE DEMO contact :
Email : raj@apex-online-it-training.com
Phone/WhatsApp : +91-(850) 012-2107
USA Number : 214-628-3894
Gtalk : raavi.sriraja@gmail.com
Blog: http://apex-it-online-trainings..in
Website: www.apex-online-it-trainings.com


Data Science with R-Programming Course Content
(we can customize the course agenda as per your requirements)


Data Analytics with R Course Content


 Introduction to Business Analytics
 Introduction to R
 R Programming
 R Data Structure
 Apply Functions
 Data Visualization
 Introduction to Statistics
 Hypothesis Testing I
 Hypothesis Testing II
 Regression Analysis
 Classification
 Clustering
 Association

Oracle Apps Functional Realtime online training, job & interview support by hands-on working faculty


Oracle Apps Functional Training makes you specialist as an Oracle Apps Functional Consultant. You would be working towards operations, business suite and has capabilities to understand business flows, design and run queries...etc.


FOR FREE DEMO contact :
Email : raj@apex-online-it-training.com
Phone/WhatsApp : +91-(850) 012-2107
USA Number : 214-628-3894
Gtalk : raavi.sriraja@gmail.com
Blog: http://apex-it-online-trainings..in
Website: www.apex-online-it-trainings.com


Oracle Apps Functional Interview Questions and Answers, Recorded Video Sessions, Materials, Mock Interviews Assignments Will be provided


ORACLE APPS FUNCTIONAL COURSE CONTENT
(the course outline can be modified as per your requirements):

R12 Summary Course Content
Payables (AP)
Receivables (AR)
General Ledger (GL)
Fixed Assets (FA)
Cash Management (CE)
Multi Org Access Control (MOAC)
Sub Ledger Accounting (SLA)


R12 Complete Course Content

Basic concepts of R12:
Architectural Overview – System Administration
UI Navigation changes in R12 Vs 11i
Flex fields
Access and Controls
Functional overview of Products
Concepts of LE/OU/Chart of Accounts
Differences between R11 Vs 11i-sneek peek review
Creation of Users and assignment of Responsibilities
Profile Options and security controls.

Payables:
Invoice Vs Inv Batch
Creation of Invoices (All types of Invoices)
Prepayment Application and Unapplication
Payment of Invoices- Full and Partial
Invoice Accounting
Payables Options
Financials Options
System Hold and Manual Holds
Distribution Set Vs Distribution Accounts
Retainage Release Calculation
WH Taxes
Recurring Invoices
Supplier Setup
Multi Currency payments

Payables Integration Areas:
Procure to Pay (end to end flow)
Creation of PO
Receipt
Inspection
Invoice Matching and Payment for the same
2/3/4 way matching with PO
Auto Invoice from PO
Automatic Offset
Creation of isupplier portal
Supplier PO Management
Data Model Analysis
AP Backend data model
Tables impacted on updation
Retainage Release
Fixed Assets Integration

Oracle Payments (IBY):
Funds Disbursement
Changes in R12 Vs 11i
Role of New Payment Set up Administrator
Creation of Payment Process Profile
Creation of Payment methods
Mapping PPP and Payment Documents with Internal bank Accounts
Payment Process Request Templated and Submission
Manual Vs Automatic completion
Overview of Federal formats
Scheduling Requests in Real time
Assignment of Bank Accounts and PPP
Paying different supplier and OU’s in single pay run
Review proposed payments
Add & Remove invoices during payments
Electronic and Printed Payments
Multi Currency Payments
Validations during payment
Resolve document & payment validation errors
Payment Limits.

MOAC Payments:
Decentralised AP and Payments
Centralized AP and Payments
Terminate
Void and Stop Payments
Void by overflow
Skipped documents

Funds Capture:
Process flow for funds capture
Auths Vs Settlements
Credit Card Creation
Brand activation Vs Inactivation’s
Assignment of credit card and Bank accounts to customer
Encryption Vs Masking
Creation of Funds Capture Process Profile
Creation of Payee
Mapping FCPP
PSA and Payees with OU
Transaction testing auths & settlements
Auth Capture
Credit Card refund
Invoking FC from AR/OM and collections.

Data Model:
Data Model Analysis for Funds Disbursement
Data Model Analysis for Funds Capture

Multi Org Access Control (MOAC):
Changes in 11i Vs R12
Security Profile Options
Security list maintenance
Assigning security to users and responsibilities

Fixed Assets:
Asset Books vs Finance Book
Asset Creation
Calculation of Depreciation
Paying a capital asset PO via AP
Mass Addition
Retirement
Transfer of Asset
Group Vs Member Assets

Cash Management:
Changes in R12 Vs 11i
Creation of Banks/Branches/Accounts
Distinction between Internal bank accounts and external bank accounts
Controls in Cash Management
Reconciliation Manual and Auto Reconciliation
UMX Security Controls
Back end SQL data model for internal and external bank accounts
Cash Clearing
Bank Account Transfers
Cash Positioning and Forecasting

Accounts Receivable:
Creation of Transaction
Receivable Options
Receipt Manual Vs Automatic
Receipt Application Vs Unapplication
Remittances
Refund Manual Vs Credit Card
Charge Back
Customer setups
Auto Cash Rule set
Balance Forward Billing
Type of Transactions and set off with Credit Memo
Accounts Overview

IModules:
I Receivables
I Supplier Portal

Sale Order Management Integration with Financial Modules (AR):
Auto Import Orders
Creation of Invoices in AR using import from OM
Payment of Sales Order using Credit card

Subledger:
Architectural Overview
Even Model in R12 Vs 11i
Accounting Events Definition
Accounting Events in Payables
Accounting Events in Receivables
Modifying seeded AAD
JLT and JLD

Oracle General Ledger:
Creation of Ledger
Accounting Setup Manager
Open and Close periods
Mapping of 4 C’s = Currency
Calendar
COA and Convention
Primary and Secondary Ledger
Reporting Currency Ledger
Transfer/Post Accounting entries to GL
Creation of recurring journals
Data Conversion Levels
COA Mapping
Ledger Vs Ledger Sets
Consolidations
Data Access Set Vs Definition Access Set
Budgets
Consolidations

Financial Statement Generator:

Microsoft Business Intelligence MSBI realtime online training, job Support & interview support by hands-on working professionals


MSBI Training makes your expert in creating real world integration, Analytical and Reporting applications with MSBI. Microsoft BI tools cover a wide range of functionalities and they hold up to the competition very well.


FOR FREE DEMO contact :
Email : raj@apex-online-it-training.com
Phone/WhatsApp : +91-(850) 012-2107
USA Number : 214-628-3894
Gtalk : raavi.sriraja@gmail.com
Blog: http://apex-it-online-trainings..in
Website: www.apex-online-it-trainings.com


MSBI:SSAS,SSIS,SSRS Interview Questions and Answers, Recorded Video Sessions, Materials, Mock Interviews, Assignments Will be provided


MSBI COURSE Agenda
(the course content can be modified as per your requirements):


1) SSIS
• Introduction to SSIS
• Control Flow, Data Flow and Containers
• Transformations -- Includes All Transformations inside Dataflow
• Slowly Changing Dimensions(SCD)
• Tasks used inside Control Flow
• Check Points
• Logging
• Configurations
Ø Jobs & Scheduling Packages
• Deploying SSIS packages
• Performance Tuning of SSIS packages & Optimizations Techniques
• Different Kinds of Data Loadings (Incremental Loading)
• Protection Levels in SSIS
• Precedence constraints

2) SSRS
• Introduction to SSRS
• Core Components - Data Tab, Layout Tab & Preview Tabs
• Designing Reports - Header, Footer, Details, Query Designer
• Creating parameters in reports, Types of parameters, Cascading Parameter
• Drilldown Reports
• Matrix Reports
• Image, Rectangular, Chart and List Reports
• Sub report
Ø Report Deployment and Security
• Drill through Reports
• Report Caching
• Subscriptions
• Adhoc Reports
• N) Linked Report
• o) Report Manager and Report Server
• p) Report Snapshot
• q) Gauge, Data Bars, Spark Lines, Indicators

3) SSAS
• Introduction to Data Ware Housing, SSAS, DataMart’s
• Dimension and Fact tables
• Types of Dimensions
• Schema - Star & Snowflake
• Cube-Advantages, Creation, Processing
• Options inside Data Source View - Named Query, Add/Remove tables, New Relationship
• Levels, Members, Hierarchy
• Measures - Additive, Semi Additive, Non Additive
• Fact less Fact tables
• Storage Modes
• Cube Securities
• Partitions, Calculations, Perspectives
• Create Reports in ssrs using cube
Ø How to browse cube from Excel

Teradata realtime online training, job Support & interview support by hands-on working faculty


TeraData Training online course makes you an expert in using teradata and how to control database space, business analytics solutions, bigdata analytics, integrated data warehousing, advanced teradata sql concepts, etc.


FOR FREE DEMO contact :
Email : raj@apex-online-it-training.com
Phone/WhatsApp : +91-(850) 012-2107
USA Number : 214-628-3894
Gtalk : raavi.sriraja@gmail.com
Blog: http://apex-it-online-trainings..in
Website: www.apex-online-it-trainings.com


Teradata DBA Interview Questions and Answers, Recorded Video Sessions, Materials, Mock Interviews Assignments Will be provided


TERADATA DBA COURSE OUTLINE / AGENDA
(the course content can be modified as per your requirements):

Module 1: (TERADATA Architecture)
• Parsing Engine(PE)
• Request and Response Parcel
• Access Module Processors (AMPs)
• Bynet
• Data access Handling
• TD Config Utilities
• Config and Reconfig

Module 2: (TERADATA Database Space)
• Permanent Space
• Spool Space
• Temp Space
• Indexes

Module 3: (DBC Dictionary Tables)
• Data dictionary
• Parsing Engine
• System Views
• Database Views
• DBC Users View
• Indices View
• All Temp Tables View
• Using DBC AMP Usage
• Using DBC Table Size
• Logon and Logoff Tracking.

Module4: (Access Rights, Roles, Profiles)
• Access rights (Auto,implicit,Explicit Rights)
• Roles and Profiles
• Creating Roles and Profiles
• DBC.RoleInfo and DBC.ProfileInfo

Module 5: (Query analysis and Tools)
• Database Query Log (DBQL)
• DBQL Tables and Views
• Access Logging

Module 6: (System Access Control Levels)
• TD Password Encryption
• Password Security Features
• Host Logon Processing
• GRANT/REVOKE LOGON
• Session Related Views
• DBC.sessionInfo Info View
• Data Access Info Views
• Access LogRules Views
• Access Log Views

Module 7: (TD Manager)
• TD Manager Apps
• TD Dashboard
• Priority Scheduler Admin
• TD Manager Service
• Starting TD Manager

Module 8: (Monitoring tools)
• Performance Monitor
• PMON Main window
• PMON sessions Screen
• TD Administrator
• TD manager Dynamic Utilization Charting
• Locking Logger

Module 9: (TD Remote Console Utilities)
• Starting DB Window
• QRYCONFIG
• QRYSESSN
• RCVMANAGER
• SHOWLOCKS
• VPROCMANAGER
• SHOWSPACE
• SHOWBLOCKS
• PACKDISK
• SCANDISK

Module 10: (Archiving Data)
• Archive and Recovery Statements
• Recovery vs. FastLoad
• Invoking Archive
• Restart Log
• ANALYZE Statement
• Archive
• Database DBC Archive
• Indexes option
• Database DBC Archive
• Archive and Recovery (ARC) Examples

Module 11 (Restoring data)
• Restore
• COPY
• Copying Tables
• BUILD

Mobile Application Testing Realtime online training, job & interview support by hands-on working faculty


Mobile Applications Testing Training is designed to make you an expert in software testing of Mobile Applications developed on IOS, Andriod ..etc. Mobile devices is tested for its functionality, usability and consistency.


FOR FREE DEMO contact :
Email : raj@apex-online-it-training.com
Phone/WhatsApp : +91-(850) 012-2107
USA Number : 214-628-3894
Gtalk : raavi.sriraja@gmail.com
Blog: http://apex-it-online-trainings..in
Website: www.apex-online-it-trainings.com


Mobile Testing Interview Questions and Answers, Recorded Video Sessions, Materials, Mock Interviews Assignments Will be provided


MOBILE TESTING COURSE AGENDA
(the course content can be modified as per your requirements):

 Software Testing Concepts
1. SDLC (Software Development Life Cycle)
2. Software Development Models
3. STLC (Software Testing Life Cycle)
4. Types of Testing

 Mobile Application Testing - Overview
1. Overview of Mobility Testing
2. Mobile Application Development Process
3. Introduction to various Mobile platforms
4. Introduction to Various Apps, Mobile App, Web based App, Native App, Hybrid App.

 Mobile App Testing - Strategy
1. Device Emulator
2. Mobile Cloud Computing (Remote Real Devices)
3. Real Time Devices
4. Automation Tools
5. Emulators and its usage
6. Installation and un- installation of Android Emulator.

 Mobile App Testing - Approach
1. Mobility Application – Test Approach/Phases
2. Test Requirements
3. Test Planning
4. Test Environment setup
5. Test Design
6. Test Execution and Defect tracking
7. Test Reports and Acceptance.

 Mobile App Testing - Scope
1. Unit testing
2. Integration testing
3. Functional testing
4. Device conformance testing
5. System testing
6. Regression testing
7. Mobile browser compatibility testing
8. Performance testing

 Mobile App Testing - Device Conformance
1. Mobile App Device conformance Testing Types
2. Installation testing/Un-Installation Testing
3. Usability testing
4. Interrupt Testing
5. Performance Testing
6. Memory Leakage Testing

 Mobile App Testing - Usability Test Scenarios
1. Authoring of Usability Test Scenarios for Mobile App
2. Orientations
3. Interface
4. Navigation Policies
5. Pop-up policies
6. Icon policies
7. Status screens, Zooming, Work Flows

 Testing - Installation, Networking And Interrupt Test Scenarios
1. Test Scenarios for Installation testing/Un-Installation
2. Test Scenarios for Interrupt Testing.

 Different Test Scenarios and Challenges

Pega realtime online training, job & interview support, Corporate training by hands-on Industrial experts


Pega Training makes you expert in handling customer relationship management and business process management. Pega improves the efficiency of a number of high volume, high importance operations by more than 50%.


FOR FREE DEMO contact :
Email : raj@apex-online-it-training.com
Phone/WhatsApp : +91-(850) 012-2107
USA Number : 214-628-3894
Gtalk : raavi.sriraja@gmail.com
Blog: http://apex-it-online-trainings..in
Website: www.apex-online-it-trainings.com


Pega Interview Questions and Answers, Recorded Video Sessions, Materials, Mock Interviews Assignments Will be provided

PEGA COURSE CURRICULUM
(the course content can be modified as per your requirements):


Pega Course Content

Please follow here for course content and Demo details  https://www.apex-online-it-trainings.com/it-trainings-at-apex/pega-online-training

(Or) mail at raj@apex-online-it-training.com

Biztalk Realtime online training, job support & interview support, Corporate training by IT professionals


BizTalk Server Training is designed to assist learners create maps between document specifications, build business process implementations, as well as integration with XML web services and methodology for BizTalk projects by qualified technical professionals.


FOR FREE DEMO contact :
Email : raj@apex-online-it-training.com
Phone/WhatsApp : +91-(850) 012-2107
USA Number : 214-628-3894
Gtalk : raavi.sriraja@gmail.com
Blog: http://apex-it-online-trainings..in
Website: www.apex-online-it-trainings.com


Biztalk server Interview Questions and Answers, Recorded Video Sessions, Materials, Mock Interviews Assignments Will be provided


BIZTALK COURSE OUTLINE / AGENDA
(the course content can be modified as per your requirements):

BizTalk 2010 Developer and Admin Training & Workshop

1. BizTalk Framework & Architecture
a. Understanding BizTalk
b. BizTalk Architecture
c. Different BizTalk Versions
d. BizTalk 2010 & Visual Studio 2010
e. Understanding BizTalk Development tools
f. BizTalk Project System
g. BizTalk Application Concept
h. Updated Platform support

2. BizTalk Installation

3. BizTalk Databases

4. Understanding BizTalk Ports
a. Port Groups

5. Understanding BizTalk Adapters
a. File
b. WCF SQL
c. WCF Adapter
d. MSMQ Adapter
e. SharePoint Adapter
f. Scheduled Task Adapter

6. Role Link

7. Pipelines
a. Stages, components
b. Types

8. Creating BizTalk Schemas

9. Creating BizTalk Maps
a. Enhanced BizTalk Mapper

10. Functoids

11. Orchestrations Design

12. Creating Orchestrations

13. Different Shapes in Orchestrations

14. Exception Handling

15. Deploying BizTalk Application

16. Accessing Web Services & WCF from orchestrations

17. Publishing orchestrations/Schemas as WCF

18. Using BizTalk WCF publishing wizard

19. Consuming a WCF Service

20. Best Practices to optimize BT Application Performance
a. Adapters
b. Message Box
c. Mappers
d. Schemas
e. Canonical Schema

21. Business Rule Engine (BRE)

22. Orchestration calling another orchestration

23. Compensation

24. ESB Architecture

25. Asynchronous request and response messaging pattern

26. BizTalk Administration
a. Memory & CPU Utilization
b. BT Service monitoring

27. Correlation

28. Transactions

29. BizTalk Application Troubleshooting and Management

30. Business Activity Monitoring (BAM)