Advanced Microsoft Office SharePoint 2007 Development
(Microsoft Training Course: 50064) - 5 days - £2640 exc VAT

> Target Audience
This course provides students with the knowledge and skills to develop Microsoft SharePoint 2007 applications and customisations. It is intended for experienced SharePoint developers.
> Course outline
  1. Custom Authentication
  2. SharePoint Permissions
  3. In-Browser Customisation
  4. Basic SharePoint Designer
  5. Advanced SharePoint Designer
  6. Content Types
  7. Site Definitions
  8. Features
  9. Web Services API
  10. Web Part Development
  11. Client Side Scripts/AJAX
  12. Object Model
  13. Custom Field Types
  14. SharePoint Events/Timer Jobs
  15. Shared Services
  16. Workflows (SP Designer)
  17. Workflows (Visual Studio)
  18. ASP.NET Localization
  19. SharePoint/Microsoft FrontPage RPC
  20. Excel Services
  21. Business Data Catalog
  22. Business Intelligence

Module 1: Custom Authentication
  • This module explains ASP.NET providers, how to create a single sign-on, and how to configure a SharePoint Web Application.
  • SharePoint = ASP.NET Application
  • ASP.NET Providers
  • Microsoft Single Sign-On
  • Lab: Custom Authentication
  • Configure a Microsoft Single Sign-On
  • Configure a SharePoint Web Application
Module 2: SharePoint Permissions
  • This module explains the permissions in Microsoft Windows Server Systems (WSS) and how they have been enhanced.
  • IIS Application Pools
  • SharePoint Groups
  • ASP.NET Membership/Role Provider
  • Custom Permission Levels
  • Security Trimmed Interface
  • Web Application Policy
  • SPSecurity Class
  • Lab : SharePoint Permissions
  • Set permissions at an item level.
  • Use the Membership/Role provider feature of ASP.NET 2.0.
Module 3: In-Browser Customisation
  • This module explains how to add new pages using web parts, master pages, and themes.
  • Default.aspx
  • Using Web Parts
  • Customization Web Parts
  • Adding New Pages
  • Editing New Pages
  • Content Management Server (CMS)
  • Lab: In-Browser Customizations
  • 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.
Module 4: Basic SharePoint Designer
  • This module explains the SharePoint designer basics, how to create and modify existing sites, and how to create CSS style sheets.
  • Creating and Modifying Existing Sites
  • SharePoint Designer Editing Features
  • Creating Master Pages
  • Creating CSS Style Sheets
  • Lab: Basic SharePoint Designer Tasks
  • Make simple changes to your SharePoint site.
  • Update master pages.
  • Create and override CSS.
Module 5: Advanced SharePoint Designer
  • This module explains reports, data views, data sources, and how to back up and restore a Web site.
  • Built-In Reports
  • Data Views
  • Data Sources
  • Lab: Advanced SharePoint Designer
  • Run reports for quick data mining of the sites.
  • Backup and restore a web site.
Module 6: Content Types
  • This module explains different content types, document information panes, and how to create custom content types.
  • Built-In Content Types/ Inheritance
  • Site/Content Type Columns
  • Workflows
  • Custom Content Types
  • Lab: Content Types
  • Define metadata layers around content.
  • Build columns.
  • Assign items to common content.
Module 7: Site Definitions
  • This module explains built-in definitions, CAML and describes the different SharePoint templates and themes.
  • WSS Built-In Site Definitions
  • MOSS Built-In Site Definitions
  • CAML
  • Custom Site Definitions
  • Site Definition Elements
  • Site Definition Configuration Element
  • Lab: SharePoint Solution Generator
  • Lab: SharePoint Templates
  • Lab: SharePoint Themes
  • Add branding to the default site definitions.
  • Use the Solution Generator.
Module 8: Features
  • This module explains types of features and how to create, activate, and deactivate them.
  • Creating & Deploying Features
  • Activating/Deactivating Features
  • Solutions
  • Lab: Creating Features
  • Lab: Packaging Features into a Solution
  • Scope a feature such as a web part.
  • Create, deploy, activate, and deactivate features.
Module 9: Web Services API
  • This module explains web services API and some common SharePoint Web Services that are available.
  • Web Service APIs
  • Common SharePoint Web Services
  • Lab: Web Service API
  • Use web services to integrate your applications with SharePoint.
Module 10: Web Part Development
  • This module explains web part connections, upgrading web parts, and code access security.
  • WSS 2.0 vs. WSS 3.0 Web Parts
  • Web Part Connections
  • Upgrading your Web Parts to WSS 3.0
  • Code Access Security (CAS)
  • Lab: Web Parts
  • Use web parts to customize and personalize.
  • Connect web parts to each other to implement more advanced functionality.
Module 11: Client Side Scripts/AJAX
  • This module explains how to emit client side scripts and describes common AJAX uses.
  • Client Side Scripts
  • AJAX Introduction
  • SharePoint AJAX Support
  • Lab: Client Side Scripts / AJAX
  • Move functionality from Server to Client.
  • Enhance user experience by using AJAX.
Module 12: Object Model
  • This module explains object model Dlls and how to use the object model.
  • Object Model Dlls
  • SPSite vs. SPWeb
  • Namespace Changes (2.0 to 3.0)
  • Lab: Object Model
  • Build applications that extend functionality.
  • Create tools to automate common administrative functions.
  • Allow other .NET applications to integrate with SharePoint.
Module 13: Custom Field Types
  • This module explains how to create built-in types and custom field types.
  • Built-In Field Types
  • Custom Field Types
  • Lab: Building Custom Field Types
  • Create custom field types to enhance the functionality of lists in SharePoint.
Module 14: SharePoint Events/Timer Jobs
  • This module explains how to create new events in SharePoint.
  • SharePoint Event Handler History
  • New Events
  • SharePoint Timer Service
  • Lab: SharePoint Events
  • Lab : SharePoint Timer Jobs
  • Add event receivers to objects (lists and sites).
  • Understand the object model.
  • Include event receivers on SharePoint sites.
Module 15: Shared Services
  • This module explains the features of the shared services.
  • Shared Services Features
  • Lab: Setup Shared Services
  • Add extra functionality with Shared Services.
Module 16: Workflows (SP Designer)
  • This module explains SharePoint Designer workflows, conditions, and actions.
  • Built-In WSS/MOSS Workflows
  • Extending SharePoint Designer Workflows
  • Lab: MOSS Workflows
  • Lab: Workflows (SP Designer)
  • Use SharePoint workflows, conditions, and actions.
  • Add conditions and actions to further the functionality.
Module 17: Workflows (Visual Studio)
  • This module explains how to use workflows with Visual Studio and SharePoint.
  • Windows Workflow Foundation
  • Workflow Persistence
  • Workflows with Visual Studio
  • SharePoint Workflows
  • Debugging a Workflow
  • Lab: Workflow (Visual Studio)
  • Create and use workflows.
  • Design workflows with Visual Studio.
Module 18: ASP.NET Localization
  • This module explains how to use RESX files, SharePoint resource files, and SharePoint Language Packs.
  • ASP.NET Localization
  • Culture and UICulture
  • RESX Files
  • SharePoint Resource Files
  • SharePoint Language Packs
  • Lab: ASP.NET Localization
  • Localize a SharePoint site for other languages and cultures.
  • Override the default SharePoint RESX Files.
Module 19: SharePoint/Microsoft FrontPage RPC
  • This module explains how to use FrontPage RPC and SharePoint RPC.
  • FrontPage RPC
  • SharePoint RPC
  • Lab: SharePoint RPC
  • Use RPC methods do the work.
Module 20: Excel Services
  • This module explains how to use Excel Services.
  • Excel Services Trusted Locations
  • Excel Services Web Parts
  • Excel Services Object Model/Web Services
  • Lab: Excel Services
  • Use Excel Services to centralize Excel files.
  • Prevent “bad” Excel files from being uploaded by using trusted locations.
Module 21: Business Data Catalog
  • This module explains Business Data Catalogs.
  • Application Definition Files
  • Business Data Catalog Web Parts
  • Business Data Catalog Indexing
  • Business Data Catalog with Single Sign-On
  • Lab: Business Data Catalog
  • Using BDC to gain access to important data in a backend system.
  • Use BDC data to populate list data.
Module 22: Business Intelligence
  • This module explains how to use the report center, KPIs, dashboards, and Reporting Services Integration.
  • Report Center
  • Key Performance Indicator (KPI)
  • Reporting Services Integration
  • Lab: Business Intelligence
  • 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.
> Pre-Requisites
Before attending this course, students must have the following pre-requisites:
  • Completed course 4995: Programming with Microsoft .NET Framework Using Microsoft Visual Studio 2005
  • Completed course 2542: Advanced Data Access with Visual Studio 2005
  • Completed course 2543: Core Web Application Technologies with Microsoft Visual Studio 2005
  • Completed course 5060: Implementing Windows SharePoint Services 3.0 2007
  • Completed course 5061: Implementing Microsoft Office SharePoint Server 2007.
> Purpose
After completing this course, students will be able to 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.