Microsoft 365 Essentials: Teams, Word, and Excel Training Course

Course Description

This three-day instructor-led training is designed for professionals seeking to transition into database administration roles or those whose current responsibilities are expanding to include database management for government systems. The curriculum covers foundational database concepts, including classification, programming languages, and architectural design.

Target Audience

The primary target for this course is individuals entering database-focused positions or those whose professional scope now incorporates database technologies.

Learning Outcomes

Upon successful completion of this course, participants will be able to:
• Identify core database concepts within the SQL Server 2016 framework
• Specify the database languages utilized in SQL Server 2016
• Outline data modeling methodologies
• Explain normalization and denormalization procedures
• Define relationship types and their implications for database design
• Evaluate the impact of database design on system performance
• Identify common database objects for government use

About This Course

This three-day Instructor-Led Training (ILT) course is designed to meet the operational requirements of information technology (IT) professionals responsible for administering, configuring, and maintaining Office 365 services. The curriculum addresses identities, dependencies, system requirements, and supporting technologies. Primary focus is placed on the skills necessary for the administration and troubleshooting of the Office 365 tenant and core services, including Exchange Online, SharePoint Online, and Microsoft Teams. Additionally, the course covers security frameworks and compliance mandates relevant to government operations.

Audience Profile

This course is intended for IT professionals and system administrators seeking to master administration and troubleshooting techniques within the Office 365 ecosystem. Participants should possess at least three years of professional experience in relevant fields, with preferred backgrounds in system administration, network administration, and messaging infrastructure.

Course Outcomes

Upon completion of this course, participants will be able to:

• Describe the capabilities of Office 365 services.
• Administer Office 365 using the Microsoft 365 admin center and Office 365 service-specific admin centers, for government compliance and efficiency
• Administer and troubleshoot directory synchronization and directory objects.
• Administer and troubleshoot Exchange Online.
• Administer and troubleshoot Microsoft Teams.
• Administer and troubleshoot SharePoint Online.
• Plan and deploy Microsoft 365 Apps for enterprise.
• Administer and troubleshoot compliance and security settings in Office 365.

Course Description

This five-day instructional course equips participants with the expertise necessary to plan, administer, and maintain a Microsoft SharePoint 2016 environment. The curriculum covers the deployment, administration, and troubleshooting of SharePoint systems. Additionally, it provides regulatory guidelines, industry best practices, and strategic considerations to optimize SharePoint deployments for government operations.

This is the introductory course in a two-part series designed for IT professionals and aligns with the SharePoint 2016 IT Pro certification standards.

Target Audience

This course is intended for experienced IT professionals who seek to master the installation, configuration, deployment, and management of SharePoint 2016 in both data center and cloud-based contexts.

Participants typically possess more than one year of hands-on experience* in planning and maintaining SharePoint systems, along with two years of experience in core supporting technologies, 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.

A minimally qualified candidate typically meets the following criteria:

• Is an IT professional responsible for planning, implementing, and maintaining multi-server SharePoint 2016 deployments for government and public sector use.
• Has practical knowledge and, preferably, hands-on experience with SharePoint Online.
• Has a comprehensive understanding of SharePoint workloads.
• Has experience with business continuity management, including data backup, recovery, and high availability strategies.
• Has experience with authentication and security technologies.
• Has experience with Windows PowerShell.

* The hands-on or job experience should derive from a solutions-focused role where the candidate has managed multiple SharePoint initiatives, including document management, content management, and search services for government entities.

Learning Objectives

• Describe the primary features and capabilities 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.

This curriculum is designed to equip IT professionals with the capabilities required to administer Azure subscriptions, enforce identity security, oversee infrastructure operations, configure virtual networking, establish connectivity between Azure and on-premises environments, regulate network traffic, deploy storage architectures, provision and scale virtual machines, implement web applications and containers, execute data backup and sharing protocols, and monitor solution performance for government operations.

Targeted at Azure Administrators, this training addresses the responsibilities of implementing, managing, and monitoring identity, governance, storage, compute, and virtual network resources within cloud environments. Azure Administrators are responsible for provisioning, sizing, observing, and adjusting resources to ensure compliance and operational efficiency.

This instructor-led, live training in US (delivered online or on-site) is designed for entry-level IT professionals seeking to acquire knowledge of Microsoft Azure and cloud computing principles.

Upon completion of this training, participants will be equipped to:

• Comprehend fundamental cloud computing concepts.
• Recognize core Azure service offerings.
• Explain core solutions and administrative tools available in Azure.
• Understand general security and network security protocols.
• Understand identity management, governance, privacy, and compliance frameworks.
• Understand Azure cost management practices and Service Level Agreements (SLAs).

Course Overview

This course outlines the various methods and best practices aligned with business and technical requirements for modeling, visualizing, and analyzing data using Power BI. It demonstrates how to access and process data from a range of sources, including both relational and non-relational databases. Additionally, the course explores the implementation of appropriate security standards and policies across the Power BI environment, including datasets and user groups. It further addresses the management and deployment of reports and dashboards for secure sharing and content distribution.

Target Audience

This course is designed for data professionals and business intelligence specialists seeking to master accurate data analysis using Power BI. It is also tailored for individuals who develop reports that visualize data from platform technologies hosted in the cloud or on-premises.

Acquired Skills

• Ingest, clean, and transform data
• Model data for performance and scalability
• Design and create reports for data analysis
• Apply and perform advanced report analytics
• Manage and share report assets

About This Course

Dynamics 365 Finance and Operations applications include, but are not limited to, Dynamics 365 Finance, Dynamics 365 Supply Chain Management, and Dynamics 365 Supply Chain Management, Manufacturing. Dynamics 365 Finance assists in the following: Automating and modernizing global financial operations. Monitoring performance in real time, predicting future outcomes, and making data-driven decisions to drive business growth. Driving strategic financial decisions with artificial intelligence (AI), unifying and automating financial processes, reducing operational expenses, and decreasing global financial complexity and risk for government entities. Dynamics 365 Supply Chain Management assists in the following: Transforming manufacturing and supply chain operations. Using predictive insights and intelligence from AI and the Internet of Things (IoT) across planning, production, inventory, warehouse, and transportation management. Maximizing operational efficiency, product quality, and profitability. Innovating with intelligent manufacturing operations, modernizing warehouse management, optimizing production performance, maximizing the life of assets, and automating and streamlining the supply chain for government operations. Note: For more information, please refer to https://docs.microsoft.com/learn/paths/get-started-finance-operations/ In this module, the focus is on the core features and functionality of Dynamics 365 Finance applications that are most frequently utilized by end users and consultants in the public sector.

Audience Profile

A Dynamics 365 for Finance and Operations Functional Consultant is responsible for performing discovery, capturing requirements, engaging subject matter experts and stakeholders, translating requirements, and configuring the solution and applications for government use. The Functional Consultant implements a solution using out-of-the-box capabilities, codeless extensibility, application and service integrations, and adherence to public sector standards.

At Course Completion

Upon completing this course, participants will be able to:

• Navigate and efficiently use search, filtering, and queries
• Use operational workspaces
• Work with Business Document Management
• Work with record templates
• Integrate Power BI with Dynamics 365 Finance and Operations applications
• Personalize workspaces
• Identify when to use Power Platform in Dynamics 365 Finance and Operations applications for government workflows
• Apply security roles to users
• Run and analyze security reports
• Create and use workflow for approval
• Work with Organization Hierarchy and its purposes
• Use the personalization feature
• Use the Data Management workspace
• Create and use entity templates
• Copy configuration data between legal entities
• Import and export data and manage data using Office Integration
• Use the Regression Suite Automation Tool (RSAT)
• Create User Acceptance Tests (UAT) and test plans
• Create and work with Business Process Modeler (BPM)
• Understand how to use Issue search

This five-day instructor-led training (ILT) program is designed to address the operational requirements of IT professionals involved in the evaluation, strategic planning, deployment, and ongoing operation of Microsoft Office 365 services for government. The curriculum covers critical aspects of identity management, dependency mapping, requirement analysis, and supporting technologies. The course emphasizes the skills necessary to establish an Office 365 tenant, including identity federation with existing user directories, and the competencies required to maintain tenant integrity and user support.

This course is targeted at IT professionals accountable for the planning, configuration, and management of Office 365 environments for government. Participants are expected to possess a comprehensive understanding of key on-premises technologies, including Domain Name System (DNS) and Active Directory Domain Services (AD DS). Additionally, candidates should demonstrate general proficiency with Microsoft Exchange Server, Microsoft Lync Server or Skype for Business Server, and Microsoft SharePoint Server.

Upon successful completion of this course, participants will be capable of:

• Strategic planning of Office 365 deployments, configuration of the Office 365 tenant, and design of pilot initiatives.
• Management of Office 365 users, groups, and licenses, as well as configuration of delegated administrative roles.
• Planning and implementation of client connectivity to Office 365.
• Planning and configuration of directory synchronization between Microsoft Azure AD and on-premises AD DS.
• Strategic planning and execution of Office 365 ProPlus deployments.
• Management of Microsoft Exchange Online recipients and associated permissions.
• Configuration of Exchange Online service parameters.
• Planning and implementation of Microsoft Teams.
• Configuration of Microsoft SharePoint Online services.
• Development of Office 365 collaboration solutions.
• Integration of Office 365 with Microsoft Azure Information Protection.
• Monitoring of Office 365 services and resolution of operational issues.
• Implementation of identity federation between on-premises AD DS and Azure AD.

This curriculum is intended for professionals preparing for the Microsoft 365 Administrator role who have successfully completed at least one of the Microsoft 365 role-based administrator certification tracks.

Course Description

This course establishes a foundational understanding of the strategic implications and operational benefits associated with adopting cloud services, specifically within the Software as a Service (SaaS) model. The curriculum focuses on Microsoft 365 cloud service offerings, providing essential knowledge for public sector operations. Participants will first explore cloud computing fundamentals, including an examination of Microsoft’s specific cloud infrastructure. The course introduces Microsoft Azure and distinguishes the functional differences between Microsoft 365 and Office 365. A comprehensive review of Microsoft 365 follows, covering comparisons between on-premises and cloud-based services, enterprise mobility standards, and collaborative capabilities. The curriculum concludes with an analysis of security, compliance, privacy, and trust frameworks, as well as an examination of subscription structures, licensing, billing, and support models.

Target Audience

This course is tailored for business leaders and IT specialists in government and the public sector who are responsible for implementing cloud services or seeking to develop a robust understanding of cloud fundamentals. It addresses the strategic considerations and operational advantages of cloud adoption, with a primary focus on the SaaS model and the specific service portfolio of Microsoft 365.

Learning Objectives

Upon successful completion of this course, participants will be able to:

• Distinguish between distinct cloud service models.
• Recognize the key variations among Microsoft 365 subscription tiers.
• Develop strategies for migrating to Microsoft 365 services.
• Identify the operational distinctions between on-premises infrastructure and Microsoft 365 cloud services.
• Explain how Microsoft 365 services facilitate collaborative workflows.
• Define identity management concepts, including cloud-based, on-premises, and hybrid architectures.
• Describe cloud-based device management and protection strategies, including the application of Intune.
• Outline data protection measures, specifically the implementation of Azure Information Protection.
• Explain general compliance principles and specific compliance features within Microsoft 365.
• Describe the structures for Microsoft 365 subscriptions, licensing, billing, and support

This instructor-led, live training program, delivered either online or on-site, is structured to equip public sector professionals with the competencies necessary to pass the Microsoft Azure Administrator Associate (AZ-104) certification examination in US.

The curriculum addresses the technical requirements for overseeing Azure infrastructure, with specific focus on virtual machines, storage architectures, and network governance.

This instructor-led live training in US (online or on-site) is structured to assist participants in preparing for the Microsoft Azure Developer Associate (AZ-204) certification assessment.

The curriculum addresses the principles of engineering Azure solutions, encompassing compute, storage, and security capabilities. It delivers a thorough orientation to Azure development for government contexts, covering the essential tools and services required for application construction, validation, and deployment.

This instructor-led, live training in US (online or onsite) is structured to assist participants in preparing for the Microsoft Azure Solutions Architect Expert (AZ-305) certification examination.

The curriculum addresses advanced cloud computing concepts and Azure service capabilities. It offers a thorough overview of Azure solution architecture, encompassing its underlying principles, constituent components, and associated services. Participants will also acquire the skills necessary to design and deploy Azure solutions in accordance with best practices and industry standards.