Microsoft To Do Essentials - 1 Day Training Course

Course Overview

This three-day, instructor-led programme is designed for individuals aspiring to become database professionals or those whose current roles are increasingly involving database responsibilities. The course provides a comprehensive overview of essential database concepts, including various database types, relevant database languages, and fundamental design principles.

Target Audience

The primary participants for this course are professionals transitioning into database-related roles or those whose existing responsibilities have expanded to include database technologies.

Learning Outcomes

Upon successful completion of this course, learners will be equipped to:
• Explain core database concepts within the context of SQL Server 2016
• Identify and describe the database languages utilized in SQL Server 2016
• Outline data modelling methodologies
• Differentiate between normalization and denormalization techniques
• Detail relationship types and their implications in database design
• Assess the impact of database design choices on system performance
• Recognize commonly used database objects

About This Course

This three-day Instructor-Led Training (ILT) programme is designed to meet the needs of IT professionals involved in administering, configuring, troubleshooting, and managing Office 365 services. The curriculum covers essential topics such as identities, dependencies, prerequisites, and supporting technologies. Emphasis is placed on the skills required to manage and resolve issues within an Office 365 tenant, focusing on core services including Exchange Online, SharePoint Online, and Teams. The course also provides comprehensive coverage of security and compliance capabilities inherent to Office 365.

Audience Profile

This programme is intended for IT professionals and system administrators seeking to master administration and troubleshooting techniques within Office 365. Participants are expected to possess a minimum of three years of professional experience, ideally in system administration, network administration, or messaging environments.

At Course Completion

Upon successful completion of this course, students will be equipped to:

• Explain the various services offered by Office 365.
• Administer Office 365 utilizing the Microsoft 365 admin center, Office 365 services admin centers, and associated tools.
• Administer and resolve issues related to 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 measures within Office 365.

About This Course

Over the course of five days, this programme equips you with the essential knowledge and skills required to plan and administer a Microsoft SharePoint 2016 environment. You will learn how to deploy, manage, and troubleshoot your SharePoint setup. Additionally, the course offers guidelines, industry best practices, and key considerations to help you optimise your SharePoint deployment.

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

Audience Profile

This course is aimed at experienced IT professionals keen on learning how to install, configure, deploy, and manage SharePoint 2016 installations in either data centre or cloud environments.

Typical students possess over one year of hands-on experience* with planning and maintaining SharePoint, alongside two years of experience with core technologies that SharePoint relies on. These include 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 responsible for planning, implementing, and maintaining a multi-server deployment of SharePoint 2016.
• Has practical knowledge of, and preferably hands-on experience with, SharePoint Online.
• Is broadly familiar 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 or job experience should stem from a solutions-based role where the candidate has worked on multiple solutions within the SharePoint space, encompassing 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 enhance their Excel proficiency to optimally create, consolidate, and manage data. By leveraging specialized tools that streamline workflows, you can significantly reduce the time previously required for these tasks and develop applications capable of performing new, automated functions.

Elevate your VBA proficiency to an intermediate standard by mastering custom interfaces, complex data types, conditional logic, looping constructs, and professional debugging methodologies. This practical Excel VBA training imparts robust error handling, performance optimization, VBA UserForms, and workflow automation through real-world exercises, bridging the gap from basic macros to advanced automation solutions for data analysts, reporting professionals, and business users aiming to leverage enterprise-grade spreadsheet capabilities.

Master Microsoft Excel through this professional training course designed to significantly boost 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 handling graphic objects. This course is ideal for business analysts, accountants, data handlers, and office professionals aiming to advance their Excel proficiency from intermediate to expert level. Enhance your data analysis capabilities, streamline reporting workflows, and unlock the full power 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 sites, manage network traffic, implement storage solutions, create and scale virtual machines, deploy web apps and containers, back up and share data, and monitor your solutions.

This course is designed for Azure Administrators. The Azure Administrator manages, implements, and monitors identity, governance, storage, compute, and virtual networks within a cloud environment. The Azure Administrator provisions, sizes, monitors, and adjusts resources as necessary.

About This Course

Dynamics 365 Finance and Operations apps encompass, but are not limited to, Dynamics 365 Finance, Dynamics 365 Supply Chain Management, and Dynamics 365 Supply Chain Management, Manufacturing. Dynamics 365 Finance enables you to: Automate and modernize 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 helps 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. Maximize operational efficiency, product quality, and profitability. Innovate with intelligent manufacturing operations, modernize warehouse management, optimize production performance, maximize 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 Course

Designed for developers, this course equips Microsoft Dynamics 365 Finance and Operations Apps Developers with the skills to implement and extend applications that align with business needs. Participants will deliver complete solutions by leveraging standardized coding patterns, extensible features, and external integrations.

Audience Profile

Microsoft Dynamics 365 Finance and Operations Apps Developers

This 5-day instructor-led training (ILT) course is designed to meet the requirements of IT professionals involved in evaluating, planning, deploying, and operating Microsoft Office 365 services. It covers essential identities, dependencies, requirements, and supporting technologies. The curriculum emphasizes the skills needed to set up an Office 365 tenant, including federation with existing user identities, as well as the capabilities required to maintain an Office 365 tenant and its users.

This course targets IT professionals responsible for planning, configuring, and managing an Office 365 environment. Participants are expected to possess a broad understanding of various on-premises technologies, such as Domain Name System (DNS) and Active Directory Domain Services (AD DS). Additionally, they should have a general knowledge 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 tailored for professionals aspiring to the Microsoft 365 Administrator role who have completed at least one of the Microsoft 365 role-based administrator certification paths.

About This Course

This course delivers essential knowledge regarding the considerations and advantages of adopting cloud services and the Software as a Service (SaaS) cloud model, with a specific emphasis on Microsoft 365 cloud offerings. You will start by gaining an understanding of cloud fundamentals, including a broad overview of cloud computing and Microsoft cloud services in particular. You will be introduced to Microsoft Azure and explore the distinctions between Microsoft 365 and Office 365. The course then delves deeply into Microsoft 365, comparing Microsoft on-premises services with Microsoft 365 cloud services, reviewing enterprise mobility within Microsoft 365, and analysing how these services facilitate collaboration. Subsequently, the course examines how security, compliance, privacy, and trust are managed within Microsoft 365, concluding with a review of subscriptions, licenses, billing, and support options for Microsoft 365.

Audience Profile

This course is tailored for Business Decision Makers and IT Professionals who aim to deploy cloud services within their organisations or seek foundational knowledge on cloud basics. This includes understanding the considerations and benefits of adopting cloud services generally, and the Software as a Service (SaaS) cloud model specifically, with a primary focus on Microsoft 365 cloud service offerings.

At Course Completion

Upon completing this course, students will be able to:

• Differentiate between 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.

Spanning five days, this instructor-led programme is tailored for IT professionals who possess prior experience with Windows Server. It targets those tasked with managing identity, networking, storage, and compute resources using Windows Server 2019, aiming to provide a comprehensive understanding of the scenarios, requirements, and options relevant to this platform. The course equips IT staff with the fundamental administration skills necessary to deploy and support Windows Server 2019 across a wide range of organizational environments.