Data Professional

Skill Me Up expert on-demand training for data professionals - learn how to use Azure Machine Learning, Big Data, and Data Visualization with Power BI using live hands-on lab environments, on-demand training and live courses.

learning path
0 (0)
0 Lectures | 0 Labs |

Microsoft Open Hacks

learning path
4 (18)
5 Lectures | 6 Labs | 7h 59m | Beginner | Certification Prep

In this this learning path you will explore Power BI Desktop and the the Power of PowerBI.com deploy datasets and reports as well as deploying, sharing, and securing assets in PowerBI.com. You will learn how to model data using DAX, as well as build reports and visualizations through on-demand courses and interactive hands-on labs.

learning path
4 (42)
3 Lectures | 5 Labs | 12h 51m | Advanced

In this learning path, you will learn how to implement Azure Database. Topics will include understanding to design and deploy databases using SQL DB and SQL Datawarehouse along with more advanced topics of performance and troubleshooting for SQL.

learning path
5 (7)
4 Lectures | 5 Labs | 18h 36m | Advanced

In this learning path, you will take a deep dive into Azure Cosmos DB, Throughout the path you will design documents and collections for real time implementations, create user-defined functions, stored procedures and triggers, tuning databases, monitoring performance along with troubleshooting techniques and best practices.

learning path
4 (16)
2 Lectures | 4 Labs | 10h 47m | Intermediate

In this learning path, you will learn the fundamentals of Azure DataBricks and as new courses are added to the path you will progressively learn more advanced topics.

learning path
4 (8)
1 Lectures | 3 Labs | 4h 44m | Advanced

In this learning path, you will learn from the fundamentals of SQL Server relational databases to advanced capabilities,

learning path
4 (96)
6 Lectures | 2 Labs | 6h 54m | Intermediate | Certification Prep

In this learning path, you will learn key concepts about the cloud and various Microsoft Azure Services. From there, you will learn core concepts such as various PaaS and IaaS services including management tools. This course will also cover several key concepts for security and compliance, as well as a brief look at a Azure pricing and support. This course will help you prepare for AZ 900 Microsoft Azure Fundamentals.

learning path
5 (10)
4 Lectures | 0 Labs | 5h 30m | Intermediate

In this learning path, you will learn the basics of data science including what data science is, some of the common programming languages used in data science (R and Python) as well as an introduction to machine learning.

learning path
4 (96)
6 Lectures | 2 Labs | 6h 54m | Intermediate | Certification Prep

In this learning path, you will learn key concepts about the cloud and various Microsoft Azure Services. From there, you will learn core concepts such as various PaaS and IaaS services including management tools. This course will also cover several key concepts for security and compliance, as well as a brief look at a Azure pricing and support. This course will help you prepare for AZ 900 Microsoft Azure Fundamentals.

learning path
4 (21)
3 Lectures | 6 Labs | 12h 8m | Intermediate | Certification Prep

This learning path contains a collection of courses and hands-on labs designed to help you pass the exam DP-200: Implementing an Azure Data Solution

learning path
4 (3)
2 Lectures | 0 Labs | 3h 7m | Beginner

This learning path is designed to teach you the fundamentals of relational databases using Microsoft SQL Server. You will learn core concepts such as tables, indexes, and building relationships with foreign keys. From there, you will learn how to write queries using T-SQL to query data as well as make changes to your database.

learning path
5 (4)
3 Lectures | 0 Labs | 6h 45m | Intermediate | Certification Prep

This learning path contains a collection of courses and hands-on labs designed to help you pass the exam DP-201: Designing an Azure Data Solution

learning path
2 (6)
4 Lectures | 2 Labs | 5h 35m | Intermediate | Certification Prep

This track has a collection of demonstrations, presentations, and interactive labs designed to prepare you for the Microsoft DP-100 exam.

learning path
4 (20)
1 Lectures | 5 Labs | 11h 37m | Intermediate

In this learning path, you will find courses and hands-on labs to teach you the ins and outs of using PowerShell.

learning path
0 (0)
1 Lectures | 0 Labs | 1h 49m | Beginner

This learning path contains recordings and hands-on labs based off of the SQL Server 2019 workshop development by the Microsoft SQL Server product team. You will learn about SQL Server intelligent performance features, new security features, modern development capabilities, how to use SQL Server 2019 on Linux + Containers, as well as new features with big data and data virtualization.

learning path
5 (3)
10 Lectures | 0 Labs | 11h 35m | Intermediate

This track contains a collection of expert talks recorded by Azure Data Professionals

learning path
5 (1)
2 Lectures | 0 Labs | 2h 7m | Intermediate

This track contains a collection of expert talks recorded by Power BI Experts.

learning path
5 (1)
2 Lectures | 0 Labs | 5h 58m | Beginner | Certification Prep

This course is geared toward the PL-900 exam which focuses a significant amount on business scenarios and uses for the components within the Power Platform. However, to understand which features, functionality, and products to use in the various scenarios presented, you need to understand the products themselves. So, in this course, our goal is to present you with and understanding of each of the components, so that when it does come to the exam, you’ll be able to successfully match up the fundamentals of what you should use when. While some of the demos and slides may go into the technical detail of how to accomplish things, for the purpose of the Power Platform fundamentals exam, you won’t need to know the how everything is built, but when to use the various components we’re building with.

learning path
0 (0)
0 Lectures | 0 Labs |

In this Learning Path we will discuss the methods and best practices in line with both business and technical requirements for modeling, visualizing data Power BI. We will also cover how to access and process data from a variety of different data sources including both relational and non-relational data. This course will also cover how to implement the proper security standards and policies across the Power BI spectrum. We will move on to discuss how to manage and deploy reports and dashboards for sharing as well as content distribution. We will wrap up by showing how to build paginated reports within the Power BI service and how to publish them to a workspace for inclusion within Power BI.

learning path
0 (0)
3 Lectures | 4 Labs | 22h 25m | Advanced | Certification Prep

In this learning path, students are educated on the proficiencies of a Microsoft identity and Microsoft Graph. Students will practice how to administer Microsoft Teams within an organization to support modern collaboration workloads. Topics include application deployment, messaging, meetings, audio conferencing, client configuration, compliance policies, security practices, guest collaboration, networking requirements, and integration with existing applications. Migration planning and upgrade paths for Skype For Business services is also covered as an important topic for organizations today. Tasks are demonstrated using both the administrator portal and Windows PowerShell.

learning path
0 (0)
0 Lectures | 0 Labs |

Cloud Maker episodes feature discussions and information about cloud architecture. These episodes include cloud migration best practices, cloud architecture, security, and building solutions utilizing the Microsoft Cloud. If you are architecting and building services with Azure, Microsoft 365, and hybrid infrastructures, Cloud Maker is the place to go to find information.

learning path
0 (0)
0 Lectures | 0 Labs |

Cloud Native episodes feature discussions and information about application development on the cloud. These episodes include application development of cloud native applications, CI/CD utilizing Git, GitHub and Azure DevOps, creating scalable applications with C#, Python, PowerShell, CLI and other coding tools, and utilizing platform and serverless services, such as Azure Functions, Logic Apps, IoT and cognitive services. If you are creating and using code and serverless computing, Cloud Native is the place to go to find information.

lecture
2 (3)
5h 38m | Intermediate | Apr 12 2019 |

In this course, you will explore the Spark Internals and Architecture. The course will start with a brief introduction to Scala. Using the Scala programming language, you will be introduced to the core functionalities and use cases of Apache Spark including Spark SQL, Spark Streaming, MLlib, and GraphFrames.

lecture
0 (0)
1h 9m | Beginner | May 27 2020 |

The Azure container alphabet soup, ACR, ACI, AKS, AWC, DCK,...Containers are popular, and especially in a cloud environment. But often it is hard to decide on where to run them, how to run them and what service is better than another. Even within a single cloud platform like Azure, you have a few different capabilities. Learn in this session from Peter, an Azure Business Program Manager within Microsoft, passionate Azure trainer and former Azure MVP, how you can containerize your applications, and run them in different Azure Container services. As typical for Peter's sessions, this is packed with demos, to-the-point, and no marketing fluff.

lecture
0 (0)
55m | Beginner | Jul 21 2020 |

Did you ever wonder what NoSQL is about? Then you've just came across the right Expert Talk to see how to provision and use Azure CosmosDB. Azure CosmosDB is a NoSQL offering in Azure, which allows you to provision several types of NoSQL database engines based on your workload. In the talk we'll see how to get the best from the deployment.

lecture
0 (0)
23m | Beginner | Sep 16 2020 |

In this course, you will learn to identity ways to plan and manage costs and purchase services within Azure, how to understand the Azure Service Level Agreements and calculating a composite SLA for more than one service combination, and understanding the service lifecycle within Azure. This course covers one of the objective areas that help you in preparing for the AZ-900 Azure Fundamentals exam.

lecture
5 (2)
1h 37m | Intermediate | Aug 12 2019 |

This course is an introduction to Microsoft Azure Machine Learning Services. In this course you will learn to navigate the AML Services interface, create notebook servers, create compute clusters, manage AML Services from a notebook, deploy models, and create an Automated Machine Learning experiment.

lecture
0 (0)
1h | Beginner | May 29 2020 |

Azure SQL Database is a popular database engine available in Azure environment which can be utilized for both building new applications and also for modernization migration of your existing environment. In this Expert Talk we'll see how to provision and configure the database service for scalable and secure operations.

lecture
5 (4)
4h 42m | Advanced | Sep 15 2017 |

This course will be a deep dive into Azure SQL Database performance. We will look at designing an Azure SQL Database architecture for performance. We will look at performance specific features of Azure SQL Database. We will also cover monitoring and troubleshooting.

lecture
5 (1)
Azure Synapse Analytics
Beginner | Coming Soon!

Let's dive in together into the brand new big data data warehouse solution running on Microsoft Azure. Azure Synapse brings the best from data analytics, ingestion and reporting tools available in one single piece.

lecture
0 (0)
1h | Intermediate | Apr 28 2020 |

Database workloads demand good storage performance in order to work well, and Azure offers you a lot of storage options. In this expert talk, you will learn about principals of Azure Storage and how it works in conjunction with Virtual Machines. You’ll learn options for how to configure you storage for optimal performance, and options for balancing your cost versus performance. Finally, you’ll learn the best practices for how to layout your SQL Server files.

lecture
0 (0)
33m | Intermediate | Apr 3 2020 |

In this course, you will learn techniques for making your application scale and be ready for production. We’ll explore common troubleshooting techniques you can use for your application, as well discuss how to design for data concurrency. This course will also explore the Cosmos DB Change Feed feature for building event driven applications with Cosmos DB. Finally, the course will close on how to distribute your Cosmos backend globally using multiple Azure regions.

lecture
0 (0)
31m | Beginner | Oct 9 2020 |

In this episode of Cloud Maker, Kit Skinner will talk about the options to bring the Azure cloud closer to your physical presence. If a gigabit and 100ms isn’t enough for your solution, or restrictions require your compute to be close to your devices, or you’re the GoaT of IoT but you still want the dynamic and versatile features of the Azure services, there are options to bring the Azure cloud to your doorstep. We’ll go over Azure Stack in all its flavors (Edge, HCI, Hub, etc.) and discuss ways to utilize it in your environment.

lecture
5 (1)
15m | Beginner | Sep 16 2020 |

In this course, you will learn about the core solutions within Azure and the management tools that are available. These include Internet of Things (IoT), big data and analytics, artificial intelligence, serverless computing, and DevOps. You will get a high-level understanding of the tools available to create resources, automate, and govern resources within Azure. This course covers one of the objective areas that help you in preparing for the AZ-900 Azure Fundamentals exam.

lecture
0 (0)
44m | Intermediate | Apr 3 2020 |

In this course, you will learn how to model data using the JSON based document model, and understand how data schemas are still applicable in Cosmos DB. From there, this course will take a look at one of the most important aspects of building a high-performance database and that is data partitioning.

lecture
5 (2)
1h 35m | Beginner | Mar 6 2020 |

In this course we will cover Data Modeling and the xVelocity Engine. We will also discuss DAX Basics along with Advanced DAX and optimizing the data model.

lecture
5 (1)
33m | Beginner | Mar 6 2020 |

This course will cover the basics of acquiringdata in Power BI Desktop andbuilds on the data acquisition basics and adds performance optimization and re-usability techniques.

lecture
1 (1)
36m | Intermediate | Sep 18 2020 |

Now you have a good, trained model. How can you use it? In this course we explore the various ways that models can be deployed for making single predictions as well as batch predictions. You will learn the various types of deployment environments that exist and how to choose compute for those. This course will also teach you how to convert your existing training pipelines into deployable inferencing pipelines. This course covers one of the objective areas that help you in preparing for the DP-100: Designing and Implementing a Data Science Solution on Azure exam.

lecture
0 (0)
55m | Beginner | Oct 1 2020 |

In this episode of Cloud Maker, join Kit Skinner and Dwayne Natwick for a down to Earth, simplified discussion about deployments in Azure. Whether you're looking to leave the nest, build your own nested deployments, or just understand how Jason is related to your Azure resources, we’ll help you to understand why we’re on this track in Azure, how it really can make your life easier, and what to expect in the future for your next ARM day. We will also go over how you can reutilize deployments and utilize others’ published templates to help ease your tasks.

lecture
5 (2)
3h 6m | Intermediate | Nov 27 2019 |

In this course, students will gain knowledge and skills needed to design data storage solutions. Topics will include recommending the correct storage based on business and technical requirements, designing relational and non-relational cloud data stores. Specific focus points will be around data distribution, partitioning, designing for scale, high availability and disaster recovery on Cosmos DB, SQL Database, Azure Synapse Analytics, Data Lake Store Gen2 and Blob storage.

lecture
5 (2)
1h 57m | Intermediate | Oct 11 2019 |

This course covers designing of data processing solutions. We will look at leveraging Data Factory and Databricks and choosing optimal batch processing technology. The course will also include the design of real-time processing solutions with Stream Analytics and Azure Databricks.

lecture
0 (0)
1h 40m | Intermediate | Jan 20 2020 |

This course covers designing for data security and compliance. We will discuss securing source data access with endpoint security and authentication, securing data with encryption at rest and in transit. We will also cover data governance and compliance topics such as auditing, classification and data retention policies.

lecture
5 (1)
1h 45m | Intermediate | Jul 22 2020 |

In this expert Talk,  Jen Stirrup will go in-depth on what to expect for the exam Designing and Implementing a Data Science Solution on Azure (DP 100). Her talk starts with a review of the exam skills and what is measured, and then will step through each of the objectives and quickly review the key points of the exam as well as sample questions to help test your knowledge in each area.

lecture
0 (0)
1h 9m | Intermediate | May 8 2020 |

You are already familiar with T-SQL and are eager to learn R but do not know where to start? Start from what you already know: T-SQL. Both languages have many things in common on some levels, but are very different on others. You will learn how to begin your first steps in the new language and how to perform the most common tasks, typical for R: statistics, machine learning data visualization.This session will kick you off to the new language by using analogies from T-SQL. You will learn how to write your first R-scripts, make usage of packages and will leave this session with a basic understanding of typical use-cases of R and how to integrate that into your existing environment with SQL Server.

lecture
5 (2)
1h 29m | Beginner | Mar 19 2019 |

The course will teach you the fundamentals of the relational database model and how to access data stored in relational databases. The course will give students an understanding of relational database concepts and teach the practical application of these concepts through the T-SQL programming language for Microsoft SQL Server and Azure SQL Database.

lecture
0 (0)
43m | Beginner | Sep 16 2020 |

In this course, you will get an understanding of the security challenges to an organization within the cloud. You will learn some ways to build a defense in depth strategy utilizing Azure security tools, such as Azure Security Center, Azure Sentinel, Azure Key Vault, and other network security services. This course covers one of the objective areas that help you in preparing for the AZ-900 Azure Fundamentals exam.

lecture
0 (0)
1h 40m | Beginner | Jul 22 2020 |

In this expert talk you will learn how to plan smarter, collaborate better, and ship faster with Azure DevOps Services. You will discover some of the team and collaboration capabilities as well as learn the basics of setting up pipelines for continuous integration and deployment in this demo packed exclusive session.

lecture
0 (0)
57m | Beginner | Nov 12 2020 |

Interest in the cloud continues to grow. Many organizations are looking to adopt and migrate applications and data to Azure to reduce capital expenses and costly data centers. As administrators, architects, developers, and engineers, what are you doing to architected and deploy cloud technologies in your organization? In this episode of Cloud Maker, Shannon Kuehn and Dwayne Natwick will explore Azure Landing Zones to and how they are used to continue your digital transformation.After this discussion, you will have a better idea of how you can build scalable and modular Azure cloud services.

lecture
0 (0)
33m | Beginner | Oct 22 2020 |

How do you maintain communication with disconnected personnel? Organizations are facing a gigantic change in processes and procedures during COVID-19. Obviously, one of the largest is communication and inter-communications of personnel working from home and the field. In this episode of Cloud Native, Brian Nielsen will go over the features in the Microsoft Teams mobile app and how it can keep your organization connected and more productive.

lecture
5 (1)
1h 1m | Intermediate | May 4 2020 |

Power BI is a self-service Business Intelligence tool, which does a great job in hiding complexity and technology away from the user. But when it comes to performance and even correct numbers, one should spend some time in finding the right way of modelling the tables and how they are related to each other. In this talk we spend an hour on doing exactly that. You will get answers to questions like: Why should you care about the data model? What kind of relations are available? How do they influence performance? Why redundancy is (not) a bad thing?

lecture
0 (0)
58m | Beginner | Sep 16 2020 |

In this course, you will learn about the various tools for Identity and Access Management, governing Azure resources with role-based access control and resource locks and using Azure Policy for cost and resource compliance. We will discuss how Azure can assist in regulatory and governmental compliance. This course covers one of the objective areas that help you in preparing for the AZ-900 Azure Fundamentals exam.

lecture
5 (3)
2h 42m | Intermediate | Dec 30 2019 |

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.

lecture
5 (7)
23m | Beginner | Aug 24 2016 |

In this hands-on course, students will learn about Azure SQL Data Warehouse. This course will review basic architecture of Azure SQL Data Warehouse. We will cover tools used with Azure SQL Data Warehouse, loading SQL Data Warehouse and basic workload management in SQL Data Warehouse.

lecture
5 (12)
1h 15m | Beginner | Sep 17 2016 |

In the course Introduction to Azure SQL Database we will discuss the configuration, performance, security, availability, recovery and automation of Azure SQL Database. We will also review hybrid solutions with SQL Server Stretch Database. This course will partially help prepare you for exam 70-473 Designing and Implementing Cloud Data Platform Solutions.This course will help you prepare for Microsoft Exam 70-533 - Implementing Azure Infrastructure Solutions and 70-532 Developing Azure Solutions as well.

lecture
5 (5)
45m | Beginner | Jan 14 2019 |

This course covers the necessary tools and concepts used in the data science industry to include machine learning, statistical inference, working with data at scale and much more.

lecture
5 (8)
54m | Intermediate | Jul 4 2018 |

This training provides an overview of Azure Databricks and Spark. In this course you will learn where Azure Databricks fits in the big data landscape in Azure. Key features of Azure Databricks such as Workspaces and Notebooks will be covered. Students will also learn the basic architecture of Spark and cover basic Spark internals including core APIs, job scheduling and execution. This class will prepare developers and administrators for more advanced work in Azure Databricks such as Python or Scala development.

lecture
5 (2)
32m | Beginner | Mar 6 2020 |

Welcome to this introduction to Power BI for data professionals. In this course, we will have an overview of the Power BI ecosystem. Then we will have a tour of Power BI Desktop.

lecture
5 (1)
1h 8m | Beginner | Sep 9 2019 |

This course is an introduction to Python. In this course you will learn which IDE is right for you, print statements, data types, control flow, Python functions and anonymous functions, methods, file io, and an introduction to Python packages.

lecture
5 (2)
1h 59m | Intermediate | Jul 2 2019 |

This course covers introduction to the R Language. We start off with an introduction to R verisons and R Editions then move to R the language. From there will dive into one of R’s strongest features, Graphics. Using base R graphics and GGPlot you will learn how to get started, and learn how to create your own visualizations.

lecture
5 (2)
56m | Beginner | Mar 6 2020 |

In this course we will discuss an overview of the Power BI Service. We will also cover sharing and securing your report and designing Enterprise Solutions in Power BI.

lecture
0 (0)
1h 10m | Beginner | Oct 19 2020 |

Every organization has sensitive information that they need to protect. Whether it is a healthcare provider with Personal Health Information (PHI), a bank with client financial information, or any business that has social security numbers and bank accounts in their payroll systems, this information needs to be kept from unauthorized individuals. In this episode of Cloud Maker, Dwayne Natwick and Liam Cleary will discuss and demonstrate how Microsoft Data Protection and Classification services can be used to tag and label this sensitive information and create policies that can limit the exposure of this data to unauthorized individuals and bad actors.

lecture
5 (2)
1h 28m | Intermediate | Jan 24 2020 |

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.

lecture
0 (0)
50m | Beginner | Sep 23 2020 |

As more users and organizations are utilizing applications and platforms that are cloud native, such as Microsoft 365 and Azure, the importance of managing and protecting identities becomes a top priority among administrators and security personnel. In this episode of Cloud Maker, Dwayne Natwick and Wim Matthyssen will discuss how to protect identities within Azure Active Directory for Microsoft 365, Azure, and hybrid users. We will show how conditional access policies can be used to protect against sign-in, user, and device risk, and how Privileged Identity Management can be used to decrease the identity attack surface of administrative privileges.

lecture
0 (0)
58m | Beginner | Oct 30 2020 |

As more users begin to rely on cloud applications to access information, how does a security administrator manage the governance of what applications are allowed within the corporate ecosystem. In this episode of Cloud Maker, Dwayne Natwick and Tim Hermie will take a look at how Cloud App Security can be used to create and govern the cloud applications that users have the ability to access and save data. We will also show how the Cloud App Security dashboard and Azure Sentinel can be used to monitor and investigate potential misuse of cloud applications.

lecture
0 (0)
58m | Beginner | Oct 23 2020 |

How does an organization monitor and manage information governance and data retention to protect themselves and their users from regulatory fines and legal issues. In this episode of Cloud Maker, Dwayne Natwick and Liam Cleary will discuss how Microsoft 365 Information Governance and Retention policies can be used to avoid accidental (or intentional) deletion of information that may be required to be held for a specified amount of time for regulatory, financial, or legal reasons. We will show how to create policies for information governance and retention requirements for data within the organization that is auto-applied to Exchange, SharePoint, OneDrive, and Teams data and communications.

lecture
0 (0)
1h | Beginner | May 27 2020 |

In this expert talk by Microsoft MVP Jesus Gil you will learn what Microsoft Flow is all about with real business use cases through a demo packed session.

lecture
5 (1)
52m | Intermediate | Feb 14 2020 |

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.

lecture
0 (0)
1h 2m | Beginner | Nov 19 2020 |

Interest in the cloud continues to grow. Many organizations are looking to adopt and migrate applications and data to Azure to reduce capital expenses and costly data centers. As administrators, architects, developers, and engineers, how are you going to execute the move the cloud? In this episode of Cloud Maker, Shannon Kuehn and Dwayne Natwick will explore the benefits and uses of Azure Migrate for discovery, estimate, and execute workload moves to the Azure cloud. After this discussion, you will have a better idea of how you can migrate workloads to Azure cloud services.

lecture
0 (0)
1h 30m | Intermediate | Jul 31 2020 |

In this course, students are introduced to deployment considerations for Microsoft Teams. Module topics include migration planning, networking requirements, guest access, information security, client endpoints, and system monitoring. Microsoft Teams Administrators are expected to understand these concepts to successfully deploy Microsoft Teams and promote rapid adoption within their organizations. Students will practice executing Microsoft Teams environment tasks via both the administrator portal and Windows PowerShell.

lecture
0 (0)
2h 29m | Intermediate | Sep 3 2020 |

In this course, students will learn how to manage groups within Microsoft Teams from both administrator and user perspectives. Module topics include creating and managing teams, modifying team memberships, team permissions, and application policies. Microsoft Teams Administrators are expected to apply and teach these skills within their organization to train users on managing their teams and memberships. Students will practice these tasks as both administrators and users to promote efficient team membership management.

lecture
0 (0)
1h 10m | Intermediate | Jul 13 2020 |

In this course, students will learn how to manage groups within Microsoft Teams from both administrator and user perspectives. Module topics include creating and managing teams, modifying team memberships, team permissions, and application policies. Microsoft Teams Administrators are expected to apply and teach these skills within their organization to train users on managing their teams and memberships. Students will practice these tasks as both administrators and users to promote efficient team membership management.

lecture
5 (1)
58m | Intermediate | Apr 27 2020 |

Dataviz guru Stephen Few once stated that we should “save the pies for dessert”. What he meant is that pie charts are good in some specific use cases, but they should not be used in others. The same is true for other chart types. Using the wrong type of chart will make it harder for report users to understand the story behind the data. To enable insights, information must be presented in the most intuitive way possible. You will leave this session with five easy-to-implement rules, which will guide you through the process of creating clear and attractive visualizations. Every rule will be applied through live demos in Power BI Desktop, where you will learn how to avoid pitfalls from the defaults and turn the right knobs to build clear and helpful visualizations.

lecture
0 (0)
1h 9m | Intermediate | Sep 22 2020 |

Join Shannon and Dwayne Natwick for this Expert Talk, where they will provide an overview of Microsoft’s next evolution of Azure VMware Solution (AVS). The new AVS solution is a first-party service offered on bare metal servers in Azure. The new offering allows customers to seamlessly extend, or completely migrate, existing on-premises VMware workloads to Azure without the cost, effort, or risk of re-architecting applications or retooling operations.

lecture
3 (2)
1h 23m | Intermediate | Sep 18 2020 |

What if Azure Machine Learning could do the hard work of model selection and optimization for you? What if it also could automatically explain the “why’s” of the model’s prediction process? Well it can! In this course we explore a few powerful features of Azure Machine Learning. In part one we will learn about Automated Machine Learning which makes algorithm selection a breeze. In part two we explore Hyperdrive, a feature that helps us find optimal Hyperparameter values. Then this course will introduce you to Interpretability in Azure Machine Learning. Finally, we learn about a powerful new feature in the platform called Data Drift Detection. This course covers one of the objective areas that help you in preparing for the DP-100: Designing and Implementing a Data Science Solution on Azure exam.

lecture
0 (0)
54m | Intermediate | Apr 27 2020 |

This expert talk will cover how to parameterized data sources, Data Modelling, some useful DAX through quick measures, Report and Dashboard design tips and tricks, utilize Bookmarks and Tooltips, optimize layout for both Desktop and Phone and how to share collaborate Reports and Dashboard.

lecture
5 (1)
4h 58m | Beginner | May 26 2020 |

This course is geared toward the PL-900 exam which focuses a significant amount on business scenarios and uses for the components within the Power Platform. However, to understand which features, functionality, and products to use in the various scenarios presented, you need to understand the products themselves.So, in this course, our goal is to present you with and understanding of each of the components, so that when it does come to the exam, you’ll be able to successfully match up the fundamentals of what you should use when. While some of the demos and slides may go into the technical detail of how to accomplish things, for the purpose of the Power Platform fundamentals exam, you won’t need to know the how everything is built, but when to use the various components we’re building with.

lecture
4 (17)
9h 7m | Intermediate | Sep 6 2016 |

PowerShell is Microsoft’s strategic task automation platform for IT Pros, It is a key component of Microsoft’s overall management strategy. PowerShell consists of a scripting environment, a script development tool (the PowerShell ISE) and a wealth of add-on functionality in the form of modules. PowerShell also ships for down-level systems including Windows 7, 8.1 and Server 2012. This course provides a great foundation to PowerShell. It covers the fundamental aspects of PowerShell and demonstrates the many new and improved features that come with PowerShell Version 3. We also discuss PowerShell V4 and V5.

lecture
0 (0)
58m | Beginner | Nov 19 2020 |

Most users within an organization spend more time on a wireless Internet connection outside of a corporate connection than ever before. This creates a potential exposure of corporate data on a user’s device, email, or cloud storage, if it is not properly protected and secured. in this episode of Cloud Maker, Dwayne Natwick and Tim Hermie will discuss how Microsoft Defender for Identity and Microsoft Defender for Office 365 services can be used to both protect and educate users about the safety and security of corporate and personal data in the cloud. We will explore how Microsoft protects companies through their vast threat protection database to block potential attacks before they happen.

lecture
3 (1)
1h 37m | Beginner | Nov 25 2019 |

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.

lecture
0 (0)
30m | Intermediate | Apr 3 2020 |

In this course, you will learn how to use the SQL API to write T-SQL like queries against your Cosmos DB collections. We’ll explore how partitioning and partition keys affect query performance and how to tune for faster results. This course will also explore how to write server-side queries, such as stored procedures, triggers, and user-defined functions.

lecture
5 (2)
36m | Beginner | Mar 9 2020 |

In this course you will learn about building interactive reports. We will also discuss helpful data visualization techniques in Power BI.

lecture
3 (2)
50m | Intermediate | Sep 17 2020 |

To get results from Azure Machine Learning, you must run Experiments. In this course we learn what experiments are, how they relate to Models and how to create them. Furthermore, this course will show you how to obtain output and metrics from Experiments and even how to automate the process using Azure Machine Learning. This course covers one of the objective areas that help you in preparing for the. DP-100: Designing and Implementing a Data Science Solution on Azure exam.

lecture
0 (0)
41m | Beginner | Oct 5 2020 |

To Microservice or not to Microservice, that is the question. When is it right to keep the monolithic solution, and how do you avoid keeping the monolithic application mindset when moving to serverless solutions? In this episode of Cloud Native, Brian Gorman will dive into discussions around the various platform-as-a-service offerings available at Azure to create a well-architected, instrumented, and robust microservices solution using tools like Azure Functions, Azure Logic Apps, Event Grid/Event Hub, ServiceBus Queues and Storage Queues, Storage and shared access tokens, and Data options and solutions. We’ll also talk about Azure App Services, API Management, Security, Identity and Azure active directory, and other critical features you will want to leverage when building out your production-ready serverless solutions.

lecture
1 (1)
45m | Intermediate | Sep 17 2020 |

Get introduced to Azure Machine Learning Service. In this course you will learn about the core environment for working with Azure Machine Learning: the Workspace. We also introduce the two primary concepts within the workspace required to make things happen: Data stores and Compute Contexts.This course covers one of the objective areas that help you in preparing for the. DP-100: Designing and Implementing a Data Science Solution on Azure exam.

lecture
4 (6)
2h 44m | Advanced | Feb 23 2017 |

This course covers In-Memory OLTP, Columnstore Indexing, Real-time Analytics, Query Store, JSON data in SQL Server and Extended Events with Availability Groups.

lecture
0 (0)
1h 5m | Beginner | Jul 22 2020 |

Since its birth Power Query has become an easy-to-use ETL tool.However, how can we exploit this ease of use?What is the best practice to do it?In this session you learn about how and what to do to achieve it.

lecture
5 (5)
54m | Beginner | Sep 16 2020 |

In this course, you will learn the evolution of computing to cloud computing. The course will guide you through the various types of cloud services, cloud deployment models, and how to understand shared responsibility between the cloud provider and the consumer. This course covers one of the objective areas that help you in preparing for the AZ-900 Azure Fundamentals exam.

lecture
5 (2)
43m | Beginner | Sep 16 2020 |

In this course, you will learn about the Azure service components and products. This course will familiarize you with the Azure geographic regions and zones, resources, and core Azure products, such as compute, app services, networking, containers, storage, and database services. This course covers one of the objective areas that help you in preparing for the AZ-900 Azure Fundamentals exam.

lecture
0 (0)
38m | Intermediate | Apr 2 2020 |

In this course, you will learn how the resource model works in Cosmos DB. We will discuss containers, databases, and understand how request units translates to the Cosmos DB billing model as well as how reserved capacity can be used to save on your Azure bill.

lecture
0 (0)
1h 2m | Beginner | Nov 4 2020 |

Interest in the cloud continues to grow. Many organizations are looking to adopt and migrate applications and data to Azure to reduce capital expenses and costly data centers. As administrators, architects, developers, and engineers, what are you doing to keep up with the accelerated organizational adoption of cloud technologies? How are you determining that your architecture is following best practices? In this episode of Thinking Cloudy, Shannon Kuehn and Dwayne Natwick will explore the Azure Well Architected Framework to help speed up digital transformation.After this discussion, you will have a better idea of how you can build and architect best practice Azure cloud services.

lecture
0 (0)
56m | Beginner | Oct 2 2020 |

In this episode of Cloud Maker, Dwayne Natwick and Wim Matthyssen will discuss the use of Azure Sentinel as a cloud-native SIEM solution for your organization. We will show how it can be used for monitoring security events in Azure, Microsoft 365, and hybrid networks. We will show how the investigation tools tied to the Microsoft global threat database and artificial intelligence can detect anomalies within the environment that can be identified and rectified to protect the organization.

lecture
0 (0)
1h 49m | Beginner | Jul 8 2020 |

In this course, we will take you through the key features of SQL Server 2019. Throughout the course you will learn about intelligent performance, security, availability, Linux, Kubernetes, big data, as well as other topics.

real-time lab
5 (1)
1h 15m | Beginner | Jun 19 2020 |

In this lab, you will provision how to provision a Databricks workspace, an Azure storage account, and a Spark cluster. You will learn to use the Spark cluster to explore data using Spark Resilient Distributed Datasets (RDDs) and Spark Dataframes.

real-time lab
0 (0)
4h | Intermediate | Feb 20 2019 |

In this lab, you will author and execute multiple stored procedures within your Azure Cosmos DB instance. You will explore features unique to JavaScript stored procedures such as throwing errors for transaction rollback, logging using the JavaScript console and implementing a continuation model within a bounded execution enviornment.

real-time lab
5 (2)
45m | Beginner | Mar 3 2020 |

In this lab, you will create a report that contains multiple visuals as well as text boxes and buttons. You will add bookmarks to allow users to see a particular view.

real-time lab
4 (4)
1h 30m | Intermediate | Jan 12 2020 |

The students will be able to describe and demonstrate the capabilities that Azure Cosmos DB can bring to an organization. They will be able to create a Cosmos DB instance and show how to upload and query data through a portal and through a .Net application. They will then be able to demonstrate how to enable global scale of the Cosmos DB database.

real-time lab
5 (1)
2h 55m | Advanced | Sep 26 2018 |

In this lab, you will learn techniques for troubleshooting and turning performance with a Cosmos DB database. You will learn about the different consistency levels Cosmos offers for your data, as well as work with different data partitioning strategies that impact the performance of your queries. From there, you will learn how to monitor the performance of your queries.

real-time lab
0 (0)
4h | Intermediate | Feb 20 2019 |

In this lab, you will create multiple Azure Cosmos DB containers. Some of the containers will be unlimited and configured with a partition key, while others will be fixed-sized. You will then use the SQL API and .NET SDK to query specific containers using a single partition key or across multiple partition keys.

real-time lab
4 (9)
1h 30m | Beginner | Sep 9 2020 |

In this lab you will create an Azure SQL Database using the Azure Portal and connect to it using SQL Server Management Studio. You will then migrate a SQL Server database hosted on a virtual machine to an Azure SQL Database.

real-time lab
3 (3)
1h 45m | Beginner | Jan 11 2020 |

In this lab you will be able to explain why Azure Databricks can be used to help in Data Science projects. You will provision and Azure Databricks instance and will then create a workspace that will be used to perform a simple data preparation task from a Data Lake Store Gen II store. Finally, the student will perform a walk-through of performing transformations using Azure Databricks.

real-time lab
0 (0)
3h 45m | Intermediate | Jun 30 2020 |

MS - 600: Extending Office Overview The lab in this course have been prepared for a Microsoft Teams deployment at Contoso Ltd. Corporation. Contoso is running a Microsoft 365 cloud only deployment. The lab environments have been specifically designed in this manner to give you experience managing Microsoft Teams in a Microsoft 365 deployment. You will be provided with two virtual machines and a Microsoft 365 tenant to complete the lab steps.

real-time lab
0 (0)
3h 45m | Intermediate | Jul 2 2020 |

MS - 600: Extending Teams Overview In this lab, you will Understand the components of a Microsoft Teams app, webhooks in teams, tabs in teams, and messaging extensions in teams.

real-time lab
4 (3)
30m | Beginner | Mar 4 2020 |

In this lab, you will learn the basics of acquiring data using Power BI Desktop. You will import Excel files into Power BI Desktop and transform the data. You will use Power Query/M to connect to data sources such as SQL Databases, Excel files, text files, JSON files, and websites and then cleanand shape the data with Power Query/M.

real-time lab
4 (53)
1h 40m | Beginner | Sep 28 2020 |

In this lab, you will create a virtual network that will allow the virtual machines you create to securely connect with each other. You will then create two virtual machines and specify the virtual network configuration and the availability set configuration along with storage for the virtual machine.

real-time lab
5 (35)
1h 15m | Intermediate | Oct 22 2020 |

In this lab, you will create an Azure Web App and a SQL Database and configure the popular content management system (CMS) Orchard CMS. You will then configure the web app to automatically scale based on actual CPU usage.

real-time lab
5 (1)
1h 10m | Advanced | Apr 7 2020 |

In this lab, we will explore the use of columnstore indexes in Azure SQL Database. We will evaluate the performance improvements we get when we implement columnstore indexes on tables for with analytical workloads. 

real-time lab
0 (0)
4h | Advanced | Aug 28 2020 |

MS - 600: Implementing Microsoft Identity Overview You are a developer in a large organization that is currently supporting applications and .NET solutions with multiple identity providers. To centralize the identity management for your organization, you decided to use Azure Active Directory to simplify the access to internal and external applications. You registered applications in Azure, implemented authentication, configured permissions for consuming the API, and created a service to access Microsoft Graph. As a result, IT can manage all applications from a centralized location to provide users a seamless sign-in experience.

real-time lab
4 (1)
40m | Intermediate | Jan 10 2018 |

In this lab, you will explore columnstore indexes in SQL Server 2016. You will evaluate the performance improvements you will get when you implement columnstore indexes on tables for your analytical workloads.

real-time lab
5 (1)
1h | Beginner | Jun 24 2020 |

Spark structured streaming enables you to use the dataframe API to read and process an unbounded stream of data. This kind of processing is used in real-time scenarios to aggregate data over temporal intervals or windows. You can use Spark to process streaming data from a wide range of sources, including Azure Event Hubs, Kafka, and others. In this lab, you will run a Spark job to continually process a real-time stream of data.

real-time lab
5 (1)
40m | Beginner | Aug 4 2020 |

In this lab, you will learn the basics of importing CSV files into a Power BI model and adjusting query and column properties to prepare them for your data model. Then you will set table and column properties in the data model and create relationships between tables.

real-time lab
5 (1)
40m | Intermediate | Jul 23 2020 |

In this lab, you will explore the new SQL Server 2016 In-Memory OLTP feature. You will evaluate the performance improvements you will get when you migrate disk-based tables and interpreted T-SQL stored procedures into memory-optimized tables and natively-compiled stored procedures, respectively.

real-time lab
5 (2)
45m | Intermediate | Jul 23 2020 |

In this lab, you will deploy and configure an on-premises gateway to work with Azure Logic Apps. The on-premises data gateway acts as a bridge, providing quick and secure data transfer between on-premises data (data that is not in the cloud) and the Power BI, Microsoft Flow, Logic Apps, and PowerApps services.

real-time lab
5 (1)
1h | Beginner | Jun 24 2020 |

Spark includes an API named Spark MLLib (often referred to as Spark ML), which you can use to create machine learning solutions. Machine learning is a technique in which you train a predictive model using a large volume of data so that when new data is submitted to the model it can predict unknown values. The most common types of machine learning are supervised learning and unsupervised learning. In a supervised learning scenario, you start with a large volume of data that includes both features (categorical and numeric values that describe characteristics of the entity you’re trying to predict something about) and labels (the value your model will predict. Training the model involves applying a statistical algorithm that fits the features to the labels. Because your initial data includes known values for the labels, you can train the model and test its accuracy with these known label values – giving you confidence that the model will work accurately with new data for which the label values aren’t known. Unsupervised learning is a technique in which there are no known label values, and the model is trained to group (or cluster) similar entities together based on their features.In this lab, we’ll focus on supervised learning; and specifically a type of machine learning called classification in which you train a model to identify which category, or class an entity belongs to. You will train a classifier to use features of flights that are enroute to an airport, and predict whether they will be late or on-time.

real-time lab
5 (3)
1h 40m | Intermediate | Feb 15 2019 |

In this lab, you will use PowerShell to manage Azure SQL Database. You will create a logical Azure SQL Server via PowerShell. You will then manage the firewall to allow remote connectivity to allow for client access. You will restore a database from an existing BACPAC file. Finally, you will use PowerShell to scale the database performance and pricing tier.

real-time lab
5 (6)
1h 15m | Beginner | Oct 27 2020 |

In this lab, you will learn how to configure and manage an Azure Cosmos DB Account (formerly Azure DocumentDB), including how to query and manage JSON documents within a Collection. Among the topics covered are using SQL language syntax to perform document queries that return JSON results, and implementing and testing global data replication and fail over.

real-time lab
5 (4)
1h 25m | Advanced | Oct 10 2018 |

In this lab, we will walk through management and monitoring of an Elastic Pool. First, we will create an Elastic Pool and add our databases to the pool. Then we will monitor the performance of our pool using TSQL Scripts and the Azure Portal. DOWN FOR MAINTENANCE

real-time lab
0 (0)
40m | Intermediate | Jul 23 2020 |

In this lab, you will configure and manage the query store in SQL Server 2016 to collect runtime statistics, queries, query plan history and other workload history within the database to assist with troubleshooting query performance issues, you will then identify and resolve poor performing queries in your database using SQL Server 2016 Query Store. You will also identify query plan regressions and how to address them with information gathered from the Query Store.

real-time lab
5 (2)
1h | Beginner | Nov 23 2020 |

In this lab, you will learn how to provision a Databricks workspace, an Azure storage account, and a Spark cluster. You will then execute and manage a Spark Job.

real-time lab
5 (1)
30m | Beginner | Mar 3 2020 |

In this lab, you will import Excel and CSV files into Power BI Desktop and then merge queries, group data, and group queries in the query pane. It is common to have to pull data from transactional systems and shape them. It is also common to add data from other sources to provide a more complete picture.First, you will stage the data from the multiple sources. Then you will merge and group data to get final reporting tables to be used in Power BI. Then you will disable staging queries. Finally, you will organize your queries into folders for better organization.

real-time lab
4 (2)
1h 15m | Intermediate | May 1 2020 |

In this module, you will learn how Azure Data factory can be used to orchestrate the data movement from a wide range of data platform technologies. You will be able to explain the capabilities of the technology and be able to set up an end to end data pipeline that ingests data from SQL Database and load the data into SQL Data Warehouse. You will also demonstrate how to call a compute resource.

real-time lab
5 (2)
45m | Intermediate | Jan 12 2020 |

The students will be able to describe what data streams are and how event processing works and choose an appropriate data stream ingestion technology for the AdventureWorks case study. They will provision the chosen ingestion technology and integrate this with Stream Analytics to create a solution that works with streaming data.

real-time lab
5 (1)
30m | Beginner | Mar 3 2020 |

In this lab, you will implement basic row-level security in Power BI Desktop and PowerBI.com. First, you will create roles on a model in Power BI and add filters for each role. Then you will deploy the model and test the row-level security in PowerBI.com. Then you will add members to the role in PowerBI.com.

real-time lab
5 (1)
30m | Beginner | Jul 23 2020 |

In this hands-on lab, you will learn how to format output using PowerShell. This will involve formatting with the pipeline and format-table/format list. You will also learn to use the --f operator and format with hash tables. Finally, you will use out-of-grid view.

real-time lab
5 (1)
30m | Beginner | Jul 23 2020 |

In this hands-on lab, you will learn about using PowerShell Providers. This lab will involve viewing providers, using the registry provider, and using the certificate provider.

real-time lab
0 (0)
4h | Intermediate | Feb 20 2019 |

In this lab, you will use the .NET SDK to tune an Azure Cosmos DB request to optimize performance of your application.

real-time lab
0 (0)
30m | Beginner | Jul 23 2020 |

In this hands-on lab, you will learn how to use objects with PowerShell. You will work with .NET objects, COM objects, and WMI objects.

real-time lab
0 (0)
30m | Beginner | Jul 24 2020 |

In this hands-on lab, you will learn about using modules to organize your code with PowerShell. You will examine snap-ins and modules, create a simple module, and create a module manifest.

real-time lab
5 (1)
30m | Beginner | Jul 24 2020 |

In this hands-on lab you will work with the PowerShell Integrated Scripting Environment (ISE). This lab will begin by demonstrating the general layout and structure of the ISE. Then you will learn about using Intellisense. Finally you will learn about using Snippets in the PowerShell ISE.

real-time lab
5 (1)
50m | Beginner | Nov 28 2019 |

In this lab, you will learn the basics of time intelligence measures to show year-to-date, quarter-to-date, and month-to-date totals. Then you will use DAX to enhance the data model and build a table that lets users choose which measures they want to see.

real-time lab
0 (0)
5h 45m | Intermediate | Aug 28 2020 |

MS - 600: Work with Microsoft Graph Overview As a developer at a large enterprise that needs a governance plan and approval process around the creation of Office 365 Teams and Groups, you will support the plan to meet requirements in the most efficient way. As you set out to meet the objectives, you need to collect data from many separate Microsoft 365 services. Focusing on simplifying programming and authentication, Microsoft Graph provides a single point of access to a wide range of Microsoft resources, supporting you with the range of data needed to complete requirements for the plan.

real-time lab
5 (4)
45m | Beginner | Jan 11 2020 |

In this lab, you will create Azure storage accounts and Data Lake Storage account and explain the difference between Data Lake Storage version 1 and version 2. You will also demonstrate how to perform data loads into the data storage of choice.

real-time lab
0 (0)
1h 5m | Intermediate | Jan 12 2020 |

The students will be able to provision an Azure SQL Database and Azure Synapse Analytics server and be able to issue queries against one of the instances that are created. They will be also be able to integrate a data warehouse with a number of other data platform technologies and use PolyBase to load data from one data source into Azure Synapse Analytics.

learning path
0 (0)
0 Lectures | 0 Labs |

Microsoft Open Hacks

learning path
4 (18)
5 Lectures | 6 Labs | 7h 59m | Beginner | Certification Prep

In this this learning path you will explore Power BI Desktop and the the Power of PowerBI.com deploy datasets and reports as well as deploying, sharing, and securing assets in PowerBI.com. You will learn how to model data using DAX, as well as build reports and visualizations through on-demand courses and interactive hands-on labs.

learning path
4 (42)
3 Lectures | 5 Labs | 12h 51m | Advanced

In this learning path, you will learn how to implement Azure Database. Topics will include understanding to design and deploy databases using SQL DB and SQL Datawarehouse along with more advanced topics of performance and troubleshooting for SQL.

learning path
5 (7)
4 Lectures | 5 Labs | 18h 36m | Advanced

In this learning path, you will take a deep dive into Azure Cosmos DB, Throughout the path you will design documents and collections for real time implementations, create user-defined functions, stored procedures and triggers, tuning databases, monitoring performance along with troubleshooting techniques and best practices.

learning path
4 (16)
2 Lectures | 4 Labs | 10h 47m | Intermediate

In this learning path, you will learn the fundamentals of Azure DataBricks and as new courses are added to the path you will progressively learn more advanced topics.

learning path
4 (8)
1 Lectures | 3 Labs | 4h 44m | Advanced

In this learning path, you will learn from the fundamentals of SQL Server relational databases to advanced capabilities,

learning path
4 (96)
6 Lectures | 2 Labs | 6h 54m | Intermediate | Certification Prep

In this learning path, you will learn key concepts about the cloud and various Microsoft Azure Services. From there, you will learn core concepts such as various PaaS and IaaS services including management tools. This course will also cover several key concepts for security and compliance, as well as a brief look at a Azure pricing and support. This course will help you prepare for AZ 900 Microsoft Azure Fundamentals.

learning path
5 (10)
4 Lectures | 0 Labs | 5h 30m | Intermediate

In this learning path, you will learn the basics of data science including what data science is, some of the common programming languages used in data science (R and Python) as well as an introduction to machine learning.

learning path
4 (96)
6 Lectures | 2 Labs | 6h 54m | Intermediate | Certification Prep

In this learning path, you will learn key concepts about the cloud and various Microsoft Azure Services. From there, you will learn core concepts such as various PaaS and IaaS services including management tools. This course will also cover several key concepts for security and compliance, as well as a brief look at a Azure pricing and support. This course will help you prepare for AZ 900 Microsoft Azure Fundamentals.

learning path
4 (21)
3 Lectures | 6 Labs | 12h 8m | Intermediate | Certification Prep

This learning path contains a collection of courses and hands-on labs designed to help you pass the exam DP-200: Implementing an Azure Data Solution

learning path
4 (3)
2 Lectures | 0 Labs | 3h 7m | Beginner

This learning path is designed to teach you the fundamentals of relational databases using Microsoft SQL Server. You will learn core concepts such as tables, indexes, and building relationships with foreign keys. From there, you will learn how to write queries using T-SQL to query data as well as make changes to your database.

learning path
5 (4)
3 Lectures | 0 Labs | 6h 45m | Intermediate | Certification Prep

This learning path contains a collection of courses and hands-on labs designed to help you pass the exam DP-201: Designing an Azure Data Solution

learning path
2 (6)
4 Lectures | 2 Labs | 5h 35m | Intermediate | Certification Prep

This track has a collection of demonstrations, presentations, and interactive labs designed to prepare you for the Microsoft DP-100 exam.

learning path
4 (20)
1 Lectures | 5 Labs | 11h 37m | Intermediate

In this learning path, you will find courses and hands-on labs to teach you the ins and outs of using PowerShell.

learning path
0 (0)
1 Lectures | 0 Labs | 1h 49m | Beginner

This learning path contains recordings and hands-on labs based off of the SQL Server 2019 workshop development by the Microsoft SQL Server product team. You will learn about SQL Server intelligent performance features, new security features, modern development capabilities, how to use SQL Server 2019 on Linux + Containers, as well as new features with big data and data virtualization.

learning path
5 (3)
10 Lectures | 0 Labs | 11h 35m | Intermediate

This track contains a collection of expert talks recorded by Azure Data Professionals

learning path
5 (1)
2 Lectures | 0 Labs | 2h 7m | Intermediate

This track contains a collection of expert talks recorded by Power BI Experts.

learning path
5 (1)
2 Lectures | 0 Labs | 5h 58m | Beginner | Certification Prep

This course is geared toward the PL-900 exam which focuses a significant amount on business scenarios and uses for the components within the Power Platform. However, to understand which features, functionality, and products to use in the various scenarios presented, you need to understand the products themselves. So, in this course, our goal is to present you with and understanding of each of the components, so that when it does come to the exam, you’ll be able to successfully match up the fundamentals of what you should use when. While some of the demos and slides may go into the technical detail of how to accomplish things, for the purpose of the Power Platform fundamentals exam, you won’t need to know the how everything is built, but when to use the various components we’re building with.

learning path
0 (0)
0 Lectures | 0 Labs |

In this Learning Path we will discuss the methods and best practices in line with both business and technical requirements for modeling, visualizing data Power BI. We will also cover how to access and process data from a variety of different data sources including both relational and non-relational data. This course will also cover how to implement the proper security standards and policies across the Power BI spectrum. We will move on to discuss how to manage and deploy reports and dashboards for sharing as well as content distribution. We will wrap up by showing how to build paginated reports within the Power BI service and how to publish them to a workspace for inclusion within Power BI.

learning path
0 (0)
3 Lectures | 4 Labs | 22h 25m | Advanced | Certification Prep

In this learning path, students are educated on the proficiencies of a Microsoft identity and Microsoft Graph. Students will practice how to administer Microsoft Teams within an organization to support modern collaboration workloads. Topics include application deployment, messaging, meetings, audio conferencing, client configuration, compliance policies, security practices, guest collaboration, networking requirements, and integration with existing applications. Migration planning and upgrade paths for Skype For Business services is also covered as an important topic for organizations today. Tasks are demonstrated using both the administrator portal and Windows PowerShell.

learning path
0 (0)
0 Lectures | 0 Labs |

Cloud Maker episodes feature discussions and information about cloud architecture. These episodes include cloud migration best practices, cloud architecture, security, and building solutions utilizing the Microsoft Cloud. If you are architecting and building services with Azure, Microsoft 365, and hybrid infrastructures, Cloud Maker is the place to go to find information.

learning path
0 (0)
0 Lectures | 0 Labs |

Cloud Native episodes feature discussions and information about application development on the cloud. These episodes include application development of cloud native applications, CI/CD utilizing Git, GitHub and Azure DevOps, creating scalable applications with C#, Python, PowerShell, CLI and other coding tools, and utilizing platform and serverless services, such as Azure Functions, Logic Apps, IoT and cognitive services. If you are creating and using code and serverless computing, Cloud Native is the place to go to find information.

lecture
2 (3)
5h 38m | Intermediate | Apr 12 2019 |

In this course, you will explore the Spark Internals and Architecture. The course will start with a brief introduction to Scala. Using the Scala programming language, you will be introduced to the core functionalities and use cases of Apache Spark including Spark SQL, Spark Streaming, MLlib, and GraphFrames.

lecture
0 (0)
1h 9m | Beginner | May 27 2020 |

The Azure container alphabet soup, ACR, ACI, AKS, AWC, DCK,...Containers are popular, and especially in a cloud environment. But often it is hard to decide on where to run them, how to run them and what service is better than another. Even within a single cloud platform like Azure, you have a few different capabilities. Learn in this session from Peter, an Azure Business Program Manager within Microsoft, passionate Azure trainer and former Azure MVP, how you can containerize your applications, and run them in different Azure Container services. As typical for Peter's sessions, this is packed with demos, to-the-point, and no marketing fluff.

lecture
0 (0)
55m | Beginner | Jul 21 2020 |

Did you ever wonder what NoSQL is about? Then you've just came across the right Expert Talk to see how to provision and use Azure CosmosDB. Azure CosmosDB is a NoSQL offering in Azure, which allows you to provision several types of NoSQL database engines based on your workload. In the talk we'll see how to get the best from the deployment.

lecture
0 (0)
23m | Beginner | Sep 16 2020 |

In this course, you will learn to identity ways to plan and manage costs and purchase services within Azure, how to understand the Azure Service Level Agreements and calculating a composite SLA for more than one service combination, and understanding the service lifecycle within Azure. This course covers one of the objective areas that help you in preparing for the AZ-900 Azure Fundamentals exam.

lecture
5 (2)
1h 37m | Intermediate | Aug 12 2019 |

This course is an introduction to Microsoft Azure Machine Learning Services. In this course you will learn to navigate the AML Services interface, create notebook servers, create compute clusters, manage AML Services from a notebook, deploy models, and create an Automated Machine Learning experiment.

lecture
0 (0)
1h | Beginner | May 29 2020 |

Azure SQL Database is a popular database engine available in Azure environment which can be utilized for both building new applications and also for modernization migration of your existing environment. In this Expert Talk we'll see how to provision and configure the database service for scalable and secure operations.

lecture
5 (4)
4h 42m | Advanced | Sep 15 2017 |

This course will be a deep dive into Azure SQL Database performance. We will look at designing an Azure SQL Database architecture for performance. We will look at performance specific features of Azure SQL Database. We will also cover monitoring and troubleshooting.

lecture
5 (1)
Azure Synapse Analytics
Beginner | Coming Soon!

Let's dive in together into the brand new big data data warehouse solution running on Microsoft Azure. Azure Synapse brings the best from data analytics, ingestion and reporting tools available in one single piece.

lecture
0 (0)
1h | Intermediate | Apr 28 2020 |

Database workloads demand good storage performance in order to work well, and Azure offers you a lot of storage options. In this expert talk, you will learn about principals of Azure Storage and how it works in conjunction with Virtual Machines. You’ll learn options for how to configure you storage for optimal performance, and options for balancing your cost versus performance. Finally, you’ll learn the best practices for how to layout your SQL Server files.

lecture
0 (0)
33m | Intermediate | Apr 3 2020 |

In this course, you will learn techniques for making your application scale and be ready for production. We’ll explore common troubleshooting techniques you can use for your application, as well discuss how to design for data concurrency. This course will also explore the Cosmos DB Change Feed feature for building event driven applications with Cosmos DB. Finally, the course will close on how to distribute your Cosmos backend globally using multiple Azure regions.

lecture
0 (0)
31m | Beginner | Oct 9 2020 |

In this episode of Cloud Maker, Kit Skinner will talk about the options to bring the Azure cloud closer to your physical presence. If a gigabit and 100ms isn’t enough for your solution, or restrictions require your compute to be close to your devices, or you’re the GoaT of IoT but you still want the dynamic and versatile features of the Azure services, there are options to bring the Azure cloud to your doorstep. We’ll go over Azure Stack in all its flavors (Edge, HCI, Hub, etc.) and discuss ways to utilize it in your environment.

lecture
5 (1)
15m | Beginner | Sep 16 2020 |

In this course, you will learn about the core solutions within Azure and the management tools that are available. These include Internet of Things (IoT), big data and analytics, artificial intelligence, serverless computing, and DevOps. You will get a high-level understanding of the tools available to create resources, automate, and govern resources within Azure. This course covers one of the objective areas that help you in preparing for the AZ-900 Azure Fundamentals exam.

lecture
0 (0)
44m | Intermediate | Apr 3 2020 |

In this course, you will learn how to model data using the JSON based document model, and understand how data schemas are still applicable in Cosmos DB. From there, this course will take a look at one of the most important aspects of building a high-performance database and that is data partitioning.

lecture
5 (2)
1h 35m | Beginner | Mar 6 2020 |

In this course we will cover Data Modeling and the xVelocity Engine. We will also discuss DAX Basics along with Advanced DAX and optimizing the data model.

lecture
5 (1)
33m | Beginner | Mar 6 2020 |

This course will cover the basics of acquiringdata in Power BI Desktop andbuilds on the data acquisition basics and adds performance optimization and re-usability techniques.

lecture
1 (1)
36m | Intermediate | Sep 18 2020 |

Now you have a good, trained model. How can you use it? In this course we explore the various ways that models can be deployed for making single predictions as well as batch predictions. You will learn the various types of deployment environments that exist and how to choose compute for those. This course will also teach you how to convert your existing training pipelines into deployable inferencing pipelines. This course covers one of the objective areas that help you in preparing for the DP-100: Designing and Implementing a Data Science Solution on Azure exam.

lecture
0 (0)
55m | Beginner | Oct 1 2020 |

In this episode of Cloud Maker, join Kit Skinner and Dwayne Natwick for a down to Earth, simplified discussion about deployments in Azure. Whether you're looking to leave the nest, build your own nested deployments, or just understand how Jason is related to your Azure resources, we’ll help you to understand why we’re on this track in Azure, how it really can make your life easier, and what to expect in the future for your next ARM day. We will also go over how you can reutilize deployments and utilize others’ published templates to help ease your tasks.

lecture
5 (2)
3h 6m | Intermediate | Nov 27 2019 |

In this course, students will gain knowledge and skills needed to design data storage solutions. Topics will include recommending the correct storage based on business and technical requirements, designing relational and non-relational cloud data stores. Specific focus points will be around data distribution, partitioning, designing for scale, high availability and disaster recovery on Cosmos DB, SQL Database, Azure Synapse Analytics, Data Lake Store Gen2 and Blob storage.

lecture
5 (2)
1h 57m | Intermediate | Oct 11 2019 |

This course covers designing of data processing solutions. We will look at leveraging Data Factory and Databricks and choosing optimal batch processing technology. The course will also include the design of real-time processing solutions with Stream Analytics and Azure Databricks.

lecture
0 (0)
1h 40m | Intermediate | Jan 20 2020 |

This course covers designing for data security and compliance. We will discuss securing source data access with endpoint security and authentication, securing data with encryption at rest and in transit. We will also cover data governance and compliance topics such as auditing, classification and data retention policies.

lecture
5 (1)
1h 45m | Intermediate | Jul 22 2020 |

In this expert Talk,  Jen Stirrup will go in-depth on what to expect for the exam Designing and Implementing a Data Science Solution on Azure (DP 100). Her talk starts with a review of the exam skills and what is measured, and then will step through each of the objectives and quickly review the key points of the exam as well as sample questions to help test your knowledge in each area.

lecture
0 (0)
1h 9m | Intermediate | May 8 2020 |

You are already familiar with T-SQL and are eager to learn R but do not know where to start? Start from what you already know: T-SQL. Both languages have many things in common on some levels, but are very different on others. You will learn how to begin your first steps in the new language and how to perform the most common tasks, typical for R: statistics, machine learning data visualization.This session will kick you off to the new language by using analogies from T-SQL. You will learn how to write your first R-scripts, make usage of packages and will leave this session with a basic understanding of typical use-cases of R and how to integrate that into your existing environment with SQL Server.

lecture
5 (2)
1h 29m | Beginner | Mar 19 2019 |

The course will teach you the fundamentals of the relational database model and how to access data stored in relational databases. The course will give students an understanding of relational database concepts and teach the practical application of these concepts through the T-SQL programming language for Microsoft SQL Server and Azure SQL Database.

lecture
0 (0)
43m | Beginner | Sep 16 2020 |

In this course, you will get an understanding of the security challenges to an organization within the cloud. You will learn some ways to build a defense in depth strategy utilizing Azure security tools, such as Azure Security Center, Azure Sentinel, Azure Key Vault, and other network security services. This course covers one of the objective areas that help you in preparing for the AZ-900 Azure Fundamentals exam.

lecture
0 (0)
1h 40m | Beginner | Jul 22 2020 |

In this expert talk you will learn how to plan smarter, collaborate better, and ship faster with Azure DevOps Services. You will discover some of the team and collaboration capabilities as well as learn the basics of setting up pipelines for continuous integration and deployment in this demo packed exclusive session.

lecture
0 (0)
57m | Beginner | Nov 12 2020 |

Interest in the cloud continues to grow. Many organizations are looking to adopt and migrate applications and data to Azure to reduce capital expenses and costly data centers. As administrators, architects, developers, and engineers, what are you doing to architected and deploy cloud technologies in your organization? In this episode of Cloud Maker, Shannon Kuehn and Dwayne Natwick will explore Azure Landing Zones to and how they are used to continue your digital transformation.After this discussion, you will have a better idea of how you can build scalable and modular Azure cloud services.

lecture
0 (0)
33m | Beginner | Oct 22 2020 |

How do you maintain communication with disconnected personnel? Organizations are facing a gigantic change in processes and procedures during COVID-19. Obviously, one of the largest is communication and inter-communications of personnel working from home and the field. In this episode of Cloud Native, Brian Nielsen will go over the features in the Microsoft Teams mobile app and how it can keep your organization connected and more productive.

lecture
5 (1)
1h 1m | Intermediate | May 4 2020 |

Power BI is a self-service Business Intelligence tool, which does a great job in hiding complexity and technology away from the user. But when it comes to performance and even correct numbers, one should spend some time in finding the right way of modelling the tables and how they are related to each other. In this talk we spend an hour on doing exactly that. You will get answers to questions like: Why should you care about the data model? What kind of relations are available? How do they influence performance? Why redundancy is (not) a bad thing?

lecture
0 (0)
58m | Beginner | Sep 16 2020 |

In this course, you will learn about the various tools for Identity and Access Management, governing Azure resources with role-based access control and resource locks and using Azure Policy for cost and resource compliance. We will discuss how Azure can assist in regulatory and governmental compliance. This course covers one of the objective areas that help you in preparing for the AZ-900 Azure Fundamentals exam.

lecture
5 (3)
2h 42m | Intermediate | Dec 30 2019 |

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.

lecture
5 (7)
23m | Beginner | Aug 24 2016 |

In this hands-on course, students will learn about Azure SQL Data Warehouse. This course will review basic architecture of Azure SQL Data Warehouse. We will cover tools used with Azure SQL Data Warehouse, loading SQL Data Warehouse and basic workload management in SQL Data Warehouse.

lecture
5 (12)
1h 15m | Beginner | Sep 17 2016 |

In the course Introduction to Azure SQL Database we will discuss the configuration, performance, security, availability, recovery and automation of Azure SQL Database. We will also review hybrid solutions with SQL Server Stretch Database. This course will partially help prepare you for exam 70-473 Designing and Implementing Cloud Data Platform Solutions.This course will help you prepare for Microsoft Exam 70-533 - Implementing Azure Infrastructure Solutions and 70-532 Developing Azure Solutions as well.

lecture
5 (5)
45m | Beginner | Jan 14 2019 |

This course covers the necessary tools and concepts used in the data science industry to include machine learning, statistical inference, working with data at scale and much more.

lecture
5 (8)
54m | Intermediate | Jul 4 2018 |

This training provides an overview of Azure Databricks and Spark. In this course you will learn where Azure Databricks fits in the big data landscape in Azure. Key features of Azure Databricks such as Workspaces and Notebooks will be covered. Students will also learn the basic architecture of Spark and cover basic Spark internals including core APIs, job scheduling and execution. This class will prepare developers and administrators for more advanced work in Azure Databricks such as Python or Scala development.

lecture
5 (2)
32m | Beginner | Mar 6 2020 |

Welcome to this introduction to Power BI for data professionals. In this course, we will have an overview of the Power BI ecosystem. Then we will have a tour of Power BI Desktop.

lecture
5 (1)
1h 8m | Beginner | Sep 9 2019 |

This course is an introduction to Python. In this course you will learn which IDE is right for you, print statements, data types, control flow, Python functions and anonymous functions, methods, file io, and an introduction to Python packages.

lecture
5 (2)
1h 59m | Intermediate | Jul 2 2019 |

This course covers introduction to the R Language. We start off with an introduction to R verisons and R Editions then move to R the language. From there will dive into one of R’s strongest features, Graphics. Using base R graphics and GGPlot you will learn how to get started, and learn how to create your own visualizations.

lecture
5 (2)
56m | Beginner | Mar 6 2020 |

In this course we will discuss an overview of the Power BI Service. We will also cover sharing and securing your report and designing Enterprise Solutions in Power BI.

lecture
0 (0)
1h 10m | Beginner | Oct 19 2020 |

Every organization has sensitive information that they need to protect. Whether it is a healthcare provider with Personal Health Information (PHI), a bank with client financial information, or any business that has social security numbers and bank accounts in their payroll systems, this information needs to be kept from unauthorized individuals. In this episode of Cloud Maker, Dwayne Natwick and Liam Cleary will discuss and demonstrate how Microsoft Data Protection and Classification services can be used to tag and label this sensitive information and create policies that can limit the exposure of this data to unauthorized individuals and bad actors.

lecture
5 (2)
1h 28m | Intermediate | Jan 24 2020 |

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.

lecture
0 (0)
50m | Beginner | Sep 23 2020 |

As more users and organizations are utilizing applications and platforms that are cloud native, such as Microsoft 365 and Azure, the importance of managing and protecting identities becomes a top priority among administrators and security personnel. In this episode of Cloud Maker, Dwayne Natwick and Wim Matthyssen will discuss how to protect identities within Azure Active Directory for Microsoft 365, Azure, and hybrid users. We will show how conditional access policies can be used to protect against sign-in, user, and device risk, and how Privileged Identity Management can be used to decrease the identity attack surface of administrative privileges.

lecture
0 (0)
58m | Beginner | Oct 30 2020 |

As more users begin to rely on cloud applications to access information, how does a security administrator manage the governance of what applications are allowed within the corporate ecosystem. In this episode of Cloud Maker, Dwayne Natwick and Tim Hermie will take a look at how Cloud App Security can be used to create and govern the cloud applications that users have the ability to access and save data. We will also show how the Cloud App Security dashboard and Azure Sentinel can be used to monitor and investigate potential misuse of cloud applications.

lecture
0 (0)
58m | Beginner | Oct 23 2020 |

How does an organization monitor and manage information governance and data retention to protect themselves and their users from regulatory fines and legal issues. In this episode of Cloud Maker, Dwayne Natwick and Liam Cleary will discuss how Microsoft 365 Information Governance and Retention policies can be used to avoid accidental (or intentional) deletion of information that may be required to be held for a specified amount of time for regulatory, financial, or legal reasons. We will show how to create policies for information governance and retention requirements for data within the organization that is auto-applied to Exchange, SharePoint, OneDrive, and Teams data and communications.

lecture
0 (0)
1h | Beginner | May 27 2020 |

In this expert talk by Microsoft MVP Jesus Gil you will learn what Microsoft Flow is all about with real business use cases through a demo packed session.

lecture
5 (1)
52m | Intermediate | Feb 14 2020 |

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.

lecture
0 (0)
1h 2m | Beginner | Nov 19 2020 |

Interest in the cloud continues to grow. Many organizations are looking to adopt and migrate applications and data to Azure to reduce capital expenses and costly data centers. As administrators, architects, developers, and engineers, how are you going to execute the move the cloud? In this episode of Cloud Maker, Shannon Kuehn and Dwayne Natwick will explore the benefits and uses of Azure Migrate for discovery, estimate, and execute workload moves to the Azure cloud. After this discussion, you will have a better idea of how you can migrate workloads to Azure cloud services.

lecture
0 (0)
1h 30m | Intermediate | Jul 31 2020 |

In this course, students are introduced to deployment considerations for Microsoft Teams. Module topics include migration planning, networking requirements, guest access, information security, client endpoints, and system monitoring. Microsoft Teams Administrators are expected to understand these concepts to successfully deploy Microsoft Teams and promote rapid adoption within their organizations. Students will practice executing Microsoft Teams environment tasks via both the administrator portal and Windows PowerShell.

lecture
0 (0)
2h 29m | Intermediate | Sep 3 2020 |

In this course, students will learn how to manage groups within Microsoft Teams from both administrator and user perspectives. Module topics include creating and managing teams, modifying team memberships, team permissions, and application policies. Microsoft Teams Administrators are expected to apply and teach these skills within their organization to train users on managing their teams and memberships. Students will practice these tasks as both administrators and users to promote efficient team membership management.

lecture
0 (0)
1h 10m | Intermediate | Jul 13 2020 |

In this course, students will learn how to manage groups within Microsoft Teams from both administrator and user perspectives. Module topics include creating and managing teams, modifying team memberships, team permissions, and application policies. Microsoft Teams Administrators are expected to apply and teach these skills within their organization to train users on managing their teams and memberships. Students will practice these tasks as both administrators and users to promote efficient team membership management.

lecture
5 (1)
58m | Intermediate | Apr 27 2020 |

Dataviz guru Stephen Few once stated that we should “save the pies for dessert”. What he meant is that pie charts are good in some specific use cases, but they should not be used in others. The same is true for other chart types. Using the wrong type of chart will make it harder for report users to understand the story behind the data. To enable insights, information must be presented in the most intuitive way possible. You will leave this session with five easy-to-implement rules, which will guide you through the process of creating clear and attractive visualizations. Every rule will be applied through live demos in Power BI Desktop, where you will learn how to avoid pitfalls from the defaults and turn the right knobs to build clear and helpful visualizations.

lecture
0 (0)
1h 9m | Intermediate | Sep 22 2020 |

Join Shannon and Dwayne Natwick for this Expert Talk, where they will provide an overview of Microsoft’s next evolution of Azure VMware Solution (AVS). The new AVS solution is a first-party service offered on bare metal servers in Azure. The new offering allows customers to seamlessly extend, or completely migrate, existing on-premises VMware workloads to Azure without the cost, effort, or risk of re-architecting applications or retooling operations.

lecture
3 (2)
1h 23m | Intermediate | Sep 18 2020 |

What if Azure Machine Learning could do the hard work of model selection and optimization for you? What if it also could automatically explain the “why’s” of the model’s prediction process? Well it can! In this course we explore a few powerful features of Azure Machine Learning. In part one we will learn about Automated Machine Learning which makes algorithm selection a breeze. In part two we explore Hyperdrive, a feature that helps us find optimal Hyperparameter values. Then this course will introduce you to Interpretability in Azure Machine Learning. Finally, we learn about a powerful new feature in the platform called Data Drift Detection. This course covers one of the objective areas that help you in preparing for the DP-100: Designing and Implementing a Data Science Solution on Azure exam.

lecture
0 (0)
54m | Intermediate | Apr 27 2020 |

This expert talk will cover how to parameterized data sources, Data Modelling, some useful DAX through quick measures, Report and Dashboard design tips and tricks, utilize Bookmarks and Tooltips, optimize layout for both Desktop and Phone and how to share collaborate Reports and Dashboard.

lecture
5 (1)
4h 58m | Beginner | May 26 2020 |

This course is geared toward the PL-900 exam which focuses a significant amount on business scenarios and uses for the components within the Power Platform. However, to understand which features, functionality, and products to use in the various scenarios presented, you need to understand the products themselves.So, in this course, our goal is to present you with and understanding of each of the components, so that when it does come to the exam, you’ll be able to successfully match up the fundamentals of what you should use when. While some of the demos and slides may go into the technical detail of how to accomplish things, for the purpose of the Power Platform fundamentals exam, you won’t need to know the how everything is built, but when to use the various components we’re building with.

lecture
4 (17)
9h 7m | Intermediate | Sep 6 2016 |

PowerShell is Microsoft’s strategic task automation platform for IT Pros, It is a key component of Microsoft’s overall management strategy. PowerShell consists of a scripting environment, a script development tool (the PowerShell ISE) and a wealth of add-on functionality in the form of modules. PowerShell also ships for down-level systems including Windows 7, 8.1 and Server 2012. This course provides a great foundation to PowerShell. It covers the fundamental aspects of PowerShell and demonstrates the many new and improved features that come with PowerShell Version 3. We also discuss PowerShell V4 and V5.

lecture
0 (0)
58m | Beginner | Nov 19 2020 |

Most users within an organization spend more time on a wireless Internet connection outside of a corporate connection than ever before. This creates a potential exposure of corporate data on a user’s device, email, or cloud storage, if it is not properly protected and secured. in this episode of Cloud Maker, Dwayne Natwick and Tim Hermie will discuss how Microsoft Defender for Identity and Microsoft Defender for Office 365 services can be used to both protect and educate users about the safety and security of corporate and personal data in the cloud. We will explore how Microsoft protects companies through their vast threat protection database to block potential attacks before they happen.

lecture
3 (1)
1h 37m | Beginner | Nov 25 2019 |

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.

lecture
0 (0)
30m | Intermediate | Apr 3 2020 |

In this course, you will learn how to use the SQL API to write T-SQL like queries against your Cosmos DB collections. We’ll explore how partitioning and partition keys affect query performance and how to tune for faster results. This course will also explore how to write server-side queries, such as stored procedures, triggers, and user-defined functions.

lecture
5 (2)
36m | Beginner | Mar 9 2020 |

In this course you will learn about building interactive reports. We will also discuss helpful data visualization techniques in Power BI.

lecture
3 (2)
50m | Intermediate | Sep 17 2020 |

To get results from Azure Machine Learning, you must run Experiments. In this course we learn what experiments are, how they relate to Models and how to create them. Furthermore, this course will show you how to obtain output and metrics from Experiments and even how to automate the process using Azure Machine Learning. This course covers one of the objective areas that help you in preparing for the. DP-100: Designing and Implementing a Data Science Solution on Azure exam.

lecture
0 (0)
41m | Beginner | Oct 5 2020 |

To Microservice or not to Microservice, that is the question. When is it right to keep the monolithic solution, and how do you avoid keeping the monolithic application mindset when moving to serverless solutions? In this episode of Cloud Native, Brian Gorman will dive into discussions around the various platform-as-a-service offerings available at Azure to create a well-architected, instrumented, and robust microservices solution using tools like Azure Functions, Azure Logic Apps, Event Grid/Event Hub, ServiceBus Queues and Storage Queues, Storage and shared access tokens, and Data options and solutions. We’ll also talk about Azure App Services, API Management, Security, Identity and Azure active directory, and other critical features you will want to leverage when building out your production-ready serverless solutions.