Training

Courses - Overview

Advaitaa provides affordable, flexible Information Technology training programs designed to help your current career and provide foundation for new career paths.

Our training solution features hands-on instructor led instruction from industry professionals, online practical lab exercises and much more. We provide the highest quality and most practical education consistent with our instructors' extensive experience in the subject.

 Superior Instructors with over 15 years of experience

 High Quality, Extensive and Industry Standard Curriculum

 Online access to course material

 State-of-the-Art Classrooms with timely access to Lab Facilities

 Resume Preparation and Job Placement Service

Advaitaa's powerful career placement team (info@advaitaa.com subject as Resume) will help you get the job or career advancement you want

You will learn from the best!!

Microsoft - BI Bootcamp

This 4 day, instructor-led training course provides students with the knowledge and skills necessary to begin designing and developing Business Intelligence solutions using Microsoft BI Stack The bootcamp will empower developers to exploit the BI functionality in the following technologies:

 SQL Server 2005 Database Services
 SQL Server 2005 Integration Services
 SQL Server 2005 Reporting Services
 SQL Server 2005 Analysis Services (OLAP)

Course Pre-requisites

Basic understanding of SQL and relational database technology

Course Objectives
Through interactive presentations and concrete hands-on labs, attendees will learn:

 How to use Microsoft SQL Server 2005 to build and manage data marts.
 How to build data warehouse using SQL Server 2005 Integration Services to extract, transform, and load information into SQL Server 2005 databases.
 How to use SQL Server 2005 Reporting Services to develop predefined and ad hoc relational reports.
 How to use SQL Server 2005 Analysis Services to create a dimensional model that provides business analytics.

Course Topics

Day 1

Module 1 - Microsoft BI Strategy Overview
 Defining Business Intelligence (BI)
 Introducing the Microsoft BI Platform
 Introducing the BI Developer’s Toolset
 Introducing SampleData Company

Module 2 - Introduction to Dimensional Modeling Techniques
 Designing the Dimensional Model
 Introducing Additional Design Concepts
 Lab 02A - Database Modeling

Module 3 - Introduction to ETL Techniques Using SSIS
 Reviewing ETL Fundamentals
 Introducing SSIS Components
 Designing ETL Packages
 Lab 03A - Control Flow
 Lab 03B - Data Flow

Day 2

Module 4 - Advanced SSIS
 Advanced Data Flow
 Manageability Features
 Programmability
 Lab 04A - Slowly Changing Dimensions

Module 5 - Introduction to SSRS
 Reporting Fundamentals
 Introducing Reporting Services (SSRS)
 Basic SSRS Report Design
 Lab 05A - Creating Managed Reports

Module 6 - Advanced SSRS
 Introducing Report Interactivity
 Extending Reports with Custom Logic
 Optimizing Report Execution
 Managing the Report Server with Utilities
 Lab 06A - Advanced Managed Reports
 Lab 06B - Advanced SSRS Features

Courses - PMP

Project Management Professional Certification (PMP)

This 40 hour class, instructor-led PMP training course provides students with the knowledge and skills necessary to prepare for the Project Management Professional (PMP) certification exam. You will learn essential skills and knowledge needed to pass the PMP® exam, while also working with real world scenario based questions. The course is based on the PMBOK® 3rd Edition published by the Project Management Institute (PMI®).

Course Topics

Day 1 - Introduction
  Course Objectives
  What will you learn?
  Why Project Management?
  PMBoK
  PM framework
  Phases and Life Cycle
  Stakeholders and Organization
  Project Management Processes
  PM General Skills
  PMP EXAM TIPS

Day 1 - Integration Management
  Project Plan Development
  Project Plan Execution
  Integrated Change Control

Day 2 - Scope Management
  Project Initiation
  Scope planning
  Scope Definition
  Scope Verification
  Scope Change Control

Day 2 - Time Management
  Activity Definition
  Activity Sequencing
  Activity Duration Estimating
  Schedule Development
  Schedule Control

Day 2 - Cost Management
  Cost Estimating
  Resource Planning
  Cost Budgeting
  Cost Control
  Other cost concepts

Day 3 - Quality Management
  Quality Planning
  Quality Assurance
  Quality Control

Day 3 - Human Resource Management
  Organizational Planning
  Staff Acquisition
  Team Development
  Conflict resolution and techniques
  Leadership skills & styles
  PM Roles, Authority and Powers

Day 3 - Communication Management
  Communication Planning
  Information Distribution
  Administrative Closure
  Performance Reporting

Day 4 - Risk Management
  Risk Management Planning
  Risk Identification
  Qualitative Risk Analysis
  Quantitative Risk Analysis
  Risk Response Planning
  Risk Response and Control

Day 4 - Procurement Management
  Procurement Planning
  Solicitation Planning
  Solicitation
  Source Selection
  Contract Administration
  Contract Closeout

Day 4 - Professional Responsibility
  What a PM should do?
  What a PM should not do?

Courses - Microsoft SharePoint

Microsoft- SQL Server 2005

Course Prerequisite:

T-SQL
Basic Programming

Course Topic :SQL Server 2005

  New features of SQL Server 2005
  SQL Server Management Studio
  Support Online Index Operations
  Schedule Administrative Tasks
  Performance Tuning
  Locking and Blocking Issues
  Implement Snapshot Isolation and Data Partitioning
  Perform Mirrored Backups and Online Restores
  Identify Replication Enhancements
  Implement Database Mirroring
  Utilize the New Security model
  Use the New Version of Data Transformation Services (DTS)
  Implement Native Data Encryption
  Set Up and Use Reporting Services

An Overview of SQL Server 2005 New Features Database Roles Client Tools	Installing SQL Server 2005 Preparing For Installation Setup User Interface Installing Express Edition Configuring an New Instance
SQL Server Database Engine Managing Services Managing Servers Database Projects Database Objects	SQL Server Integration Services (SSIS) What Happened To DTS? What is ETL? Integration Services Projects SSIS Objects Expressions
SQL Server Analysis Services (SSAS) OLAP vs. OLTP Data Warehousing Data Mining Architecture Analysis Services Projects Analysis Services Scripting Language (ASSL) XML for Analysis (XMLA) Predictive Mining Model Language (PMML) Data Mining Extensions (DMX) Multidimensional Expression Language (MDX)	SQL Server Replication Overview Replication Types Agents Implementing Administering Enhancements
SQL Server Reporting Services (SSRS) Overview Creating, Managing, and Delivering Administering	SQL Server Full-Text Search (SSFTS) Overview Architecture Writing Queries Administering
SQL Server Notification Services (SSNS) Overview Subscription Management Event Collection Subscription Processing Formatting and Delivery	SQL Server Service Broker Overview Conversations Message Ordering and Coordination Transactional Asynchronous Programming Loosely Coupled Applications Components Administering
Security Overview Catalog Views Security Functions Cryptographic Functions CLR Integration Native XML Web Services Integration Services Analysis Services Replication Reports Notifications Service Broker	International Databases Unicode Data Date and Time Issues Collations International SQL Integration Services Analysis Services Reports Notifications Service Broker Full-Text Searches
Working with XML Data Type Indexes Schema Collections For XML OpenXML Native XML Web Services	Data Availability Disaster Recovery High Availability Backup Restore
Monitoring & Performance Windows Performance Monitor SQL Server Profiler Database Engine Tuning Advisor (DTA) Federated Database Servers Partitioned Tables Partitioned Indexes Query Performance Issues Transactions and Locks Best Practices for Native XML Web Services	Programming SQL Server 2005 Transact-SQL CLR Integration Overview Stored Procedures User-Defined Functions User-Defined Types DML Triggers DDL Triggers SQL Management Objects (SMO) Integration Services Replication Management Objects (RMO) Reports Notifications

Courses - BI (Data warehousing)

Introduction of Data warehousing
  What is it? How is it different from OLTP
  Components of DW
  Schemas and storage mechanisms of OLAP

Data Modeling
  How to model OLTP and OLAP
  ERWIN data modeling tool

Informatica
  Introduction to Informatica servers and components
  Informatica installation and administration Creating different transformations

DTS
  Introduction to SQL Server (Query Analyzer, Enterprise Management console)
  Creating simple transformations ( from source to target)
  Transformation using ActiveX
  Workflow modeling
  Scheduling

Analysis Services
  Creating Star Schema and Snow flake schema
  MOLAP, ROLAP and HOLAP
  Data Slicing and dicing
  Retrieve data from the cube
  Introduction to MS Reporting Services

Business Objects
  Crystal Reports
  Creating different types of reports using crystal
  Advanced logic in reports
  Sub reports and OLAP reporting using Crystal

Crystal Enterprise
  Setting up the Crystal
  Enterprise Setting up permissions
  Hosting reports in Crystal Enterprise
  Using Collaboration functionality to share documents between users.

Business objects
  Connecting to data base
  Modeling the data
  Creating reports
  Publishing reports

Cognos:
  Cognos Transformer
  ReportNet

5

6