Microsoft To Do Essentials - 1 Day Training Course

About This Course

This three-day instructor-led course is designed for individuals aiming to transition into a database professional role or whose current job responsibilities are expanding to include database components. The course covers fundamental database concepts, including various database types, languages, and design principles.

Audience Profile

The primary audience for this course consists of individuals who are moving into a database role or whose roles have 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 is a three-day Instructor-Led Training (ILT) programme designed for the needs of information technology (IT) professionals who are involved in administering, configuring, troubleshooting, and operating Office 365 services. The course covers identities, dependencies, requirements, and supporting technologies. It concentrates on the skills required to administer and troubleshoot Office 365 tenants and key services, such as Exchange Online, SharePoint Online, and Teams. Additionally, it addresses the security and compliance features of Office 365.

Audience Profile

This course is intended for IT professionals and system administrators who wish to gain knowledge of administration and troubleshooting techniques in Office 365. Participants should have at least three years of experience in their respective fields, ideally in system administration, network administration, and messaging.

At Course Completion

Upon completing this course, students will be able to:

• Describe Office 365 services.
• Administer Office 365 by using the Microsoft 365 admin center and Office 365 services admin centers.
• Administer and troubleshoot directory synchronization and directory objects.
• Administer and troubleshoot Exchange Online.
• Administer and troubleshoot Teams.
• Administer and troubleshoot SharePoint Online.
• Plan and deploy Microsoft 365 Apps for enterprise.
• Administer and troubleshoot compliance and security in Office 365.

About This Course

This five-day course will equip you with the necessary knowledge and skills to plan and administer a Microsoft SharePoint 2016 environment. You will learn 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 centre 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.

Participants will gain the ability to efficiently carry out a range of calculations in a clear manner, arrange and present their findings, utilise various tools to streamline and speed up spreadsheet creation, and safeguard their calculations and results against unauthorised access.

Participants will learn to master Excel in the most efficient manner, enabling them to create, consolidate, and manage data effectively. The tools introduced in this course streamline workflows, significantly reducing the time previously required for various activities. Additionally, learners will gain the ability to design applications capable of performing new tasks.

Enhance your VBA proficiency to an intermediate level by mastering custom interfaces, complex data types, conditional logic, looping constructs, and professional debugging techniques. This practical Excel VBA training programme focuses on robust error handling, performance optimization, VBA UserForms, and workflow automation through real-world exercises. It bridges the gap between basic macros and advanced automation solutions, catering to data analysts, reporting professionals, and business users aiming to leverage enterprise-grade spreadsheet capabilities.

Achieve mastery of Microsoft Excel through this professional training course, specifically designed to improve your spreadsheet efficiency and productivity. Gain essential skills such as editing worksheets, managing workbooks, constructing complex formulas with powerful functions, formatting cells, creating professional charts and graphs, working with PivotTables and data lists, and managing graphic objects. This course is ideal for business analysts, accountants, data handlers, and office professionals who wish to advance their Excel proficiency from an intermediate to an expert level. Enhance your data analysis capabilities, streamline reporting processes, and unlock the full potential of Microsoft Excel for better decision-making and workplace productivity.

In this whiteboard design session, you will learn how to design a solution with a combination of Azure Resource Manager templates and Azure DevOps to enable continuous delivery with several Azure PaaS services.

At the end of this workshop, you will be better able to build templates to automate cloud infrastructure and reduce error-prone manual processes. In addition, you'll create an Azure Resource Manager (ARM) template to provision Azure resources, configure continuous delivery with Azure DevOps, configure Application Insights into an application, and create an Azure DevOps project and Git repository.

This course equips IT professionals with the skills to manage Azure subscriptions, secure identities, administer infrastructure, configure virtual networking, connect Azure with on-premises environments, manage network traffic, implement storage solutions, create and scale virtual machines, deploy web apps and containers, back up and share data, and monitor overall solutions.

Designed for Azure Administrators, this training covers the implementation, management, and monitoring of identity, governance, storage, compute, and virtual networks within a cloud environment. Azure Administrators will learn to provision, size, monitor, and adjust resources as required.

About This Course

Dynamics 365 Finance and Operations applications include, among others, Dynamics 365 Finance, Dynamics 365 Supply Chain Management, and Dynamics 365 Supply Chain Management, Manufacturing. Dynamics 365 Finance empowers you to: Automate and modernise your global financial operations. Monitor performance in real time, predict future outcomes, and make data-driven decisions to drive business growth. Drive strategic financial decisions with artificial intelligence (AI), unify and automate your financial processes, reduce operational expenses, and decrease global financial complexity and risk. Dynamics 365 Supply Chain Management enables you to: Transform your manufacturing and supply chain operations. Use predictive insights and intelligence from AI and the Internet of Things (IoT) across planning, production, inventory, warehouse, and transportation management. Maximise operational efficiency, product quality, and profitability. Innovate with intelligent manufacturing operations, modernise warehouse management, optimise production performance, maximise the life of your assets, and automate and streamline your supply chain. Note: For more information, please refer to https://docs.microsoft.com/learn/paths/get-started-finance-operations/ In this module, we will focus on the core features and functionality for Dynamics 365 Dynamics 365 Finance apps that are most used by end users and consultants.

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. The Functional Consultant implements a solution using out of the box capabilities, codeless extensibility, application and service integrations.

At Course Completion

After completing this course, students will be able to:

• How to navigate and efficiently use search, filtering and queries
• How to use operational workspaces
• Work with Business Document Management
• Work with record templates
• Integrate Power BI with Dynamics 365 Finance and Operations apps
• How to personalize workspaces
• Identify when to use Power Platform in Dynamics 365 Finance and Operations app.
• How to apply security roles to users
• Run and analyze security reports
• Create and use workflow for approval
• Work with Organization Hierarchy and its purposes.
• How to use personalization feature
• Use Data Management workspace
• Create and use and entity templates
• Copy configuration data between legal entities
• Import and Export data and manage data by using Office Integration
• Use 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

About This Programme

This course provides developer training for Microsoft Dynamics 365 Finance and Operations Apps Developers, who implement and enhance applications to align with business needs. Candidates deliver complete solutions by leveraging standardised coding patterns, extensible features, and external integrations.

Target Audience

Microsoft Dynamics 365 Finance and Operations Apps Developers

This 5-day instructor-led training (ILT) course is designed for IT professionals who evaluate, plan, deploy, and operate Microsoft Office 365 services, encompassing identities, dependencies, requirements, and supporting technologies. The course focuses on the skills needed to set up an Office 365 tenant, including federation with existing user identities, and the skills required to maintain an Office 365 tenant and its users.

This course is intended for IT professionals responsible for planning, configuring, and managing an Office 365 environment. Students attending this course are expected to have a broad understanding of several on-premises technologies, such as Domain Name System (DNS) and Active Directory Domain Services (AD DS). Additionally, they should have a general understanding of Microsoft Exchange Server, Microsoft Lync Server or Skype for Business Server, and Microsoft SharePoint Server.

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

• Plan an Office 365 deployment, configure the Office 365 tenant, and plan a pilot deployment.
• Manage Office 365 users, groups, and licenses, and configure delegated administration.
• Plan and configure client connectivity to Office 365.
• Plan and configure directory synchronization between Microsoft Azure AD and on-premises AD DS.
• Plan and implement the Office 365 ProPlus deployment.
• Plan and manage Microsoft Exchange Online recipients and permissions.
• Plan and configure Exchange Online services.
• Plan and configure Microsoft Teams
• Plan and configure Microsoft SharePoint Online.
• Plan and configure an Office 365 collaboration solution.
• Plan and configure the integration between Office 365 and Microsoft Azure Information Protection.
• Monitor and review Office 365 services, and troubleshoot Office 365 issues.
• Plan and implement identity federation between on-premises AD DS and Azure AD.

This course is designed for persons aspiring to the Microsoft 365 Administrator role and have completed at least one of the Microsoft 365 role-based administrator certification paths.

About This Course

This course provides foundational knowledge on the considerations and benefits of adopting cloud services and the Software as a Service (SaaS) cloud model, with a specific focus on Microsoft 365 cloud service offerings. You will begin by learning about cloud fundamentals, including an overview of cloud computing and specifically Microsoft cloud services. You will be introduced to Microsoft Azure, and you will examine the differences between Microsoft 365 and Office 365. You will then perform an in-depth review of Microsoft 365, including a comparison of Microsoft on-premises services versus Microsoft 365 cloud services, a review of enterprise mobility in Microsoft 365, and an analysis of how Microsoft 365 services provide collaboration. The course then analyzes how security, compliance, privacy, and trust are handled in Microsoft 365, and it concludes with a review of Microsoft 365 subscriptions, licenses, billing, and support.

Audience Profile

This course is designed for Business Decision Makers and IT Professionals who aspire to deploy cloud services in their organization, or who are simply looking to acquire foundational knowledge on cloud fundamentals. This includes the considerations and benefits of adopting cloud services in general and the Software as a Service (SaaS) cloud model specifically, with a general focus on Microsoft 365 cloud service offerings.

At Course Completion

After completing this course, students will be able to:

• Differentiate between the various cloud service models.
• Identify the key differences between Microsoft 365 subscriptions.
• Plan for migration to Microsoft 365 services.
• Identify key differences between Microsoft on-premises services and Microsoft 365 cloud services.
• Identify how Microsoft 365 services support teamwork.
• Describe identities, including cloud, on-premises, and hybrid identity.
• Describe cloud device management and protection, including the use of Intune.
• Describe data protection, including the use of Azure Information Protection.
• Describe compliance in general and the compliance features in Microsoft 365.
• Describe Microsoft 365 subscriptions, licenses, billing, and support

This five-day instructor-led course is primarily tailored for IT professionals who already possess some experience with Windows Server. It is designed for those who will be responsible for managing identity, networking, storage, and compute resources using Windows Server 2019, and who need to understand the scenarios, requirements, and options available and applicable to this version. The course equips IT professionals with the fundamental administration skills required to deploy and support Windows Server 2019 in most organisations.