Administration DVD
Interactive DVD
BENEFITS WHAT YOU WILL LEARN SCREENSHOTS BUY NOW
What You Will Learn

SharePoint 2007 Training DVD Fundamentals is intended for System Administrators, Architects, and Managers.

Administrators, system architects, and designers from companies such as Microsoft, Lexis Nexis, Intel, and Nucor attended the "Microsoft SharePoint: Become an Expert" class on which we based the content of training DVD. Below are some of the items that you will learn as part of the course:

  • Course Overview
  • Outline - Part 1
  • Outline - Part 2


  • All the topics covered from the Fundamentals DVD.
  • Core SharePoint features - sites and site collections, lists, columns, views, site, version control, notification mechanisms, web parts, search, personal sites, and user profiles.
  • How to administer security
  • The importance of content types and their relationship to features such as site columns, workflows, information management policies, and content query web part
  • Out of box workflow management
  • How to create workflows in SharePoint Designer
  • New integration features in Office 2007
  • How to use InfoPath to design and publish forms to InfoPath Form Services
  • How to use Excel to design and publish reports to Excel Services
  • How to administer site collection content, site templates, features, themes, and recycle bin
  • How to use sites directory template
  • Web content management and publishing features management
  • How to use SharePoint Designer to change look and feel of SharePoint sites and create web parts that display information from various data sources
  • How to use business data catalog features
  • How to use document center as publishing location
  • How to create a site collection mapped to organizational structure from start to finish
  • The architectural foundation of SharePoint platform
  • Details about the web server and the database server
  • How to manage web applications and site collections and purpose of different web applications such as shared services or central administration
  • Content databases management
  • Shared services provider management
  • Alternative access mappings and its relationship to DNS and authentication
  • How to administer user profiles, active directory imports, and how to setup useful audiences
  • How to setup search content sources, scopes, best bets, and managed properties
  • How to customize search and search results pages
  • Site definitions and features from system administrator perspective
  • How to use backup and restore tools
  • How to administer and use single sign on
  • How to administer business data catalog
  • Upgrading from SharePoint 2003 to SharePoint 2007
  • Deployment guide

Part 1 - Fundamentals

Content Management / Site Collection Administration


  • Navigation
  • Site collection, sites, lists
  • List columns and views
  • Versioning
  • Draft/publishing versioning model
  • Email notifications and list emails
  • Web parts
  • Standard vs. published web part pages
  • Content query web part
  • Managing personal site and user profile
  • Search syntax from end user perspective
  • Authentication vs. authorization
  • Site Level Security
    • Permissions
    • Permission levels
    • Active Directory users and groups
    • SharePoint groups
  • List, folder list item security
  • Security Principals
  • Limitations
  • Opening items in Outlook (offline)
    • Calendar
    • Tasks
    • Contacts
    • Document libraries
  • InfoPath Form Publishing
  • Importing lists from excel
  • Excel Services and dashboard pages
  • KPI (key performance indicator) lists
  • Site columns
    • Creating/updating/propagating
    • Scopes
  • Content types
    • Creating/updating/propagating
    • Content types settings
  • Information management policies
    • Labeling
    • Auditing
    • Expiration
    • Using with content types
  • Workflow
    • Out of box vs. SharePoint Designer vs. Visual Studio
    • Standard workflow templates
    • Association
    • Initiation and status
    • Relation to content types
  • Manage content and structure tool
  • Recycle bin
  • List and site templates
    • Creating new
    • List and site collection galleries
    • Examining Microsoft templates
  • Features from site administrator perspective
  • Site directory and self-service site collection creation
  • What SharePoint does not share between site collections
  • Modifying site image and theme
  • Editing look and feel
    • Customized/uncustomized pages
    • Master/content pages
    • Safe vs. application pages and problems that they cause
    • CSS Stylesheets customization
  • working with external data sources
    • SQL databases
    • Lists on other sites
    • Data view configuration
  • building workflows
    • Creating new
    • Examining workflows from Microsoft templates
  • Publishing infrastructure and publishing features
  • Publishing content types
  • Page layouts and fields controls
  • Page layout association with content type
  • Custom content types
  • Using SharePoint Designer to modify page layouts
  • Publishing process
  • Customizing content query web part look and feel
  • Customizing master pages
  • Set up of "ABC Company" site collection and navigation
  • Secure "ABC Company" site collection
  • Set up document management for "ABC Company"
    • Document libraries
    • Content types
    • Document center site publishing

Part 2 - Administration

System Administration / Architecture


  • Topology
    • Servers in farm
    • Services on server
  • Global configuration
  • Application security
  • Web application management
    • What is a web application, application pool in IIS, SharePoint, impersonation vs. process account
    • What is the basic database organization in SharePoint databases and why we need multiple content databases for the same web application
    • Content database tables
    • Create or extend or delete web application
    • Remove SharePoint from IIS web site
    • Assignment permissions to users for the entire web application
  • SharePoint Site Management
    • Create and delete site collections
  • Intranet/extranet deployment scenarios
  • Shared services provider configuration
  • Full URL rendering
  • Zones, public URLs, internal URLs
  • Authentication considerations
  • Load balancing considerations
  • User profiles
    • Import from Active Directory
    • Creating new properties
  • Audiences
    • Creating audiences
    • Using audiences in pages, web parts, and list items
  • Search architecture
  • Content sources and schedules
  • Crawl rules and security
  • Properties and scopes
  • Relevance inclusions / keywords / logging
  • Customizing search center and web parts
  • What has changed
  • New feature architecture
  • How to use features as administrators
  • Simple feature
  • Solutions
  • Creating applications definitions
  • Using single sign on credentials in SharePoint Designer
  • Lob systems, entities, properties, and methods
  • Authorization
  • Delegation vs. RevertToSelf authentication
  • What to backup
  • Backup method descriptions and limitations
  • MOSS backup and restore tool through user interface and stsadm command-line
  • Individual site collection backup and restore through stsadm command-line
  • Third party solutions
  • Basics of upgrade processes
  • Step by step process of manual content database migration
  • Initial planning: define the team and the scope for the first stage of deployment
  • Pilot deployment as an intranet: focus on collaboration, document management and portal features
  • Test deployment on production hardware: plan capacity and figure out server farm structure
  • Production deployment
  • Beyond the initial stages
  • Examining prerequisites
    • Application server role
    • Domain controller role
    • SQL server
    • Email
  • Installing SharePoint files and central administration site
    • Initial parameters
    • Using the wizard
    • Browsing through central administration iste
  • Configuring services
  • Creating shared services provider
  • Creating end-user web application and a site collection
  • Configuring Shared Services provider
    • User profiles
    • Search
    • Business data catalog
    • Excel services