Welcome to the ITG Technical Skilling Program!

You have been selected to register for course:

(AI-050) Develop Generative AI Solutions with Azure OpenAI Service

Starting Date: 02-Nov-2023
Ending Date: 03-Nov-2023
Modality: Virtual-Led
Location: Microsoft Teams Meeting
Language:
Please register below to reserve your seat...

Azure Skills Initiative

Microsoft advance program

10979F(5 Days)Introduction to Microsoft Azure for IT Professionals

AZ-103(4 Days)Azure Administrator

AZ-203(6 Days)Azure Developer

AZ-300(5 Days)Azure Solutions Architect Technologies

AZ-301(5 Days)Azure Solutions Architect Design

AZ-400(5 Days)Azure DevOps Solutions

Microsoft migration workshops

AZ-500T00A(1 Day)Azure Security Technologies

AI-100T01A(3 Day)Designing and Implementing an Azure AI Solution

DP-100T01A(1 Day)Designing and Implementing a Data Science Solution on Azure

DP-200T01A(3 Day)Implementing an Azure Data Solution

DP-201T01A(2 Day)Designing an Azure Data Solution


Thank you for your registration, you will be getting further instructions by email. 

Cloud Administrator - As companies move to the cloud, the need for cloud skilled professionals continues to rise. Companies need people with a range of skills; such as automation of deployments and workloads, to understanding how to best manage security and compliance. Through this program, students / professional learners will learn how to set up Microsoft Azure virtual machines, networks, and app services; automate workloads and deployment; and manage storage, identity, databases, security and compliance. 
Description: Deploy Windows; manage devices and data; configure connectivity; and maintain Windows.
Prerequisites: Microsoft 365 Fundamentals if needed. 
Description: Deploy and update operating systems; manage policies and profiles; manage and protect devices; and manage apps and data.
Prerequisites: Modern Desktop Administrator MD -100 
Description: Manage modern messaging infrastructure; manage mail flow topology; and manage recipients and devices.
Prerequisites: None listed 
Description: Plan and implement a hybrid configuration and migration; secure the messaging environment; and manage organizational settings.
Prerequisites: Messaging Administrator MS-200 
Description: Configure and manage SharePoint Online; configure and manage OneDrive for Business; configure and manage Teams; and configure and manage workload integrations.
Prerequisites: Experience with Windows PowerShell. Basic understanding of Active Directory and Azure AD. Basic understanding of mobile device management, and alternative operating systems (Android and macOS). Basic understanding of SQL Server management. Basic understanding of networking, including DNS. Working knowledge of windows server administration.  
Description: Configure and manage SharePoint On-Premises; configure and manage hybrid scenarios; and migrate to SharePoint Online.
Prerequisites: Teamwork Administrator Code MS-300  

Thank you for contacting ITG!

Please allow 24 hours for the processing of your request. Once it has been processed, you will receive an email with the course information.

Best regards,

ITG Inside Sales

Description: Implement and manage threat protection, implement and manage information protection and manage governance and compliance features in Microsoft 365.
Prerequisites: Basic conceptual understanding of Microsoft Azure. Experience with Windows 10 devices. Experience with Office 365. Basic understanding of authorization and authentication. Basic understanding of computer networks. Working knowledge of managing mobile devices.  
×

MS-900 Microsoft 365 Fundamentals

Module 1: Understanding Cloud Fundamentals
Lessons
  • Cloud Computing Overview
  • Microsoft Cloud Services
  • Migration to cloud services
Lab: Cloud Fundamentals
  • Exercise 1: Determine the appropriate cloud model (paper-based lab)
Module 2: Microsoft 365 Fundamentals
Lessons
  • Microsoft 365 core services
  • Microsoft on-premise services vs. Microsoft 365 cloud services
  • Enterprise Mobility in Microsoft 365
  • Collaboration in Microsoft 365
Lab: Enabling and configuring a Microsoft 365 tenant
  • Exercise 1: Activating and configuring a Microsoft 365 tenant
  • Exercise 2: Exploring the Microsoft 365 user and admin portal
  • Exercise 3: Configuring new user and group accounts
Module 3: Security, Compliance, Privacy and Trust in Microsoft 365
Lessons
  • Organization security overview
  • Identity basics
  • Devices and data protection
  • Compliance in Microsoft 365
Lab: Security in Microsoft 365
  • Exercise 1: Managing users and devices in Azure Active Directory
  • Exercise 2: Evaluate Identity Protection
  • Exercise 3: Explore tools for compliance
Module 4: Subscriptions and support in Microsoft 365
Lessons
  • Microsoft 365 Subscriptions, licenses, and billing
  • Support in Microsoft 365
Lab: Managing subscriptions, licensing and support in M365
  • Exercise 1: Explore interfaces for billing and subscriptions
  • Exercise 2: Add trial licenses to the tenant
  • Exercise 3: Review support options
×
×

MS-500: Microsoft 365 Security Administration (Security Administrator Associate)

and use Azure AD Connect, and introduces you to Conditional Access.  You will also learn about solutions for managing external access to your Microsoft 365 system.

In this course, you will learn about threat protection technologies that help protect your Microsoft 365 environment. Specifically, you will learn about threat vectors and Microsoft’s security solutions for them. You will learn about Secure Score, Exchange Online protection, Azure Advanced Threat Protection, Windows Defender Advanced Threat Protection, and how to use Microsoft 365 Threat Intelligence. It also discusses securing mobile devices and applications. The goal of this course is to help you configure your Microsoft 365 deployment to achieve your desired security posture.

 In this course, you will learn about information protection technologies that help secure your Microsoft 365 environment. Specifically, this course discusses information rights-managed content, message encryption, as well as labels, policies, and rules that support data loss prevention and information protection.  Lastly, the course explains the deployment of Microsoft Cloud App Security.

 In this course, you will learn about information protection technologies that help secure your Microsoft 365 environment. Specifically, this course discusses information rights-managed content, message encryption, as well as labels, policies, and rules that support data loss prevention and information protection.  Lastly, the course explains the deployment of Microsoft Cloud App Security.

Audience Profile

This course is for the Microsoft 365 security administrator role.  This role collaborates with the Microsoft 365 Enterprise Administrator, business stakeholders, and other workload administrators to plan and implement security strategies and ensures that the solutions comply with the policies and regulations of the organization.

This role proactively secures Microsoft 365 enterprise environments. Responsibilities include responding to threats, implementing, managing and monitoring security and compliance solutions for the Microsoft 365 environment. They respond to incidents, investigations and enforcement of data governance.

The Microsoft 365 Security administrator is familiar with Microsoft 365 workloads and has strong skills and experience with identity protection, information protection, threat protection, security management and data governance. This role focuses on the Microsoft 365 environment and includes hybrid environments.

At course completion

After completing this course, students will be able to:

  • Administer user and group security in Microsoft 365.
  • Manage passwords in Microsoft 365.
  • Describe Azure Identity Protection features.
  • Plan and implement Azure AD Connect.
  • Manage synchronized identities.
  • Plan to implement federated identities.
  • Describe and use conditional access.
  • Describe cyber-attack threat vectors.
  • Describe security solutions for Microsoft 365
  • Use Microsoft Secure Score to evaluate your security posture.
  • Use the Security Dashboard in the Microsoft Security & Compliance center.
  • Configure various advanced threat protection services for Microsoft 365.
  • Configure Advanced Threat Analytics.
  • Plan and deploy Mobile Device Management.
  • Implement information rights management.
  • Secure messages in Office 365.
  • Configure Data Loss Prevention policies.
  • Deploy and manage Cloud App Security.
  • Implement Azure information protection for Microsoft 365.
  • Implement Windows information protection for devices.
  • Implement information rights management.
  • Secure messages in Office 365.
  • Configure Data Loss Prevention policies.
  • Deploy and manage Cloud App Security.
  • Implement Azure information protection for Microsoft 365.
  • Implement Windows information protection for devices.

Prerequisites

  • Basic conceptual understanding of Microsoft Azure.
  • Experience with Windows 10 devices.
  • Experience with Office 365.
  • Basic understanding of authorization and authentication.
  • Basic understanding of computer networks.
  • Working knowledge of managing mobile devices.

 

Course Outline

Subject
Module 1: User and Group Security
Lab : Managing your Microsoft 365 Identity environment
Module 2: Identity Synchronization
Module 3: Federated Identities
Module 4: Access Management
Lab : Managing Recipient Infrastructure
Module 5: Security in Microsoft 365
Module 6: Advanced Threat Protection
Lab : Advanced Threat Protection
Module 7: Threat Intelligence
Lab : Advanced Threat Analytics
Module 8: Mobility
Module 9: Information Protection
Lab : Data Loss Prevention
Module 10: Data Loss Prevention
Lab : Data Loss Prevention
Module 11: Cloud Application Security
Module 12: Information Protection
Lab : Data Loss Prevention
Module 13: Data Loss Prevention
Lab : Data Loss Prevention
Module 14: Cloud Application Security
32 Hours
×
×

AZ-103 - Microsoft Azure Administrator

Description

Materials Include:
  1. Microsoft Official Courseware
  2. Microsoft Official Virtual Labs
  3. Official Microsoft Certificate Of Achievement
  4. 15% OFF on Exam & Practice Test
  

Course Duration: 4 Days

SATV: Yes

About This Course
This course teaches IT Professionals how to manage their Azure subscriptions, create and scale virtual machines, implement storage solutions, configure virtual networking, back up and share data, connect Azure and on-premises sites, manage network traffic, implement Azure Active Directory, secure identities, and monitor your solution.

Audience Profile
This course is for Azure Administrators. Azure Administrators manage the cloud services that span storage, networking and compute cloud capabilities, with a deep understanding of each service across the full IT lifecycle. They take end-user requests for new cloud applications and make recommendations on services to use for optimal performance and scale, as well as provision, size, monitor and adjust as appropriate. This role requires communicating and coordinating with vendors. Azure Administrators use the Azure Portal and as they become more proficient they use PowerShell and the Command Line Interface.

Prerequisites

  • There are no pre-requisites for taking this course. Technical IT experience is not required however some general IT knowledge or experience would be beneficial.

 

Course Outline

Module 1: Azure Administration
In this module, you’ll learn about to tooling Azure Administrator uses to manage their infrastructure. This includes the Azure Portal, Cloud Shell, Azure PowerShell, CLI, Resource Manager, and Resource Manager Templates. The demonstrations in this module will ensure you are successful in the course labs.

Lessons
Azure Portal and Cloud Shell
Azure PowerShell and CLI
Resource Manager
ARM Templates

Module 2: Azure Virtual Machines
In this module, you’ll learn about Azure virtual machines including planning, creating, availability and extensions.

Lessons
Virtual Machine Planning
Creating Virtual Machines
Virtual Machine Availability
Virtual Machine Extensions
Lab : Deploy and Manage Virtual Machines
Lab : Virtual Machines and Scale Sets

Module 3: Azure Storage
In this module, you’ll learn about basic storage features including storage accounts, blob storage, Azure files, and storage security.

Lessons
Storage Accounts
Azure Blobs
Azure Files
Storage Security
Lab : Implement and Manage Storage

Module 4: Virtual Networking
In this module, you’ll learn about basic virtual networking concepts like virtual networks, IP addressing, Azure DNS, and network security groups.

Lessons
Virtual Networks
IP Addressing and Endpoints
Azure DNS
Network Security Groups
Lab : Configure Azure DNS

Module 5: Intersite Connectivity
In this module, you’ll learn about intersite connectivity features including VNet Peering, VNet-to-VNet connections, Site-to-Site Connections, and ExpressRoute.

Lessons
VNet Peering
VNet-to-VNet Connections
ExpressRoute Connections
Lab : VNet Peering and Service Chaining

Module 6: Monitoring
In this module, you’ll learn about monitoring your Azure infrastructure including Azure Monitor, alerting, log analytics, and Network Watcher.

Lessons
Azure Monitor
Azure Alerts
Log Analytics
Network Watcher
Lab : Network Watcher

Module 7: Data Protection
In this module, you’ll learn about data replication strategies, backing up files and folders, and virtual machine backups.
Lessons
Data Replication
File and Folder Backups
Virtual Machine Backups
Lab : Azure Site Recovery Between Regions

Module 8: Network Traffic Management
In this module, you’ll learn about network traffic strategies including service endpoints, network routing, Azure Load Balancer, and Azure Traffic Manager.
Lessons
Network Routing
Azure Load Balancer
Azure Traffic Manager
Lab : Load Balancer and Traffic Manager

Module 9: Azure Active Directory
In this module, you’ll learn about Azure Active Directory (AD) including Azure AD Connect and Azure AD Join.
Lessons
Azure Active Directory
Azure AD Connect
Azure AD Join
Lab : Implement Directory Synchronization

Module 10: Securing Identities
In this module, you’ll learn how to secure identities including Multi-Factor Authentication, Azure AD Identity Protection, and Self-Service Password Reset.
Lessons
Multi-Factor Authentication
Azure AD Identity Protection
Self-Service Password Reset
Lab : Azure AD Identity Protection
Lab : Self-Service Password Reset

Module 11: Governance and Compliance
In this module, you’ll learn about managing your subscriptions and accounts including role-based access control, users and groups, and Azure policy.
Lessons
Subscriptions and Accounts
Role-Based Access Control (RBAC)
Users and Groups
Azure Policy
Lab : Role-Based Access Control
Lab : Governance and Compliance

Module 12: Data Services
In this module, you’ll learn how to effectively share data using Import and Export service, Data Box, Content Delivery Network, and File Sync.
Lessons
Content Delivery Network
File Sync
Import and Export Service
Data Box
Lab : File Sync

32 Hours 

×

AZ-203 - Developing Solutions for Microsoft Azure (Azure Developer Associate)

Description

Materials Include:
  1. Microsoft Official Courseware
  2. Microsoft Official Virtual Labs
  3. Official Microsoft Certificate Of Achievement
  4. 15% OFF on Exam & Practice Test
  

Course Duration: 6 Days

SATV: Yes

About This Course
In this course, students will gain the knowledge and skills needed to implement Azure IaaS services and features in their development solutions. The course covers provisioning virtual machines, using Batch Service to deploy/maintain resources, and how to create containerized solutions by using Azure Kubernetes Service.

In this course will gain the knowledge and skills needed to implement Azure Platform as a Service feature and services in their development solutions. Students will learn how to create and manage Azure App Service resources, integrate push and offline sync in their mobile apps, and how to document an API. Students will also learn how to create and test Azure Functions.

In this course, students will gain the knowledge and skills needed to leverage Azure storage services and features in their development solutions. It covers Azure Table storage, Azure Cosmos DB, Azure Blob, and developing against relational databases in Azure.

In this course, students will gain the knowledge and skills needed to include Azure authentication and authorization services in their development solutions. Students will learn how identity is managed and utilized in Azure solutions by using the Microsoft identity platform. Students will also learn about access control (claims-based authorization and role-based access control) and how to implement secure data solutions. Throughout the course, students learn how to create and integrate these resources by using the Azure CLI, REST, and application code.

In this course students will gain the knowledge and skills needed to ensure applications hosted in Azure are operating efficiently and as intended. Students will learn how Azure Monitor operates and how to use tools like Log Analytics and Application Insights to better understand what is happening in their application. Students will also learn how to implement autoscale, instrument their solutions to support monitoring and logging, and use Azure Cache and CDN options to enhance the end-user experience.

This course is all about communication between apps and services. Students will learn how to create and manage their own APIs by using API Management, and how to use the different event- and message-based services in Azure within their development solutions. Throughout the course students learn how to create and integrate these resources by using the Azure Portal, Azure CLI, REST, and application code.

Audience Profile
Students in this course are interested in Azure development or in passing the Microsoft Azure Developer Associate certification exam.

Prerequisites

  • Students should have 1-2 years of experience as a developer. This course assumes students know how to code and have a fundamental knowledge of Azure.
  • It is recommended that students have some experience with PowerShell or Azure CLI, working in the Azure portal, and with at least one Azure-supported programming language. Most of the examples in this course are presented in C# .NET.

 

Course Outline

Module 1: Implement solutions that use virtual machines
Students will learn how to properly plan for VM deployment. It covers VM creation by using the Azure Portal, PowerShell, and through code. It also covers creating and using ARM templates for repeatable deployments and how to use Azure Disk Encryption to secure information on the VM.

Lessons
Provision VMs
Create ARM templates
Configure Azure Disk Encryption for VMs
After completing this module, students will be able to:
Learn how to create and deploy virtual machines by using the Azure Portal, PowerShell, and through code.
Learn how to create and deploy Azure Resource Manager templates by using the Azure Portal and Visual Studio.
Understand the different encryption options and learn how to encrypt existing and new deployments.

Module 2: Implement batch jobs by using Azure Batch Services
Azure Batch creates and manages a pool of compute nodes (virtual machines), installs the applications you want to run, and schedules jobs to run on the nodes.

Lessons
Azure Batch overview
Run a batch job by using the Azure CLI and Azure Portal
Run batch jobs by using code
Manage batch jobs by using the Batch Service API
After completing this module, students will be able to:
Understand how the Azure Batch service works
Learn how to create and run batch jobs by using the Azure CLI
Learn how to create and run batch jobs by using code
Learn how to use the Azure Batch Service API to manage jobs

Module 3: Create containerized solutions
You can build and run modern, portable, microservices-based applications that benefit from Kubernetes orchestrating and managing the availability of those application components. Kubernetes supports both stateless and stateful applications as teams progress through the adoption of microservices-based applications.

Lessons
Create an Azure Managed Kubernetes Service (AKS) cluster
Create container images for solutions
Publish an image to the Azure Container Registry
Run containers by using Azure Container Instance or AKS
After completing this module, students will be able to:
Learn core concepts for Azure Kubernetes Service (AKS)
Learn how to deploy AKS clusters
Publish an image to the Azure Container Registry
Learn about Azure Container Instances and how to deploy to them

Module 4: Create App Service web apps
Azure App Service Web Apps (or just Web Apps) is a service for hosting web applications, REST APIs, and mobile back ends. Web Apps not only adds the power of Microsoft Azure to your application, such as security, load balancing, autoscaling, and automated management.

Lessons
Azure App Service core concepts
Creating an Azure App Service web app
Creating background tasks by using WebJobs in Azure App Service
After completing this module, students will be able to:
Understand App Service core concepts and capabilities
Know how to create App Service web apps by using Azure CLI, Azure Portal, and PowerShell.
Be able to create continuous and triggered WebJobs

Module 5: Creating Azure App Service mobile apps
The Mobile Apps feature of Azure App Service gives enterprise developers and system integrators a mobile-application development platform that’s highly scalable and globally available.

Lessons
Getting started with mobile apps in App Service
Enable push notifications for your app
Enable offline sync for your app
After completing this module, students will be able to:
Push their app on to the Mobile App service
How to register apps for push notifications

Module 6: Create Azure App Service API apps
This module covers how to create and document an Azure App Service API.
Lessons
Creating APIs
Using Swagger to document an API
After completing this module, students will be able to:
Know how to create an APIM instance and create a new API
Know how to use Swashbuckle to create Swagger objects in ASP.NET Core

Module 7: Implement Azure Functions
Azure Functions is a solution for easily running small pieces of code, or “functions,†in the cloud. You can write just the code you need for the problem at hand, without worrying about a whole application or the infrastructure to run it.

Lessons
Azure Functions overview
Develop Azure Functions using Visual Studio
Implement durable functions
After completing this module, students will be able to:
Understand the core features and functionality of Azure Functions
Be able to create functions, bindings, and triggers
Know common patters for Durable Functions and be able to create them

Module 8: Develop solutions that use Azure Table storage
Azure Table storage is a service that stores structured NoSQL data in the cloud, providing a key/attribute store with a schemaless design. Because Table storage is schemaless, it’s easy to adapt your data as the needs of your application evolve.

Lessons
Azure Table storage overview
Authorization in Table storage
Table service REST API
After completing this module, students will be able to:
Understand the features and uses of Azure Table storage
Know how to utilize Shared Key authorization
Know how to use the Azure Table storage REST service to manage data

Module 9: Develop solutions that use Azure Cosmos DB storage
This module covers Azure Cosmos DB storage. It instructs students on how it works, how to manage containers and items, and create and update documents by using code.

Lessons
Azure Cosmos DB overview
Managing containers and items
Create and update documents by using code
After completing this module, students will be able to:
Understand core features and functionality of Azure Cosmos DB
Be able to manage containers and items
Be able to create and update documents

Module 10: Develop solutions that use a relational database
SQL Database is a general-purpose relational database managed service in Microsoft Azure that supports structures such as relational data, JSON, spatial, and XML.

Lessons
Azure SQL overview
Create, read, update, and delete database tables by using code
After completing this module, students will be able to:
Know how the Azure SQL Database service works
Be able to perform database operations by using code

Module 11: Develop solutions that use Microsoft Azure Blob storage
Azure Blob storage is Microsoft’s object storage solution for the cloud. Blob storage is optimized for storing massive amounts of unstructured data. Unstructured data is data that does not adhere to a particular data model or definition, such as text or binary data.

Lessons
Azure Blob storage overview
Working with Azure Blob storage
After completing this module, students will be able to:
Understand when and why to use Azure Blob storage
Know how to set and retrieve Blob storage properties and metadata
Know how to replicate and copy Blobs

Module 12: Implement authentication
Microsoft identity platform is an evolution of the Azure Active Directory (Azure AD) identity service and developer platform. It allows developers to build applications that sign in all Microsoft identities, get tokens to call Microsoft Graph, other Microsoft APIs, or APIs that developers have built.

Lessons
Microsoft identity platform
Implement OAuth2 authentication
Implement managed identities for Azure resources
Implement authentication by using certificates, forms-based authentication, or tokens
Implement multi-factor authentication
After completing this module, students will be able to:
Understand the architecture of the Microsoft identity platform
Be able to implement OAuth2 authentication in their solutions
Be able to use Azure Key Vault to store and retrieve authentication information

Module 13: Implement access control
This module covers claims-based and role-based access control.

Lessons
Claims-based authorization
Role-based access control (RBAC) authorization
After completing this module, students will be able to:
Learn how to use claims-based authorization in their development solutions
How to manage access to resources using RBAC through the REST API

Module 14: Implement secure data solutions
This module covers securing data at rest and during transmission.

Lessons
Encryption options
End-to-end encryption
Implement Azure confidential computing
Manage cryptographic keys in Azure Key Vault
After completing this module, students will be able to:
Understand encryption options
Learn how to encrypt data with Transparent Data Encryption
Manage and utilize encryption keys by using the Azure key Vault

Module 15: Introduction to Azure Monitor
Azure Monitor is the central service that includes all of tools you need to monitor and optimize your solution.

Lessons
Overview of Azure Monitor
After completing this module, students will be able to:
Understand how Azure Monitor works
Know where and how Azure Monitor collects data

Module 16: Develop code to support scalability of apps and services
This module covers how applications scale and how to handle some troubleshooting.

Lessons
Implement autoscale
Implement code that addresses singleton application instances
Implement code that handles transient faults
After completing this module, students will be able to:
Understand autoscale patterns and best practices for scaling their solutions
How to use the Azure CLI to communicate with a specific copy of a resource
How to handle transient faults in your solution

Module 17: Instrument solutions to support monitoring and logging
This module covers adding code to your app to send the data to Azure Monitor.

Lessons
Configure instrumentation in an app or server by using Application Insights
Analyze and troubleshoot solutions by using Azure Monitor
After completing this module, students will be able to:
Know how to add default code to web pages, console apps, and Windows desktop apps to support telemetry
Know how to use dashboards and other tools to monitor and troubleshoot their app

Module 18: Integrate caching and content delivery within solutions
This module shows students how to leverage Azure Cache for Redis and Azure CDNs to deliver assets to users more quickly.

Lessons
Azure Cache for Redis
Develop for storage on CDNs
After completing this module, students will be able to:
Understand how Azure Cache for Redis operates and how to configure and interact with it
Know how to manage Azure CDN

Module 19: Develop an App Service Logic App
Logic Apps helps you build solutions that integrate apps, data, systems, and services across enterprises or organizations by automating tasks and business processes as workflows. This module covers what they are and how to create them.

Lessons
Azure Logic Apps overview
Create Logic Apps by using Visual Studio
Create custom connectors for Logic Apps
Create custom templates for Logic Apps
After completing this module, students will be able to:
Understand how to create and manage Azure Logic Apps.

Module 20: Integrate Azure Search within solutions
Azure Search is a search-as-a-service cloud solution that gives developers APIs and tools for adding a rich search experience over private, heterogenous content in web, mobile, and enterprise applications. In this module students will learn how to integrate Azure Search in to their solutions.

Lessons
Create and query an Azure Search Index
Full text search in Azure Search
After completing this module, students will be able to:
Provision the service, create an index, load data, and execute searches.

Module 21: API Management
API Management (APIM) helps organizations publish APIs to external, partner, and internal developers to unlock the potential of their data and services.

Lessons
Introduction to the API Management service
Securing your APIs
Defining API policies
After completing this module, students will be able to:
Provision the APIM service using the Azure Portal, secure APIs with subscriptions and client certificates, and use API policies to modify the behavior of an API.

Module 22: Develop event-based solutions
This module covers developing event-based solutions in Azure by integrating Azure Event Grid, Event Hubs, and Notification Hubs in your applications.

Lessons
Implement solutions that use Azure Event Grid
Implement solutions that use Azure Event Hubs
Implement solutions that use Azure Notification Hubs
After completing this module, students will:
Know how the services work and how to integrate them in to their solutions.

Module 23: Develop message-based solutions
Microsoft Azure Service Bus is a fully managed enterprise integration message broker. Service Bus is most commonly used to decouple applications and services from each other, and is a reliable and secure platRegister for asynchronous data and state transfer. Azure Queue storage is a service for storing large numbers of messages that can be accessed from anywhere in the world via authenticated calls using HTTP or HTTPS.
Lessons
Implement solutions that use Azure Service Bus
Implement solutions that use Azure Queue Storage queues
After completing this module, students will be able to:
Understand how to leverage Azure message-based services in their solutions.

48 Hours 

×

20779: Analyzing Data with Excel

te measures using advanced DAX functions.
Create data visualizations in Excel.
Create a Power BI dashboard with Excel.

Prerequisites

This course requires that you meet the following prerequisites:

  • Excellent knowledge of relational databases and reporting.
  • Some basic knowledge of data warehouse schema topology (including star and snowflake schemas).
  • Some exposure to basic programming constructs (such as looping and branching).
  • An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.
  • Familiarity with Microsoft Office applications – particularly Excel.

Module 1: Data Analysis in Excel

  1.   Classic Data Analysis with Excel
  2. Excel Pivot Tables
  3. Limitations of Classic Data Analysis

Lab : Building a Classic Excel Dashboard

  •  Formatting Data
  •  Building a Pivot Table
  • Adding pivot charts and a slicer

Module 2: The Excel Data Model

  1. Using an Excel Data Model
  2. DAX

Lab : Explore an Excel Data Model

  • Create Calculated Columns
  • Format Data Model Data
  • Create Measures
  • Analyze the Data

Module 3: Importing Data from Files

  1.  Importing Data into Excel
  2.  Shaping and Transforming Data
  3.  Loading Data

Lab : Importing Data from a CSV File

  • Import and Transform Data from a CSV File
  • Add Data from a Folder
  • Import data into excel.
  • Shape and transform data.
  • Load data.

Module 4: Importing Data from Databases

  1. Available Data Sources
  2. Previewing, Shaping, and Transforming Data
  3. Table Relationships and Hierarchies
  4. Loading Data

Lab : Import Data from Multiple Sources

  • Import Data from SQL Server
  • Import Data from a CSV File
  • Create a Data Table

Module 5: Importing Data from Excel Reports

  1.  Importing Data from Excel Reports
  2. Transforming Excel report Data

Lab : Importing Data from a Report

  •  Import Data from Excel
  • Transform the Excel Data
  • Load the Data into an Excel Data Model

Module 6: Creating and Formatting Measures

  1. DAX
  2.  Advanced DAX Functions

Lab : Creating Measures using Advanced DAX Functions

  • Last year comparison
  • Year to date
  • Market Share

Module 7: Visualizing Data in Excel

  1.  Pivot Charts
  2.  Cube Functions
  3. Charts for Cube Functions

Lab : Data Visualization in Excel

  • Create a Tabular Report
  • Create a Pivot Chart
  • Add Slicers to Charts

Module 8: Using Excel with Power BI

  1.  Power BI
  2. Uploading Excel Data to Power BI
  3. Power BI Mobile App

Lab : Creating a Power BI Dashboard with Excel

  • Uploading Excel Data
  • Creating a Power BI Dashboard
  • Using Power BI desktop

Total Hours: 24

×

20778 Analyzing Data with Power BI

Module 1: Power BI Desktop Data Transformations This module describes how to import fata into Power BI. Lessons

  • What is Power BI?
  • Power BI data
  • Transformations

Lab : Import Data to Power BI

  • Import data to Power BI desktop
  • Import data from CSV files
  • Import data from a less structured file

After completing this module, students will be able to:

  • Describe what Power BI is and what it does.
  • Describe the types of data.
  • Perform data transformations.

Module 2: Power BI Desktop Modeling This module introduces Power BI desktop modeling. Lessons

  • Optimizing data models
  • Calculations
  • Hierarchies

Lab : Manage Power BI data

  • Manage table relationships
  • Last year comparison
  • Year to date
  • Market share
  • Optimize the data model

After completing this module, students will be able to:

  • Optimize data models.
  • Perform calculations with Power BI data.
  • Describe and create hierarchies.

Module 3: Power BI Desktop Visualization At the end of this module students will be able to create a Power BI desktop visualization. Lessons

  • Visualizing your data
  • Working with multiple visualizations

Lab : Create reports with visualizations

  • Cross-tabular reports
  • Part-to-Whole reports
  • Relationship reports
  • Trend reports
  • Rank reports

After completing this module, students will be able to:

  • Visualize data using Power BI
  • Work with multiple visualizations.

Module 4: Power BI Service This module describes how to implement the Power BI service. Lessons

  • Working with the Power BI service
  • Configuring a dashboard
  • Viewing a Power BI Dashboard

Lab : Implementing the Power BI service

  • Upload a Power BI report
  • Share a Power BI dashboard
  • Configure data refresh

After completing this module, students will be able to:

  • Work with the Power BI service.
  • Configure a Power BI dashboard.
  • View a Power BI dashboard.

Module 5: Working with Excel This module describes how to connect to Excel as a source of data. Lessons

  • Importing data from excel
  • Analyzing data in Excel

Lab : Working with Excel

  • Uploading an Excel file with an Excel table
  • Uploading an Excel file with a data model

After completing this module, students will be able to:

  • Import data from excel.
  • Analyze data in Excel.

Module 6: Organization Content Packs, Security, and groups This module describes how to collaborate with Power BI data. Lessons

  • Collaboration
  • Content packs

Lab : Working with Organization Content Packs

  • Create a content pack
  • Edit a content pack
  • Share a content pack

After completing this module, students will be able to:

  • Share data for collaborative purposes.
  • Create, edit, and share content packs.

Module 7: Direct Connectivity This module describes various connectivity options using Power BI. Lessons

  • Cloud data
  • Connecting to analysis services

Lab : Direct Connectivity

  • Direct connectivity from Power BI desktop
  • Direct connectivity from the Power BI service

After completing this module, students will be able to:

  • Access data in SQL Azure.
  • Connect to SQL Server Analysis Services.

Module 8: Developer API This module describes the developer API within Power BI. Lessons

  • The developer API
  • Custom visuals

Lab : Using the developer API

  • Using custom visuals

After completing this module, students will be able to:

  • Describe the developer API.
  • Use the developer API to create custom visuals.

Module 9: Power BI mobile app This module describes the Power BI mobile app. Lessons

  • The Power BI mobile app
  • Using the Power BI mobile app
  • Power BI embedded

After completing this module, students will be able to:

  • Describe the Power BI mobile app.
  • Download and use the Power BI mobile app.
  • Describe Power BI embedded and when you would want to use it.
×

AZ-500 Microsoft Azure Security Technologies

Module 1: Identity and Access

Lessons

  • Configure Azure Active Directory for Azure workloads and subscriptions
  • Configure Azure AD Privileged Identity Management
  • Configure security for an Azure subscription

Module 2: Platform Protection

Lessons

  • Understand cloud security
  • Build a network
  • Secure network
  • Implement host security
  • Implement platform security
  • Implement subscription security

Module 3: Security Operations

Lessons

  • Configure security services
  • Configure security policies by using Azure Security Center
  • Manage security alerts
  • Respond to and remediate security issues
  • Create security baselines

Module 4: Data and applications

Lessons

  • Configure security policies to manage data
  • Configure security for data infrastructure
  • Configure encryption for data at rest
  • Understand application security
  • Implement security for application lifecycle
  • Secure applications
  • Configure and manage Azure Key Vault
×
×

AI-100 Designing and Implementing an Azure AI Solution

Module 1: Introducing Azure Cognitive Services The student will learn about the available Cognitive Services on Microsoft Azure and their role in architecting AI solutions.

Lessons
  • Overview of Azure Cognitive Services
  • Creating a Cognitive Service on the Azure Portal
  • Access and Test a Cognitive Service

Module 2: Creating Bots The student will learn about the Microsoft Bot Framework and Bot Services.

Lessons
  • Introducing the Bot Service
  • Creating a Basic Chat Bot
  • Testing with the Bot Emulator

Module 3: Enhancing Bots with QnA Maker The student will learn about the QnA Maker and how to integrate Bots and QnA Maker to build up a useful knowledge base for user interactions.

Lessons
  • Introducing QnA Maker
  • Implement a Knowledge Base with QnA Maker
  • Integrate QnA with a Bot

Module 4: Learn How to Create Language Understanding Functionality with LUIS The student will learn about LUIS and how to create intents and utterances to support a natural language processing solution.

Lessons
  • Introducing Language Understanding
  • Create a new LUIS Service
  • Build Language Understanding with Intents and Utterances

Module 5: Enhancing Your Bots with LUIS The student will learn about integrating LUIS with a Bot to better understand the users’ intentions when interacting with the Bot.

Lessons
  • Overview of language understanding for AI applications
  • Integrate LUIS and Bot to create an AI-based solution

Module 6: Integrate Cognitive Services with Bots and Agents The student will learn about integrating Bots and Agents with Azure Cognitive Services for advanced features such as sentiment analysis, image and text analysis, and OCR and object detection.

Lessons
  • Understand Cognitive Services for Bot Interactions
  • Perform Sentiment Analysis for your Bot with Text Analytics
  • Detect Language in a Bot with the Language Cognitive Services
  • Integrate Computer Vision with Bots
×

Microsoft 20703-1A – Administering System Center Configuration Manager

In this course you will learn how to use Configuration Manager and its associated site systems to efficiently manage network resources. You will also learn day-to-day management tasks, including how to manage applications, client health, hardware and software inventory, operating system deployment, and software updates by using Configuration Manager. You also will learn how to optimize System Center Endpoint Protection, manage compliance, and create management queries and reports. Additionally, this course, in conjunction with Microsoft Official Course 20703-2A, helps certification candidates prepare for Exam 70-703: Administering System Center Configuration Manager and Cloud Services Integration.

Course Duration: 5 Days

Contact Hours: 40 hrs.

Who needs to attend?
This course is aimed at experienced IT professionals, typically described as Enterprise Desktop Administrators (EDAs).

What you will learn

Upon completion you will know how to:

  • Describe the features Configuration Manager and Intune include, and explain how you can use these features to manage PCs and mobile devices in an enterprise environment.
  • Analyze data by using queries and reports.
  • Prepare a management infrastructure, including configuring boundaries, boundary groups, and resource discovery, and integrating mobile-device management with Microsoft Exchange Server.
  • Deploy and manage the Configuration Manager client.
  • Configure, manage, and monitor hardware and software inventory, and use Asset Intelligence and software metering.
  • Identify and configure the most appropriate method to distribute and manage content used for deployments.
  • Distribute, deploy, and monitor applications for managed users and systems.
  • Maintain software updates for PCs that Configuration Manager manages.
  • Implement Endpoint Protection for managed PCs.
  • Manage configuration items, baselines, and profiles to assess and configure compliance settings and data access for users and devices.
  • Configure an operating-system deployment strategy by using Configuration Manager.
  • Manage and maintain a Configuration Manager site.

Prerequisites

Students need to have:

  • Networking fundamentals, including common networking protocols, topologies, hardware, media, routing, switching, and addressing.
  • Active Directory Domain Services (AD DS) principles and fundamentals of AD DS management.
  • Installation, configuration, and troubleshooting for Windows-based personal computers.
  • Basic concepts of public key infrastructure (PKI) security.
  • Basic understanding of scripting and Windows PowerShell syntax.
  • Basic understanding of Windows Server roles and services.
  • Basic understanding of the configuration options for iOS, Android, and Windows Mobile device platforms.

 

Students who attend this training can meet the prerequisites by attending the following courses or by obtaining equivalent knowledge and skills through hands-on activities:

  • Course 20697-1: Installing and Configuring Windows 10
  • Course 20697-2: Deploying and Managing Windows 10 Using Enterprise Services
  • Course 20411: Administering Windows Server 2012

Course Outline

Read full course outline...

Module 1: Managing computers and mobile devices in the enterprise

This module describes the features of Configuration Manager that you can use to perform complex management tasks, including the following tasks:

  • Hardware and software inventory.
  • Application management.
  • Operating system deployment.
  • Settings management.
  • Software update management.
  • Remote client troubleshooting.
  • Protection from malware.

Lessons

  • Overview of systems management by using enterprise management solutions
  • Overview of the Configuration Manager architecture
  • Overview of the Configuration Manager administrative tools
  • Tools for monitoring and troubleshooting a Configuration Manager site

Lab : Exploring the Configuration Manager tools

  • Searching in the Configuration Manager console
  • Using Windows PowerShell with Configuration Manager
  • Using Configuration Manager Service Manager to manage components
  • Monitoring site and component status
  • Reviewing log files by using the Configuration Manager Trace tool
  • Explain how to use Configuration Manager to address the challenges of managing systems and users in today’s enterprise.
  • Describe the Configuration Manager architecture.
  • Describe the management tools that you use to perform administrative functions for Configuration Manager.
  • Describe the tools that you use to monitor and troubleshoot a Configuration Manager site.

Module 2: Analyzing data using queries and reports

The Microsoft System Center Configuration Manager database stores a large amount of data about the resources in your environment. You might not always want to perform all management tasks on all resources simultaneously. Therefore, to help you locate devices or user objects in your environment that meet specific criteria, you can create queries. You then can use these queries to create collections or to find additional information about specific resources. This module describes queries and methods of creating and running them. In addition to queries, you can run reports to view various types of information related to your Configuration Manager environment. To run Configuration Manager reports, you must install and configure a reporting services point, which this module details.

Lessons

  • Introduction to queries
  • Configuring Microsoft SQL Server Reporting Services (SSRS)

Lab : Creating and running queriesConfiguring boundaries and resource discovery

  • Creating data queries
  • Creating subselect queries
  • Creating status message queries

Lab : Configuring SSRS

  • Configuring a reporting services point
  • Creating a report by using Report Builder
  • Create and configure data and status message queries.
  • Configure and manage SSRS and the reporting services point.

Module 3: Preparing the management infrastructure to support PCs and mobile devices

This module explains how to prepare the management infrastructure, including configuring boundaries, boundary groups, and resource discovery. Additionally, it describes how Configuration Manager interacts with the Microsoft Exchange Server environment to discover and manage mobile devices.

Lessons

  • Configuring site boundaries and boundary groups
  • Configuring resource discovery
  • Configuring the Exchange Server Connector for mobile device management
  • Configuring user and device collections

Lab : Configuring boundaries and resource discovery

  • Configuring boundaries, boundary groups, and fallback relationships
  • Configuring Active Directory discovery methods

Lab : Configuring user and device collections

  • Creating a device collection
  • Creating a user collection
  • Configuring a maintenance window
  • Configure boundaries and boundary groups.
  • Configure resource discovery.
  • Configure the Exchange Server connector mobile device management.
  • Organize resources using device and user collections.

Module 4: Deploying and managing clients

This module explains the supported operating systems and devices, the software requirements, and the different methods for installing the Configuration Manager client. This module also describes some of the default and custom client settings that you can configure. After installing the client software, you can configure the client settings to perform routine management tasks.

Lessons

  • Overview of the Configuration Manager client
  • Deploying the Configuration Manager client
  • Configuring and monitoring client status
  • Managing client settings in Configuration Manager

Lab : Deploying the Microsoft System Center Configuration Manager client software

  • Preparing the site for client installation
  • Deploying the Configuration Manager client software by using client push installation

Lab : Configuring and monitoring client status

  • Configuring and monitoring client health status

Lab : Managing client settings

  • Configuring client settings
  • Describe the requirements and considerations for installing the Configuration Manager client software.
  • Deploy the Configuration Manager client software.
  • Configure and monitor client status.
  • Manage Configuration Manager client settings.

Module 5: Managing inventory for PCs and applications

This module provides an overview of inventory collection, and explains how you can manage the information collected. You also will learn about the process of collecting hardware and software inventory, initiating inventory cycles, and initiating and securing inventory collection. This module also covers the use of software metering to monitor program usage, and the configuration and management of Asset Intelligence.

Lessons

  • Overview of inventory collection
  • Configuring hardware and software inventory
  • Managing inventory collection
  • Configuring software metering
  • Configuring and managing Asset Intelligence

Lab : Configuring and managing inventory collection

  • Configuring and managing hardware inventory

Lab : Configuring software metering

  • Configuring software metering

Lab : Configuring and managing Asset Intelligence

  • Preparing the site for Asset Intelligence
  • Configuring Asset Intelligence
  • Monitoring license agreements by using Asset Intelligence
  • Viewing Asset Intelligence reports
  • Describe inventory collection.
  • Configure and collect hardware and software inventory.
  • Manage inventory collection.
  • Configure software metering.
  • Configure Asset Intelligence.

Module 6: Distributing and managing content used for deployments

Configuration Manager clients obtain content, such as packages, applications, software updates, and even operating system images, from distribution points. Configuration Manager relies on the distribution point infrastructure to provide content management functionality. In this module, you will review the content management features, configure distribution points, and learn how to distribute and monitor content. You also will perform content validation and content prestaging.

Lessons

  • Preparing the infrastructure for content management
  • Distributing and managing content on distribution points

Lab : Distributing and managing content for deployments

  • Installing a new distribution point
  • Managing content distribution
  • Prepare the infrastructure for content management.
  • Distribute and manage content on distribution points.

Module 7: Deploying and managing applications

In this module, you will learn about the methods for creating, deploying, and managing applications with Configuration Manager. You also will learn to use the Software Center and the Application Catalog to install available applications. You will learn about managing deployments on unconventional applications. In addition, you will learn to install Windows 10 apps and virtualized applications.

Lessons

  • Overview of application management
  • Creating applications
  • Deploying applications
  • Managing applications
  • Deploying virtual applications by using System Center Configuration Manager (Optional)
  • Deploying and managing Windows Store apps

Lab : Creating and deploying applications

  • Installing and configuring the Application Catalog roles
  • Creating applications with requirements
  • Deploying applications

Lab : Managing application supersedence and removal

  • Managing application supersedence
  • Uninstalling the Excel Viewer application

Lab : Deploying virtual applications by using Configuration Manager (Optional)

  • Configuring support for App-V
  • Deploying virtual applications

Lab : Using Configuration Manager to deploy Windows Store apps

  • Configuring support for sideloading Windows Store apps
  • Configuring a Windows Store app
  • Deploying Windows 10 apps to users
  • Describe the application management features of Configuration Manager.
  • Create applications.
  • Deploy applications.
  • Manage applications.
  • Configure and deploy virtual applications.
  • Configure and deploy Windows Store apps.

Module 8: Maintaining software updates for managed PCs

This module explains how to use the software updates feature in Configuration Manager to implement an end-to-end management process for the complex task of identifying, deploying, and monitoring software updates to your Configuration Manager clients.

Lessons

  • The software updates process
  • Preparing a Configuration Manager site for software updates
  • Managing software updates
  • Configuring automatic deployment rules
  • Monitoring and troubleshooting software updates

Lab : Configuring the site for software updates

  • Configuring and synchronizing the software update point

Lab : Deploying and managing software updates

  • Determining software update compliance
  • Deploying software updates to clients
  • Configuring automatic deployment rules
  • Describe how the software updates feature integrates with Configuration Manager.
  • Prepare the Configuration Manager site for software updates.
  • Manage the evaluation and deployment of software updates.
  • Configure automatic deployment rules.
  • Monitor and troubleshoot software updates.

Module 9: Implementing Endpoint Protection for managed PCs

Configuration Manager provides a number of security-related features that you can use to help protect client computers from malware threats, and to configure specific Windows Firewall settings for clients. Based on System Center Endpoint Protection (Endpoint Protection) functionality, Endpoint Protection in Configuration Manager supports the deployment, management, and monitoring of antimalware policies and Windows Firewall settings on client computers. This module explains how to use configure Endpoint Protection Configuration Manager to implement Endpoint Protectionand deploy and monitor Endpoint Protection policies.

Lessons

  • Overview of Endpoint Protection in Configuration Manager
  • Configuring, deploying, and monitoring Endpoint Protection policies

Lab : Implementing Microsoft System Center Endpoint Protection

  • Configuring the System Center Endpoint Protection point and client settings
  • Configuring and deploying Endpoint Protection policies
  • Monitoring Endpoint Protection
  • Configure Endpoint Protection to detect and remediate malware and security vulnerabilities.
  • Configure, deploy, and manage Endpoint Protection policies.

Module 10: Managing compliance and secure data access

Many enterprise organizations require systems, such as servers, laptops, desktop computers, and mobile devices, to meet specific configuration and compliance requirements. Compliance settings in Configuration Manager can play a key role in identifying existing configurations, discovering systems that have adverse configuration changes, and remediating these settings automatically when necessary. Compliance settings also can help control how users manage and access data in the enterprise network environment. For computers that run Windows 8 and newer operating systems, you can manage data using folder redirection, offline files, and roaming profiles. You also can control access to data using remote connection profiles, virtual private network (VPN) profiles, Wi-Fi profiles, and certificate profiles. This module describes the compliance settings that you can manage using Configuration Manager. You will learn to use these settings to maintain configuration requirements and to provide secure data access to enterprise resources.

Lessons

  • Overview of Compliance Settings
  • Configuring compliance settings
  • Viewing compliance results
  • Managing resource and data access

Lab : Managing compliance settings

  • Managing configuration items and baselines
  • Viewing compliance settings and reports
  • Configuring remediation in compliance settings
  • Using compliance information to create collections
  • Describe compliance settings features.
  • Configure compliance settings.
  • View compliance results.
  • Manage resource and data access.

Module 11: Managing operating system deployment

You can use the operating system deployment feature in Configuration Manager to create operating system images that you can deploy to unmanaged computers and those managed by Configuration Manager. There are several scenarios in which you can deploy operating systems by using Configuration Manager, including when you are working with new systems or when you are upgrading existing ones. Operating system deployment uses both Configuration Manager and Windows components to manage and deliver operating system images. You can configure settings on a reference computer prior to capturing an image of its operating system or by using task sequences that Configuration Manager creates after you deploy the image to a target system. This module explains how to use Configuration Manager to create a strategy for operating-system deployments. And also, it explains how to manage Windows as a service.

Lessons

  • An overview of operating system deployment
  • Preparing a site for operating system deployment
  • Deploying an operating system
  • Managing Windows as a service

Lab : Preparing thea site for operating -system deployment

  • Managing the site system roles used to support operating system deployment
  • Managing packages to support operating system deployment

Lab : Deploying operating -system images for bare-metal installations

  • Preparing the operating system image
  • Creating a task sequence to deploy an image
  • Deploying an image
  • Describe the terminology, components, and scenarios used to deploy operating systems by using Configuration Manager.
  • Describe how to prepare a site for operating system deployment.
  • Describe the process used to deploy an operating system image.

Module 12: Managing and maintaining a Configuration Manager site

This module explains how to use manage and maintain a Configuration Manager site. It describes role-based administration, Remote Tools, and the site maintenance tasks that you can manage by using Configuration Manager. Additionally, it explains how to back up and recover a Configuration Manager site system.

Lessons

  • Configuring role-based administration
  • Configuring Remote Tools
  • Overview of Configuration Manager site maintenance
  • Backing up and recovering a Configuration Manager site

Lab : Configuring role-based administration

  • Configuring a new scope for Toronto administrators
  • Configuring a new administrative user

Lab : Configuring Remote Tools

  • Configuring the Remote Tools client settings and permissions
  • Managing desktops by using Remote Control

Lab : Maintaining a Configuration Manager site

  • Configuring maintenance tasks in Configuration Manager
  • Configuring the Backup Site Server task
  • Recovering a site from a backup
  • Configure role-based administration.
  • Configure Remote Tools to support client activity.
  • Identify Configuration Manager site Maintenance tasks.
  • Back up and recover a Configuration Manager site.

Follow on
There are no follow-ons for this course.

Certification programs
There are no certifications associated with this course.

×

Course MS-100: Office 365 Management

Course Syllabus

Course Duration: 5 Days

Contact Hours: 40 hrs.

SATV: Yes

About This Course

Learn about Office 365 Management, including key components of Office 365, how to move your organization to Office 365, how to configure Office 365, and how to manage Office 365 ProPlus deployments.

Audience Profile.

This course is designed for persons who are aspiring to the Microsoft 365 Enterprise Admin role and have completed one of the Microsoft 365 role-based administrator certification paths.
Learn about Microsoft 365 Tenant and Service Management, including how to plan, manage, and customize your organization’s Microsoft 365 tenant and services.
Learn about Microsoft 365 Identity Management, including how to manage user security groups and licenses for cloud identities, and how to plan and implement identity synchronization, federated identities, applications, and external access.

At Course Completion

By actively participating in this course, you will learn about the following:

  • Office 365 overview
  • Moving your organization to Office 365
  • Configuring Office 365
  • Managing Office 365 ProPlus deployments
  • Plan their Microsoft 365 on-premises infrastructure
  • Plan their identity and authentication solution
  • Plan and configure their Microsoft 365 experience
  • Leverage Microsoft’s FastTrack and partner services
  • Implement their domain services
  • Configure their Microsoft 365 tenant roles
  • Manage their Microsoft 365 tenant health and services
  • Manage user accounts and licenses in Microsoft 365
  • Manage admin roles and security groups in Microsoft 365
  • Plan and implement password management
  • Manage Microsoft 365 authentication and provisioning options
  • Plan for directory synchronization
  • Plan and implement Azure AD Connect
  • Manage synchronized identities
  • Plan and implement an ADFS deployment
  • Implement applications in Azure AD
  • Configure Azure AD Application Proxy
  • Design solutions for external access
  • Manage their Microsoft 365 tenant health and services

Course Outline

Module 1: Moving Your Organization to Office 365
Lessons
Exchange Online
SharePoint Online
Teams
Additional Resources

Module 2: Configuring your Microsoft 365 Tenant
Lessons
Planning Your Network with Office 365
Planning Your Service Setup
Planning Your Hybrid Environment
Planning Your Migration to Office 365

Module 3: Configuring Office 365
Lessons
Office 365 Client Overview
Configuring Office Client Connectivity to Office 365

Module 4: Managing Office 365 ProPlus Deployments
Lessons
Managing User-Driven Client Installations
Managing Centralized Office 365 ProPlus Deployments
Configuring Office Telemetry
Configuring Microsoft Analytics

Module 5: Hands-On Lab
Lab : Managing Office 365
Exercise 1: Set up a Microsoft 365 trial tenant
Exercise 2: Prepare an Office 365 ProPlus managed installation
Exercise 3: Manage user-driven Office 365 ProPlus installations
Exercise 4: Manage centralized Office 365 ProPlus installations
Exercise 5: Deploy and configure Office Telemetry components

Module 6: Designing your Microsoft 365 Tenant
Lessons
Planning a Microsoft 365 On-premises infrastructure
Planning Your Identity and Authentication Solution


Module 7: Managing your Microsoft 365 Tenant
Lessons
Configuring Tenant Roles
Managing Tenant Health and Services

Module 8: Hands-On Lab
Lab : Microsoft 365 Tenant and Service Management
Exercise 1: Set up a Microsoft 365 trial tenant
Exercise 2: Managing Microsoft 365 users, groups, and administration
Exercise 3: Configuring Rights Management and compliance
Exercise 4: Monitor and troubleshoot Microsoft 365

Module 9: Manage User Security Groups and Licenses for Cloud Identities
Lessons
User Accounts and Licenses in Microsoft 365
Admin Roles and Security Groups in Microsoft 365
Password Management in Microsoft 365
Lab : Managing your Microsoft 365 Identity environment
Exercise 1: Setting up your lab environment
Exercise 2: Managing your Microsoft 365 identity environment using the Microsoft 365 admin center
Exercise 3: Managing your Microsoft 365 identity environment using Windows PowerShell

Module 10: Plan and Implement Identity Synchronization
Lessons
Introduction to Identity Synchronization
Planning for Azure AD Connect
Implementing Azure AD Connect
Managing Synchronized Identities
Lab : Implementing Identity Synchronization
Exercise 1: Setting up your organization for identity synchronization
Exercise 2: Implement Identity Synchronization

Module 11: Planning and Implementing Federated Identities
Lessons
Introduction to Federated Identities
Planning an AD FS Deployment
Implementing AD FS

Module 12: Implementing Applications and External Access
Lessons
Implementing Applications in Azure AD
Configuring Azure AD Application Proxy
Designing Solutions for External Access

×
×

MS-300: Deploying Microsoft 365 Teamwork

Course Syllabus

Course Duration:  4 Days

Contact Hours: 32 hrs.

SATV: Yes

About This Course

Content is the most critical digital asset for every organization. In this course you will learn how to plan, configure, and manage SharePoint Site Collection and OneDrive for Business to enable modern content services which transform the content lifecycle. Specifically, this course discusses the modern SharePoint site structure, such as SharePoint hub sites. It provides best practices for the adoption and deployment of OneDrive for Business within your organization. It also covers sharing, security, and monitoring in SharePoint Online and OneDrive for business.

This course is designed for IT Professionals who deploy and manage the Teamwork infrastructure in their organization.

This is the first in a series of four courses for the Teamwork Administrator role. These courses help prepare for the exam MS-300: Deploying Microsoft 365 Teamwork.

Audience Profile

This course is for the Microsoft 365 teamwork administrator role. The role is responsible for configuring, deploying, and managing Office 365 and Azure workloads that focus on efficient and effective collaboration and adoption. They manage apps, services, and supporting infrastructure to meet business requirements. The administrator is aware of and can differentiate between products and services, but may not directly manage each product or service.

The Teamwork Administrator must be able to deploy, manage, migrate, and secure SharePoint (online, on-premises, and hybrid), OneDrive, and Teams.

The Teamwork Administrator has a fundamental understanding of integration points with the following apps and services: Office, PowerApps, Flow, Yammer, Microsoft Graph, Stream, Planner, and Project. The administrator understands how to integrate third-party apps and services including line-of-business applications

Skills gained

  • Configure SharePoint Site Collections
  • Manage site collection storage limits
  • Deploy OneDrive for Business sync client
  • Use Group Policy to control OneDrive sync client settings
  • Manage external sharing for data in SharePoint Online and OneDrive for Business

Prerequisites

Learners should start this course already having the following skills:

  • Experience with Windows PowerShell
  • Basic understanding of Active Directory and Azure AD
  • Basic understanding of mobile device management, and alternative operating systems (Android and macOS)

Course outline

Module 1: Plan and Configure SharePoint Site Collection

This module is all about planning, configuring, and managing SharePoint site collections. It discusses how SharePoint administrators use SharePoint Admin Center to manage the lifecycle of site collections in your organization.

Lessons

  • SharePoint Online Overview
  • Configure site collection
  • Manage site collection

After completing this module, students will be able to:

  • Explain the site collection concepts
  • Create site collections
  • Manage site collection storage limits
  • Create and configure SharePoint hub sites
  • Describe how to use SharePoint Admin Center to manage site collections

Module 2: Configure and Manage OneDrive for Business

This module explains how to plan the deployment of OneDrive for Business. It discusses different approaches to deploy OneDrive for Business based on different scenarios. It also introduces the capabilities to manage content in OneDrive for Business.

Lessons

  • OneDrive for Business Overview
  • Deploy OneDrive for Business
  • Manage OneDrive for Business

After completing this module, students will be able to:

  • Manage users’ storage limits
  • Configure data retention in OneDrive for Business
  • Use Group Policy to control OneDrive sync client settings
  • Describe different methods to deploy OneDrive for Business
  • Describe how to use OneDrive Admin Center to manage OneDrive for Business

Module 3: Sharing, Security, and Monitoring in SharePoint and OneDrive

This module is focused on sharing, security, and monitoring in SharePoint and OneDrive. Specifically, we discuss planning and managing external sharing as well as access control in SharePoint and OneDrive. It also discusses how to use Office 365 Admin Center to monitor the activities in SharePoint online and OneDrive for Business.

Lessons

  • Manage sharing in SharePoint and OneDrive
  • Manage security in SharePoint and OneDrive
  • Monitor SharePoint and OneDrive

After completing this module, students will be able to:

  • Describe the external sharing in SharePoint Online and OneDrive for business
  • Describe the options to manage device access to SharePoint Online and OneDrive for business
  • View Office 365 reports that measure SharePoint Online and OneDrive for business usage

Module 4: Course Conclusion

Lab : Creating and configuring site collection

MS-300: Enabling Office 365 Workloads for Collaboration

About this course:

Transforming teamwork and collaboration inside and outside the organization becomes more critical in a modern workspace. In this course you will learn how to leverage Office 365 Collaboration Workloads to improve your organizations productivity, such as Yammer, Stream, PowerApps, and Flow. We will evaluate available collaborative toolsets and analyze business requirements. You will also learn how to plan and develop governance for digital transformation including user adoption and change management.

This course is designed for IT Professionals who deploy and manage the teamwork infrastructure in their organization.

This is the last in a series of four courses for the Teamwork administrator. These courses help prepare for the exam MS-300: Deploying Microsoft 365 Teamwork.

Audience profile

This course is for the Microsoft 365 teamwork administrator role. The role is responsible for configuring, deploying, and managing Office 365 and Azure workloads that focus on efficient and effective collaboration and adoption. They manage apps, services, and supporting infrastructure to meet business requirements. The administrator is aware of and can differentiate between products and services but may not directly manage each product or service.

The teamwork administrator must be able to deploy, manage, migrate, and secure SharePoint (online, on-premises, and hybrid), OneDrive, and Teams.

The teamwork administrator has a fundamental understanding of integration points with the following apps and services: Office, PowerApps, Flow, Yammer, Microsoft Graph, Stream, Planner, and Project. The administrator understands how to integrate third-party apps and services including line-of-business applications.

Skills gained

  • Evaluate available technological tools
  • Analyze business requirements
  • Develop governance for digital transformation
  • Implement application management governance
  • Manage user adoption and change
  • Monitor collaboration solutions
  • Evaluate Office 365 collaboration workloads  

Prerequisites

Learners should start this course already having the following skills:

  • Experience with Windows PowerShell
  • Basic understanding of Active Directory and Azure AD
  • Basic understanding of mobile device management, and alternative operating systems (Android and macOS)

Course outline

Module 1: Evaluating Office 365 Collaboration Workloads

Office 365 includes many features that can be used to build collaboration solutions. The core component for building collaboration solutions is SharePoint Online, but other features such as Yammer and Stream can also be used. You need to understand how SharePoint Online and other Office 365 features compare with third-party solutions when designing your solution. You also need to be able to analyze business requirements to ensure that your solution meets business needs.

Lessons

  • Evaluating available technological tools
  • Analyzing business requirements

After completing this module, students will be able to:

  • Evaluate available technological tools
  • Analyze business requirements

Module 2: Planning and Developing Governance

Successful deployment and management of information technology (IT) requires a consistent and well-defined methodology. Governance is the processes that you follow to define the policies and procedures for deploying and managing IT, including collaboration solutions. You need to consider governance for application management, user adoption, change management, and monitoring.

Lessons

  • Developing Governance  for digital transformation
  • Implementing application management governance
  • User adoption and change management
  • Monitoring collaboration solutions

After completing this module, students will be able to:

  • Develop governance for digital transformation
  • Implement application management governance
  • Manage user adoption and change
  • Monitor collaboration solutions

Module 3: Managing Office 365 collaboration workloads

In Office 365, there are many apps and features that you can use for collaboration. You need to understand how to configure these apps and features to meet the needs of your organization. In this module, you will learn about management of Office 365 groups, Power BI, Microsoft Stream, Yammers, Flow, and PowerApps.

Lessons

  • Managing Office 365 collaboration workloads
  • Managing Stream capabilities
  • Managing Yammer capabilities
  • Managing Flow and PowerApps capabilities

After completing this module, students will be able to:

  • ManageOffice 365 collaboration workloads
  • ManageStream capabilities
  • ManageYammer capabilities
  • ManageFlow and PowerApps capabilities

        

×

DP-201 Designing an Azure Data Solution

Module 1: Data Platform Architecture Considerations

In this module, the students will learn how to design and build secure, scalable and performant solutions in Azure by examining the core principles found in every good architecture. They will learn how using key principles throughout your architecture regardless of technology choice, can help you design, build, and continuously improve your architecture for an organizations benefit.

Lessons
  • Core Principles of Creating Architectures
  • Design with Security in Mind
  • Performance and Scalability
  • Design for availability and recoverability
  • Design for efficiency and operations
  • Case Study
Lab: Case Study
  • Design with security in mind
  • Consider performance and scalability
  • Design for availability and recoverability
  • Design for efficiency and operations

After completing this module, students will be able to:

  • Design with Security in mind
  • Consider performance and scalability
  • Design for availability and recoverability
  • Design for efficiency and operations
Module 2: Azure Batch Processing Reference Architectures

In this module, the student will learn the reference design and architecture patterns for dealing with the batch processing of data. The student will be exposed to dealing with the movement of data from on-premises systems into a cloud data warehouse and how it can be automated. The student will also be exposed to an AI architecture and how the data platform can integrate with an AI solution.

Lessons
  • Lambda architectures from a Batch Mode Perspective
  • Design an Enterprise BI solution in Azure
  • Automate enterprise BI solutions in Azure
  • Architect an Enterprise-grade Conversational Bot in Azure
Lab: Architect an Enterprise-grade Conversational Bot in Azure
  • Designing an Enterprise BI solution in Azure
  • Automate an Enterprise BI solution in Azure
  • Automate an Enterprise BI solution in Azure

After completing this module, students will be able to:

  • Core Principles of Creating Architectures
  • Describe Lambda architectures from a Batch Mode Perspective
  • Design an Enterprise BI solution in Azure
  • Automate enterprise BI solutions in Azure
  • Architect an Enterprise-grade conversational bot in Azure
  • Case study
Module 3: Azure Real-Time Reference Architectures

In this module, the student will learn the reference design and architecture patterns for dealing with streaming data. They will learn how streaming data can be ingested by Event Hubs and Stream Analytics to deliver real-time analysis of data. They will also explore a data science architecture the streams data into Azure Databricks to perform trend analysis. They will finally learn how an Internet of Things (IoT) architecture will require data platform technologies to store data.

Lessons
  • Lambda architectures for a Real-Time Perspective
  • Architect a stream processing pipeline with Azure Stream Analytics
  • Design a stream processing pipeline with Azure Databricks
  • Create an Azure IoT reference architecture
Lab: Azure Real-Time Reference Architectures
  • Architect a stream processing pipeline with Azure Stream Analytics
  • Design a stream processing pipeline with Azure Databricks
  • Create an Azure IoT reference architecture

After completing this module, students will be able to:

  • Lambda architectures for a Real-Time Mode Perspective
  • Architect a stream processing pipeline with Azure Stream Analytics
  • Design a stream processing pipeline with Azure Databricks
  • Create an Azure IoT reference architecture
Module 4: Data Platform Security Design Considerations

In this module, the student will learn how to incorporate security into an architecture design and learn the key decision points in Azure provides to help you create a secure environment through all the layers of your architecture.

Lessons
  • Defense in Depth Security Approach
  • Identity Management
  • Infrastructure Protection
  • Encryption Usage
  • Network Level Protection
  • Application Security
Lab: Data Platform Security Design Considerations
  • Defense in Depth Security Approach
  • Identity Protection

After completing this module, students will be able to:

  • Defense in Depth Security Approach
  • Identity Management
  • Infrastructure Protection
  • Encryption Usage
  • Network Level Protection
  • Application Security
Module 5: Designing for Resiliency and Scale

In this module, student will learn scaling services to handle load. They will learn how identifying network bottlenecks and optimizing your storage performance are important to ensure your users have the best experience. They will also learn how to handle infrastructure and service failure, recover from the loss of data, and recover from a disaster by designing availability and recoverability into your architecture.

Lessons
  • Adjust Workload Capacity by Scaling
  • Optimize Network Performance
  • Design for Optimized Storage and Database Performance
  • Identifying Performance Bottlenecks
  • Design a Highly Available Solution
  • Incorporate Disaster Recovery into Architectures
  • Design Backup and Restore strategies
Lab: Designing for Resiliency and Scale
  • Adjust Workload Capacity by Scaling
  • Design for Optimized Storage and Database Performance
  • Design a Highly Available Solution
  • Incorporate Disaster Recovery into Architectures

After completing this module, students will be able to:

  • Adjust Workload Capacity by Scaling
  • Optimize Network Performance
  • Design for Optimized Storage and Database Performance
  • Identifying Performance Bottlenecks
  • Design a Highly Available Solution
  • Incorporate Disaster Recovery into Architectures
  • Design Backup and Restore strategies
Module 6: Design for Efficiency and Operations

In this module, students will learn how to design an Azure architecture that is operationally-efficient and minimizes costs by reducing spend, they will understand how to design architectures that eliminates waste and gives them full visibility into what is being utilized in your organizations Azure environment.

Lessons
  • Maximizing the Efficiency of your Cloud Environment
  • Use Monitoring and Analytics to Gain Operational Insights
  • Use Automation to Reduce Effort and Error
Lab: Design for Efficiency and Operations
  • Maximize the Efficiency of your Cloud Environment
  • Use Monitoring and Analytics to Gain Operational Insights
  • Use Automation to Reduce Effort and Error

After completing this module, students will be able to:

  • Maximize the Efficiency of your Cloud Environment
  • Use Monitoring and Analytics to Gain Operational Insights
  • Use Automation to Reduce Effort and Error
×

AZ-900 - Microsoft Azure Fundamentals

Description

Materials Include:
  1. Microsoft Official Courseware
  2. Microsoft Official Virtual Labs
  3. Official Microsoft Certificated Of Achievement
  4. 15% OFF on Exam & Practice Test
  

Course Duration: 1 Day

SATV: Yes

About This Course
This course will provide foundational level knowledge of cloud services and how those services are provided with Microsoft Azure. The course can be taken as an optional first step in learning about cloud services and Microsoft Azure, before taking further Microsoft Azure or Microsoft cloud services courses.

The course will cover general cloud computing concepts as well as general cloud computing models and services such as Public, Private and Hybrid cloud and Infrastructure-as-a-Service (IaaS), Platform-as-a-Service(PaaS) and Software-as-a-Service (SaaS).

It will also cover some core Azure services and solutions, as well as key Azure pillar services concerning security, privacy, compliance and trust. It will finally cover pricing and support services available with Azure.

Audience Profile
There are no pre-requisites for taking this course. It is targeted for anyone that wants to learn more about Microsoft Azure.
At Course Completion

After completing this course, students will be able to:
Understand general cloud computing concepts
Understand core services available with Microsoft Azure
Understand security, privacy, compliance and trust with Microsoft Azure
Understand pricing and support models available with Microsoft

Prerequisites

  • There are no pre-requisites for taking this course. Technical IT experience is not required however some general IT knowledge or experience would be beneficial.

 

Course Outline

Subject
Module 1: Cloud Concepts
Infrastructure-as-a-Service (IaaS), Platform-as-a-Service (PaaS) and Software-as-a-Service (SaaS) Public, Private, and Hybrid cloud models
Understand general cloud computing concepts
Module 2: Core Azure Services
Core Azure architectural components
Core Azure Services and Products
Azure Solutions
Azure management tools
Understand core services available with Microsoft Azure
Module 3: Security, Privacy, Compliance and Trust
Securing network connectivity in Azure
Azure governance methodologies
Monitoring and Reporting in Azure
Privacy, Compliance and Data Protection standards in Azure
Understand security, privacy, compliance and trust with Microsoft Azure
Module 4: Azure Pricing and Support
Azure subscriptions
Planning and managing costs
Support options available with Azure
Service lifecycle in Azure
Understand pricing and support models available with Microsoft
8 hours
×
×

AZ-103 - Microsoft Azure Administrator

Description

Materials Include:
  1. Microsoft Official Courseware
  2. Microsoft Official Virtual Labs
  3. Official Microsoft Certificate Of Achievement
  4. 15% OFF on Exam & Practice Test
  

Course Duration: 4 Days

SATV: Yes

About This Course
This course teaches IT Professionals how to manage their Azure subscriptions, create and scale virtual machines, implement storage solutions, configure virtual networking, back up and share data, connect Azure and on-premises sites, manage network traffic, implement Azure Active Directory, secure identities, and monitor your solution.

Audience Profile
This course is for Azure Administrators. Azure Administrators manage the cloud services that span storage, networking and compute cloud capabilities, with a deep understanding of each service across the full IT lifecycle. They take end-user requests for new cloud applications and make recommendations on services to use for optimal performance and scale, as well as provision, size, monitor and adjust as appropriate. This role requires communicating and coordinating with vendors. Azure Administrators use the Azure Portal and as they become more proficient they use PowerShell and the Command Line Interface.

Prerequisites

  • There are no pre-requisites for taking this course. Technical IT experience is not required however some general IT knowledge or experience would be beneficial.

 

Course Outline

Module 1: Azure Administration
In this module, you’ll learn about to tooling Azure Administrator uses to manage their infrastructure. This includes the Azure Portal, Cloud Shell, Azure PowerShell, CLI, Resource Manager, and Resource Manager Templates. The demonstrations in this module will ensure you are successful in the course labs.

Lessons
Azure Portal and Cloud Shell
Azure PowerShell and CLI
Resource Manager
ARM Templates

Module 2: Azure Virtual Machines
In this module, you’ll learn about Azure virtual machines including planning, creating, availability and extensions.

Lessons
Virtual Machine Planning
Creating Virtual Machines
Virtual Machine Availability
Virtual Machine Extensions
Lab : Deploy and Manage Virtual Machines
Lab : Virtual Machines and Scale Sets

Module 3: Azure Storage
In this module, you’ll learn about basic storage features including storage accounts, blob storage, Azure files, and storage security.

Lessons
Storage Accounts
Azure Blobs
Azure Files
Storage Security
Lab : Implement and Manage Storage

Module 4: Virtual Networking
In this module, you’ll learn about basic virtual networking concepts like virtual networks, IP addressing, Azure DNS, and network security groups.

Lessons
Virtual Networks
IP Addressing and Endpoints
Azure DNS
Network Security Groups
Lab : Configure Azure DNS

Module 5: Intersite Connectivity
In this module, you’ll learn about intersite connectivity features including VNet Peering, VNet-to-VNet connections, Site-to-Site Connections, and ExpressRoute.

Lessons
VNet Peering
VNet-to-VNet Connections
ExpressRoute Connections
Lab : VNet Peering and Service Chaining

Module 6: Monitoring
In this module, you’ll learn about monitoring your Azure infrastructure including Azure Monitor, alerting, log analytics, and Network Watcher.

Lessons
Azure Monitor
Azure Alerts
Log Analytics
Network Watcher
Lab : Network Watcher

Module 7: Data Protection
In this module, you’ll learn about data replication strategies, backing up files and folders, and virtual machine backups.
Lessons
Data Replication
File and Folder Backups
Virtual Machine Backups
Lab : Azure Site Recovery Between Regions

Module 8: Network Traffic Management
In this module, you’ll learn about network traffic strategies including service endpoints, network routing, Azure Load Balancer, and Azure Traffic Manager.
Lessons
Network Routing
Azure Load Balancer
Azure Traffic Manager
Lab : Load Balancer and Traffic Manager

Module 9: Azure Active Directory
In this module, you’ll learn about Azure Active Directory (AD) including Azure AD Connect and Azure AD Join.
Lessons
Azure Active Directory
Azure AD Connect
Azure AD Join
Lab : Implement Directory Synchronization

Module 10: Securing Identities
In this module, you’ll learn how to secure identities including Multi-Factor Authentication, Azure AD Identity Protection, and Self-Service Password Reset.
Lessons
Multi-Factor Authentication
Azure AD Identity Protection
Self-Service Password Reset
Lab : Azure AD Identity Protection
Lab : Self-Service Password Reset

Module 11: Governance and Compliance
In this module, you’ll learn about managing your subscriptions and accounts including role-based access control, users and groups, and Azure policy.
Lessons
Subscriptions and Accounts
Role-Based Access Control (RBAC)
Users and Groups
Azure Policy
Lab : Role-Based Access Control
Lab : Governance and Compliance

Module 12: Data Services
In this module, you’ll learn how to effectively share data using Import and Export service, Data Box, Content Delivery Network, and File Sync.
Lessons
Content Delivery Network
File Sync
Import and Export Service
Data Box
Lab : File Sync

32 Hours 

 
×

AZ-203 - Developing Solutions for Microsoft Azure (Azure Developer Associate)

Description

Materials Include:
  1. Microsoft Official Courseware
  2. Microsoft Official Virtual Labs
  3. Official Microsoft Certificate Of Achievement
  4. 15% OFF on Exam & Practice Test
  

Course Duration: 6 Days

SATV: Yes

About This Course
In this course, students will gain the knowledge and skills needed to implement Azure IaaS services and features in their development solutions. The course covers provisioning virtual machines, using Batch Service to deploy/maintain resources, and how to create containerized solutions by using Azure Kubernetes Service.

In this course will gain the knowledge and skills needed to implement Azure Platform as a Service feature and services in their development solutions. Students will learn how to create and manage Azure App Service resources, integrate push and offline sync in their mobile apps, and how to document an API. Students will also learn how to create and test Azure Functions.

In this course, students will gain the knowledge and skills needed to leverage Azure storage services and features in their development solutions. It covers Azure Table storage, Azure Cosmos DB, Azure Blob, and developing against relational databases in Azure.

In this course, students will gain the knowledge and skills needed to include Azure authentication and authorization services in their development solutions. Students will learn how identity is managed and utilized in Azure solutions by using the Microsoft identity platform. Students will also learn about access control (claims-based authorization and role-based access control) and how to implement secure data solutions. Throughout the course, students learn how to create and integrate these resources by using the Azure CLI, REST, and application code.

In this course students will gain the knowledge and skills needed to ensure applications hosted in Azure are operating efficiently and as intended. Students will learn how Azure Monitor operates and how to use tools like Log Analytics and Application Insights to better understand what is happening in their application. Students will also learn how to implement autoscale, instrument their solutions to support monitoring and logging, and use Azure Cache and CDN options to enhance the end-user experience.

This course is all about communication between apps and services. Students will learn how to create and manage their own APIs by using API Management, and how to use the different event- and message-based services in Azure within their development solutions. Throughout the course students learn how to create and integrate these resources by using the Azure Portal, Azure CLI, REST, and application code.

Audience Profile
Students in this course are interested in Azure development or in passing the Microsoft Azure Developer Associate certification exam.

Prerequisites

  • Students should have 1-2 years of experience as a developer. This course assumes students know how to code and have a fundamental knowledge of Azure.
  • It is recommended that students have some experience with PowerShell or Azure CLI, working in the Azure portal, and with at least one Azure-supported programming language. Most of the examples in this course are presented in C\# .NET.

 

Course Outline

Module 1: Implement solutions that use virtual machines
Students will learn how to properly plan for VM deployment. It covers VM creation by using the Azure Portal, PowerShell, and through code. It also covers creating and using ARM templates for repeatable deployments and how to use Azure Disk Encryption to secure information on the VM.

Lessons
Provision VMs
Create ARM templates
Configure Azure Disk Encryption for VMs
After completing this module, students will be able to:
Learn how to create and deploy virtual machines by using the Azure Portal, PowerShell, and through code.
Learn how to create and deploy Azure Resource Manager templates by using the Azure Portal and Visual Studio.
Understand the different encryption options and learn how to encrypt existing and new deployments.

Module 2: Implement batch jobs by using Azure Batch Services
Azure Batch creates and manages a pool of compute nodes (virtual machines), installs the applications you want to run, and schedules jobs to run on the nodes.

Lessons
Azure Batch overview
Run a batch job by using the Azure CLI and Azure Portal
Run batch jobs by using code
Manage batch jobs by using the Batch Service API
After completing this module, students will be20191003 able to:
Understand how the Azure Batch service works
Learn how to create and run batch jobs by using the Azure CLI
Learn how to create and run batch jobs by using code
Learn how to use the Azure Batch Service API to manage jobs

Module 3: Create containerized solutions
You can build and run modern, portable, microservices-based applications that benefit from Kubernetes orchestrating and managing the availability of those application components. Kubernetes supports both stateless and stateful applications as teams progress through the adoption of microservices-based applications.

Lessons
Create an Azure Managed Kubernetes Service (AKS) cluster
Create container images for solutions
Publish an image to the Azure Container Registry
Run containers by using Azure Container Instance or AKS
After completing this module, students will be able to:
Learn core concepts for Azure Kubernetes Service (AKS)
Learn how to deploy AKS clusters
Publish an image to the Azure Container Registry
Learn about Azure Container Instances and how to deploy to them

Module 4: Create App Service web apps
Azure App Service Web Apps (or just Web Apps) is a service for hosting web applications, REST APIs, and mobile back ends. Web Apps not only adds the power of Microsoft Azure to your application, such as security, load balancing, autoscaling, and automated management.

Lessons
Azure App Service core concepts
Creating an Azure App Service web app
Creating background tasks by using WebJobs in Azure App Service
After completing this module, students will be able to:
Understand App Service core concepts and capabilities
Know how to create App Service web apps by using Azure CLI, Azure Portal, and PowerShell.
Be able to create continuous and triggered WebJobs

Module 5: Creating Azure App Service mobile apps
The Mobile Apps feature of Azure App Service gives enterprise developers and system integrators a mobile-application development platform that’s highly scalable and globally available.

Lessons
Getting started with mobile apps in App Service
Enable push notifications for your app
Enable offline sync for your app
After completing this module, students will be able to:
Push their app on to the Mobile App service
How to register apps for push notifications

Module 6: Create Azure App Service API apps
This module covers how to create and document an Azure App Service API.
Lessons
Creating APIs
Using Swagger to document an API
After completing this module, students will be able to:
Know how to create an APIM instance and create a new API
Know how to use Swashbuckle to create Swagger objects in ASP.NET Core

Module 7: Implement Azure Functions
Azure Functions is a solution for easily running small pieces of code, or “functions,” in the cloud. You can write just the code you need for the problem at hand, without worrying about a whole application or the infrastructure to run it.

Lessons
Azure Functions overview
Develop Azure Functions using Visual Studio
Implement durable functions
After completing this module, students will be able to:
Understand the core features and functionality of Azure Functions
Be able to create functions, bindings, and triggers
Know common patters for Durable Functions and be able to create them

Module 8: Develop solutions that use Azure Table storage
Azure Table storage is a service that stores structured NoSQL data in the cloud, providing a key/attribute store with a schemaless design. Because Table storage is schemaless, it’s easy to adapt your data as the needs of your application evolve.

Lessons
Azure Table storage overview
Authorization in Table storage
Table service REST API
After completing this module, students will be able to:
Understand the features and uses of Azure Table storage
Know how to utilize Shared Key authorization
Know how to use the Azure Table storage REST service to manage data

Module 9: Develop solutions that use Azure Cosmos DB storage
This module covers Azure Cosmos DB storage. It instructs students on how it works, how to manage containers and items, and create and update documents by using code.

Lessons
Azure Cosmos DB overview
Managing containers and items
Create and update documents by using code
After completing this module, students will be able to:
Understand core features and functionality of Azure Cosmos DB
Be able to manage containers and items
Be able to create and update documents

Module 10: Develop solutions that use a relational database
SQL Database is a general-purpose relational database managed service in Microsoft Azure that supports structures such as relational data, JSON, spatial, and XML.

Lessons
Azure SQL overview
Create, read, update, and delete database tables by using code
After completing this module, students will be able to:
Know how the Azure SQL Database service works
Be able to perform database operations by using code

Module 11: Develop solutions that use Microsoft Azure Blob storage
Azure Blob storage is Microsoft’s object storage solution for the cloud. Blob storage is optimized for storing massive amounts of unstructured data. Unstructured data is data that does not adhere to a particular data model or definition, such as text or binary data.

Lessons
Azure Blob storage overview
Working with Azure Blob storage
After completing this module, students will be able to:
Understand when and why to use Azure Blob storage
Know how to set and retrieve Blob storage properties and metadata
Know how to replicate and copy Blobs

Module 12: Implement authentication
Microsoft identity platform is an evolution of the Azure Active Directory (Azure AD) identity service and developer platform. It allows developers to build applications that sign in all Microsoft identities, get tokens to call Microsoft Graph, other Microsoft APIs, or APIs that developers have built.

Lessons
Microsoft identity platform
Implement OAuth2 authentication
Implement managed identities for Azure resources
Implement authentication by using certificates, forms-based authentication, or tokens
Implement multi-factor authentication
After completing this module, students will be able to:
Understand the architecture of the Microsoft identity platform
Be able to implement OAuth2 authentication in their solutions
Be able to use Azure Key Vault to store and retrieve authentication information

Module 13: Implement access control
This module covers claims-based and role-based access control.

Lessons
Claims-based authorization
Role-based access control (RBAC) authorization
After completing this module, students will be able to:
Learn how to use claims-based authorization in their development solutions
How to manage access to resources using RBAC through the REST API

Module 14: Implement secure data solutions
This module covers securing data at rest and during transmission.

Lessons
Encryption options
End-to-end encryption
Implement Azure confidential computing
Manage cryptographic keys in Azure Key Vault
After completing this module, students will be able to:
Understand encryption options
Learn how to encrypt data with Transparent Data Encryption
Manage and utilize encryption keys by using the Azure key Vault

Module 15: Introduction to Azure Monitor
Azure Monitor is the central service that includes all of tools you need to monitor and optimize your solution.

Lessons
Overview of Azure Monitor
After completing this module, students will be able to:
Understand how Azure Monitor works
Know where and how Azure Monitor collects data

Module 16: Develop code to support scalability of apps and services
This module covers how applications scale and how to handle some troubleshooting.

Lessons
Implement autoscale
Implement code that addresses singleton application instances
Implement code that handles transient faults
After completing this module, students will be able to:
Understand autoscale patterns and best practices for scaling their solutions
How to use the Azure CLI to communicate with a specific copy of a resource
How to handle transient faults in your solution

Module 17: Instrument solutions to support monitoring and logging
This module covers adding code to your app to send the data to Azure Monitor.

Lessons
Configure instrumentation in an app or server by using Application Insights
Analyze and troubleshoot solutions by using Azure Monitor
After completing this module, students will be able to:
Know how to add default code to web pages, console apps, and Windows desktop apps to support telemetry
Know how to use dashboards and other tools to monitor and troubleshoot their app

Module 18: Integrate caching and content delivery within solutions
This module shows students how to leverage Azure Cache for Redis and Azure CDNs to deliver assets to users more quickly.

Lessons
Azure Cache for Redis
Develop for storage on CDNs
After completing this module, students will be able to:
Understand how Azure Cache for Redis operates and how to configure and interact with it
Know how to manage Azure CDN

Module 19: Develop an App Service Logic App
Logic Apps helps you build solutions that integrate apps, data, systems, and services across enterprises or organizations by automating tasks and business processes as workflows. This module covers what they are and how to create them.

Lessons
Azure Logic Apps overview
Create Logic Apps by using Visual Studio
Create custom connectors for Logic Apps
Create custom templates for Logic Apps
After completing this module, students will be able to:
Understand how to create and manage Azure Logic Apps.

Module 20: Integrate Azure Search within solutions
Azure Search is a search-as-a-service cloud solution that gives developers APIs and tools for adding a rich search experience over private, heterogenous content in web, mobile, and enterprise applications. In this module students will learn how to integrate Azure Search in to their solutions.

Lessons
Create and query an Azure Search Index
Full text search in Azure Search
After completing this module, students will be able to:
Provision the service, create an index, load data, and execute searches.

Module 21: API Management
API Management (APIM) helps organizations publish APIs to external, partner, and internal developers to unlock the potential of their data and services.

Lessons
Introduction to the API Management service
Securing your APIs
Defining API policies
After completing this module, students will be able to:
Provision the APIM service using the Azure Portal, secure APIs with subscriptions and client certificates, and use API policies to modify the behavior of an API.

Module 22: Develop event-based solutions
This module covers developing event-based solutions in Azure by integrating Azure Event Grid, Event Hubs, and Notification Hubs in your applications.

Lessons
Implement solutions that use Azure Event Grid
Implement solutions that use Azure Event Hubs
Implement solutions that use Azure Notification Hubs
After completing this module, students will:
Know how the services work and how to integrate them in to their solutions.

Module 23: Develop message-based solutions
Microsoft Azure Service Bus is a fully managed enterprise integration message broker. Service Bus is most commonly used to decouple applications and services from each other, and is a reliable and secure platform for asynchronous data and state transfer. Azure Queue storage is a service for storing large numbers of messages that can be accessed from anywhere in the world via authenticated calls using HTTP or HTTPS.
Lessons
Implement solutions that use Azure Service Bus
Implement solutions that use Azure Queue Storage queues
After completing this module, students will be able to:
Understand how to leverage Azure message-based services in their solutions.

48 Hours 

 
Description: This course provides an introduction to HTML5, CSS3, and JavaScript. This course helps students gain basic HTML5/CSS3/JavaScript programming skills. They are intended to focus on the principles and coding components/structures that are used to establish an HTML5 software application.
Prerequisites: Experience creating Web applications, including writing simple JavaScript code, creating Windows client applications, use of Visual Studio 2017. 
Description: Develop advanced ASP.NET MVC applications using .NET Framework tools and technologies. The focus will be on coding activities that enhance the performance and scalability of a web application. ASP.NET MVC will be introduced and compared with Web Forms so that students know when each should/could be used.
Prerequisites: Experience developing web-based applications by using Microsoft Visual Studio and Microsoft ASP.NET, proficiency in using the .NET Framework, and some familiarity with the C# language. 
Description: The main purpose of the course is to give students a good understanding of the Transact-SQL language which is used by all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. As such, the primary target audience for this course is: Database Administrators, Database Developers and BI professionals.
Prerequisites: Basic knowledge of the Microsoft Windows operating system and its core functionality. Working knowledge of relational databases. 
Description: The course focuses on teaching individuals how to use SQL Server product features and tools related to developing a database.
Prerequisites: Basic knowledge of the Microsoft Windows operating system and its core functionality. Working knowledge of Transact-SQL. Working knowledge of relational databases. 
Description: The course is to give students the ability to add BI techniques to Excel data analysis. The course goes beyond the capabilities of tables and charts and uses Pivot Charts, the Excel Data Model, and Power BI. This course is intended for students who are experienced with analyzing data with Excel and who wish to add BI techniques.
Prerequisites: Basic knowledge of relational databases. Extensive knowledge of Excel spreadsheets including formulas, charts, filtering, sorting, and sub-totals. Basic knowledge of data analytics equivalent to having attended course 10994. 
Description: Course provides students with the knowledge and skills analyze data with Power BI. The course includes creating visualizations, the Power BI Service, and the Power BI Mobile App. The course will likely be attended by SQL Server report creators who are interested in alternative methods of presenting data.
Prerequisites: Excellent knowledge of relational databases and reporting. Some basic knowledge of data warehouse schema topology (including star and snowflake schemas). Some exposure to basic programming constructs (such as looping and branching). An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable. Familiarity with Microsoft Office applications – particularly Excel. 
Description: The course is designed primarily for IT professionals who have some experience with Windows Server. It is designed for professionals who will be responsible for managing storage and compute by using Windows Server 2016, and who need to understand the scenarios, requirements, and storage and compute options that are available and applicable to Windows Server 2016.
Prerequisites: A basic understanding of networking fundamentals. An awareness and understanding of security best practices. An understanding of basic AD DS concepts. Basic knowledge of server hardware. Experience supporting and configuring Windows client operating systems such as Windows 8 or Windows 10. 
Description: The course provides the fundamental networking skills required to deploy and support Windows Server 2016 in most organizations. It covers IP fundamentals, remote access technologies, and more advanced content including Software Defined Networking.
Prerequisites: Experience working with Windows Server 2008 or Windows Server 2012 Experience working in a Windows Server infrastructure enterprise environment. Knowledge of the Open Systems Interconnection (OSI) model. Understanding of core networking infrastructure components and technologies such as cabling, routers, hubs, and switches. Familiarity with networking topologies and architectures such as local area networks (LANs), wide area networks (WANs) and wireless networking. Some basic knowledge of the TCP/IP protocol stack, addressing and name resolution. Experience with and knowledge of Hyper-V and virtualization. Hands-on experience working with the Windows client operating systems such as Windows 8.1 or Windows 10. 
Description: The course teaches IT professionals how to deploy and configure Active Directory Domain Services (AD DS) in a distributed environment, how to implement Group Policy, how to perform backup and restore, and how to monitor and troubleshoot Active Directory–related issues with Windows Server 2016. Additionally, this course teaches students how to deploy other Active Directory server roles, such as Active Directory Federation Services (AD FS) and Active Directory Certificate Services (AD CS).
Prerequisites: . 
Description: The course is designed for candidates looking to demonstrate foundational knowledge on the considerations and benefits of adopting cloud services in general and the Software as a Service (SaaS) cloud model. This exam will also cover knowledge of available options and benefits gained by implementing Microsoft 365 cloud service offerings. .
Prerequisites: . 
$("div").text($("form").serialize());
Description: This course will provide you with the knowledge and skills to plan and administer a Microsoft SharePoint 2016 environment. The course teaches you how to deploy, administer, and troubleshoot your SharePoint environment. This course also provides guidelines, best practices, and considerations that help you optimize your SharePoint deployment.
Prerequisites: An ideal candidate for this course must have at least one year of experience with deploying and administering multiple SharePoint 2013 farms across a large enterprise. Because many customers have not upgraded from SharePoint 2010, a candidate can also have at least two years of experience with SharePoint 2010. However, they also must understand the differences between SharePoint 2010 and SharePoint 2013, particularly in terms of hybridization. 
Description: This course will teach you how to plan, configure, and manage the advanced features in a SharePoint 2016 environment. The special areas of focus for this course include implementing high availability, disaster recovery, service application architecture, and Microsoft Business Connectivity Services. This course also focuses on social computing features, productivity, and collaboration platforms and features. Students also will learn about business intelligence solutions, Enterprise Content Management, web content management infrastructure, solutions, and apps. This course also covers how to develop and implement a governance plan, and how to perform an upgrade or a migration to SharePoint 2016.
Prerequisites: An ideal candidate for this course must have at least one year experience with deploying and administering multiple SharePoint Server 2013 farms across a large enterprise. The candidate should have completed Course 20339-1A: Planning and Administering Microsoft SharePoint 2016, or should demonstrate equivalent skills. 
Description: In this course, you will use Configuration Manager and its associated site systems to efficiently manage network resources. You will learn day-to-day management tasks, including how to manage applications, client health, hardware and software inventory, operating system deployment, and software updates by using Configuration Manager. You will also discover how to optimize System Center Endpoint Protection, manage compliance, and create management queries and reports.
Prerequisites: Networking fundamentals, including common networking protocols, topologies, hardware, media, routing, switching, and addressing Active Directory Domain Services (AD DS) principles and fundamentals of AD DS management Installation, configuration, and troubleshooting for Windows-based personal computers Basic concepts of public key infrastructure (PKI) security Basic understanding of scripting and Windows PowerShell syntax Basic understanding of Windows Server roles and services Basic understanding of the configuration options for iOS, Android, and Windows Mobile device platforms. 
Description: This course that describes the integration of various online cloud services with Microsoft System Center Configuration Manager. This course covers integration with online services such as Microsoft Store for Business, Microsoft Office 365, and Microsoft Azure. It also describes how to manage mobile devices by using methods such as on-premises mobile device management and Exchange Server integration.
Prerequisites: To help you prepare for this class, attend the following course: Course 20703-1A: Administering System Center Configuration Manager. 
×

10979F - Introduction to Microsoft Azure for IT Professionals

This course provides the underlying knowledge required by ITPros/Devs who will be evaluating Microsoft Azure, whether they are administrators, developers, or database administrators.
 
This course introduces students to the principles of cloud computing. Students will become familiar with how these principles have been implemented in Microsoft Azure. In addition, this course explains how to implement the core Azure infrastructure, consisting of virtual networks and storage. With this foundation, students will be able to create the most common Azure services, including Azure Virtual Machines, Web Apps, and Azure SQL Database. The students will also learn about container-based Azure services and the most prominent examples of serverless computing. The course concludes by describing features of Azure Active Directory (Azure AD).
 
Audience Profile
This course is intended for individuals who want to evaluate deploying, configuring, and administering services and virtual machines (VMs) by using Azure. This includes:
  • Developers who want to evaluate creating Azure solutions.
  • Windows Server administrators who want to evaluate the migration of on-premises Active Directory roles and services to the cloud.
  • IT professionals who want to evaluate the use of Azure to host websites and mobile app back-end services.
  • Database administrators who want to evaluate the use of Azure to host SQL databases.
 
At Course Completion
After completing this course, students will be able to:
  • Describe cloud computing, Azure, and Azure subscriptions.
  • Use Azure PowerShell, the Azure Software Development Kit (SDK), and the Azure command-line interface (CLI) to manage Azure subscriptions.
  • Create and configure virtual machines in Azure, and manage their disks.
  • Create, configure, and monitor web apps in Azure and deploy Azure platform as a service (PaaS) cloud services.
  • Create and configure Azure virtual networks.
  • Create, manage, and configure cloud storage in Azure.
  • Use Azure SQL Database to create, configure, and manage SQL databases.
  • Create and manage Azure AD.
 
Prerequisites
Before attending this course, students must have a background in IT. In addition to their professional experience, students who attend this training should already have the following technical knowledge:
  • Understanding of how to deploy websites
  • A basic understanding of virtualization
  • A basic understanding of Active Directory concepts, including domains, users, and domain controllers
  • A basic understanding of database concepts, including tables and simple queries
 
Course Outline
Module 1: Getting started with Microsoft Azure
This module introduces students to cloud services and the various Azure services. It describes how to use the Azure portal to access and manage Azure services, and to manage Azure subscription and billing.
Lessons
  • What is cloud computing?
  • What is Azure?
  • Managing Azure
  • Subscription management, support, and billing
Lab : Using the Azure portals
  • Customizing the Azure portal interface
  • Viewing billing, usage, and quotas data
After completing this module, you will be able to:
  • Describe cloud computing.
  • Describe Azure and its various services.
  • Manage Azure services from the Azure portal.
  • Manage your Azure subscription and billing. 
     
Module 2: Microsoft Azure management tools
This module explains Azure PowerShell and its use in managing Azure subscriptions. It also describes how to use the Azure SDK and the Azure CLI to manage Azure subscriptions.
Lessons
  • What is Azure PowerShell?
  • Azure SDK and Azure CLI
Lab : Using Microsoft Azure management tools
  • Using the Azure PowerShell modules
  • Using the Azure CLIAfter completing this module, you will be able to:
  • Describe and use Azure PowerShell to manage your Azure subscription.
  • Describe the Visual Studio Tools for Azure and use the Azure CLI to manage your Azure subscription. 
     
Module 3: Virtual machines in Microsoft Azure
This module explains how to create and configure virtual machines in Azure and how to manage disks for virtual machines.
Lessons
  • Creating and configuring Azure VMs
  • Configuring Azure VM storage
Lab : Creating a VM in Azure
  • Creating a VM from the Azure portal by using an Azure Marketplace image
  • Verifying the functionality of the VM
  • Configuring storage of a VM
After completing this module, you will be able to:
  • Create and configure VMs in Azure.
  • Configure VM availability.
  • Configure disks for VMs. 
     
Module 4: Azure Web Apps
This module explains how to create, configure, and monitor web apps in Azure.
Lessons
  • Creating and configuring Azure web apps
  • Deploying and monitoring Azure web apps
Lab : Creating and managing Azure web apps
  • Creating and configuring an Azure web app
After completing this module, you will be able to:
  • Create and configure web apps in Microsoft Azure.
  • Deploy and monitor Azure web apps. 
     
Module 5: Implementing Azure networking
This module explains how to create and implement Azure networks and how to use their components to enhance the resiliency and availability of virtual machines.
Lessons
  • Getting started with Azure networking
  • Getting started with Azure Load Balancer
Lab : Creating and configuring virtual networks
  • Creating a virtual network
  • Creating an Azure load balancer
After completing this module, you will be able to:
  • Describe the purpose and functionality of Azure networking and Azure virtual networks.
  • Create Azure virtual networks.
  • Describe and implement Azure Load Balancer. 
     
Module 6: Introduction Azure Storage and Data Services
This module explains the features and benefits of Azure storage and data services.
Lessons
  • Understanding Azure Storage options
  • Creating and managing storage
  • Understanding options for relational database deployments
  • Creating and connecting to Azure SQL databases
Lab : Configuring Azure Storage
  • Creating and configuring an Azure Storage account
  • Creating and managing blobs
Lab : Creating a SQL Database in Azure
  • Creating a new Azure SQL database in Azure and configuring SQL Server firewall rules
  • Managing content of an Azure SQL database by using SQL Server Management Studio
After completing this module, you will be able to:
  • Describe the features and benefits of Microsoft Azure Storage.
  • Create and manage Azure Storage.
  • Describe options for relational database deployment in Microsoft Azure.
  • Create, connect to, and manage the content of Microsoft Azure SQL Database instances. 
     
Module 7: Introduction to containers and serverless computing in Azure
This module explains the options for implementing containers and describes the serverless technologies available in Azure.
Lessons
  • Implementing Windows and Linux containers in Azure
  • Introduction to Azure serverless computing
Lab : Implementing containers on Azure VMs
  • Implementing Docker hosts on Azure VMs
  • Deploying containers to Azure VMs
  • Deploying multicontainer applications with Docker Compose to Azure VMs
After completing this module, you will be able to:
  • Describe the options for implementing containers in Azure.
  • Describe the serverless technologies available in Azure. 
     
Module 8: Configuring and managing Azure AD
This module explains how to create users, domains, and directories in Azure AD, integrate applications with Azure AD, and use Multi-Factor Authentication.
Lessons
  • Overview of Azure AD
  • Manage Azure AD authentication and authorization
Lab : Create and manage Azure Active Directory
After completing this module, you will be able to:
  • Create and manage Azure AD tenants, domains, and users.
  • Manage Azure AD authentication and authorization.
 
×

AZ-300 Azure Solutions Architect Technologies

Description

Materials Include:
  1. Microsoft Official Courseware
  2. Microsoft Official Virtual Labs
  3. Official Microsoft Certificate Of Achievement
  4. 15% OFF on Exam & Practice Test
  

Course Duration: 6 Days

SATV: Yes

About This Course
In this course, students will gain the knowledge and skills needed to implement Azure IaaS services and features in their development solutions. The course covers provisioning virtual machines, using Batch Service to deploy/maintain resources, and how to create containerized solutions by using Azure Kubernetes Service.

In this course will gain the knowledge and skills needed to implement Azure Platform as a Service feature and services in their development solutions. Students will learn how to create and manage Azure App Service resources, integrate push and offline sync in their mobile apps, and how to document an API. Students will also learn how to create and test Azure Functions.

In this course, students will gain the knowledge and skills needed to leverage Azure storage services and features in their development solutions. It covers Azure Table storage, Azure Cosmos DB, Azure Blob, and developing against relational databases in Azure.

In this course, students will gain the knowledge and skills needed to include Azure authentication and authorization services in their development solutions. Students will learn how identity is managed and utilized in Azure solutions by using the Microsoft identity platform. Students will also learn about access control (claims-based authorization and role-based access control) and how to implement secure data solutions. Throughout the course, students learn how to create and integrate these resources by using the Azure CLI, REST, and application code.

In this course students will gain the knowledge and skills needed to ensure applications hosted in Azure are operating efficiently and as intended. Students will learn how Azure Monitor operates and how to use tools like Log Analytics and Application Insights to better understand what is happening in their application. Students will also learn how to implement autoscale, instrument their solutions to support monitoring and logging, and use Azure Cache and CDN options to enhance the end-user experience.

This course is all about communication between apps and services. Students will learn how to create and manage their own APIs by using API Management, and how to use the different event- and message-based services in Azure within their development solutions. Throughout the course students learn how to create and integrate these resources by using the Azure Portal, Azure CLI, REST, and application code.

Audience Profile
Students in this course are interested in Azure development or in passing the Microsoft Azure Developer Associate certification exam.

Prerequisites

  • Students should have 1-2 years of experience as a developer. This course assumes students know how to code and have a fundamental knowledge of Azure.
  • It is recommended that students have some experience with PowerShell or Azure CLI, working in the Azure portal, and with at least one Azure-supported programming language. Most of the examples in this course are presented in C\# .NET.

 

Course Outline

Module 1: Implement solutions that use virtual machines
Students will learn how to properly plan for VM deployment. It covers VM creation by using the Azure Portal, PowerShell, and through code. It also covers creating and using ARM templates for repeatable deployments and how to use Azure Disk Encryption to secure information on the VM.

Lessons
Provision VMs
Create ARM templates
Configure Azure Disk Encryption for VMs
After completing this module, students will be able to:
Learn how to create and deploy virtual machines by using the Azure Portal, PowerShell, and through code.
Learn how to create and deploy Azure Resource Manager templates by using the Azure Portal and Visual Studio.
Understand the different encryption options and learn how to encrypt existing and new deployments.

Module 2: Implement batch jobs by using Azure Batch Services
Azure Batch creates and manages a pool of compute nodes (virtual machines), installs the applications you want to run, and schedules jobs to run on the nodes.

Lessons
Azure Batch overview
Run a batch job by using the Azure CLI and Azure Portal
Run batch jobs by using code
Manage batch jobs by using the Batch Service API
After completing this module, students will be able to:
Understand how the Azure Batch service works
Learn how to create and run batch jobs by using the Azure CLI
Learn how to create and run batch jobs by using code
Learn how to use the Azure Batch Service API to manage jobs

Module 3: Create containerized solutions
You can build and run modern, portable, microservices-based applications that benefit from Kubernetes orchestrating and managing the availability of those application components. Kubernetes supports both stateless and stateful applications as teams progress through the adoption of microservices-based applications.

Lessons
Create an Azure Managed Kubernetes Service (AKS) cluster
Create container images for solutions
Publish an image to the Azure Container Registry
Run containers by using Azure Container Instance or AKS
After completing this module, students will be able to:
Learn core concepts for Azure Kubernetes Service (AKS)
Learn how to deploy AKS clusters
Publish an image to the Azure Container Registry
Learn about Azure Container Instances and how to deploy to them

Module 4: Create App Service web apps
Azure App Service Web Apps (or just Web Apps) is a service for hosting web applications, REST APIs, and mobile back ends. Web Apps not only adds the power of Microsoft Azure to your application, such as security, load balancing, autoscaling, and automated management.

Lessons
Azure App Service core concepts
Creating an Azure App Service web app
Creating background tasks by using WebJobs in Azure App Service
After completing this module, students will be able to:
Understand App Service core concepts and capabilities
Know how to create App Service web apps by using Azure CLI, Azure Portal, and PowerShell.
Be able to create continuous and triggered WebJobs

Module 5: Creating Azure App Service mobile apps
The Mobile Apps feature of Azure App Service gives enterprise developers and system integrators a mobile-application development platform that’s highly scalable and globally available.

Lessons
Getting started with mobile apps in App Service
Enable push notifications for your app
Enable offline sync for your app
After completing this module, students will be able to:
Push their app on to the Mobile App service
How to register apps for push notifications

Module 6: Create Azure App Service API apps
This module covers how to create and document an Azure App Service API.
Lessons
Creating APIs
Using Swagger to document an API
After completing this module, students will be able to:
Know how to create an APIM instance and create a new API
Know how to use Swashbuckle to create Swagger objects in ASP.NET Core

Module 7: Implement Azure Functions
Azure Functions is a solution for easily running small pieces of code, or “functions,†in the cloud. You can write just the code you need for the problem at hand, without worrying about a whole application or the infrastructure to run it.

Lessons
Azure Functions overview
Develop Azure Functions using Visual Studio
Implement durable functions
After completing this module, students will be able to:
Understand the core features and functionality of Azure Functions
Be able to create functions, bindings, and triggers
Know common patters for Durable Functions and be able to create them

Module 8: Develop solutions that use Azure Table storage
Azure Table storage is a service that stores structured NoSQL data in the cloud, providing a key/attribute store with a schemaless design. Because Table storage is schemaless, it’s easy to adapt your data as the needs of your application evolve.

Lessons
Azure Table storage overview
Authorization in Table storage
Table service REST API
After completing this module, students will be able to:
Understand the features and uses of Azure Table storage
Know how to utilize Shared Key authorization
Know how to use the Azure Table storage REST service to manage data

Module 9: Develop solutions that use Azure Cosmos DB storage
This module covers Azure Cosmos DB storage. It instructs students on how it works, how to manage containers and items, and create and update documents by using code.

Lessons
Azure Cosmos DB overview
Managing containers and items
Create and update documents by using code
After completing this module, students will be able to:
Understand core features and functionality of Azure Cosmos DB
Be able to manage containers and items
Be able to create and update documents

Module 10: Develop solutions that use a relational database
SQL Database is a general-purpose relational database managed service in Microsoft Azure that supports structures such as relational data, JSON, spatial, and XML.

Lessons
Azure SQL overview
Create, read, update, and delete database tables by using code
After completing this module, students will be able to:
Know how the Azure SQL Database service works
Be able to perform database operations by using code

Module 11: Develop solutions that use Microsoft Azure Blob storage
Azure Blob storage is Microsoft’s object storage solution for the cloud. Blob storage is optimized for storing massive amounts of unstructured data. Unstructured data is data that does not adhere to a particular data model or definition, such as text or binary data.

Lessons
Azure Blob storage overview
Working with Azure Blob storage
After completing this module, students will be able to:
Understand when and why to use Azure Blob storage
Know how to set and retrieve Blob storage properties and metadata
Know how to replicate and copy Blobs

Module 12: Implement authentication
Microsoft identity platform is an evolution of the Azure Active Directory (Azure AD) identity service and developer platform. It allows developers to build applications that sign in all Microsoft identities, get tokens to call Microsoft Graph, other Microsoft APIs, or APIs that developers have built.

Lessons
Microsoft identity platform
Implement OAuth2 authentication
Implement managed identities for Azure resources
Implement authentication by using certificates, forms-based authentication, or tokens
Implement multi-factor authentication
After completing this module, students will be able to:
Understand the architecture of the Microsoft identity platform
Be able to implement OAuth2 authentication in their solutions
Be able to use Azure Key Vault to store and retrieve authentication information

Module 13: Implement access control
This module covers claims-based and role-based access control.

Lessons
Claims-based authorization
Role-based access control (RBAC) authorization
After completing this module, students will be able to:
Learn how to use claims-based authorization in their development solutions
How to manage access to resources using RBAC through the REST API

Module 14: Implement secure data solutions
This module covers securing data at rest and during transmission.

Lessons
Encryption options
End-to-end encryption
Implement Azure confidential computing
Manage cryptographic keys in Azure Key Vault
After completing this module, students will be able to:
Understand encryption options
Learn how to encrypt data with Transparent Data Encryption
Manage and utilize encryption keys by using the Azure key Vault

Module 15: Introduction to Azure Monitor
Azure Monitor is the central service that includes all of tools you need to monitor and optimize your solution.

Lessons
Overview of Azure Monitor
After completing this module, students will be able to:
Understand how Azure Monitor works
Know where and how Azure Monitor collects data

Module 16: Develop code to support scalability of apps and services
This module covers how applications scale and how to handle some troubleshooting.

Lessons
Implement autoscale
Implement code that addresses singleton application instances
Implement code that handles transient faults
After completing this module, students will be able to:
Understand autoscale patterns and best practices for scaling their solutions
How to use the Azure CLI to communicate with a specific copy of a resource
How to handle transient faults in your solution

Module 17: Instrument solutions to support monitoring and logging
This module covers adding code to your app to send the data to Azure Monitor.

Lessons
Configure instrumentation in an app or server by using Application Insights
Analyze and troubleshoot solutions by using Azure Monitor
After completing this module, students will be able to:
Know how to add default code to web pages, console apps, and Windows desktop apps to support telemetry
Know how to use dashboards and other tools to monitor and troubleshoot their app

Module 18: Integrate caching and content delivery within solutions
This module shows students how to leverage Azure Cache for Redis and Azure CDNs to deliver assets to users more quickly.

Lessons
Azure Cache for Redis
Develop for storage on CDNs
After completing this module, students will be able to:
Understand how Azure Cache for Redis operates and how to configure and interact with it
Know how to manage Azure CDN

Module 19: Develop an App Service Logic App
Logic Apps helps you build solutions that integrate apps, data, systems, and services across enterprises or organizations by automating tasks and business processes as workflows. This module covers what they are and how to create them.

Lessons
Azure Logic Apps overview
Create Logic Apps by using Visual Studio
Create custom connectors for Logic Apps
Create custom templates for Logic Apps
After completing this module, students will be able to:
Understand how to create and manage Azure Logic Apps.

Module 20: Integrate Azure Search within solutions
Azure Search is a search-as-a-service cloud solution that gives developers APIs and tools for adding a rich search experience over private, heterogenous content in web, mobile, and enterprise applications. In this module students will learn how to integrate Azure Search in to their solutions.

Lessons
Create and query an Azure Search Index
Full text search in Azure Search
After completing this module, students will be able to:
Provision the service, create an index, load data, and execute searches.

Module 21: API Management
API Management (APIM) helps organizations publish APIs to external, partner, and internal developers to unlock the potential of their data and services.

Lessons
Introduction to the API Management service
Securing your APIs
Defining API policies
After completing this module, students will be able to:
Provision the APIM service using the Azure Portal, secure APIs with subscriptions and client certificates, and use API policies to modify the behavior of an API.

Module 22: Develop event-based solutions
This module covers developing event-based solutions in Azure by integrating Azure Event Grid, Event Hubs, and Notification Hubs in your applications.

Lessons
Implement solutions that use Azure Event Grid
Implement solutions that use Azure Event Hubs
Implement solutions that use Azure Notification Hubs
After completing this module, students will:
Know how the services work and how to integrate them in to their solutions.

Module 23: Develop message-based solutions
Microsoft Azure Service Bus is a fully managed enterprise integration message broker. Service Bus is most commonly used to decouple applications and services from each other, and is a reliable and secure platRegister for asynchronous data and state transfer. Azure Queue storage is a service for storing large numbers of messages that can be accessed from anywhere in the world via authenticated calls using HTTP or HTTPS.
Lessons
Implement solutions that use Azure Service Bus
Implement solutions that use Azure Queue Storage queues
After completing this module, students will be able to:
Understand how to leverage Azure message-based services in their solutions.

48 Hours 

 
×

AZ-301 Azure Solutions Architect Design

Description

The AZ-301 exam is targeted at experienced IT experts, the exam covers a variety of subjects and services, all of which are covered in Skylines Academy’s latest course. In order to understand core architect technologies, Skylines Academy will lead you through a series of sections, modules, and demos to prepare you for taking, and ultimately passing, the Microsoft Azure AZ-301 exam.

This course curriculum is as follows:

  • Determine Workload Requirements

  • Design Identity Management

  • Design a Data Solution

  • Establish Business Continuity

  • Design Deployment and Migrations

  • Design an Infrastructure Strategy

  • Example Designs

Lectures will educate you on the fundamental terms and principles of the Azure platform and demos will enable you with a hands-on experience using scenarios to empower you in the real world.

Welcome to the Skylines Academy AZ-301 course! We’re happy you’re joining us!


Note: If you took the AZ-300 course, there will be some overlap. There is a lot to repeat around subjects covered in AZ-300 to make sure you have the basis on core technologies that align with the curriculum. Where possible, I try to make the distinction but you will find that we need to cover core infrastructure topics again before moving onto design elements. Feel free to ignore these videos if you took my AZ-300 course, or watch them again for a good refresh before taking your AZ-301 exam. I continue to update this course based on design examples so you can try to take your hands on knowledge and think about it from an architecture perspective.

Who this course is for:
  • Azure Architects
  • IT Administrators
 
×

AZ-400 Azure DevOps Solutions

Candidates for this exam are DevOps professionals who combine people, processes, and technologies to continuously deliver valuable products and services that meet end user needs and business objectives. DevOps professionals streamline delivery by optimizing practices, improving communications and collaboration, and creating automation. They design and implement strategies for application code and infrastructure that allow for continuous integration, testing, delivery, monitoring, and feedback.

Candidates must be proficient with Agile practices. They must be familiar with both Azure administration and Azure development and experts in at least one of these areas. Azure DevOps professionals must be able to design and implement DevOps practices for version control, compliance, infrastructure as code, configuration management, build, release, and testing by using Azure technologies.

Skills measured

  • Design a DevOps strategy
  • Implement DevOps development processes
  • Implement continuous integration
  • Implement continuous delivery
  • Implement dependency management
  • Implement application infrastructure
  • Implement continuous feedback
 
×

AZ-500T00A Azure Security Technologies

Candidates for this exam are Microsoft Azure security engineers who implement security controls, maintain the security posture, manage identity and access, and protect data, applications, and networks. Candidates identify and remediate vulnerabilities by using a variety of security tools, implement threat protection, and respond to security incident escalations. As a Microsoft Azure security engineer, candidates often serve as part of a larger team dedicated to cloud-based management and security and may also secure hybrid environments as part of an end-to-end infrastructure.

Candidates for this exam should have strong skills in scripting and automation; a deep understanding of networking, virtualization, and cloud N-tier architecture; and a strong familiarity with cloud capabilities, Microsoft Azure products and services, and other Microsoft products and services.

Skills measured

  • Manage identity and access (20-25%)
  • Implement platform protection (35-40%)
  • Manage security operations (15-20%)
  • Secure data and applications (30-35%)
 
×

AI-100T01A Designing and Implementing an Azure AI Solution

Candidates for this exam analyze the requirements for AI solutions, recommend appropriate tools and technologies, and implements solutions that meet scalability and performance requirements.

Candidates translate the vision from solution architects and work with data scientists, data engineers, IoT specialists, and AI developers to build complete end-to-end solutions. Candidates design and implement AI apps and agents that use Microsoft Azure Cognitive Services and Azure Bot Service. Candidates can recommend solutions that use open source technologies.

Candidates understand the components that make up the Azure AI portfolio and the available data storage options.

Candidates implement AI solutions that use Cognitive Services, Azure bots, Azure Search, and data storage in Azure. Candidates understand when a custom API should be developed to meet specific requirements.

Skills measured

  • Analyze solution requirements (25-30%)
  • Design AI solutions (40-45%)
  • Implement and monitor AI solutions (25-30%)
 
×

DP-201T01A Designing an Azure Data Solution

Candidates for this exam are Microsoft Azure data engineers who collaborate with business stakeholders to identify and meet the data requirements to design data solutions that use Azure data services.

Azure data engineers are responsible for data-related tasks that include designing Azure data storage solutions that use relational and non-relational data stores, batch and real-time data processing solutions, and data security and compliance solutions.

Candidates for this exam must design data solutions that use the following Azure services: Azure Cosmos DB, Azure SQL Database, Azure SQL Data Warehouse, Azure Data Lake Storage, Azure Data Factory, Azure Stream Analytics, Azure Databricks, and Azure Blob storage.

Skills measured

  • Design Azure data storage solutions (40-45%)
  • Design data processing solutions (25-30%)
  • Design for data security and compliance (25-30%)
 
×

DP-100T01A Designing and Implementing a Data Science Solution on Azure

Candidates for this exam apply scientific rigor and data exploration techniques to gain actionable insights and communicate results to stakeholders. Candidates use machine learning techniques to train, evaluate, and deploy models to build AI solutions that satisfy business objectives. Candidates use applications that involve natural language processing, speech, computer vision, and predictive analytics.

Candidates serve as part of a multi-disciplinary team that incorporates ethical, privacy, and governance considerations into the solution. Candidates typically have background in mathematics, statistics, and computer science.

Skills measured

  • Define and prepare the development environment (15-20%)
  • Prepare data for modeling (25-30%)
  • Perform feature engineering (15-20%)
  • Develop models (40-45%)
 
×

DP-200T01A Implementing an Azure Data Solution

Candidates for this exam are Microsoft Azure data engineers who collaborate with business stakeholders to identify and meet the data requirements to implement data solutions that use Azure data services.

Azure data engineers are responsible for data-related tasks that include provisioning data storage services, ingesting streaming and batch data, transforming data, implementing security requirements, implementing data retention policies, identifying performance bottlenecks, and accessing external data sources.

Candidates for this exam must be able to implement data solutions that use the following Azure services: Azure Cosmos DB, Azure SQL Database, Azure SQL Data Warehouse, Azure Data Lake Storage, Azure Data Factory, Azure Stream Analytics, Azure Databricks, and Azure Blob storage.

Skills measured

  • Implement data storage solutions (40-45%)
  • Manage and develop data processing (25-30%)
  • Monitor and optimize data solutions (30-35%)
 
×
×

DP-200 Implementing an Azure Data Solution

Module 1: Azure for the Data Engineer

This module explores how the world of data has evolved and how cloud data platform technologies are providing new opportunities for business to explore their data in different ways. The student will gain an overview of the various data platform technologies that are available, and how a Data Engineers role and responsibilities has evolved to work in this new world to an organization benefit

Lessons
  • Explain the evolving world of data
  • Survey the services in the Azure Data Platform
  • Identify the tasks that are performed by a Data Engineer
  • Describe the use cases for the cloud in a Case Study
Lab: Azure for the Data Engineer
  • Identify the evolving world of data
  • Determine the Azure Data Platform Services
  • Identify tasks to be performed by a Data Engineer
  • Finalize the data engineering deliverables

After completing this module, students will be able to:

  • Explain the evolving world of data
  • Survey the services in the Azure Data Platform
  • Identify the tasks that are performed by a Data Engineer
  • Describe the use cases for the cloud in a Case Study
Module 2: Working with Data Storage

This module teaches the variety of ways to store data in Azure. The Student will learn the basics of storage management in Azure, how to create a Storage Account, and how to choose the right model for the data you want to store in the cloud. They will also understand how data lake storage can be created to support a wide variety of big data analytics solutions with minimal effort.

Lessons
  • Choose a data storage approach in Azure
  • Create an Azure Storage Account
  • Explain Azure Data Lake storage
  • Upload data into Azure Data Lake
Lab: Working with Data Storage
  • Choose a data storage approach in Azure
  • Create a Storage Account
  • Explain Data Lake Storage
  • Upload data into Data Lake Store

After completing this module, students will be able to:

  • Choose a data storage approach in Azure
  • Create an Azure Storage Account
  • Explain Azure Data Lake Storage
  • Upload data into Azure Data Lake
Module 3: Enabling Team Based Data Science with Azure Databricks

This module introduces students to Azure Databricks and how a Data Engineer works with it to enable an organization to perform Team Data Science projects. They will learn the fundamentals of Azure Databricks and Apache Spark notebooks; how to provision the service and workspaces and learn how to perform data preparation task that can contribute to the data science project.

Lessons
  • Explain Azure Databricks and Machine Learning Platforms
  • Describe the Team Data Science Process
  • Provision Azure Databricks and workspaces
  • Perform data preparation tasks
Lab: Enabling Team Based Data Science with Azure Databricks
  • Explain Azure Databricks and Machine Learning Platforms
  • Describe the Team Data Science Process
  • Provision Azure Databricks and Workspaces
  • Perform Data Preparation Tasks

After completing this module, students will be able to:

  • Explain Azure Databricks
  • Describe the Team Data Science Process
  • Provision Azure Databricks and workspaces
  • Perform data preparation tasks
Module 4: Building Globally Distributed Databases with Cosmos DB

In this module, students will learn how to work with NoSQL data using Azure Cosmos DB. They will learn how to provision the service, and how they can load and interrogate data in the service using Visual Studio Code extensions, and the Azure Cosmos DB .NET Core SDK. They will also learn how to configure the availability options so that users are able to access the data from anywhere in the world.

Lessons
  • Create an Azure Cosmos DB database built to scale
  • Insert and query data in your Azure Cosmos DB database
  • Provision a .NET Core app for Cosmos DB in Visual Studio Code
  • Distribute your data globally with Azure Cosmos DB
Lab: Building Globally Distributed Databases with Cosmos DB
  • Create an Azure Cosmos DB
  • Insert and query data in Azure Cosmos DB
  • Build a .Net Core App for Azure Cosmos DB using VS Code
  • Distribute data globally with Azure Cosmos DB

After completing this module, students will be able to:

  • Create an Azure Cosmos DB database built to scale
  • Insert and query data in your Azure Cosmos DB database
  • Build a .NET Core app for Azure Cosmos DB in Visual Studio Code
  • Distribute your data globally with Azure Cosmos DB
Module 5: Working with Relational Data Stores in the Cloud

In this module, students will explore the Azure relational data platform options including SQL Database and SQL Data Warehouse. The student will be able explain why they would choose one service over another, and how to provision, connect and manage each of the services.

Lessons
  • Use Azure SQL Database
  • Describe Azure SQL Data Warehouse
  • Creating and Querying an Azure SQL Data Warehouse
  • Use PolyBase to Load Data into Azure SQL Data Warehouse
Lab: Working with Relational Data Stores in the Cloud
  • Use Azure SQL Database
  • Describe Azure SQL Data Warehouse
  • Creating and Querying an Azure SQL Data Warehouse
  • Use PolyBase to Load Data into Azure SQL Data Warehouse

After completing this module, students will be able to:

  • Use Azure SQL Database
  • Describe Azure SQL Data Warehouse
  • Creating and Querying an Azure SQL Data Warehouse
  • Use PolyBase to Load Data into Azure SQL Data Warehouse
Module 6: Performing Real-Time Analytics with Stream Analytics

In this module, students will learn the concepts of event processing and streaming data and how this applies to Events Hubs and Azure Stream Analytics. The students will then set up a stream analytics job to stream data and learn how to query the incoming data to perform analysis of the data. Finally, you will learn how to manage and monitor running jobs.

Lessons
  • Explain data streams and event processing
  • Data Ingestion with Event Hubs
  • Processing Data with Stream Analytics Jobs
Lab: Performing Real-Time Analytics with Stream Analytics
  • Explain data streams and event processing
  • Data Ingestion with Event Hubs
  • Processing Data with Stream Analytics Jobs

After completing this module, students will be able to:

  • Explain data streams and event processing
  • Data Ingestion with Event Hubs
  • Processing Data with Stream Analytics Jobs
Module 7: Orchestrating Data Movement with Azure Data Factory

In this module, students will learn how Azure Data factory can be used to orchestrate the data movement and transformation from a wide range of data platform technologies. They will be able to explain the capabilities of the technology and be able to set up an end to end data pipeline that ingests and transforms data.

Lessons
  • Explain how Azure Data Factory works
  • Azure Data Factory Components
  • Azure Data Factory and Databricks
Lab: Orchestrating Data Movement with Azure Data Factory
  • Explain how Azure Data Factory works
  • Azure Data Factory Components
  • Azure Data Factory and Databricks

After completing this module, students will be able to:

  • Explain how Azure Data Factory works
  • Azure Data Factory Components
  • Azure Data Factory and Databricks
Module 8: Securing Azure Data Platforms

In this module, students will learn how Azure provides a multi-layered security model to protect your data. The students will explore how security can range from setting up secure networks and access keys, to defining permission through to monitoring across a range of data stores.

Lessons
  • An introduction to security
  • Key security components
  • Securing Storage Accounts and Data Lake Storage
  • Securing Data Stores
  • Securing Streaming Data
Lab: Securing Azure Data Platforms
  • An introduction to security
  • Key security components
  • Securing Storage Accounts and Data Lake Storage
  • Securing Data Stores
  • Securing Streaming Data

After completing this module, students will be able to:

  • An introduction to security
  • Key security components
  • Securing Storage Accounts and Data Lake Storage
  • Securing Data Stores
  • Securing Streaming Data
Module 9: Monitoring and Troubleshooting Data Storage and Processing

In this module, the student will get an overview of the range of monitoring capabilities that are available to provide operational support should there be issue with a data platform architecture. They will explore the common data storage and data processing issues. Finally, disaster recovery options are revealed to ensure business continuity.

Lessons
  • Explain the monitoring capabilities that are available
  • Troubleshoot common data storage issues
  • Troubleshoot common data processing issues
  • Manage disaster recovery
Lab: Monitoring and Troubleshooting Data Storage and Processing
  • Explain the monitoring capabilities that are available
  • Troubleshoot common data storage issues
  • Troubleshoot common data processing issues
  • Manage disaster recovery

After completing this module, students will be able to:

  • Explain the monitoring capabilities that are available
  • Troubleshoot common data storage issues
  • Troubleshoot common data processing issues
  • Manage disaster recovery
×

20764 Administering a SQL Database Infrastructure

Course Duration: 5 Days

SATV: Yes

About This Course

This five-day instructor-led course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure. Additionally, it will be of use to individuals who develop applications that deliver content from SQL Server databases.

Audience Profile

The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job.

The secondary audiences for this course are individuals who develop applications that deliver content from SQL Server databases.

At Course Completion

After completing this course, students will be able to:

  • Authenticate and authorize users

  • Assign server and database roles

  • Authorize users to access resources

  • Protect data with encryption and auditing

  • Describe recovery models and backup strategies

  • Backup SQL Server databases

  • Restore SQL Server databases

  • Automate database management

  • Configure security for the SQL Server agent

  • Manage alerts and notifications

  • Managing SQL Server using PowerShell

  • Trace access to SQL Server

  • Monitor a SQL Server infrastructure

  • Troubleshoot a SQL Server infrastructure

  • Import and export data

Course OutlineModule 1: SQL Server SecurityProtection of data within your Microsoft SQL Server databases is essential and requires a working knowledge of the issues and SQL Server security features. This module describes SQL Server security models, logins, users, partially contained databases, and cross-server authorization. Lessons
  • Authenticating Connections to SQL Server
  • Authorizing Logins to Connect to databases
  • Authorization Across Servers
  • Partially Contained Databases
Lab : Authenticating Users
  • Create Logins
  • Create Database Users
  • Correct Application Login Issues
  • Configure Security for Restored Databases

After completing this module, you will be able to:

  • SQL Server basic concepts.

  • SQL Server connection authentication.

  • User login authorization to databases.

  • Partially contained databases.

  • Authorization across servers.

Module 2: Assigning Server and Database RolesUsing roles simplifies the management of user permissions. With roles, you can control authenticated users’ access to system resources based on each user’s job function—rather than assigning permissions user-by-user, you can grant permissions to a role, then make users members of roles. Microsoft SQL Server includes support for security roles defined at server level and at database level. Lessons
  • Working with server roles
  • Working with Fixed Database Roles
  • Assigning User-Defined Database Roles
Lab : Assigning server and database roles
  • Assigning Server Roles
  • Assigning Fixed Database Roles
  • Assigning User-Defined Database Roles
  • Verifying Security

After completing this module, you will be able to:

  • Describe and use server roles to manage server-level security.

  • Describe and use fixed database roles.

  • Use custom database roles and application roles to manage database-level security.

Module 3: Authorizing Users to Access ResourcesIn the previous modules, you have seen how Microsoft SQL Server security is organized and how sets of permissions can be assigned at the server and database level by using fixed server roles, user-defined server roles, fixed database roles, and application roles. The final step in authorizing users to access SQL Server resources is the authorization of users and roles to access server and database objects. In this module, you will see how these object permissions are managed. In addition to access permissions on database objects, SQL Server provides the ability to determine which users are allowed to execute code, such as stored procedures and functions. In many cases, these permissions and the permissions on the database objects are best configured at the schema level rather than at the level of the individual object. Schema-based permission grants can simplify your security architecture. You will explore the granting of permissions at the schema level in the final lesson of this module.Lessons
  • Authorizing User Access to Objects
  • Authorizing Users to Execute Code
  • Configuring Permissions at the Schema Level
Lab : Authorizing users to access resources
  • Granting, Denying, and Revoking Permissions on Objects
  • Granting EXECUTE Permissions on Code
  • Granting Permissions at the Schema Level

After completing this module, you will be able to:

  • Authorize user access to objects.

  • Authorize users to execute code.

  • Configure permissions at the schema level.

Module 4: Protecting Data with Encryption and AuditingWhen configuring security for your Microsoft SQL Server systems, you should ensure that you meet any of your organization’s compliance requirements for data protection. Organizations often need to adhere to industry-specific compliance policies, which mandate auditing of all data access. To address this requirement, SQL Server provides a range of options for implementing auditing. Another common compliance requirement is the encryption of data to protect against unauthorized access in the event that access to the database files is compromised. SQL Server supports this requirement by providing transparent data encryption (TDE). To reduce the risk of information leakage by users with administrative access to a database, columns containing sensitive data—such as credit card numbers or national identity numbers—can be encrypted using the Always Encrypted feature. This module describes the available options for auditing in SQL Server, how to use and manage the SQL Server Audit feature, and how to implement encryption.Lessons
  • Options for auditing data access in SQL Server
  • Implementing SQL Server Audit
  • Managing SQL Server Audit
  • Protecting Data with Encryption
Lab : Using Auditing and Encryption
  • Working with SQL Server Audit
  • Encrypt a Column as Always Encrypted
  • Encrypt a Database using TDE

After completing this module, you will be able to:

  • Describe the options for auditing data access.

  • Implement SQL Server Audit.

  • Manage SQL Server Audit.

  • Describe and implement methods of encrypting data in SQL Server.

  • Implement encryption

Module 5: Recovery Models and Backup StrategiesOne of the most important aspects of a database administrator's role is ensuring that organizational data is reliably backed up so that, if a failure occurs, you can recover the data. Even though the computing industry has known about the need for reliable backup strategies for decades—and discussed this at great length—unfortunate stories regarding data loss are still commonplace. A further problem is that, even when the strategies in place work as they were designed, the outcomes still regularly fail to meet an organization’s operational requirements. In this module, you will consider how to create a strategy that is aligned with organizational needs, based on the available backup models, and the role of the transaction logs in maintaining database consistency.Lessons
  • Understanding Backup Strategies
  • SQL Server Transaction Logs
  • Planning Backup Strategies
Lab : Understanding SQL Server recovery models
  • Plan a Backup Strategy
  • Configure Database Recovery Models

After completing this module, you will be able to:

  • Describe various backup strategies.

  • Describe how database transaction logs function.

  • Plan SQL Server backup strategies.

Module 6: Backing Up SQL Server DatabasesIn the previous module, you learned how to plan a backup strategy for a SQL Server system. You can now learn how to perform SQL Server backups, including full and differential database backups, transaction log backups, and partial backups. In this module, you will learn how to apply various backup strategies.Lessons
  • Backing Up Databases and Transaction Logs
  • Managing Database Backups
  • Advanced Database Options
Lab : Backing Up Databases
  • Backing Up Databases
  • Performing Database, Differential, and Transaction Log Backups
  • Performing a Partial Backup

After completing this module, you will be able to:

  • Perform backups of SQL Server databases and transaction logs.

  • Manage database backups.

  • Describe advanced backup options.

Module 7: Restoring SQL Server 2016 DatabasesIn the previous module, you learned how to create backups of Microsoft SQL Server 2016 databases. A backup strategy might involve many different types of backup, so it is essential that you can effectively restore them. You will often be restoring a database in an urgent situation. You must, however, ensure that you have a clear plan of how to proceed and successfully recover the database to the required state. A good plan and understanding of the restore process can help avoid making the situation worse. Some database restores are related to system failure. In these cases, you will want to return the system as close as possible to the state it was in before the failure. Some failures, though, are related to human error and you might wish to recover the system to a point before that error. The point-in-time recovery features of SQL Server 2016 can help you to achieve this. Because they are typically much larger, user databases are more likely to be affected by system failures than system databases. However, system databases can be affected by failures, and special care should be taken when recovering them. In particular, you need to understand how to recover each system database because you cannot use the same process for all system databases. In this module, you will see how to restore user and system databases and how to implement point-in-time recovery. Lessons
  • Understanding the Restore Process
  • Restoring Databases
  • Advanced Restore Scenarios
  • Point-in-Time Recovery
Lab : Restoring SQL Server Databases
  • Restoring a Database Backup
  • Restring Database, Differential, and Transaction Log Backups
  • Performing a Piecemeal Restore

After completing this module, you will be able to:

  • Explain the restore process.

  • Restore databases.

  • Perform advanced restore operations.

  • Perform a point-in-time recovery.

Module 8: Automating SQL Server ManagementThe tools provided by Microsoft SQL Server make administration easy when compared to some other database engines. However, even when tasks are easy to perform, it is common to have to repeat a task many times. Efficient database administrators learn to automate repetitive tasks. This can help to avoid situations where an administrator forgets to execute a task at the required time. Perhaps more importantly, the automation of tasks helps to ensure that they are performed consistently, each time they are executed. This module describes how to use SQL Server Agent to automate jobs, how to configure security contexts for jobs, and how to implement multiserver jobs. Lessons
  • Automating SQL Server management
  • Working with SQL Server Agent
  • Managing SQL Server Agent Jobs
  • Multi-server Management
Lab : Automating SQL Server Management
  • Create a SQL Server Agent Job
  • Test a Job
  • Schedule a Job
  • Configure Master and Target Servers

After completing this module, you will be able to:

  • Describe methods for automating SQL Server Management.

  • Configure jobs, job step types, and schedules.

  • Manage SQL Server Agent jobs.

  • Configure master and target servers.

Module 9: Configuring Security for SQL Server AgentOther modules in this course have demonstrated the need to minimize the permissions that are granted to users, following the principle of “least privilege.” This means that users have only the permissions that they need to perform their tasks. The same logic applies to the granting of permissions to SQL Server Agent. Although it is easy to execute all jobs in the context of the SQL Server Agent service account, and to configure that account as an administrative account, a poor security environment would result from doing this. It is important to understand how to create a minimal privilege security environment for jobs that run in SQL Server Agent.Lessons
  • Understanding SQL Server Agent Security
  • Configuring Credentials
  • Configuring Proxy Accounts
Lab : Configuring Security for SQL Server Agent
  • Analyzing Problems in SQL Server Agent
  • Configuring a Credential
  • Configuring a Proxy Account
  • Configuring and testing the Security Context of a Job

After completing this module, you will be able to:

  • Explain SQL Server Agent security.

  • Configure credentials.

  • Configure proxy accounts.

Module 10: Monitoring SQL Server with Alerts and NotificationsOne key aspect of managing Microsoft SQL Server in a proactive manner is to make sure you are aware of problems and events that occur in the server, as they happen. SQL Server logs a wealth of information about issues. You can configure it to advise you automatically when these issues occur, by using alerts and notifications. The most common way that SQL Server database administrators receive details of events of interest is by email message. This module covers the configuration of Database Mail, alerts, and notifications for a SQL Server instance, and the configuration of alerts for Microsoft Azure SQL Database. Lessons
  • Monitoring SQL Server Errors
  • Configuring Database Mail
  • Operators, Alerts, and Notifications
  • Alerts in Azure SQL Database
Lab : Monitoring SQL Server with Alerts and Notifications
  • Configuring Database Mail
  • Configuring Operators
  • Configuring Alerts and Notifications
  • Testing Alerts and Notifications

After completing this module, you will be able to:

  • Monitor SQL Server errors.

  • Configure database mail.

  • Configure operators, alerts, and notifications.

  • Work with alerts in Azure SQL Database.

Module 11: Introduction to Managing SQL Server by using PowerShellThis module looks at how to use Windows PowerShell with Microsoft SQL Server. Businesses are constantly having to increase the efficiency and reliability of maintaining their IT infrastructure; with PowerShell, you can improve this efficiency and reliability by creating scripts to carry out tasks. PowerShell scripts can be tested and applied multiple times to multiple servers, saving your organization both time and money.Lessons
  • Getting Started with Windows PowerShell
  • Configure SQL Server using PowerShell
  • Administer and Maintain SQL Server with PowerShell
  • Managing Azure SQL Databases using PowerShell
Lab : Using PowerShell to Manage SQL Server
  • Getting Started with PowerShell
  • Using PowerShell to Change SQL Server settings

After completing this module, you will be able to:

  • Describe the benefits of PowerShell and its fundamental concepts.

  • Configure SQL Server by using PowerShell.

  • Administer and maintain SQL Server by using PowerShell.

  • Manage an Azure SQL Database by using PowerShell.

Module 12: Tracing Access to SQL Server with Extended eventsMonitoring performance metrics provides a great way to assess the overall performance of a database solution. However, there are occasions when you need to perform more detailed analysis of the activity occurring within a Microsoft SQL Server instance—to troubleshoot problems and identify ways to optimize workload performance. SQL Server Extended Events is a flexible, lightweight event-handling system built into the Microsoft SQL Server Database Engine. This module focuses on the architectural concepts, troubleshooting strategies and usage scenarios of Extended Events. Lessons
  • Extended Events Core Concepts
  • Working with Extended Events
Lab : Extended Events
  • Using the System_Health Extended Events Session
  • Tracking Page Splits Using Extended Events

After completing this module, you will be able to:

  • Describe Extended Events core concepts.

  • Create and query Extended Events sessions.

Module 13: Monitoring SQL Server The Microsoft SQL Server Database Engine can run for long periods without the need for administrative attention. However, if you regularly monitor the activity that occurs on the database server, you can deal with potential issues before they arise. SQL Server provides a number of tools that you can use to monitor current activity and record details of previous activity. You need to become familiar with what each of the tools does and how to use them. It is easy to become overwhelmed by the volume of output that monitoring tools can provide, so you also need to learn techniques for analyzing their output.Lessons
  • Monitoring activity
  • Capturing and Managing Performance Data
  • Analyzing Collected Performance Data
  • SQL Server Utility
Lab : Monitoring SQL Server

After completing this module, you will be able to:

  • Monitor current activity.

  • Capture and manage performance data.

  • Analyze collected performance data.

  • Configure SQL Server Utility.

Module 14: Troubleshooting SQL ServerDatabase administrators working with Microsoft SQL Server need to adopt the important role of troubleshooter when issues arise—particularly if users of business-critical applications that rely on SQL Server databases are being prevented from working. It is important to have a solid methodology for resolving issues in general, and to be familiar with the most common issues that can arise when working with SQL Server systems. Lessons
  • A Trouble Shooting Methodology for SQL Server
  • Resolving Service Related Issues
  • Resolving Connectivity and Log-in issues
Lab : Troubleshooting Common Issues
  • Troubleshoot and Resolve a SQL Login Issue
  • Troubleshoot and Resolve a Service Issue
  • Troubleshoot and Resolve a Windows Login Issue
  • Troubleshoot and Resolve a Job Execution Issue
  • Troubleshoot and Resolve a Performance Issue

After completing this module, you will be able to:

  • Describe a troubleshooting methodology for SQL Server.

  • Resolve service-related issues.

  • Resolve login and connectivity issues.

Module 15: Importing and Exporting DataWhile a great deal of data residing in a Microsoft SQL Server system is entered directly by users who are running application programs, there is often a need to move data in other locations, to and from SQL Server. SQL Server provides a set of tools you can use to transfer data in and out. Some of these tools, such as the bcp (Bulk Copy Program) utility and SQL Server Integration Services, are external to the database engine. Other tools, such as the BULK INSERT statement and the OPENROWSET function, are implemented in the database engine. With SQL Server, you can also create data-tier applications that package all the tables, views, and instance objects associated with a user database into a single unit of deployment. In this module, you will explore these tools and techniques so that you can import and export data to and from SQL Server. Lessons
  • Transferring Data to and from SQL Server
  • Importing and Exporting Table Data
  • Using bcp and BULK INSERT to Import Data
  • Deploying and Upgrading Data-Tier Application
Lab : Importing and Exporting Data
  • Import and Excel Data Using the Import Wizard
  • Import a Delimited Text File Using bcp
  • Import a Delimited Text File using BULK INSERT
  • Create and Test an SSIS Package to Extract Data
  • Deploy a Data-Tier Application

After completing this module, you will be able to:

  • Describe tools and techniques for transferring data.

  • Import and export table data.

  • Use bcp and BULK INSERT to import data.

  • Use data-tier applications to import and export database applications.

In addition to their professional experience, students who attend this training should already have the following technical knowledge:

·         Basic knowledge of the Microsoft Windows operating system and its core functionality.

·         Working knowledge of Transact-SQL.

·         Working knowledge of relational databases.

·         Some experience with database design.

 
×

20765 Provisioning SQL Databases

Course Duration: 5 Days

SATV: Yes

About This Course

This course is designed to teach students how to provision SQL Server databases both on premise and in SQL Azure.

Audience Profile

The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job.

The secondary audiences for this course are individuals who develop applications that deliver content from SQL Server databases.

At Course Completion

After completing this course, students will be able to:

  • Provision a Database Server

  • Upgrade SQL Server

  • Configure SQL Server

  • Manage Databases and Files (shared)

  • Provision, migrate and manage databases in the cloud

Course OutlineModule 1: SQL Server ComponentsThis module describes the various SQL Server components and versions.Lessons
  • Introduction to the SQL Server Platform
  • Overview of SQL Server Architecture
  • SQL Server Services and Configuration Options

After completing this module, you will be able to:

  • Describe SQL Server components and versions.

  • Describe SQL Server architecture and resource usage.

  • Describe SQL Server services and how you manage the configuration of those services.

Module 2: Installing SQL Server This modules describes the process to install SQL Server 2016.Lessons
  • Considerations for SQL Installing Server
  • TempDB Files
  • Installing SQL Server
  • Automating Installation
Lab : Installing SQL Server
  • Preparing to install SQL Server
  • Install an instance of SQL Server
  • Perform post installation checks
  • Automating Installation

After completing this module, you will be able to:

  • Describe the considerations when installing SQL Server.

  • Describe TempDB files.

  • Install SQL Server.

  • Automate a SQL Server installation.

Module 3: Upgrading SQL Server to SQL Server 2017This module describes the process for upgrading to SQL Server 2017. Lessons
  • Upgrade Requirements
  • Upgrade SQL Server Services
  • Side by Side Upgrade: Migrating SQL Server Data and Applications
Lab : Upgrading SQL Server
  • Create the Application Logins
  • Restore the backups of the TSQL Database
  • Orphaned Users and Database Compatibility Level

After completing this module, you will be able to:

  • Describe the upgrade requirements for SQL Server.

  • Upgrade SQL Server.

  • Migrate SQL Server data and applications.

Module 4: Working with DatabasesThis module describes the preinstalled system databases, the physical structure of databases and the most common configuration options related to them.Lessons
  • Introduction to Data Storage with SQL Server
  • Managing Storage for System Databases
  • Managing Storage for User Databases
  • Moving and Copying Database Files
  • Buffer Pool Extension
Lab : Managing Database Storage
  • Configuring tempdb Storage
  • Creating Databases
  • Attaching a Database
  • Enable Buffer Pool Extension

After completing this module, you will be able to:

  • Describe Data Storage with SQL Server.

  • Manage Storage for System Databases.

  • Manage Storage for User Databases.

  • Move and Copy Database Files.

  • Describe and use Buffer Pool Extensions.

Module 5: Performing Database MaintenanceThis module covers database maintenance plans.Lessons
  • Ensuring Database Integrity
  • Maintaining Indexes
  • Automating Routine Database Maintenance
Lab : Performing Database Maintenance
  • Use DBCC CHECKDB to Verify Database Integrity
  • Rebuild Indexes
  • Create a Database Maintenance Plan

After completing this module, you will be able to:

  • Ensure Database Integrity.

  • Maintain Indexes.

  • Automate Routine Database Maintenance.

Module 6: Database Storage OptionsDescribe SQL Server storage options.Lessons
  • SQL Server storage Performance
  • SMB Fileshare
  • SQL Server Storage in Microsoft Azure
  • Stretch Databases
Lab : Implementing Stretch Database
  • Run Stretch Database Advisor
  • Implement Stretch Database

After completing this module, you will be able to:

  • Describe SQL Server Storage Performance.

  • Describe SMB Fileshare.

  • Explain SQL Server Storage in Microsoft Azure.

  • Describe Stretch Database.

Module 7: Planning to Deploy SQL Server on Microsoft AzureThis module describes how to plan to deploy SQL Server on Azure.Lessons
  • SQL Server Virtual Machines in Azure
  • Azure Storage
  • Azure SQL Authentication
  • Deploying an Azure SQL Database
Lab : Plan and Deploy an Azure SQL Database
  • Plan an Azure SQL Database, Networking, performance tiers, security
  • Provision an Azure SQL Database
  • Connect to an Azure SQL Database

After completing this module, you will be able to:

  • Describe SQL Server Virtual Machines in Azure.

  • Describe Azure Storage.

  • Explain Azure SQL Authentication, auditing and compliance.

  • Deploy an Azure SQL Database.

Module 8: Migrating Databases to Azure SQL DatabaseThis module describes how to migrate databases to Azure SQL Database.Lessons
  • Database Migration Testing Tools
  • Database Migration Compatibility Issues
  • Migrating a SQL Server Database to Azure SQL Database
Lab : Migrating SQL Server Databases to Azure
  • Perform Migration Testing
  • Migrate a SQL Server Database to Azure SQL Database
  • Test a Migrated Database

After completing this module, students will be able to:

  • Describe various database migration testing tools.
  • Explain database migration compatibility issues.
  • Migrate a SQL Server database to Azure SQL database.


Module 9: Deploying SQL Server on a Microsoft Azure Virtual Machine This module describes how to deploy SQL Server on Microsoft Azure VMs.Lessons
  • Deploying SQL Server on an Azure VM
  • The Deploy Database to a Microsoft Azure VM Wizard
Lab : Deploying SQL Server on an Azure Virtual Machine
  • Provision an Azure VM
  • Use the Deploy Database to Azure VM Wizard

After completing this module, students will be able to:

  • Deploy SQL Server on an Azure VM.
  • Use The Deploy Database to a Microsoft Azure VM Wizard.
  • Configure SQL Server Connections
Module 10: Managing databases in the CloudThis module describes how to manage SQL Server on Azure.Lessons
  • Managing Azure SQL Database Security
  • Configure Azure storage
  • Azure Automation
Lab : Managing Databases in the Cloud
  • Add data masking
  • Use Azure automation to stop Virtual Machines

After completing this module, students will be able to:

  • Manage Azure SQL Database Security.
  • Configure Azure storage.
  • Implement Azure Automation.
Additional Reading


This course requires that you meet the following prerequisites:

  • Basic knowledge of the Microsoft Windows operating system and its core functionality.

  • Working knowledge of Transact-SQL.

  • Working knowledge of relational databases.

  • Some experience with database design

 
Description: .
Prerequisites: . 

Course: Microsoft OneDrive Basic Fundamentals

Hours: 3

Prerequisites: N/A

Description:

This course teaches participants how to use the Office 365 cloud storage service, OneDrive. This cloud service woks like a traditional hard drive. During the course, participants will learn how how to use both the OneDrive Desktop App and the OneDrive Web App. Finally, participants will learn how to store, upload, and download files, and use Office Web App for business accounts in a collaborative environment.


Objectives:

At the end of the course OneDrive Basics Fundamentals, participants will be able to:

  • Manage files in the cloud storage service OneDrive.

  • Upload and download files.

  • Set-up folder to sync to OneDrive.

  • Understand the status of OneDrive files.

  • Use OneDrive Files On-Demand.


Framework Topics

  1. What is OneDrive for Business?

  2. OneDrive Basics Fundamentals

    1. Introduction to Microsoft OneDrive

      1. Set up a OneDrive Account

      2. Get started with OneDrive at work

      3. OneDrive basics for work

    2. Manage your files

      1. How to upload files and folders to OneDrive

      2. Create files and folders

      3. Delete files and folders

      4. Restore deleted files on OneDrive

    3. Share and sync files

      1. Sync folder in OneDrive

      2. Understanding the sync status

      3. Sync OneDrive files

      4. Share files using OneDrive

    4. OneDrive files On-Demand

      1. Manage OneDrive files On-Demand


Reference

Microsoft. (2019, July 01). Office 365 Training Center. Retrieved from https://support.office.com/en-us/office-training-center





 

Microsoft Teams Basics Fundamentals

Hours: 4


Prerequisites: N/A

Description:

In this course, participants will learn how to use the Microsoft Teams collaboration app in a business environment. Participants will understand how to manage a team through the Microsoft Teams app, helping them to stay organized, have conversations in one place, chat, and create channels by projects, topics and/or team groups. Finally, participants will learn how to manage online meetings with the goal of improving both the communications and collaborative work environment of a business.


Objectives

At the end of the course, the participant will be able to:

  • Set up and customize Teams.

  • Collaborate in teams and channels

  • Work with post and messages.

  • Upload and find files.

  • Start chats and calls.

  • Manage meetings, set up live event and record meetings.

Framework Topics

  1. Introduction to Microsoft Teams

    1. What is Microsoft Teams?

  2. Set up and customize your team

    1. Get your team up and running

    2. Create your team

    3. Create a team from an existing group

    4. Manage team settings and permission

    5. Organize your teams

  3. Collaborate in team and channels

    1. Collaborate in teams

      1. Overview of teams and channels

      2. Collaborate in teams

    2. Manage channels

      1. Create a channel

      2. Team owner, manage channels and add or remove members

      3. Show and hide channels

      4. Works in channels

      5. Work in file together

      6. Send email to a channel

    3. Manage chats and calls

      1. Start a chat in Teams

      2. Make calls

      3. Hide chats, delete messages

      4. Set up a delegate to take your calls

  4. Meeting in Teams

    1. Manage meetings

      1. Meetings in Microsoft Teams

      2. Join a meeting in Teams

      3. Manage the meeting

      4. Manage calendar meeting view

    2. Share content in meeting

      1. Show your screen during a meeting

      2. Show PowerPoint slides in meeting

      3. Share your screen in a meeting

      4. Give and take control of shared content

      5. Switch between people and content

    3. Recording meeting or live events

      1. Play and share a meeting recording

      2. Record a meeting in Teams

      3. Plan and schedule a live event

      4. Produce a live event

      5. Attend to live event

  5. Take meeting notes in Microsoft Teams

      1. Prepare collaborative notes before, during and after the meeting

References

Microsoft. (2019, July 01). Office 365 Training Center. Retrieved from https://support.office.com/en-us/office-training-center










 

Microsoft Planner Basics Fundamentals

Hours: 2.0

Prerequisites: N/A

Description:

In this course, participants will learn the advantages of using Microsoft Planner and Microsoft Teams together. The course will help participants understand new ways of making plans using Microsoft Planner, as well as create and organize plans, assign tasks, share files, and chat about the status and get progress updates of tasks or projects. This course helps and organization’s staff and leaders in the management of operations using the Planner app, with the goal of obtaining a big picture of productivity in relation to a project, all in one place.


Objectives

At the end of the course, the participant will be able to:

  • Create new plans, assign tasks, and share files with others.

  • Organize teamwork and collaborate on projects in a simple, visual way.

  • Chat with others to make sure you're on the same page.

  • Keep track of your team's progress and stay on top of your work—from anywhere, on any device.

  • Work with Microsoft Teams and Microsoft Planner together.


Framework Topics


  1. Introduction to Microsoft Planner

    1. What is Microsoft Planner?

    2. Set up and configure Microsoft Planner account


  1. Create new plan and tasks

    1. New plan, new group

      1. Build your plan

      2. Add a plan to an existing group

      3. Create a plan in the same group

      4. Add tasks to a plan

      5. Manage your tasks

      6. Add people to your plan

      7. See planner tasks in Microsoft To-Do


  1. More ways to get organized with Microsoft Planner

    1. Get organize with Microsoft Planner

      1. Create buckets to sort your tasks

      2. Set and update task progress

      3. Track progress

      4. Add task start and due dates

      5. See your planner schedule in Outlook Calendar

      6. Comments on tasks in Microsoft Planner

      7. Use schedule view in Microsoft Planner

      8. Plan an event in Planner


  1. Attach files, photos or links

    1. Attach files, photos or links

    2. Publish content

    3. Support customers in Microsoft Planner


  1. Use Planner in Microsoft Teams

    1. Create a plan with Planner in Teams

    2. Use Planner in Microsoft Teams

    3. Organize your teams in Planner

    4. Plan actions in Teams versus Planner for web

    5. Open your teams-created in Planner or Teams


References

Microsoft. (2019, July 01). Office 365 Training Center. Retrieved from https://support.office.com/en-us/office-training-center