TRAINING ROADMAP

Upcoming Online Lectures, Labs and Learning Paths


  • Querying Data with T-SQL

    This course serves as an introduction to the T-SQL programming language. This course is designed to give students a strong foundation in the T-SQL language which is used by all variants of SQL Server both on-premises and in the cloud.

  • Implement and manage threat protection - Course Three of MS-500 Exam Preparation

    The course will educate you on the implementation and management of threat protection services within Microsoft 365. Starting with implementing Hybrid configuration threat protection solutions, followed by protecting devices and applications using Advanced Threat Protection (ATP). You will also learn how to use ATP to secure Office 365 messaging and surrounding workloads such as OneDrive for Business, SharePoint Online, and Microsoft Teams.

  • MS-300: Deploying Microsoft 365 Teamwork

    Candidates for this exam are Teamwork Administrators who are responsible for configuring, deploying, and managing Office 365 and Azure workloads that focus on efficient and effective collaboration and adoption. Teamwork Administrators manage apps, services, and supporting infrastructure to meet business requirements. The Teamwork administrator must be able to deploy, manage, migrate, and secure SharePoint (online, on-premises, and hybrid), OneDrive, and Teams.
    The Teamwork administrator is involved with decisions regarding governance and works with other administrators to implement many of the decisions made by governance bodies. The Teamwork administrator collaborates with the Messaging Administrator to configure options and security related to email tasks, the Voice Administrator to integrate voice capabilities in organizations, and the Security Administrator to ensure end to end security.
    Candidates for this exam have a fundamental understanding of integration points with the following apps and services: Office, PowerApps, Flow, Yammer, Microsoft Graph, Stream, Planner, and Project. The administrator understands how to integrate third-party apps and services including line-of-business applications. Candidates also have an understanding of SQL Server management concepts, Azure Active Directory, PowerShell, networking, Windows server administration, Domain Name System (DNS), Active Directory mobile device management, and alternative operating systems.

  • Dynamics 365 Fundamentals

    Dynamics 365 is a family of Business Applications. This course provides an overview of the functionality provided by Dynamics 365 Apps to provide a foundational level of knowledge of their capabilities and how the Apps are provided by Microsoft.
    We start off by looking at the various Dynamics 365 Apps and the Power Platform. 
    We then move on to a more detailed look the Apps for Customer Engagement, including what is involved in purchasing, deployment and support.
    We then switch attention to the Apps for Unified Operation, again what is involved in purchasing, deployment and support.
    This course will wrap up by at Cloud Concepts These concepts are not specifically about Dynamics 365 but as Software as a Service applications, it is important to understand and be able to articulate these concepts.

  • Azure DNS - Advanced

    The Domain Name System, or DNS, is responsible for translating (or resolving) a service or server name to its IP address. Azure DNS is a hosting service for DNS domains, providing name resolution using the Microsoft Azure infrastructure. In addition to supporting internet-facing DNS domains, Azure also supports DNS for cloud and hybrid networks.
    This course provides in-depth guidance on using DNS in Azure, covering both public and private DNS deployment, configuration and management.
    As a starting point, students are introduced to DNS (Domain Name System) fundamentals, as well as the various DNS services and features in Azure. Next, students are guided through the registration, delegation, and hosting of public DNS zones using Azure DNS, together with DNS record management. Public DNS management is concluded with a discussion of sub-zones and DNS zone file import and export.
    Students are then introduced to the Azure features for managing DNS in private and hybrid networks. This includes learning which scenarios support Azure DNS private zones and when to use dedicated name servers, together with deployment and configuration details for both approaches.
    The course concludes with a discussion of DNS operations. Students learn how to configure DNS management role-based access control, prevent accidental DNS changes, how to monitor key Azure DNS metrics, and how to set up alerts. Finally, advanced topics include DNS zone backup and recovery, and how to deploy a redundant DNS zone co-hosted with an external provider for maximum resilience to DNS outages or DDoS attacks.     

  • Introduction to Node.js

    Node.js lets developers use JavaScript to write command line tools and for server-side scripting—running scripts server-side to produce dynamic web page content before the page is sent to the user's web browser. Consequently, Node.js represents a "JavaScript everywhere" paradigm, unifying web application development around a single programming language, rather than different languages for server side and client side scripts. In this hands-on lab, you will learn everything from how setup node.js, install packages, understand routing and templating, to perform common operations like file i/o, data access, and deployment.

  • Organizing Azure Resources

    This is one course of eight courses that make up the learning path of Implementing Azure Governance. Resource organization is critical for organizations using Azure at scale. This course begins by discussing resource organization in Azure, explaining both the technical capability of the platform and best practices you can use to manage resources effectively. The second part of the course focuses on the Azure Resource Graph, showing how you can use this feature to explore your resources in many powerful ways.

  • Exploring Azure Resources with Resource Graph

    This is one course of eight courses that make up the learning path of Implementing Azure Governance. Resource organization is critical for organizations using Azure at scale. This course begins by discussing resource organization in Azure, explaining both the technical capability of the platform and best practices you can use to manage resources effectively. The second part of the course focuses on the Azure Resource Graph, showing how you can use this feature to explore your resources in many powerful ways.

  • Implementing Azure Blue Prints

    This is one course of eight courses that make up the learning path of Implementing Azure Governance. Blueprints can be used to create, track and manage pre-built Azure environments. They enable a cloud governance team to define and enforce best practices and compliance while still allowing individual development and operations teams the flexibility to build their own solutions. In this class, students will deep dive into Azure Blueprints, learning how Blueprints are structured, and how to manage the full Blueprint life cycle.

  • Configure and Manage Teams

    In this course you will learn how to plan, deploy and manage Microsoft Teams. Specifically, this course discusses the relationship of Microsoft Teams with SharePoint Online, OneDrive for Business, and Office 365 Groups. It provides best practices for the adoption and deployment of Teams within your organization. It also covers how to establish guest policies and data governance for your Teams data. 

  • Introduction to Cloud Design Principals

    This course is a high level introduction to common cloud concepts (recap of fundamentals to a degree) – but from the point of view of the architect – what are the components of Azure that make a difference w.r.t architecture and what is different about cloud design vs on-premise.

  • Introduction to Architecting Infrastructure Solutions

    This course is an introduction to the services commonly used when solutions that leverage virtual machines. Topics will include compute, network, storage, migration, availability, networking, and automation.

  • Migrating Existing Workloads to Azure

    This course covers how to migrate existing workloads to Azure.  Topics to be discussed include: A migration overview and assessment, Azure Migrate, Lift and Shift, Migrating Servers and Virtual Machines with Azure Site Recovery, and Migrating Databases with Azure Database Migration Service.

  • Define and Prepare the Development Environment: Course One of DP-100 Exam Preparation

    The student will learn how Azure services can support the data science process. They’ll explore common architectures, learn to assess business goals and constraints for determining the correct environment, and setup the relevant development environments to support data science deployments in Azure.

  • Prepare Data for Modeling: Course Two of DP-100 Exam Preparation

    The student will learn how to prepare tabular datasets ready for modeling. Integrating data from multiple sources, understanding relationships inside the data, and cleansing issues where possible are important tasks for building robust statistical models. These techniques will be taught in Azure DataBricks using common Python libraries and Microsoft developed libraries like the Azure Machine Learning Data Prep SDK.

  • Implement Data Storage Solutions - Course One of DP-200 Exam Preparation

    This course covers implementing Azure Data Storage services. We start off by reviewing Azure Portal and Storage concepts, then move on to implementing Azure SQL Data Warehouse, Azure SQL DB, Azure Data Lake, Azure Storage, and Azure Cosmos DB.

  • Manage and Develop Data Processing Solutions - Course Two of DP-200 Exam Preparation

    This course covers configuring, managing and deploying Azure data processing solutions.  We start with an overview of big data environments, including Hadoop clusters, then cover how to plan for and implement Azure Databricks, Azure Stream Analytics, Event Hubs, Azure Data Factory and how these fit with Azure Data Warehouse solutions.

  • Monitor and Optimize Data Solutions - Course Three of DP-200 Exam Preparation

    This course covers configuring, managing and deploying monitoring for Azure Storage and data store solutions.  We start with an overview of monitoring concepts, then focus on monitoring Azure Storage, Azure Data Lake, Azure Data Warehouse, Azure SQL DB and other services.

  • Design Azure Data Storage Solutions - Course One of DP-201 Exam Preparation

    In this course, students will gain knowledge and skills needed to recommend and design Azure Data Solutions based on requirements. The solution technologies will include both relational and non-relational cloud data stores.

  • Design for Data Security and Compliance - Course Three of DP-201 Exam Preparation

    This course covers designing of security for source data access and security for data policies and standards.

  • Manage governance and compliance features in Microsoft 365 - Course Four of MS-500 Exam Preparation

    The course will educate you on Governance and Compliance features within Microsoft 365. It will guide you through the ability to retrieve content as well as audit logs, allowing you to make decisions, and apply protections and controls based on information.

  • AWS Certified DevOps Engineer

    The AWS Certified DevOps Engineer - Professional exam tests the candidate's technical expertise in provisioning, operating, and managing distributed application systems on the AWS platform. For this exam, you should know how to:

    Implement and manage continuous delivery systems and methodologies on AWS. Understand, implement, and automate security controls, governance processes, and compliance validation. Define and deploy monitoring, metrics, and logging systems on AWS. Implement systems that are highly available, scalable, and self-healing on the AWS platform. Design, manage, and maintain tools to automate operational processes.

    This course is designed to provide you with the knowledge and skills required to pass the AWS Certified DevOps Engineer - Professional exam and to successfully apply these skills in the workplace.

  • Design Data Processing Solutions - Course Two of DP-201 Exam Preparation

    This course covers designing of batch processing solutions and designing of real-time processing solutions. 

  • Deploy and update operating systems - Course One of MD-101 Exam Preparation

    Students will learn Plan and implement Windows 10 by using dynamic deployment, plan and implement Windows 10 by using Windows Autopilot, upgrade devices to Windows 10, manage updates and manage device authentication.

  • Manage policies and profiles - Course Two of MD-101 Exam Preparation

    Students will learn how to plan and implement co-management, implement conditional access and compliance policies for devices, configure device profiles and manage user profiles.

  • Manage and protect devices - Course Three of MD-101 Exam Preparation

    Students will learn how to manage Windows Defender, manage Intune device enrollment and inventory and monitor device health such as log analytics, windows analytics or other cloud-based tools. 

  • Deploy and update applications - Course Four of MD-101 Exam Preparation

    Students will learn how to deploy and update applications, assign apps to groups, deploy O365 ProPlus and implement Mobile Application Management (MAM).

  • React Advanced

    This course goes beyond the basics of building simple React components and simple web user interfaces. This course introduces students to the Flux design pattern and Redux Dataflows. Then a brief overview of reactive programming techniques is presented. We then discuss routing and server API access for data strorage and web service interactions, such as GraphQL, and authentication/authorization. We then explore how React can be used to develop native mobile apps, and finally, we go over several best practices that relate to Test Driven Development and how to customizing builds and deal with app rollout and deployment.

  • Perform Feature Engineering: Course Three of DP-100 Exam Preparation

    The student will learn how develop effective and reusable features ready for modeling. Using manual techniques and then automated techniques, the data scientist will be able to handle core data types using SciKit-Learn and Microsoft Python libraries like MMLSpark and Azure Machine Learning Data Prep SDK.

  • Develop Models: Course Four of DP-100 Exam Preparation

    The student will learn how develop robust models. Starting from selecting the right metric to meet business goals, through to building tuned models, and then evaluating the models produced for fitness. 

  • Azure SQL Database Concept Overview: Course One of Introduction to Azure SQL Database

    Course 1 provides the conceptual backdrop of setting the stage for Azure SQL Database as a contender and enterprise premium workload.   This course covers the concepts and service tier definitions for Azure SQL Database, providing a formal launch point for additional course study on this feature set. 

  • Azure SQL Database Security: Course Two of Introduction to Azure SQL Database

    Course 2 guides participants through Azure SQL Database Security Concepts, including Role-base Access Control (RBAC) and a survey of the Security Advisory Tools Azure provides as part of the overall feature set.   In addition, this course introduces Row Level Security and Dynamic Data Masking to round out.

  • Azure SQL Database Tooling and Management: Course Three of Introduction to Azure SQL Database

    Course 3 takes participants on a tour of Azure SQL Database management, showcasing various Azure SQL Tooling options and focusing on the considerations for integration and management of an Azure SQL Database instance.

  • Azure SQL Database Monitoring and Data Encryption: Course Four of Introduction to Azure SQL Database

    Course 4 discusses various database monitoring and data encryption options provided within Azure SQL Database.  Monitoring options include a brief introduction to Extended Events with a particular focus on popular encryption options like storage-level Transparent Data Encryption and client-side Always Encrypted column-level encryption are covered.

  • Azure SQL Database Elastic Scaling: Course Five of Introduction to Azure SQL Database

    Course 5 is a tour into Azure SQL Database Elastic Scaling and guidance for decisions on proper usage of Elastic Pools vs Instances when configuring Azure SQL Database for desired performance goals.

  • Azure SQL Database High Availability and Disaster Recovery: Course Six of Introduction to Azure SQL Database

    Course 6 discusses Azure SQL Database options providing various levels of HADR capability through platform configuration.  On entry, participants will get exposure to the backing roles that MSFT and Deployment Teams take in HADR, conceptual considerations and requirements., evolving into a tour of what Azure SQL Database brings to the table to simplify and promote reduced downtime and near-zero data loss on an existing enterprise grade SLA.  In addition, client-side design implications are discussed in terms of building advanced fault tolerance capability as a pre-configpluggable. 

  • Azure SQL Database Sizing and Performance: Course Seven of Introduction to Azure SQL Database

    Course 7 discusses various sizing and performance options available.  Participants will consider options, match to basic performance scenarios engaging both with Azure Performance Advisor Tools as well as manual adjustments to fit specific custom requirements.  

  • Orchestrating Data with Azure Data Factory

    This course will cover how to use Azure Data Factory to orchestrate data movement and transform data at a scale.  Azure Data Factory is a managed cloud service that is built for complex hybrid extract-transform-load (ETL), extract-load-transform (ELT), and data integration projects.  This course would be ideal for individuals working in big data, analysts, and data scientists.  

  • MS-300: Configure and Manage OneDrive for Business

    Students will learn how to connect clients to all their files in Office 365, enabling the ability to share and work from anywhere in a secure environment. This course will deliver a experience of adoption for the attendees, getting to know the deeps and tricks of OneDrive for business and the benefits that come with the platform.

  • GCP Fundamentals: Core Infrastructure

    This course covers understanding clouds, different services, google cloud and its advantages.  We start off by learning basics of cloud computing, Infrastructure-as-a-Service (IaaS), Platform-as-a-Service (PaaS), and Software-as-a-Service (SaaS).  We will then move on to the Google cloud and the benefits of using it.  

    We will also take a deep look at each service of the Google Compute Platform (GCP), including networking, security, compute, storage, and more.  Through this course, you will gain an understanding of availability zones, containers, and cloud data flow for data processing.

  • Advanced C# Language Features

    This course is designed to help you understand advanced language features in the ever-evolving C# programming language. This course will help you understand advanced C# language features that can make your code easier to read, maintain, test and build. After completing this course, you will be able to author applications faster and make them more maintainable using C#.

  • Advanced Programming with .NET

    This course explores advanced concepts related to building .NET applications using C#. This course will help you understand the differences between the .NET frameworks and how to build them in various environments. Completing this course, you will be able to build desktop and web solutions using an expanded set of features in .NET.

  • Security+

    This course provides an overview of Defense in Depth security challenges and strategies of mitigation in the information systems environment. Topics include definition of security terms, security concepts, elements, and goals incorporating industry standards and practices with a focus on confidentiality, availability, and integrity fundamentals of information systems for Systems Administrators.

  • Power BI for Data Professionals

    This course covers using Power BI Desktop to create and deploy datasets and reports as well as deploying, sharing, and securing assets in PowerBI.com. 
    We will start off by reviewing the components of the Power BI ecosystem. Then we will begin to build a model in Power BI Desktop by acquiring data using Power Query/M. Next, we will shape and model the data using M and DAX. Then we will build calculations to support analysis and reporting. 
    Once we have a working dataset, we will build a report using default and custom visuals, buttons, and bookmarks. Then we’ll add dynamic row-level security roles.  
    Next, we’ll explore various ways to deploy and share the data model and the report in PowerBI.com. This will include organization of workspaces, user roles within the workspace, row-level security, and use of Power BI apps. We will also look at scheduling the refresh of data in imported and composite datasets. 
    The course will wrap up by looking at some re-usability and lifecycle management techniques including version control, pre-production environments, use of shared and certified datasets, and suggested quality checks before deploying to production. 

  • MS-300: Configure and Manage Workload Integrations

    This course will help you prepare for the exam MS-300: Deploying Microsoft 365 Teamwork by covering the basics of configuring and managing workload integrations in Microsoft 365. This four-module course will cover integrating M365 workloads (such as Office 365 connectors, Flow and PowerApps, etc.), enabling document support for Yammer, managing Stream, and integrating M365 workloads with external systems (such as PowerBI, line of business systems and monitoring usage and licensing).

  • Getting Started with Linux Scripting

    In this course, you will learn some basic techniques for scripting with Bash in a Linux environment. The principles learned will be applicable to all computing environments. Throughout the course, as you build a number of sample scripts, you will learn the use of bash shortcuts, shell variables, and built-in commands. You will also learn how to script dynamically on the command line, how to format a script, the use of return values and comments, command substitution, testing conditions, and looping constructs, and how to invoke scripts and obtain input from the command line. You will be better prepared to create your own scripts to use in your computing environment.