Advanced SharePoint 2007 Development

Create a SharePoint site that is customized and personalized to the end user

Create and run reports

Create custom field types to enhance functionality of lists

MS-4995: Programming with Microsoft .NET Framework Using Microsoft Visual Studio 2005

MS-2542: Advanced Data Access with Visual Studio 2005

MS-2543: Core Web Application Technologies with Microsoft Visual Studio 2005

MS-5060: Implementing Windows SharePoint Services 3.0 2007

MS-5061: Implementing Microsoft Office SharePoint Server 2007

Introduction

Course Materials

Facilities

Prerequisites

What We'll Be Discussing

Set Up Web Applications for Lab Use

Overview

SharePoint = ASP.NET Application

ASP.NET Providers

Microsoft Single Sign-On

Demonstration: Custom Authentication

Create a Username/Password Database

Create a User

Configure .NET Config File

Configure a SharePoint Web Application to Use Forms Authentication with Custom Provider

Configure a Single Sign-On

Program a Single Sign-On

Configure a Microsoft Single Sign-On

Configure a SharePoint Web Application

Overview

IIS Application Pools

SharePoint Windows Groups

SharePoint Default Groups

ASP.NET Membership/Role Provider

Assignable Entities

Custom Permission Levels

Permissions

Site/List/Item Permission Inheritance

Security Trimmed Interface

Web Application Policy

SPSecurity Class

Single Sign-On

Demonstration: SharePoint Permissions

SharePoint Default Groups

Membership Users

Custom Permission Sets

Site/List/Item Permission Inheritance

Web Application Policy

Set permissions at an item level

Use the Membership/Role provider feature of ASP.NET 2.0.

Overview

SharePoint UI Overview

Default.aspx

Everything Is a List

Using Web Parts

Customization Web Parts

Adding New Pages

Editing New Pages

Master Pages

Themes

Navigation

Demonstration: In-Browser Customizations

Page Layouts

Content Types

Content Management Server (CMS)

Default.aspx page

Adding web parts

Add/edit a new page

Apply a master page

Apply a theme

Versioning and content approval

Personalize site pages using web parts

Create and use master pages and themes to make it easy for end users to change the site to their preferences

Overview

SharePoint Designer Basics

Creating/Modifying Existing Sites

Exploring Team Sites

Exploring Portal Sites

Demonstration: SharePoint Designer

ASP.NET Pages

SharePoint Designer Editing Features

Demonstration: SharePoint Designer

Creating Master Pages

Demonstration: SharePoint Designer

Using SharePoint Controls

Demonstration: SharePoint Designer

Creating CSS Style Sheets

Demonstration: SharePoint Designer

Create a Site

Add an ASPX Page

Create a Master Page

Override CSS

Check In/Check Out

Add Web Parts

Add Web Part Zones

Adding Images

Reset to Site Definition

Make simple changes to your SharePoint site

Update master pages

Create and override CSS

Overview

Built-In Reports

Data Views

Data Sources

Backup Web Site

Restore Web Site

Demonstration: Advanced SharePoint Designer

Reports

Data Views

Data Sources

Backup a Site

Restore a Site

Run reports for quick data mining of the sites

Backup and restore a site

Overview

Content Types Introduction

Built-In Content Types/ Inheritance

Content Type Settings

Site/Content Type Columns

Document Information Panel

Workflows

Custom Content Types

Demonstration: Content Types

Built-in Types

Document Information Panel

Workflows

Define metadata layers around content

Build columns

Assign items to common content

WSS Built-In Site Definitions

MOSS Built-In Site Definitions

CAML

Custom Site Definitions

Site Definition Elements

Site Definition Configuration Element

SharePoint Solution Generator

SharePoint Templates

SharePoint Themes

Demonstration: Site Definitions

Create Site Definition (manually)

Create Site Definition (Visual Studio)

SharePoint Solution Generator

SharePoint Templates

Create a SharePoint Theme

Add branding to the default site definitions

Use the Solution Generator

Features Overview

Types of Features

Feature Scopes

Feature Dependencies

Feature Localization

Feature Event Receivers

Creating Features

Deploying Features

Activating/Deactivating Features

Solutions

Demonstration: Features

Creating a Feature

Deploying a Feature

Create a Feature using Visual Studio

Package features into a solution

Scope a feature such as a web part

Create, deploy, activate, and deactivate features

Overview

Web Service APIs

Why Use Web Services

Common SharePoint Web Services

Find Web Service

Add Web Service Reference

Use the Web Service

Use web services to integrate your applications with SharePoint

Overview

Web Parts

WSS 2.0 vs. WSS 3.0 Web Parts

ASP.NET Web Part Class

Web Part Connections

Web Part Connections (Interfaces)

Upgrading your Web Parts to WSS 3.0

When to use SharePoint Web Part Class

Web Part Permissions

Code Access Security (CAS)

Web Part Performance Hints

Demonstration: WebParts

Creating WebParts

Deploying WebParts

Build WebParts that Interface with Data Sources

Implement Web Part Connections

Implement Synchronous Web Part

Implement Asynchronous Web Part

Use web parts to customize and personalize

Connect web parts to each other to implement more advanced functionality

Overview

Client Side Scripts

Emitting Client Side Scripts

AJAX Introduction

Common AJAX Uses

SharePoint AJAX Support

Demonstration: Client Side Scripts

Client Side Scripts

AJAX

Move functionality from Server to Client

Enhance user experience by using AJAX

Object Model Overview

Object Model Dlls

Using the Object Model

SPSite vs. SPWeb

Namespace Changes (2.0 to 3.0)

Demonstration: Object Model

Object Model Dlls

Using the Object Model

Build applications that extend functionality

Create tools to automate common administrative functions

Allow other .NET applications to integrate with SharePoint

Overview

Field Types Introduction

Built-In Field Types

Custom Field Types

Demonstration: Custom Field Types

Building Custom Field Types

Create custom field types to enhance the functionality of lists in SharePoint

Overview

SharePoint Event Handler History

New Events

More Event Details

SharePoint Timer Service

SP JobDefinition Class

Create an Event

Assign an Event to a List

Assign an Event to a Site

Create a Timer Job

Add event receivers to objects (lists and sites)

Understand the object model

Include event receivers on SharePoint sites

Overview

Shared Services Features

Life without Shared Services Features

Life with Shared Services Features

Setup Shared Services

Add extra functionality with Shared Services

Overview

Built-In WSS/MOSS Workflows

SharePoint Designer Workflows

SharePoint Designer Conditions

SharePoint Designer Actions

Extending SharePoint Designer Workflows

Demonstration: SharePoint Designer Workflows

Create and Use Each of the MOSS Workflows

SharePoint Designer Workflows

Extending SharePoint Designer

Use SharePoint workflows, conditions, and actions

Add conditions and actions to further the functionality

Overview

Windows Workflow Foundation

Workflow Persistence

Workflow Types

Workflows with Visual Studio

SharePoint Workflows

SharePoint Workflows Forms

Debugging a Workflow

Comparison of Visual Studio vs. SharePoint Designer

Demonstration: Workflows (Visual Studio)

Create a Custom Workflow

Create and use workflows

Design workflows with Visual Studios

Overview

ASP.NET Localization

Culture and UICulture

RESX Files

Implicit vs. Explicit

SharePoint Resource Files

Browser Language

SharePoint Language Packs

Demonstration: ASP.NET Localization

RESX Files

Browser Language

Localize a SharePoint site for other languages and cultures

Override the default SharePoint RESX Files

Overview

FrontPage RPC

SharePoint RPC

Call a Simple SharePoint RPC Method

Use RPC methods do the work

Overview

Excel Services Trusted Locations

Excel Services Web Parts

Excel Services Object Model/Web Services

Create and Upload an Excel File

Add a Trusted Location

Configure Excel Web Parts

Use Excel Services to centralize Excel files

Prevent “bad” Excel files from being uploaded by using trusted locations

Overview

Application Definition Files

Business Data Catalog Web Parts

Business Data Catalog Indexing

Business Data Catalog with Single Sign-On

Install a BDC Application

Setup BDC Web Parts

Create a List that Uses BDC Data

Using BDC to gain access to important data in a backend system

Use BDC data to populate list data

Overview

Report Center

Key Performance Indicator (KPI)

Dashboards

Reporting Services Integration

Integrate SQL Server Reporting Services

Create a Report

Use the Reporting Services Web Part

Use the Report Center as the main portal to reports and business data

Utilize KPIs for quick and easy decision making

Integrate Reporting Services seamlessly with SharePoint sites

Overview

Prescan.exe

In-Place Upgrade

Side-By-Side/ Gradual Upgrade

Side-By-Side/Gradual Upgrade Steps

Database Migration Upgrade

Upgrading Site Definitions

Migration Issues

In-Place Upgrade

Gradual Upgrade

Database Migration

Migration Issues

Use the prescan.exe tool to find common issues

Test the migration in a staging environment