Microsoft SharePoint Server 2007 MCTS 70-542 course

Total Items: 7 Total Time: 9.00 hour(s)

Summary:

This training will prepare you for the MCTS 70-542: Microsoft Office SharePoint Server 2007 – Application Development exam.

This exam is the only requirement to apply for the Technology Specialist: Microsoft Office SharePoint Server 2007,

Application Development certification. This study guide will prepare you build SharePoint Server applications, with a focus on managing business intelligence data.

Learning Segment 1: Managing Enterprise Content :

Summary:

This learning segment covers developing applications in the Microsoft Office SharePoint Server 2007 environment, and utilizing programming languages such as XML to integrate functionality. SharePoint fundamentals covered in this learning segment include customizing data retrieval and workflows, and creating hierarchical Web sites and features for the streamlined, centralized administration and use of organizational data. This learning segment also introduces the use of Document Policies for logically managing document handling, the use of Page Authoring for managing MOSS 2007 Web content, and other topics.

Objectives:

• Create and customize a document policy Create and customize the Auditing Policy feature Customize and use Records Management features Create, edit, and author HTML and Web pages Create new content deployment paths Provide variations of Web content Provision or add multiple sites to a SharePoint hierarchy

Topics:

• Managing Enterprise Content

Learning Segment 2 : Creating Business Intelligence Solutions

Summary:

This learning segment introduces the features and functionalities in Microsoft Office SharePoint Server 2007 that can be used to provide an infrastructure that makes it easy for decision-makers to access information anytime, anywhere. This learning segment also covers business data Access and Discovery, such as adding Rich Reporting to MOSS 2007.

Objectives:

• Display data from a Microsoft Excel workbook by using Excel Services Create a trusted workbook location by using the Stsadm.exe command-line tool Implement business logic by using an Excel Services user-defined function Filter data in a workbook by using Excel Services Provide parameters to a Report Viewer Web Part from a custom Web Part Expose a data source by adding a data connection to a Report Center Web Site Create a key performance indicator (KPI) Web Part by using data from a report data source

Topics:

• Creating Business Intelligence Solutions

Learning Segment 3 : Using the Business Data Catalog

Summary:

This learning segment introduces the features and functionalities in Microsoft Office SharePoint Server 2007 that can be used to serve business data from various Line-of-Business applications such as SAP, Siebel, and databases. This learning segment also covers Business Data Catalog access to underlying data sources with a metadata model that provides a consistent and simplified client object model.

Objectives:

• Create a Line-of-Business (LOB) system Explain Business Data Catalog (BDC) Functions and Operations Configure the BDC as an object model with metadata Use external applications in line with the BDC application definition Create a Finder method Implement incremental crawls in the database for indexing Configure a Business Data List (BDL) to display a list of items from a BDC data source Enable a single item query by creating a SpecificFinder method or identifiers for entities Use a List Web Part to display tasks or to retrieve information from the BDC definition Describe business data types

Topics:

• Using the Business Data Catalog

Learning Segment 4 : Accessing Application Platform Services :

Summary:

This learning segment introduces the features and functionalities in Microsoft Office SharePoint Server 2007 that can be used to automate, customize, and manage data, configurations, processes and procedures. This learning segment also covers various components such as the WSS, UDCs, WCF, and WSE as they relate to document conversions, content management, and Web services.

Objectives:

• Process InfoPath data from within a workflow Display an InfoPath Form from within an ASP.NET page by using the Form Services control Automate Office Forms Server administration tasks Manage credentials by using the Single Sign-On (SSO) credential store Convert documents by using the document converter Display a user profile retrieved from an Office SharePoint Server 2007 Web service

Topics:

• Accessing Application Platform Services

Learning Segment 5 : Searching Data with the Search Service

Summary:

This learning segment introduces the features and functionalities in Microsoft Office SharePoint Server 2007 that can be used to search and retrieve enterprise content, with a focus on Enterprise Search Architecture, Querying Enterprise Search, Customizing the Search user interface, Programmatically Administrating Search, and the general management and administration of Web content. This learning segment also covers the applicability and relevance of search results to requested search criteria, to ensure user-friendliness in the MOSS 2007 search experience.

Objectives:

• Enhance the search service programmatically Add a custom search page for searching the Business Data Catalog (BDC) Provide custom search capabilities by creating an enterprise search Web Part Customize the display of search results by modifying the Search Core Results XSLT Display results from a Windows SharePoint Services search Web service Display the results of a keyword query

Topics:

• Searching Data with Search Service

Learning Segment 6 : Targeting Content Based on Audience Membership :

Summary:

This learning segment introduces the features and functionalities in Microsoft Office SharePoint Server 2007 that can be used to manage user information and Web Parts, with a focus on document policy features, document storage, business rules, resource lists, Web content management features, workflows, and document policy logic. This learning segment also covers the code required to implement business rules and content management features in both Microsoft Visual Basic 2005 and Microsoft Visual C# 2005.

Objectives:

• Create an audience Specify conditions for audience membership by using rules Target a list item to an audience Target a Web Part to an audience by using filters Display all audiences to which a user belongs Display all users in a given audience

Topics:

• Targeting Content Based on Audience Membership

Learning Segment 7 : Customizing Functionality with Profiles

Summary:

This learning segment introduces the features and functionalities in Microsoft Office SharePoint Server 2007 that can be used to customize User Profiles. This learning segment also covers configuration and code requirements and associated features, such as LDAP and ADAM, for implementing MOSS 2007 User Profile management features.

Objectives:

• Import users into the user profile store from an LDAP store Create a profile in the user profile store Manipulate profile properties Display all colleagues for a given user Add a distribution list to a new membership Display results from the user profile change log

Topics:

• Customizing Functionality with Profiles

Features:

• Flash-based instructional demonstrations applying course concepts. Instructional audio with graphics highlighting key points.
• Exercises allow learners to practice in the actual application being studied.
• A Course Topics list contains active hyperlinks, permitting quick access to specific topics.
• Find-A-Word allows learners to look up an unfamiliar term in the Glossary, on the Web, or in a dictionary. In addition, it lets them find other occurrences of the term in the same course.
• Search text enables learners to rapidly search all text within a course to easily retrieve information required.
• A skill assessment generates a customized learning path based on the results of a pre-test.
•  A glossary provides a reference for definitions of unfamiliar terms.
• Bookmarking tracks the learner's progress in a course.

Technical Requirements:

P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Cookies enabled; Sound card with speakers or headphones strongly recommended.