Upcoming Online Lectures, Labs and Learning Paths
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.
DevOps Up and Running
This course is designed for IT leaders, developers, and operations folks who are aiming to build on the early wins of their DevOps implementation. We start off by discussing rapid iteration and understanding the “fail fast” culture of startups, how to prioritize important work, and learn how to increase velocity through improved performance.
Then, we will look at the importance of customer experience and feedback, including how to create a customer feedback process so that you can begin to integrate that feedback into your software development process.
After that, we will focus on how to set your team up for success using three approaches to team structure in a DevOps culture. Each approach has advantages and disadvantages. We’ll also cover recruiting, interviewing, deciding on job titles, and dealing with challenging teammates.
This course will wrap up by looking at how to scale an engineering team through DevOps, motivating engineers to produce their best work, and measuring your success.
DP-300 Course 1 Plan and Implement Data Platform Resources
In this course, we will discuss deploying resources by using manual methods. We will also talk about recommending an appropriate database offering based on specific requirements, configuring resources for scale and performance and evaluating a strategy for moving to Azure. We will close out this course by discussing how to implement a migration or upgrade strategy for moving to Azure.
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.
Understanding Web Servers, Browsers, and the HTTP Protocol
In this course we will explore web servers, browsers, and the HTTP Protocol in the context of Internet architecture and using the client-server paradigm prominent in the web today. This course will seek to explain each concept, highlight fundamental building blocks, and eventually showcase a demo that grounds each concept and how all the three aspects work together within the client server paradigm. For example, you’ll learn about some of the common HTTP Status codes such as OK 200 and Page 404 Page Not Found in the context of web requests. The course will seek to develop an integrated understanding with the ability to apply the concepts using existing web technologies such as NGINX web server, HTML, and Google Chrome.
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.
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 Monitoring and Operations
This course will cover the history of monitoring in Azure, demystify what all the Azure native monitoring tools look like, provide guidance on when to use what + why or when, walk through Azure Monitor Alerts (metrics and diagnostics), dive into Log Analytics/Kusto Query Language (KQL), discuss parts of the former OMS, dig into Azure Backup + Azure Site Recovery, go over Azure Automation, and explore Application Insights.
MS - 600 Extend Teams
In this course, we will cover the components of a Teams app, options for extending the Microsoft
DP-300 Course 2 Implement a Secure Environment
In the second course of DP-300 we will start off with configuring data base authentication by using platform and data base tools. We will then move on to configuring data base authorization by using platform and database tools. This course will also cover implementing security for data at rest and data in transit as well as implementing compliance controls for sensitive data.
DP-300 Course 3 Monitor and Optimize Operational Resources
Course 3 of DP-300 will start off with monitoring activity and performance and implementing performance-related maintenance tasks. You will learn about identity performance-related issues, configuring resources for optimal performance, as well as configuring a user data base for optimal performance.
DP-300 Course 4 Optimize Query Performance
Course 4 of DP-300 will cover reviewing query plans and evaluating performance improvements. This course will also discuss reviewing database table and index design.
DP-300 Course 5 Perform Automation of Tasks
In course 5 we will discuss creating scheduled tasks. We will then move on to evaluating and implementing an alert and notification strategy. We will wrap up this course with managing and automating tasks in Azure.
DP-300 Course 6 Plan and Implement a High Availability and Disaster Recovery (HADR) Environment
In Course 6 you will learn how to recommend an HADR strategy for a data platform solution, test an HADR strategy by using platform, OS and database tools and how to perform a backup and restore a database by using database tools. This course will also cover configuring DR by using platform and database tools along with configuring HA using platform, OS and database tools.
DP-300 Course 7 Perform Administration by Using T-SQL
In course 7 of DP-300 you will learn how to examine system health, monitor database configuration by using T-SQL and perform backup and restore a database by using T-SQL. We will also cover how to manage authentication by using T-SQL and manage authorization by using T-SQL.
Introduction to Automating Azure with Azure CLI
This course covers the basics of using the Cross-platform Azure CLI to manage an Azure Tenant.
We will start by understanding the Azure CLI tool set, as well as understanding common syntax, modes and features. We will also look at automating the creation and management of Azure Tenant Services and Components.
This course will walk through how to control Azure Services as well as how to use JSON for management in Azure CLI.
This course covers the basic functionalities and concepts of Microsoft PowerShell (Version 7). The start will be to get to the basics of this powerful, object oriented scripting language. Several modules will explain the language itself and how to use the various scripting environments. The remaining parts of this course will show you how to take your PowerShell scripts to production, extend your reach to other computers and the Azure cloud and even build your own tools.
During the course you will also see how to install PowerShell 7 on a new system, examples of how to use the latest features and how to create your own scripting environment; on your own computer or in the cloud.
This course will wrap up by looking at ways to extend the out-of-the-box experience and create on user interfaces for your operations tasks.
Automating Azure Virtual Machines with Azure CLI
This course takes you through using Azure CLI for Virtual Machine Management. We will start by understanding the available commands for Virtual Machines. We will then walk through configuration of supporting services when using Virtual Machines. This course will walk through all the steps needed to deploy and manage the basics of Virtual Machines within Azure.
Democratizing AI: Deep Dive into Developing Cognitive Services Solutions
Students who complete this course will have a better understanding on what it is to be a citizen developer and how to write AI solutions using Cognitive Services with each service.
Microsoft PowerApps + Dynamics 365 Developer
This course covers all you need to know about Power Platform development opportunities. We start by covering the way to manage and deliver your solutions with or without the Power Platform Common Data Service which is also used by Dynamics 365. We then move on to customizing solutions using plug-ins, web resources, client scripts and business rules.
After creating our solution, we will take a look at how to extend the user experience to display, manage and automate operations between different Power Apps options.
This course will wrap up by looking at some of the important key points you’ll need to look at specifically in order to prepare for the Microsoft Certification.
Building APIs with ASP.NET Core
As web applications grow in popularity and we see a greater uptick in web frameworks, creating robust application programming interfaces (APIs) for internal and external use is becoming increasingly more important.
This course will teach developers the fundamentals of building APIs with ASP.NET Core, including testing, validation, and designing interfaces that will allow them to be good API citizens.