50255 Managing Windows Environments with Group Policy

50255 Managing Windows Environments with Group Policy

Group Policy is one of the most powerful tools available to enterprise IT professionals—and one of the most misunderstood. This course demystifies Group Policy and teaches you how to use it to secure, configure, and streamline the management of your organization’s Windows Server 2016 systems and Windows clients. Through real-world scenarios and hands-on labs, you'll explore Group Policy processing architecture, implement security and administrative templates, and use PowerShell to manage and automate policies. Whether you're aiming to reduce costs, standardize configurations, or improve network security, this training will give you the experience and tools to do it confidently.

5 Days $2,995.00 excl.
  • Mon 12 Oct
    5 days, 09:00 AM – 05:00 PM
    • $2,995.00 excl.
  • Mon 11 Jan
    5 days, 09:00 AM – 05:00 PM
    • $2,995.00 excl.
None of these dates work for you? Suggest another date & time

Description

Module 1: Introduction to Configuration Management

  • Overview of configuration management via Group Policy
  • Newer features in modern Windows versions
  • Using PowerShell for policy management

Module 2: Using Group Policy Management Tools

  • Local and domain policies
  • GPMC walkthrough
  • Group Policy refresh cycles

Module 3: Designing a Group Policy Infrastructure

  • Planning and deploying GPOs
  • Managing and securing Group Policy design

Module 4: Understanding the Architecture of Group Policy Processing

  • GPO components in AD DS
  • Deployment order and processing
  • Customizing processing behavior

Module 5: Troubleshooting and Backing Up GPOs

  • Using RSOP and logging tools
  • Backups, imports, and migration tables

Module 6: Securing Windows Using Group Policy

  • Account security and firewall settings
  • Domain security implementation
  • Exploring Windows security policies

Module 7: Implementing Application Security Using Group Policy

  • UAC and malware protection
  • AppLocker configuration
  • App security best practices

Module 8: Configuring the Desktop Environment

  • Start menu, taskbar, and network settings
  • Control Panel and Windows component configurations
  • Printer and pruning management

Module 9: Implementing User State Virtualization

  • Folder redirection and offline files
  • User Experience Virtualization
  • OneDrive for Business integration

Module 10: Assigning and Publishing Software Packages

  • Using MSI and distribution points
  • Deploying with Group Policy and System Center

Module 11: Configuration Management with Windows PowerShell

  • PowerShell scripting for Group Policy
  • PowerShell-based logon scripts

Module 12: Implementing PowerShell Desired State Configuration

  • Comparing policy settings and preferences
  • Applying preference settings

Module 13: Configuring Group Policy Preferences

  • Introduction to preferences
  • Real-world preference configuration

Prerequisites

55344 Identity with Windows Server

Target Audience

This course is intended for Enterprise network staff responsible for help desk support, system administration, and network design.

Objectives

By the end of this course, you’ll be able to design and implement a robust Group Policy infrastructure and use it to manage security and configuration across your environment. You’ll also gain skills in scripting, troubleshooting, and automating Group Policy using PowerShell. Design and manage Group Policy Objects (GPOs) Secure Windows environments using GPOs Configure desktop environments and folder redirection Deploy software using MSI and Group Policy Manage Group Policy with Windows PowerShell Troubleshoot Group Policy issues

Similar courses

  • GH-500 GitHub Advanced Security

    GitHub Advanced Security (GHAS) plays a crucial role in enhancing the security posture of software development projects on GitHub. It provides a comprehensive set of tools and features designed to identify and address security vulnerabilities throughout the development lifecycle. By integrating security directly into the development process with GHAS, your team can build more secure and reliable software. The course will explore how to utilize GHAS to maximize security impact and understand GHAS and its role in the security ecosystem.

  • DP-3001 Migrate SQL Server workload to Azure SQL

    This learning path prepares you for the task of migrating SQL Server workloads to Azure SQL Database. You'll learn how to assess SQL Server components and compatibility for migration using the Azure SQL Migration Extension and Database Migration Assistant. This training guides you through the process of provisioning and configuring Azure SQL Database resources. You gain hands-on experience in choosing the best migration option to meet business requirements for downtime, handling migration state, and monitoring database migration. Additionally, you'll also learn to perform post-migration tasks like disaster recovery and monitoring for Azure SQL Database. These skills are essential for ensuring a smooth, efficient transition to Azure SQL Database, and maintaining its operation post-migration.

  • AZ-1002 Configure secure access to your workloads using networking with Azure Virtual Network

    In this learning path, you practice configuring secure access to workloads using Azure networking.

  • MS-4014 Build a foundation to build AI agents and extend Microsoft 365 Copilot

    This course explores extending Copilot's capabilities with Microsoft Graph connectors and custom engine copilots, guiding participants to choose the best development path. It concludes with agent management in the Microsoft 365 admin center.

  • SC-5003 Implement information protection and data loss prevention by using Microsoft Purview

    Gain the skills to use Microsoft Purview to improve your data security in Microsoft 365. In this training, you learn how to create sensitive information types, create sensitivity labels, and use auto-labeling policies based on these labels. You also learn how to set up DLP (Data Loss Prevention) policies to safeguard your organization's data.

  • MS-700T00 Manage Microsoft Teams

    MS-700T00: Manage collaboration and communication with Microsoft Teams is designed for persons who are aspiring to the Microsoft 365 Teams Admin role. A Microsoft Teams administrator plans, deploys, configures, and manages Microsoft Teams to focus on efficient and effective collaboration and communication in a Microsoft 365 environment. In this course, you will learn about various Teams management tools, security and compliance feature for Teams, network requirement for Teams deployment as well as different Teams settings and policies for managing collaboration and communication experience in Teams.

  • SC-5008 Configure and Govern Entitlement with Microsoft Entra ID

    In today's digital landscape, managing access and entitlements is crucial for safeguarding sensitive information and ensuring compliance. This intensive one-day course offers a deep dive into Microsoft Entra Entitlement Management, Access Reviews, Privileged Access, and Monitoring. Participants will learn how to streamline access management with Entitlement Management, conduct thorough Access Reviews to maintain least privilege, manage high-risk Privileged Access, and implement robust Monitoring strategies to detect and respond to security events promptly. By the end of the training, attendees will be equipped with the best practices and actionable insights to enhance their organization's security posture.

  • MS-4022 Extend Microsoft 365 Copilot in Copilot Studio

    Build agents that extend Microsoft 365 Copilot with additional knowledge and capabilities. Use Copilot Studio to build declarative agents, add knowledge, add actions, and publish agents to Microsoft 365 Copilot.

  • AZ-2001T00 Implement security through a pipeline using Azure DevOps

    This learning path helps you prepare for the Implement security through a pipeline assessment using Azure DevOps. Learn how to configure and secure Azure Pipelines. You'll also get opportunities to practice hands-on skills. These skills include configuring secure access to pipeline resources, configuring, and validating permissions, configuring a project and repository structure, extending a pipeline, configuring pipelines to use variables and parameters securely, and managing identity for projects, pipelines, and agents.

  • MS-721T00 Plan, configure, and manage collaboration communications systems with Microsoft Teams

    This training course is designed to give participants the knowledge and skills to become a Collaboration Communications Systems Engineer. Participants should understand the fundamentals of networking, telecommunications, audio/visual and meeting room technologies, identity and access management, and Microsoft Teams. They will gain hands-on experience configuring and deploying Microsoft Teams Phone, meetings and certified devices including Microsoft Teams Rooms and Surface Hub. The course will also cover how to manage and monitor Teams Phone, meetings, and certified devices using the Microsoft Teams admin center, PowerShell, the Microsoft Teams Rooms Pro Portal, and the Call Quality Dashboard. In addition, the course will cover configuring and deploying Microsoft Teams Phone with PSTN connectivity through Microsoft Calling Plans, Operator Connect, Teams Phone Mobile, and Direct Routing.

  • 55399 Implementing and Managing Microsoft Intune

    Still spending hours manually setting up new devices? For IT teams managing hybrid and remote workforces, traditional provisioning is slow, costly, and unsustainable. Microsoft Intune changes that. Organizations using Intune have cut help desk calls by 53% and improved IT productivity by 25% by streamlining device setup, app deployment, and endpoint security from the cloud. In this three-day, hands-on course, you’ll learn how to enroll and configure devices with Microsoft Intune, automate provisioning with Windows Autopilot, deploy applications at scale, and apply consistent security policies using Conditional Access, Endpoint Analytics, and other advanced tools.

  • DP-3021 Configure and migrate to Azure Database for PostgreSQL

    Azure Database for PostgreSQL is a Platform as a Service database service in the Microsoft cloud. It bases itself on the PostgreSQL open-source relational database and includes built-in high availability, automatic backup and restore, as well as comprehensive security features. The pay-as-you-go pricing model provides predictable performance and near-instant scaling. In this learning path, you learn the main features of PostgreSQL and how they work in Azure Database for PostgreSQL. You learn about the different Azure Database for PostgreSQL implementation options, and how to configure a server for your needs.

  • AZ-2007 Accelerate app development by using GitHub Copilot

    Learn how to accelerate app development by using GitHub Copilot and GitHub Copilot Chat in a Visual Studio Code environment.

  • Microsoft Power BI – Data Analysis Practitioner

    As technology progresses and becomes more interwoven with our businesses and lives, more data is collected about business and personal activities. This era of "big data" has exploded due to the rise of cloud computing, which provides an abundance of computational power and storage, allowing organizations of all sorts to capture and store data. Leveraging that data effectively can provide timely insights and a competitive advantage.

  • SC-5007 Implement Retention, eDiscovery, and Communication Compliance in Microsoft Purview

    Manage data lifecycle, records management, eDiscovery, and communication compliance with Microsoft Purview.

  • Power BI for Data-driven Decision Makers

    As data acquisition, access, analysis, and reporting are interwoven with our businesses and lives, more and more data is collected about business and personal activities. This abundance of data and the computing power to analyze it has increased the use of data analysis and data visualization across a broad range of job roles. Decision makers of all types, including managers and executives, must interact with, interpret, and develop reports based on data and analysis provided to them. Microsoft Power BI software is designed for data analysis and the creation of visualizations. Data analysts prepare data, perform initial analysis, and create visualizations that are then passed to business data decision makers. These decision makers can use Power BI's tools to explore the data, perform further analysis to find new insights, make decisions, and create customized reports to share their findings.

  • 55339 Programming in C#

    This five- day training course teaches developers the programming skills that are required to create applications using the C# language. During their five days in the classroom, students review the basics of C# program structure, language syntax, and implementation details, and then consolidate their knowledge throughout the week as they build an application that incorporates several features of .NET. The course aims to follow the spirit of the Microsoft Official Curriculum course 20483, while bringing it completely up-to-date with the latest features of C#, .NET 6.0 and Visual Studio 2022. 55339A is the equivalent of the retired MOC Course 20483CC – Programming in C#.

  • AZ-1004 Deploy and configure Azure Monitor

    In this learning path, you practice implementing Azure Monitor to collect, analyze and act on monitoring telemetry from Azure environments. You learn to configure and interpret monitoring for virtual machines, networking, and web applications.

  • DP-604T00 Implement a data science and machine learning solution for AI with Microsoft Fabric

    This course is designed to build practical skills in implementing data science and machine learning solutions using Microsoft Fabric. The course explores the complete end-to-end data science process, from understanding and exploring data to preparing and transforming datasets for analysis. Students will learn how to train, evaluate, and track machine learning models, as well as how to deploy those models and generate predictions using Microsoft Fabric tools and capabilities.

  • AZ-040T00 Automate Administration with PowerShell

    Can you confidently manage and automate Windows Server environments using PowerShell? Over 90% of IT professionals now use PowerShell for automating administration, reducing repetitive tasks, and streamlining Microsoft server and cloud operations. This AZ-040T00 Automating Administration with PowerShell training teaches IT professionals how to use PowerShell for administering and automating administration of Windows Server, Microsoft Azure, Microsoft 365, and other Microsoft platforms. The course provides students with the fundamental knowledge and skills to use PowerShell commands and build scripts to accomplish advanced tasks such as automating repetitive tasks and generating reports. You’ll learn how to automate administration of Windows servers and remote computers, schedule jobs, manage Active Directory and Microsoft 365, and use Windows PowerShell pipeline techniques. Although Windows Server is the common platform in this course, the skills you gain can be applied to a broad range of Microsoft products including Microsoft Exchange Server, Microsoft SharePoint Server, and Microsoft SQL Server.

  • DP-800T00: Develop AI-enabled database solutions

    This course provides students with the knowledge and skills to design and develop AI enabled database solutions across Microsoft SQL platforms, including SQL Server, Azure SQL, and SQL databases in Microsoft Fabric. It is intended for professionals who build modern data solutions that integrate structured and semi structured data and incorporate AI features into scalable enterprise applications. It will also be valuable for individuals who develop applications that rely on SQL based data services enhanced with vector search, embeddings, and other AI driven capabilities.

  • DP-3020 Develop data-driven applications with Azure SQL Database

    This learning path prepares you for the task of developing data-driven applications by using Microsoft Azure SQL Database. You'll learn how to create and configure an Azure SQL Database, build and deploy database projects using GitHub Actions and Azure Pipelines, and automate the publishing process. Additionally, you'll explore how to use Data API builder for Azure SQL Database and develop a data API with Azure Web Apps and Static Web App. Furthermore, you'll gain skills in importing data via an external REST endpoint, exporting data using an Azure Function, and securing an Azure SQL Database. These essential skills will empower you to effectively develop and manage applications using Azure SQL Database.

  • 55123 Writing Reports with Report Builder and SSRS Level 1

    Need to turn raw SQL Server data into clear, professional reports? This beginner-friendly course teaches you how to do just that using Microsoft SQL Server Report Builder and SQL Server Reporting Services (SSRS). In Report Builder Level 1 (Course 55123), you’ll learn how to connect to data sources, create tables and matrix reports, group and filter data, apply formatting, and add visualizations like charts. The course combines foundational theory with hands-on labs to help you produce reports that are insightful and presentation-ready. Whether you're starting from scratch or transitioning from another reporting tool, this 2-day class equips you with the practical skills to create, polish, and share reports that support decision-making.

  • MS-4010 Extend Microsoft 365 Copilot with declarative agents by using Visual Studio Code

    This training course is designed to help you understand the extensibility options available for Microsoft 365 copilot. You will learn about the different ways to extend Copilot, including building plugins and connectors, and how to choose the right option for your use case. The course also covers best practices for building high-quality plugins and connectors, as well as data, privacy, and security considerations. Whether you are a pro-code or low/no-code developer, this course will help you chart your path to extending and customizing Microsoft 365 Copilot.

  • GH-900 GitHub Foundations

    GitHub Foundations introduces you to the fundamental concepts, features, and products of GitHub. You'll discover the benefits of using GitHub as a collaborative platform and explore its core features, such as repository management, commits, branches, and merging. Through curated modules and hands-on exercises, you'll gain a solid understanding of GitHub's essential tools and be well-equipped to start contributing to projects and collaborating effectively within GitHub.

  • PL-200T00 Microsoft Power Platform Functional Consultant

    This course will teach you to use Microsoft Power Platform solutions to simplify, automate, and empower business processes for organizations in the role of a Functional Consultant. A Microsoft Power Platform Functional Consultant is responsible for creating and configuring apps, automations, and solutions. They act as the liaison between users and the implementation team. The functional consultant promotes utilization of solutions within an organization. The functional consultant may perform discovery, engage subject matter experts and stakeholders, capture requirements, and map requirements to features. They implement components of a solution including application enhancements, custom user experiences, system integrations, data conversions, custom process automation, and simple visualizations. This course may contain a 1-day Applied Workshop. This workshop will allow you to practice your Functional Consultant skills by creating an end-to-end solution to solve a problem for a fictitious company. The solution will include a Microsoft Dataverse database, Power Apps canvas app, and Power Automate flows.

  • SQL Querying Fundamentals – Part 1

    Over 70% of business decision-makers say their teams struggle with data access—most don’t know how to use SQL effectively. This one-day beginner-level training course provides a hands-on introduction to SQL fundamentals using Microsoft SQL Server. You’ll learn SQL from the ground up, gaining the skills to write queries, filter and sort results, combine data from multiple tables, and manipulate output for analysis or reporting. Real-world exercises guide you through every step so you can confidently retrieve information from a relational database.

  • Power BI: Dashboard in a Day

    Are you making the most of your data? 70% of business leaders say analytics is critical—yet most teams struggle to use it effectively. Power BI: Dashboard in a Day is a one-day, hands-on workshop that introduces you to the full capabilities of Microsoft Power BI. Designed for business users, analysts, and anyone interested in data visualization, this course helps you go from raw data to compelling, interactive dashboards in just one day. Work at your own pace while having access to a live instructor for guidance and support.

  • DP-3029 Work smarter with Copilot in Microsoft Fabric

    This course explores how to work smarter with Copilot in Microsoft Fabric. Learn how to integrate, transform, store data, and create insightful reports using Copilot in Microsoft Fabric.

  • GH-100 GitHub fundamentals – Administration basics and product features

    In this course, you'll learn the basics of GitHub and gain a better understanding of its fundamental features with a hands-on exercise all within a GitHub repository. You'll learn best practices for building, hosting, and maintaining a secure repository on GitHub.

  • DP-900T00 Introduction to Microsoft Azure Data

    In this course, students will gain foundational knowledge of core data concepts and related Microsoft Azure data services. Students will learn about core data concepts such as relational, non-relational, big data, and analytics, and build their foundational knowledge of cloud data services within Microsoft Azure. Students will explore fundamental relational data concepts and relational database services in Azure. They will explore Azure storage for non-relational data and the fundamentals of Azure Cosmos DB. Students will learn about large-scale data warehousing, real-time analytics, and data visualization.

  • AB-7011: Introduction to navigating the modern Contact Center

    This course introduces Microsoft Dynamics 365 Contact Center, focusing on its core features and user experiences. Participants will gain an understanding of the platform’s work allocation capabilities, learn how conversations are efficiently routed, and explore the day-to-day workflows of both Contact Center representatives and supervisors. By the end of the course, learners will be equipped with the knowledge to navigate and manage the Dynamics 365 Contact Center environment effectively.

  • GH-300 GitHub Copilot

    This course explores the use of AI in the context of GitHub Copilot, a generative AI tool for developers. It equips users with the knowledge and skills to use Copilot effectively while mitigating potential ethical and operational risks associated with AI usage.

  • PL-7002 Create and Manage Automated Processes by using Power Automate

    Get started with Power Automate by create and manage automated processes with Power Automate. Including creating triggers for cloud flows, configuring actions, implementing conditional logic for a cloud flow, testing a cloud flow, creating and configuring approvals by using Power Automate, and sharing cloud flows.

  • 55301 Mastering Microsoft Project 2019

    This three-day instructor-led course is intended for individuals who are interested in expanding their knowledge base and technical skills about Microsoft Project. The course begins with the basic concepts and leads students through all the functions they’ll need to plan and manage a small to medium-size project, including how to level resources and capture both cost and schedule progress.

  • VBA with Microsoft Excel

    VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft Excel and other applications in the Microsoft 365 application suite. You can use VBA to perform tasks that would be difficult or impossible to do using only worksheet functions, and you can automate a wide range of tasks so they can be performed faster, more consistently, and with less effort than performing them manually. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks. You will learn how to use the macro recorder effectively, as well as how to write your own VBA code from scratch. You will use tools built into Excel to explore and learn VBA's capabilities and to optimize and debug your code.

  • MB-280T03 Design and deliver powerful customer experiences with Dynamics 365 Customer Insights

    Dynamics 365 Customer Insights helps organizations deliver exceptional experiences personalized to every customer. In this course, students will learn how to work with key features of Customer Insights – Data and Customer Insights – Journeys. First, students will learn about the business value of using a customer data platform. They will ingest data into Customer Insights – Data, create unified customer profiles, and create segments to help target specific audiences. Then, students will build impactful and personal experiences using Customer Insights – Journeys. They will create marketing assets like emails and text messages and deliver them via segment- and trigger-based journeys. This course is part of a four-course series (MB-280T01-T04) aligning to the MB-280 certification exam.

  • MS-4004 Empower your workforce with Microsoft 365 Copilot Use Cases

    In MS-4004: Empower your workforce with Microsoft 365 Copilot Use Cases, students perform a series of hands-on exercises involving ten Use Cases – Executives, Sales, Marketing, Finance, IT, HR, Operations, Communications, Customer Service, and Legal. These exercises focus on using Copilot in various Microsoft 365 apps (such as Word, PowerPoint, Outlook, and so on) to complete a series of common business-related tasks pertaining to each Use Case. To complete the Use Case exercises in this course, each student must have access to a Microsoft 365 subscription (BYOS) in which they're licensed to use Microsoft 365 Copilot. Each student must also have a Microsoft OneDrive account, since Copilot requires OneDrive to complete the file sharing tasks used throughout the Use Case exercises.

  • SC-401 Protect sensitive information with Microsoft Purview in the AI era

    The Information Security Administrator course equips you with the skills needed to plan and implement information security for sensitive data using Microsoft Purview and related services. The course covers essential topics such as information protection, data loss prevention (DLP), retention, and insider risk management. You learn how to protect data within Microsoft 365 collaboration environments from internal and external threats. Additionally, you learn how to manage security alerts and respond to incidents by investigating activities, responding to DLP alerts, and managing insider risk cases. You also learn how to protect data used by AI services within Microsoft environments and implement controls to safeguard content in these environments.

  • PL-7008 Create agents in Microsoft Copilot Studio

    In this learning path, you will learn how to create custom copilots with Copilot Studio and will get the opportunity to practice your skills in a guided project.

  • AZ-2006 Automate Azure Load Testing by using GitHub Actions

    Learn how to implement GitHub Actions and configure Azure Load Testing to automate testing app deployments.

  • DP-602T00 Implement a Data Warehouse with Microsoft Fabric

    Explore the data warehousing process and learn how to load, monitor, and query a warehouse in Microsoft Fabric.

  • 55133 PowerShell for System Center Configuration Manager Administrators

    Managing Microsoft System Center Configuration Manager (SCCM) manually can be time-consuming and error-prone. PowerShell gives administrators the tools to automate repetitive processes, improve accuracy, and manage large environments more efficiently. This hands-on training teaches you how to integrate PowerShell with SCCM to handle collections, deployments, operating system distribution, compliance, and reporting. By the end of the course, you’ll leave with practical scripts and techniques that save time and reduce effort in day-to-day administration.

  • PL-400T00 Microsoft Power Platform Developer

    The Microsoft Power Platform helps organizations optimize their operations by simplifying, automating and transforming business tasks and processes. In this course, students will learn how to design, develop, test, and troubleshoot solution components that use the extension points of Microsoft Power Platform. You use traditional code to solve challenges not appropriate with low-code.

  • DP-600T00 Implement analytics solutions using Microsoft Fabric

    This course covers methods and practices for implementing and managing enterprise-scale data analytics solutions using Microsoft Fabric. Students will learn how to use Fabric dataflows, pipelines, and notebooks to develop analytics assets such as semantic models, data warehouses, and lakehouses.  This course is designed for experienced data professionals skilled at data preparation, modeling, analysis, and visualization, such as the PL-300: Power BI Data Analyst certification.

  • SQL Querying Fundamentals – Part 2

    Think you know SQL? Time to level up. SQL appears in over 45% of all data job postings, making it the most in-demand skill for data professionals. In this SQL training course, you’ll build on your foundational skills to write advanced queries, structure and index tables, and control how data is stored and manipulated. Through real-world exercises and expert instruction, you’ll learn how to use subqueries, manage views, and execute transactions—giving you the tools to confidently handle more complex data scenarios.

  • AZ-900T00 Introduction to Microsoft Azure

    This course will provide foundational level knowledge on cloud concepts; core Azure services; and Azure management and governance features and tools.

  • MS-4002 Prepare security and compliance to support Microsoft 365 Copilot

    This learning path examines the key Microsoft 365 security and compliance features that administrators must prepare in order to successfully implement Microsoft 365 Copilot.

  • 55342 Supporting and Troubleshooting Windows 11

    What happens when a key executive can’t log in, a department loses access to shared files, or BitLocker locks out an entire team? Your ability to troubleshoot Windows 11 issues quickly and effectively can make or break business continuity. With Windows 11 now running on over 25% of all desktops worldwide, organizations are rapidly transitioning, and they need IT professionals who can keep systems running smoothly. Get ready to confidently support Windows 11 in enterprise environments. In this hands-on course, you’ll learn how to troubleshoot real issues like installation failures, network connectivity problems, Group Policy glitches, and app compatibility—all within a Windows Server Active Directory setup. With expert guidance and practical labs, you’ll build the skills needed to deliver dependable Tier 2 support and keep users up and running.

  • 55366 Querying Data with Transact-SQL

    How many bad business decisions could be avoided if your data was accurate, timely, and easy to query? Nearly 82% of organizations admit to basing decisions on out-of-date data, leading to costly mistakes. The Querying Data with Transact-SQL training course builds the skills you need to work confidently with Microsoft SQL Server. Through hands-on, instructor-led training, you’ll learn to query single and multiple tables, filter and sort results, join related data, use built-in functions, and work with stored procedures and transactions. You’ll also master subqueries, table expressions, aggregations, and error handling, ensuring you can retrieve and manage data accurately, securely, and efficiently.

  • DP-203T00 Data Engineering on Microsoft Azure

    In this course, the student will learn how to implement and manage data engineering workloads on Microsoft Azure, using Azure services such as Azure Synapse Analytics, Azure Data Lake Storage Gen2, Azure Stream Analytics, Azure Databricks, and others. The course focuses on common data engineering tasks such as orchestrating data transfer and transformation pipelines, working with data files in a data lake, creating and loading relational data warehouses, capturing and aggregating streams of real-time data, and tracking data assets and lineage.

  • AZ-2008 DevOps Foundations: The Core Principles and Practices

    This course provides fundamental level skills in DevOps practices. Students will learn about the DevOps culture and how to optimize application lifecycle management through Agile planning and management, version control, continuous integration, continuous testing, shift-left testing, continuous deployment/delivery, infrastructure as code, observability, security monitoring, Site Reliability Engineering, and platform engineering.

  • Microsoft Power BI Data Analysis Professional

    As technology progresses and becomes more interwoven with our businesses and lives, more data is collected about business and personal activities. This era of "big data" is a direct result of the popularity and growth of cloud computing, which provides an abundance of computational power and storage, allowing organizations of all sorts to capture and store data. Leveraging that data effectively can provide timely insights and competitive advantages. Creating data-backed visualizations is key for data scientists, or any professional, to explore, analyze, and report insights and trends from data. Microsoft® Power BI® software is designed for this purpose. Power BI was built to connect to a wide range of data sources, and it enables users to quickly create visualizations of connected data to gain insights, show trends, and create reports. Power BI's data connection capabilities and visualization features go far beyond those that can be found in spreadsheets, enabling users to create compelling and interactive worksheets, dashboards, and stories that bring data to life and turn data into thoughtful action.

  • SC-200T00 Defend against cyberthreats with Microsoft's security operations platform

    Learn how to investigate, respond to, and hunt for threats using Microsoft Sentinel, Microsoft Defender XDR and  Microsoft Defender for Cloud. In this course you will learn how to mitigate cyberthreats using these technologies. Specifically, you will configure and use Microsoft Sentinel as well as utilize Kusto Query Language (KQL) to perform detection, analysis, and reporting. The course was designed for people who work in a Security Operations job role and helps learners prepare for the exam SC-200: Microsoft Security Operations Analyst.

  • 55371 Windows Server Administration

    Looking to strengthen your Windows Server administration skills? Over 70% of IT workloads rely on Windows Server, making server admins essential to business continuity and network efficiency. This five-day instructor-led course delivers the core knowledge IT professionals need to deploy, manage, and support Windows Server environments. You’ll gain hands-on experience with identity services, networking, virtualization, high availability, and security features. Designed for those with some server experience, this training is ideal for administrators transitioning into more advanced roles or updating skills from previous versions of Windows Server.

  • 55315 Introduction to SQL Databases

    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. This course updates and replaces course 10985C previously published under the same title.

  • MD-102T00 Microsoft 365 Endpoint Administrator

    Can you confidently manage and secure every device in your organization, no matter where it’s located or who’s using it? The Microsoft 365 Endpoint Administrator Training (MD-102) course gives you the skills to plan, deploy, and manage a modern endpoint environment using Microsoft 365 tools. You’ll learn how to configure Windows Autopilot for seamless provisioning, manage devices and apps with Microsoft Intune, and protect identities and data using Microsoft Entra and Microsoft Defender for Endpoint. From update strategies to compliance policies, this course prepares you to support Windows and non-Windows devices in a cloud-powered, security-first world. MD-102 is also a core step toward earning the Microsoft 365 Certified: Endpoint Administrator Associate credential.

  • DP-700T00 Implement data engineering solutions using Microsoft Fabric

    This course covers methods and practices to implement data engineering solutions by using Microsoft Fabric. Students will learn how to design and develop effective data loading patterns, data architectures, and orchestration processes. Objectives for this course include ingesting and transforming data and securing, managing, and monitoring data engineering solutions. This course is designed for data professionals with some data integration and orchestration experience.

  • DP-3014 Build machine learning solutions using Azure Databricks

    Azure Databricks is a fully managed, cloud-based data analytics platform, which empowers developers to accelerate AI and innovation by simplifying the process of building enterprise-grade data applications. Built as a joint effort by Microsoft and the team that started Apache Spark, Azure Databricks provides data science, engineering, and analytical teams with a single platform for big data processing and machine learning. In this course, you’ll learn how to use Azure Databricks to train and deploy machine learning models.

  • Trainer & Facilitator Workshop: Skills for the Modern Classroom

    This course includes multiple techniques for leading classes virtually or in person. Effective facilitation of group sessions, whether remote or in person, is a key skill for Trainers, Supervisors, and Managers as an expression of their leadership and their ability to focus a group. This 3-day course covers multiple techniques and provides a solid foundation in facilitation, instruction, interactive learning, and presenting skills. Dedicated to anyone who delivers content to a group regardless of the setting. Attendees will have ample opportunity to prepare, practice and deliver to the group and receive instruction, coaching, and feedback to support their development of outstanding training skills. Upon successful course completion and test teach, you will earn a badge from Credly.

  • SC-5004 Defend against cyberthreats with Microsoft Defender XDR

    Implement the Microsoft Defender for Endpoint environment to manage devices, perform investigations on endpoints, manage incidents in Defender XDR, and use Advanced Hunting with Kusto Query Language (KQL) to detect unique threats.

  • DP-3011 Implement a Data Analytics Solution with Azure Databricks

    This course explores how to use Databricks and Apache Spark on Azure to take data projects from exploration to production. You’ll learn how to ingest, transform, and analyze large-scale datasets with Spark DataFrames, Spark SQL, and PySpark, while also building confidence in managing distributed data processing. Along the way, you’ll get hands-on with the Databricks workspace—navigating clusters and creating and optimizing Delta tables.   You’ll also dive into data engineering practices, including designing ETL pipelines, handling schema evolution, and enforcing data quality. The course then moves into orchestration, showing you how to automate and manage workloads with Lakeflow Jobs and pipelines. To round things out, you’ll explore governance and security capabilities such as Unity Catalog and Purview integration, ensuring you can work with data in a secure, well-managed, and production-ready environment.

  • AZ-305T00 Designing Microsoft Azure Infrastructure Solutions

    This course teaches Azure Solution Architects how to design infrastructure solutions. Course topics cover governance, compute, application architecture, storage, data integration, authentication, networks, business continuity, and migrations. The course combines lecture with case studies to demonstrate basic architect design principles.

  • AZ-700T00 Design and Implement Microsoft Azure Networking Solutions

    Azure is the backbone of many enterprise cloud environments, and networking is critical to performance, security, and scalability. The AZ-700T00: Design and Implement Microsoft Azure Networking Solutions course equips network engineers with the knowledge and hands-on practice to build resilient, secure, and optimized networking solutions in Azure. Through real-world scenarios, you will learn to design and implement virtual networks, establish hybrid connectivity, configure load balancing, secure traffic, and monitor network performance. By the end of the course, you’ll be ready to implement best practices that ensure reliability and performance for enterprise-grade Azure deployments.

  • SC-5002 Secure Azure services and workloads with Microsoft Defender for Cloud regulatory compliance controls

    This learning path guides you in securing Azure services and workloads using Microsoft Cloud Security Benchmark controls in Microsoft Defender for Cloud via the Azure portal.

  • SC-5006 Enhance security operations by using Microsoft Security Copilot

    Explore the transformative power of AI in security with Microsoft Security Copilot. This course starts by introducing you to the fundamental concepts of generative AI. The course then delves into the cutting-edge AI functionality of Microsoft Security Copilot that empowers analysts to respond to threats quickly, process signals at machine speed, and assess risk exposure more quickly than may otherwise be possible. Lastly, the course guides the learner through a series of simulation-based exercises that mimic real-world situations.

  • SC-300T00 Microsoft Identity and Access Administrator

    The Microsoft Identity and Access Administrator course explores how to design, implement, and operate an organization’s identity and access management systems by using Microsoft Entra ID. Learn to manage tasks such as providing secure authentication and authorization access to enterprise applications. You will also learn to provide seamless experiences and self-service management capabilities for all users. Finally, learn to create adaptive access and governance of your identity and access management solutions ensuring you can troubleshoot, monitor, and report on your environment. The Identity and Access Administrator may be a single individual or a member of a larger team. Learn how this role collaborates with many other roles in the organization to drive strategic identity projects. The end goal is to provide you knowledge to modernize identity solutions, to implement hybrid identity solutions, and to implement identity governance.

  • MB-280T04 Configure a Dynamics 365 customer experience solution

    This learning path prepares you to complete the Dynamics 365 customer experience analyst challenge project and validate your skills. You should have already completed the following modules as part of the MB-280: Dynamics 365 Customer Experience Analyst course series. If you haven't, it's recommended that you take some time to complete these modules before beginning the challenge project.

  • 55321 SQL Server Integration Services

    Struggling to keep up with data quality and loading challenges? Analysts spend up to 80% of their time managing pipelines and cleansing data, leaving just 20% for real insights. The SQL Server Integration Services (SSIS) training course teaches you how to efficiently design and optimize ETL workflows, so your team can focus on delivering impactful business intelligence instead of slogging through manual data prep. The SQL Server Integration Services (SSIS) training course teaches you how to design, configure, and secure efficient ETL workflows. You’ll build SSIS packages that connect to multiple data sources, transform complex datasets, and load results into SQL Server or other destinations with precision. You’ll also learn to design control flows, use precedence constraints effectively, optimize package execution, cleanse and validate server data, follow deployment best practices, and maintain a secure SSIS Catalog. By course completion, you’ll have the skills to deliver reliable, high-quality BI solutions that grow with your organization. Note: This course is similar to the retired Course 20767-C: Implementing a SQL Data Warehouse but focuses more on building packages, rather than the entire data warehouse design and implementation.

  • MS-4015 Build custom agents for Microsoft Teams

    Build intelligent Microsoft Teams apps using the LLMs and AI components of your choice with Teams AI Library. These custom agents can also be used to extend Microsoft 365 Copilot.

  • 55215 SharePoint Online Power User

    Did you know that 80% of Fortune 500 companies use SharePoint to power collaboration and manage content across teams? It’s a powerful platform—but without the right training, it’s easy to feel lost in the complexity. The 55215 SharePoint Online Power User Course helps you take control of your SharePoint sites with practical, hands-on instruction designed for real business users. You’ll learn how to build, organize, and manage sites that actually work for your team—while picking up best practices and learning what to avoid along the way. Through live demos and guided exercises, you’ll gain the skills and confidence to make SharePoint Online a productive, user-friendly hub for your organization.

  • AB-900T00 Introduction to Microsoft 365 and AI administration

    This course provides a comprehensive introduction to Microsoft 365, Copilot, and AI-powered agents. It introduces learners to the foundational concepts, core services, and administrative controls of Microsoft 365. It then builds upon this foundation by exploring how Copilot and agents can utilize AI to automate tasks, enhance collaboration, and personalize user experiences across the Microsoft 365 suite.

  • PL-7001 Create and Manage Canvas Apps with Power Apps

    Create your own data model and canvas app to support a scenario for a fictional company. You're provided high-level specifications on the custom tables, columns and canvas app needed to complete this project.

  • 55353 Administering a SQL Database Infrastructure

    Are your SQL Server systems secure, optimized, and ready for the demands of modern business? With over 70% of organizations relying on SQL databases to drive daily operations, the need for skilled database administrators is stronger than ever. This instructor-led course on administering a SQL database infrastructure equips learners with practical skills to configure SQL Server security, implement backup strategies, manage access, monitor performance, and use PowerShell for automation. You'll also learn to maintain SQL Server databases, troubleshoot performance issues, and import and export data across production environments—including Microsoft Azure SQL.

  • 55318 Advanced Automated Administration with Windows PowerShell

    This three-day course teaches students how to automate administrative tasks using PowerShell. Students will learn crucial scripting skills such as creating advanced functions, writing controller scripts, and handling script errors. Candidates will learn how to use PowerShell when working with Microsoft Azure, SQL Server, Active Directory, IIS, Windows PowerShell Workflow, .NET resources, the REST API and XML, CSV & JSON formatted data files.

  • PL-500T00 Microsoft Power Automate RPA Developer

    Candidates for this course automate time-consuming and repetitive tasks by using Microsoft Power Automate. They review solution requirements, create process documentation, and design, develop, troubleshoot, and evaluate solutions. Candidates work with business stakeholders to improve and automate business workflows. They collaborate with administrators to deploy solutions to production environments, and they support solutions.

  • SC-100T00 Microsoft Cybersecurity Architect

    This is an advanced, expert-level course. Although not required to attend, students are strongly encouraged to have taken and passed another associate level certification in the security, compliance and identity portfolio (such as AZ-500, SC-200 or SC-300) before attending this class. This course prepares students with the expertise to design and evaluate cybersecurity strategies in the following areas: Zero Trust, Governance Risk Compliance (GRC), security operations (SecOps), and data and applications. Students will also learn how to design and architect solutions using zero trust principles and specify security requirements for cloud infrastructure in different service models (SaaS, PaaS, IaaS).

  • PL-7003 Create and Manage Model-Driven Apps with Power Apps and Dataverse

    In this learning path, you practice building model-driven apps by using Microsoft Power Apps. The skills validated include creating Dataverse tables, modifying forms and views, and configuring a model-driven app. The scenario in this experience represents real-world challenges faced by individuals with business-specific expertise who build model-driven apps.

  • AZ-1003 Secure storage for Azure Files and Azure Blob Storage

    In this learning path, you practice storing business data securely by using Azure Blob Storage and Azure Files. The skills validated include creating storage accounts, storage containers, and file shares. Also, configuring encryption and networking to improve the security posture.

  • AZ-104T00 Microsoft Azure Administrator

    How do you keep your cloud infrastructure scalable, secure, and cost-efficient? The Azure Administrator does exactly that, and this course gives you the skills to do it well. According to Microsoft, more than 95% of Fortune 500 companies use Azure, making Azure administration one of the most in-demand cloud roles globally. In this hands-on training, you'll learn how to configure and manage core Microsoft Azure services, including virtual networking, identity, compute, storage, and monitoring. The course aligns with the AZ-104 certification exam. Ideal for IT professionals who need to administer enterprise Azure deployments or are pursuing Microsoft Certified: Azure Administrator Associate certification.

  • DP-603T00 Implementing Real Time Analytics with Microsoft Fabric

    In this learning path, the student is exposed to various ways to: Source streaming data sources into Microsoft Fabric. Use real time Eventstream in Microsoft Fabric. Query data in a KQL database in Microsoft Fabric. Create real time dashboards in Microsoft Fabric.

  • 55232 Writing Analytical Queries for Business Intelligence

    How do you transform complex tables into clean, analysis-ready datasets? This training course teaches you how to write analytical queries using Transact-SQL (T-SQL) for business intelligence (BI) workflows. You’ll learn to manipulate columns, combine tables, aggregate results, and encapsulate logic in reusable views and procedures. With a focus on BI scenarios, the course prepares you to deliver clean, structured datasets to tools like Power BI, Excel, SSRS, and RStudio.

  • AZ-400T00 Design and Implement Microsoft DevOps solutions

    This course provides the knowledge and skills to design and implement DevOps processes and practices. Students will learn how to plan for DevOps, use source control, scale Git for an enterprise, consolidate artifacts, design a dependency management strategy, manage secrets, implement continuous integration, implement a container build strategy, design a release strategy, set up a release management workflow, implement a deployment pattern, and optimize feedback mechanisms

  • MB-820T00 Develop solutions with Dynamics 365 Business Central

    A Dynamics 365 Business Central developer develops apps that extend Business Central. This can include creating new modules and modifying existing modules. The developer can add new business logic or change existing business logic by using events. A developer also makes it possible to integrate Business Central with other applications, including Microsoft Power Platform products. Business Central developers are responsible for troubleshooting and debugging issues in the system. This may involve identifying the root cause of a problem, fixing bugs, and testing the solution to ensure it works as expected. Business Central developers may be required to optimize the performance of the system by identifying bottlenecks and improving code quality. Business Central developers are responsible for upgrading the system, migrating data, and maintaining the system to ensure it remains up to date and secure.

  • 50256 Managing Windows Environments with Group Policy

    Group Policy is one of the most powerful tools available to enterprise IT professionals—and one of the most misunderstood. This course demystifies Group Policy and teaches you how to use it to secure, configure, and streamline the management of your organ

  • DP-300T00 Implement scalable database solutions using Azure SQL

    This course provides students with the knowledge and skills to create a SQL Server database infrastructure for cloud, on-premises and hybrid relational databases and who work with the Microsoft PaaS relational database offerings. Additionally, it will be of use to individuals who develop applications that deliver content from SQL-based relational databases.

  • MD-4011 Enhance Endpoint Security with Microsoft Intune and Microsoft Copilot for Security

    This Course will empower IT professionals and security analysts with the expertise to utilize Microsoft Intune and Microsoft Security Copilot effectively in device management and security operations. This course directs learners towards optimizing Intune for enhanced security and integrating Security Copilot to strengthen their organization's security stance.

  • MS-4017 Manage and extend Microsoft 365 Copilot

    MS-4017: Manage and extend Microsoft 365 Copilot examines how administrators can manage and extend Microsoft 365 Copilot to meet their business needs. The course introduces you to Copilot, examines how to implement and administer it, and then explores the fundamentals of Copilot extensibility.

  • DP-080T00 Query and modify data with Transact-SQL

    This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database, Azure Synapse Analytics, and Microsoft Fabric.

  • 55128 Writing Reports with Report Builder and SSRS Level 2

    In this course, students will continue their learning on the foundations of report writing with Microsoft® SQL Server® Report Builder and SSRS. The focus will be on report creation by connecting to a database and manipulating the data.

  • DP-605 Prepare and visualize data with Microsoft Power BI

    This course is designed as an introduction to Power BI for data analysis and reporting. Skills include connecting to data and basic data preparation tasks using Power Query, designing report pages for optimal user experience, and exploring how Copilot in Power BI aids the report development process.

  • 55238 SharePoint Online for Administrators

    With more than 250,000 organizations worldwide and 85% of Fortune 500 companies relying on Microsoft® SharePoint® for collaboration and content management, its value in modern enterprise is undeniable. The SharePoint Online for Administrators course equips you to become a skilled administrator who can configure, optimize, and secure SharePoint Online within Microsoft 365 environments. You’ll dive into SharePoint’s architecture with hands-on learning across site collections, user profiles, taxonomy setup, apps, and compliance tools. The course also emphasizes critical areas such as data connectivity, storage management, and search configuration to support seamless collaboration.

  • 55341 Installation, Storage, and Compute with Windows Server

    This five-day course is designed primarily for IT professionals who have some experience with Windows Server. It is designed for professionals who will be responsible for managing storage and compute by using Windows Server, and who need to understand the scenarios, requirements, and storage and compute options that are available and applicable to Windows Server. Although this course and the associated labs are written for Windows Server 2022, the skills taught will also be backwards compatible for Server 2016 and Server 2019. The course and labs also focus on how to administer Windows Server using not only the traditional tools such as PowerShell and Server manager, but also Windows Admin Center.

  • Excel Dashboards

    Today's world runs on data more than ever before and that's a trend not likely to change, or even slow down, any time soon. With the tremendous amount of available data, the ability to make sense of it continues to be an ongoing challenge. You already know how to use Excel to perform simple calculations and modify worksheets to make them easier to read, interpret, and present to others. But Excel is capable of doing so much more. To gain a truly competitive edge, you need to be able to extract actionable organizational intelligence from your raw data, and present it in a visually compelling format that enables decision makers to view key trends and gain insights. And that's exactly what this course aims to help you do.

  • GH-200T00 Automate your workflow with GitHub Actions

    Learn how GitHub Actions enables you to automate your software development cycle. You'll learn how to plan automation of your software development life cycle with GitHub Actions workflows, use GitHub Actions to automatically build an application, and use GitHub Script to interact with the GitHub API.

  • PL-300T00 Design and Manage Analytics Solutions Using Power BI

    This course covers the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will show how to access and process data from a range of data sources including both relational and non-relational sources. Finally, this course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution.

  • AZ-140T00 Configure and Operate Microsoft Azure Virtual Desktop

    This course teaches Azure administrators how to plan, deliver, and manage virtual desktop experiences and remote apps, for any device, on Azure. Lessons include implementing and managing networking for Azure Virtual Desktop, configuring host pools and session hosts, creating session host images, implementing, and managing FSLogix, monitoring Azure Virtual Desktop performance and health, and automating Azure Virtual Desktop management tasks. Students will learn through a mix of demonstrations and hands-on lab experiences deploying virtual desktop experiences and apps on Azure Virtual Desktop and optimizing them to run in multi-session virtual environments. Candidates of this course must have solid Azure administration skills. This course assumes prior experience, including virtualization, networking, identity, storage, backup and restore, and disaster recovery. Students should have knowledge of on-premises virtual desktop infrastructure technologies as they relate to migrating to Azure Virtual Desktop. Students are expected to have used the tools common to the Azure environment, such as the Azure PowerShell and Cloud Shell.

  • AZ-801T00 Configure Windows Server Hybrid Advanced Services

    This course teaches IT Professionals to configure advanced Windows Server services using on-premises, hybrid, and cloud technologies. The course teaches IT Professionals how to leverage the hybrid capabilities of Azure, how to migrate virtual and physical server workloads to Azure IaaS, and how to secure Azure VMs running Windows Server. The course also teaches IT Professionals how to perform tasks related to high availability, troubleshooting, and disaster recovery. The course highlights administrative tools and technologies including Windows Admin Center, PowerShell, Azure Arc, Azure Policy, Azure Monitor, Azure Update Manager, Microsoft Defender for Identity, Microsoft Defender for Cloud, and IaaS virtual machine administration.

  • AZ-1008 Administer Active Directory Domain Services

    This learning path helps prepare you for the APL-1008 Administer Active Directory Domain Services modern credential. You'll learn how to create, deploy, and maintain an Active Directory Domain Services environment.

  • PL-900T00 Introduction to Microsoft Power Platform

    Learn the business value and product capabilities of Microsoft Power Platform. Connect data with Dataverse, build simple canvas and model-driven apps, automate a process with Power Automate, and build a Power Pages site.