Microsoft 365: Building Advanced Knowledge Management Systems Training Course

About This Course

This three-day instructor-led course is aimed at people looking to move into a database professional role or whose job role is expanding to encompass database elements. The course describes fundamental database concepts including database types, database languages, and database designs.

Audience Profile

The primary audience for this course is people who are moving into a database role, or whose role has expanded to include database technologies.

At Course Completion

After completing this course, students will be able to:
• Describe key database concepts in the context of SQL Server 2016
• Describe database languages used in SQL Server 2016
• Describe data modelling techniques
• Describe normalization and denormalization techniques
• Describe relationship types and effects in database design
• Describe the effects of database design on performance
• Describe commonly used database objects

About This Course

This five-day course will provide you with the knowledge and skills to plan and administer a Microsoft SharePoint 2016 environment. The course teaches you how to deploy, administer, and troubleshoot your SharePoint environment. This course also provides guidelines, best practices, and considerations that help you optimize your SharePoint deployment.

This is the first in a sequence of two courses for IT professionals and is aligned with the SharePoint 2016 IT Pro certification.

Audience Profile

The course is targeted at experienced IT professionals who are interested in learning how to install, configure, deploy, and manage SharePoint 2016 installations either in a data center or in the cloud.

Students typically have more than one year of hands-on experience* with planning and maintaining SharePoint and two years’ experience with other core technologies on which SharePoint depends, including Windows Server 2012 R2 or later, Internet Information Services (IIS), Microsoft SQL Server 2014 or later, Active Directory Domain Services (AD DS), and networking infrastructure services.

The minimally qualified candidate typically:

• Is an IT professional who plans, implements, and maintains a multi-server deployment of SharePoint 2016.
• Has a working knowledge of, and preferably hands-on experience, with SharePoint Online.
• Has broad familiarity with SharePoint workloads.
• Has experience with business continuity management, including data backup, restoration, and high availability.
• Has experience with authentication and security technologies.
• Has experience with Windows PowerShell.

* The hands-on experience or job experience should be from a solutions-based role where the candidate has worked on multiple solutions in the SharePoint space that includes document management, content management, and search.

At Course Completion

• Describe the key features of SharePoint 2016.
• Design an information architecture for a SharePoint 2016 deployment.
• Design a logical architecture for a SharePoint 2016 deployment.
• Design the physical architecture for a SharePoint 2016 deployment.
• Install and configure SharePoint 2016.
• Create and configure web applications and site collections.
• Plan and configure service applications for a SharePoint 2016 deployment.
• Manage users and permissions, and secure content in a SharePoint 2016 deployment.
• Configure authentication in a SharePoint 2016 deployment.
• Configure platform and farm-level security in a SharePoint 2016 deployment.
• Manage information taxonomy in SharePoint web applications and site collections.
• Configure and manage user profiles and audiences.
• Configure and manage the search experience in SharePoint 2016.
• Monitor, maintain, and troubleshoot a SharePoint 2016 deployment.

About This Course

This five-day course will teach you how to plan, configure, and manage the advanced features in a SharePoint 2016 environment. The special areas of focus for this course include implementing high availability, disaster recovery, service application architecture, and Microsoft Business Connectivity Services. This course also focuses on social computing features, productivity, and collaboration platforms and features. Students also will learn about business intelligence solutions, Enterprise Content Management, web content management infrastructure, solutions, and apps. This course also covers how to develop and implement a governance plan, and how to perform an upgrade or a migration to SharePoint 2016.

This is the second in a sequence of two courses for IT Professionals and is aligned with the SharePoint 2016 IT Pro certification.

Audience Profile

The course is targeted at experienced IT Professionals who are interested in learning how to install, configure, deploy, and manage SharePoint 2016 installations either in a data center or in the cloud.

Students typically should have more than four years of hands-on experience* planning and maintaining SharePoint Server and other core technologies upon which SharePoint depends, including Windows Server 2012 R2 or later, Internet Information Services (IIS), Microsoft SQL Server 2014 R2 or later, Active Directory Domain Services (AD DS), and networking infrastructure services.

Students should have completed Course 20339-1A: Planning and Administering Microsoft SharePoint 2016, or have gained equivalent knowledge and experience before taking this course.

The minimally qualified candidate typically:

• Has a working knowledge of, and preferably hands-on experience, with Microsoft SharePoint Online.

• Has broad familiarity with SharePoint Server workloads.

• Has experience with business continuity management, including data backup, restoration, and high availability.

• Has experience with authentication and security technologies.

• Has experience with Windows PowerShell.

* The hands-on experience or job experience should be from a solutions-based role where the candidate has worked on multiple solutions in the SharePoint Server space that includes document management, content management, and search.

At Course Completion

After completing this course, students will be able to:

• Describe the core SharePoint 2016 architecture and its new and improved features.
• Describe the key hybrid features in SharePoint 2016.
• Plan and design a SharePoint 2016 environment to meet requirements for high availability and disaster recovery.
• Plan and implement Business Connectivity Services and Secure Store Service.
• Configure and manage productivity services for a SharePoint 2016 deployment.
• Manage solutions in a SharePoint 2016 deployment.
• Plan and configure social computing features.
• Plan and configure web content management for an Internet-facing environment.
• Plan and configure Enterprise Content Management in a SharePoint 2016 deployment.
• Plan and configure business intelligence solutions.
• Plan and configure work management, productivity, and collaboration platforms and features.
• Perform an upgrade or migration to SharePoint 2016.

Learn about Office 365 Management, including key components of Office 365, how to move an organization to Office 365, how to configure Office 365, and how to manage Office 365 ProPlus deployments.

Audience profile

This course is designed for persons who are aspiring to the Microsoft 365 Enterprise Admin role and have completed one of the Microsoft 365 role-based administrator certification paths.

Skills gained

• Office 365 overview
• Moving an organization to Office 365
• Configuring Office 365
• Managing Office 365 ProPlus deployments

This three-day instructor-led course provides students moving from earlier releases of SQL Server with an introduction to the new features in SQL Server 2016.

Skills gained

• Describekey capabilities and components of SQL Server 2016
• Describe new and enhanced features in SQL Server performance
• Describes new and enhanced features in SQL Server security
• Describe what’s new inSQL Server Availability and Scalability
• Describe new and enhanced features in reporting and PowerBIin SQL Server 2016
• Describe new and enhanced data access features
• Describe new and enhanced features in SQL Server OLAP
• Describenew SQL Server cloud functionality

This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2014 database. The course focuses on teaching individuals how to use SQL Server 2014 product features and tools related to maintaining a database.

Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.

This five-day instructor-led course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer an SQL server database infrastructure. Additionally, it will be of use to individuals who develop applications that deliver content from SQL Server databases.

This course is designed to teach students how to provision SQL Server databases both on premise and in SQL Azure.

This one day class is designed for SharePoint team members and end users who need to know how to use the team collaboration, document management and social features of Microsoft SharePoint 2016. This class features live inline interactive labs where the student interacts with both SharePoint and other students.

Skills gained

• Navigate SharePoint sites.
• Manage content in lists and libraries.
• Create and edit Alerts.
• Collaborate using Tasks lists, Calendars and Document libraries.
• Work with libraries, including upload, download, editing, content approval, check out/in and versioning.
• Use the SharePoint social features.
• Use OneDrive for Business.

This instructor-led, live training in Botswana (online or onsite) is aimed at advanced-level professionals who wish to develop expertise in designing and managing complex knowledge management systems within Notion.

By the end of this training, participants will be able to:

• Create advanced databases and relational structures.
• Design dynamic dashboards for real-time data visualization.
• Implement customized knowledge management workflows.
• Develop interconnected content ecosystems.
• Maintain and optimize large-scale knowledge systems.

This instructor-led, live training in Botswana (online or onsite) is aimed at beginner-level professionals who wish to learn the fundamental features of Notion for team productivity and organization.

By the end of this training, participants will be able to:

• Understand Notion’s workspace structure and navigation.
• Create and organize team tasks, notes, and documents.
• Utilize templates, databases, and custom views to manage projects.
• Collaborate effectively using shared workspaces and real-time editing.
• Apply productivity techniques to optimize workflow in Notion.

This instructor-led, live training in Botswana (online or onsite) is aimed at intermediate-level professionals who wish to develop practical skills in leveraging Notion’s collaboration and project management features to enhance team productivity, streamline communication, and efficiently manage shared tasks and resources.

By the end of this training, participants will be able to:

• Set up team workspaces for collaborative project management.
• Create project boards, task lists, and shared documentation.
• Leverage Notion databases to track progress and manage resources.
• Utilize templates for efficient project planning and reporting.
• Collaborate in real-time using shared pages and communication tools.

This instructor-led, live training in Botswana (online or onsite) is aimed at advanced-level professionals who wish to leverage Tana’s AI capabilities and automation to supercharge workflows and optimize team collaboration.

By the end of this training, participants will be able to:

• Utilize Tana’s AI-powered features for workflow automation.
• Set up and customize advanced automations within Tana.
• Integrate AI-driven knowledge management into team collaboration.
• Optimize data retrieval, task execution, and decision-making with AI tools.

This instructor-led, live training in Botswana (online or onsite) is aimed at intermediate-level professionals who wish to utilize Tana for team collaboration, knowledge sharing, and workflow automation.

By the end of this training, participants will be able to:

• Set up and structure a collaborative workspace in Tana.
• Use nodes and supertags for efficient team knowledge management.
• Streamline project and task management with Tana’s automation features.
• Enhance team collaboration through shared documentation and workflows.
• Integrate Tana with other business tools for seamless productivity.

This instructor-led, live training in Botswana (online or onsite) is aimed at beginner-level professionals who wish to learn the fundamentals of Tana for knowledge management and workflow optimization.

By the end of this training, participants will be able to:

• Navigate Tana’s interface and workspace structure.
• Capture, structure, and retrieve information efficiently.
• Utilize supertags and nodes for dynamic knowledge organization.
• Set up task management workflows using Tana’s features.
• Leverage search and filtering tools to access information quickly.
• Integrate Tana into daily work processes for improved productivity.