Microsoft SharePoint: Installation to Advanced Applications

Introduction

Embark on a comprehensive journey through Microsoft SharePoint with our extensive course designed to equip you with the knowledge and skills needed to master this powerful collaboration and document management platform. From installation to advanced application development, this course covers everything you need to know to effectively use SharePoint for business solutions.

Section 1: Installing SharePoint

In this foundational section, you will learn how to set up the core components required for a SharePoint environment. The journey begins with the installation of Office, ensuring you have the necessary tools to interact with SharePoint. Next, you’ll dive into the installation of SQL Server 2008 R2, which serves as the backend database for SharePoint. After setting up the prerequisites, you will move on to the installation of SharePoint itself, gaining a deep understanding of the steps and configurations involved. This section is crucial for setting up a robust SharePoint environment, providing the groundwork for all subsequent learning and application. Additionally, you will explore best practices for configuration and initial setup, ensuring your SharePoint environment is optimized for performance and scalability. By mastering the installation process, you will be able to create a stable foundation for your SharePoint deployment, ready to support your organization’s collaboration and document management needs.

Section 2: SharePoint: Lists and Library Apps

This section delves into the core functionalities of SharePoint, focusing on lists and library applications. You will start by learning the drag-and-drop functionality, which simplifies the process of uploading and organizing documents. The section then covers the creation and customization of lists, including modifying general, versioning, and validation settings. Furthermore, you will learn how to update permissions and manage list contents effectively. The section concludes with the creation of collaboration sites and adding tasks in project sites, enhancing your ability to organize and manage projects within SharePoint. Additionally, you will explore advanced list features, such as creating custom list views and using metadata to categorize and filter information. By mastering these skills, you will be able to create dynamic and interactive list and library applications, improving your organization’s ability to manage and collaborate on information.

Section 3: SharePoint: Office Applications

Integrating Office applications with SharePoint is essential for seamless document management and collaboration. In this section, you will learn how to edit documents directly in Office, co-author documents in real-time using SharePoint 2013, and integrate Excel with SharePoint for advanced data analysis. You will also explore creating and using workflows to automate business processes, adding web parts to enhance site functionality, and managing document locations and versioning. The section concludes with content types and managing document sets, ensuring you can organize and classify documents effectively. Additionally, you will delve into advanced document management techniques, such as using content type hubs for centralized content management and creating custom document sets to manage complex document lifecycles. By integrating these applications, you will streamline your workflows and enhance your productivity.

Section 4: SharePoint: Developer Tools

For those interested in customizing and developing SharePoint applications, this section provides an in-depth look at developer tools. You will start by exploring site settings and look-and-feel options, followed by using various developer tools to add web parts and create applications using SharePoint Designer. The section also covers displaying XML files and SQL databases, creating JavaScript pages, and integrating Silverlight for enhanced user experiences. The section concludes with developing custom SharePoint applications, including creating simple web parts, custom Twitter web parts, and using Expression Blend Suite for development. Additionally, you will explore advanced development techniques, such as creating master pages, using client-side object models, and developing Silverlight applications within Visual Studio. By mastering these tools and techniques, you will be able to create powerful and customized SharePoint applications, tailored to your organization’s specific needs.

Section 5: SharePoint: Tasks and Programming Lists

This section focuses on task management and programming lists within SharePoint. You will learn how to create data view web parts, site columns in Visual Studio, and event receivers. The section also covers creating ASPX pages, master pages, and dealing with programming SharePoint links. You will explore creating XAML files, navigating programming lists, and creating custom lists. Additionally, you will learn how to add service references, update product information, and run foreach loops. The section concludes with programming the client object model, writing list data programmatically, creating new list item objects, using RESTful programming against lists, and adding label controls. Additionally, you will delve into advanced programming techniques, such as creating custom list forms, using CAML queries for data retrieval, and implementing advanced client-side scripting with JavaScript and jQuery. By mastering these skills, you will be able to automate and enhance task management and list functionalities, improving your efficiency and productivity.

Section 6: SharePoint: Silverlight

Silverlight integration with SharePoint opens up a world of possibilities for creating rich, interactive web parts and applications. In this section, you will learn how to create web parts using Excel and Visual Studio, add data values, and develop customer information web parts. The section also covers creating visual web parts, adding labels, coding web parts, and creating custom web part properties. You will explore designing sales record visuals, adding custom lists, and coding sales record applications. The section concludes with creating new classes, site collection features, and developing ADO.NET-based external content types and read-only web services. Additionally, you will delve into advanced Silverlight development techniques, such as creating complex user interfaces, integrating Silverlight applications with SharePoint data, and optimizing Silverlight performance for large datasets. By integrating Silverlight, you will enhance the user experience and create visually appealing and highly interactive SharePoint applications.

Section 7: Project on SilverLight – Creating SilverLight Programs

In this hands-on project section, you will apply your knowledge to create Silverlight programs within SharePoint. Starting with an introduction to the Silverlight project, you will work through a series of progressive tasks, from initial setup to advanced functionalities. Each part of the project builds on the previous one, culminating in a comprehensive Silverlight application that integrates seamlessly with SharePoint. Additionally, you will explore advanced project management techniques, such as using version control systems for collaborative development, performing unit testing to ensure code quality, and optimizing application performance for real-world usage. By completing this project, you will gain practical experience and confidence in developing Silverlight applications, ready to tackle real-world challenges.

Conclusion

By the end of this course, you will have gained a comprehensive understanding of SharePoint, from installation to advanced application development. With hands-on experience and practical knowledge, you will be well-equipped to leverage SharePoint’s capabilities for effective collaboration, document management, and custom application development, making you a valuable asset to any organization.

What Will Students Learn in This Course?

In this comprehensive SharePoint course, students will gain a wide range of skills and knowledge, enabling them to effectively use and develop SharePoint solutions in various professional settings. Here’s a detailed breakdown of what students will learn:

Section 1: SharePoint Installation

• Installation of Office: Students will learn how to properly install Office, laying the foundation for SharePoint integration.
• Installation of SQL Server 2008 R2: Students will be guided through the installation process of SQL Server 2008 R2, a critical component for SharePoint’s backend.
• Installation of SharePoint Prerequisites: Understanding and installing the necessary prerequisites for SharePoint to ensure a smooth setup.
• Installation of SharePoint: The step-by-step process of installing SharePoint itself, including configuration and initial setup.

Section 2: Lists and Library Apps

• Drag and Drop Functionality: Utilizing the drag and drop feature for efficient file management.
• Creating a Custom List: How to create and customize lists to suit organizational needs.
• Modifying General, Versioning, and Validation Settings: Adjusting settings to manage document versions and validate data entries.
• Updating Permissions and Management: Configuring permissions for secure and controlled access to documents and lists.
• Working with List Contents: Managing and manipulating list content effectively.
• Creating Collaboration Sites and Adding Tasks: Setting up sites for team collaboration and managing project tasks.

Section 3: Office Applications

• Editing Documents in Office: How to seamlessly edit documents within SharePoint using Office applications.
• Coauthoring and Integrating with Excel: Real-time document collaboration and integrating Excel for advanced data analysis.
• Analyzing List Data in Excel: Using Excel to analyze SharePoint list data for better insights.
• Creating and Using Workflows: Automating processes with SharePoint workflows.
• Document Management and Versioning: Managing document locations, versions, content types, and document sets efficiently.

Section 4: Developer Tools

• Site Settings and Developer Tools: Customizing the look and feel of sites and using developer tools for advanced customization.
• Web Parts and Applications: Adding and customizing web parts and creating applications using SharePoint Designer.
• Displaying Data: Displaying XML files and SQL database content within SharePoint.
• JavaScript and Silverlight Integration: Enhancing SharePoint functionality with JavaScript and integrating Silverlight applications.

Section 5: Tasks and Programming Lists

• Data View Web Parts and Site Columns: Creating and customizing data view web parts and site columns.
• Event Receivers and ASPX Pages: Handling events and creating custom ASPX pages.
• Programming with SharePoint: Navigating programming lists, creating custom lists, and using service references.
• Client Object Model and RESTful Services: Writing data programmatically and interacting with SharePoint lists using RESTful services.

Section 6: Silverlight

• Web Parts and Visual Studio: Creating and adding web parts using Excel and Visual Studio.
• Customer Information and Sales Records: Developing custom web parts for customer information and sales records.
• External Content Types: Creating ADO. NET based external content types and read-only web services.
• Silverlight Applications: Building simple Silverlight applications and integrating them with SharePoint.

Section 7: Project on Silverlight – Creating Silverlight Programs

• Comprehensive Silverlight Project: Step-by-step guidance through a multi-part project, allowing students to create and refine Silverlight applications, integrating them with SharePoint to solve real-world problems.

By the End of This Course, Students Will Be Able To:

1. Install and configure SharePoint and its prerequisites.
2. Create and manage lists, libraries, and collaboration sites.
3. Integrate Office applications with SharePoint for enhanced productivity.
4. Develop custom solutions using SharePoint Designer, JavaScript, and Silverlight.
5. Implement advanced data management and automation through workflows, custom web parts, and external content types.
6. Handle SharePoint data programmatically using the Client Object Model and RESTful services.
7. Complete a comprehensive Silverlight project, integrating it seamlessly with SharePoint.

This course equips students with the essential skills to become proficient in SharePoint administration, development, and integration, preparing them for various roles in IT and business environments.