Introduction

This five day course focuses on the features in SharePoint 2007 that support application development and customization. Attendees will get a comprehensive introduction to the SharePoint development platform and will also be provided with an overview of the customization of SharePoint sites using tools such as SharePoint Designer 2007 and Visual Studio 2005.

Audience

This Class is designed primarily for SharePoint developers and site designers, but is also appropriate for SharePoint project managers laying out a SharePoint development strategy.

At Course Completion

If you attend this course, you will learn:

·         What customizations can be done in the browser, and when you will need to use SharePoint Designer and Visual Studio.

·         How to manage SharePoint security including the use of permissions, permission levels and SharePoint Groups.  Additionally, how to leverage Active Directory security groups will be addressed.

·         The core features of the Windows SharePoint Services 3.0 platform, and how developers can leverage its new ASP.NET 2.0 foundation

·         How to design your site collection architecture by using managed paths and multiple content databases.

·         How developers can use the important new list and library enhancements such as site columns and content types

·         How to use SharePoint Designer 2007, including using it to customize sites with Master and Content Pages, Cascading Style Sheets, and Site Themes.

·         How to design a site branding strategy that fits your company’s goals.

·         How to work with ASP.NET controls and custom forms in SharePoint Designer.

·         How to tie ASP.NET controls to SharePoint lists.

·         How to build InfoPath forms and integrate them with SharePoint.

·         How to build custom workflows using SharePoint Designer 2007.

·         How to build data centric and reporting applications in SharePoint, using the improved Data View control in SharePoint Designer, and the Business Data Catalog (BDC) in MOSS 2007.

·         How to connect to SQL databases from SharePoint Designer via Single Sign-On, BDC and SQL authentication.

·         The fundamentals of SharePoint programming using Visual Studio 2005, including programming the SharePoint API, and programming SharePoint sites using the Web Services interface.

Prerequisites

To get the most out of this seminar attendees should have previous experience working with and customizing SharePoint 2003 sites.

Course Materials

All Course materials will be provided with the cost of the Class.

Course Outline

Module 1: Course Introduction and SharePoint 2007 Backgrounder

•      Windows SharePoint Services Features

•      SharePoint Server Features

•      Architecture and Services

•      Site Collections, Managed Paths and the effective use of content databases

•      SharePoint Security

•      Development Possibilities

Module 2: Working with Lists, Views, Site Columns and Content Types

•      Core Enhancements

•      Enhancements in Lists, Libraries and Views

•      Working with Site Columns

•      Working with Site Content Types

•      New List Types

Module 3: Working with Pages and Web Parts

•      Improved Web Part design experience

•      Working with new SharePoint 2007 Web Parts

•      Working with Connected Web Parts

•      Exporting and Importing Web Parts

Module 4: Customizing SharePoint Sites Using SharePoint Designer

•      SharePoint Designer 2007 Basics

•      Customizing the default Master Page of a Site

•      Applying Master Pages to New Pages

•      Working with Cascading Style Sheets

•      Customizing Sites with Site Themes

•      Review Site Branding Strategies

Module 5: Application Development with SharePoint Designer and InfoPath

•      Working with ASP.NET Controls

•      Integrating ASP.NET Controls with SharePoint Lists

•      Connecting to SQL databases from SharePoint Designer

•      Creating and Working with Data Integration Features

•      Creating Custom Forms for SharePoint Lists

•      Creating custom InfoPath forms and publishing them to SharePoint

Module 6: Building Workflows in SharePoint 2007

•      Workflow Fundamentals

•      Creating Workflows using SharePoint Designer

•      Contrasting Designer Workflows with Windows Workflow Foundation workflows created using Visual Studio 2005

Module 7:  Excel Services and Business Intelligence

•      Overview of Excel Services

•      Setup and Administration

•      Publishing Workbooks

•      Creating Dashboards

•      Key Performance Indicators

Module 8:  Business Data Catalog

•      Using the Business Data Catalog

•      Configuring the Application Definition File

•      Methods for creating the Application Definition File

•      Using new web parts to access BDC entities

•      Integrating BDC data in SharePoint lists and libraries

Module 9: Programming SharePoint

•      Architecture and Object Model

•      Programming SharePoint using the API

•      Programming SharePoint using Web Services