TRAINING at ACCENTIQA

TRAINING


Accentiqa offers training on location or remotely using the latest e-learning technologies. Our qualified instructors can help your team be more effective and efficient with ETL TESTING,CLOUD COMPUTING AMAZON AWS, VMWARE, SALESFORCE.COM CRM,NETSUITE ERP, HADOOP BIGDATA. Our individualized training sessions go beyond Technologies. We help users to create well-organized dashboards, verify the workflow of your business processes and create alerts to make sure no one misses any important events.The end result? Efficient users who make the most out of your investment in all above Technologies.

If you cannot find what you are looking for? Call us and we can create a course to meet your needs.

BIG DATA & HADOOP


HADOOP - Overview :
  • What is Big Data.
  • Move computation not data.
  • Hadoop performance and data scale facts.
  • The Apache Hadoop Project.
  • Hadoop - an inside view:
  • MapReduce and HDFS.
  • What about NoSQL?

Hadoop Administrator
  • Setting Up a Hadoop Cluster
  • Cluster Setup and Installation
  • Hadoop Configuration

The Hadoop Distributed Filesystem (HDFS)
  • HDFS Design & Concepts
  • Blocks, Namenodes and Datanodes
  • hadoop dfs The Command-Line Interface
  • Basic Filesystem Operations
  • Reading Data from a Hadoop URL
  • Reading Data Using the FileSystem API

MapReduce
  • Map and Reduce Basics.
  • Shuffling and Sorting.
  • Combiner.
  • Java Map Reduce.
  • Hadoop Streaming

How MapReduce Works
  • Anatomy of a MapReduce Job Run
  • Job Submission,Job Initialization, Task Assignment, Task Execution
  • Progress and Status Updates
  • Job Completion, Failures
  • Shuffle and Sort - Map Side, Reduce Side
  • Configuration Tuning
  • Distributed Cache

Hive
  • Basic concepts.
  • Data storage in partitions.
  • HiveQL.

Cassandra
  • Basics of Cassandra.
  • Why Cassandra?
  • Datastorage in Cassandra.
  • Setting up Cassandra Cluster.
  • Keyspaces and Column Families.
  • *Intro to Astyanax API

SALESFORCE.COM CRM


Level - 1
  • Salesforce.com User Fundamentals
  • Salesforce.com CRM Vanilla Processes
  • Administrator Tasks
  • Salesforce.com Configuration
  • Continuous Hands on Lab work to reinforce concepts
  • Building Report & Dashboards
  • Intro to Apex Coding & Visualforce.com

Level -2 (Advance)
  • Using Force.com IDE
  • Visualforce.com
    • Introduction
    • Developing Pages
    • Changing Look and Feel
    • Data Sets
  • Apex
    • Introduction
    • Triggers, SOSL, Classes, Logic, Expressions & Operators
    • Visualforce Components
    • Custom Controllers

ETL TESTING - QA


DataWare Housing Concepts:
  • What is Data Ware House?
  • Difference between OLTP and DataWare Housing
  • Data Acquisition
  • Data Extraction
  • Data Transformation
  • Data Loading
  • Data Marts
  • Dependent Data Mart
  • Independent Data Mart
Data Base Design
  • Star Schema
  • Snow Flake Schema
  • Fact constellation Schema
SCD(slowly changing dimension)
  • Type-1 SCD
  • Type-2 SCD
  • Type-3 SCD
Basic Concepts in SQL
  • Overview of ETL Tool Architecture
  • White Box and Black BOX Testing Functionality on Different Transformation Rules
Data Ware House Life Cycle
Different Types of Testing Techniques in ETL

  • Minus Queing
  • Count Queing

ETL Testing Concepts
1.Introduction

  • What is use of testing
  • What is quality & standards
  • Responsibilities of a ETL Tester
2.Software development life cycle
  • Waterfall model
  • V-model
  • Agile model & methodology
  • Prototype model
  • Spiral model
3.Testing methodologies
  • White box testing
  • Black box testing
  • Grey box testing
  • ETL Testing Work Flow Process
  • How to Prepare the ETL Test Plan
  • How to design the Test cases in ETL Testing.
  • How to reporting the Bugs in ETL Testing ?
  • ETL Testing Responsibilities in DataStage, Informatica, Abinitio etc;
  • How to detect the bugs through database queries
  • ETL Performing Testing & Performing Tuning

NET SUITE - ERP


NETSUITE ADMNISTRATION :
Course Content
NetSuite best practices to set up, configure, and maintain core functionality
Courses objectives
By the end of the training session, participants will be able to:

  • Describe the role and tasks of the NetSuite administrator
  • Navigate NetSuite and employ various search techniques to find records Define a company setup and accounting preferences
  • Describe how NetSuite characterizes, classifies and segments data
  • Plan the migration of company data into NetSuite Set up users with role-specific dashboards
  • Apply roles and permissions to enable secure data access Publish a dashboard

NETSUITE - ACCOUNTING :
This course is meant for accounting teams, bookkeeping, accounts receivable, accounts payable and executives.
Course Content
How to set up and manage preferences for:

  • Inventory and pricing
  • Purchasing
  • Accounts payable
  • Accounts receivable
  • Client accounts
Course Objectives
By the end of the training session, participants should be able to:
  • Modify the preferences of various accounts
  • Describe standard Invoice-to-Payment business process flows
  • Review banking and the general ledger
  • Set up and present different ways to manage accounts
  • Understand how to manage inventory and its impact on Cost of Goods Sold (COGS)
  • Perform end-user tasks and describe best practices for the above processes

CLOUD COMPUTING


  • Cloud Computing Fundamentals

    • What is cloud computing
    • Why cloud computing
    • Challenges in cloud computing
  • Cloud computing infrastructure and Architecture
  • Virtualization
    • OS Virtualization
    • Network virtualization
    • Machine Images
  • VMWare
  • Cloud patterns
  • SOA & web services
  • Developing cloud based applications
  • Deploying applications in cloud
  • Amazon Web services
    • Fundamentals
    • Security, keys, certificates
    • Amazon S3
    • Amazon EC2
    • Creating custom Amazon AMI
  • Cloud management and monitoring
  • Security in Cloud computing
  • Microsoft Azure
    • Fundamentals
    • Creating and deploying applications in Azure platform
  • Google’s Cloud
    • Google cloud infrastructure
    • MapReduce
  • Creating private cloud
    • Using Open source technologies
  • Migrating to public cloud
    • Opportunities
  • Challenges
Introduction to Cloud Computing
  • Basic Building blocks of Cloud Computing
  • Understanding Virtualization
  • Understanding Infrastructure as a Service
    • Amazon Web Services
    • Rackspace, Gogrid and others
  • Understanding Platform as a Service
    • Google App Engine
    • Cloud Foundry
  • Understanding Software as a Service
    • Sales Force
  • Understanding Private Clouds
    • Eucalyptus
    • Openstack
    • Vmware
Public Clouds – Amazon Web Services & Microsoft Azure
  • Amazon Web Services (AWS)
  • Understanding Basic Components of AWS
    • Elastic Compute Cloud (EC2)
    • Simple Storage Service (S3)
    • Elastic Block Storage(EBS)
    • Elastic Load Balancer (ELB)
  • Understand the usage of the components using APIs
  • Setup a Development Environment in Eclipse for Java
  • Deploy a sample application on Amazon AWS
Platform-as-a-Service – Google App Engine & Cloud Foundry
  • Platform as a Service
  • Google App Engine
    • Understand Components of Google App Engine(GAE)
    • Understand Google App Engine Datastores.
    • Setup Eclipse to use GAE.
    • Develop a Sample Application in Java or Python for GAE
    • Host Application for free on GAE
    • Understanding environment limitations
  • Cloud Foundry
    • Understand components of Cloud Foundry
    • Setup local development environment for Cloud Foundry
    • Develop a Spring-Application for Cloud Foundry
    • Host Application on Cloud Foundry
    • Understand envirorment limitation
Private Clouds
  • Understanding Private Clouds vs Public Clouds
  • Eucalyptus, Openstack and Cloud.com
    • Understand Core Components – Compute, Storage
  • Using EucalytuPrivate Cloud
    • Eucalyptus Architecture
    • Elastic IPs and Security Groups
    • Image Management
    • Working with Instances
    • Working with Volumes and Snapshots
    • Understanding euca-tools
Programming for the Cloud
  • Understanding Multi-tenancy
  • Exposing APIs
  • Consuming APIs
  • Design for Failure
  • Design for Economics
  • Understanding jclouds