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.