Microsoft Training

This course teaches IT Professionals how to manage their Azure subscriptions, secure identities, administer the infrastructure, configure virtual networking, connect Azure and on-premises sites, manage network traffic, implement storage solutions, create and scale virtual machines, implement web apps and containers, back up and share data, and monitor your solution.

Audience Profile

This course is for Azure Administrators. The Azure Administrator implements, manages, and monitors identity, governance, storage, compute, and virtual networks in a cloud environment. The Azure Administrator will provision, size, monitor, and adjust resources as appropriate.

This course teaches developers how to create end-to-end solutions in Microsoft Azure. Students will learn how to implement Azure compute solutions, create Azure Functions, implement and manage web apps, develop solutions utilizing Azure storage, implement authentication and authorization, and secure their solutions by using KeyVault and Managed Identities. Students will also learn how to connect to and consume Azure services and third-party services, and include event- and message-based models in their solutions. The course also covers monitoring, troubleshooting, and optimizing Azure solutions.

Audience Profile

Students in this course are interested in Azure development or in passing the Microsoft Azure Developer Associate certification exam.

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

Audience Profile

This course is suitable for IT personnel who are just beginning to work with Azure. This audience wants to learn about our offerings and get hands-on experience with the product. This course primarily uses the Azure portal and command line interface to create resources and does not require scripting skills. Students in this course will gain confidence to take other role-based courses and certifications, such as Azure Administrator. This course combines lecture, demonstrations, and hands-on labs. This course will also help prepare someone for the AZ-900 exam.

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.

This course provides students with the knowledge and skills to administer 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.

This course introduces Microsoft 365, an integrated cloud platform that delivers industry-leading productivity apps along with intelligent cloud services, and world-class security. You’ll learn foundational knowledge on the considerations and benefits of adopting cloud services and the Software as a Service (SaaS) cloud model, with a specific focus on Microsoft 365 cloud service offerings. You will begin by learning about cloud fundamentals, including an overview of cloud computing. You will be introduced to Microsoft 365 and learn how Microsoft 365 solutions improve productivity, facilitate collaboration, and optimize communications. The course then analyzes how security, compliance, privacy, and trust are handled in Microsoft 365, and it concludes with a review of Microsoft 365 subscriptions, licenses, billing, and support.

The course introduces essential elements of modern management, co-management approaches, and Microsoft Intune integration. It covers app deployment, management of browser-based applications, and key security concepts such as authentication, identities, access, and compliance policies. Technologies like Microsoft Entra ID, Azure Information Protection, and Microsoft Defender for Endpoint are explored to protect devices and data.

Use powerful, dynamic SharePoint sites to achieve your business goals! This class guides you through the most important tools and functions of SharePoint. First, you will get comfortable with the SharePoint layout and navigation. From there, we introduce you to SharePoint lists, which allow you to store and view important data. Then, you will learn to use SharePoint libraries to improve your teams file management and document versioning. Next, get hands-on with SharePoint sites. You will use built-in site templates to create project sites, team sites, community sites, and blog sites. This class is for end users working in a SharePoint environment. If you need to learn to manage a SharePoint site, consider taking our SharePoint Site Owner class after completing this Introductory training.

In this Introduction to Microsoft Excel 2019 training class, students will create and edit basic worksheets and workbooks. This course is designed for students who want to gain the necessary skills to create, edit, format, and print basic Microsoft Excel 2019 worksheets.

This Intermediate Microsoft Excel 2019 training class is meant for students who want to advance their skill set by learning to work with advanced formulas, lists, and illustrations. Students will also work with charts and advanced formatting including styles.

This Advanced Microsoft Excel 2019 training class is designed for students to gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros.

The Microsoft Power Platform helps organizations optimize their operations by automating routine tasks and standardizing best practices. This training provides a high-level overview of the capabilities of Microsoft Dynamics 365 and the Power Platform and provides a foundation for other Microsoft Dynamics 365 and Power Platform training offerings. High-level topics include application configuration, automation opportunities, integration, testing, and deployment.

This course will provide you with a broad introduction to the finance and operations capabilities of Dynamics 365. You will become familiar with the concept of enterprise resource management (ERP), and learn about the core capabilities of the finance and operations app. Then we will discuss each of the apps individually, including Dynamics 365 Supply Chain Management, Dynamics 365 Finance, Dynamics 365 Commerce, Dynamics 365 Human Resources, and the ERP capabilities of Dynamics 365 Project Operations. This course will include lecture and hands-on-labs.

Learn the business value and product capabilities of Microsoft Power Platform. Create simple Power Apps, connect data with Dataverse, build a Power BI Dashboard, and automate processes with Power Automate.

This Power Automate and Power Apps training course teaches attendees how to leverage the powerful features of both tools to build Microsoft Power Platform applications and automations that maximize your team’s productivity in Microsoft 365.

The Power Automate modules in this course teach attendees how to create automated flows, scheduled flows, and button flows in a no-code environment. Students learn how to create automated workflows between their favorite apps and services to synchronize files, receive notifications, collect data, and more. Attendees then take their Power Automate skills to the next level to create more advanced approval workflows, build a workflow from scratch, and gain a deeper understanding of Triggers, Variables, and Expressions.

The Power Apps topics teach attendees how to create custom apps in the cloud to automate business processes. Students learn how to create canvas apps using templates, apps from SharePoint, and more in a low-code environment. Throughout the class, attendees get real-world, hands-on practice creating and editing several small apps and adding Power Automate flows to those apps. Attendees then go beyond the basics and build more sophisticated custom apps in a low-code environment.

55337AC is the equivalent of the retired MOC Course 10975AC - Introduction to Programming.

This course is intended for anyone who is new to software development and wants, or needs, to gain an understanding of programming fundamentals and object-oriented programming concepts. They will typically be high school students, post-secondary school students, or career changers, with no prior programming experience. They might want to gain an understanding of the core programming fundamentals before moving on to more advanced courses such as Programming in C#.

The focus will be on core programming concepts such as computer storage, data types, decision structures, and repetition by using loops. The course also covers an introduction to object-oriented programming covering classes, encapsulation, inheritance, and polymorphism. Coverage is also included around exception handling, application security, performance, and memory management.

This course is a direct replacement of Legacy course 20486CC.

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

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.

This Introduction to SharePoint 2019 class is for end users working in a SharePoint 2019 environment. It is an abbreviated version of our complete SharePoint End User class and is intended for people new to using SharePoint who will not be responsible for managing a SharePoint site.

This course gives you hands-on experience with SharePoint Site Owner tasks. You have the opportunity to practice building and managing team sites, creating and editing content, integrating Excel and Outlook, and managing permissions. First, your expert SharePoint instructor will demonstrate how to build different types of sites and how to create and configure site navigation. Then, your live trainer will provide guidance on managing page content. Next, you will learn best practices for using web parts, creating site columns, using content types, and integrating with Excel and Outlook. Finally, the class wraps up with SharePoint site permissions including hands-on practice creating SharePoint groups, assigning permissions, and adjusting permissions inheritance. By the end of this class, you will be ready to help users securely share documents, collaborate on content, and access the business information they need to work together more efficiently.

This course delivers the complete site owner story from start to finish in an engaging and practical way to ensure you have the confidence to plan and create new sites or manage your existing sites. Your goal is to learn how to make SharePoint relevant to your team by using a sites functionality to help you share information and collaborate with your colleagues. During the class you will also learn best practices and what not to do as you watch live, interactive demonstrations and put theory into practice with hands on exercises.

55315A is the equivalent of the retired MOC Course 10985C - Introduction to SQL Databases. The 55315A three-day instructor-led course is provided as an introductory class for anyone getting started with databases. It will be useful to programmers and other IT professionals whose job roles are expanding into database management. Students will learn fundamental database concepts through demonstrations and hands-on labs on SQL Server, Azure SQL Server and other cloud-based SQL Server databases.

SQL Server Integration Services is the equivalent of the retired MOC Course 20767CC - Implementing a SQL Data Warehouse. This five-day instructor-led course is intended for IT professionals who need to learn how to use SSIS to build, deploy, maintain, and secure Integration Services projects and packages, and to use SSIS to extract, transform, and load data to and from SQL Server.

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.

55316A is the Community Courseware equivalent of retired MOC Course 20764A - Administering a SQL Database Infrastructure.

The 55316A five-day instructor-led course will provide training in how to administer and maintain SQL Server, Azure SQL Database and other cloud-based SQL Server databases. IT professionals who work in environments where databases play a key role in their job will find this material useful. By using demonstrations and hands-on lab exercises, students will learn to carry out these important tasks.

Course 55345AC is the Community Courseware equivalent of retired MOC Course 20697-1D - Implementing and Managing Windows 10.

This is a 4-day ILT course designed to provide you with the knowledge and skills required to install and configure Windows 11 desktops and devices in an on-premises Windows Server Active Directory domain environment.

Note: This course is also backwards compatible with Windows 10 as many of the technologies and principles remain the same.

This course teaches IT Professionals how to manage core Windows Server workloads and services using on-premises, hybrid, and cloud technologies. The course teaches IT Professionals how to implement and manage on-premises and hybrid solutions such as identity, management, compute, networking, and storage in a Windows Server hybrid environment.

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 Automation Update Management, Microsoft Defender for Identity, Azure Security Center, Azure Migrate, and Azure Monitor.

Course 55371AC is the Community Courseware equivalent of retired MOC WS-011 - Windows Server Administration.

This five-day instructor-led 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 identity, networking, storage and compute by using Windows Server, and who need to understand the scenarios, requirements, and options that are available and applicable to Windows Server. The course teaches IT professionals the fundamental administration skills required to deploy and support Windows Server in most organizations.