Courses

Home / Courses

American Institute of Technical Education (AITE) is licensed as a private career school. Licensure is not an endorsement of the Institution. The institute aims to serve the best interest of community and make IT education available to all at a nominal and affordable price.

Module 1A: Software Testing / QA Training

QA is the most important part of any software development and so are Software Testers. This courses focuses on manual and automation testing techniques and tools. This training is designed for fresher and professional to provide cutting edge in the ever-growing competitive job market. This coursework is very JOB ORIENTED and HAND- ON taught by working professional.

Prerequisite- None

Knowledge or experience in Finance, healthcare, Retail, Insurance domain is a added advantage.

Detail Course Content

Software Development Life Cycle (SDLC)

  • Traditional vs. Empirical models
  • Waterfall Model
  • V-V Model
  • Spiral Model
  • Agile methodologies
  • Scrum Model
  • CMM and CMMI standards
  • ISO Standards

Software Testing Concepts

  • White box vs Blackbox testing
  • Types of testing including
  • Unit, INT, SYS, EIT, Reg, Smoke, Sanity, GUI, Internationalization etc
  • Level 0 and Level 1 estimation models
  • Master Test Plan
  • Requirement Analysis
  • Test Case Design
  • Test Execution
  • Defect Lifecycle
  • Defect Triage
  • Testing Deliverables
  • Equivalence Portioning and Error Guessing
  • Traceability matrix

Manual Testing Tool (HPQC 9.x and IBM Rational Clearquest)

  • Requirement Building
  • Test Plan and Test Case development
  • Test Lab (execution)
  • Defects
  • Traceability of requirement, test plans and defects
  • Test Parameterization
  • Test analysis and reporting

SQL using MS Access/Oracle

  • RDBMS Introduction
  • DML vs DDL
  • Select, Insert, Delete and Update commands
  • Orderby and groupby
  • Joins and Unions
  • SQL Constraints
  • SQL Functions

Automation Testing using HP QTP 9.x
Basic – QTP tool

  • Introduction to automation
  • Overview of QTP tool
  • Recording and Running
  • Checkpoints and Output values
  • Test Result Analysis
  • Data tables and parameterization
  • Actions and types
  • Object Repository
  • Object Spy

Revision and Class Performance Analysis

  • QA Case studies like Database/backend testing, ETL testing, Siebel testing.
  • Project Presentation by candidates
  • Domain Knowledge
  • Mock Interview practice
  • Resume preparation help

Schedule

Weekday Training schedule: Monday to Friday 10:00AM CST – 3:30PM CST
Weekday Training Duration: 1 week

Weekend Training schedule: Saturday and Sunday 10:00AM CST – 3:30PM CST
Weekend Training Duration: 3 weeks

Total Hrs of Training: ~40hrs (excluding homework)

NOTE: Take home homework is worth extra 20hrs.

Start Date

Please click on the below link for the start date

www.instituteusa.com/schedule

Fee Details

Instructor led classroom training : $1600.00

Live online training : $800.00

Video based training : $500.00

(Individual, group and corporate discount available.). Please talk to the counselor about discounts.

Payment Methods

  • By Check
  • By Credit Card

Registration

Please complete your personal and credit card (cc) details in the enrollment form to register for the training. Also, this is just a registration process, the actual fee will be charged only after first half day of class.

Although you provide us with the cc details during registration, you can choose to pay by check or cc on the first day of the training.

Email the completed enrollment form to training@instituteusa.com . Please talk to your respective counselor for any questions.

REGISTRATION IS COMPULSORY. LAST DAY TO REGISTER – 2 BUSINESS DAYS PRIOR TO THE START DATE.

In-Class Training Location:

  • 220 Robert Street S, Suite 100
    Saint Paul, MN – 55107.

Live Online Training also available.

Training Features

  • Unlimited Training as many times as you want, till your confident enough to face interviews with in a year.
  • Complete refund of training fee 2 months after the candidates secures a project while working with us.
  • Course completion certificate will be provided.
  • Free Lab access for 3-4 weeks.
  • Weekday Morning, evening and Weekend training sessions available.
  • New facility with labs and remote access.
  • Just tool access available for 3 months. Call on 651-222-9922 for more information.
  • Free career counseling based on your education and industry experience.
  • Instructor led Training.
  • Lab exercises, assignments, projects for each session.
  • Training available in live online or classroom training.
  • * Instructor support provided after training.
  • Training material constantly updated to remain competitive
  • * On Job and interview support.
  • * Case Studies of our clients in various popular domain – client specific training
  • Industry experienced instructors, to give you Real Time solutions.
  • Full assistance in Placement.
  • * On-going support for at least a year after your training.
  • Lifetime of notes, tools and other necessary material.
Module 1B: Automation Testing / Automation QA

Automated software testing plays a vital role in many software development and web application projects. Test automation for modern GUI software is very challenging. This course focuses on the HP automation tool QTP (Quick Test Professional). Creating automation scripts with the tool using advanced features like Actions, Library files, Data Driven Tests, Descriptive programming, Exception Handling and understand the different frameworks available for QTP.

 

Prerequisite- Manual testing Knowledge/experience

Knowledge in VB script / any scripting is a added advantage.

 

Detail Course Content

Introduction to Automation testing

  • Need of Automation.
  • Introducing various tools and functionalities.
  • Difference between manual testing and
  • Automation testing.
  • Introduction to QTP tool and discussion on various versions of QTP

Testing Process of QTP

  • Understanding the Test Process of QTP
  • Discussion on the various components of QTP
  • Window like test pane, Test details pane,
  • Active screen, Data table, Information and
  • Discussion on the keyword view and Expert view.
  • Understanding different toolbars and window
Implementation GUI and Bitmap Regression Test
  • Understanding the Add-in manager.
  • Working with Automation Record and Run setting
  • Working with File settings.
  • Working with Tools options
Creating Test Scenarios / Components
  • Creating a basic script.
  • Understand diff recording modes of QTP
  • (Normal, Analog, Low-Level).
  • Understanding Test object, Run Object,
  • Pre Learning and Auto Learning.
  • Understanding how QTP identifies the objects
  • (Mandatory & Assistive properties).
  • Working with Object Repository
  • (Shared and Per-Action).
  • Working with Object Repository Manager.
  • Associating Objects Repositories to Actions of QTP
  • Working with Object Spy
  • Understanding the basic structure of QTP script
Understanding the need of checkpoints in Automation
  • Working on various checkpoints available in QTP
  • Understanding the need of output values in
  • Automation.
  • Working on various output values available in QTP
  • Understanding the Environment Variables /
  • Global Variables.
  • Working on both inbuilt and Userdefined Variables
Action in QTP
  • Introduction to Actions in QTP advantages of Actions.
  • Creating New actions, Split actions.
  • Working on reusability of Actions with call to
  • existing and call to copy options.
Functions, Procedures and Classes (Library Files)
  • Automation Testing.
  • Creating Local and Global functions in QTP
  • Working with Library Files of QTP
  • Creating user defined classes, methods and objects in QTP
  • Understanding how a function returns the value in QTP

Parameterization / Data Driven Test

  • Introduction to parameterization.
  • Creating a Parameterized script (Data Driven Test)
  • Working on different methods of Data Table object
  • Working on different ways of parameterizing an object in QTP

File Operations in QTP

  • Reading from, Writing to external files like
  • Text files, Excel files.
  • Working with XML util object.
  • Performing various operations on XML files using QTP

Advanced Options

  • Descriptive programming.
  • Exception Handling / Recovery scenario Manager.
  • Smart Identification, Configuration of object Identification.
  • Database connection using ADODB objects.

Schedule

Weekday Training schedule: Monday to Friday 10:00AM CST – 3:30PM CST
Weekday Training Duration: 1 week

Weekend Training schedule: Saturday and Sunday 10:00AM CST – 3:30PM CST
Weekend Training Duration: 3 weeks

Total Hrs of Training: ~40hrs (excluding homework)

NOTE: Take home homework is worth extra 20hrs.

Start Date

Please click on the below link for the start date

www.instituteusa.com/schedule

Fee Details

Instructor led classroom training : $1600.00

Live online training : $800.00

Video based training : $500.00

(Individual, group and corporate discount available.). Please talk to the counselor about discounts.

Payment Methods

  • By Check
  • By Credit Card

Registration

Please complete your personal and credit card (cc) details in the enrollment form to register for the training. Also, this is just a registration process, the actual fee will be charged only after first half day of class.

Although you provide us with the cc details during registration, you can choose to pay by check or cc on the first day of the training.

Email the completed enrollment form to  training@instituteusa.com . Please talk to your respective counselor for any questions.

REGISTRATION IS COMPLUSORY. LAST DAY TO REGISTER – 2 BUSINESS DAYS PRIOR TO THE START DATE.

In-Class Training Location:

  • 220, Robert Street S, Suite 100
    Saint Paul, MN 55107

Live Online Training also available.

Training Features

  • Unlimited Training as many times as you want, till your confident enough to face interviews with in a year.
  • Complete refund of training fee 2 months after the candidates secures a project while working with us.
  • Course completion certificate will be provided.
  • Free Lab access for 3-4 weeks.
  • Weekday Morning, evening and Weekend training sessions available.
  • New facility with labs and remote access.
  • Just tool access available for 3 months. Call on 651-222-9922 for more information.
  • Free career counseling based on your education and industry experience.
  • Instructor led Training.
  • Lab exercises, assignments, projects for each session.
  • Training available in live online or classroom training.
  • * Instructor support provided after training.
  • Training material constantly updated to remain competitive
  • * On Job and interview support.
  • * Case Studies of our clients in various popular domain – client specific training
  • Industry experienced instructors, to give you Real Time solutions.
  • Full assistance in Placement.
  • * On-going support for at least a year after your training.
  • Lifetime of notes, tools and other necessary material.
Module 2: Business Analysis (BA)

A business analyst applies skills and domain knowledge in understanding customer needs to translate it into specification through elicitation, facilitation and business analysis, while constantly communicating, tracing and validating requirements. This course is designed for fresher and professional to provide cutting edge in the ever-growing competitive job market. This coursework is very JOB ORIENTED and HAND- ON taught by working professional.

Prerequisite- None

Knowledge or experience in Finance, healthcare, Retail, Insurance domain is a added advantage

Detail Course Content

Introduction to SDLC

  • Predictive and Adaptive Models
  • Testing/QA and Business Analysis
  • Concepts & Role of Business Analysis
  • Review the major tasks performed by the Business Analyst.
  • Define the essential skills needed to perform their tasks.
  • Essential IT Concepts (RDBMS, Web development, eCommerce, ERP)

Project Introduction

  • Project Lifecycle – initiation, planning, execution, evaluation, and closing
  • Product Lifecycle (PLM)-Conception, growth, maturity, decline, withdraw
  • Identify project participants and their roles.
  • Discuss how the Business Analyst interacts with these participants.

Requirement Gathering Techniques

  • Categorizing Requirements, Facilitating Requirements Session
  • Enterprise Analysis
  • Elicit Requirements through Document Analysis, Observation JAD Session, and Role of a BA in JAD Session
  • Creating Functional Requirement Document
  • Review Templates and Checklists
  • Obtaining consensus and signoff of requirements
  • Rational Requisite Pro Tool

UML Diagrams

  • Static, Functional and Dynamic categories
  • Types of diagrams – DFD, Class, Object, Sequence, State Chart, Use Cases,
  • Activity Use Case Diagrams
  • Creating Use cases from Requirements
  • Creating Use Case Narratives Rational Rose and MS Visio Tool

Introduction to MS Sharepoint

  • Basics of Sharepoint & Building block
  • Organize group activities and share calendar
  • Share & transfer documents
  • Collaborative working
  • Discuss and manage projects via sub sites
  • Exchange data with other office applications
  • Collection of customer data through surveys and data analysis

Introduction to MS project

  • Creating the project
  • Assigning resources to tasks
  • Creating task links (dependency)
  • Adjust project schedule
  • Tracking you project (baseline/actual plan)
  • Project calendar
  • Project critical path

Candidate performance evaluation

  • Domain Knowledge
  • Class Test
  • Mock case study presentation by candidates
  • Resume discussion
  • Interview questions

Schedule

Weekday Training schedule: Monday to Friday 10:00AM CST – 3:30PM CST
Weekday Training Duration: 1 week

Weekend Training schedule: Saturday and Sunday 10:00AM CST– 3:30PM CST
Weekend Training Duration: 3 weeks

Total Hrs of Training: ~40hrs (excluding homework)

NOTE: Take home homework is worth extra 20hrs.

Start Date

Please click on the below link for current start date

www.instituteusa.com/schedule

Fee Details

Instructor led classroom training : $1600.00

Live online training : $800.00

Video based training : $500.00

(Individual, group and corporate discount available.). Please talk to the counselor about discounts.

Payment Methods

  • By Check
  • By Credit Card

Registration

Please complete your personal and credit card (cc) details in the enrollment form to register for the training. Also, this is just a registration process, the actual fee will be charged only after first half day of class.

Although you provide us with the cc details during registration, you can choose to pay by check or cc on the first day of the training.

Email the completed enrollment form to training@instituteusa.com .  Please talk to your respective counselor for any questions.

REGISTRATION IS COMPLUSORY. LAST DAY TO REGISTER – 2 BUSINESS DAYS PRIOR TO THE START DATE.

In-Class Training Location:

  • 220, Robert Street S, Suite 100
    Saint Paul, MN 55107.

Live Online Training also available.

Training Features

  • Unlimited Training as many times as you want, till your confident enough to face interviews.
  • Complete refund of training fee 2 months after the candidates secures a project while working with us.
  • Course completion certificate will be provided.
  • Free Lab access for 3-4 weeks.
  • Weekday Morning, evening and Weekend training sessions available.
  • New facility with labs and remote access.
  • Just tool access available for 3 months. Call on 651-222-9922 for more information.
  • Free career counseling based on your education and industry experience.
  • Instructor led Training.
  • Lab exercises, assignments, projects for each session.
  • Training available in live online or classroom training.
  • * Instructor support provided after training.
  • Training material constantly updated to remain competitive
  • * On Job and interview support.
  • * Case Studies of our clients in various popular domain – client specific training
  • Industry experienced instructors, to give you Real Time solutions.
  • Full assistance in Placement.
  • * On-going support for at least a year after your training.
  • Lifetime of notes, tools and other necessary material.
Module 3: Middle Ware (Tibco)

Prerequisite- None

Knowledge or experience in Java/J2ee is an added advantage.

Detail Course Content

EAI Concepts

  • What is EAI?
  • Why EAI?
  • How Business work using EAI
  • TIBCO Runtime Agent (TRA).
  • How TIBCO Supports EAI

TIBCO BUSINESS Works (5.4)

  • Concepts Of Business Works
  • How IDE Looks
  • Working With palettes with Complex Transaction.
  • File, HTTP, FTP, JDBC, Adapter, General Configuration, JMS, SOAP, WSDL, JAVA, Transaction, XML, Parse, MQ Adapter Pallets
  • X Path Function
  • How to create EAR File
  • Difference between version of TIBCO (2.x, 5.x) Versions
  • How to convert (2.x) project to (5.x) project (Migration)

TIBCO EMS

  • Concepts of Enterprise Messaging System (EMS).
  • Topics /Queues
  • Bridging Topics /Queues
  • Persistence /Non-persistence
  • Durable /Non Durable
  • Creation of Topics /Queues, granting Privileges, etc.
  • Routes & Fault tolerance.

TIBCO RV (7.2)

  • Concepts of RV (Messaging Infrastructure).
  • Types Of Messaging
  • Reliable
  • Certified
  • Fault Tolerance
  • Distributed Queues
  • Publish /Subscribe, Point –to-point, Multicast Messaging
  • Virtual Circuits
  • Rendezvous Demo (RVD)
  • Rendezvous routing Demon (RVD)
  • Rendezvous applets (RVA)

ADAPTERS

  • Adapter concepts.
  • File adapter.
  • ADB adapter.
  • Integrating Oracle, DB2, Sybase.
  • MQ services adapter sending and receiving Cobol copy books.
  • SAP R/3 adapter.
  • Exposing SAP as web service.
  • Siebel adapter.

TIBCO ADMINSTRATION

  • Concepts
  • Resource Management
  • Creation of Domain.
  • How to add a machine in a domain
  • How to create a user
  • How to grant roles to the user
  • How to add a secondary sever into a Domain
  • How to add EMS server into Domain
  • How to enable HTTPS
  • Application Management
  • How to deploy EAR file
  • How to start / stop the process
  • How to enable HAWK in administration

TIBCO HAWK

 

  • What is HAWK?
  • How to configure HAWK
  • How to create Rule base in HAWK.
  • How to monitor the process, operating systems
  • End Systems using HAW

TIBCO Activematrix Business work 5.x

 

  • Introduction to TIBCO ActiveMatrix
  • BusinessWorks software fundamentals (design and testing)
  • BusinessWorks web services and process automation
  • Application deployment and management with TIBCO Administrator
  • Introduction to iprocess

Revision and Class Performance Analysis

  • Case studies
  • Project Presentation by candidates
  • Domain Knowledge
  • Mock Interview practice
  • Resume preparation help

Schedule

Weekend Training schedule: Saturday and Sunday 10:00AM CST – 3:30PM CST
Weekend Training Duration: 3 weeks

Total Hrs of Training: ~40hrs (excluding homework)

NOTE: Take home homework is worth extra 20hrs.

Start date

Please click on the below link for the current start date

www.instituteusa.com/schedule

Fee Details

Instructor led classroom training : $1600.00

Live online training : $800.00

Video based training : $500.00

(Individual, group and corporate discount available.). Please talk to the counselor about discounts.

Payment Methods

  • By Check
  • By Credit Card

Registration

Please complete your personal and credit card (cc) details in the enrollment form to register for the training. Also, this is just a registration process, the actual fee will be charged only after first half day of class.

Although you provide us with the cc details during registration, you can choose to pay by check or cc on the first day of the training.

Email the completed enrollment form to training@instituteusa.com. Please talk to your respective counselor for any questions.

REGISTRATION IS COMPLUSORY. LAST DAY TO REGISTER – 2 BUSINESS DAYS PRIOR TO THE START DATE.

In-Class Training Location

  • 220, Robert Street S, Suite 100
    Saint Paul, MN 55107

Live Online Training also available.

Training Features

  • Unlimited Training as many times as you want, till your confident enough to face interviews.
  • Complete refund of training fee 2 months after the candidates secures a project while working with us.
  • Course completion certificate will be provided.
  • Free Lab access for 3-4 weeks.
  • Weekday Morning, evening and Weekend training sessions available.
  • New facility with labs and remote access.
  • Just tool access available for 3 months. Call on 651-222-9922 for more information.
  • Free career counseling based on your education and industry experience.
  • Instructor led Training.
  • Lab exercises, assignments, projects for each session.
  • Training available in live online or classroom training.
  • * Instructor support provided after training.
  • Training material constantly updated to remain competitive
  • * On Job and interview support.
  • * Case Studies of our clients in various popular domain – client specific training
  • Industry experienced instructors, to give you Real Time solutions.
  • Full assistance in Placement.
  • * On-going support for at least a year after your training.
  • Lifetime of notes, tools and other necessary material.
Module 4: Java and J2EE

1 and 2 Introduction to Java programming concepts using TextPad
Introduction to OO Concepts – Polymorphism, Inheritance and Encapsulation Overview of ASP .net with C# and Visual basic
Lab sessions

3,4, 5 Web programing basics/ Core Java/ Install and use Netbeans
Object Oriented analysis and design (Basic concepts)
Servlets/JSP/Expression Language
SQL basics/ Oracle Java Database Connectivity (JDBC)
Struts Framework / Model View Controller architecture
JSP/ Servlets/JSTL
Spring Framework and Hibernate
RMI, Socket Programming and Enterprise Java Beans

Module 5: ASP .NET

Prerequisite- None

Knowing any programming language like Cobol, C, C++ or Java is an added advantage..

Detail Course Content

  • Introduction to OOPs concepts – Basics of object oriented programming like classes, objects, access modifiers, data types etc.
  • Introduction to .net framework – What is .net, CLR and class library
  • Introduction to Asp. net, C# and Visual Studio.net
  • Sample C# example and command line compilation
  • Asp.net Controls – Basic html tags, Use of controls from HYPERLINK “http://asp.net” asp.net toolkit like dropdown, button control
  • User controls and Custom Controls
  • Validating User input – Use of HYPERLINK “http://asp.net” asp.net validation controls
  • Intro to Ado.net – Overview of System. Data namespace and Data access techniques
  • Databound controls and DataBinding using Gridview
  • The Page Object Model – Page class, its properties, methods and events
  • Configuration and state management – web.config, app.config files, maintaining Client and server state using View State, Application, Session and Cache
  • CSS, themes and Master pages – How to apply themes, styles, Css and use of Master pages
  • Site Navigation and data access – Insight into site-map, site- structure and site navigation
  • Handlers, Modules and IIS – Insight into HttpApplication object, Http handlers and http modules
  • Webparts – What are webparts, their usage
  • Providers – Various data providers and the classes available for data binding
  • Security– The security infrastructure and subsystem relationships of the HYPERLINK “http://ASP.NET” ASP.NET and the sequence of events that occur when authentication is sought.
  • .Net Webservices, Remoting – Overview of advanced .net features like webservices, remoting and the scenarios they are used in.
  • Ajax– What is Ajax, why use Ajax and overview of HYPERLINK “http://ajax.net” ajax.net
  • Debugging – Using the Visual studio debugger,
  • Deployment – app.config, web.config
  • LinQ, Wcf, Wpf, WWf overview – Difference in .net 2.0/3.5 and new features of .net 3.5, Insight into what is WPF, WCF, WWF and Linq

Revision and Class Performance Analysis
Final Lab project to create a .net application to get Hands on practical experience on all of the above Project Presentation by candidates
Domain Knowledge
Mock Interview practice
Resume preparation help

Schedule

Weekday Training schedule: and Sunday 10:00AM CST – 3:30PM CST
Weekday Training Duration: 3 week

Total Hrs of Training: ~40hrs (excluding homework)

NOTE: Take home homework is worth extra 20hrs.

Start Date

Click on the below link for the current start date

www.instituteusa.com/schedule

Fee Details

Instructor led classroom training : $1600.00

Live online training : $800.00

Video based training : $500.00

(Individual, group and corporate discount available.). Please talk to the counselor about discounts.

Payment Methods

  • By Check
  • By Credit Card

Registration

Please complete your personal and credit card (cc) details in the enrollment form to register for the training. Also, this is just a registration process, the actual fee will be charged only after first half day of class.

Although you provide us with the cc details during registration, you can choose to pay by check or cc on the first day of the training.

Email the completed enrollment form to training@instituteusa.com . Please talk to your respective counselor for any questions.

REGISTRATION IS COMPLUSORY. LAST DAY TO REGISTER – 2 BUSINESS DAYS PRIOR TO THE START DATE.

In-Class Training Location:

  • 220, Robert Street S, Suite 100
    Saint Paul, MN 55107

Live Online Training also available.

Training Features

  • Unlimited Training as many times as you want, till your confident enough to face interviews.
  • Complete refund of training fee 2 months after the candidates secures a project while working with us.
  • Course completion certificate will be provided.
  • Free Lab access for 3-4 weeks.
  • Weekday Morning, evening and Weekend training sessions available.
  • New facility with labs and remote access.
  • Just tool access available for 3 months. Call on 651-222-9922 for more information.
  • Free career counseling based on your education and industry experience.
  • Instructor led Training.
  • Lab exercises, assignments, projects for each session.
  • Training available in live online or classroom training.
  • * Instructor support provided after training.
  • Training material constantly updated to remain competitive
  • * On Job and interview support.
  • * Case Studies of our clients in various popular domain – client specific training
  • Industry experienced instructors, to give you Real Time solutions.
  • Full assistance in Placement.
  • * On-going support for at least a year after your training.
  • Lifetime of notes, tools and other necessary material.
Module 6: Datawarehousing and Informatica 8.x

Prerequisite-

Databases Knowledge. Knowing SQL, Oracle or SQL server is a added advantage.

Detail Course Content

Introduction to Data warehousin

  • Data Warehouse Architecture
  • DW design Methodologies: Bottom-up design, Top-down design (Inmon/ Kimball Approaches) and Hybrid Design.
  • Extract, transform, and load (ETL)
  • Database Design (OLAP- MOLAP, ROLAP & HOLAP)

Informatica 8.X

  • PowerCenter Architecture
  • Informatica Server, Repository and Client Installation & Configuration
  • Security, Server & Repository Management
  • Production Migration & Performance Tuning
  • Source Qualifier/ File Lists/ Workflow Scheduler/Reusable Transformations/ Debugger
  • Detailed Review of the Expression/ Filter/ Sorter/Aggregator/ Joiner/ Lookup/ Update Strategy/ Router/ Sequence Generator Transformations.
  • Source and Target Overrides/ Parameters and Variables/ Self-Join/ incremental Aggregation/ Dynamic Lookup Cache/ Mapplets/
  • Workflow Configuration and Techniques
  • Reusable Schedule for a Workflow/ Session Configuration/ Tasks and Worklets.
  • Performance tuning.
  • Creating and managing Repository
  • Designing the ETL (Extract, Transform & Load) Functions
  • Understanding The After-Design Scenario
  • Specifying the Database Connections

Revision and Class Performance Analysis

  • Case studies
  • Project Presentation by candidates
  • Domain Knowledge
  • Mock Interview practice
  • Resume preparation help

Schedule

Weekday Training schedule: Monday to Friday 10:00AM CST – 3:30PM CST
Weekday Training Duration: 1 week

Weekend Training schedule: Saturday and Sunday 10:00AM CST – 3:30PM CST
Weekend Training Duration: 3 weeks

Total Hrs of Training: ~40hrs (excluding homework)

NOTE: Take home homework is worth extra 20hrs.

Fee Details

Instructor led classroom training : $1600.00

Live online training : $800.00

Video based training : $500.00

(Individual, group and corporate discount available.). Please talk to the counselor about discounts.

Payment Methods

  • By Check
  • By Credit Card

Registration

Please complete your personal and credit card (cc) details in the enrollment form to register for the training. Also, this is just a registration process, the actual fee will be charged only after first half day of class.

Although you provide us with the cc details during registration, you can choose to pay by check or cc on the first day of the training.

Email the completed enrollment form to training@instituteusa.com . Please talk to your respective counselor for any questions.

REGISTRATION IS COMPLUSORY. LAST DAY TO REGISTER – 2 BUSINESS DAYS PRIOR TO THE START DATE.

In-Class Training Location:

  • 220, Robert Street S, Suite 100
    Saint Paul, MN 55107

Live Online Training also available.

Training Features

  • Unlimited Training as many times as you want, till your confident enough to face interviews.
  • Complete refund of training fee 2 months after the candidates secures a project while working with us.
  • Course completion certificate will be provided.
  • Free Lab access for 3-4 weeks.
  • Weekday Morning, evening and Weekend training sessions available.
  • New facility with labs and remote access.
  • Just tool access available for 3 months. Call on 651-222-9922 for more information.
  • Free career counseling based on your education and industry experience.
  • Instructor led Training.
  • Lab exercises, assignments, projects for each session.
  • Training available in live online or classroom training.
  • * Instructor support provided after training.
  • Training material constantly updated to remain competitive
  • * On Job and interview support.
  • * Case Studies of our clients in various popular domain – client specific training
  • Industry experienced instructors, to give you Real Time solutions.
  • Full assistance in Placement.
  • * On-going support for at least a year after your training.
  • Lifetime of notes, tools and other necessary material.
Module 7: Datawarehousing and Datastage V8

Prerequisite-

Knowing SQL, Oracle or SQL server is a added advantage.

Detail Course Content

Introduction to Data warehousing

  • Data Warehouse Architecture
  • DW design Methodologies: Bottom-up design, Top-down design (Inmon/ Kimball Approaches) and Hybrid Design.
  • Extract, transform, and load (ETL)
  • Database Design (OLAP- MOLAP, ROLAP & HOLAP)

Datastage V8 Tool

  • Introduction to Datastage – Deployment, Administration console, Designer, Director, Administrator
  • Combine data using lookup, join, and merge stages
  • Create jobs that read from and write to sequential files
  • Make jobs that read from and write to a relational database using the connector stages
  • Build jobs that process data using transformations, combinations, filterings, sortings and aggregations
  • Conduct searches and impact analyses
  • Produce job reports
  • Construct DataStage users
  • Administer the DataStage environment
  • Reusable Schedule for a Workflow/ Session Configuration/ Tasks and Worklets.
  • Performance tuning.
  • Creating and managing Repository
  • Designing the ETL (Extract, Transform & Load) Functions

Revision and Class Performance Analysis

  • Case studies
  • Project Presentation by candidates
  • Domain Knowledge
  • Mock Interview practice
  • Resume preparation help

Schedule

Weekend Training schedule: Saturday and Sunday 10:00AM CST – 3:30PM CST
Weekend Training Duration: 3 weeks

Total Hrs of Training: ~40hrs (excluding homework)

NOTE: Take home homework is worth extra 20hrs.

Fee Details

Instructor led classroom training : $1600.00

Live online training : $800.00

Video based training : $500.00

(Individual, group and corporate discount available.). Please talk to the counselor about discounts.

Payment Methods

  • By Check
  • By Credit Card

Registration

Please complete your personal and credit card (cc) details in the enrollment form to register for the training. Also, this is just a registration process, the actual fee will be charged only after first half day of class.

Although you provide us with the cc details during registration, you can choose to pay by check or cc on the first day of the training.

Email the completed enrollment form to training@instituteusa.com . Please talk to your respective counselor for any questions.

REGISTRATION IS COMPLUSORY. LAST DAY TO REGISTER – 2 BUSINESS DAYS PRIOR TO THE START DATE.

In-Class Training Location:

  • 220, Robert Street S, Suite 100
    Saint Paul, MN 55107

Live Online Training also available.

Training Features

  • Unlimited Training as many times as you want, till your confident enough to face interviews.
  • Complete refund of training fee 2 months after the candidates secures a project while working with us.
  • Course completion certificate will be provided.
  • Free Lab access for 3-4 weeks.
  • Weekday Morning, evening and Weekend training sessions available.
  • New facility with labs and remote access.
  • Just tool access available for 3 months. Call on 651-222-9922 for more information.
  • Free career counseling based on your education and industry experience.
  • Instructor led Training.
  • Lab exercises, assignments, projects for each session.
  • Training available in live online or classroom training.
  • * Instructor support provided after training.
  • Training material constantly updated to remain competitive
  • * On Job and interview support.
  • * Case Studies of our clients in various popular domain – client specific training
  • Industry experienced instructors, to give you Real Time solutions.
  • Full assistance in Placement.
  • * On-going support for at least a year after your training.
  • Lifetime of notes, tools and other necessary material.
Module 8: Web Programming
Sessions Topics Covered Class Hrs Lab Extended Lab Hrs
1 Web Page Basics XHTML & CSS 6 Hrs
  • Introducing XHTML
    • XHTML Editors
    • Formatting documents/ images/ forms
  • File Transfer Protocol
    • Using an ftp tool to transfer your .html files to a server
  • StyleRules and Stylesheets
JavaScript Functions and Objects
  • Summary of JavaScript
  • Using functions to handle events
  • Methods in JavaScript
2 PHP 5.3 Crash Course 5 Hrs
  • PHP Basics
    • PHP Basic Syntax
    • Variables and Variable Scope
    • Constants
    • Operators
    • Flow Control
  • Using Files and Arrays
    • File processing Basics
    • Array operators
    • Looping through arrays
    • Multidimensional arrays
    • Sorting arrays
  • String Manipulation and Functions
    • Operations on Strings
    • Passing input to the function
3 PHP 5.3 Crash Course Continued 5Hrs
  • Object-oriented PHP
    • Creating classes, attributes and operations
    • Encapsulation, Inheritance, Polymorphism
  • Using session control in PHP
    • Using sessions
    • Starting, registering and destroying sessions
    • Setting and using a cookie
  • Handling email in PHP
  • PHP and HTML Forms
    • Create Forms
    • Validating numbers
    • String Manipulation
  • Regular Expressions
    • Regular Expression Syntax
Mid Term Test
4 Database Management Systems using MySQL 5.4 and E-Commerce and Web Security 6 Hrs
  • Database Management Systems using MySQL 5.4
    • Simple SELECTs, Subqueries, Joins and Unions
    • Inserting, updating and deleting records
  • Setting and closing database connection
    • Querying the database
    • Web Database Architecture
  • E-Commerce and Web Security
    • Authentication with PHP and MySQL
  • Protocols TCP/IP HTTP
5 Introduction to PEAR, AJAX, Ruby on rail 6 Hrs
  • PEAR:DB
    • Advantages and Disadvantages of PEAR DB
      • Why use a database abstraction layer?
      • When not to use a database abstraction layer?
    • Why use a database abstraction layer?
    • When not to use a database abstraction layer?
    • Using PEAR DB
  • Introduction to XML, AJAX, SOAP
  • Introduction to Ruby on Rail
6 Introduction to DreamWeaver CS4 and MVC Framework (Zend, CakePHP, Symfony, CodeIgniter)(Anyone of the framework will be covered) 6Hrs
  • Case Studies and Labs sessions
Final Test
Module 9 A: SAP FICO

Prerequisite- NONE

Accounting knowledge is a added advantage.

Topics to be covered in the SAP Financial Accounting and Controlling (FI/CO) training

a) Basic introduction of ERP and SAP

b) FI Module

  1. Enterprise / Organizational structure and Global settings
  2. General Ledger (GL) Accounting configuration and new GL using SAP 6.0 ECC
  3. Accounts Receivables (AR) and Accounts payable (AP)
  4. Reporting Strategies
  5. Payments – payments program, dunning program, interest calculation etc.
  6. Cash Management
  7. Asset Management and Accounting
  8. Special Purpose Ledger configuration techniques
  9. Overview of Consolidation, Bank Accounting, Funds Management and Contract AccountingSAP 6.0 ECC focuses on system configuration, integration with financial accounting subsidiary ledgers and with controlling, periodic processing, reporting financial statements, valuating foreign currency to name a few.

c) CO Module

  1. Cost Center Accounting – Configuration and settings include controlling, cost center, cost elements and overhead orders.
  2. Cost Element Accounting
  3. Product Costing and Activity based costing
  4. Internal Order accounting
  5. Profit Center accounting and Profitability Analysis

d) Additional important topics –

  1. Integration of FICO with other logistics modules like MM, SD and PP
  2. Implementation methodology
  3. Focus on ASAP Methodology and COPA

Revision and Class Performance Analysis

  • Final Lab project to create a .net application to get Hands on practical experience on all of the above
  • Project Presentation by candidates
  • Domain Knowledge
  • Mock Interview practice
  • Resume preparation help

Schedule

Weekend Training schedule: Saturday and Sunday 10:00AM CST – 3:30PM CST
Weekend Training Duration: 4 weeks

Total Hrs of Training: ~60hrs (excluding homework)

NOTE: Take home homework is worth extra 20hrs.

Fee Details

Instructor led classroom training : $2500.00

Live online training : $1500.00

Video based training : $500.00

(Individual, group and corporate discount available.). Please talk to the counselor about discounts.

Payment Methods

  • By Check
  • By Credit Card

Registration

Please complete your personal and credit card (cc) details in the enrollment form to register for the training. Also, this is just a registration process, the actual fee will be charged only after first half day of class.

Although you provide us with the cc details during registration, you can choose to pay by check or cc on the first day of the training.

Email the completed enrollment form to training@instituteusa.com . Please talk to your respective counselor for any questions.

REGISTRATION IS COMPLUSORY. LAST DAY TO REGISTER – 2 BUSINESS DAYS PRIOR TO THE START DATE.

In-Class Training Location:

  • 220, Robert Street S, Suite 100
    Saint Paul, MN 55107

Live Online Training also available.

Training Features

  • Unlimited Training as many times as you want, till your confident enough to face interviews.
  • Complete refund of training fee 2 months after the candidates secures a project while working with us.
  • Course completion certificate will be provided.
  • Free Lab access for 3-4 weeks.
  • Weekday Morning, evening and Weekend training sessions available.
  • New facility with labs and remote access.
  • Just tool access available for 3 months. Call on 651-222-9922 for more information.
  • Free career counseling based on your education and industry experience.
  • Instructor led Training.
  • Lab exercises, assignments, projects for each session.
  • Training available in live online or classroom training.
  • * Instructor support provided after training.
  • Training material constantly updated to remain competitive
  • * On Job and interview support.
  • * Case Studies of our clients in various popular domain – client specific training
  • Industry experienced instructors, to give you Real Time solutions.
  • Full assistance in Placement.
  • * On-going support for at least a year after your training.
  • Lifetime of notes, tools and other necessary material.
Module 9 B: SAP BI

Prerequisite-

Databases and Data warehouse knowledge

Topics to be covered in the SAP Netweaver 7.0 BI (Business Intelligence) training

SAP BI – Introduction to SAP Netweaver 2004s (7.0 BI) system

  1. Overview
  2. BI System upgrade and migration of dataflow from BW 3.x to BI 7.0
  3. Transformation & UoM conversions
  4. Write routines in transformations and debugging routines
  5. DTP & DTP Error handling
  6. Concepts – Bi Integrated planning, BI Accelerator and Analysis Process Designer (APD)

SAP BI – Data Warehousing (DW)

  1. Overview, Positioning & Fundamentals of Data Warehousing
  2. Objects in the BI DW layer
  3. Data Acquisition & Transformation from SAP Source Systems
  4. Data Acquisition from other systems
  5. Business Content
  6. Other Info Providers
  7. Administration of Data Targets
  8. Introduction to Query Performance Optimization

SAP BI – Reporting & Analysit

  1. Introduction to BI Enterprise Reporting
  2. Get to know BEx Query Designer
  3. Key Figures, Characteristics, Variables, Exceptions and Conditions
  4. BEx Analyzer
  5. Enterprise Portal Integration and Document integration
  6. Report-Report-Interface
  7. Managing Query Objects
  8. Business Content
  9. Further SAP BI Reporting Tools
  10. Information Broadcasting

SAP BI – Data Staging & Extraction

  1. Overview of Data Staging in SAP BI-BW Content
  2. Data Transfer with the service API, dB Connect, UDC and Third party ETL Tools
  3. Delta Management
  4. Transferring data from flat files
  5. XML Based extraction
  6. Data Mart Interface
  7. Application Specific Extraction

SAP BI – Modeling & Authorization

  1. Logical Model and BI Data Model
  2. Tracking history and hierarchies
  3. Modeling characteristics and key figures
  4. Modeling ODS/DSO Objects and InfoCubes , Open Hub Service
  5. Multidimensional Modeling
  6. Changing Data model
  7. Special modeling aspects
  8. Authorizations – Setting up for reporting, standard roles and templates
  9. Securing data access for administrative tasks in BI, connected source systems and planning
    environment
  10. Security requirements in SAP BI
  11. System security
  12. BPS Authorizations

SAP BI – Performance & Administration

  1. InfoProvider modeling and administration for performance
  2. Optimize and monitor query performance and data acquisition performance
  3. Aggregates and roll up
  4. Transport Management for BI Objects
  5. Process chains – Development & monitoring

Revision and Class Performance Analysis

  • Final Lab project to create a .net application to get Hands on practical experience on all of the above
  • Project Presentation by candidates
  • Domain Knowledge
  • Mock Interview practice
  • Resume preparation help

Schedule

Weekend Training schedule: Saturday and Sunday 10:00AM CST – 3:30PM CST
Weekend Training Duration: 4  weeks

Total Hrs of Training: ~60hrs (excluding homework)

NOTE: Take home homework is worth extra 20hrs.

Fee Details

Instructor led classroom training : $2500.00

Live online training : $1500.00

Video based training : $500.00

(Individual, group and corporate discount available.). Please talk to the counselor about discounts.

Payment Methods

  • By Check
  • By Credit Card

Registration

Please complete your personal and credit card (cc) details in the enrollment form to register for the training. Also, this is just a registration process, the actual fee will be charged only after first half day of class.

Although you provide us with the cc details during registration, you can choose to pay by check or cc on the first day of the training.

Email the completed enrollment form to training@instituteusa.com .  Please talk to your respective counselor for any questions.

REGISTRATION IS COMPLUSORY. LAST DAY TO REGISTER – 2 BUSINESS DAYS PRIOR TO THE START DATE.

In-Class Training Location:

  • 220, Robert Street S, Suite 100
    Saint Paul, MN 55107

Live Online Training also available.

Training Features

  • Unlimited Training as many times as you want, till your confident enough to face interviews.
  • Complete refund of training fee 2 months after the candidates secures a project while working with us.
  • Course completion certificate will be provided.
  • Free Lab access for 3-4 weeks.
  • Weekday Morning, evening and Weekend training sessions available.
  • New facility with labs and remote access.
  • Just tool access available for 3 months. Call on 651-222-9922 for more information.
  • Free career counseling based on your education and industry experience.
  • Instructor led Training.
  • Lab exercises, assignments, projects for each session.
  • Training available in live online or classroom training.
  • * Instructor support provided after training.
  • Training material constantly updated to remain competitive
  • * On Job and interview support.
  • * Case Studies of our clients in various popular domain – client specific training
  • Industry experienced instructors, to give you Real Time solutions.
  • Full assistance in Placement.
  • * On-going support for at least a year after your training.
  • Lifetime of notes, tools and other necessary material.
Module 10: Business Objects

Prerequisite- None

Detail Course Content

BusinessObjects XI 3.0:
Universe Design

To understand universe design concepts and terminology, as well as the role of universes in relation to Business Objects reporting tools. The course provides an overview of the process for planning, designing, and creating a universe, and walks you through the process of designing a universe that responds to identifying requirements.

  • Understanding Business Objects Universes (Define BusinessObjects universe concepts, Use the Universe Development Cycle)
  • Creating the Course Universe (Describe the course database & universe ,Create the universe)
  • Building the Universe Structure (Populate the universe structure, Define joins in a universe)
  • Creating Dimension Objects (Define and Create classes & objects)
  • Creating Measure Objects (Explain measure object concepts, Create measure objects)
  • Resolving Loops in a Universe (Understand loops, Resolve loops using shortcut joins, using aliases and using contexts)
  • Resolving SQL Traps (Understand SQL traps & universes, Resolve fan traps and chasm traps)
  • Using List of Values (Create a list of values (LOV), Work with LOVs in Designer, Create a cascading LOV)
  • Applying Restrictions on Objects (Restrict the data returned by objects)
  • Using @ Functions with Objects (Use @ Functions)
  • Using Hierarchies (Work with hierarchies)
  • Deriving Tables & Indexes (Use derived tables, Apply index awareness)

Web Intelligence XI 3.0:
Report Design

The Web Intelligence XI 3.0: Report Design course is designed to give learners the comprehensive skills and in-depth knowledge needed to access and analyze information using BusinessObjects InfoView and Web Intelligence. You will learn how to organize, manage, and distribute documents using InfoView. You will also learn how to create Web Intelligence documents for your reporting needs, retrieve data by building queries using BusinessObjects universes, and use Web Intelligence to enhance documents for easier analysis.

  • Understand core concepts of Web Intelligence
  • Create Web Intelligence documents with queries
  • Restrict data returned by a query
  • Design a report
  • Enhance the presentation of data in reports
  • Format a report
  • Calculate data with formulas & variables
  • Use multiple data sources
  • Analyze data
  • Manage & share Web Intelligence documents

Crystal Reports XI:

Gain in-depth knowledge required to plan and create reports that will help them analyze and interpret important information.

  • Fundamentals of Report Design
  • Plan a report, create a report, Select records, Organize data on a report, Format a report, apply section formatting, Create basic formulas, Apply conditional reporting, Present data visually, and distribute a report.
  • Business Reporting Solutions
  • Use the Repository, Create complex formulas, Create Report Templates, Build parameterized reports, Summarize data with Cross-Tabs, Use report sections, Build specialized reports, Share reports on the Web.
  • Report Processing Strategies
  • Describe report processing, Use Sub reports, Create complex formulas, Use Custom Functions

Revision and Class Performance Analysis

  • Domain Knowledge
  • Mock Interview practice
  • Resume preparation help

 

Schedule

Weekend Training schedule: Saturday and Sunday 10:00AM CST – 3:30PM CST
Weekend Training Duration: 3 weeks

Total Hrs of Training: ~40hrs (excluding homework)

NOTE: Take home homework is worth extra 20hrs.

Fee Details

Instructor led classroom training : $1600.00

Live online training : $800.00

Video based training : $500.00

(Individual, group and corporate discount available.). Please talk to the counselor about discounts.

Payment Methods

  • By Check
  • By Credit Card

Registration

Please complete your personal and credit card (cc) details in the enrollment form to register for the training. Also, this is just a registration process, the actual fee will be charged only after first half day of class.

Although you provide us with the cc details during registration, you can choose to pay by check or cc on the first day of the training.

Email the completed enrollment form to training@instituteusa.com . Please talk to your respective counselor for any questions.

REGISTRATION IS COMPLUSORY. LAST DAY TO REGISTER – 2 BUSINESS DAYS PRIOR TO THE START DATE.

In-Class Training Location:

  • 220, Robert Street S, Suite 100
    Saint Paul, MN 55107.

Live Online Training also available.

Training Features

  • Unlimited Training as many times as you want, till your confident enough to face interviews.
  • Complete refund of training fee 2 months after the candidates secures a project while working with us.
  • Course completion certificate will be provided.
  • Free Lab access for 3-4 weeks.
  • Weekday Morning, evening and Weekend training sessions available.
  • New facility with labs and remote access.
  • Just tool access available for 3 months. Call on 651-222-9922 for more information.
  • Free career counseling based on your education and industry experience.
  • Instructor led Training.
  • Lab exercises, assignments, projects for each session.
  • Training available in live online or classroom training.
  • * Instructor support provided after training.
  • Training material constantly updated to remain competitive
  • * On Job and interview support.
  • * Case Studies of our clients in various popular domain – client specific training
  • Industry experienced instructors, to give you Real Time solutions.
  • Full assistance in Placement.
  • * On-going support for at least a year after your training.
  • Lifetime of notes, tools and other necessary material.
Module 11: OBIEE (Siebel Analytics)

Topics to be covered in the OBIEE training include:

a) Introduction to Siebel Analytics & Using Siebel Analytics

b) Siebel Essentials c) Configuration & Scripting d) Analytics Architecture

e) Analytics Reporting

f) Legacy Introduction

g) Database Design

h) Case studies using Siebel Analytics

Advantages with American Institute of Technical Education:

  • Free career counseling based on your education and industry experience.
  • One on One instructor led Training.
  • Unlimited Training as many times as you want, till your confident enough to face Interviews. Instructor support provided during and after training. Training material constantly updated to remain competitive On Job and interview support.
  • Case Studies of our clients in various popular domain – client specific training Sample practice project are given, for a hands-on experience with tools.
  • Industry experienced instructors, to give you Real Time solutions.
  • Full assistance in resume preparation and Placement. On-going support for at least a year after your training.
  • Lifetime of notes, tools and other necessary material. Remote access for the tools available
  • Or go to our website at www.instituteusa.com` Please put your contact detail, location and Training Options (Class room or online) in the mail along with best time to call.

Training Features

  • Free career counseling based on your education and industry experience.
  • Instructor led Training. Lab exercises for each session. Training available live-online or in-class training.
  • Day and evening training sessions available.
  • New facility with labs and remote access 24/7 Instructor support provided after training.
  • Training material constantly updated to remain competitive Unlimited Training as many times as you want, till your confident enough to face interviews. On Job and interview support.
  • Assistance for certification with study material. Case Studies of our clients in various popular domain – client specific training Industry experienced instructors, to give you Real Time solutions.
  • Full assistance in Placement. On-going support for at least a year after your training. Lifetime of notes, tools and other necessary material.
  • Complete refund of training fee 2 months after the candidates secures a project while working with us. 3 months server access provided for SAP FICO and SAP BI.
Contact Us

We're not around right now. But you can send us an email and we'll get back to you, asap.

Not readable? Change text. captcha txt
Show Buttons
Hide Buttons