Friday, May 28, 2010

C# .NET Training

Complete C# starts by teaching students C# syntax and semantics as well as the concepts of Object Oriented Programming (OOP). In the class, students learn classes, enums, structures, delegates, and interfaces (the .NET type system). Students also learn, file Input/Output and metadata. This course also covers ASP.NET, Windows Forms, and ADO.NET.
Learning Objectives : -
During this course, the participant will:
  • Learn Object Oriented Programming with C#
  • Learn to build desktop applications using Windows Forms
  • Learn to interact with relational databases using ADO.NET
  • Learn to build web sites using ASP.NET
  • Learn to build XML web services using the .NET platform

Audience: This class is intended for developers, however no knowledge of C# or .NET is assumed.

The Philosophy of .NET
  • Understand the motivation behind the .NET platform
  • Know the role of the Common Type System (CTS)
  • Know the role of the Common Language Specification (CLS)
  • Know the role of the Common Language Runtime (CLR)
  • Understand the assembly, namespace, type distinction
  • Contrast single-file and multi-file assemblies
  • Know the role of the Common Intermediate Language (CIL)
  • Survey the .NET Namespaces
  • Platform independent .NET (Mono / Portable .NET distributions)
  • Choosing a managed language (C#, VB, MC++)
  • Developing with the C# command line compiler (csc.exe)
  • Developing with Visual Studio 2008

Introducing the C# Programming Language

  • The role of the Main() method
  • Processing command line arguments
  • Defining class types using C#
  • Examine looping and decision constructs
  • Understanding method overloading
  • C# parameter modifiers (out, ref, params)
  • Working with structured exception handling
  • Building custom exception objects

Object Oriented Programming with C#

  • The role of constructors and finalizers
  • Encapsulation and C# property syntax
  • Static fields, members and constructors
  • The const and readonly modifiers
  • Implementation inheritance and virtual members
  • Abstract base classes / abstract members
  • Interface based polymorphism
  • Explicit interface implementation
  • Rules of type casting
  • The role of nested types

Common Language Runtime Fundamentals

  • Understanding value types and reference types
  • The role of System.Object
  • Understanding boxing and unboxing
  • Arrays and the System.Array class
  • Working with textual data
  • The role of System.Enum
  • Building custom namespaces
  • Understanding .NET delegate types
  • The delegate / event relationship

Advanced C# Language Features

  • Designing partial types
  • Static class definitions
  • C# nullable types (and the ? and ?? operators)
  • Delegate Covariance and Contravariance
  • Understanding Anonymous Methods
  • Understanding Method Group Conversion

Working with .NET Generics

  • The motivation behind generics
  • The System.Collections.Generic namespace
  • Building custom generic members
  • Building custom generic types
  • Constraining type parameters

Understanding .NET Assemblies

  • Assembly characteristics
  • Contrasting private and shared assemblies
  • Deploying and configuring private assemblies
  • Cross language inheritance
  • Understanding the role of strong names
  • Deploying and configuring shared assemblies
  • Understand publisher policy assemblies
  • Working with codebase

Desktop Development using Windows Forms

  • The Visual Studio Windows Forms designers
  • Understand the role of the Application class
  • Examine the derivation of the Form class
  • Survey of the Windows Forms control set
  • Handle keyboard events in a desktop application
  • Handle mouse events in a desktop application
  • Graphical rendering using GDI+ (System.Drawing)
  • Construct dialog boxes
  • Understand form inheritance

Reflection and Attribute Based Programming

  • The role of reflection and System.Type
  • Dynamic loading of external assemblies
  • The role of late binding
  • Understanding attribute based programming
  • Building custom attributes
  • Building extendable software


Input, Output and Object Serialization

  • Survey the System.IO namespace
  • Learn to manipulate a directory and file structure
  • Open, read, write and close text files
  • The role of object serialization
  • The BinaryFormatter / SoapFormatter types
  • Data Access with ADO.NET
  • Understand the ADO.NET object model
  • Working with DataReaders
  • Working with Command types
  • Build parameterized queries
  • Invoke stored procedures using ADO.NET
  • Work with DataSets and DataAdapters
  • Understand DataRelation types
  • Work with DataView types
  • Advanced ADO.NET Topics
  • The data provider factory pattern
  • Reading configuration data from App.config
  • Working with connection string builder objects
  • Using DataTables as DataReaders

Web Development with ASP.NET

  • Examine the architecture of an ASP.NET Web Application
  • Survey the ASP.NET namespaces
  • The ASP.NET development server and IIS
  • The single file and code file development models
  • Understand the role of the Page type
  • A survey of ASP.NET Web Controls
  • Interacting with the request / response
  • Working with session and application data

After Complettion of the Course :

  • Interview Guidance Provided
  • Mock Tests Conducted
  • Mock Interviews
  • Resume Preparation as per the standards
  • Guidance for Microsoft Certification Exam

Fees Structure :
Rupees : 14,000/-
Duration : 20 days [40 Hours]

ASP.NET 3.5 Training

Audiences :
This class is intended for .NET developers who understand the basics of Object Oriented Programming (OOP) and a base-level understanding of any version of .NET

Introducing ASP.NET
  • Understand the basic architecture of a Web application
  • Understanding the role of HTTP
  • The difference between HTML and XHTML
  • Learn the key features of ASP.NET 3.5
  • The ASP.NET Namespaces
  • The history of ASP.NET Web development
  • Contrast the use of IIS vs. the Visual Studio 2008 development Web server
  • Work with different versions of IIS
  • Know the differences between a Visual Studio 2008 Web Site and a Web Application project

The Page Class and Other Files

  • Know the three architectures of ASP.NET Web pages
  • Work with members of the Page class
  • The Page class events
  • Explore the single-file and code-behind models
  • The ASP.NET directives (Page, Control, and so on)
  • Investigate the ASP.NET folders
  • The Request and Response objects
  • The IsPostback property
  • Understand the basics of Web.config
  • Perform debugging and tracing
  • Introducing Web Site Administration Tool (WAT)
  • Research the global.asax file
  • Trapping application errors

ASP.NET Controls

  • Understand the ASP.NET Web control event architecture
  • Contrast HTML Server Controls with Web Controls
  • Survey the categories of Web Controls
  • Programming with Web control events
  • Work with ASP.NET Validation Controls
  • Examine the use of HTML tables and CSS Positioning for Web content

Custom Controls

  • Understand the need for custom Web controls
  • Building custom Web controls
  • Using the HTMLTextWriter
  • Adding Style to Custom Controls
  • Integrating custom Web controls with the VS IDE
  • Creating composite custom controls
  • Registering the controls with *.aspx, *.ascx and *.master files
  • Defining properties for the VS Properties window
  • Adding a custom icon for the Toolbox
  • User Controls and Master Pages
  • Understanding and creating user controls
  • Creating composite user controls
  • Manipulating user controls on the host page
  • Exposing events from user controls
  • Host Web pages subscribing the user control events
  • Introducing Master pages
  • A Master page walkthrough
  • Nested Master pages
  • Master page events and page access

Site Navigation

  • Basic page navigation
  • Response.Redirect() and Server.Transfer()
  • Work with the MultiView control
  • Work with the Wizard control
  • Understand the site map model of ASP.NET
  • Examine the Menu navigation control
  • Examine the TreeView navigation control
  • Create Web application breadcrumbs

State Management

  • Define the role of view state
  • Read and write cookies
  • The role of application state and session state
  • Work with The State Services
  • Work with SQL Server session management
  • Study the various forms of caching (the Cache object and OutputCache)
  • Work with Cache dependencies, such as a Sql Server dependency

CSS and Themes

  • Understand Cascading Style Sheets (CSS)
  • Adding a CSS Style sheet
  • CSS and Web controls
  • Learn the style builder tools in Visual Studio
  • Examine the use of themes and skins
  • Dynamically assign themes
  • Adding a skin to a theme
  • Defining a .skin file
  • Using CSS and themes together
  • Adding a stylesheet to a theme

ADO.NET

  • Introducing System.Data.dll
  • The ADO.NET Data Providers
  • The Speedy DataReader
  • Binding DataReaders to Web controls
  • Performing CRUD operations in a connected model
  • Working with Parameters
  • Working with Sql Server Stored Procedures
  • The Disconnected Model
  • Working with the Data Adapter
  • Working with the members of a DataSet
  • Working with a DataView
  • Testing the CommandBuilder
  • Adding Data relationships

Data Binding

  • Understanding ASP.NET Data Binding
  • Data Binding with Array, Collection and Custom Types
  • Look at some new ways to manage Connection Strings in our applications
  • Declarative data binding
  • Expression data binding
  • Data Source Controls
  • The SqlDataSource control
  • The GridView control
  • The Repeater control

Handlers, Modules and IIS

Understand ASP.NET and IIS process management
  • IIS delegation of requests
  • Understand ASP.NET handlers
  • Configuring handlers
  • Creating a custom handler
  • Installing a custom .ashx handler
  • Using as custom file extension
  • Understand ASP.NET modules
  • Configuring modules
  • Creating a custom module
  • Comparing handlers and modules to ISAPI filters and extensions
  • Configuring IIS 5.1, 6, 7
  • Providers

    • Understand the ASP.NET provider model
    • Configuring providers
    • Using aspnet_regsql.exe
    • Explore the membership providers and SqlMembershipProvider
    • Adding new users
    • The MembershipUser type
    • Learn the Role Manager with SqlRoleProvider
    • Store and retrieve user information with the Profile object
    • Personalize a Web site

    Web Parts

    • The role of Web Parts
    • The Web Part Manager
    • The different modes of the WebPartManager
    • Working with Web Part Zones
    • Add Web Parts
    • Web Parts in the Toolbox
    • Using an EditorZone
    • using a CatalogZone
    • Using AJAX with Web Parts

    Security

    • Definition of Web security
    • Understand Web programming best practices
    • Learn ASP.NET forms-based authentication
    • Discover ASP.NET authorization
    • Encrypting sections of Web.config
    • Know ASP.NET security configuration
    • Learn IIS security
    • Work with ASP.NET security controls

    AJAX

    • Know the role of AJAX
    • AJAX in today
    • Understand the role of the XMLHttpRequest object
    • Learn about the ASP.NET Page Script Callbacks
    • Learn the ASP.NET AJAX controls
    • Learn the ASP.NET AJAX controls
    • Build a Web site using the ASP.NET AJAX Control Toolkit

    Deployment

    • Copy, XCopy and RoboCopy a Web Site
    • Pre-compiling a Web site using aspnet_compiler.exe
    • Copying a Web site in Visual Studio
    • Publishing a Web site in Visual Studio
    • Building an ASP.NET Web deployment (*.msi) project

    Silverlight

    • Understand the role of Silverlight
    • Contrast the Silverlight 1.0 and 2.0 feature sets
    • Survey the Silverlight 2.0 architecture
    • Overview key Silverlight 2.0 development tools
    • Learn the core Silverlight assemblies and namespaces
    • Learn the role of the Application and UserControl classes
    • Learn the syntax of XAML

    After Complettion of the Course :

    • Interview Guidance Provided
    • Mock Tests Conducted
    • Mock Interviews
    • Resume Preparation as per the standards
    • Guidance for Microsoft Certification Exam

    Fees Structure :

    Rupees : 16,000/-

    Duration : 22 days [55 hours ]

    Silverlight 3.0 Training in Bangalore

    Silverlight 3.0 is a web-based GUI toolkit based on the WPF programming model. Intertech’s Complete Silverlight 2.0 will examine this new API beginning with the topics of XAML, code files and Silverlight 2.0 development tools. Attendees will learn about the Silverlight 2.0 programming model, control templates, data binding, graphical rendering services, the ASP.NET Silverlight controls and browser interactions.
    Learning Objectives :
    Understand the Silverlight 2.0 programming model and XAML
    Learn to build custom user controls
    Work with data binding
    Work with animation and graphical rendering
    Audience : This class is intended for experienced .NET 2.0 software developers. No knowledge of Silverlight 2.0 is assumed

    1. Introducing Silverlight

    • Silverlight vs. Flash
    • Rich Internet Applications
    • RIA Technologies
    • Silverlight 1.0, 2.0 and 3.0
    • Understanding Silverlight Web Sites
    • Creating a Silverlight Project
    • The Anatomy of a Silverlight Application
    • Creating a Simple Silverlight Page
    • Adding Event Handling Code
    • Browsing the Silverlight Class Libraries
    • Testing a Silverlight Application
    • Creating an ASP.NET Web Site with Silverlight Content

    2. Silverlight Compilation and Deployment

    • Compiling a Silverlight Assembly
    • Deploying a Silverlight Assembly
    • The HTML Entry Page
    • The Application Manifest
    • The XAP

    3. Brief Intro of WPF and Introducing Silverlight XAML

    • Vectors
    • WPF
    • XAML
    • Using Text
    • Using Shapes
    • Paths and Geometries
    • Exporting Clip Art
    • Positioning Elements
    • Using Images
    • Using Brushes
    • Transparency
    • The Layout Containers
    • The Panel Background
    • Borders
    • Simple Layout with the StackPanel
    • The Grid
    • Coordinate-Based Layout with the Canvas
    • The Page
    • Navigation


    4. Introducing Silverlight Tools and Intro to DeepZoom

    • XML Editors
    • Vector Graphics Editors
    • Silverlight IDEs
    • Introduction to DeepZoom
    • Using the DeepZoom Composer
    • Including and Controlling Deepzoom within your Silvelright app

    5. Elements

    • Static Text
    • Content Controls
    • List Controls
    • Text Controls
    • Range-Based Controls
    • Lap around existing controls
    • Creating custom controls


    6. The Application Model

    • Application Events
    • Application Tasks
    • Resources
    • Class Library Assemblies

    7. Handling User Interaction and Events

    • Dependency Properties
    • Routed Events
    • Events and Event Handlers
    • Mouse Events
    • Keyboard Events
      8. Transforming and Animating Content and Adding Sound and Video
    • Transformations
    • Animations
    • Preparing Multimedia Data'
    • MediaElement
      9. Adding Silverlight Content to ASP.NET 3.5 Applications
    • Embedding XAML
    • Embedding Media Content

    10. Accessing Silverlight Content with JavaScript and Special Silverlight JavaScript APIs·

    • Accessing the Plug-in
    • Communicating with the Plug-in
    • Advanced JavaScript APIs
    • Dynamically Downloading Content
    • Using Additional Fonts

    11. Silverlight DataBinding

    • Understanding DataBinding in Silverlight
    • DataBinding Modes
    • DataBinding Syntax
    • DataContext
    • Change Notifcation
    • DataTemplates
    • Isolated Storage

    12. New Features of Silverlight 3

    • 3-D Effects (Perspective Transforms)
    • Bitmap Effects and Pixel Shaders
    • WriteableBitmap
    • Bitmap Caching
    • New Media Supported (Raw Video/Audio and H.264)
    • Changing Styles at Run Time
    • BasedOn Styles
    • Animation Easing Functions
    • FontSource support in Glyphs
    • Out-of-Browser Support
    • Communication Between Local Silverlight-Based Applications
    • Application Library Caching
    • Application Extension Services
    • Data Binding Improvements
    • Browser Zoom Support
    • Navigation
    • Networking

    After Complettion of the Course :

    • Interview Guidance Provided
    • Mock Tests Conducted
    • Mock Interviews
    • Resume Preparation as per the standards
    • Guidance for Microsoft Certification Exam

    Fees Structure :
    Rupees : 17,000/-
    Duration : 3 Weekends [30 hours]

    Windows Azure Training/Cloud Computing Training

    Complete Windows Azure Training/Cloud Computing Training
    This Training Program is an introduction to cloud computing and specifically Microsoft's public cloud offering in Windows Azure. Windows Azure has been described by Microsoft as an operating system for "the cloud". In this class, you explore this new cloud operating system and learn how to write, deploy and monitor .NET applications in Azure.
    Learning Objectives :
    • Understand cloud computing in its various forms and how Windows Azure fits in the cloud computing space
    • Learn why organizations want to run applications in the Azure cloud
    • Understand the architecture of Azure
    • Explore the Azure SDK and DevFabric development environment
    • See how to develop applications for Azure and how that varies from "normal" .NET application development
    • Write and deploy a ASP.NET Web application (Web Role) to Azure
    • Explore Azure storage capability
    • Learn how to create and deploy background computatinal applications (Worker Role) in Azure
      Audiences: This class is designed for .NET developers with Web application experience that are exploring developing new applications or porting existing applications to Windows Azure.
      Cloud Computing
    • IaaS, PaaS, SaaS
    • Private, Public, Hybrid clouds
    • Why cloud computing
    • Where Azure fits in
    • Why Azure
      Azure Introductions
    • Azure Architecture
    • Windows Azure
    • Azure Roles
    • Azure Storage
    • SQL Azure
    • AppFabric
    • Microsoft Data Centers
    • Tools and DevFabric
    • Hello Azure Application
      Azure Web Role
    • Configuration
    • Endpoints
    • Security
    • Logging
    • Load Balancing
      Publishing to the Cloud
    • Developer Portal
    • Hosted Services
    • Storage Accounts
    • Associated Costs
      Azure Storage
    • Local Storage
    • Blobs
    • Tables
    • Queues
    • REST API
      Azure Worker Role
    • Configuration and API
    • Communications
    • Azure Application Architecture
    After Complettion of the Course :
    • Interview Guidance Provided
    • Mock Tests Conducted
    • Mock Interviews
    • Resume Preparation as per the standards
    • Guidance for Microsoft Certification Exam
    Fees Structure :
    Rupees : 17,000/-
    Duration : 3 Weekends [30 hours]

    Tuesday, May 25, 2010

    BizTalk Server 2009 CertificationTraining in Bangalore

    1.BizTalk 2009 Overview

    2.Creating BizTalk Schemas

    • Creating a New BizTalk Project
    • Creating Schemas using the BizTalk Editor
    • Promoting a Schema Property
    • Creating a flat file schema using a The Flat File Schema Wizard
    • Generating an Instance Message and Validating the Schemas
    • Assigning a strong name to the assembly
    • Building the Schema Project

    3 .Creating a Schema Map

    • Creating a Schema Map using the BizTalk Mapper
    • Adding Functoids to a Map
    • Validating and Testing the Map
    • Building the Schema Map Project
    • Developing Custom functoids
    • Using Functoids like Script functoids, Database functoids
    • Developing Schemas for EDI file

    4. Creating an Orchestration

    • Creating an Orchestration
    • Creating and Configuring Ports
    • Building the Orchestration Project
    • Using Different shape in Orchestration like Call Orchestration , Delay
    • Different type of Message
    • Using Muilt part Message
    • Using .Net Class in Orchestration
    • what is Zombie
    • Using Sequential Convey and Parallel Convey

    5 . Deploying a BizTalk Solution

    • Assign and Deploy a BizTalk Assembly to an Application
    • Create a Receive port and Receive Location
    • Import port binding from binding file
    • Configure and Test the BizTalk Application
    • Export the Application to an MSI package
    • Import the application from MSI Package
    • Use the group Hub page for to Fix an Invalid Message

    6 .Working with Flat Files and Pipeline

    • Create a Flat file schema using the flat file schema wizard
    • Create a receive pipeline to disassemble the a message Interchange
    • Enable and test the Pipeline
    • Configure and Test the pipeline for Interchange Processing
    • Configure and test the pipeline for Recoverable Interchange Processing
    • Developing Custom Pipeline

    7. Integrating Business Rules

    • Defining Business Rule
    • Call Business Rule from within Orchestration
    • Building and Deploying the Business Rule Project
    • Starting the Business Rule

    8 . Creating Business Transactions

    • Creating a Transaction
    • Adding Compensation and Handling Exceptions

    9. Consuming and Publishing WCF Service or Web Service

    • Adding a Services Reference to a Project
    • Creating a Map
    • Modifying the Orchestration
    • Building and Deploying the Orchestration
    • ProjectStarting and Testing the Orchestration

    10. Creating a Deployment Package

    • Create a Deployment Project
    • Install the Deployment Package and Test the Solution

    11.Tracking BizTalk Message Activity
    12.Integration with POP3 and SharePoint and Routing Failed Messages
    13.Processing EDI messages with BizTalk Server 2009
    14.Sending EDI Messages with BizTalk Server 2009
    15.Building an RFID application with BizTalk Server 2009
    16 - Performance tuning with BizTalk


    After Complettion of the Course :

    • Interview Guidance Provided
    • Mock Tests Conducted
    • Mock Interviews
    • Resume Preparation as per the standards
    • Guidance for Microsoft Certification Exam


    Fees Structure :

    Rupees : 18,000/-

    Duration : 60 hours




    SharePoint Server 2007 Administration Training for Certification 70-630

    Prerequisites: This course is designed for individuals with a basic understanding knowledge on Net work Administration.

    Module 1 – Introduction on Microsoft office SharePoint Server 2007

    • A Primer on Microsoft office SharePoint Server 2007
    • Shared Service Provider (SSP)
    • SharePoint Products and Technologies
    • Difference between WSS 3.0 & MOSS 2007

    Module 2 – Managing Content with Lists and Libraries

    • Creating Custom Lists and Document Libraries
    • Creating Views based on Creating
    • Site Columns
    • Creating/updating/Propagating
    • Scopes
    • Content types
    • Creating/updating/Propagating
    • Content type Settings
    • Using Look ups and Calculated Columns
    • Working With Libraries

    Module 3 – Configuring User Groups and Permissions

    • Creating Users in Active Directory
    • Creating Mail for the User
    • Configuring out look account settings
    • Configuring out going E-mail settings in SharePoint

    Module 4 – SharePoint Security

    • Permission Levels in SharePoint
    • Creating Custom Permission Levels
    • Creating and Using Alerts.
    • Security at site Level
    • Security at List or Library Level
    • Item Level Security.

    Module 5 – Securing Sites through SSL

    • Requirements for SSL
    • Extending Web Applications for https
    • Implementing SSL on IIS

    Module 6 – Monitoring SharePoint

    • Usage Analysis
    • Diagnostic Logging
    • Performance Monitor

    Module 7 – Configuring the Server

    • Configuring MOSS
    • Configuring WSS 3.0
    • Setting Up Shared Services
    • Enabling Search

    Module 8 – SharePoint Portal operations and Administration

    • Working with managed paths
    • Quota Templates
    • Blocked file types
    • Zones in Web Application
    • Installing/uninstalling Features
    • Activating/Deactivating Features
    • Adding the Solution Package

    Module 9 – Backup and Restore

    • Performing Backup and Restore from Central Administration
    • Back up and Restore from SharePoint Designer
    • Back up and Restore using STSADM
    • Creating Site as Template
    • Creating List as Template

    Module 10 – InfoPath

    • Designing InfoPath forms
    • Publishing InfoPath forms to SharePoint Sites
    • Publishing as Content types.
    • Manage Form Templates(Administrator ApNumbered Listproved InfoPath Forms)
    • Upload or Upgrade a Form Template
    • Activate Form Template
    • Deactivate Form Template

    Module 11- Installing Microsoft Office SharePoint Server 2007

    • Hardware requirements
    • Software requirements
    • Step by step Installation Process

    Module 12 – Workflows and the Recycle bin

    • Introduction On workflows
    • Creating out-of-box workflows
    • Creating workflows using SharePoint Designer
    • Managing the Recycle bin

    Module 13 – Setting Up an Extranet

    • Topology and Requirements
    • Alternate Access Mapping
    • Configuring Forms based Authentication
    • Extending Web Applications

    Module 14 – Authentication

    • Windows Authentication
    • Single sign on
    • Forms based Authentication

    Chapter 15- Business Intelligence

    • Excel Services
    • Key Performance Indicators(KPIS’S)
    • Dash Boards
    • Reports

    Chapter 16- Enterprise Search

    • Configuring Search Settings in SSP
    • Search Scopes
    • People Search
    • All Sites Search
    • Full Crawling
    • Incremental Crawling

    Module 17 – Personalization and My Site

    • Configuring My Site Settings
    • Creating Personal Sites
    • Applying Personal Views to Pages and Lists

    Module 18 – Working with SharePoint Designer

    • Performing Backup and Restore
    • Check in and Check out
    • Adding Web part zones and Web parts

    Module 19 - Web parts

    • Web parts overview
    • Static and Web part pages
    • Adding the web part to the pages
    • Deploying the Web parts

      Note : - We can also provide Training as per the Custom Contents based on the requirements.

    For any Training Queries, feel free to contact : venkat@ 91-9916229967

    After Complettion of the Course :

    • Interview Guidance Provided
    • Mock Tests Conducted
    • Mock Interviews
    • Resume Preparation as per the standards
    • Guidance for Microsoft Certification Exam

    Fees Structure :

    Rupees : 18,000/-

    Duration : 45 hourse

    MSBI Training @Bangalore

    we are providing Complete Hands on training with Examples on SQL Server 2008 Business Intelligence[MSBI]

    Module 1 – Introduction to ETL Techniques using Sql Server Integration Services

    • Reviewing ETL Fundamentals
    • Data Integration
    • Business Scenarios
    • SQL Server 2008 Data Integration
    • Populating Dimension Tables
    • Populating Fact Tables
    • Introducing SSIS Components
    • Architecture
    • The Package
    • Connection Manager
    • Control Flow
    • Containers
    • Tasks
    • Data Flow
    • Data Preparation
    • Process Communication
    • SQL Server
    • Analysis Services
    • Database Maintenance
    • Scripting
    • Precedence constraints
    • Variables

    Module 2 – Developing a Query Driven E-mail Delivery System

    • Data Flow
    • Data Flow Sources
    • Data Flow Destinations
    • Data Flow Transformations
    • Row
    • Rowset
    • Split and Join
    • Business Intelligence (BI)
    • Script
    • Other

    Module 3
    Loading and Integrating Data from Multiple Sources
    Module 4 – Designing ETL Packages

    • Orchestrating the ETL Process
    • Populating Dimension Tables
    • Populating Fact Tables
    • Slowly Changing Dimension Transformation

    Module 5 –Important Features of Sql Server Analysis Services

    • Solving Business Problems with SSAS 2005
    • Introduction to Unified Dimension Model (UDM)
    • Analysis Services components Overview
    • Analysis Services components Demo
    • Defining a data source view within an Analysis Services project by using BI Development Studio.
    • Defining and Deploying a Cube
    • Modifying Measures, Attributes and Hierarchies
    • Named Queries and Named Calculations
    • Storage options with SSAS 2005
    • Defining Advanced Attribute and Dimension Properties
    • Defining Relationships Between Dimensions and Measure Groups
    • Defining Key Performance Indicators (KPIs)
    • Defining Actions
    • Defining Perspectives and Translations
    • Defining Administrative Roles

    Module 6 – SQL Server Reporting Services

    • Introducing Reporting Services
    • Who uses reports and why?
    • Installing reporting services.
    • Designing reports.
    • Reporting Services Architecture
    • Reporting Service lifecycle
    • Reporting Services features – New features in SQL 2005
    • Reporting Services Components
    • Data Processing Extensions
    • Reporting Services Web Services
    • Report Designer
    • Report Services Tools
    • Designing Reports
    • Using the Report Wizard
    • Importing Reports
    • Plan for Extensibility
    • Report Items and Data Regions
    • Subtotals
    • Formatting
    • Pagination Control
    • Printing Considerations
    • Designing Data Access
    • Reporting for Relational Data
    • Query Basics
    • Filtering Techniques
    • Advanced Report Design
    • Designing a tabular report using table.
    • Link and Drill Down/Through Reports.
    • Charting
    • Custom Fields
    • Conditional Expressions
    • Using Custom Code
    • Designing for Mobility

    Module 7 – Managing and Using the Report Manager

    • Viewing Reports
    • Searching and browsing for specific reports
    • Configuring report viewing security
    • Creating schedules and subscriptions
    • Launching Report Builder for ad hoc reports
    • Managing Reports Using Programs
    • Professional SQL Reporting Service Manager
    • Building the Visual Interface
    • Adding a reference to the Web Service
    • Filling the Treeview
    • Credentials
    • Displaying the Folder Contents
    • Adding/Updating Folders
    • Deleting an Item From a Folder
    • Importing Report Definition Files
    • Managing Security
    • Report Scripting
    • Command Line Utilities
    • Automating Server and Report Management
    • Reporting Services RS Utility
    • Script Deployment
    • Building a Script Development Harness
    • Accessing Server Items
    • Retrieving Reports
    • Deploying Reports
    • Logging Events
    • URL Access and Programmatic Rendering
    • Accessing Reporting Services Objects
    • Reporting Services URL Parameters
    • Passing Report Information through the URL
    • Rendering through Windows
    • Rendering to the Web
    • Report Caching and Subscriptions
    • Report Delivery
    • Configuration Credentials for Data Sources
    • Configuring Cached Reports
    • Subscriptions

    Module 8 – Report Definition Language

    • What is RDL?
    • Creating RDL
    • Extending Reporting Services
    • Security Extensions
    • Rendering Extensions
    • Extensible Report Designer Classes
    • Common Extension Interfaces
    • Creating a Custom Data Processing Extension
    • Deployment Strategies
    • Architecture Review
    • Reporting Services Deployment Scenario
    • System Requirements and Prerequisites
    • Installation and Configuration
    • Administrative Issues
    • Approaching Solution Design
    • Define the Business Program
    • Solution Design
    • Transactional and Decision Support Data
    • Business Intelligence Process Lifecycle
    • Architecting BI Solutions
    • Reporting Solution Design
    • Reporting Solution Development Environment

    After Complettion of the Course :

    • Interview Guidance Provided
    • Mock Tests Conducted
    • Mock Interviews
    • Resume Preparation as per the standards
    • Guidance for Microsoft Certification Exam


    Fees Structure :

    Rupees : 18,000/-

    Duration : 15days [40 hours]