SQL Querying Fundamentals – Part 1

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.

1 Day $695.00 excl.
  • Mon 28 Sep
    1 day, 09:00 AM – 05:00 PM
    • $695.00 excl.
  • Thu 15 Oct
    1 day, 09:00 AM – 05:00 PM
    • $695.00 excl.
  • Wed 4 Nov
    1 day, 08:00 AM – 04:00 PM
    • $695.00 excl.
  • Tue 24 Nov
    1 day, 09:00 AM – 05:00 PM
    • $695.00 excl.
  • Tue 15 Dec
    1 day, 09:00 AM – 05:00 PM
    • $695.00 excl.
None of these dates work for you? Suggest another date & time

Description

Module 1: Executing Basic SQL Statements

  • Connect to a SQL Server database
  • Create, modify, and execute queries
  • Save and reopen query files

Module 2: Filtering with Conditional Logic

  • Limit results using comparison operators
  • Combine multiple conditions
  • Search for ranges, NULL values, and patterns

Module 3: Using Built-In SQL Functions

  • Perform date and time calculations
  • Manipulate strings and text fields
  • Calculate summaries with aggregate functions

Module 4: Structuring and Summarizing Output

  • Sort results and apply custom rankings
  • Group data and filter grouped rows
  • Pivot and unpivot results for advanced formatting

Module 5: Working Across Tables

  • Merge data with inner and outer joins
  • Identify records without matches
  • Compare and combine multiple result sets

Module 6: Exporting Results and Creating Reports

  • Format and save query results
  • Generate basic XML output
  • Review common reporting use cases

Prerequisites

Basic computer literacy Basic PC operating system navigation skills Basic Internet usage skills

Target Audience

Individuals with basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases.

Objectives

After completing this course, you’ll be equipped to use SQL to extract and manipulate data from relational databases. You’ll gain practical experience writing queries, formatting results, and applying functions using SQL Server. Run basic SQL statements to retrieve data Apply conditions and logical filters using WHERE clauses Use string, numeric, and date functions for calculated results Organize and group query output Join tables and identify missing or unmatched records

Similar courses

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

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

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

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

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

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

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

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

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

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

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

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

  • 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-1003 Secure storage for Azure Files and Azure Blob Storage

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

  • AZ-040T00 Automate Administration with PowerShell

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

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

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

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

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

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

  • SC-100T00 Microsoft Cybersecurity Architect

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

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

  • 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

  • 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-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

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

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

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

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

  • DP-3001 Migrate SQL Server workload to Azure SQL

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

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

  • MB-335T00 Augment advance level Supply Chain Management solutions with Microsoft Dynamics 365

    This course is designed to build your in Dynamics 365 Supply Chain Management application knowledge. This course will cover the most important features and functionalities needed by Dynamics 365 Supply Chain Management functional consultant including: The product information and how to configure, create, and manage your product and inventory. Supply chain management configuration and processing. The transportation management features, and the warehouse management features. Asset Management functionalities. Master planning configuration and processing. Sales and procurement processes. This course includes lectures and several hands-on exercises. The exercises will be introduced to you in the form of a case study presented to a Dynamics 365 Supply Chain Management Functional Consultant, Expert. Each exercise will be based on a business scenario followed by a question or discussion then a step-by-step guidance to perform the system related steps.

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

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

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

  • Power BI for Data-driven Decision Makers

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

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

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

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

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

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

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

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

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

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

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

  • SC-5001 Configure SIEM security operations using Microsoft Sentinel

    Get started with Microsoft Sentinel security operations by configuring the Microsoft Sentinel workspace, connecting Microsoft services and Windows security events to Microsoft Sentinel, configuring Microsoft Sentinel analytics rules, and responding to threats with automated responses. After completing this course, students will be able to:  Create and configure a Microsoft Sentinel workspace  Deploy a Microsoft Sentinel content hub solution  Connect Windows hosts to Microsoft Sentinel  Configure analytics rules in Microsoft Sentinel  Configure automation in Microsoft Sentinel

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  • GH-300 GitHub Copilot

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

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

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

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

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

  • AZ-1004 Deploy and configure Azure Monitor

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

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

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

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

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

  • AZ-104T00 Microsoft Azure Administrator

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

  • DP-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.

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

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

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

  • 55341 Installation, Storage, and Compute with Windows Server

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

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

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

  • PL-7008 Create agents in Microsoft Copilot Studio

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

  • AZ-1008 Administer Active Directory Domain Services

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

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

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

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

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

  • PL-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.

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

  • SQL Querying Fundamentals – Part 2

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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