Course 578:
SharePoint 2010 for System Admins, Designers,
and Managers

(4 days)


Course Description

SharePoint is a complex infrastructure that spans SharePoint, SQL Server, IIS, and the Windows Operating System. System administrators require knowledge of how to successfully configure, manage, maintain, and optimize their SharePoint infrastructure. In this four-day hands-on course, all aspects of SharePoint Server Operation will be examined.

Who Should Attend

This course will benefit system administrators, middleware/workflow designers, technical managers, and advanced Web developers who need to know how SharePoint operates from the ground up.


It is recommended that everyone previously attended the 2.5-day SharePoint for Power Users course or have power user equivalent experience with SharePoint 2010.

Course Outline

SharePoint Services Installation

  • Different Versions of SharePoint 2010
  • SharePoint Infrastructure Basics: Single Server and Server-Farm
  • Locating the SharePoint Database
  • Hardware and Software Requirements for SharePoint 2010
  • Pre-Installation Requirements of SharePoint Services
  • Installation of SharePoint Services on Windows Server 2008 R2, Using a Centralized SQL Server
  • SharePoint 2007 and 2010 Administration and Management Differences

SharePoint Server Management and Configuration

  • Understanding the SharePoint Framework
  • Day-to-Day SharePoint Management
  • Backup/Restoration Options in SharePoint
  • Understanding Email and SharePoint Integration: Outbound and Inbound
  • SharePoint Command Line Operation
  • Site Collections and Top-Level Sites

Creating Additional SharePoint Sites

  • Site Collections and Top-Level Sites
  • Managing SharePoint Namespaces
  • How SharePoint Integrates with Internet Information Server (IIS)
  • Securing SharePoint with SSL/TLS
  • Configuring Site Administrator Permissions

Web Parts

  • What Is a Web Part?
  • Enabling/Disabling Web Parts
  • Install a Downloaded Web Part
  • Considerations when Utilizing Third-Party Web Parts
  • Introduction on Writing Web Parts (*Lecture Only: Requires Programming/Visual Studio Knowledge)

SharePoint and SQL Server

  • Understanding How SQL Server Stores SharePoint Data
  • Looking at SharePoint Database Tables Using SQL Management Tools
  • Backup/Restoration/Movement of SharePoint Data in SQL
  • Connecting SharePoint to a SQL Server for Data Retrieval
  • Configuring a Web Part to Utilize A Back-End SQL Database

Providing Search Functionality

  • Windows SharePoint Services Search Architecture
  • Requirements for Search-enabling SharePoint
  • Content Crawling
  • Building Search Queries

SharePoint Security

  • Security and SharePoint
  • Adding Local Users and Groups to SharePoint Permissions
  • Understanding SharePoint Authentication
  • SharePoint Integration with Active Directory User Accounts
  • Adding Domain Users and Groups to SharePoint Permissions

Integration and Expanding SharePoint

  • Using SharePoint Designer 2010
  • SharePoint Integration with Microsoft Exchange/Messaging Systems
  • Building a SharePoint Web Farm
  • Migrating Sites and Content from SharePoint 2007 to SharePoint 2010
  • Microsoft InfoPath as a SharePoint Tool

Performance, Optimization, and Troubleshooting

  • Monitoring Performance of SharePoint Servers and Sites
  • Optimization of SharePoint Technologies
  • SharePoint Server Best Practices
  • Replacing a Failed SharePoint Server
  • Backup/Restoration Review

Building SharePoint Workflows

  • Creating Forms for Data Input
  • Design a Simple Workflow
  • Understanding Email Flow in SharePoint
  • Sending and Receiving Email with SharePoint
  • Using SharePoint Designer to Build Complex Workflows

Please Contact Your ROI Representative to Discuss Course Tailoring!