Microsoft Technical

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.

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

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.

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.

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.

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.

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.

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.

What if you could build enterprise-grade apps without writing a single line of code? With Microsoft PowerApps, anyone can design low-code apps that streamline business processes, connect to real data, and integrate with Microsoft 365, all without writing a single line of code. The 55265 Microsoft PowerApps Training course equips students to create professional-grade apps that connect with data sources like Excel, SharePoint, and Azure SQL. Through guided instruction and hands-on labs, you’ll learn how to build canvas and model-driven apps, apply branding, write formulas, and embed your apps in tools like Teams and SharePoint Online.

Automation is transforming how teams work by reducing repetitive tasks and improving consistency. This instructor-led course introduces Microsoft Power Automate and shows you how to create, edit, and manage flows that connect apps and services across Office 365 and beyond. You will practice applying conditions and loops, using connectors, and integrating with on-premises and cloud systems so you can start automating right away.

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.

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.

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.

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.

Breaking into software development can feel overwhelming; research shows that 30% to 50% of students struggle or drop out of introductory programming courses because the fundamentals are difficult to grasp without the right structure. 55337: Introduction to Programming provides a clear solution. This 5-day, beginner-friendly course introduces you to the basics of computer programming through Microsoft Visual Studio 2022, using C# and Visual Basic. You’ll learn how computers process data, write algorithms, and use decision structures and loops, then progress to object-oriented concepts like classes, inheritance, and polymorphism. The course also introduces debugging, security, I/O, and performance, giving you a solid foundation to advance into Programming in C# and begin your software development journey.

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#.

In this 5-day course, professional web developers will learn to develop advanced ASP.NET Core applications using .NET tools and technologies. The focus will be on coding activities that enhance the performance and scalability of the Web site application.

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.

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.

55343A is the Community Courseware equivalent of retired Legacy Course 20741BC - Networking with Windows Server 2016. This 5-day classroom-based course provides the fundamental networking skills required to deploy and support Windows Server in most organizations. It covers IP fundamentals, remote access technologies, and more advanced content including Software Defined Networking. 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.

Unlock the backbone of secure enterprise environments through identity and access management. Over 90% of Fortune 1000 companies rely on Active Directory for authentication and identity management, making it one of the most critical skills for IT professionals today. Without a solid foundation in Active Directory and related services, organizations risk downtime, compliance failures, and security breaches. The 55344 Identity with Windows Server course is an instructor-led training that teaches IT professionals how to deploy and configure Active Directory Domain Services (AD DS), implement Group Policy, and monitor and troubleshoot Active Directory–related issues with Windows Server 2022. You’ll also learn how to deploy other Active Directory server roles, including Active Directory Certificate Services (AD CS) and Active Directory Federation Services (AD FS). This hands-on training helps you implement core and advanced identity and access technologies in Windows Server. With practical labs using PowerShell, Server Manager, and Windows Admin Center, you’ll configure domain controllers, secure AD DS environments, and synchronize with Azure AD. The skills apply not only to Windows Server 2022 but also to Windows Server 2016 and Windows Server 2019, giving you flexibility to support hybrid and distributed environments.

What’s the secret to keeping enterprise devices secure, compliant, and up to date across thousands of users? Today’s organizations depend on skilled administrators who can leverage Microsoft Endpoint Configuration Manager to deliver, protect, and manage devices at scale. Microsoft reports that Configuration Manager is already managing more than 12.5 million devices worldwide, underscoring its critical role in enterprise IT. The Administering Microsoft Endpoint Configuration Manager Training (55348) course equips you with the practical skills to deploy clients, deliver applications, enforce compliance, roll out operating systems, and manage updates, ensuring your environment remains efficient, secure, and resilient.

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.

Are you ready to confidently manage your organization’s Office 365 environment? With Office 365 powering productivity for over a million companies globally, demand is growing for IT professionals who can administer its services efficiently and securely. In this hands-on course, you’ll learn how to plan, configure, and manage an Office 365 tenant, covering everything from user identities and directory synchronization to Exchange Online, SharePoint, Teams, and security compliance features. Taught using the E3 license model, the skills you gain will be applicable across most Microsoft 365 deployments. This training is ideal for IT administrators looking to build or sharpen their Office 365 expertise in real-world scenarios, including hybrid environments and multi-service administration.

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.

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.

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.

Architecting agentic AI business solutions is an advanced course for architects, senior consultants, and technical leaders responsible for planning, designing, and governing AI-powered enterprise solutions built on Microsoft platforms. This course serves as a foundational, real-world, and architectural preparation step that builds the design judgment, strategic reasoning, and end-to-end understanding learners need before pursuing the AB-100 exam or implementing agentic AI solutions at scale. Learners will explore how to architect AI-powered business solutions that use agents, copilots, and generative AI to automate tasks, improve decision-making, and enhance employee and customer experiences. Emphasis is placed on architecture, trade-offs, governance, cost/benefit analysis, and lifecycle management, rather than step-by-step configuration.

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.

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.

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.

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

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.

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.

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.

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.

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.

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.

Develop the skills necessary to configure a secure deployment solution for cloud-native apps. Learn how to build, deploy, scale, and manage containerized cloud-native apps using Azure Container Apps, Azure Container Registry, and Azure Pipelines.

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