Microsoft SharePoint Server 2007 MCTS 70-542
This series 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.
This course is for anyone who wants to achieve MCTS 70-542 certification. This online course contains 7 lessons and should take approximately 9 hours to complete.
Managing Enterprise Content
This course 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 course include customizing data retrieval and workflows, and creating hierarchical Web sites and features for the streamlined, centralized administration and use of organizational data This course 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 and teaches you how to 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, and provision or add multiple sites to a SharePoint hierarchy.
Creating Business Intelligence Solutions
This course 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 course also covers business data Access and Discovery, such as adding Rich Reporting to MOSS 2007 and teaches you how to 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, and create a key performance indicator (KPI) Web Part by using data from a report data source.
Using the Business Data Catalog
This course 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 course also covers Business Data Catalog access to underlying data sources with a metadata model that provides a consistent and simplified client object model and teaches you how to 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, and describe business data types.
Accessing Application Platform Services
This course 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 course also covers various components such as the WSS, UDCs, WCF, and WSE as they relate to document conversions, content management, and Web services and teaches you how to 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, and display a user profile retrieved from an Office SharePoint Server 2007 Web service.
Searching Data with the Search Service
This course 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 course also covers the applicability and relevance of search results to requested search criteria, to ensure user-friendliness in the MOSS 2007 search experience and teaches you how to 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, and display the results of a keyword query.
Targeting Content Based on Audience Membership
This course 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 course also covers the code required to implement business rules and content management features in both Microsoft Visual Basic 2005 and Microsoft Visual C# 2005 and teaches you how to 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, and display all users in a given audience.
Customizing Functionality with Profiles
This course introduces the features and functionalities in Microsoft Office SharePoint Server 2007 that can be used to customize User Profiles This course also covers configuration and code requirements and associated features, such as LDAP and ADAM, for implementing MOSS 2007 User Profile management features and teaches you how to 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, and display results from the user profile change log.