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.
-
Mon 21 Sep2 days, 09:00 AM – 05:00 PM
-
Tue 24 Nov2 days, 09:00 AM – 05:00 PM
-
Thu 28 Jan2 days, 09:00 AM – 05:00 PM
Description
1 – Introduction to Transact-SQL
- Work with schemas
- Explore the structure of SQL statements
- Examine the SELECT statement
- Work with data types
- Handle NULLs
- Module assessment
2 – Sort and filter results in T-SQL
- Sort your results
- Limit the sorted results
- Page results
- Remove duplicates
- Filter data with predicates
- Module assessment
3 – Combine multiple tables with JOINs in T-SQL
- Understand joins concepts and syntax
- Use inner joins
- Use outer joins
- Use cross joins
- Use self joins
- Module assessment
4 – Write Subqueries in T-SQL
- Understand subqueries
- Use scalar or multi-valued subqueries
- Use self-contained or correlated subqueries
- Module assessment
5 – Use built-in functions and GROUP BY in Transact-SQL
- Categorize built-in functions
- Use scalar functions
- Use ranking and rowset functions
- Use aggregate functions
- Summarize data with GROUP BY
- Filter groups with HAVING
- Module assessment
6 – Modify data with T-SQL
- Insert data
- Generate automatic values
- Update data
- Delete data
- Merge data based on multiple tables
- Module assessment
Target Audience
This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers.
Similar courses
-
AZ-800T00 Administering Windows Server Hybrid Core Infrastructure
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.
-
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.
-
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.
-
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.
-
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-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.
-
PL-600T00 Power Platform Solution Architect
The Solution Architect is responsible for the successful design, implementation, deployment and adoption of an overall solution. The Solution Architect ensures that the solution meets the customer’s needs now and in the future. In this course, students will learn about decisions a Solution Architect makes during an implementation, covering security, integrations, Power Apps architecture, Power Automate architecture, and more. This course is designed to give you an introduction to the Solution Architect role.
-
AZ-2003 Deploy cloud-native apps using Azure Container Apps
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.
-
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.
-
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.
-
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.
-
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.
-
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.
-
55343 Networking with Windows Server
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.
-
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.
-
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.
-
DP-3028 Implement Generative AI engineering with Azure Databricks
This course covers generative AI engineering on Azure Databricks, using Spark to explore, fine-tune, evaluate, and integrate advanced language models. It teaches how to implement techniques like retrieval-augmented generation (RAG) and multi-stage reasoning, as well as how to fine-tune large language models for specific tasks and evaluate their performance. Students will also learn about responsible AI practices for deploying AI solutions and how to manage models in production using LLMOps (Large Language Model Operations) on Azure Databricks.
-
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.
-
SC-900T00 Introduction to Microsoft Security, Compliance, and Identity
This course provides introductory level knowledge on security, compliance, and identity concepts and related cloud-based Microsoft solutions.
-
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.
-
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.
-
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.
-
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.
-
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.
-
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.
-
AB-100T00: Architecting agentic AI business solutions
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.
-
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.
-
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.
-
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.
-
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.
-
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.
-
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.
-
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.
-
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.
-
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.
-
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.
-
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.
-
55265 Microsoft® PowerApps
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.
-
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.
-
AZ-500T00 Microsoft Azure Security Technologies
This course provides IT Security Professionals with the knowledge and skills needed to implement security controls, maintain an organization’s security posture, and identify and remediate security vulnerabilities. This course includes security for identity and access, platform protection, data and applications and security operations.
-
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.
-
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.
-
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-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.
-
55337 Introduction to Programming
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.
-
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.
-
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.
-
AZ-204T00 Developing Solutions for Microsoft Azure
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.
-
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.
-
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-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.
-
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.
-
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.
-
DP-3015 Get started with Azure Cosmos DB NoSQL development
This course teaches developers to utilize Azure Cosmos DB for NoSQL API and SDK. Students will learn query execution, resource configuration, SDK operations, and design strategies for non-relational data modeling and data partitioning.
-
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.
-
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-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.
-
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.
-
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.
-
55348 Administering Microsoft Endpoint Configuration Manager
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.
-
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.
-
MS-102T00 Microsoft 365 Administrator
This course covers the following key elements of Microsoft 365 administration: Microsoft 365 tenant management, Microsoft 365 identity synchronization, and Microsoft 365 security and compliance. In Microsoft 365 tenant management, you learn how to configure your Microsoft 365 tenant, including your organizational profile, tenant subscription options, component services, user accounts and licenses, security groups, and administrative roles. You then transition to configuring Microsoft 365, with a primary focus on configuring Office client connectivity. Finally, you explore how to manage user-driven client installations of Microsoft 365 Apps for enterprise deployments. The course then transitions to an in-depth examination of Microsoft 365 identity synchronization, with a focus on Azure Active Directory Connect and Connect Cloud Sync. You learn how to plan for and implement each of these directory synchronization options, how to manage synchronized identities, and how to implement password management in Microsoft 365 using multifactor authentication and self-service password management. In Microsoft 365 security management, you begin examining the common types of threat vectors and data breaches facing organizations today. You then learn how Microsoft 365’s security solutions address each of these threats. You are introduced to the Microsoft Secure Score, as well as to Azure Active Directory Identity Protection. You then learn how to manage the Microsoft 365 security services, including Exchange Online Protection, Safe Attachments, and Safe Links. Finally, you are introduced to the various reports that monitor an organization’s security health. You then transition from security services to threat intelligence; specifically, using Microsoft 365 Defender, Microsoft Defender for Cloud Apps, and Microsoft Defender for Endpoint. Once you have this understanding of Microsoft 365’s security suite, you then examine the key components of Microsoft 365 compliance management. This begins with an overview of all key aspects of data governance, including data archiving and retention, Microsoft Purview message encryption, and data loss prevention (DLP). You then delve deeper into archiving and retention, paying particular attention to Microsoft Purview insider risk management, information barriers, and DLP policies. You then examine how to implement these compliance features by using data classification and sensitivity labels.
-
55268 Microsoft Power Automate for End Users
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.
-
55344 Identity with Windows Server
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.
-
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.
-
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.
-
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.
-
55340 Developing ASP.NET Core Web Applications
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.
-
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.
-
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.
-
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.
-
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.
-
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.
-
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.
-
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-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.
-
MB-280T01 Configure Dynamics 365 customer experience model-driven apps
With model-driven apps, organizations can customize their user experiences with little to no code and create powerful applications that empower their users and increase productivity. This course is designed to help students learn the skills necessary to configure the Dynamics 365 customer experience model-driven apps, which include Dynamics 365 Sales and Dynamics 365 Customer Insights. In this course, students will learn how to create tables and columns, work with Microsoft Dataverse, and configure the user experience inside a model-driven application. This course is part of a four-course series (MB-280T01-T04) aligning to the MB-280 certification exam.
-
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.
-
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.
-
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.
-
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.
-
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.
-
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.
-
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
-
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.
-
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.
-
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.
-
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.
-
MB-910T00 Introduction to Microsoft Dynamics 365 (CRM)
Do you want to learn more about Dynamics 365? This course will provide you with a broad introduction to the customer engagement capabilities of Dynamics 365. You will become familiar with the concept of customer engagement, the core capabilities of customer engagement apps as well as with each of the customer engagement apps, including Dynamics 365 Customer Insights, Dynamics 365 Sales, Dynamics 365 Customer Service and Dynamics 365 Field Service. You will also learn how Copilot can assist you in executing customer engagement tasks in Dynamics 365. This course includes lectures and hands-on-labs.
-
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.
-
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.
-
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.
-
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.
-
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.
-
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.
-
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.
-
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.
-
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-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.
