Microsoft Azure Certification - United Kingdom

Microsoft Azure Administrator AZ104 Course Outline

Module 1: Manage Services with The Azure Portal

• Introduction
• Azure Management Options
• Navigate The Portal
• Exercise - Work with Resources
• Exercise - Use the Azure Portal
• Azure Portal Dashboards
• Exercise - Customise the Dashboard
• Access Preview Features

Module 2: Introduction To Azure Cloud Shell

• Introduction
• What Is Azure Cloud Shell?
• How Does Azure Cloud Shell Work?
• When Should You Use Azure Cloud Shell?

Module 3: Introduction To Bash

• Introduction
• What Is Bash?
• Bash Fundamentals
• Bash Commands and Operators
• Exercise - Try Bash
• Exercise - Terminate A Misbehaving Process
• Exercise - Use Bash and Grep to Filter CLI Output

Module 4: Introduction To PowerShell

• Introduction
• What Is PowerShell?
• Exercise - Run Your First PowerShell Commands
• Locate Commands
• Exercise - Locate Commands

Module 5: Deploy Azure Infrastructure by Using JSON ARM Templates

• Introduction
• Explore Azure Resource Manager Template Structure
• Exercise - Create and Deploy an Azure Resource Manager Template
• Add Flexibility to Your Azure Resource Manager Template by Using Parameters and Outputs
• Exercise - Add Parameters and Outputs to Your Azure Resource Manager Template

Module 6: Understand Microsoft Entra ID

• Introduction
• Examine Microsoft Entra ID
• Compare Microsoft Entra ID And Active Directory Domain Services
• Examine Microsoft Entra ID As a Directory Service for Cloud Apps
• Compare Microsoft Entra ID P1 And P2 Plans
• Examine Microsoft Entra Domain Services

Module 7: Create, Configure, And Manage Identities

• Introduction
• Create, Configure, And Manage Users
• Exercise - Assign Licenses to Users
• Exercise - Restore or Remove Deleted Users
• Create, Configure, And Manage Groups
• Exercise - Add Groups in Microsoft Entra ID
• Configure And Manage Device Registration
• Manage Licenses
• Exercise - Change Group License Assignments
• Exercise - Change User License Assignments
• Create Custom Security Attributes
• Explore Automatic User Creation

Module 8: Describe The Core Architectural Components of Azure

• Introduction
• What Is Microsoft Azure
• Get Started with Azure Accounts
• Exercise - Explore the Learn Sandbox
• Describe Azure Physical Infrastructure
• Describe Azure Management Infrastructure
• Exercise - Create an Azure Resource

Module 9: Azure Policy Initiatives

• Introduction
• Cloud Adoption Framework for Azure
• Azure Policy Design Principles
• Azure Policy Resources
• Azure Policy Definitions
• Evaluation Of Resources Through Azure Policy

Module 10: Secure Your Azure Resources with Azure Role-Based Access Control (Azure RBAC)

• Introduction
• What Is Azure RBAC?
• Knowledge Check - What Is Azure RBAC?
• Exercise - List Access Using Azure RBAC and The Azure Portal
• Exercise - Grant Access Using Azure RBAC and The Azure Portal
• Exercise - View Activity Logs for Azure RBAC Changes

Module 11: Allow Users to Reset Their Password with Microsoft Entra Self-Service Password Reset

• Introduction
• What Is Self-Service Password Reset in Microsoft Entra ID?
• Implement Microsoft Entra Self-Service Password Reset
• Exercise - Set Up Self-Service Password Reset
• Exercise - Customise Directory Branding

Module 12: Configure Virtual Networks

• Introduction
• Plan Virtual Networks
• Create Subnets
• Create Virtual Networks
• Plan IP Addressing
• Create Public IP Addressing
• Associate Public IP Addresses
• Allocate Or Assign Private IP Addresses
• Interactive Lab Simulation

Module 13: Configure Network Security Groups

• Introduction
• Implement Network Security Groups
• Determine Network Security Group Rules
• Determine Network Security Group Effective Rules
• Create Network Security Group Rules
• Implement Application Security Groups
• Interactive Lab Simulation

Module 14: Host Your Domain On Azure DNS

• Introduction
• What Is Azure DNS?
• Configure Azure DNS to Host Your Domain
• Exercise - Create A DNS Zone And an A Record By Using Azure DNS
• Dynamically Resolve Resource Name by Using Alias Record
• Exercise - Create Alias Records for Azure DNS

Module 15: Configure Azure Virtual Network Peering

• Introduction
• Determine Azure Virtual Network Peering Uses
• Determine Gateway Transit and Connectivity
• Create Virtual Network Peering
• Extend Peering with User-Defined Routes and Service Chaining
• Interactive Lab Simulation

Module 16: Manage And Control Traffic Flow in Your Azure Deployment with Routes

• Introduction
• Identify Routing Capabilities of An Azure Virtual Network
• Exercise - Create Custom Routes
• What Is An NVA?
• Exercise - Create an NVA And Virtual Machines
• Exercise - Route Traffic Through The NVA

Module 17: Introduction To Azure Load Balancer

• Introduction
• What Is Azure Load Balancer?
• What an Azure Load Balancer Works
• When To Use Azure Load Balancer

Module 18: Introduction To Azure Application Gateway

• Introduction
• What Is Azure Application Gateway?
• How Azure Application Gateway Works
• When To Use Azure Application Gateway

Module 19: Introduction To Azure Network Watcher

• Introduction
• What Is Azure Network Watcher?
• How Azure Network Watcher Works
• When To Use Azure Network Watcher

Module 20: Configure Storage Accounts

• Introduction
• Implement Azure Storage
• Explore Azure Storage Services
• Determine Storage Account Types
• Determine Replication Strategies
• Access Storage
• Secure Storage Endpoints

Module 21: Configure Azure Blob Storage

• Introduction
• Implement Azure Blob Storage
• Create Blob Containers
• Assign Blob Access Tiers
• Add Blob Lifecycle Management Rules
• Determine Blob Object Replication
• Upload Blobs
• Determine Blob Storage Pricing
• Interactive Lab Simulation

Module 22: Configure Azure Storage Security

• Introduction
• Review Azure Storage Security Strategies
• Create Shared Access Signatures
• Identify URI And SAS Parameters
• Determine Azure Storage Encryption
• Create Customer-Managed Keys
• Apply Azure Storage Security Best Practices
• Interactive Lab Simulation

Module 23: Configure Azure Files

• Introduction
• Compare Storage for File Shares and Blob Data
• Manage Azure File Shares
• Create File Share Snapshots
• Implement Soft Delete for Azure Files
• Use Azure Storage Explorer
• Consider Azure File Sync

Module 24: Introduction To Azure Virtual Machines

• Introduction
• Compile A Checklist for Creating an Azure Virtual Machine
• Exercise - Create A VM Using the Azure Portal
• Describe The Options Available to Create and Manage an Azure Virtual Machine
• Manage The Availability of Your Azure VMs
• Back Up Your Virtual Machines

Module 25: Configure Virtual Machine Availability

• Introduction
• Plan For Maintenance and Downtime
• Create Availability Sets
• Review Update Domains and Fault Domains
• Review Availability Zones
• Compare Vertical and Horizontal Scaling
• Implement Azure Virtual Machine Scale Sets
• Create Virtual Machine Scale Sets
• Implement Autoscale
• Configure Autoscale
• Interactive Lab Simulation

Module 26: Configure Azure App Service Plans

• Introduction
• Implement Azure App Service Plans
• Determine Azure App Service Plan Pricing
• Scale Up and Scale Out Azure App Service
• Configure Azure App Service Autoscale

Module 27: Configure Azure App Service

• Introduction
• Implement Azure App Service
• Create An App with App Service
• Explore Continuous Integration and Deployment
• Create Deployment Slots
• Add Deployment Slots
• Secure Your App Service App
• Create Custom Domain Names
• Back Up and Restore Your App Service App
• Use Azure Application Insights
• Interactive Lab Simulation

Module 28: Configure Azure Container Instances

• Introduction
• Compare Containers to Virtual Machines
• Review Azure Container Instances
• Implement Container Groups
• Review Azure Container Apps
• Interactive Lab Simulation

Module 29: Introduction To Azure Backup

• Introduction
• What Is Azure Backup?
• How Azure Backup Works
• When To Use Azure Backup

Module 30: Protect Your Virtual Machines by Using Azure Backup

• Introduction
• Azure Backup Features and Scenarios
• Back Up an Azure Virtual Machine by Using Azure Backup
• Exercise - Back Up an Azure Virtual Machine
• Restore Virtual Machine Data
• Exercise - Restore Azure Virtual Machine Data

Module 31: Introduction To Azure Monitor

• Introduction
• Monitoring And Azure Monitor
• Metrics And Logs
• Azure Monitor Insights, Visualisations, And Actions

Module 32: Improve Incident Response with Azure Monitor Alerts

• Introduction
• Explore The Different Alert Types That Azure Monitor Supports
• Use Metric Alerts for Alerts About Performance Issues in Your Azure Environment
• Exercise - Use Metric Alerts to Alert on Performance Issues in Your Azure Environment
• Use Log Search Alerts to Alert on Events in Your Application
• Use Activity Log Alerts to Alert on Events Within Your Azure Infrastructure
• Use Action Groups and Alert Processing Rules to Send Notifications When an Alert Is Fired
• Exercise -Use an Activity Log Alert and An Action Group to Notify Users About Events in Your Azure Infrastructure

Module 33: Analyse Your Azure Infrastructure by Using Azure Monitor Logs

• Introduction
• Features Of Azure Monitor Logs
• Create Basic Azure Monitor Log Queries to Extract Information from Log Data
• Exercise - Create Basic Azure Monitor Log Queries to Extract Information from Log Data

Developing Solutions for Microsoft Azure AZ-204 Course Outline

Module 1: Explore Azure App Service                          

• Introduction
• Examine Azure App Service
• Examine Azure App Service Plans
• Deploy to App Service
• Explore Authentication and Authorisation in App Service
• Discover App Service Networking Features
• Exercise: Create a Static HTML Web App by Using Azure Cloud Shell

Module 2: Configure Web App Settings

• Introduction
• Configure Application Settings
• Configure General Settings
• Configure Path Mappings
• Enable Diagnostic Logging
• Configure Security Certificates

Module 3: Scale Apps in Azure App Service

• Introduction
• Examine Autoscale Factors
• Identify Autoscale Factors
• Enable Autoscale in App Service
• Explore Autoscale Best Practices

Module 4: Explore Azure App Service Deployment Slots

• Introduction
• Explore Staging Environments
• Examine Slot Swapping
• Swap Deployment Slots
• Route Traffic in App Service

Module 5: Explore Azure Functions

• Introduction
• Discover Azure Functions
• Compare Azure Functions Hosting Options
• Scale Azure Functions

Module 6: Develop Azure Functions

• Introduction
• Explore Azure Functions Development
• Create Triggers and Bindings
• Connect Functions to Azure Services
• Exercise: Create an Azure Function by Using Visual Studio Code

Module 7: Explore Azure Blob Storage

• Introduction
• Explore Azure Blob Storage
• Discover Azure Blob Storage Resource Types
• Explore Azure Storage Security Features
• Discover Static Website Hosting in Azure Storage

Module 8: Manage the Azure Blob Storage lifecycle

• Introduction
• Explore the Azure Blob Storage Lifecycle
• Discover Blob Storage Lifecycle Policies
• Implement Blob Storage Lifecycle Policies
• Rehydrate Blob Data from the Archive Tier

Module 9: Work with Azure Blob Storage

• Introduction
• Explore Azure Blob Storage Client Library
• Create a Client Object
• Exercise: Create Blob Storage Resources by Using the .NET Client Library
• Manage Container Properties and Metadata by Using .NET
• Set and Retrieve Properties and Metadata for Blob Resources by Using REST

Module 10: Explore Azure Cosmos DB

• Introduction
• Identify Key Benefits of Azure Cosmos DB
• Explore the Resource Hierarchy
• Explore Consistency Levels
• Choose the Right Consistency Level
• Explore Supported APIs
• Discover Request Units
• Exercise: Create Azure Cosmos DB Resources by Using the Azure Portal

Module 11: Work with Azure Cosmos DB

• Introduction
• Explore Microsoft .NET SDK V3 for Azure Cosmos DB
• Exercise: Create Resources by Using the Microsoft .NET SDK V3
• Create Stored Procedures
• Create Triggers and User-Defined Functions
• Explore Change Feed in Azure Cosmos DB

Module 12: Manage Container Images in Azure Container Registry

• Introduction
• Discover the Azure Container Registry
• Explore Storage Capabilities
• Build and Manage Containers with Tasks
• Explore Elements of a Docker File
• Exercise: Build and Run a Container Image by Using Azure Container Registry Tasks

Module 13: Run Container Images in Azure Container Instances

• Introduction
• Explore Azure Container Instances
• Exercise - Deploy a Container Instance by Using the Azure CLI
• Run Containerised Tasks with Restart Policies
• Set Environment Variables in Container Instances
• Mount an Azure File Share in Azure Container Instances

Module 14: Implement Azure Container Apps

• Introduction
• Explore Azure Container Apps
• Exercise - Deploy A Container App
• Explore Containers in Azure Container Apps
• Implement Authentication and Authorization in Azure Container Apps
• Manage Revisions and Secrets in Azure Container Apps
• Explore Dapr Integration with Azure Container Apps

Module 15: Explore the Microsoft Identity Platform

• Introduction
• Explore the Microsoft Identity Platform
• Explore Service Principals
• Discover Permissions and Consent
• Discover Conditional Access

Module 16: Implement Authentication by Using the Microsoft Authentication Library

• Introduction
• Explore the Microsoft Authentication Library
• Initialise Client Applications
• Exercise - Implement Interactive Authentication by Using MSAL.NET

Module 17: Implement Shared Access Signatures

• Introduction
• Discover Shared Access Signatures
• Choose When to Use Shared Access Signatures
• Explore Stored Access Policies

Module 18: Explore Microsoft Graph

• Introduction
• Discover Microsoft Graph
• Query Microsoft Graph by Using REST
• Query Microsoft Graph by Using SDKs
• Apply Best Practices to Microsoft Graph

Module 19: Implement Azure Key Vault

• Introduction
• Explore Azure Key Vault
• Discover Azure Key Vault Best Practices
• Authenticate to Azure Key Vault
• Exercise: Set and Retrieve a Secret from Azure Key Vault by Using Azure CLI

Module 20: Implement Managed Identities

• Introduction
• Explore Managed Identities
• Discover the Managed Identities Authentication Flow
• Configure Managed Identities
• Acquire an Access Token

Module 21: Implement Azure App Configuration

• Introduction
• Explore the Azure App Configuration Service
• Create Paired Keys and Values
• Manage Application Features
• Secure App Configuration Data

Module 22: Explore API Management

• Introduction
• Discover the API Management service
• Explore API gateways
• Explore API Management policies
• Create advanced policies
• Secure APIs by using subscriptions
• Secure APIs by using certificates

Module 23: Explore Azure Event Grid

• Introduction
• Explore Azure Event Grid
• Discover Event Schemas
• Explore Event Delivery Durability
• Control Access to Events
• Receive Events by Using Webhooks
• Filter Events
• Exercise - Route Custom Events to Web Endpoint by Using Azure CLI

Module 24: Explore Azure Event Hubs

• Introduction
• Discover Azure Event Hubs
• Explore Event Hubs Capture
• Scale your Processing Application
• Control Access to Events
• Perform Common Operations with the Event Hubs Client Library

Module 25: Discover Azure Message Queues

• Introduction
• Choose a Message Queue Solution
• Explore Azure Service Bus
• Discover Service Bus Queues, Topics, and Subscriptions
• Explore Service Bus Message Payloads and Serialisation
• Exercise: Send and Receive Messages from a Service Bus Queue by Using .NET
• Explore Azure Queue Storage
• Create and Manage Azure Queue Storage and Messages by Using .NET

Module 26: Monitor App Performance

• Explore Application Insights
• Discover Log-Based Metrics
• Instrument an App for Monitoring
• Select an Availability Test
• Troubleshoot App Performance by Using Application Map

Module 27: Develop for Azure Cache for Redis

• Explore Azure Cache for Redis
• Configure Azure Cache for Redis
• Interact with Azure Cache for Redis by using .NET
• Exercise - Connect an app to Azure Cache for Redis by using .NET Core

Module 28: Develop for Storage on CDNs

• Explore Azure Content Delivery Networks
• Control cache behaviour on Azure Content Delivery Networks
• Interact with Azure Content Delivery Networks by using .NET

Designing Microsoft Azure Infrastructure Solutions AZ305 Course Outline

Module 1: Describe the Core Architectural Components of Azure

• Introduction
• What Is Microsoft Azure
• Get Started with Azure Accounts
• Exercise - Explore the Learn Sandbox
• Describe Azure Physical Infrastructure
• Describe Azure Management Infrastructure
• Exercise - Create an Azure Resource

Module 2: Describe Azure Compute and Networking Services

• Introduction
• Describe Azure Virtual Machines
• Exercise - Create an Azure Virtual Machine
• Describe Azure Virtual Desktop
• Describe Azure Containers
• Describe Azure Functions
• Describe Application Hosting Options
• Describe Azure Virtual Networking
• Exercise - Configure Network Access
• Describe Azure Virtual Private Networks
• Describe Azure ExpressRoute
• Describe Azure DNS

Module 3: Describe Azure Storage Services

• Introduction
• Describe Azure Storage Accounts
• Describe Azure Storage Redundancy
• Describe Azure Storage Services
• Exercise - Create a Storage Blob
• Identify Azure Data Migration Options
• Identify Azure File Movement Options

Module 4: Describe Azure Identity, Access, and Security

• Introduction
• Describe Azure Directory Services
• Describe Azure Authentication Methods
• Describe Azure External Identities
• Describe Azure Conditional Access
• Describe Azure Role-Based Access Control
• Describe Zero Trust Model
• Describe Defense-in-Depth
• Describe Microsoft Defender for Cloud

Module 5: Introduction to the Microsoft Cloud Adoption Framework

• Introduction
• Strategy
• Plan
• Ready
• Migrate
• Innovate
• Govern
• Manage
• Secure

Module 6: Introduction to the Microsoft Azure Well-Architected Framework

• Introduction
• Azure Well-Architected Framework Pillars
• Cost Optimisation
• Operational Excellence
• Performance Efficiency
• Reliability
• Security

Module 7: Azure Architects Design and Recommend Governance Solutions

• Introduction
• Design for Governance
• Design for Management Groups
• Design for Subscriptions
• Design for Resource Groups
• Design for Resource Tags
• Design for Azure Policy
• Design for Role-Based Access Control (RBAC)
• Design for Azure Landing Zones

Module 8: Design Authentication and Authorisation Solutions

Introduction

• Design for Identity and Access Management (IAM)
• Design for Microsoft Entra ID
• Design for Microsoft Entra Business-to-Business (B2B)
• Design for Azure Active Directory B2C
• Design for Conditional Access
• Design for Identity Protection
• Design for Access Reviews
• Design Service Principals for Applications
• Design Managed Identities
• Design for Azure Key Vault

Module 9: Design a Solution to Log and Monitor Azure Resources

• Introduction
• Design for Azure Monitor Data Sources
• Design for Azure Monitor Logs (Log Analytics) Workspaces
• Design for Azure Workbooks and Azure Insights
• Design for Azure Data Explorer

Module 10: Describe High Availability and Disaster Recovery Strategies

• Introduction
• Describe Recovery Time Objective and Recovery Point Objective
• Explore High Availability and Disaster Recovery Options
• Describe Azure High Availability and Disaster Recovery Features for Azure Virtual Machines
• Describe High Availability and Disaster Recovery for PaaS Deployments
• Explore High Availability and Disaster Recovery Solution for IaaS
• Describe Hybrid Solutions

Module 11: Design a Solution for Backup and Disaster Recovery

• Introduction
• Design for Backup and Recovery
• Design for Azure Backup
• Design for Azure Blob Backup and Recovery
• Design for Azure Files Backup and Recovery
• Design for Azure Virtual Machine Backup and Recovery
• Design for Azure SQL Backup and Recovery
• Design for Azure Site Recovery

Module 12: Design a Data Storage Solution for Non-Relational Data

• Introduction
• Design for Data Storage
• Design for Azure Storage Accounts
• Design for Data Redundancy
• Design for Azure Blob Storage
• Design for Azure Files
• Design for Azure Managed Disks
• Design for Storage Security

Module 13: Design a Data Storage Solution for Relational Data

• Introduction
• Design for Azure SQL Database
• Design for Azure SQL Managed Instance
• Design for SQL Server on Azure Virtual Machines
• Recommend a Solution for Database Scalability
• Recommend a Solution for Database Availability
• Design Security for Data at Rest, Data in Motion, and Data in Use
• Design for Azure SQL Edge
• Design for Azure Cosmos DB and Table Storage

Module 14: Design Data Integration

• Introduction
• Design a Data Integration Solution with Azure Data Factory
• Design a Data Integration Solution with Azure Data Lake
• Design a Data Integration and Analytic Solution with Azure Databricks
• Design a Data Integration and Analytic Solution with Azure Synapse Analytics
• Design Strategies for Hot, Warm, and Cold Data Paths
• Design an Azure Stream Analytics Solution for Data Analysis

Module 15: Design an Azure Compute Solution

• Introduction
• Choose an Azure Compute Service
• Design for Azure Virtual Machines Solutions
• Design for Azure Batch Solutions
• Design for Azure App Service Solutions
• Design for Azure Container Instances Solutions
• Design for Azure Kubernetes Service Solutions
• Design for Azure Functions Solutions
• Design for Azure Logic Apps Solutions

Module 16: Design an Application Architecture

• Introduction
• Describe Message and Event Scenarios
• Design a Messaging Solution
• Design an Azure Event Hubs Messaging Solution
• Design an Event-Driven Solution
• Design a Caching Solution
• Design API Integration
• Design an Automated App Deployment Solution
• Design an App Configuration Management Solution

Module 17: Design Network Solutions

• Introduction
• Recommend a Network Architecture Solution Based on Workload Requirements
• Design Patterns for Azure Network Connectivity Services
• Design Outbound Connectivity and Routing
• Design for On-Premises Connectivity to Azure Virtual Network
• Choose an Application Delivery Service
• Design for Application Delivery Services
• Design for Application Protection Services

Module 18: Design Migrations

• Introduction
• Evaluate Migration with the Cloud Adoption Framework
• Describe the Azure Migration Framework
• Assess Your On-Premises Workloads
• Select a Migration Tool
• Migrate Your Structured Data in Databases
• Select an Online Storage Migration Tool for Unstructured Data
• Migrate Offline Data

Module 19: Introduction to the Microsoft Azure Well-Architected Framework

• Introduction
• Azure Well-Architected Framework Pillars
• Cost Optimisation
• Operational Excellence
• Performance Efficiency
• Reliability
• Security

Module 20: Microsoft Azure Well-Architected Framework - Cost Optimisation

• Introduction
• Develop Cost-Management Discipline
• Design with a Cost-Efficiency Mindset
• Design for Usage Optimisation
• Design for Rate Optimisation
• Monitor and Optimise Over Time

Module 21: Microsoft Azure Well-Architected Framework - Operational Excellence

• Introduction
• Embrace DevOps Culture
• Establish Development Standards
• Evolve Operations with Observability
• Deploy with Confidence
• Automate for Efficiency
• Adopt Safe Deployment Practices

Module 22: Microsoft Azure Well-Architected Framework - Performance Efficiency

• Introduction
• Negotiate Realistic Performance Targets
• Design to Meet Capacity Requirements
• Achieve and Sustain Performance
• Improve Efficiency through Optimisation

Module 23: Microsoft Azure Well-Architected Framework - Reliability

• Introduction
• Design for Business Requirements
• Design for Resilience
• Design for Recovery
• Design for Operations
• Keep It Simple

Module 24: Microsoft Azure Well-Architected Framework - Security

• Introduction
• Plan Your Security Readiness
• Design to Protect Confidentiality
• Design to Protect Integrity
• Design to Protect Availability
• Sustain and Evolve Your Security Posture

Module 25: Develop a Cloud Adoption Strategy by Using the Cloud Adoption Framework

• Introduction
• Assess Your Cloud Adoption Strategy
• Determine Your Motivations
• Define Your Mission and Objectives
• Define Your Cloud Strategy Team
• Prepare for Organisational Alignment
• Cost Efficiency Considerations for Your Cloud Adoption Strategy
• AI Considerations for Your Cloud Adoption Strategy
• Resiliency Considerations for Your Cloud Adoption Strategy
• Security Considerations for Your Cloud Adoption Strategy
• Sustainability Considerations for Your Cloud Adoption Strategy

Module 26: Prepare for Cloud Adoption with a Data-Driven Plan

• Introduction
• Customer Narrative
• Exercise - Deploy Your First Cloud Adoption Plan
• Exercise - Customise Your Cloud Adoption Plan

Module 27: Choose the Best Azure Landing Zone to Support Your Requirements for Cloud Operations

• Introduction
• Customer Narrative
• Common Operating Models
• Design Areas for Azure Landing Zones
• Design Principles for Azure Landing Zones
• Journey to the Target Architecture
• Choose an Azure Landing Zone Option
• Deploy the Azure Landing Zone Accelerator
• Enhance Your Landing Zone

Module 28: Use the Cloud Adoption Framework Migrate Methodology to Migrate Your Workload to the Cloud

• Introduction
• Prepare for Your Migration
• Assess Your Workload
• Deploy Your Assets
• Release Your Workload

Module 29: Address Tangible Risks with the Govern Methodology of the Cloud Adoption Framework for Azure

• Introduction
• Customer Narrative
• Govern Methodology
• Assess Cloud Governance Risks
• Document Cloud Governance Policies
• Enforce Cloud Governance Policies
• Monitor Cloud Governance

Module 30: Ensure Stable Operations and Optimisation Across All Supported Workloads Deployed to the Cloud

• Introduction
• Establish Business Commitments
• Deploy an Operations Baseline
• Protect and Recover
• Enhance an Operations Baseline
• Manage Platform and Workload Specialisation

Module 31: Innovate Applications by Using Azure Cloud Technologies

• Introduction
• Follow the Innovation Lifecycle
• Azure Technologies for the Build Process
• Infuse Your Applications with AI
• Azure Technologies for Measuring Business Impact
• Azure Technologies for the Learn Process

Module 32: Strengthen Cloud Security by Using the Cloud Adoption Framework

• Introduction
• The Secure Methodology
• Teams, Roles, and Functions
• Integrate Security into Your Cloud Adoption Strategy
• Plan for a Secure Cloud Adoption
• Prepare Your Secure Cloud Estate
• Perform Your Cloud Adoption Securely
• Govern Your Cloud Estate Securely
• Manage Your Cloud Estate with Enhanced Security

Microsoft Azure Security Technologies AZ-500 Course Outline

Module 1: Manage Identities in Microsoft Entra ID

• What is Microsoft Entra ID?
• Secure Microsoft Entra Users
• Create a New User in Microsoft Entra ID
• Secure Microsoft Entra Groups
• Recommend when to use External Identities
• Secure External Identities
• Implement Microsoft Entra Identity Protection

Module 2: Manage Authentication by using Microsoft Entra ID

• Microsoft Entra Connect
• Microsoft Entra Cloud Sync
• Authentication Options
• Password Hash Synchronization with Microsoft Entra ID
• Microsoft Entra Pass-through Authentication
• Federation with Microsoft Entra ID
• What is Microsoft Entra Authentication?
• Implement Multifactor Authentication (MFA)
• Passwordless Authentication Options for Microsoft Entra ID
• Implement Passwordless Authentication
• Implement Password Protection
• Microsoft Entra ID Single Sign-on
• Implement Single Sign-on (SSO)
• Integrate Single Sign-on (SSO) and Identity Providers
• Introduction to Microsoft Entra Verified ID
• Configure Microsoft Entra Verified ID
• Recommend and Enforce Modern Authentication Protocols

Module 3: Manage Authorization by using Microsoft Entra ID

• Azure Management Groups
• Configure Azure Role Permissions for Management Groups, Subscriptions, Resource Groups, And Resources
• Azure Role-Based Access Control
• Azure Built-In Roles
• Assign Azure Role Permissions for Management Groups, Subscriptions, Resource Groups, And Resources
• Microsoft Entra Built-In Roles
• Assign Built-In Roles in Microsoft Entra ID
• Microsoft Entra Role-Based Access Control
• Create and Assign a Custom Role in Microsoft Entra ID
• Microsoft Entra Permissions Management
• Implement and Manage Microsoft Entra Permissions Management
• Zero Trust Security
• Microsoft Entra Privileged Identity Management
• Configure Privileged Identity Management
• Microsoft Entra ID Governance
• Entitlement Management
• Access Reviews
• Identity Lifecycle Management
• Lifecycle Workflows
• Delegation and Roles in Entitlement Management
• Configure Role Management and Access Reviews by Using Microsoft Entra ID Governance
• Implement Conditional Access Policies

Module 4: Manage Application Access in Microsoft Entra ID

• Manage Access to Enterprise Applications in Microsoft Entra ID, Including Oauth Permission Grants
• Manage App Registrations in Microsoft Entra ID
• Configure App Registration Permission Scopes
• Manage App Registration Permission Consent
• Manage and Use Service Principals
• Manage Managed Identities for Azure Resources
• Recommend When to Use and Configure A Microsoft Entra Application Proxy, Including Authentication

Module 5: Plan and Implement Security for Virtual Networks

• What is an Azure Virtual Network?
• Plan and Implement Network Security Groups (Nsgs) And Application Security Groups (Asgs)
• Plan and Implement User-Defined Routes (Udrs)
• Plan and Implement Virtual Network Peering or Gateway
• Plan and Implement Virtual Wide Area Network, Including Secured Virtual Hub
• Secure VPN Connectivity, Including Point-To-Site and Site-To-Site
• Azure Expressroute
• Implement Encryption Over Expressroute
• Configure Firewall Settings on Paas Resources
• Monitor Network Security by Using Network Watcher, Including Network Security Groups

Module 6: Plan and Implement Security for Private Access to Azure Resources

• Plan and Implement Virtual Network Service Endpoints
• Plan and Implement Private Endpoints
• Plan and Implement Private Link Services
• Plan and Implement Network Integration for Azure App Service and Azure Functions
• Plan and Implement Network Security Configurations for An App Service Environment (ASE)
• Plan and Implement Network Security Configurations for An Azure SQL Managed Instance

Module 7: Plan and Implement Security for Public Access to Azure Resources

• Plan and Implement Transport Layer Security (TLS) To Applications, Including Azure App Service and API Management
• Plan, Implement, And Manage an Azure Firewall, Azure Firewall Manager and Firewall Policies
• Plan and Implement an Azure Application Gateway
• Plan and Implement a Web Application Firewall (WAF)
• Plan and Implement an Azure Front Door, Including Content Delivery Network (CDN)
• Recommend When to Use Azure Ddos Protection Standard

Module 8: Plan and Implement Advanced Security for Compute

• Plan and Implement Remote Access to Public Endpoints, Azure Bastion and Just-In-Time (JIT) Virtual Machine (VM) Access
• What Is Azure Kubernetes Service?
• Configure Network Isolation for Azure Kubernetes Service (AKS)
• Secure and Monitor Azure Kubernetes Service
• Configure Authentication for Azure Kubernetes Service
• Configure Security for Azure Container Instances (Acis)
• Configure Security for Azure Container Apps (Acas)
• Manage Access to Azure Container Registry (ACR)
• Configure Disk Encryption, Azure Disk Encryption (ADE), Encryption as Host, And Confidential Disk Encryption
• Recommend Security Configurations for Azure API Management

Module 9: Plan and Implement Security for Storage

• Azure Storage
• Configure Access Control for Storage Accounts
• Manage Life Cycle for Storage Account Access Keys
• Select and Configure an Appropriate Method for Access to Azure Files
• Select and Configure an Appropriate Method for Access to Azure Blobs
• Select and Configure an Appropriate Method for Access to Azure Tables
• Select and Configure an Appropriate Method for Access to Azure Queues
• Select and Configure Appropriate Methods for Protecting Against Data Security Threats, Including Soft Delete, Backups, Versioning, and Immutable Storage
• Configure Bring Your Own Key (Byok)
• Enable Double Encryption at the Azure Storage Infrastructure Level

Module 10: Plan and Implement Security for Azure SQL Database and Azure SQL Managed Instance

• Azure SQL Database and SQL Managed Instance Security
• Enable Database Authentication by Using Microsoft Entra ID
• Enable and Monitor Database Audit7 Min
• Identify Use Cases for the Microsoft Purview Governance Portal
• Implement Data Classification of Sensitive Information by Using the Microsoft Purview Governance Portal
• Plan and Implement Dynamic Mask
• Implement Transparent Data Encryption​
• Recommend When to Use Azure SQL Database Always Encrypted

Module 11: Plan, Implement, and Manage Governance for Security

• Azure Governance
• Create, Assign, And Interpret Security Policies and Initiatives in Azure Policy
• Configure Security Settings by Using Azure Blueprint
• Deploy Secure Infrastructures by Using a Landing Zone
• Azure Key Vault
• Azure Key Vault Security
• Azure Key Vault Authentication
• Create and Configure an Azure Key Vault
• Recommend When to Use a Dedicated Hardware Security Module (HSM)
• Configure Access to Key Vault, Including Vault Access Policies and Azure Role Based Access Control
• Manage Certificates, Secrets, and Keys
• Configure Key Rotation
• Configure Backup and Recovery of Certificates, Secrets, And Keys

Module 12: Manage Security Posture by using Microsoft Defender for Cloud

• Implement Microsoft Defender For Cloud
• Identify and Remediate Security Risks by Using the Microsoft Defender for Cloud Secure Score and Inventory
• Assess Compliance Against Security Frameworks and Microsoft Defender for Cloud
• Add Industry and Regulatory Standards to Microsoft Defender For Cloud
• Add Custom Initiatives to Microsoft Defender For Cloud
• Connect Hybrid Cloud and Multicloud Environments to Microsoft Defender For Cloud
• Identify and Monitor External Assets by Using Microsoft Defender External Attack Surface Management

Module 13: Configure and Manage Threat Protection by using Microsoft Defender for Cloud

• Enable Workload Protection Services in Microsoft Defender for Cloud
• Configure Microsoft Defender for Servers
• Configure Microsoft Defender for Azure SQL Database
• Container Security in Microsoft Defender for Containers
• Managed Kubernetes Threat Factors
• Defender for Containers Architecture
• Configure Microsoft Defender for Containers Components
• Vulnerability Assessments for Azure
• Defender for Storage
• Malware Scanning in Defender for Storage
• Detect Threats to Sensitive Data
• Deploy Microsoft Defender For Storage
• Enable Configure Azure Built-In Policy
• Microsoft Defender For Cloud Devops Security
• Devops Security Support and Prerequisites
• Devops Environment Security Posture
• Connect Your Github Lab Environment to Microsoft Defender for Cloud
• Configure the Microsoft Security Devops Github Action
• Manage and Respond to Security Alerts in Microsoft Defender for Cloud
• Configure Workflow Automation by Using Microsoft Defender for Cloud
• Evaluate Vulnerability Scans from Microsoft Defender For Server

Module 14: Configure and Manage Security Monitoring and Automation solutions

• Monitor Security Events by Using Azure Monitor
• Configure Data Connectors in Microsoft Sentinel
• Create and Customize Analytics Rules in Microsoft Sentinel
• Evaluate Alerts and Incidents from Microsoft Sentinel
• Configure Automation in Microsoft Sentinel

Designing and Implementing Microsoft DevOps Solutions AZ400 Course Outline

Module 1: Introduction to DevOps

• Introduction
• What is DevOps?
• Explore the DevOps Journey
• Identify Transformation Teams
• Define Organisation Structure for Agile Practices
• Explore Shared Goals and Define Timelines
• What is Azure DevOps?
• What is GitHub?
• Design a License Management Strategy
• What is Source Control?
• Describe Working with Git Locally
• Introduction to Azure Repos
• Introduction to GitHub

Module 2: Plan Agile with GitHub Projects and Azure Boards

• Introduction
• Introduction to GitHub Projects and Project Boards
• Introduction to Azure Boards
• Configure Projects and Teams in Azure DevOps
• Link GitHub to Azure Boards
• Configure GitHub Projects
• Manage Work with GitHub Project Boards
• Customise Project Views
• Collaborate Using Team Discussions
• Design and Implement a Strategy for Feedback Cycles
• Design and Implement Source, Bug, and Quality Traceability
• Agile Plan and Portfolio Management with Azure Boards

Module 3: Design and Implement Branch Strategies and Workflows

• Introduction
• Explore Branch Workflow Types
• Explore Feature Branch Workflow
• Explore Git Branch Model for Continuous Delivery
• Explore GitHub Flow
• Explore Fork Workflow
• Implement Branch Merging Restrictions
• Version Control with Git in Azure Repos

Module 4: Collaborate with Pull Requests in Azure Repos

• Introduction
• Collaborate with Pull Requests
• Exercise: Azure Repos Collaborating with Pull Requests

Module 5: Explore Git Hooks

• Introduction to Git Hooks
• Implement Git Hooks

Module 6: Plan Foster Inner Source

• Introduction
• Explore Foster Inner Source
• Implement the Fork Workflow
• Describe Inner Source with Forks

Module 7: Manage and Configure Repositories

• Introduction
• Work with Large Repositories
• Explore Monorepo Versus Multiple Repos
• Implement a Change Log
• Implement Scalar and Cross-Repo Sharing
• Recover Specific Data by Using Git Commands
• Purge Repository Data
• Manage Releases with GitHub Repos
• Automate Release Notes with GitHub
• Create API Documentation
• Implement Automation of Git History Documentation
• Configure Source Control Repository Permissions Using GitHub
• Configure GitHub Tags to Organise Repositories

Module 8: Identify Technical Debt

• Introduction
• Examine Code Quality
• Examine Complexity and Quality Metrics
• Introduction to Technical Debt
• Measure and Manage Technical Debt
• Introduction to GitHub Advanced Security
• Integrate Other Code Quality Tools
• Plan Effective Code Reviews

Module 9: Explore Azure Pipelines

• Introduction
• Explore the Concept of Pipelines in DevOps
• Describe Azure Pipelines
• Understand Azure Pipelines Key Terms

Module 10: Manage Azure Pipeline Agents and Pools

• Introduction
• Choose Between Microsoft-hosted Versus Self-hosted Agents
• Explore Job Types
• Introduction to Agent Pools
• Explore Predefined Agent Pools
• Understand Typical Situations for Agent Pools
• Communicate with Azure Pipelines
• Communicate to Deploy to Target Servers
• Examine Other Considerations
• Describe Security of Agent Pools
• Configure Agent Pools and Understand Pipeline Styles

Module 11: Describe Pipelines and Concurrency

• Introduction
• Understand Parallel Jobs
• Estimate Parallel Jobs
• Describe Azure Pipelines and Open-Source Projects
• Explore Azure Pipelines and Visual Designer
• Describe Azure Pipelines and YAML
• Enable Continuous Integration with Azure Pipelines

Module 12: Design and Implement a Pipeline Strategy

• Introduction
• Configure Agent Demands
• Explore Multi-configuration and Multi-agent
• Integrate GitHub Repos and Azure Pipelines
• Design and Implement a Comprehensive Testing Strategy
• Implement Code Coverage and Show in the Pipeline
• Implement Multi-job Builds
• Explore Source Control Types Supported by Azure Pipelines

Module 13: Integrate with Azure Pipelines

• Introduction
• Describe the Anatomy of a Pipeline
• Understand the Pipeline Structure
• Detail Templates
• Explore YAML Resources
• Use Multiple Repositories in Your Pipeline
• Migrate a Pipeline from Classic to YAML in Azure Pipelines

Module 14: Introduction to GitHub Actions

• Introduction
• What are Actions?
• Explore Actions Flow
• Understand Workflows
• Describe Standard Workflow Syntax Elements
• Explore Events
• Explore Jobs
• Explore Runners
• Examine Release and Test an Action

Module 15: Learn Continuous Integration with GitHub Actions

• Introduction
• Describe Continuous Integration with Actions
• Examine Environment Variables
• Share Artifacts Between Jobs
• Examine Workflow Badges
• Describe Best Practices for Creating Actions
• Mark Releases with Git Tags
• Create Encrypted Secrets
• Use Secrets in a Workflow
• Implement GitHub Actions for CI/CD

Module 16: Design a Container Build Strategy

• Introduction
• Examine Structure of Containers
• Work with Docker Containers
• Understand Dockerfile Core Concepts
• Examine Multi-stage Dockerfiles
• Examine Considerations for Multiple Stage Builds
• Explore Azure Container-related Services
• Deploy Docker Containers to Azure App Service Web Apps

Module 17: Create a Release Pipeline

• Introduction
• Describe Azure DevOps Release Pipeline Capabilities
• Explore Release Pipelines
• Explore Artifact Sources
• Choose the Appropriate Artifact Source
• Examine Considerations for Deployment to Stages
• Explore Build and Release Tasks
• Explore Custom Build and Release Tasks
• Explore Release Jobs
• Understand Database Deployment Task
• Configure Pipelines as Code with YAML

Module 18: Explore Release Recommendations

• Introduction
• Understand the Delivery Cadence and Three Types of Triggers
• Explore Release Approvals
• Explore Release Gates
• Use Release Gates to Protect Quality
• Explore GitOps Release Strategy and Recommendations
• Control Deployments Using Release Gates

Module 19: Provision and Test Environments

• Introduction
• Provision and Configure Target Environments
• Exercise: Set Up Service Connections
• Configure Automated Integration and Functional Test Automation
• Understand Shift-left
• Set Up and Run Availability Tests
• Explore Azure Load Testing
• Set Up and Run Functional Tests

Module 20: Manage and Modularize Tasks and Templates

• Introduction
• Examine Task Groups
• Explore Variables in Release Pipelines
• Exercise: Create and Manage Variable Groups

Module 21: Automate Inspection of Health

• Introduction
• Automate Inspection of Health
• Explore Events and Notifications
• Explore Service Hooks
• Configure Azure DevOps Notifications
• Configure GitHub Notifications
• Explore How to Measure Quality of Your Release Process
• Examine Release Notes and Documentation
• Examine Considerations for Choosing Release Management Tools
• Explore Common Release Management Tools

Module 22: Introduction to Deployment Patterns

• Introduction
• Explore Microservices Architecture
• Examine Classical Deployment Patterns
• Understand Modern Deployment Patterns

Module 23: Implement Blue-Green Deployment and Feature Toggles

• Introduction
• What is Blue-Green Deployment?
• Explore Deployment Slots
• Introduction to Feature Toggles
• Describe Feature Toggle Maintenance

Module 24: Implement Canary Releases and Dark Launching

• Introduction
• Explore Canary Releases
• Examine Traffic Manager
• Understand Dark Launching

Module 25: Implement A/B Testing and Progressive Exposure Deployment

• Introduction
• What is A/B Testing?
• Explore CI-CD with Deployment Rings

Module 26: Integrate with Identity Management Systems

• Introduction
• Integrate GitHub with Single Sign-On (SSO)
• Design and Implement Permissions and Roles in GitHub
• Design and Implement Permissions and Security Groups in Azure DevOps
• Explore Workload Identities
• Implement Managed Identities

Module 27: Manage Application Configuration Data

• Introduction
• Rethink Application Configuration Data
• Explore Separation of Concerns
• Understand External Configuration Store Patterns
• Implement Azure DevOps Secure Files
• Introduction to Azure App Configuration
• Examine Key-Value Pairs
• Examine App Configuration Feature Management
• Integrate Azure Key Vault with Azure Pipelines
• Manage Secrets, Tokens and Certificates
• Examine DevOps Inner and Outer Loop
• Integrate Azure Key Vault with Azure DevOps
• Enable Dynamic Configuration and Feature Flags

Module 28: Explore Infrastructure as Code and Configuration Management

• Introduction
• Explore Environment Deployment
• Examine Environment Configuration
• Understand Imperative Versus Declarative Configuration
• Understand Idempotent Configuration

Module 29: Create Azure Resources Using Azure Resource Manager Templates

• Introduction
• Why Use Azure Resource Manager Templates?
• Explore Template Components
• Manage Dependencies
• Modularise Templates
• Manage Secrets in Templates

Module 30: Create Azure Resources by Using Azure CLI

• Introduction
• What is Azure CLI?
• Work with Azure CLI

Module 31: Explore Azure Automation with DevOps

• Introduction
• Create Automation Accounts
• What is a Runbook?
• Understand Automation Shared Resources
• Explore Runbook Gallery
• Examine Webhooks
• Explore Source Control Integration
• Explore PowerShell Workflows
• Create a Workflow
• Explore Hybrid Management
• Examine Checkpoint and Parallel Processing

Module 32: Implement Desired State Configuration (DSC)

• Introduction
• Understand Configuration Drift
• Explore Desired State Configuration (DSC)
• Explore Azure Automation State Configuration (DSC)
• Examine DSC Configuration File
• Implement DSC and Linux Automation on Azure

Module 33: Implement Bicep

• Introduction
• What is Bicep?
• Install Bicep
• Exercise: Create Bicep Templates
• Understand Bicep File Structure and Syntax
• Exercise: Deploy a Bicep File from Azure Pipelines
• Exercise: Deploy a Bicep File from GitHub Workflows
• Deployments Using Azure Bicep Templates

Module 34: Explore Package Dependencies

• Introduction
• What is Dependency Management?
• Describe Elements of a Dependency Management Strategy
• Identify Dependencies
• Understand Source and Package Componentization
• Decompose Your System
• Scan Your Codebase for Dependencies

Module 35: Understand Package Management

• Introduction
• Explore Packages
• Understand Package Feeds
• Explore Package Feed Managers
• Explore Common Public Package Sources
• Explore Self-hosted and SaaS-based Package Sources
• Consume Packages
• Introduction to Azure Artifacts
• Publish Packages
• Package Management with Azure Artifacts

Module 36: Migrate, Consolidate and Secure Artifacts

• Introduction
• Identify Existing Artifact Repositories
• Migrate and Integrate Artifact Repositories
• Secure Access to Package Feeds
• Examine Roles
• Examine Permissions
• Examine Authentication

Module 37: Implement a Versioning Strategy

• Introduction
• Understand Versioning of Artifacts
• Explore Semantic Versioning
• Examine Release Views
• Promote Packages
• Explore Best Practices for Versioning

Module 38: Introduction to GitHub Packages

• Introduction
• Publish Packages
• Install a Package
• Delete and Restore a Package
• Explore Package Access Control and Visibility

Module 39: Implement Tools to Track Usage and Flow

• Introduction
• Understand the Inner Loop
• Introduction to Continuous Monitoring
• Explore Azure Monitor and Log Analytics
• Examine Kusto Query Language (KQL)
• Implement Application Insights
• Design and Implement Metrics and Queries
• Monitor Application Performance with Application Insights

Module 40: Develop Monitor and Status Dashboards

• Introduction
• Configure Monitoring in GitHub
• Explore Azure Dashboards
• Explore Azure Monitor Workbooks
• Explore Power BI
• Build Your Own Custom Application
• Monitor Pipeline Health, Including Failure Rate, Duration, and Flaky Tests
• Optimise a Pipeline for Cost, Time, Performance, and Reliability
• Optimise Pipeline Concurrency for Performance and Cost

Module 41: Share Knowledge Within Teams

• Introduction
• Share Acquired Knowledge within Development Teams
• Introduction to Azure DevOps Project Wikis
• Integrate GitHub and Azure DevOps with Microsoft Teams
• Share Team Knowledge Using Azure Project Wiki

Module 42: Design Processes to Automate Application Analytics

• Introduction
• Explore Rapid Responses and Augmented Search
• Integrate Telemetry
• Examine Monitoring Tools and Technologies
• Explore IT Service Management Connector

Module 43: Manage Alerts, Blameless Retrospectives and a Just Culture

• Introduction
• Examine When to Get a Notification
• Explore How to Fix It
• Explore Smart Detection Notifications
• Improve Performance
• Understand Server Response Time Degradation
• Reduce Meaningless and Non-actionable Alerts
• Examine Blameless Retrospective
• Develop a Just Culture

Module 44: Introduction to Secure DevOps

• Introduction
• Describe SQL Injection Attack
• Understand DevSecOps
• Explore Secure DevOps Pipeline
• Explore Key Validation Points
• Explore Continuous Security Validation
• Understand Threat Modeling
• Explore CodeQL in GitHub

Module 45: Implement Open-Source Software

• Introduction
• Explore How Software is Built
• What is Open-source Software?
• Explore Corporate Concerns with Open-source Software Components
• Introduction to Open-source Licenses
• Explore Common Open-source Licenses
• Examine License Implications and Ratings

Module 46: Software Composition Analysis

• Introduction
• Inspect and Validate Code Bases for Compliance
• Explore Software Composition Analysis (SCA)
• Implement GitHub Dependabot Alerts and Security Updates
• Integrate Software Composition Analysis Checks into Pipelines
• Examine Tools for Assess Package Security and License Rate
• Automate Container Scanning, Including Container Images
• Interpret Alerts from Scanner Tools

Module 47: Security Monitoring and Governance

• Introduction
• Implement Pipeline Security
• Explore Microsoft Defender for Cloud
• Examine Microsoft Defender for Cloud Usage Scenarios
• Explore Azure Policy
• Understand Policies
• Explore Initiatives
• Explore Resource Locks
• Understand Microsoft Defender for Identity
• Integrate GitHub Advanced Security with Microsoft Defender for Cloud
• Configure GitHub Advanced Security for GitHub and Azure DevOps

Microsoft Azure AI Fundamentals AI-900 Course Outline

Module 1: Fundamental AI Concepts

• Introduction to AI
• Understand Machine Learning
• Understand Computer Vision
• Understand Natural Language Processing
• Understand Document Intelligence and Knowledge Mining
• Understand Generative AI
• Challenges and Risks with AI
• Understand Responsible AI

Module 2: Fundamentals of Machine Learning

• Introduction
• What is Machine Learning?
• Types of Machine Learning
• Regression
• Binary Classification
• Multiclass Classification
• Clustering
• Deep Learning
• Azure Machine Learning
• Exercise - Explore Automated Machine Learning in Azure Machine Learning

Module 3: Fundamentals of Azure AI Services

• Introduction
• AI Services on the Azure Platform
• Create Azure AI Service Resources
• Use Azure AI Services
• Understand Authentication for Azure AI Services
• Exercise - Explore Azure AI Services

Module 4: Fundamentals of Computer Vision

• Introduction
• Images and Image Processing
• Machine Learning for Computer Vision
• Azure AI Vision
• Exercise - Analyse Images in Vision Studio

Module 5: Fundamentals of Facial Recognition

• Introduction
• Understand Facial Analysis
• Get Started with Facial Analysis on Azure
• Exercise - Detect Faces in Vision Studio

Module 6: Fundamentals of Optical Character Recognition

• Introduction
• Get Started with Azure AI Vision
• Get Started with Vision Studio on Azure
• Exercise - Read Text in Vision Studio

Module 7: Fundamentals of Text Analysis with the Language Service

• Introduction
• Understand Text Analytics
• Get Started with Text Analysis
• Exercise - Analyse Text with Language Studio

Module 8: Fundamentals of Question Answering with the Language Service

• Introduction
• Understand Question Answering
• Get Started with Custom Question Answering
• Exercise - Use Question Answering with Language Studio

Module 9: Fundamentals of Conversational Language Understanding

• Introduction
• Describe Conversational Language Understanding
• Get Started with Conversational Language Understanding in Azure
• Exercise - Use Conversational Language Understanding with Language Studio

Module 10: Fundamentals of Azure AI Speech

• Introduction
• Understand Speech Recognition and Synthesis
• Get Started with Speech on Azure
• Use Azure AI Speech
• Exercise - Explore Speech Studio

Module 11: Fundamentals of Language Translation

• Introduction
• Understand Translation Concepts
• Understand Translation in Azure
• Get Started with Translation in Azure
• Exercise - Explore Azure AI Translator

Module 12: Fundamentals of Azure AI Document Intelligence

• Introduction
• Explore Capabilities of Document Intelligence
• Understand Azure AI Document Intelligence Capabilities
• Exercise - Extract Form Data in Document Intelligence Studio

Module 13: Fundamentals of Knowledge Mining and Azure AI Search

• Introduction
• What is Azure AI Search?
• Identify Elements of a Search Solution
• Create an Index in the Azure Portal
• Query Data in an Azure AI Search Index
• Exercise - Explore an Azure AI Search Index (UI)

Module 14: Fundamentals of Generative AI

• Introduction
• What is Generative AI?
• What Are Language Models?
• Using Language Models
• Copilot and AI Agents
• Understand Microsoft Copilot
• Considerations for Prompts
• Extending and Developing Copilot-Like Agents
• Exercise - Explore Microsoft Copilot

Module 15: Introduction to Azure AI Foundry

• Introduction
• What is Azure AI Foundry?
• How Does Azure AI Foundry Work
• When to Use Azure AI Foundry
• Exercise - Explore the Azure AI Foundry Portal

Module 16: Responsible Generative AI

• Introduction
• Plan a Responsible Generative AI Solution
• Identify Potential Harms
• Measure Potential Harms
• Mitigate Potential Harms
• Operate a Responsible Generative AI Solution
• Exercise - Explore Content Filters in Azure AI Studio

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

Module 1: Explore Azure Machine Learning Workspace Resources and Assets

• Introduction
• Create a Workspace
• Identify Resources
• Identify Assets
• Train Models
• Explore Workspace

Module 2: Explore Developer Tools for Workspace Interaction

• Introduction
• Explore the Studio
• Explore Python SDK
• Explore the CLI
• Explore Developer Tools

Module 3: Make Data Available in Azure Machine Learning

• Introduction
• Understand URIs
• Create a Datastore
• Create a Data Asset
• Make Data Available

Module 4: Work with Compute Targets in Azure Machine Learning

• Introduction
• Choose a Compute Target
• Use a Compute Instance
• Use a Compute Cluster
• Work with Compute Resources

Module 5: Work with Environments in Azure Machine Learning

• Introduction
• Understand Environments
• Use Curated Environments
• Create Custom Environments
• Work with Environments

Module 6: Find the Best Classification Model with Automated Machine Learning

• Introduction
• Preprocess Data
• Run an Experiment
• Evaluate Models
• Find the Best Model

Module 7: Track Model Training in Jupyter Notebooks with MLflow

• Introduction
• Configure MLflow
• Track Models in Notebooks
• Track Model Training

Module 8: Run a Training Script as a Command Job in Azure Machine Learning

• Introduction
• Convert to Script
• Run a Command Job
• Use Parameters
• Run a Training Script

Module 9: Track Model Training with MLflow in Jobs

• Introduction
• Track Metrics
• View Metrics
• Use MLflow to Track Training Jobs

Module 10: Perform Hyperparameter Tuning with Azure Machine Learning

• Introduction
• Define a Search Space
• Configure Sampling
• Configure Termination
• Run a Sweep Job

Module 11: Run Pipelines in Azure Machine Learning

• Introduction
• Create Components
• Create a Pipeline
• Run a Pipeline Job

Module 12: Register an MLflow Model in Azure Machine Learning

• Introduction
• Log Models
• Understand Model Format
• Register a Model
• Log and Register Models

Module 13: Create and Explore the Responsible AI Dashboard for a Model in Azure Machine Learning

• Introduction
• Understand Responsible AI
• Create the Dashboard
• Evaluate the Dashboard
• Explore the Dashboard

Module 14: Deploy a Model to a Managed Online Endpoint

• Introduction
• Explore Online Endpoints
• Deploy to Online Endpoint
• Test Online Endpoints
• Deploy an Online Model

Module 15: Deploy a Model to a Batch Endpoint

• Introduction
• Understand Batch Endpoints
• Deploy to Batch Endpoint
• Invoke Batch Endpoints
• Deploy a Batch Model

Module 16: Plan and Prepare to Develop AI Solutions on Azure

• Introduction
• What is AI?
• Azure AI Services
• Azure AI Foundry
• Developer Tools and SDKs
• Responsible AI
• Explore AI Foundry Portal

Module 17: Choose and Deploy Models from the Model Catalog in Azure AI Foundry Portal

• Introduction
• Explore Language Models
• Deploy a Model
• Improve Performance
• Explore and Deploy Models

Module 18: Develop an AI App with the Azure AI Foundry SDK

• Introduction
• What is Azure AI Foundry SDK?
• Work with Connections
• Create a Chat Client
• Create an AI Chat App

Module 19: Get Started with Prompt Flow to Develop Language Model Apps in the Azure AI Foundry

• Introduction
• Understand LLM App Lifecycle
• Explore Core Components
• Explore Connections
• Explore Variants and Monitoring Options
• Get Started with Prompt Flow

Module 20: Build a RAG-Based Agent with Your Own Data Using Azure AI Foundry

• Introduction
• Ground Your Language Model
• Make Your Data Searchable
• Build an Agent with Prompt Flow
• Create a Custom Agent

Module 21: Fine-Tune a Language Model with Azure AI Foundry

• Introduction
• When to Fine-Tune
• Prepare Your Data
• Explore Fine-Tuning
• Fine-Tune a Model

Module 22: Evaluate the Performance of Generative AI Apps with Azure AI Foundry

• Introduction
• Assess Model Performance
• Manually Evaluate
• Assess App Performance
• Evaluate Your AI App

Module 23: Responsible Generative AI

• Introduction
• Plan a Solution
• Identify Harms
• Measure Harms
• Mitigate Harms
• Operate a Solution
• Explore Content Filters

Microsoft Azure Data Fundamentals DP-900 Course Outline

Module 1: Explore Core Data Concepts

• Introduction
• Identify Data Formats
• Explore File Storage
• Explore Databases
• Explore Transactional Data Processing
• Explore Analytical Data Processing

Module 2: Explore Data Roles and Services

• Introduction
• Explore Job Roles in the World of Data
• Identify Data Services

Module 3: Explore Fundamental Relational Data Concepts

• Introduction
• Understand Relational Data
• Understand Normalisation
• Explore SQL
• Describe Database Objects

Module 4: Explore Relational Database Services in Azure

• Introduction
• Describe Azure SQL Services and Capabilities
• Describe Azure Services for Open-Source Databases
• Exercise: Explore Azure Relational Database Services

Module 5: Explore Azure Storage for Non-Relational Data

• Introduction
• Explore Azure Blob Storage
• Explore Azure DataLake Storage Gen2
• Explore Azure Files
• Explore Azure Tables
• Exercise: Explore Azure Storage

Module 6: Explore Fundamentals of Azure Cosmos DB

• Introduction
• Describe Azure Cosmos DB
• Identify Azure Cosmos DB APIs
• Exercise: Explore Azure Cosmos DB

Module 7: Explore Fundamentals of Large-Scale Data Warehousing

• Introduction
• Describe Data Warehousing Architecture
• Explore Data Ingestion Pipelines
• Explore Analytical Data Stores
• Exercise: Explore Data Analytics in Azure with Azure Synapse Analytics

Module 8: Explore Fundamentals of Real-Time Analytics

• Introduction
• Understand Batch and Stream Processing
• Explore Common Elements of Stream Processing Architecture
• Explore Azure Stream Analytics
• Exercise: Explore Azure Stream Analytics
• Explore Apache Spark on Microsoft Azure
• Exercise: Explore Spark Streaming in Azure Synapse Analytics

Module 9: Explore Fundamentals of Data Visualisation

• Introduction
• Understand Batch and Stream Processing
• Explore Common Elements of Stream Processing Architecture
• Explore Azure Stream Analytics
• Exercise: Explore Azure Stream Analytics
• Explore Apache Spark on Microsoft Azure
• Exercise: Explore Spark Streaming in Azure Synapse Analytics

Configuring and Operating Microsoft Azure Virtual Desktop AZ-140​ Course Outline

Module 1: Azure Virtual Desktop Architecture

• Introduction
• Azure Virtual Desktop for Enterprise
• Azure Virtual Desktop Components
• Personal and Pooled Desktops
• Service Updates for Azure Virtual Desktop Desktops
• Azure Limitations for Azure Virtual Desktop
• Virtual Machine Sizing for Azure Virtual Desktop
• Azure Virtual Desktop Pricing

Module 2: Design the Azure Virtual Desktop Architecture

• Introduction
• Assess Network Capacity and Speed Requirements
• Azure Virtual Desktop Experience Estimator
• Recommend an Operating System
• Balancing Host Pools
• Recommendations for Subscriptions and Management Groups
• Configure Azure Virtual Desktop Metadata Location
• Recommend Configuration for Performance Requirements

Module 3: Design for User Identities and Profiles

• Introduction
• Select Appropriate Licensing Model
• Personal and Multi-session Desktop Scenarios
• Recommend Storage Solution
• Plan Desktop Client Deployment
• Plan RDP Client Deployment
• Windows Desktop Client to Multiple Devices
• Hybrid Identity with Microsoft Entra ID
• Plan Microsoft Entra Connect

Module 4: Implement and Manage Networking for Azure Virtual Desktop

• Introduction
• Plan Implement RDP Shortpath
• Analyse Connection Quality
• RDP Bandwidth Requirements
• RDP Shortpath Scenarios
• Manage Connectivity to Internet and Premises Networks
• Plan and Implement Azure Private Link
• Create RDP Connection to Windows VM
• Monitor and Troubleshoot Network Watcher

Module 5: Implement and Manage Storage for Azure Virtual Desktop

• Introduction
• Plan Storage for User Data
• Azure Storage Management
• Azure Files Tiers
• Azure NetApp Files Tiers
• Implement Storage Accounts

Module 6: Create and Configure Host Pools and Session Hosts

• Introduction
• Prerequisites for Azure Virtual Desktop
• Operating Systems and Azure Regions
• Network and RDP Client Planning
• Create a Host Pool
• Create Host Pool via Azure Portal
• Add Session Hosts to Host Pool
• Customise RDP Properties

Module 7: Create and Manage Session Host Image

• Introduction
• Create Golden Image in Azure
• Using Azure VM Image Builder
• Create Azure Virtual Desktop Image with PowerShell
• Plan Image Update and Management
• Manage Licensing for Session Hosts
• Install Language Packs

Module 8: Manage Access for Azure Virtual Desktop

• Introduction
• Select Identity Strategy
• Select Authentication Strategy
• Role-based Access Control (RBAC)
• Implement Azure Roles and RBAC
• Assign RBAC Roles to Service Principals
• Enforce Entra MFA with Conditional Access
• Use Azure Virtual Desktop with Intune

Module 9: Manage Security for Azure Virtual Desktop

• Introduction
• Security Recommendations
• Connect Subscriptions to Microsoft Defender
• Microsoft Defender for Endpoint
• Apply Zero Trust Principles
• Implement Conditional Access Policies
• Security Posture and Threat Protection

Module 10: Implement and Manage FSLogix

• Introduction
• Overview of FSLogix
• Understand FSLogix Containers
• Configure FSLogix Profile Containers
• Configure FSLogix Office Containers
• Configure Profile Containers with Cloud Cache
• Using FSLogix Apps Rule Editor
• Create and Implement Rule Sets
• Implement Azure NetApp Files

Module 11: Configure User Experience Settings

• Introduction
• Connect to Azure Virtual Desktop
• Configure Session Timeout Properties
• Implement Start VM on Connect
• Configure Universal Print
• Configure Device Redirections
• Troubleshoot Azure Virtual Desktop Clients

Module 12: Install and Configure Apps on a Session Host

• Introduction
• Create and Configure Application Group
• Assign Users to Application Groups
• Publish RemoteApp
• Implement OneDrive in Multisession Environments
• Implement Microsoft Teams for RDP
• Implement Microsoft 365 Apps
• Configure Dynamic App Delivery with App Attach
• Create Application Package for App Attach

Module 13: Monitor and Manage Performance and Health

• Introduction
• Configure Log Collection and Analysis
• Monitor with Azure Monitor
• Customise Azure Monitor Workbooks
• Monitor with Azure Advisor
• Implement Scaling Plans
• Optimise Capacity and Performance

Module 14: Plan and Implement Updates, Backups, and Disaster Recovery

• Introduction
• Disaster Recovery for Azure Virtual Desktop
• Design and Implement Backup Strategy
• Monitor Costs with Azure Cost Management

Designing and implementing a Microsoft Azure AI Solution AI-102 Course Outline

Module 1: Introduction to AI on Azure

Artificial Intelligence (AI) is increasingly at the core of modern apps and services. In this module, you'll learn about some common AI capabilities that you can leverage in your apps, and how those capabilities are implemented in Microsoft Azure. You'll also learn about some considerations for designing and implementing AI solutions responsibly.

Lessons

• Introduction to Artificial Intelligence
• Artificial Intelligence in Azure

After completing this module, students will be able to:

• Describe considerations for creating AI-enabled applications
• Identify Azure services for AI application development

Module 2: Developing AI Apps with Cognitive Services

Cognitive Services are the core building blocks for integrating AI capabilities into your apps. In this module, you'll learn how to provision, secure, monitor, and deploy cognitive services.

Lessons

• Getting Started with Cognitive Services
• Using Cognitive Services for Enterprise Applications

Lab: Get Started with Cognitive Services
Lab: Manage Cognitive Services Security
Lab: Monitor Cognitive Services
Lab: Use a Cognitive Services Container

After completing this module, students will be able to:

• Provision and consume cognitive services in Azure
• Manage cognitive services security
• Monitor cognitive services
• Use a cognitive services container

Module 3: Getting Started with Natural Language Processing

Natural Language processing (NLP) is a branch of artificial intelligence that deals with extracting insights from written or spoken language. In this module, you'll learn how to use cognitive services to analyze and translate text.

Lessons

• Analyzing Text
• Translating Text

Lab: Translate Text

Lab: Analyze Text

After completing this module, students will be able to:

• Use the Text Analytics cognitive service to analyze text
• Use the Translator cognitive service to translate text

Module 4: Building Speech-Enabled Applications

Many modern apps and services accept spoken input and can respond by synthesizing text. In this module, you'll continue your exploration of natural language processing capabilities by learning how to build speech-enabled applications.

Lessons

• Speech Recognition and Synthesis
• Speech Translation

Lab: Recognize and Synthesize Speech
Lab: Translate Speech

After completing this module, students will be able to:

• Use the Speech cognitive service to recognize and synthesize speech
• Use the Speech cognitive service to translate speech

Module 5: Creating Language Understanding Solutions

To build an application that can intelligently understand and respond to natural language input, you must define and train a model for language understanding. In this module, you'll learn how to use the Language Understanding service to create an app that can identify user intent from natural language input.

Lessons

• Creating a Language Understanding App
• Publishing and Using a Language Understanding App
• Using Language Understanding with Speech

Lab: Create a Language Understanding Client Application
Lab: Create a Language Understanding App
Lab: Use the Speech and Language Understanding Services

After completing this module, students will be able to:

• Create a Language Understanding app
• Create a client application for Language Understanding
• Integrate Language Understanding and Speech

Module 6: Building a QnA Solution

One of the most common kinds of interaction between users and AI software agents is for users to submit questions in natural language, and for the AI agent to respond intelligently with an appropriate answer. In this module, you'll explore how the QnA Maker service enables the development of this kind of solution.

Lessons

• Creating a QnA Knowledge Base
• Publishing and Using a QnA Knowledge Base

Lab: Create a QnA Solution

After completing this module, students will be able to:

• Use QnA Maker to create a knowledge base
• Use a QnA knowledge base in an app or bot

Module 7: Conversational AI and the Azure Bot Service

Bots are the basis for an increasingly common kind of AI application in which users engage in conversations with AI agents, often as they would with a human agent. In this module, you'll explore the Microsoft Bot Framework and the Azure Bot Service, which together provide a platform for creating and delivering conversational experiences.

Lessons

• Bot Basics
• Implementing a Conversational Bot

Lab: Create a Bot with the Bot Framework SDK
Lab: Create a Bot with Bot Framework Composer

After completing this module, students will be able to:

• Use the Bot Framework SDK to create a bot
• Use the Bot Framework Composer to create a bot

Module 8: Getting Started with Computer Vision

Computer vision is an area of artificial intelligence in which software applications interpret visual input from images or video. In this module, you'll start your exploration of computer vision by learning how to use cognitive services to analyze images and video.

Lessons

• Analyzing Images
• Analyzing Videos

Lab: Analyze Video
Lab: Analyze Images with Computer Vision

After completing this module, students will be able to:

• Use the Computer Vision service to analyze images
• Use Video Analyzer to analyze videos

Module 9: Developing Custom Vision Solutions

While there are many scenarios where pre-defined general computer vision capabilities can be useful, sometimes you need to train a custom model with your own visual data. In this module, you'll explore the Custom Vision service, and how to use it to create custom image classification and object detection models.

Lessons

• Image Classification
• Object Detection

Lab: Classify Images with Custom Vision
Lab: Detect Objects in Images with Custom Vision

After completing this module, students will be able to:

• Use the Custom Vision service to implement image classification
• Use the Custom Vision service to implement object detection

Module 10: Detecting, Analyzing, and Recognizing Faces

Facial detection, analysis, and recognition are common computer vision scenarios. In this module, you'll explore the user of cognitive services to identify human faces.

Lessons

• Detecting Faces with the Computer Vision Service
• Using the Face Service

Lab: Detect, Analyze, and Recognize Faces

After completing this module, students will be able to:

• Detect faces with the Computer Vision service
• Detect, analyze, and recognize faces with the Face service

Module 11: Reading Text in Images and Documents

Optical character recognition (OCR) is another common computer vision scenario, in which software extracts text from images or documents. In this module, you'll explore cognitive services that can be used to detect and read text in images, documents, and forms.

Lessons

• Reading text with the Computer Vision Service
• Extracting Information from Forms with the Form Recognizer service

Lab: Read Text in Images
Lab: Extract Data from Forms

After completing this module, students will be able to:

• Use the Computer Vision service to read text in images and documents
• Use the Form Recognizer service to extract data from digital forms

Module 12: Creating a Knowledge Mining Solution

Many AI scenarios involve intelligently searching for information based on user queries. AI-powered knowledge mining is an increasingly important way to build intelligent search solutions that use AI to extract insights from large repositories of digital data and enable users to find and analyze those insights.

Lessons

• Implementing an Intelligent Search Solution
• Developing Custom Skills for an Enrichment Pipeline
• Creating a Knowledge Store

Lab: Create a Custom Skill for Azure Cognitive Search
Lab: Create an Azure Cognitive Search solution
Lab: Create a Knowledge Store with Azure Cognitive Search

After completing this module, students will be able to:

• Create an intelligent search solution with Azure Cognitive Search
• Implement a custom skill in an Azure Cognitive Search enrichment pipeline
• Use Azure Cognitive Search to create a knowledge store

Administering Microsoft Azure SQL Solutions DP300 Course Outline

Module 1: Prepare to Maintain SQL Databases on Azure

• Introduction
• Describe Microsoft Intelligent Data Platform Roles
• Understand SQL Server in an Azure Virtual Machine
• Design Azure SQL Database for Cloud-Native Applications
• Explore Azure SQL Managed Instance

Module 2: Deploy IaaS Solutions with Azure SQL

• Introduction
• Explain IaaS Options to Deploy SQL Server in Azure
• Understand Hybrid Scenarios
• Explore Performance and Security
• Explain High Availability and Disaster Recovery Options
• Exercise: Provision a SQL Server on an Azure Virtual Machine

Module 3: Deploy PaaS Solutions with Azure SQL

• Introduction
• Explain PaaS Options for Deploying SQL Server in Azure
• Explore Single SQL Database
• Deploy SQL Database Elastic Pool
• Understand SQL Database Hyperscale
• Examine SQL Managed Instance
• Exercise: Deploy an Azure SQL Database

Module 4: Migrate SQL Server Workloads to Azure SQL Database

• Introduction
• Choose the Right Azure SQL Database Feature
• Use Azure SQL Migration Extension to Migrate to Azure SQL Database
• Explore Data Migration Assistant to Migrate to Azure SQL Database
• Migrate to Azure SQL Database using BACPAC
• Use an Online Method to Migrate to Azure SQL Database
• Move Data to Azure SQL Database
• Exercise: Migrate a SQL Server Database to Azure SQL Database

Module 5: Migrate SQL Server Workloads to Azure SQL Managed Instance

• Introduction
• Evaluate Migration Scenarios
• Use Log Replay Service (LRS) to Migrate
• Migrate Using Managed Instance Link
• Move Data to SQL Managed Instance
• Exercise: Migrate a SQL Server Database to Azure SQL Managed Instance

Module 6: Configure Database Authentication and Authorisation

• Introduction
• Describe Authentication and Identities
• Describe Security Principals
• Describe Database and Object Permissions
• Identify Authentication and Authorisation Failures
• Exercise: Authorise Access to Azure SQL Database with Microsoft Entra ID

Module 7: Protect Data in-Transit and at Rest

• Introduction
• Explore Transparent Data Encryption
• Configure Server and Database Firewall Rules
• Explain Object Encryption and Secure Enclaves
• Enable Encrypted Connections
• Describe SQL Injection
• Understand Azure Key Vault
• Exercise: Configure a Server-Based Firewall Rule using the Azure Portal

Module 8: Implement Compliance Controls for Sensitive Data

• Introduction
• Explore Data Classification
• Explore Server and Database Audit
• Implement Dynamic Data Masking
• Implement Row-Level Security
• Understand Microsoft Defender for SQL
• Explore Ledger
• Implement Azure Purview
• Exercise: Enable Microsoft Defender for SQL and Data Classification

Module 9: Describe Performance Monitoring

• Introduction
• Describe Performance Monitoring Tools
• Describe Critical Performance Metrics
• Establish Baseline Metrics
• Explore Extended Events
• Describe Database Watcher (Preview)
• Explore Query Performance Insight
• Exercise: Isolate Problems with Monitoring

Module 10: Configure SQL Server Resources for Optimal Performance

• Introduction
• Explain How to Optimise Azure Storage for SQL Server Virtual Machines
• Describe Virtual Machine Resizing
• Optimise Database Storage
• Control SQL Server Resources

Module 11: Configure Databases for Optimal Performance

• Introduction
• Explore Database Maintenance Checks
• Describe Database Scoped Configuration Options
• Describe Automatic Tuning
• Describe Intelligent Query Processing
• Exercise: Detect and Correct Fragmentation Issues

Module 12: Explore Query Performance Optimisation

• Introduction
• Understand Query Plans
• Explain Estimated and Actual Query Plans
• Describe Dynamic Management Views and Functions
• Explore Query Store
• Identify Problematic Query Plans
• Describe Blocking and Locking
• Exercise: Identify and Resolve Blocking Issues

Module 13: Explore Performance-Based Design

• Introduction
• Describe Normalisation
• Choose Appropriate Data Types
• Design Indexes
• Exercise: Identify Database Design Issues

Module 14: Evaluate Performance Improvements

• Introduction
• Describe Wait Statistics
• Tune and Maintain Indexes
• Understand Query Hints
• Exercise: Isolate Problem Areas in Poorly Performing Queries

Module 15: Automate Database Deployment

• Introduction
• Describe Deployment Models in Azure
• Automate Deployment by Using Azure Resource Manager Templates and Bicep
• Automate Deployment by Using PowerShell
• Automate Deployment by Using Azure CLI
• Exercise: Deploy an Azure SQL Database using an Azure Resource Manager Template

Module 16: Create and Manage SQL Agent Jobs

• Introduction
• Create a SQL Server Maintenance Plan
• Describe Task Status Notifications
• Exercise: Create a CPU Status Alert for a SQL Server

Module 17: Manage Azure PaaS Tasks Using Automation

• Introduction
• Explore Elastic Jobs
• Understand Azure Automation
• Build an Automation Runbook
• Automate Database Workflows by Using Logic Apps
• Monitor Automated Tasks
• Exercise: Deploy an Automation Runbook to Automatically Rebuild Indexes

Module 18: Describe High Availability and Disaster Recovery Strategies

• Introduction
• Describe Recovery Time Objective and Recovery Point Objective
• Explore High Availability and Disaster Recovery Options
• Describe Azure High Availability and Disaster Recovery Features for Azure Virtual Machines
• Describe High Availability and Disaster Recovery for PaaS Deployments
• Explore High Availability and Disaster Recovery Solution for IaaS
• Describe Hybrid Solutions

Module 19: Explore IaaS and PaaS Solutions for High Availability and Disaster Recovery

• Introduction
• Describe Failover Clusters in Windows Server
• Configure Always-On Availability Groups
• Describe Active Geo-Replication for Azure SQL Database
• Explore Auto-Failover Groups for Azure SQL Database and Azure SQL Managed Instance
• Monitor Availability
• Exercise: Configure Geo Replication for Azure SQL Database

Module 20: Back Up and Restore Databases

• Introduction
• Back Up and Restore SQL Server Running on Azure Virtual Machines
• Back Up a SQL Server Virtual Machine
• Back Up and Restore a Database for SQL Database and SQL Managed Instance
• Exercise: Backup to URL

Planning and Administering Microsoft Azure for SAP Workloads AZ120 Course Outline 

Module 1: Explore Azure for SAP Workloads

• Introduction
• SAP and Microsoft Partnership
• SAP on Azure Options
• Microsoft Components Evaluation

Module 2: Discover Common Terms and Meanings for SAP on Azure

• Introduction
• SAP Terminology
• SAP Deployments on Azure
• Azure Terminology

Module 3: Identify SAP-Certified Configurations

• Introduction
• SAP Prerequisites in Public Cloud
• SAP Deployment Options on Azure
• Supported Azure VMs for SAP on Windows/Linux
• Supported Azure VMs for SAP NetWeaver
• SAP-Certified Operating Systems for Azure VMs
• SAP Certifications and Configurations on Azure

Module 4: Examine SAP NetWeaver with AnyDB on Azure Virtual Machines

• Introduction
• SAP NetWeaver on Azure VMs
• Architectural Components
• Sample Functional Workflow

Module 5: Examine SAP S/4HANA on Azure Virtual Machines

• Introduction
• SAP S/4HANA on Azure VMs
• Architectural Components
• Sample Functional Workflow

Module 6: Explore Azure for SAP Compute

• Introduction
• SAP Solution Implementation Planning
• Azure VMs Exploration
• Constrained vCPU VMs
• Scale Azure VMs
• VM Scaling Considerations
• Network Bandwidth Allocation
• Data Flows
• VM Compute Considerations
• SAP HANA High Availability on VMs

Module 7: Explore Azure for SAP Networking

• Introduction
• Azure Virtual Networks
• IP Addressing
• Name Resolution
• Accelerated Networking
• Azure Load Balancer
• VM Networking Considerations
• Load Balancing Considerations
• Azure Traffic Manager
• Azure Front Door
• Azure Firewall
• Networking Changes for VMs
• Routing Configurations
• Virtual Network Connectivity
• DDoS Protection
• Virtual Datacenter
• Cross-Premises Connectivity
• SAP router
• Networking Support for SAP on Azure

Module 8: Explore Azure for SAP Storage

• Introduction
• Azure Storage Types
• Azure Files
• Azure VM Disks
• VM Images and Disks
• Managed/Unmanaged Disks
• VM and Data Disk Caching
• Write Accelerator
• Database Sizing
• VM Storage Considerations
• SAP HANA Dynamic Tiering
• VM Disks Best Practices
• VM NFS Storage
• VM SMB Storage
• SAP HANA VM Storage Configurations
• Premium Storage for M-Series VMs
• Ultra Disk Storage for SAP HANA
• NFS v4.1 on Azure NetApp Files
• SAP HANA Database Sizing on NetApp Files

Module 9: Explore Azure for SAP Databases

• Introduction
• Azure Database Support for SAP
• SQL Server
• Database Compression
• Blob Storage for Database Files
• Azure VM Security
• Blob Storage Security
• SQL Server Transparent Data Encryption
• SQL Server Buffer Pool Extension
• Oracle Recommendations
• Lab - Implement Linux Clustering for SAP on Azure Virtual Machines
• Lab - Implement Windows Clustering for SAP on Azure Virtual Machines

Module 10: Explore Azure Networking for SAP RISE

• Introduction
• Azure Integration with SAP RISE
• Azure Virtual Network Peering
• Azure VPN Connection to SAP RISE
• Connect On-premises to SAP RISE
• Connect SAP RISE with Internet

Module 11: Explore Identity Services for SAP on Azure

• Introduction
• VM Authentication and Access Control
• Microsoft Entra ID
• SAP Cloud Platform Identity Authentication
• Integrate Entra ID with SAP Cloud
• Integrate Entra ID with SAP Fiori
• Integrate Entra ID with SAP HANA
• Integrate Entra ID with SAP NetWeaver
• Active Directory Integration with SAP SSO
• Active Directory Domain Services
• Explore Primary Scenarios with Active Directory Domain Services on Azure Virtual Machines
• Entra Domain Services
• Linux Integration with AD DS

Module 12: Explore Remote Management for SAP on Azure

• Introduction
• Remote Management of VMs
• Azure Connector for SAP Landscape Management
• Access Management
• Azure Bastion
• JIT VM Access

Module 13: Explore Governance and Manageability for SAP on Azure

• Introduction
• Azure Resource Manager
• ARM Templates
• ARM Template Structure
• Role-Based Access Control
• Azure Resource Tags
• Azure Policy
• Management Groups
• Azure Automation
• Security and Compliance Services

Module 14: Deploy Single-Instance Implementations of SAP on Azure

• Introduction
• Deployment Methodologies
• Deploy with ARM Templates
• Manually Install SAP HANA
• Prepare VMs for SAP HANA Installation
• SAP HANA Installation with SWPM
• SAP HANA Installation with HDBLCM
• SAP HANA Scale-Out

Module 15: Implement High Availability in SAP NetWeaver with AnyDB on Azure

• Introduction
• High Availability in SAP NetWeaver
• Single SID 3-Tier High Availability
• Multi-SID 3-Tier High Availability
• DNS IP Setup
• Registry Entries for SAP ASCS-SCS
• Failover Cluster for SAP ASCS-SCS
• SIOS Data Keeper for SAP ASCS-SCS
• Highly Available NFS Share
• Lab - Implement SAP Architecture on Azure Virtual Machines Running Linux
• Lab - Implement SAP Architecture on Azure Virtual Machines Running Windows

Module 16: Explore Azure Center for SAP Solutions

• Introduction
• Azure Center for SAP Solutions
• Prerequisites for Azure Center
• Deployment Options
• Deploy S/4HANA Infrastructure
• Install SAP Software
• Register SAP System
• Use Azure Center Features

Module 17: Implement High Availability for SAP Workloads in Azure

• Introduction
• High Availability and DR for SAP
• SAP Workload High Availability
• Failover Clustering
• Deployment Scenarios
• High Availability of SAP Application Servers
• High Availability of SAP ASCS-SCS Instances
• High Availability of DBMS Instances
• SAP HANA Availability
• SQL Server High Availability for SAP
• Oracle High Availability for SAP
• Azure Infrastructure HA Capabilities
• Service-Level Agreements
• Availability Zones
• Principal Architectures
• Latency Between VMs Across Availability Zones
• Active/Active Deployment
• Active/Passive Deployment
• Combined HA and DR Configuration

Module 18: Implement Disaster Recovery for SAP Workloads in Azure

• Introduction
• Disaster Recovery of SAP Workloads
• Availability Between Two Azure Regions
• Combine Availability Across Regions
• Site Recovery
• Disaster Recovery for SAP on Azure
• Set up DR for Multi-Tier SAP NetWeaver App
• Replicate VMs in Proximity Placement Groups
• Set up DR for AD and DNS

Module 19: Perform Backups and Restores for SAP Workloads on Azure

• Introduction
• Backup and Restore of VMs
• Application-Consistent Backup for Linux VMs
• Application Backup
• Database Backup
• SAP HANA Backup
• SAP HANA Backup Scheduling
• SAP HANA File-Level Backups
• SAP HANA Snapshot-Based Backups
• SQL Server Backup to URL
• SQL Server File-Snapshot Backups
• Oracle Backup
• SQL Server Backups
• Set up SQL Server DR

Module 20: Use the Planning and Deployment Checklist for SAP Workloads on Azure

• Introduction
• SAP Workload Planning Checklist
• Project Preparation and Planning
• Pilot Phase
• Nonproduction Phase
• Production Preparation Phase
• Go Live Phase
• Post-Production Phase

Module 21: Explore Migration Options for SAP on Azure

• Introduction
• Strategies for Migrating SAP to Azure
• Migrate to S/4HANA from SAP Business Suite
• Classical vs. DMO Migration
• SAP DMO Methodology
• One-Step DMO with System Move
• Two-Step Migration
• Downtime-Optimised DMO

Module 22: Migrate Very Large Databases (VLDB) to Azure for SAP

• Introduction
• VLDB Migration
• Optimise Source System
• Advanced Source System Optimisation
• Optimise Network Upload
• Optimise Target System
• Create Migration Documents
• Monitor Migration
• VLDB Migration Best Practices

Module 23: Explore Monitoring Requirements of Azure for SAP Workloads

• Introduction
• Monitoring Requirements for SAP
• Monitoring, Logging, and Alerting
• VM Monitoring Considerations
• Enhanced Monitoring Troubleshooting
• Azure Monitor and Log Analytics
• SAP HANA Alerts
• Diagnostic Tools
• VM and Workload Updates

Module 24: Configure the Azure Enhanced Monitoring Extension for SAP

• Introduction
• Enhanced Monitoring Extension
• Configure Enhanced Monitoring Extension

Module 25: Explore Licensing, Pricing, and Support for SAP on Azure Virtual Machines

• Introduction
• Pricing Azure VM Solutions
• Licensing, Pricing, and Support for SAP

Data Engineering on Microsoft Azure DP203 Course Outline

Module 1: Introduction to Data Engineering on Azure

• Introduction
• What is Data Engineering
• Important Data Engineering Concepts
• Data Engineering in Microsoft Azure

Module 2: Introduction to Azure Data Lake Storage Gen2

• Introduction
• Understand Azure Data Lake Storage Gen2
• Enable Azure Data Lake Storage Gen2 in Azure Storage
• Compare Azure Data Lake Store to Azure Blob Storage
• Understand the Stages for Processing Big Data
• Use Azure Data Lake Storage Gen2 in Data Analytics Workloads

Module 3: Introduction to Azure Synapse Analytics

• Introduction
• What are Azure Synapse Analytics
• How Azure Synapse Analytics Works
• When to Use Azure Synapse Analytics
• Exercise - Explore Azure Synapse Analytics

Module 4: Use Azure Synapse Serverless SQL Pool to Query Files in a Data Lake

• Introduction
• Understand Azure Synapse Serverless SQL Pool Capabilities and Use Cases
• Query Files Using a Serverless SQL Pool
• Create External Database Objects
• Exercise - Query Files Using a Serverless SQL Pool

Module 5: Use Azure Synapse Serverless SQL Pools to Transform Data in a Data Lake

• Introduction
• Transform Data Files with the CREATE EXTERNAL TABLE AS SELECT Statement
• Encapsulate Data Transformations in a Stored Procedure
• Include a Data Transformation Stored Procedure in a Pipeline
• Exercise - Transform Files Using a Serverless SQL Pool

Module 6: Create a Lake Database in Azure Synapse Analytics

• Introduction
• Understand Lake Database Concepts
• Explore Database Templates
• Create a Lake Database
• Use a Lake Database
• Exercise - Analyse Data in a Lake Database

Module 7: Secure Data and Manage Users in Azure Synapse Serverless SQL Pools

• Introduction
• Choose an Authentication Method in Azure Synapse Serverless SQL Pools
• Manage Users in Azure Synapse Serverless SQL Pools
• Manage User Permissions in Azure Synapse Serverless SQL Pools

Module 8: Analyse Data with Apache Spark in Azure Synapse Analytics

• Introduction
• Get to Know Apache Spark
• Use Spark in Azure Synapse Analytics
• Analyse Data with Spark
• Visualise Data with Spark
• Exercise - Analyse Data with Spark

Module 9: Transform Data with Spark in Azure Synapse Analytics

• Introduction
• Modify and Save DataFrames
• Partition Data Files
• Transform Data with SQL
• Exercise - Transform Data with Spark in Azure Synapse Analytics

Module 10: Use Delta Lake in Azure Synapse Analytics

• Introduction
• Understand Delta Lake
• Create Delta Lake Tables
• Create Catalog Tables
• Use Delta Lake with Streaming Data
• Use Delta Lake in a SQL Pool
• Exercise - Use Delta Lake in Azure Synapse Analytics

Module 11: Build a Data Pipeline in Azure Synapse Analytics

• Introduction
• Understand Pipelines in Azure Synapse Analytics
• Create a Pipeline in Azure Synapse Studio
• Define Data Flows
• Run a Pipeline
• Exercise - Build a Data Pipeline in Azure Synapse Analytics

Module 12: Use Spark Notebooks in an Azure Synapse Pipeline

• Introduction
• Understand Synapse Notebooks and Pipelines
• Use a Synapse Notebook Activity in a Pipeline
• Use Parameters in a Notebook
• Exercise - Use an Apache Spark Notebook in a Pipeline

Module 13: Introduction to Azure Synapse Analytics

• Introduction
• What are Azure Synapse Analytics
• How Azure Synapse Analytics Works
• When to Use Azure Synapse Analytics
• Exercise - Explore Azure Synapse Analytics

Module 14: Use Azure Synapse Serverless SQL Pool to Query Files in a Data Lake

• Introduction
• Understand Azure Synapse Serverless SQL Pool Capabilities and Use Cases
• Query Files Using a Serverless SQL Pool
• Create External Database Objects
• Exercise - Query Files Using a Serverless SQL Pool

Module 15: Analyse Data with Apache Spark in Azure Synapse Analytics

• Introduction
• Get to Know Apache Spark
• Use Spark in Azure Synapse Analytics
• Analyse Data with Spark
• Visualise Data with Spark
• Exercise - Analyse Data with Spark

Module 16: Use Delta Lake in Azure Synapse Analytics

• Introduction
• Understand Delta Lake
• Create Delta Lake Tables
• Create Catalog Tables
• Use Delta Lake with Streaming Data
• Use Delta Lake in a SQL Pool
• Exercise - Use Delta Lake in Azure Synapse Analytics

Module 17: Analyse Data in a Relational Data Warehouse

• Introduction
• Design a Data Warehouse Schema
• Create Data Warehouse Tables
• Load Data Warehouse Tables
• Query a Data Warehouse
• Exercise - Explore a Data Warehouse

Module 18: Build a Data Pipeline in Azure Synapse Analytics

• Introduction
• Understand Pipelines in Azure Synapse Analytics
• Create a Pipeline in Azure Synapse Studio
• Define Data Flows
• Run a Pipeline
• Exercise - Build a Data Pipeline in Azure Synapse Analytics

Module 19: Analyse Data in a Relational Data Warehouse

• Introduction
• Design a Data Warehouse Schema
• Create Data Warehouse Tables
• Load Data Warehouse Tables
• Query a Data Warehouse
• Exercise - Explore a Data Warehouse

Module 20: Load Data into a Relational Data Warehouse

• Introduction
• Load Staging Tables
• Load Dimension Tables
• Load Time Dimension Tables
• Load Slowly Changing Dimensions
• Load Fact Tables
• Perform Post Load Optimisation
• Exercise - Load Data into a Relational Data Warehouse

Module 21: Manage and Monitor Data Warehouse Activities in Azure Synapse Analytics

• Introduction
• Scale Compute Resources in Azure Synapse Analytics
• Pause Compute in Azure Synapse Analytics
• Manage Workloads in Azure Synapse Analytics
• Use Azure Advisor to Review Recommendations
• Use Dynamic Management Views to Identify and Troubleshoot Query Performance

Module 22: Secure a Data Warehouse in Azure Synapse Analytics

• Introduction
• Understand Network Security Options for Azure Synapse Analytics
• Configure Conditional Access
• Configure Authentication
• Manage Authorisation Through Column and Row Level Security
• Exercise - Manage Authorisation Through Column and Row Level Security
• Manage Sensitive Data with Dynamic Data Masking
• Implement Encryption in Azure Synapse Analytics

Module 23: Plan Hybrid Transactional and Analytical Processing Using Azure Synapse Analytics

• Introduction
• Understand Hybrid Transactional and Analytical Processing Patterns
• Describe Azure Synapse Link

Module 24: Implement Azure Synapse Link with Azure Cosmos DB

• Introduction
• Enable Cosmos DB Account to Use Azure Synapse Link
• Create an Analytical Store Enabled Container
• Create a Linked Service for Cosmos DB
• Query Cosmos DB Data with Spark
• Query Cosmos DB with Synapse SQL
• Exercise - Implement Azure Synapse Link for Cosmos DB

Module 25: Implement Azure Synapse Link for SQL

• Introduction
• What Is Azure Synapse Link for SQL?
• Configure Azure Synapse Link for Azure SQL Database
• Configure Azure Synapse Link for SQL Server 2022
• Exercise - Implement Azure Synapse Link for SQL

Module 26: Get Started with Azure Stream Analytics

• Introduction
• Understand Data Streams
• Understand Event Processing
• Understand Window Functions
• Exercise - Get Started with Azure Stream Analytics

Module 27: Ingest Streaming Data Using Azure Stream Analytics and Azure Synapse Analytics

• Introduction
• Stream Ingestion Scenarios
• Configure Inputs and Outputs
• Define a Query to Select, Filter, and Aggregate Data
• Run a Job to Ingest Data
• Exercise - Ingest Streaming Data into Azure Synapse Analytics

Module 28: Visualise Real-Time Data with Azure Stream Analytics and Power BI

• Introduction
• Use a Power BI Output in Azure Stream Analytics
• Create a Query for Real-Time Visualisation
• Create Real-Time Data Visualisations in Power BI
• Exercise - Create a Real-Time Data Visualisation

Module 29: Explore Azure Databricks

• Introduction
• Get Started with Azure Databricks
• Identify Azure Databricks Workloads
• Understand Key Concepts
• Data Governance Using Unity Catalog and Microsoft Purview
• Exercise - Explore Azure Databricks

Module 30: Perform Data Analysis with Azure Databricks

• Introduction
• Ingest Data with Azure Databricks
• Data Exploration Tools in Azure Databricks
• Data Analysis Using DataFrame APIs
• Exercise - Explore Data with Azure Databricks

Module 31: Use Apache Spark in Azure Databricks

• Introduction
• Get to Know Spark
• Create a Spark Cluster
• Use Spark in Notebooks
• Use Spark to Work with Data Files
• Visualise Data
• Exercise - Use Spark in Azure Databricks

Module 32: Manage Data with Delta Lake

• Introduction
• Get Started with Delta Lake
• Manage ACID Transactions
• Implement Schema Enforcement
• Data Versioning and Time Travel in Delta Lake
• Data Integrity with Delta Lake
• Exercise - Use Delta Lake in Azure Databricks

Module 33: Build Data Pipelines with Delta Live Tables

• Introduction
• Explore Delta Live Tables
• Data Ingestion and Integration
• Real-Time Processing
• Exercise - Create a Data Pipeline with Delta Live Tables

Module 34: Deploy Workloads with Azure Databricks Workflows

• Introduction
• What Are Azure Databricks Workflows?
• Understand Key Components of Azure Databricks Workflows
• Explore the Benefits of Azure Databricks Workflows
• Deploy Workloads Using Azure Databricks Workflows
• Exercise - Create an Azure Databricks Workflow

Automating Administration with PowerShell AZ-040 Course Outline

Module 1: Review Windows PowerShell

• Introduction
• Windows PowerShell
• Windows PowerShell Applications
• Factors to Install and Use Windows PowerShell
• Configure the Windows PowerShell Console
• Windows PowerShell Integrated Scripting Environment
• Use Visual Studio Code with PowerShell

Module 2: Command Syntax in Windows PowerShell

• Structure of PowerShell cmdlets
• Parameters for Using PowerShell cmdlets
• Tab Completion Feature in PowerShell
• Display the About Files Content in PowerShell

Module 3: Commands and Get-Help in Windows PowerShell

• Modules in PowerShell
• cmdlets in PowerShell
• Use Command Aliases in PowerShell
• Use Show-Command and Get-Help in PowerShell
• Help File Contents and Update the Local Help Content in PowerShell

Module 4: Active Directory Domain Services using PowerShell cmdlets

• User Accounts in PowerShell
• Groups and Group Memberships in PowerShell
• Computer Accounts in PowerShell
• Organisational Units and Active Directory Objects in PowerShell

Module 5: Network Service Settings for Windows Devices Using PowerShell cmdlets

• IP Addresses in PowerShell
• IP Routing in PowerShell
• DNS Clients in PowerShell
• Windows Firewall Settings in PowerShell

Module 6: Windows Server Settings Using PowerShell Cmdlets

• Automate Management Tasks Using the Group Policy Management cmdlets
• Server Roles and Services Using PowerShell cmdlets
• Hyper-V Virtual Machines Using PowerShell cmdlets
• Internet Information Services Using PowerShell cmdlets

Module 7: Settings for a Local Windows Machine Using PowerShell cmdlets

• Manage Windows 10 Using PowerShell
• Manage Permissions with PowerShell

Module 8: Windows PowerShell Pipeline

• Review Windows PowerShell Pipeline and its Output
• Discover Object Members in PowerShell
• Control the Formatting of Pipeline Output

Module 9: Select, Sort, and Measure Objects Using the Pipeline

• Sort and Group Objects by Property in the Pipeline
• Measure Objects in the Pipeline
• Select a Set of Objects in the Pipeline
• Select Object Properties in the Pipeline
• Create and Format Calculated Properties in the Pipeline

Module 10: Filter Objects Out of the Pipeline

• Comparison Operators
• Review Basic Filter Syntax in the Pipeline
• Review Advanced Filter Syntax in the Pipeline
• Optimise the Filter Performance in the Pipeline

Module 11: Enumerate Objects in the Pipeline

• Enumerations in the Pipeline
• Review Basic Syntax to Enumerate Objects
• Review Advanced Syntax to Enumerate Objects

Module 12: Send and Pass Data as Output from the Pipeline

• Write Pipeline Data to a File
• Convert Pipeline Objects to Other Forms of Data
• Control Additional Output Options

Module 13: Pass Pipeline Objects

• Pipeline Parameter Binding
• Identify ByValue Parameters
• Pass Data by Using ByValue
• Pass Data by Using ByPropertyName
• Identify ByPropertyName Parameters
• Use Manual Parameters to Override the Pipeline
• Use Parenthetical Commands
• Expand Property Values

Module 14: Connect with Data Stores Using PowerShell Providers

• Define Windows PowerShell providers
• Review the Built-in Providers in PowerShell
• Access Provider Help in PowerShell

Module 15: Use PowerShell Drives in PowerShell

• PowerShell Drives in PowerShell
• Use PowerShell Drive cmdlets in PowerShell
• File System in PowerShell
• Registry in PowerShell
• Work with Certificates
• Work with Other PowerShell Drives

Module 16: Review CIM and WMI

• Review Architecture of CIM and WMI
• Review Repositories in CIM and WMI
• Locate Online Class Documentation by Using CIM and WMI cmdlets

Module 17: Query Configuration Information by Using CIM and WMI

• List Local Repository Namespaces and Classes by Using CIM and WMI
• Query Instances by Using Commands and WMI Query Language
• Connect to Remote Computers by Using CIM and WMI cmdlets
• Query Repository Classes from Remote Computers by Using CIMSession Objects

Module 18: Query and Manipulate Repository Objects by Using CIM and WMI Methods

• Discover Methods of Repository Objects by Using CIM and WMI
• Locate Class Methods and Documentation by Using CIM and WMI
• Invoke Methods of Repository Objects by Using CIM and WMI

Module 19: Manage Variables in Windows PowerShell Scripts

• Variables in Windows PowerShell Scripts
• Create Variable Names in Windows PowerShell Scripts
• Assign Values and Types to Variables
• Methods and Properties of Variables in Windows PowerShell Scripts
• String Variables and Methods in Windows PowerShell Scripts
• Date Variables and Methods in Windows PowerShell Scripts

Module 20: Work with Arrays and Hash Tables in Windows PowerShell Scripts

• Array in Windows PowerShell Scripts
• Work with Array Lists
• Define Hash Tables
• Work with Hash Tables

Module 21: Create and Run Scripts by Using Windows PowerShell

• Review Windows PowerShell Scripts
• Modify Scripts in the PowerShell Gallery
• Create Scripts using Windows PowerShell
• Review the PowerShellGet Module in Windows PowerShell
• Run Scripts and Set the Execution Policy in Windows PowerShell
• Review Windows PowerShell and AppLocker
• Sign the Scripts Digitally in Windows PowerShell

Module 22: Work with Scripting Constructs in Windows PowerShell

• ForEach loop in Windows PowerShell Scripts
• If construct in Windows PowerShell Scripts
• Switch Construct in Windows PowerShell Scripts
• For Construct in Windows PowerShell Scripts
• Other Loop Constructs in Windows PowerShell Scripts
• Break and Continue in Windows PowerShell Scripts

Module 23: Import Data in Different Formats for Use in Scripts by Using Windows PowerShell cmdlets

• Get-Content Command
• Import-Csv cmdlet
• Import-Clixml cmdlet
• ConvertFrom-Json cmdlet

Module 24: Use Methods to Accept User Inputs in Windows PowerShell Scripts

• Identify Values that Might Change
• Use the Read-Host cmdlet
• Use the Get-Credential cmdlet
• Use the Out-GridView cmdlet
• Pass Parameters to a Windows PowerShell Script

Module 25: Troubleshoot Scripts and Handle Errors in Windows PowerShell

• Interpret Error Messages Generated for Windows PowerShell Commands
• Add Output to Windows PowerShell Scripts
• Use Breakpoints in Windows PowerShell Scripts
• Interpret Error Actions for Windows PowerShell Commands

Module 26: Use Functions and Modules in Windows PowerShell Scripts

• Review Functions in Windows PowerShell Scripts
• Use Variable Scope in Windows PowerShell Scripts
• Create Modules in Windows PowerShell Scripts
• Use the Dot Sourcing Feature in Windows PowerShell

Module 27: Manage Single and Multiple Computers by Using Windows PowerShell Remoting

• Review the Remoting Feature of Windows PowerShell
• Compare Remoting with Remote Connectivity
• Review the Remoting Security Feature of Windows PowerShell
• Enable Remoting by Using Windows PowerShell
• Use One-to-One Remoting by Using Windows PowerShell
• Use One-to-Many Remoting by Using Windows PowerShell
• Compare Remoting Output with Local Output

Module 28: Use Advanced Windows PowerShell Remoting Techniques

• Review Common Remoting Techniques of Windows PowerShell
• Send Parameters to Remote Computers in Windows PowerShell
• Set Access Protection to Variables, Aliases, and Functions by Using the Scope Modifier
• Enable Multi-Hop Remoting in Windows PowerShell

Module 29: Persistent Connections to Remote Computers by Using Windows PowerShell Sessions

• Review Persistent Connections in Windows PowerShell
• Create and Manage Persistent PSSessions by using Windows PowerShell
• Disconnect PSSessions by Using Windows PowerShell
• Review the Feature of Implicit Remoting in Windows PowerShell

Module 30: Review Azure PowerShell Module

• Azure PowerShell
• Benefits of the Azure PowerShell Module
• Install the Azure PowerShell Module
• Migrate Azure PowerShell from AzureRM to Azure
• Review Microsoft Azure Active Directory Module for Windows PowerShell and Azure Active Directory PowerShell

Module 31: Review the Features and Tools for Azure Cloud Shell

• Characteristics of Azure Cloud Shell
• Features and Tools of Azure Cloud Shell
• Configure and Experiment with Azure Cloud Shell

Module 32: Manage Azure Resources with Windows PowerShell

• New Azure Virtual Machine by Using Windows PowerShell Commands
• Azure Virtual Machines by Using Windows PowerShell Commands
• Azure Related Storage by Using Azure PowerShell
• Azure Subscriptions by Using Azure PowerShell

Module 33: Manage Users, Groups, and Licenses in Azure AD by Using Windows PowerShell

• Benefits to Manage Microsoft 365 Services by Using Windows PowerShell
• Connect to the Microsoft 365 Tenant by Using Windows PowerShell
• Users in Microsoft 365 by Using Windows PowerShell
• Groups in Microsoft 365 by Using Windows PowerShell
• Roles in Microsoft 365 by Using Windows PowerShell
• Licenses in Microsoft 365 by Using Windows PowerShell

Module 34: Manage Exchange Online by Using Windows PowerShell

• Connect to Exchange Online by Using Windows PowerShell
• Mailboxes in Exchange Online by Using Windows PowerShell
• Resources in Exchange Online by Using Windows PowerShell
• Admin Roles in Exchange Online by Using Windows PowerShell

Module 35: Manage SharePoint Online by Using Windows PowerShell

• Install and Connect to SharePoint Online Management Shell by Using Windows PowerShell
• SharePoint Online Users and Groups by Using Windows PowerShell
• SharePoint Sites by Using Windows PowerShell
• SharePoint Online External User Sharing by Using Windows PowerShell

Module 36: Manage Microsoft Teams by Using Windows PowerShell

• Review Microsoft Teams PowerShell Module
• Install the Microsoft Teams PowerShell Module
• Manage Teams with Microsoft Teams PowerShell Module

Module 37: Create and Manage Background Jobs Using Windows PowerShell

• Types of Background Jobs in Windows PowerShell
• Start Remote Jobs and CIM/WMI Jobs in Windows PowerShell
• Monitor Jobs in Windows PowerShell
• Retrieve Results for Running Jobs in Windows PowerShell

Module 38: Create and Manage Scheduled Jobs Using Windows PowerShell

• Create and Run Windows PowerShell Scripts as Scheduled Tasks
• Define Scheduled Jobs in Windows PowerShell
• Create Job Option and Job Trigger objects in Windows PowerShell
• Create and Register a Scheduled Job in Windows PowerShell
• Retrieve the Results from a Scheduled Job in Windows PowerShell

Designing and Implementing CloudNative Applications Using Microsoft Azure Cosmos DB DP420 Course Outline

Module 1: Get Started with Azure Cosmos DB for NoSQL

• Introduction to Azure Cosmos DB for NoSQL
  • Introduction
  • What Is Azure Cosmos DB for NoSQL?
  • How Does Azure Cosmos DB for NoSQL Work?
  • When Should You Use Azure Cosmos DB for NoSQL?
• Try Azure Cosmos DB for NoSQL
  • Introduction
  • Explore Resources
  • Review Basic Operations
  • Exercise: Create an Azure Cosmos DB for NoSQL Account

Module 2: Plan and Implement Azure Cosmos DB for NoSQL

• Plan Resource Requirements
  • Introduction
  • Understand Throughput
  • Evaluate Throughput Requirements
  • Evaluate Data Storage Requirements
  • Time-to-Live (TTL)
  • Plan for Data Retention with Time-to-Live (TTL)
• Configure Azure Cosmos DB for NoSQL Database and Containers
  • Introduction
  • Serverless
  • Compare Serverless Vs. Provisioned Throughput
  • Autoscale Throughput
  • Compare Autoscale Vs. Standard (Manual) Throughput
  • Migrate Between Standard (Manual) and Autoscale Throughput
  • Exercise: Configure Throughput for Azure Cosmos DB SQL API with the Azure Portal
• Move Data into and Out of Azure Cosmos DB for NoSQL
  • Introduction
  • Move Data by Using Azure Data Factory
  • Move Data by Using a Kafka Connector
  • Move Data by Using Stream Analytics
  • Move Data by Using the Azure Cosmos DB Spark Connector
  • Exercise: Migrate Existing Data Using Azure Data Factory

Module 3: Connect to Azure Cosmos DB for NoSQL with the SDK

• Use the Azure Cosmos DB for NoSQL SDK
  • Introduction
  • Understand the SDK
  • Import from Package Manager
  • Connect to an Online Account
  • Implement Client Singleton
  • Configure Connectivity Mode
  • Exercise: Connect to Azure Cosmos DB for NoSQL with the SDK
• Configure the Azure Cosmos DB for NoSQL SDK
  • Introduction
  • Enable Offline Development
  • Handle Connection Errors
  • Implement Threading and Parallelism
  • Configure Logging
  • Exercise: Configure the Azure Cosmos DB for NoSQL SDK for Offline Development

Module 4: Access and Manage Data with the Azure Cosmos DB for NoSQL SDKs

• Implement Azure Cosmos DB for NoSQL Point Operations
  • Introduction
  • Understand Point Operations
  • Create Documents
  • Read a Document
  • Update Documents
  • Configure Time-to-Live (TTL) Value for a Specific Document
  • Delete Documents
  • Exercise: Create and Update Documents with the Azure Cosmos DB for NoSQL SDK
• Perform Cross-Document Transactional Operations with the Azure Cosmos DB for NoSQL
  • Introduction
  • Create a Transactional Batch with the SDK
  • Review Batch Operation Results with the SDK
  • Exercise: Batch Multiple Point Operations Together with the Azure Cosmos DB for NoSQL SDK
  • Implement Optimistic Concurrency Control
• Process Bulk Data in Azure Cosmos DB for NoSQL
  • Introduction
  • Create Bulk Operations with the SDK
  • Review Bulk Operation Caveats
  • Implement Bulk Best Practices
  • Exercise: Move Multiple Documents in Bulk with the Azure Cosmos DB for NoSQL SDK

Module 5: Execute Queries in Azure Cosmos DB for NoSQL

• Query the Azure Cosmos DB for NoSQL
  • Introduction
  • Understand SQL Query Language
  • Create Queries with SQL
  • Project Query Results
  • Implement Type-Checking in Queries
  • Use Built-In Functions
  • Execute Queries in the SDK
  • Exercise: Execute a Query with the Azure Cosmos DB for NoSQL SDK
• Author Complex Queries with the Azure Cosmos DB for NoSQL
  • Introduction
  • Create Cross-Product Queries
  • Implement Correlated Subqueries
  • Implement Variables in Queries
  • Paginate Query Results
  • Exercise: Paginate Cross-Product Query Results with the Azure Cosmos DB for NoSQL SDK

Module 6: Define and Implement an Indexing Strategy for Azure Cosmos DB for NoSQL

• Define Indexes in Azure Cosmos DB for NoSQL
  • Introduction
  • Understand Indexes
  • Understand Indexing Policies
  • Review Indexing Policy Strategies
  • Exercise: Review the Default Index Policy for an Azure Cosmos DB for NoSQL Container with the Portal
• Customise Indexes in Azure Cosmos DB for NoSQL
  • Introduction
  • Customise the Indexing Policy
  • Evaluate Composite Indexes
  • Exercise: Configure an Azure Cosmos DB for NoSQL Container's Index Policy with the Portal

Module 7: Integrate Azure Cosmos DB for NoSQL with Azure Services

• Consume an Azure Cosmos DB for NoSQL Change Feed Using the SDK
  • Introduction
  • Understand Change Feed Features in the SDK
  • Implement a Delegate for the Change Feed Processor
  • Implement the Change Feed Processor
  • Implement the Change Feed Estimator
  • Exercise: Process Change Feed Events Using the Azure Cosmos DB for NoSQL SDK
• Handle Events with Azure Functions and Azure Cosmos DB for NoSQL Change Feed
  • Introduction
  • Understand Azure Function Bindings for Azure Cosmos DB for NoSQL
  • Configure Function Bindings
  • Develop Function
  • Exercise: Process Azure Cosmos DB for NoSQL Data Using Azure Functions
• Search Azure Cosmos DB for NoSQL Data with Azure Cognitive Search
  • Introduction
  • Create an Indexer for Data in Azure Cosmos DB for NoSQL
  • Implement a Change Detection Policy
  • Manage a Data Deletion Detection Policy
  • Exercise: Search Data Using Azure Cognitive Search and Azure Cosmos DB for NoSQL

Module 8: Implement a Data Modeling and Partitioning Strategy for Azure Cosmos DB for NoSQL

• Implement a Non-Relational Data Model
  • Introduction
  • What's the Difference Between NoSQL and Relational Databases?
  • Identify Access Patterns for Your App
  • When to Embed or Reference Data?
  • Exercise: Measure Performance for Customer Entities
  • Choose a Partition Key
  • Model Small Lookup Entities
• Design a Data Partitioning Strategy
  • Introduction
  • Denormalise Data in Your Model
  • Manage Referential Integrity by Using Change Feed
  • Combine Multiple Entities in the Same Container
  • Denormalise Aggregates in the Same Container
  • Finalise the Data Model

Module 9: Design and Implement a Replication Strategy for Azure Cosmos DB for NoSQL

• Configure Replication and Manage Failovers in Azure Cosmos DB
  • Introduction
  • Understand Replication
  • Distribute Data Across Regions
  • Evaluate the Cost of Distributing Data Globally
  • Define Automatic Failover Policies
  • Perform Manual Failovers
  • Configure SDK Region
  • Exercise: Connect Different Regions with the Azure Cosmos DB for NoSQL SDK
• Use Consistency Models in Azure Cosmos DB for NoSQL
  • Introduction
  • Understand Consistency Models
  • Configure Default Consistency Model in the Portal
  • Change Consistency Model with the SDK
  • Use Session Tokens
  • Exercise: Configure Consistency Models in the Portal and the Azure Cosmos DB for NoSQL SDK
• Configure Multi-Region Write in Azure Cosmos DB for NoSQL
  • Introduction
  • Understand Multi-Region Write
  • Configure Multi-Region Support in the SDK
  • Understand Conflict Resolution Policies
  • Create Custom Conflict Resolution Policy
  • Exercise: Connect Multi-Region Write Account with the Azure Cosmos DB for NoSQL SDK

Module 10: Optimise Query and Operation Performance in Azure Cosmos DB for NoSQL

• Customise an Indexing Policy in Azure Cosmos DB for NoSQL
  • Introduction
  • Index Usage
  • Review Read-Heavy Index Patterns
  • Review Write-Heavy Index Patterns
  • Exercise - Optimise an Azure Cosmos DB for NoSQL Container's Index Policy for Common Operations
• Measure Index Performance in Azure Cosmos DB for NoSQL
  • Introduction
  • Enable Indexing Metrics
  • Analyse Indexing Metrics Results
  • Measure Query Cost
  • Measure Point Operation Cost
  • Exercise - Optimiie an Azure Cosmos DB for NoSQL Container's Index Policy for a Specific Query
• Implement Integrated Cache in Azure Cosmos DB for NoSQL
  • Introduction
  • Review Workloads That Benefit from the Cache
  • Enable Integrated Cache
  • Configure Cache Staleness

Module 11: Monitor and Troubleshoot an Azure Cosmos DB for NoSQL Solution

• Measure Performance in Azure Cosmos DB for NoSQL
  • Introduction
  • Understand Azure Monitor
  • Measure Throughput
  • Observe Rate-Limiting Events
  • Query Logs
  • Exercise: Use Azure Monitor to Analyse an Azure Cosmos DB for NoSQL Account
• Monitor Responses and Events in Azure Cosmos DB for NoSQL
  • Introduction
  • Review Common Response Codes
  • Understand Transient Errors
  • Review Rate-Limiting Errors
  • Configure Alerts
  • Audit Security
  • Exercise: Troubleshoot an Application Using the Azure Cosmos DB for NoSQL SDK
• Implement Backup and Restore for Azure Cosmos DB for NoSQL
  • Introduction
  • Evaluate Periodic Backup
  • Configure Continuous Backup and Recovery
  • Perform a Point-in-Time Recovery
  • Exercise: Recover a Database or Container from a Recovery Point
• Implement Security in Azure Cosmos DB for NoSQL
  • Introduction
  • Implement Network-Level Access Control
  • Review Data Encryption Options
  • Use Role-Based Access Control (RBAC)
  • Access Account Resources Using Azure Active Directory
  • Understand Always Encrypted
  • Exercise: Store Azure Cosmos DB for NoSQL Account Keys in Azure Key Vault

Module 12: Manage an Azure Cosmos DB for NoSQL Solution Using DevOps Practices

• Write Management Scripts for Azure Cosmos DB for NoSQL
  • Introduction
  • Create Resources
  • Manage Index Policies
  • Configure Database or Container-Provisioned Throughput
  • Migrate Between Standard and Autoscale Throughput
  • Change Region Failover Priority
  • Initiate Failovers
  • Exercise: Adjust Provisioned Throughput Using an Azure CLI Script
• Create Resource Templates for Azure Cosmos DB for NoSQL
  • Introduction
  • Understand Azure Resource Manager Resources
  • Author Azure Resource Manager Templates
  • Configure Database or Container Resources
  • Configure Throughput with an Azure Resource Manager Template
  • Manage Index Policies Through Azure Resource Manager Templates
  • Exercise: Create an Azure Cosmos DB for NoSQL Container Using Azure Resource Manager Templates

Module 13: Create Server-Side Programming Constructs in Azure Cosmos DB for NoSQL

• Build Multi-Item Transactions with the Azure Cosmos DB for NoSQL
  • Introduction
  • Understand Transactions in the Context of JavaScript SDK
  • Author Stored Procedures
  • Rollback Transactions
  • Create Stored Procedures with the JavaScript SDK
  • Exercise: Create a Stored Procedure with the Azure Portal
• Expand Query and Transaction Functionality in Azure Cosmos DB for NoSQL
  • Introduction
  • Create User-Defined Functions
  • Create User-Defined Functions with the SDK
  • Add Triggers to an Operation
  • Create and Use Triggers with the SDK
  • Exercise: Implement and Use User Defined Functions with the Azure Cosmos DB SDK

Designing and Implementing Microsoft Azure Networking Solutions AZ700​ Training Course Outline

Module 1: Introduction to Azure Virtual Networks

• Introduction
• Explore Azure Virtual Networks
• Configure Public IP Services
• Exercise: Design and Implement a Virtual Network in Azure
• Design Name Resolution for Your Virtual Network
• Exercise: Configure Domain Name Servers Settings in Azure
• Enable Cross-Virtual Network Connectivity with Peering
• Exercise: Connect Two Azure Virtual Networks Using Global Virtual Network Peering
• Implement Virtual Network Traffic Routing
• Configure Internet Access with Azure Virtual NAT

Module 2: Design and Implement Hybrid Networking

• Introduction
• Design and Implement Azure VPN Gateway
• Exercise: Create and Configure a Virtual Network Gateway
• Connect Networks with Site-to-Site VPN Connections
• Connect Devices to Networks with Point-to-Site VPN Connections
• Connect Remote Resources by Using Azure Virtual WANs
• Exercise: Create a Virtual WAN by Using the Azure Portal
• Create a Network Virtual Appliance (NVA) in a Virtual Hub

Module 3: Design and Implement Azure ExpressRoute

• Introduction
• Explore Azure ExpressRoute
• Design an ExpressRoute Deployment
• Exercise: Configure an ExpressRoute Gateway
• Exercise: Provision an ExpressRoute Circuit
• Configure Peering for an ExpressRoute Deployment
• Connect an ExpressRoute Circuit to a Virtual Network
• Connect Geographically Dispersed Networks with ExpressRoute Global Reach
• Improve Data Path Performance Between Networks with ExpressRoute FastPath
• Troubleshoot ExpressRoute Connection Issues

Module 4: Load Balance Non-HTTP(S) Traffic in Azure

• Introduction
• Explore Load Balancing
• Design and Implement Azure Load Balancer Using the Azure Portal
• Exercise: Create and Configure an Azure Load Balancer
• Explore Azure Traffic Manager
• Exercise: Create a Traffic Manager Profile Using the Azure Portal

Module 5: Load Balance HTTP(S) Traffic in Azure

• Introduction
• Design Azure Application Gateway
• Configure Azure Application Gateway
• Exercise: Deploy Azure Application Gateway
• Design and Configure Azure Front Door
• Exercise: Create a Front Door for a Highly Available Web Application

Module 6: Design and Implement Network Security

• Introduction
• Get Network Security Recommendations with Microsoft Defender for Cloud
• Deploy Azure DDoS Protection by Using the Azure Portal
• Exercise: Configure DDoS Protection on a Virtual Network Using the Azure Portal
• Deploy Network Security Groups by Using the Azure Portal
• Design and Implement Azure Firewall
• Exercise: Deploy and Configure Azure Firewall Using the Azure Portal
• Secure Your Networks with Azure Firewall Manager
• Exercise: Secure Your Virtual Hub Using Azure Firewall Manager
• Implement a Web Application Firewall on Azure Front Door

Module 7: Design and Implement Private Access to Azure Services

• Introduction
• Explain Virtual Network Service Endpoints
• Define Private Link Service and Private Endpoint
• Integrate Private Endpoint with DNS
• Exercise: Restrict Network Access to PaaS Resources with Virtual Network Service Endpoints Using the Azure Portal
• Exercise: Create an Azure Private Endpoint Using Azure PowerShell
• Integrate Your App Service with Azure Virtual Networks

Module 8: Design and Implement Network Monitoring

• Introduction
• Monitor Your Networks Using Azure Monitor
• Exercise: Monitor a Load Balancer Resource Using Azure Monitor
• Monitor Your Networks Using Azure Network Watcher