Microsoft Technologies

AJAX

Beginning Ajax

  • Creating a request object
  • Requesting the data
  • Asynchronous data transfer
  • Using the readyState property
  • Using a callback function
  • Using innerHTML
  • Sending the request
  • Error handling with try/catch
  • Understanding HTTP

Using XML and JSON in Ajax applications

  • XML basics
  • XML and the DOM
  • Using responseText
  • Using responseXML
  • JSON vs XML
  • JSON basics
  • Using JavaScript literals
  • Using CSS with Ajax

Object-oriented JavaScript and custom Ajax objects

  • The new operator
  • Object constructors
  • Prototypes
  • Using custom Ajax objects
  • Ajax and forms
  • Encoding

Troubleshooting and Debugging Ajax

  • The onerror event handler
  • Debugging Ajax with Firebug
  • Tools for navigating the DOM
    • The Firefox DOM Inspector
    • The IE DOM Inspector
    • The Mouseover DOM Inspector (MODI)
  • Live HTTP Headers
  • HTTP Status Codes

Using JavaScript libraries and Creating a widget

  • Using JavaScript libraries/frameworks
  • Three types of libraries/frameworks:
    • DOM extension
    • Application conveniences
    • Widgets
  • The Prototype JavaScript Framework
    • Using Prototype's Ajax Object
  • Using an accordion widget to display an Ajax response

Working with XML feeds and Providing feedback to the user

  • Working with XML News Feeds
    • RSS .9x
    • RSS 2.0
    • RSS 1.0
    • Atom
  • Using the Scriptaculous library for visual effects
  • The yellow fade technique
  • Drag and drop functionality
  • Ajax best practices

 

BizTalk server

Introduction to BizTalk Server 2006

  • What is BizTalk Server 2006?
  • What's New in BizTalk Server 2006?
  • The BizTalk Server Development Environment

Creating Schemas

  • Introduction to BizTalk Schemas
  • Creating XML and Flat-File Schemas

Creating Maps

  • Creating a BizTalk Map
  • Configuriing Basic Functoids
  • Configuring Advanced Functoids

Deploying a BizTalk Project

  • Introduction to Deployment
  • Deploying an Assembly

Routing BizTalk Messages

  • Introduction to Message Routing
  • Configuring Message Routing
  • Tracking Message Activity

Creating Pipelines

  • Introduction to Pipelines
  • Building a Pipeline

Integrating with Adapters

  • Introduction to BizTalk Adapters
  • Configuring a BizTalk Adapter

Creating a BizTalk Orchestration

  • Introduction to BizTalk Orchestration
  • Building an Orchestration
  • Monitoring Orchestratons

Automating Business Processes

  • Controlling the Flow of an Orchestration
  • Configuring Orchestrations

Creating Transactional Business Processes

  • Introduction to Transactions
  • Configuring Transactions

Deploying and Managing BizTalk Applications

  • Introduction to BizTalk Applications
  • Deploying an Application

Integrating with Web Services

  • Introduction to Web Services Integration
  • Consuming a Web Service
  • Publishing an Orchestration as a Web Service

Integrating Business Rules

  • Introduction to Business Rules
  • Integrating Business Rules

Monitoring Business Activity

  • Introduction to Business Activity Monitoring
  • Enabling Business Activity Monitoring

Integrating with Trading Partners

  • Introduction to Trading Partner Integration
  • Enabling Trading Partner Integration

 

Cloud Computing for .NET Developers

1. Windows Azure platform Overview & Architecture
The Windows Azure platform is Microsoft's holistic cloud computing offering for developers. It is a multi-layered architecture for running applications and services in and via Microsoft-hosted data centers and leverages the power of the cloud. In this module we will look at the different pieces of the Windows Azure platform, how they are layered on top of each other and how they are supposed to work together hand in hand.

Windows Azure Compute
Windows Azure represents the family of Platform-as-a-Service (PaaS) cloud computing. Based on the PaaS idea Windows Azure Compute provides an abstraction layer on top of the underlying hardware and base OS. In this module you will learn about the underlying concepts like the service model, the fabric controller and the idea of roles and instances. In addition, you will see Web Role, Worker Role and the VM role in action and learn about when to use what.

Windows Azure Storage
Running applications in a hosted infrastructure presents its own challenges. Windows Azure's approach is not to provide a dedicated machine but rather to provide services that your application consumes. This means that your application can make no assumptions about the machine on which it executes which presents an issue with where do you store state. Windows Azure storage services provide storage for blobs, structured data and queues. In this module we will look at how these work and how you use them from your applications (whether in the cloud or running on-premise).

2. Windows Azure Deployment, Management & Troubleshooting
An important part of every application's life cycle is how to deploy and maintain the system's pieces. This module discusses the possibilities Windows Azure offers for application and service deployment and versioning while keeping a maximum uptime. Furthermore, you will learn what ways are available for troubleshooting and managing Azure applications once running in the cloud, far away from where you are sitting.

SQL Azure
Besides having a name-value-pair-based data storage in Windows Azure, a number of applications still want their good old relational data model, but now being hosted in the Cloud. SQL Azure is a cloud-based relational database service built on SQL Server technologies. This module covers the basic architecture of SQL Azure, how to deploy your existing databases and demonstrates how to write code to access SQL Azure.

Claims-based Identity & Federation for Windows Azure Applications
Leveraging the power of claims, you can start federating your cloud services with on-premise identity stores. This allows your customers and partners to reuse their existing accounts in the cloud as well as provide single sign-on between various cloud services and on-premise applications. Security token services play a central part in making this happen. Microsoft provides a ready to use token service for Active Directory networks called ADFS 2. Furthermore, WIF includes all the functionality needed to write your own STS. This module gives guidance when to use which approach and shows some of the security scenarios you can accomplish using federation and single sign-on in Windows Azure.

3. Windows Azure AppFabric Access Control
Even with the power of claims and federation, it is still not trivial to add support for multiple federation protocols or identity providers right into the application. This is typically the task of a so called federation gateway, and the Access Control Service is such a "gateway as a service". It enables easy integration into WS-Trust, WS-Federation, OpenID and OAuth world of protocols and features a simple claims transformation engine for creating the claims and token types for your applications.

Windows Azure AppFabric Caching
Caching is known as a well understood architectural pattern to increase the overall throughput and reduce latency in distributed applications. The Windows Azure AppFabric Caching service accelerates application performance by providing a distributed, in-memory application cache requiring no installation, configuration, or management in the cloud. In this module you will learn the functionality of the Caching service and see its benefits in action.

Windows Azure AppFabric Service Bus
Complex messaging scenarios require infrastructure support. The AppFabric provides a component called the Service Bus that is designed to be a cloud-based rendezvous point that supports message exchange patterns that are not supported by WCF out of the box - for example publish/subscribe. The Service Bus also allows on-premise systems to be bridged to cloud-based systems in a secure fashion that allows firewall and NAT traversal - in a cross-platform manner.

 

Crystal Reports

Overview of Crystal Reports

  • Formatting and summarizing data
  • Filtering, sorting and grouping data
  • Customizing reports with business logic
  • Connecting to SQL Server, Oracle and Access databases
  • Adding charts and subreports to a report

The Crystal Report Writer
Writing a basic report

  • Selecting a format
  • Adding text and fields
  • Connecting to remote data sources
  • Configuring the reporting environment

Formatting and styling

  • Tailoring sections within a report
  • Annotating header and footer fields
  • Designing fields for quality presentations
  • Adding color, borders and pictures
  • Highlighting data with Highlight Expert

Linking Crystal Reports to Data
Connecting to popular data sources

  • SQL Server
  • Oracle
  • Access
  • Web logs
  • XML
  • Reporting from stored procedures and views

Establishing data connections

  • Creating a connectivity checklist
  • Configuring ODBC and OLE DB
  • Integrating SQL commands in a report

Interpreting Structures and Retrieving Data
Navigating complex data

  • Deciphering data structures
  • Identifying data relationships

Gathering the right data

  • Merging data from multiple tables
  • Building business queries
  • Optimizing data retrieval

Combining Powerful Report Techniques
Organizing and summarizing reports

  • Sorting user sort control and grouping
  • Grouping with formulas
  • Summary and Rolling Total fields
  • Using Report Alerts

Building advanced reports

  • Embedding linked and unlinked subreports into reports
  • Creating crosstab and drill-down reports
  • Designing dynamic and cascading prompts
  • Multipass reporting, Hyperlinking Reports and Multilingual Reports
  • Achieving reusability with templates

Visualizing complex data

  • Simplifying data with charts and graphs
  • Organizing fields into sections
  • Adding, merging, suppressing sections

Programming Data Functionality
Coding in formula language

  • Working with variables and operators
  • Deciphering formula syntax
  • Adding and modifying formulas with the Formula Workshop
  • Calling and working with functions
  • Sharing formulas with the Repository

Writing effective formulas

  • Building if/then/else statements
  • Converting and comparing data
  • Debugging the code
  • Employing the Formula Workshop

Converting to Basic Syntax

  • Writing formulas with Basic Syntax
  • Laying a foundation for complex reporting logic

Deploying Reports to the Internet, Intranets, Visual Basic and .NET
Deploying Crystal Reports

  • Deciding among Push, Pull, Static and Dynamic reports
  • Migrating to production by switching databases
  • Determining when to use the Crystal Reports Server

Publishing reports to a Web site

  • Exporting reports to HTML
  • Publishing to CrystalReports.com

Integrating into custom applications

  • Adding Crystal Reports to Visual Basic and .NET
  • Exploring application development options with Crystal Reports

 

 
Data Modeling

Introducing Data Modeling

  • The Relational Data Model
  • The Object Data Model
  • The Object-Relational Data Model
  • Data Warehouse Data Modeling
  • Client-Server Versus OLTP Databases
  • Available Database Engines

 

Relational Data Modeling

  • What is Normalization?
  • Normalization Made Simple
  • Relational Terms and Jargon
  • 1st Normal Form
  • Demonstrating 1st Normal Form
  • 2nd Normal Form
  • Demonstrating 2nd Normal Form
  • 3rd Normal Form
  • Demonstrating 3rd Normal Form
  • 4th and 5th Normal Forms
  • Primary/Foreign Keys/Referential Integrity
  • The Traditional Relational Database Model
  • Surrogate Keys and the Relational Model
  • Denormalization

 

Object Data Modeling

  • The Object-Relational Database Model
  • Relational Versus Object Models
  • What is the Object Data Model?
  • What is a Class?
  • Again - a Class and an Object
  • What is an Attribute?
  • What is a Method?
  • The Simplicity of Objects
  • What is Inheritance?
  • What is Multiple Inheritance?
  • Some Specifics of the Object Data Model

 

Data Warehouse Data Modeling

  • The Origin of Data Warehouses
  • Why the Relational Model Fails
  • The Dimensional Data Model
  • Star Schemas and Snowflake Schemas

 

Getting Data from a Database

  • What is Structured Query Language (SQL)?
  • The Roots of SQL
  • Queries
  • Changing Data
  • Changing Metadata
  • What is ODQL?

 

Tuning a Relational Data Model

  • Normalization Versus Denormalizatrion
  • Referential Integrity
  • Alternate Keys
  • What is an Index?
  • Indexing Considerations
  • Too Many Indexes
  • Composite Indexing
  • Which Columns to Index?
  • Index Types
  • Match Indexes to SQL Code
  • Types of Indexing in Detail
  • Where Index Types Apply
  • Undoing Normalization
  • What to Look For?
  • Undoing Normal Forms
  • Some Good and Bad Tricks

 

Tuning a Data Warehouse Data Model

  Denormalization
Star Versus Snowflake Schemas
Dimensional Hierarchies
Specialized Data Warehouse Toys

Other Tricks

  • RAID Arrays and Striping
  • Standby Databases
  • Replication
  • Clustering
  • Wrapping it Up
  • ome Available Database Engines
  • The Future: Relational or Object?
MS.Net

Course Introduction

  • Intro / Objectives
  • What this Course Covers
  • For New Developers
  • For Experienced Developers
  • Microsoft Certification Tracks
  • Terminology & TLA's

.NET Framework Fundamentals

  • Why .NET?
  • What is the .NET Framework?
  • .NET Under the Hood
  • .NET Clients
  • Obtaining the .NET Framework
  • Language Options
  • .NET Tools
  • Framework Config MSC

How .NET Works

  • .NET and XML

Advantages of .NET

  • What's the Big Deal?
  • Important Changes

Visual Studio .NET

  • Introducing .NET
  • Visual Studio Basics
  • Obtaining and Installing .NET
  • File Organization

Framework Organization

  • Namespaces
  • Classes and More Classes

Data Types

  • Common Type System
  • Value or Reference?

Common Language Runtime

  • CLR Basics
  • MSIL

Assemblies

  • DLL Hell Freezes Over
  • Assembly Basics
  • Assembly Contents
  • Manifest Basics
  • Assembly Versioning
  • Shared Assemblies
  • How CLR Locates Assemblies
  • Redirecting

.NET Object Oriented Programming

  • VB Grows Up
  • OOP Fundamentals
  • Class Fundamentals
  • Constructors
  • Constructor Tricks
  • Inheritance
  • Inheritance Example
  • Overloading
  • Overriding
  • Shadowing
  • Interfaces

Garbage Collection

  • GC Basics
  • How GC Works
  • Forcing GC

ASP .NET

  • Web Development in .NET
  • How ASP.NET Works
  • ASP.NET Basics
  • Deploying ASP.NET Web Apps

Data Access

  • Introducing ADO.NET
  • ADO.NET Structure
  • Important Changes

Web Services

  • What Is a Web Service?
  • Creating Web Services
  • Using Web Services

Interaction With COM

  • COM Basics
  • COM & .NET
  • Calling COM from .NET

Remoting

  • What is Remoting?
  • Remoting Basics
  • Remoting Issues

Reflection

  • What is Reflection?
  • How Reflection Works

Deployment

  • Giving Birth to Your App
  • Deployment Issues

Configuration Files

  • Configuring Apps Made Easy
  • Configuration Basics

Code Security

  • Security Basics
  • Code Security Options

Migrating to .NET

  • Why to Migrate
  • When to Migrate
  • How to Migrate
SharePoint Administration  Training
SharePoint Administration

  • Introducing SharePoint
  • Differences between WSS and Moss
  • Features of SharePoint
  • Integrating with Microsoft Office
  • SharePoint Requirements
  • Reviewing SharePoint Installation

WSS and SharePoint configuration

  • WSS configuration
  • MOSS configuration
  • Creating a new SharePoint Application
  • Creating SharePoint site collections
  • Configuring your site collections

SharePoint Lists

  • Basics of Lists
  • Adding and editing lists
  • Changing the view for lists
  • Subscribing to RSS Feeds for lists
  • Exporting list content to MS Excel®

SharePoint Libraries

  • What is a Library and what is a Document
  • Uploading new documents to a library
  • Working with documents in a library
  • SharePoint Library templates
  • Managing and Customizing Lists and Libraries
  • Checking in and checking out files
  • Uploading files
  • Creating new library files
  • Using Library templates
  • Modifying existing lists
  • Customizing a library

Workflow

  • What is SharePoint workflow
  • SharePoint workflow templates
  • Custom workflows
  • Building a SharePoint workflow
  • Utilizing workflow templates
  • Associating a workflow with a document library
  • Creating a custom workflow with SharePoint Designer

Working with Web Parts

  • What is a web part
  • Web part pages
  • Included web parts
  • Customizing pages with web parts

User Management and Profiles

  • How users login to a SharePoint site
  • Managing access in SharePoint
  • Understanding membership groups
  • Understanding different levels of access
  • User Profiles
  • Audiences
  • Creating new groups
  • Creating new users
  • Maintaining a permissions model

Form Services

  • What is InfoPath®?
  • Working with InfoPath
  • Form Controls
  • Form Templates
  • Publishing Forms to Document Libraries
  • Designing Forms
  • Publishing Forms
  • Customizing Form Templates

Excel Services

  • Excel Services Overview
  • The Report Center
  • Publishing a Workbook
  • Data Connections
  • Business Scorecards
  • Creating a Report Center
  • Publishing a Workbook
  • Displaying a Workbook in a Web Parts
  • Creating a KPI List
  • Creating a Digital Dashboard

Business Data Catalog (1 hr)

  • What is the Business Data Catalog?
  • Primary Roles for the BDC

Web Content Management

  • The Publishing Portal
  • Working with Variations
  • Customizing the Look and Feel of a Site
  • Creating a Publishing Portal
  • Enabling Variations on a Site Collection
  • Managing Labels for Translations
  • Applying a New Master Page
  • Customizing a Master Page
  • Customizing Pages Based on Content Type
  • Enabling Publishing on a Team Site

Search

  • Enabling Search Feature
  • Advanced Search
  • Customizing and Managing Search
  • File Types and Search Scopes
  • The Search Center
  • Exploring Basic and Advanced Search Features
  • Indexing and Searching Non-SharePoint Sites
  • Indexing and Searching File Shares
  • Scheduling Updates for Content Sources
  • Resetting Crawled Content
  • Adding a Search Scope to a Site Collection

Backup and Recovery

  • Backup and Recovery Considerations
  • Backup Procedures
  • Recovery Procedures
  • Backing up and recovering SharePoint configuration
  • Backing up and recovering SharePoint sites
  • Backing up and recovering databases