WPF Contents

Windows Presentation Foundation Using C# Training

Introduction to WPF

* What Is WPF
* .NET Framework 3.0 (WinFX)
* WPF Overview
* Application and Window
* A Simple WPF Application
* Using Visual Studio
* Brushes
* Panels

XAML

* Role of XAML
* Elements and Attributes
* Namespaces
* Property Elements
* Type Converters
* Content Property
* Collections
* XAML and Procedural Code

WPF Controls

* Button
* Label
* Text Box
* Tool Tip
* Radio Button
* Check Box
* List Box
* Combo Box

Layout

* Positioning
* Transforms
* Canvas
* Drawing Shapes
* StackPanel
* WrapPanel
* DockPanel
* Grid
* Scrolling
* Scaling

Dialogs

* Message Boxes
* Win32 Common Dialogs
* Custom Modal Dialogs
* Custom Modeless Dialogs

Menus and Commands

* Menus
* Context Menus
* Icons on Menu Items
* Commands
* Keyboard Shortcuts
* Disabling Menu Items
* Checking Menu Items

Toolbars and Status bars

* Toolbars
* Toolbars and commands
* Status bars

Dependency Properties and Routed Events

* Dependency Properties

WCF Contents

Windows Communication Foundation Using C# Training

Introduction to WCF

* What is WCF
* Address, Binding and Contract
* WCF Services and Clients
* IIS Hosting
* WCF Architecture

Addresses and Bindings

* Addresses
* Bindings
* Message Exchange Patterns
* Configuring Bindings
* Interoperating with ASMX Web services
* Hosting in a Console Application
* Channel Factories
* Multiple Endpoints

Service Contracts

* Defining Service Contracts
* Defining Operation Contracts
* Services with Multiple Contracts
* Contract Inheritance
* Operation Overloading

Instance Management

* Using Per - Call Services
* Using Per - Session Services
* Using Singleton Services
* Configuring Behaviors

Data Contracts

* Implementing Data Contracts
* Mapping Data Contracts to XSD Schema
* Serialization
* Array and Generic Collections
* Enums
* Versioning Data Contracts

More about Service Contracts

* Versioning Service Contracts
* Implementing Message Exchange Patterns
* Oneway Contracts
* Duplex Contracts
* Asynchronous Proxies

Handling Errors

* Faults and Exceptions
* Generating and Handling Faults
* Fault Contracts
* Faults and Sessions

Sql Server Tuning Contents

SQL Server Performance Tuning



SQL Server Performance Lifecycle Management

Database performance isn’t something to be managed haphazardly, but instead should be approached in a methodical and organized manner. This is precisely what Performance Lifecycle Management or PLM is designed to provide. This course provides an introduction to PLM and covers the basics areas involved in a successful PLM implementation.

How to Accurately Measure SQL Server Database Performance

Determining the overall health of a SQL Server system can be confusing task, but it doesn’t have to be. Accurately measuring database performance can easily be accomplished once you understand the basic components of performance and how they relate to one another. This course takes a brief look at performance modeling and how it can be applied to any SQL Server installation.

Proactive Actions that Ensure Optimized SQL Server Performance

The foundation of SQL Server performance isn’t found in SQL tuning or other such tasks. Instead, it’s established during the initial physical design and performance testing phases of the PLM cycle. This course shows how to create a winning SQL Server database design and discusses how to perform one of the most neglected activities of performance management, which is proactive testing.

Establishing a Smart SQL Server Monitoring Plan

What are the overall goals of a smart SQL Server monitoring plan? Do you know how to accurately use the most important performance analysis methods for SQL Server? This course provides an overview of the building blocks of a solid SQL Server monitoring plan and introduces the key performance analysis methods that every DBA needs to understand and practice.

SQL Server Bottleneck Analysis Part 1 – Diagnosing storage and system problems

Bottleneck analysis is the primary performance analysis method DBAs should use in diagnosing and tuning SQL Server response time problems. This course focuses on how to recognize and correct bottlenecks that occur in the storage and overall SQL Server system layers.

SQL Server Bottleneck Analysis Part 2 – Diagnosing session and O/S issues

If DBAs cannot locate any obvious SQL Server issues at the storage or system layers, the next step is to drill down into session and operating system metrics to determine if any bottlenecks exist in these layers. This course contains information on how to identify and correct bottlenecks with SQL Server processes and the Windows server.

SQL Server Workload Analysis - Unlocking the Who, What, and Why of Performance Problems

After bottleneck analysis, the next most important performance methodology is workload analysis, which focuses on the overall workload generated by system, session, and SQL activity. This course contains details on how to understand the overall workload on a SQL Server and recognize where improvements can be made.

SQL Server Ratio Analysis - Techniques for quickly getting a bird's eye view of performance

Key performance ratios can quickly help a SQL Server DBA understand how well their overall system is performing. This course provides details on what ratios a DBA needs to monitor, along with recommendations for what to do when key performance metrics are out of line.

Using SQL Server History to Prepare for the Future

Many SQL Server DBAs work in a reactive mode, which means they do little to plan for the future needs of the databases they oversee. This course discusses the importance of historical trend analysis, what key metrics should be tracked, and how to use historical data to forecast future needs.

SQL Server Tuning that makes a difference

Many SQL Server DBAs spend time tuning things that make little or no impact in overall performance. This course focuses on what to pay attention to and how to form an overall PLM tuning plan that can be effectively used in large SQL Server installations to dramatically increase performance.

ASP.Net AJAX Contents

ASP.NET AJAX

Rich Internet Applications and AJAX

* Desktop Applications
* Web Applications
* Rich Client Applications
* Using Plug-Ins
* Using JavaScript
* Asynchronous Communication
* AJAX
* Microsoft's AJAX Technologies
* A Simple AJAX Application

Using JavaScript

* JavaScript and the Browser
* Data Types and Variables
* Control Structures
* Functions
* Strings
* Arrays
* Objects

DHTML, DOM and CSS

* What Is DHTML
* Document Object Model
* Accessing DOM Nodes
* Manipulating DOM Nodes
* DOM Events
* Cascading Style Sheets

ASP.NET AJAX Client Library

* Components of Microsoft's AJAX Support
* ScriptManager
* Client-Side Page Lifecycle
* Debugging Support
* JavaScript Extensions
* Object-Oriented Programming Support
* Global API Shortcuts
* Embedded JavaScript Resources

Partial Page Rendering

* UpdatePanel Control
* Update Modes
* Triggers
* Using a Timer
* PageRequestManager
* Partial Page Update Lifecycle
* UpdateProgress Control
* Limitations and Performance Issues

Remote Method Calls

* Web Service Methods
* Handling Errors
* Using Context
* Page Methods
* JSON Serialization
* ScriptMethod Attribute

AJAX Control Toolkit

* Using ACT Controls in Visual Studio
* Extender Controls
* Use of Style Sheets
* Page Layout Controls
* Popup Controls
* ACT Controls and Web Services

Application Services

* Profile Service
* Authentication Service

BiZtalk Server Contents

BizTalk Server 2006

Module 1: Introduction to BizTalk Server 2006

This module describes the BizTalk message processing architecture and identifies the new features and toolsets provided in BizTalk Server 2006.

* What is BizTalk Server 2006
* What is New in BizTalk Server 2006
* The BizTalk Server Development Environment
* Lab: Examining a BizTalk Application

After completing this module, students will be able to:

* Describe common BizTalk Server 2006 scenarios and how BizTalk Server 2006 works to process messages
* Describe improvements and new features in BizTalk Server 2006
* Identify the tools provided in the BizTalk Server 2006 development environment

Module 2: Creating Schemas

This module explains how to use BizTalk development tools to create XML and flat-file schemas.

* Introduction to BizTalk Schemas
* Creating XML and Flat-File Schemas
* Lab: Creating BizTalk Schemas

After completing this module, students will be able to:

* Describe how BizTalk uses XML and identify the types of XML message types supported by BizTalk
* Create an XML schema by using the BizTalk Editor and create a flat-file schema by using the Flat-File Schema Wizard

Module 3: Creating Maps

This module explains how to use BizTalk Mapper to create and work with BizTalk maps. Students will learn how to add functoids to a map and how to compile and test a map.

* Creating a BizTalk Map
* Configuring Basic Functoids
* Configuring Advanced Functoids
* Lab: Creating a BizTalk Map

After completing this module, students will be able to:

* Describe how maps are used by BizTalk and how to use the BizTalk Mapper to create a map.
* Manipulate data by using functoids and add functoids to a map
* Perform advanced mapping operations by using advanced functoids

Module 4: Deploying a BizTalk Project

This module explains how to deploy a BizTalk project and how to view deployed assemblies.

* Introduction to Deployment
* Deploying an Assembly
* Lab: Deploying an Assembly
* After completing this module, students will be able to:
* Explain how BizTalk deployment works and describe the steps required to deploy a BizTalk assembly
* Deploy an assembly by using Visual Studio and view deployed assemblies by using the Assembly viewer

Module 5: Routing BizTalk Messages

This module explains how to enable message routing and how to use BizTalk tools to monitor live and archived message activity.

* Introduction to Message Routing
* Configuring Message Routing
* Tracking Message Activity
* Lab: Enabling Message Routing

After completing this module, students will be able to:

* Describe how BizTalk messages are routed by various BizTalk components
* Configure BizTalk message routing

Module 6: Creating Pipelines

This module explains how to create and configure receive and send pipelines for processing messages.

* Introduction to Pipelines
* Building a Pipeline
* Lab: Creating Pipelines

After completing this module, students will be able to:

* Explain how pipelines process messages
* Use the Pipeline Designer to create a pipeline

Module 7: Integrating with Adapters

This module explains how to configure common adapters to enable BizTalk integration.

* Introduction to BizTalk Adapters
* Configuring a BizTalk Adapter
* Lab: Integrating with Adapters

Module 8: Creating a BizTalk Orchestration

This module explains how BizTalk orchestration services work and shows how to create a BizTalk orchestration. Students will also learn how to use debugging tools to monitor a running orchestration.

* Introduction to BizTalk Orchestration
* Building an Orchestration
* Monitoring Orchestrations
* Lab: Creating a BizTalk Orchestration

After completing this module, students will be able to:

* Explain how BizTalk orchestrations are used to represent a business process
* Use the BizTalk Orchestration Designer to define a business process

Module 9: Automating Business Processes

This module explains how to use orchestration shapes to represent the logical flow of an orchestration. Students will also learn how to manipulate data and manage exceptions within an orchestration.

* Controlling the Flow of an Orchestration
* Configuring Orchestrations
* Lab: Automating a Business Process

After completing this module, students will be able to:

* Use orchestration flow control shapes and create modular orchestrations
* Configure orchestration expressions, message correlation, and exception handling

Module 10: Creating Transactional Business Processes

This module explains how to create orchestrations that support atomic and long-running transactions. Students will also learn how to create nested orchestrations, configure exception handling, and recover from failed transactions.

* Introduction to Transactions
* Configuring Transactions
* Lab: Configuring a Transactional Business Process

After completing this module, students will be able to:

* Explain how transactions work and how persistence points affect the performance of a BizTalk orchestration
* Create and configure long-running and atomic transactions

Module 11: Deploying and Managing BizTalk Applications

This module explains how to create and deploy BizTalk applications in a production environment. Students will also learn how to manage running applications.

* Introduction to BizTalk Applications
* Deploying an Application
* Lab: Deploying a BizTalk Application

After completing this module, students will be able to:

* Explain how BizTalk artifacts can be grouped as applications to simplify deployment and management tasks
* Deploy an application as a Microsoft Installer (MSI) package and create and import binding files

Module 12: Integrating with Web Services

This module explains how to consume a Web service from an orchestration and how to publish an orchestration as a Web service.

* Introduction to Web Services Integration
* Consuming a Web Service
* Publishing an Orchestration As a Web Service
* Lab: Consuming and Publishing Web Services with BizTalk

After completing this module, students will be able to:

* Explain how Web service integration works in BizTalk
* Configure an orchestration to consume a Web service
* Publish an orchestration as a Web service

Module 13: Integrating Business Rules

This module explains how to configure business rules and how to call a business rule from within an orchestration.

* Introduction to Business Rules
* Integrating Business Rules
* Lab: Integrating Business Rules

After completing this module, students will be able to:

* Explain how business rule integration works in BizTalk
* Compose, publish, and deploy business rules

Module 14: Monitoring Business Activity

This module explains how to configure business rules and how to call a business rule from within an orchestration.

* Introduction to Business Activity Monitoring
* Enabling Business Activity Monitoring
* Lab: Monitoring Business Activity

After completing this module, students will be able to:

* Explain how BizTalk enables business users to monitor business activity
* Configure BizTalk to enable Business Activity Monitoring (BAM)

Module 15: Integrating with Trading Partners

This module explains how to track and manage rules, policies, agreements, and other information about trading partners.

* Enabling Trading Partner Integration
* Lab 15: Enabling Business Partner Integration

After completing this module, students will be able to:

* Explain how BizTalk supports trading partner integration and identify methods for integrating trading partners
* Manage trading partner information and configure an orchestration to integrate trading partners into an existing business process

MSBI Contents

MSBI

SSIS Objectives

* Plan data transfer and staging solutions for an ETL operation
* Plan an SSIS Solution
* Design and implement data flows
* Incorporate logging, error handling and reliability into a package
* Optimize an SSIS Solution
* Deploy an SSIS Solution

Contents:

Planning for ETL

* Identifying Data Sources and Destinations
* Evaluating Source Data
* Identifying Staging Requirements
* Lab: Planning an ETL Solution

Planning an SSIS Solution

* Planning Packages
* Planning Package Development
* Designing Package Control Flow
* Lab: Implementing SSIS Packages

Designing Data Flow

* Understanding Data Flow
* Designing Data Flow Operations
* Handling Data Changes
* Lab: Implementing Data Flow

Logging, Error Handling and Reliability

* Logging ETL Operations
* Handling Errors in SSIS
* Implementing Reliable ETL Processes with SSIS
* Lab: Implementing Reliable Packages

Optimizing an SSIS Solution

* Monitoring SSIS Performance
* Optimizing SSIS Packages
* Scaling Out SSIS Packages
* Lab: Optimizing Packages

Deploying and Operating an SSIS Solution

* Deploying SSIS Packages
* Operating an SSIS Solution
* Lab: Optimizing Packages

SSAS Objectives:

* Describe how SQL Server Analysis Services can be used to implement Analytical solutions
* Create multidimensional analysis solutions with SQL Server Analysis Services
* Implement dimensions in an Analysis Services solution
* Implement measures and measure groups in an Analysis Services solution
* Query a multidimensional Analysis Services solution
* Customize an Analysis Services cube
* Deploy and secure an Analysis Services database
* Maintain a multidimensional Analysis Services solution
* Implement Data Mining solution

Contents:

Introduction to Microsoft SQL Server 2005 Analysis Services

* Overview of Data Analysis Solutions
* Over of SQL Server 2005 Analysis Services
* Installing SQL Server 2005 Analysis Services

Creating Multidimensional Analysis Solution

* Developing Analysis Services Solutions
* Data Sources and Data Source Views
* Creating a Cube
* Lab: Creating a Multidimensional Analysis Solution

Working with Dimensions

* Configuring Dimensions
* Defining Hierarchies
* Sorting and Grouping Attributes
* Lab: Defining Dimensions

Working with Measures and Measure Groups

* Working with Measures
* Working with Measure Groups
* Lab: Configuring Measures and Measure Groups

Querying Multidimensional Analysis Solutions

* MDX Fundamentals
* Adding Calculations to a Cube
* Lab: Querying a Cube

Customizing Cube Functionality

* Implementing Key Performance Indicators
* Implementing Actions
* Implementing Perspectives
* Implementing Translations
* Lab: Customizing a Cube

Deploying and Securing an Analysis Services Database

* Deploying an Analysis Services Database
* Securing an Analysis Services Database
* Lab: Deploying and Securing an Analysis Services Database

Maintaining a Multidimensional Solution

* Configuring Processing Settings
* Logging, Monitoring and Optimizing an Analysis Services Solution
* Backing Up and Restoring an Analysis Services Database
* Lab: Maintaining an Analysis Services Database

Introduction to Data Mining

* Overview of Data Mining
* Creating a Data Mining Solution
* Validating Data Mining Models
* Lab: Implementing Data Mining

SSRS Objectives

* Describe SQL Server Reporting Services and its components
* Create a Reporting Services report
* Enhance a Reporting Services report
* Create and implement data sets
* Use report models to implement reporting for business users
* Configure report publishing and execution settings
* Implement subscriptions for reports
* Implement custom Reporting Services applications

Contents:

Introduction to Microsoft SQL Server Reporting Services

* Overview of SQL Server Reporting Services
* Reporting Services Tools
* Lab: Using Reporting Services Tools

Authoring Basic Reports

* Creating a Basic table Report
* Formatting Report Pages
* Calculating Values
* Lab: Creating a Simple Report

Enhancing Basic Reports

* Interactive Navigation
* Displaying Data
* Lab: Enhancing a Report

Manipulating Data Sets

* Defining Report Data
* Using Parameters and Filters
* Using Parameter Lists
* Manipulating Data Sets

Publishing and Executing Reports

* Executing Reports
* Creating Cached Instances
* Creating Snapshots and Report History
* Lab: Publishing and Executing Reports

Using Subscriptions to Distribute Reports

* Introduction to Report Subscriptions
* Creating Report Subscriptions
* Managing Report Subscriptions
* Lab: Implementing Subscriptions

Advanced.Net Contents

Advanced .Net

Intermediate Language Internals

CLR Internals

* The Structure of a Managed Executable File
* Metadata Tables Organization
* Modules and Assemblies
* Namespaces and Classes
* Primitive Types and Signatures
* Fields and Data Constants
* Generic Types
* Generic Methods
* IL Instructions
* Managed Exception Handling
* Events and Properties
* Custom Attributes
* Security Attributes
* Managed and Unmanaged Code Interoperation
* Multilanguage Projects

Garbage Collection

Assemblies

Performance

Threading

* Process and thread basics
* .NET from a threading perspective
* Multithreading in .NET
* Thread life cycle
* Controlling threads
* Communicating with threads
* Concurrency control
* WaitHandle classes
* Reader/Writer lock
* The ThreadPool class
* ThreadStatic and thread local storage
* Delegates
* Exceptions
* Timers
* Windows Forms and multiple threads
* Unmanaged code and managed threads
* Designing with threads

Management Instrumentation

Code Access Security

Cryptography

Dynamic code generation

* Flexible Programming
* Examining Assemblies, Objects, and Types
* Using Objects
* Creating Objects

Advanced Remoting

* NET Remoting Basics
* NET Remoting in Action
* Configuration and Deployment
* Securing NET Remoting
* Creating Remoting Clients
* In-Depth NET Remoting
* The Ins and Outs of Versioning
* NET Remoting Tips and Best Practices
* Troubleshooting NET Remoting
* Inside the Framework
* Creation of Sinks
* Extending NET Remoting
* Developing a Transport Channel

Advanced Web Services

LINQ

Generics

* Why Generics
* Terminology
* Valuing Type Safety
* Generics vs Templates
* Generic Classes
* Generic Methods
* Generic Delegates
* Generic Constraints
* BCL Generics
* Reflection, Serialization, and Remoting
* Generics Guidelines
* Under the Hood

Serviced Components

HTTP Handlers, Modules

Using Rich Web Controls and Debugging Applications

* Describe and use AdRotator control properties and events
* Describe and use Calendar control properties and events
* Use the Xml Web Server control
* Implement page-level and application-level tracing
* Display and log error messages
* Attach the debugger to an application at runtime

Data Binding and Working with Control Templates

* Explain the function of data binding
* Bind page and control properties
* Describe various binding methods and expressions
* Bind to an ArrayList, HashTable, and DataView
* Create Web Server control templates
* Use templates with various controls

Creating Mobile Applications and Using ADO.NET

* Explain what the Wireless Application Protocol is and how it\\\'s used
* Describe the Mobile Internet Toolkit
* Create a mobile Web application project
* Use validation and list controls in a mobile Web application project
* Describe the ADO.NET Object Model
* Create a Data Aware application
* Connection an application with a SQL Server database
* Access and manipulate the data, and display the results

Working with XML, Configuration, and HTTP Handlers

* Describe XML and the Document Type Definition
* Explain namespaces and schemas
* Convert data to XML
* Bind data with XML documents
* Describe the ASP.NET configuration system
* Explain the various configuration settings in ASP.NET
* Describe HTTP handlers
* Create HTTP handlers

Caching, Security, and Migration

* Explain how caching functions in Visual Studio .NET
* Implement various types of caching
* Describe how dependency impacts caching
* Describe IIS and ASP.NET security mechanisms
* Implement Forms and Windows authentication in an ASP.NET application
* Retrieve and validate user information from an ASP.NET application
* Migrate from ASP to ASP.NET, optimizing your Web site during the migration

Working with Web Services

* Describe various Web service templates
* Create a Web service and add functionality to it
* Finalize a Web service project
* Create a Web service client project
* Add Web references and implement Web methods to a Web service client project
* Restrict access, and grant access to IP addresses, for a Web service client project
* Manage the Web Service directory

Deploying Applications

* Create a Windows deployment project
* Add files, icons, screens, and an installer bootstrapper to a deployment project
* Test a Windows deployment project
* Create a Web deployment project
* Test an installation
* Configure merge module projects and CAB files