MOC On-Demand Probeaccount anfordern

Neue Microsoft Official
Courses On-Demand

  • Schritt 1 von 2: Wählen Sie das Themengebiet

    MOC On-Demand (MOD) – das sind offizielle Microsoft Schulungen, die Sie örtlich und zeitlich flexibel in einer virtuellen Lernumgebung absolvieren. Bei der GFN haben Sie die Möglichkeit, die Basiskurse mit verschiedenen Zusatzleistungen aufzuwerten, die Sie beim Lernen unterstützen und Sie gezielt auf die Prüfung vorbereiten.

    Azure
    Developer
    Exchange Server
    Firstlook
    Office 365
    PowerShell
    SharePoint Server
    Skype 4 Business
    SQL Server
    System Center
    Windows Desktop
    Windows Server
  • Details

    Schritt 2 von 2: Wählen Sie Ihren MOC On-Demand-Kurs

      Zur Themenwahl

    (Zugriff auf die Live Lab-Umgebung)

    Fragen? Tel.: 0800 436 436 436 | Mo – Fr 09:00 bis 17:00 Uhr

    (Zugriff auf die Live Lab-Umgebung)

    Fragen? Tel.: 0800 436 436 436 | Mo – Fr 09:00 bis 17:00 Uhr

    (Zugriff auf die Live Lab-Umgebung)

    Fragen? Tel.: 0800 436 436 436 | Mo – Fr 09:00 bis 17:00 Uhr

    (Zugriff auf die Live Lab-Umgebung)

    Fragen? Tel.: 0800 436 436 436 | Mo – Fr 09:00 bis 17:00 Uhr

    (Zugriff auf die Live Lab-Umgebung)

    Fragen? Tel.: 0800 436 436 436 | Mo – Fr 09:00 bis 17:00 Uhr

    (Zugriff auf die Live Lab-Umgebung)

    Fragen? Tel.: 0800 436 436 436 | Mo – Fr 09:00 bis 17:00 Uhr

    (Zugriff auf die Live Lab-Umgebung)

    Fragen? Tel.: 0800 436 436 436 | Mo – Fr 09:00 bis 17:00 Uhr

    (Zugriff auf die Live Lab-Umgebung)

    Fragen? Tel.: 0800 436 436 436 | Mo – Fr 09:00 bis 17:00 Uhr

    (Zugriff auf die Live Lab-Umgebung)

    Fragen? Tel.: 0800 436 436 436 | Mo – Fr 09:00 bis 17:00 Uhr

    (Zugriff auf die Live Lab-Umgebung)

    Fragen? Tel.: 0800 436 436 436 | Mo – Fr 09:00 bis 17:00 Uhr

    (Zugriff auf die Live Lab-Umgebung)

    Fragen? Tel.: 0800 436 436 436 | Mo – Fr 09:00 bis 17:00 Uhr

    (Zugriff auf die Live Lab-Umgebung)

    Fragen? Tel.: 0800 436 436 436 | Mo – Fr 09:00 bis 17:00 Uhr

    (Zugriff auf die Live Lab-Umgebung)

    Fragen? Tel.: 0800 436 436 436 | Mo – Fr 09:00 bis 17:00 Uhr

    (Zugriff auf die Live Lab-Umgebung)

    Fragen? Tel.: 0800 436 436 436 | Mo – Fr 09:00 bis 17:00 Uhr

    (Zugriff auf die Live Lab-Umgebung)

    Fragen? Tel.: 0800 436 436 436 | Mo – Fr 09:00 bis 17:00 Uhr

    (Zugriff auf die Live Lab-Umgebung)

    Fragen? Tel.: 0800 436 436 436 | Mo – Fr 09:00 bis 17:00 Uhr

    (Zugriff auf die Live Lab-Umgebung)

    Fragen? Tel.: 0800 436 436 436 | Mo – Fr 09:00 bis 17:00 Uhr

    (Zugriff auf die Live Lab-Umgebung)

    Fragen? Tel.: 0800 436 436 436 | Mo – Fr 09:00 bis 17:00 Uhr

    (Zugriff auf die Live Lab-Umgebung)

    Fragen? Tel.: 0800 436 436 436 | Mo – Fr 09:00 bis 17:00 Uhr

    (Zugriff auf die Live Lab-Umgebung)

    Fragen? Tel.: 0800 436 436 436 | Mo – Fr 09:00 bis 17:00 Uhr

    (Zugriff auf die Live Lab-Umgebung)

    Fragen? Tel.: 0800 436 436 436 | Mo – Fr 09:00 bis 17:00 Uhr

    (Zugriff auf die Live Lab-Umgebung)

    Fragen? Tel.: 0800 436 436 436 | Mo – Fr 09:00 bis 17:00 Uhr

    (Zugriff auf die Live Lab-Umgebung)

    Fragen? Tel.: 0800 436 436 436 | Mo – Fr 09:00 bis 17:00 Uhr

    (Zugriff auf die Live Lab-Umgebung)

    Fragen? Tel.: 0800 436 436 436 | Mo – Fr 09:00 bis 17:00 Uhr

    (Zugriff auf die Live Lab-Umgebung)

    Fragen? Tel.: 0800 436 436 436 | Mo – Fr 09:00 bis 17:00 Uhr

    (Zugriff auf die Live Lab-Umgebung)

    Fragen? Tel.: 0800 436 436 436 | Mo – Fr 09:00 bis 17:00 Uhr

    (Zugriff auf die Live Lab-Umgebung)

    Fragen? Tel.: 0800 436 436 436 | Mo – Fr 09:00 bis 17:00 Uhr

    (Zugriff auf die Live Lab-Umgebung)

    Fragen? Tel.: 0800 436 436 436 | Mo – Fr 09:00 bis 17:00 Uhr

    (Zugriff auf die Live Lab-Umgebung)

    Fragen? Tel.: 0800 436 436 436 | Mo – Fr 09:00 bis 17:00 Uhr

    (Zugriff auf die Live Lab-Umgebung)

    Fragen? Tel.: 0800 436 436 436 | Mo – Fr 09:00 bis 17:00 Uhr

    (Zugriff auf die Live Lab-Umgebung)

    Fragen? Tel.: 0800 436 436 436 | Mo – Fr 09:00 bis 17:00 Uhr

    (Zugriff auf die Live Lab-Umgebung)

    Fragen? Tel.: 0800 436 436 436 | Mo – Fr 09:00 bis 17:00 Uhr

    (Zugriff auf die Live Lab-Umgebung)

    Fragen? Tel.: 0800 436 436 436 | Mo – Fr 09:00 bis 17:00 Uhr

    (Zugriff auf die Live Lab-Umgebung)

    Fragen? Tel.: 0800 436 436 436 | Mo – Fr 09:00 bis 17:00 Uhr

    (Zugriff auf die Live Lab-Umgebung)

    Fragen? Tel.: 0800 436 436 436 | Mo – Fr 09:00 bis 17:00 Uhr

    (Zugriff auf die Live Lab-Umgebung)

    Fragen? Tel.: 0800 436 436 436 | Mo – Fr 09:00 bis 17:00 Uhr

    (Zugriff auf die Live Lab-Umgebung)

    Fragen? Tel.: 0800 436 436 436 | Mo – Fr 09:00 bis 17:00 Uhr

    (Zugriff auf die Live Lab-Umgebung)

    Fragen? Tel.: 0800 436 436 436 | Mo – Fr 09:00 bis 17:00 Uhr

    (Zugriff auf die Live Lab-Umgebung)

    Fragen? Tel.: 0800 436 436 436 | Mo – Fr 09:00 bis 17:00 Uhr

    (Zugriff auf die Live Lab-Umgebung)

    Fragen? Tel.: 0800 436 436 436 | Mo – Fr 09:00 bis 17:00 Uhr

    (Zugriff auf die Live Lab-Umgebung)

    Fragen? Tel.: 0800 436 436 436 | Mo – Fr 09:00 bis 17:00 Uhr

    (Zugriff auf die Live Lab-Umgebung)

    Fragen? Tel.: 0800 436 436 436 | Mo – Fr 09:00 bis 17:00 Uhr

    (Zugriff auf die Live Lab-Umgebung)

    Fragen? Tel.: 0800 436 436 436 | Mo – Fr 09:00 bis 17:00 Uhr

    (Zugriff auf die Live Lab-Umgebung)

    Fragen? Tel.: 0800 436 436 436 | Mo – Fr 09:00 bis 17:00 Uhr

    (Zugriff auf die Live Lab-Umgebung)

    Fragen? Tel.: 0800 436 436 436 | Mo – Fr 09:00 bis 17:00 Uhr

    (Zugriff auf die Live Lab-Umgebung)

    Fragen? Tel.: 0800 436 436 436 | Mo – Fr 09:00 bis 17:00 Uhr

    (Zugriff auf die Live Lab-Umgebung)

    Fragen? Tel.: 0800 436 436 436 | Mo – Fr 09:00 bis 17:00 Uhr

    (Zugriff auf die Live Lab-Umgebung)

    Fragen? Tel.: 0800 436 436 436 | Mo – Fr 09:00 bis 17:00 Uhr

    (Zugriff auf die Live Lab-Umgebung)

    Fragen? Tel.: 0800 436 436 436 | Mo – Fr 09:00 bis 17:00 Uhr

    (Zugriff auf die Live Lab-Umgebung)

    Fragen? Tel.: 0800 436 436 436 | Mo – Fr 09:00 bis 17:00 Uhr

    (Zugriff auf die Live Lab-Umgebung)

    Fragen? Tel.: 0800 436 436 436 | Mo – Fr 09:00 bis 17:00 Uhr

    (Zugriff auf die Live Lab-Umgebung)

    Fragen? Tel.: 0800 436 436 436 | Mo – Fr 09:00 bis 17:00 Uhr

    (Zugriff auf die Live Lab-Umgebung)

    Fragen? Tel.: 0800 436 436 436 | Mo – Fr 09:00 bis 17:00 Uhr

    (Zugriff auf die Live Lab-Umgebung)

    Fragen? Tel.: 0800 436 436 436 | Mo – Fr 09:00 bis 17:00 Uhr

    (Zugriff auf die Live Lab-Umgebung)

    Fragen? Tel.: 0800 436 436 436 | Mo – Fr 09:00 bis 17:00 Uhr

Weitere Informationen zum ausgewählten Kurs

Klicken Sie auf die Reiter, um sich weitere Informationen zu dem Kurs anzeigen zu lassen, den Sie ausgewählt haben.

This course provides students with the fundamental knowledge and skills to use Windows PowerShell 4.0 for administering and automating administration of Windows based servers. It focuses on primary Windows PowerShell command-line features and techniques, and will provide pre-requisite skills supporting a broad range of Microsoft products, including Windows Server, Windows Client, Exchange Server, SharePoint Server, SQL Server, System Center, and more. In keeping with that goal, this course will not focus on any one of those products, although Windows Server (which is the common platform for all of those) will serve as the example for the techniques being taught.

  • Understand the basic concepts behind Windows PowerShell
  • Work with the Pipeline
  • Understand How the Pipeline Works
  • Use PSProviders and PSDrives
  • Format Output
  • Use WMI and CIM
  • Prepare for Scripting
  • Moving From a Command to a Script to a Module
  • Administer Remote Computers
  • Put the various Windows PowerShell components together
  • Use Background Jobs and Scheduled Jobs
  • Use Advanced PowerShell Techniques and Profiles
  • Original-Microsoft-Training
  • MOC On-Demand is currently available only in English
  • combination of video, text, practical tasks and knowledge tests
  • special offers like discounts are considered when taking the exam.

About Microsoft Official Course On-Demand

The courses are a great alternative for anyone wanting to learn independently and at their own pace. As a participant, you will receive an access to a learning platform developed by Microsoft, providing you with content such as videos, tutorials as well as a Live Lab-Environment for exercises.

As one of the leading Microsoft Learning Partners in Germany, GFN AG works closely with Microsoft together. On request, we can offer you additional services like digital training materials or an individual exam preparation in one of our Training center. For further information, you can also visit the following website MoC On Demand-Infoseite or feel free to contact us.

First published: 12 January 2016



This course is intended for IT Professionals already experienced in general Windows Server and Windows Client administration or already experienced in administering and supporting Application servers and services including applications like Exchange, SharePoint, and SQL. It is broadly intended for students who want to use Windows PowerShell to automate administrative tasks from the command line, using any Microsoft or independent software vendor (ISV) product that supports Windows PowerShell manageability.

One more important note, all Microsoft MOC On-Demand courses are currently available in English only. To successfully complete this course, therefore a safe handling like IT-specialized English is essential.


  • Previous  Windows Server and Windows Client management knowledge and hands on experience.
  • Experience installing and configuring Windows Server into existing enterprise environments, or as standalone installations.
  • Knowledge and experience of network adapter configuration, basic Active Directory user administration, and basic disk configuration.
  • Knowledge and hands on experience specifically with Windows Server 2012/Windows Server 2012 R2 and Windows 8/Windows 8.1 would be of benefit but is not essential.

Recommended system requirements for Microsoft Official Courses On-Demand and labs include:

  • Windows 10
  • Current version of Internet Explorer or Microsoft Edge
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed ActiveX control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required
  • 1280 x 1024 or higher

Note You can also take a MOC On-Demand on your iPad® Retina 4th Generation; however, the lab experience is not optimized for tablets.

Note Regularly scheduled maintenance for the Microsoft Labs Online (MLO) platform is currently at 10?12 P.M. Pacific Time every Thursday. During that time, you may not be able to access the MLO associated with a MOC On-Demand.

The minimum system requirements for MOC On-Demand and labs include:

  • Windows 7 or later
  • Internet Explorer 9 or later
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed Active X control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required

This Online-Training covers the following topics:

  • Overview and Background
  • Finding and Learning Commands
  • Running Commands
  • Understanding the Pipeline
  • Selecting, Sorting, and Measuring Objects
  • Converting, Exporting, and Importing Objects
  • Filtering Objects Out of the Pipeline
  • Enumerating Objects in the Pipeline
  • Passing Data in the Pipeline By Value
  • Passing Data in the Pipeline By Property Name
  • Using PSProviders
  • Using PSDrives
  • Using Basic Formatting
  • Using Advanced Formatting
  • Redirecting Formatted Output
  • Understanding WMI and CIM
  • Querying Data with WMI and CIM
  • Making Changes by Using WMI and CIM
  • Using Variables
  • Scripting Security
  • Moving From Command to Script
  • Moving From Script to Function to Module
  • Implementing Basic Error Handling
  • Using Basic Scripting Constructs
  • Exploring Other Scripting Features
  • Using Basic Remoting
  • Using Advanced Remoting Techniques
  • Using Remoting Sessions
  • Provisioning a New Server Core Instance
  • Using Background Jobs
  • Using Scheduled Jobs
  • Using Advanced PowerShell Techniques
  • Creating Profile Scripts
  • Working With Alternative Credentials

Expand and build upon the knowledge already acquired in course 10961B and focus on building more scalable and usable Windows PowerShell scripts for use in your organization by building your own Windows PowerShell tools. Learn about areas such as the creation of advanced functions, script modules, advanced parameters attributes and controller scripts. Also learn how to make your scripts more robustby learning about handling script errors and the analysis and debugging Windows PowerShell scripts. The course will also cover the use of Windows PowerShell cmdlets with .NET Framework as well as teaching how to configure your Windows Servers using Desired State Configuration and providing an understanding of Windows PowerShell workflow.

  • Create Advanced Functions
  • Use Cmdlets and Microsoft .NET Framework in Windows PowerShell
  • Write Controller Scripts
  • Handle Script Errors
  • Use XML Data Files
  • Manage Server Configurations by Using Desired State Configuration
  • Analyze and Debugging Scripts
  • Understand Windows PowerShell Workflow
  • Original-Microsoft-Training
  • MOC On-Demand is currently available only in English
  • combination of video, text, practical tasks and knowledge tests
  • special offers like discounts are considered when taking the exam.

About Microsoft Official Course On-Demand

The courses are a great alternative for anyone wanting to learn independently and at their own pace. As a participant, you will receive an access to a learning platform developed by Microsoft, providing you with content such as videos, tutorials as well as a Live Lab-Environment for exercises.

As one of the leading Microsoft Learning Partners in Germany, GFN AG works closely with Microsoft together. On request, we can offer you additional services like digital training materials or an individual exam preparation in one of our Training center. For further information, you can also visit the following website MoC On Demand-Infoseite or feel free to contact us.

First published: 31. March 2016



This course is intended for IT Professionals already experienced in general Windows Server and Windows Client administration or already experienced in administering and supporting Application servers and services including applications such as Exchange, SharePoint, and SQL. System, Infrastructure and Application Administrators working in a Windows or Windows hybrid environment will all find this course relevant to their day to day jobs and future career and skills development.

The course is also intended for IT Professionals who want to build upon existing Windows PowerShell knowledge and skill to learn how to build their own tools for broader general use in their organization, using any Microsoft or independent software vendor (ISV) product that supports Windows PowerShell manageability.

One more important note, all Microsoft MOC On-Demand courses are currently available in English only. To successfully complete this course, therefore a safe handling like IT-specialized English is essential.


  • Knowledge and experience working with Windows PowerShell or knowledge equivalent to the content covered in course 10961B: Automating Administration with Windows PowerShell
  • Experienced in general Windows Server and Windows Client administration or already have experience in administering and supporting Application servers and services including applications like Exchange, SharePoint, and SQL.

Recommended system requirements for Microsoft Official Courses On-Demand and labs include:

  • Windows 10
  • Current version of Internet Explorer or Microsoft Edge
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed ActiveX control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required
  • 1280 x 1024 or higher

Note You can also take a MOC On-Demand on your iPad® Retina 4th Generation; however, the lab experience is not optimized for tablets.

Note Regularly scheduled maintenance for the Microsoft Labs Online (MLO) platform is currently at 10?12 P.M. Pacific Time every Thursday. During that time, you may not be able to access the MLO associated with a MOC On-Demand.

The minimum system requirements for MOC On-Demand and labs include:

  • Windows 7 or later
  • Internet Explorer 9 or later
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed Active X control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required

This Online-Training covers the following topics:

  • Converting a Command into an Advanced Function
  • Creating a Script Module
  • Defining Parameter Attributes and Input Validation
  • Writing Functions that use Multiple Objects
  • Writing Functions that Accept Pipeline Input
  • Producing Complex Function Output
  • Documenting Functions by using Content-Based Help
  • Supporting -Whatif and -Confirm
  • Running Windows PowerShell Commands
  • Using Microsoft .NET Framework in Windows PowerShell
  • Understanding Controller Scripts
  • Writing Controller Scripts that Show a User Interface
  • Writing Controller Scripts That Produce Reports
  • Understanding Error Handling
  • Handling Errors in a Script
  • Reading, Manipulating and Writing Data in XML
  • Understanding Desired State Configuration
  • Creating and Deploying a DSC Configuration
  • Debugging in Windows PowerShell
  • Analyzing and Debugging an Existing Script
  • Understanding Windows PowerShell Workflow

  • Describe Service Manager 2012 R2.
  • Install Service Manager 2012 R2.
  • Describe Service Manager usage cases.
  • Configure base settings in Service Manager 2012 R2.
  • Configure Incident and Problem Management.
  • Configure Activity, Change, and Release Management.
  • Configure and Manage Service Requests.
  • Automate business processes with Service Manager and Orchestrator.
  • Configure Service Level Management.
  • Customize The Self-Service Portal.
  • Use Reports and Analyze Data in Service Manager.
  • Perform advanced troubleshooting and disaster recovery in Service Manager.
  • Customize Service Manager Forms.
  • Original-Microsoft-Training
  • MOC On-Demand is currently available only in English
  • combination of video, text, practical tasks and knowledge tests
  • special offers like discounts are considered when taking the exam.

About Microsoft Official Course On-Demand

The courses are a great alternative for anyone wanting to learn independently and at their own pace. As a participant, you will receive an access to a learning platform developed by Microsoft, providing you with content such as videos, tutorials as well as a Live Lab-Environment for exercises.

As one of the leading Microsoft Learning Partners in Germany, GFN AG works closely with Microsoft together. On request, we can offer you additional services like digital training materials or an individual exam preparation in one of our Training center. For further information, you can also visit the following website MoC On Demand-Infoseite or feel free to contact us.

First published: 26. May 2016



This course is intended for cloud and datacenter administrators who are new to System Center 2012 R2 Service Manager and are responsible for deploying, configuring and operating it in their cloud or datacenter. This course is also intended for Cloud and datacenter administrators who are already familiar with Service Manager and want to upgrade their skills to include the new features found in System Center 2012 R2 Service Manager.

One more important note, all Microsoft MOC On-Demand courses are currently available in English only. To successfully complete this course, therefore a safe handling like IT-specialized English is essential.


  • Working knowledge of Windows Server 2008 R2 and Windows Server 2012.
  • Working knowledge of SQL Server 2008 R2 and SQL Server 2012.
  • An understanding of the IT management processes that are included with ITIL and MOF.

Recommended system requirements for Microsoft Official Courses On-Demand and labs include:

  • Windows 10
  • Current version of Internet Explorer or Microsoft Edge
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed ActiveX control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required
  • 1280 x 1024 or higher

Note You can also take a MOC On-Demand on your iPad® Retina 4th Generation; however, the lab experience is not optimized for tablets.

Note Regularly scheduled maintenance for the Microsoft Labs Online (MLO) platform is currently at 10?12 P.M. Pacific Time every Thursday. During that time, you may not be able to access the MLO associated with a MOC On-Demand.

The minimum system requirements for MOC On-Demand and labs include:

  • Windows 7 or later
  • Internet Explorer 9 or later
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed Active X control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required

This Online-Training covers the following topics:

  • Business Drivers Behind IT Service Management
  • Introduction to Microsoft System Center 2012 R2
  • System Center 2012 R2 Service Manager Overview and Key Features
  • Adopting ITIL/MOF Best Practices with Service Manager
  • Aligning IT Service Management Requirements to Service Manager
  • System Center 2012 R2 Service Manager Architecture and Core Components
  • Hardware, Software and Security Requirements
  • Planning and Sizing a System Center 2012 R2 Service Manager Deployment
  • Installing System Center 2012 R2 Service Manager
  • Installing and Configuring the Service Manager Self-Service Portal
  • Overview of the Service Manager Console
  • Upgrading to System Center 2012 Service Manager
  • Overview of Management Packs
  • Overview of the Service Manager CMDB
  • Managing Activities
  • Managing Workflows
  • Managing Templates
  • Security and User Roles
  • System Center 2012 R2 Service Manager Initial Configuration
  • Configuring Business Services
  • Configuring Access for your Support Teams
  • Configuring Notifications
  • Integrating Service Manager with Active Directory and other System Center Components
  • Integrating Service Manager with Exchange
  • The Definition of an Incident and a Problem
  • Managing Incidents
  • Managing Problems
  • Using Queues and Views with Incidents and Problems
  • Managing Change Requests
  • Managing Release Records
  • The Service Catalog, Request Offerings and Service Offerings
  • Managing Service Requests and Catalog Groups
  • The Self-Service Portal
  • Overview of Orchestrator
  • Configuring Runbooks in Orchestrator
  • Configuring Integration between Orchestrator and Service Manager
  • Creating a Request Offering in Service Manager to Initiate a Runbook in Orchestrator
  • Configuring Service Level Management
  • Viewing Service Level Agreement (SLA) Information in Service Manager
  • Running Reports in System Center 2012 R2 Service Manager
  • Configuring and Running Data Warehouse Jobs
  • Troubleshooting failed Data Warehouse Jobs
  • Data Warehouse Cubes
  • Performing Advanced Troubleshooting in Service Manager
  • Performing Disaster Recovery in Service Manager
  • Key Concepts in Creating and Customizing Forms in the Service Manager Authoring Tool
  • Creating New and Customized Forms by Using the Service Manager Authoring Tool

This course provides the underlying knowledge required by all individuals who will be evaluating Microsoft Azure, regardless of whether they are an administrator, developer, or database administrator.This course also provides the pre-requisite knowledge for students wishing to attend course 20532C Developing Microsoft Azure Solutions, or course 20533C Implementing Microsoft Azure Infrastructure Solutions.

During this course, students will be introduced to the principles of cloud computing and will become familiar how these principles have been implemented in Microsoft Azure. In addition, this course will take students through the process of implementing the core Azure infrastructure, consisting of virtual networks and storage. With this foundation, students will learn how to create the most common Azure services, including Azure virtual machines (VMs), Web Apps, and SQL Databases. The course will conclude by describing features of Azure Active Directory (Azure AD) and methods of integrating it with on-premises Active Directory.

  • Describe cloud computing, Azure, and Azure subscriptions.
  • Describe and create Azure Web Apps.
  • Create and configure VMs in Microsoft Azure.
  • Create an Azure virtual network.
  • Describe Azure storage.
  • Describe and deploy databases in Azure.
  • Describe Azure AD.
  • Original-Microsoft-Training
  • MOC On-Demand is currently available only in English
  • combination of video, text, practical tasks and knowledge tests
  • special offers like discounts are considered when taking the exam.

About Microsoft Official Course On-Demand

The courses are a great alternative for anyone wanting to learn independently and at their own pace. As a participant, you will receive an access to a learning platform developed by Microsoft, providing you with content such as videos, tutorials as well as a Live Lab-Environment for exercises.

As one of the leading Microsoft Learning Partners in Germany, GFN AG works closely with Microsoft together. On request, we can offer you additional services like digital training materials or an individual exam preparation in one of our Training center. For further information, you can also visit the following website MoC On Demand-Infoseite or feel free to contact us.

First published: 15. December 2016



  • Developers who want to evaluate creating Azure solutions.
  • Windows Server administrators who are looking to evaluate the migration of on-premises Active Directory services and roles to the cloud.
  • IT professionals who want to evaluate the use of Azure to host web sites and mobile app back-end services.
  • Database administrators who want to evaluate the use of Azure to host SQL databases.

One more important note, all Microsoft MOC On-Demand courses are currently available in English only. To successfully complete this course, therefore a safe handling like IT-specialized English is essential.


  • Understanding of websites.
  • A basic understanding of virtualization.
  • A basic understanding of Active Directory concepts, including domains, users, and domain controllers.
  • A basic understanding of database concepts including tables and simple queries.

Recommended system requirements for Microsoft Official Courses On-Demand and labs include:

  • Windows 10
  • Current version of Internet Explorer or Microsoft Edge
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed ActiveX control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required
  • 1280 x 1024 or higher

Note You can also take a MOC On-Demand on your iPad® Retina 4th Generation; however, the lab experience is not optimized for tablets.

Note Regularly scheduled maintenance for the Microsoft Labs Online (MLO) platform is currently at 10?12 P.M. Pacific Time every Thursday. During that time, you may not be able to access the MLO associated with a MOC On-Demand.

The minimum system requirements for MOC On-Demand and labs include:

  • Windows 7 or later
  • Internet Explorer 9 or later
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed Active X control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required

  • Module 1: Getting Started with Microsoft Azure
  • Module 2: Microsoft Azure management tools
  • Module 3: Virtual machines in Microsoft Azure
  • Module 4: Web Apps and cloud services
  • Module 5: Creating and configuring virtual networks
  • Module 6: Cloud storage
  • Module 7: Microsoft Azure databases
  • Module 8: Creating and managing Azure AD

This course is designed to provide students with the knowledge and skills required to install and configure Windows 10 desktops and devices in a Windows Server domain corporate environment. These skills include learning how to install and customize Windows 10 operating systems and apps, and configure local and remote network connectivity and storage. Students will also learn how to configure data security, device security, and network security, and maintain, update, and recover Windows 10.

  • Describe the processes for planning and using a Windows 10 troubleshooting methodology
  • Troubleshoot startup issues and operating system services on a Windows 10 device
  • Resolve issues that pertain to hardware devices and device drivers
  • Troubleshoot Windows 10 devices remotely
  • Troubleshoot issues that pertain to network connectivity
  • Troubleshoot client-configuration failures and issues with application of Group Policy Objects
  • Troubleshoot issues related to user settings
  • Troubleshoot remote-connectivity issues
  • Resolve issues that pertain to accessing resources from devices that are domain-joined
  • Resolve issues that pertain to accessing resources from devices that are not domain-joined
  • Troubleshoot issues that pertain to application installation and operation
  • Maintain a device that is running Windows 10
  • Recover a device that is running Windows 10
  • Original-Microsoft-Training
  • MOC On-Demand is currently available only in English
  • combination of video, text, practical tasks and knowledge tests
  • special offers like discounts are considered when taking the exam.

About Microsoft Official Course On-Demand

The courses are a great alternative for anyone wanting to learn independently and at their own pace. As a participant, you will receive an access to a learning platform developed by Microsoft, providing you with content such as videos, tutorials as well as a Live Lab-Environment for exercises.

As one of the leading Microsoft Learning Partners in Germany, GFN AG works closely with Microsoft together. On request, we can offer you additional services like digital training materials or an individual exam preparation in one of our Training center. For further information, you can also visit the following website MoC On Demand-Infoseite or feel free to contact us.

First published: 09. June 2016



  • The primary audience for this course is the Enterprise Desktop Support Technician (EDST), who provides Tier 2 support to users running Windows 10 personal computers (PCs) and devices in medium to large enterprise organizations, within a Windows domain environment. EDSTs focus on a broad range of technical issues for Windows operating systems (OSs), devices, cloud services, applications, networking, and hardware support. In the overarching scenario, if an Enterprise offers the service, the EDST is asked to support it.
  • The key responsibilities include resolving technical issues pertaining to Windows 10 installation and migration, activation, performance, profiles, settings; and device synchronization. Some other key responsibilities include local and remote network access; access to applications, access to data and printers; authentication, Endpoint security and policy; OS and data recovery.
  • The secondary audience for this course are IT professionals who administer and support Windows 10 desktops, devices, users, and associated network and security resources. Students who seek certification in the 70-697, Windows 10 Configuring exam will also benefit from this course.

One more important note, all Microsoft MOC On-Demand courses are currently available in English only. To successfully complete this course, therefore a safe handling like IT-specialized English is essential.


  • Networking fundamentals, including Transmission Control Protocol /Internet Protocol (TCP/IP), User Datagram Protocol (UDP), and Domain Name System (DNS).
  • Microsoft Active Directory Domain Services (AD DS) principles.
  • Understanding of the Public Key Infrastructure (PKI) components.
  • Windows Server 2012 R2 fundamentals.
  • Microsoft Windows Client essentials; for example, experience with Windows 10 or knowledge from the courses 20697-1 and 20697-2.

Recommended system requirements for Microsoft Official Courses On-Demand and labs include:

  • Windows 10
  • Current version of Internet Explorer or Microsoft Edge
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed ActiveX control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required
  • 1280 x 1024 or higher

Note You can also take a MOC On-Demand on your iPad® Retina 4th Generation; however, the lab experience is not optimized for tablets.

Note Regularly scheduled maintenance for the Microsoft Labs Online (MLO) platform is currently at 10?12 P.M. Pacific Time every Thursday. During that time, you may not be able to access the MLO associated with a MOC On-Demand.

The minimum system requirements for MOC On-Demand and labs include:

  • Windows 7 or later
  • Internet Explorer 9 or later
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed Active X control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required

This Online-Training covers the following topics:

  • Overview of Windows 10
  • Introduction to the EDST Job Role
  • Overview of the Troubleshooting Steps
  • Troubleshooting Tools
  • Overview of the Windows 10 Startup Recovery Environment
  • Troubleshooting Startup Settings
  • Troubleshooting Operating System Services Issues
  • Recovering BitLocker-Protected Drives
  • Troubleshooting Device Driver Failures
  • Overview of Hardware Troubleshooting
  • Troubleshooting Physical Failures
  • Monitoring Reliability
  • Configuring the Registry
  • Using Remote Desktop
  • Using Remote Assistance
  • Remoting with Windows PowerShell
  • Determining Network Settings
  • Troubleshooting Network Connectivity Issues
  • Troubleshooting Name Resolution
  • Overview of Group Policy Application
  • Resolving Client Configuration Failures and GPO Application Issues
  • Troubleshooting Sign In Issues
  • Troubleshooting the Application of User Settings
  • Troubleshooting VPN Connectivity Issues
  • Troubleshooting DirectAccess
  • Troubleshooting File Permissions Issues
  • Recovering Files Encrypted by EFS
  • Troubleshooting Printer Access Issues
  • Configuring and Troubleshooting Device Registration
  • Configuring and Troubleshooting Work Folders
  • Configuring and Troubleshooting OneDrive Access
  • Troubleshooting Desktop App Installation Issues
  • Troubleshooting Desktop Apps
  • Managing Windows Store Apps
  • Troubleshooting Access to Company Web Applications
  • Managing and Troubleshooting Windows Activation
  • Monitoring and Troubleshooting Performance
  • Applying Applications and Windows Updates
  • File Recovery in Windows 10
  • Recovering an OS






This course is aimed at people looking to move into a database professional role or whose job role is expanding to encompass database elements. The course describes fundamental database concepts including database types, database languages, and database designs.

  • Describe key database concepts in the context of SQL Server 2016
  • Describe database languages used in SQL Server 2016
  • Describe data modelling techniques
  • Describe normalization and denormalization techniques
  • Describe relationship types and effects in database design
  • Describe the effects of database design on performance
  • Describe commonly used database objects
  • Original-Microsoft-Training
  • MOC On-Demand is currently available only in English
  • combination of video, text, practical tasks and knowledge tests
  • special offers like discounts are considered when taking the exam.

About Microsoft Official Course On-Demand

The courses are a great alternative for anyone wanting to learn independently and at their own pace. As a participant, you will receive an access to a learning platform developed by Microsoft, providing you with content such as videos, tutorials as well as a Live Lab-Environment for exercises.

As one of the leading Microsoft Learning Partners in Germany, GFN AG works closely with Microsoft together. On request, we can offer you additional services like digital training materials or an individual exam preparation in one of our Training center. For further information, you can also visit the following website MoC On Demand-Infoseite or feel free to contact us.

First published: 23. February 2017



The primary audience for this course is people who are moving into a database role, or whose role has expanded to include database technologies.

One more important note, all Microsoft MOC On-Demand courses are currently available in English only. To successfully complete this course, therefore a safe handling like IT-specialized English is essential.


  • only general computer literacy required.

Recommended system requirements for Microsoft Official Courses On-Demand and labs include:

  • Windows 10
  • Current version of Internet Explorer or Microsoft Edge
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed ActiveX control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required
  • 1280 x 1024 or higher

Note You can also take a MOC On-Demand on your iPad® Retina 4th Generation; however, the lab experience is not optimized for tablets.

Note Regularly scheduled maintenance for the Microsoft Labs Online (MLO) platform is currently at 10?12 P.M. Pacific Time every Thursday. During that time, you may not be able to access the MLO associated with a MOC On-Demand.

The minimum system requirements for MOC On-Demand and labs include:

  • Windows 7 or later
  • Internet Explorer 9 or later
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed Active X control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required

This Online-Training covers the following topics:

  • Introduction to relational databases
  • Other types of database
  • Data analysis
  • Database languages
  • Data modelling
  • ANSI/SPARC database model
  • Entity relationship modelling
  • Why normalize data?
  • Normalization terms
  • Levels of normalization
  • Denormalization
  • Schema mapping
  • Referential integrity
  • Indexing
  • Query performance
  • Concurrency
  • Tables
  • Views
  • Stored procedures
  • Other database objects

This course provides students moving from earlier releases of SQL Server with an introduction to the new features in SQL Server 2016.

  • Describe key capabilities and components of SQL Server 2016
  • Describe new and enhanced features in SQL Server performance
  • Describes new and enhanced features in SQL Server security
  • Describe what?s new in SQL Server Availability and Scalability
  • Describe new and enhanced features in reporting and PowerBI in SQL Server 2016
  • Describe new and enhanced data access features
  • Describe new and enhanced features in SQL Server OLAP
  • Describe new SQL Server cloud functionality
  • Original-Microsoft-Training
  • MOC On-Demand is currently available only in English
  • combination of video, text, practical tasks and knowledge tests
  • special offers like discounts are considered when taking the exam.

About Microsoft Official Course On-Demand

The courses are a great alternative for anyone wanting to learn independently and at their own pace. As a participant, you will receive an access to a learning platform developed by Microsoft, providing you with content such as videos, tutorials as well as a Live Lab-Environment for exercises.

As one of the leading Microsoft Learning Partners in Germany, GFN AG works closely with Microsoft together. On request, we can offer you additional services like digital training materials or an individual exam preparation in one of our Training center. For further information, you can also visit the following website MoC On Demand-Infoseite or feel free to contact us.

First published: 26. January 2017



The primary audience for this course are existing database professionals with experience of SQL Server 2014 who want to update their skills to SQL Server 2016. Additionally this course is for existing SQL Server 2014 MCSAs who want to prepare for the Upgrade exam for SQL Server 2016 certification.

One more important note, all Microsoft MOC On-Demand courses are currently available in English only. To successfully complete this course, therefore a safe handling like IT-specialized English is essential.


  • Experience of building and managing database, data warehouse, and business intelligence (BI) solutions with SQL Server 2014
  • Familiarity with the Windows Server 2012 R2 operating system and networking
  • Familiarity with Microsoft Excel and Microsoft SharePoint Server 2013

Recommended system requirements for Microsoft Official Courses On-Demand and labs include:

  • Windows 10
  • Current version of Internet Explorer or Microsoft Edge
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed ActiveX control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required
  • 1280 x 1024 or higher

Note You can also take a MOC On-Demand on your iPad® Retina 4th Generation; however, the lab experience is not optimized for tablets.

Note Regularly scheduled maintenance for the Microsoft Labs Online (MLO) platform is currently at 10?12 P.M. Pacific Time every Thursday. During that time, you may not be able to access the MLO associated with a MOC On-Demand.

The minimum system requirements for MOC On-Demand and labs include:

  • Windows 7 or later
  • Internet Explorer 9 or later
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed Active X control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required

  • Module 1: Introduction to SQL Server 2016
  • Module 2: What?s New in SQL Server Performance
  • Module 3: What?s New in SQL Server Security?
  • Module 4: What?s New in SQL Server Availability and Scalability?
  • Module 5: What?s New in SQL Server Reporting and BI
  • Module 6: What?s New in SQL Server Data Access?
  • Module 7: New and Enhanced Features in SQL Server OLAP
  • Module 8: What?s New for SQL Server in the Cloud?

This course provides students who manage and maintain SQL Server databases with the knowledge and skills to performance tune and optimize their databases.

  • Describe the high level architectural overview of SQL Server and its various components.
  • Describe the SQL Server execution model, waits and queues.
  • Describe core I/O concepts, Storage Area Networks and performance testing.
  • Describe architectural concepts and best practices related to data files for user databases and TempDB.
  • Describe architectural concepts and best practices related to Concurrency, Transactions, Isolation Levels and Locking.
  • Describe architectural concepts of the Optimizer and how to identify and fix query plan issues.
  • Describe architectural concepts, troubleshooting scenarios and best practices related to Plan Cache.
  • Describe architectural concepts, troubleshooting strategy and usage scenarios for Extended Events.
  • Explain data collection strategy and techniques to analyze collected data.
  • Understand techniques to identify and diagnose bottlenecks to improve overall performance.
  • Original-Microsoft-Training
  • MOC On-Demand is currently available only in English
  • combination of video, text, practical tasks and knowledge tests
  • special offers like discounts are considered when taking the exam.

About Microsoft Official Course On-Demand

The courses are a great alternative for anyone wanting to learn independently and at their own pace. As a participant, you will receive an access to a learning platform developed by Microsoft, providing you with content such as videos, tutorials as well as a Live Lab-Environment for exercises.

As one of the leading Microsoft Learning Partners in Germany, GFN AG works closely with Microsoft together. On request, we can offer you additional services like digital training materials or an individual exam preparation in one of our Training center. For further information, you can also visit the following website MoC On Demand-Infoseite or feel free to contact us.

First published: 23. February 2017



  • Individuals who administer and maintain SQL Server databases and are responsible for optimal performance of SQL Server instances that they manage. These individuals also write queries against data and need to ensure optimal execution performance of the workloads.
  • Individuals who develop applications that deliver content from SQL Server databases

One more important note, all Microsoft MOC On-Demand courses are currently available in English only. To successfully complete this course, therefore a safe handling like IT-specialized English is essential.


  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Working knowledge of database administration and maintenance
  • Working knowledge of Transact-SQL

Recommended system requirements for Microsoft Official Courses On-Demand and labs include:

  • Windows 10
  • Current version of Internet Explorer or Microsoft Edge
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed ActiveX control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required
  • 1280 x 1024 or higher

Note You can also take a MOC On-Demand on your iPad® Retina 4th Generation; however, the lab experience is not optimized for tablets.

Note Regularly scheduled maintenance for the Microsoft Labs Online (MLO) platform is currently at 10?12 P.M. Pacific Time every Thursday. During that time, you may not be able to access the MLO associated with a MOC On-Demand.

The minimum system requirements for MOC On-Demand and labs include:

  • Windows 7 or later
  • Internet Explorer 9 or later
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed Active X control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required

This Online-Training covers the following topics:

  • SQL Server Components and SQL OS
  • Windows Scheduling vs SQL Scheduling
  • Waits and Queues
  • Core Concepts
  • Storage Solutions
  • I/O Setup and Testing
  • Database Structure Internals
  • Data File Internals
  • TempDB Internals
  • Windows Memory
  • SQL Server Memory
  • In-Memory OLTP
  • Concurrency and Transactions
  • Locking Internals
  • Statistics Internals and Cardinality Estimation
  • Index Internals
  • Columnstore Indexes
  • Query execution and optimizer internals
  • Analyzing query plans
  • Plan cache internals
  • Troubleshooting plan cache issues
  • Query store
  • Extended events core concepts
  • Implementing extended events
  • Monitoring and tracing
  • Baselining and benchmarking
  • Troubleshoot CPU performance
  • Troubleshoot memory performance
  • Troubleshoot I/O performance
  • Troubleshoot Concurrency performance
  • Troubleshoot TempDB performance

  • Describe key features of a self-service BI solution
  • Describe the key capabilities of SQL Server BI in a SharePoint environment
  • Describe common Analysis Services operational tasks
  • Describe PowerPivot for SharePoint server
  • Describe Power Query
  • Describe Windows Azure HDInsight
  • Original-Microsoft-Training
  • MOC On-Demand is currently available only in English
  • combination of video, text, practical tasks and knowledge tests
  • special offers like discounts are considered when taking the exam.

About Microsoft Official Course On-Demand

The courses are a great alternative for anyone wanting to learn independently and at their own pace. As a participant, you will receive an access to a learning platform developed by Microsoft, providing you with content such as videos, tutorials as well as a Live Lab-Environment for exercises.

As one of the leading Microsoft Learning Partners in Germany, GFN AG works closely with Microsoft together. On request, we can offer you additional services like digital training materials or an individual exam preparation in one of our Training center. For further information, you can also visit the following website MoC On Demand-Infoseite or feel free to contact us.

First published: 28. April 2017



The primary audience for this course are business intelligence professionals.

The secondary audiences for this course are technically proficient business users.

One more important note, all Microsoft MOC On-Demand courses are currently available in English only. To successfully complete this course, therefore a safe handling like IT-specialized English is essential.


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

Recommended system requirements for Microsoft Official Courses On-Demand and labs include:

  • Windows 10
  • Current version of Internet Explorer or Microsoft Edge
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed ActiveX control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required
  • 1280 x 1024 or higher

Note You can also take a MOC On-Demand on your iPad® Retina 4th Generation; however, the lab experience is not optimized for tablets.

Note Regularly scheduled maintenance for the Microsoft Labs Online (MLO) platform is currently at 10?12 P.M. Pacific Time every Thursday. During that time, you may not be able to access the MLO associated with a MOC On-Demand.

The minimum system requirements for MOC On-Demand and labs include:

  • Windows 7 or later
  • Internet Explorer 9 or later
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed Active X control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required

This Online-Training covers the following topics:

  • Rationale for BI Operations
  • Roles in BI Operations
  • Technologies Used in BI Operations
  • Environment and Operational Standards
  • The Importance of Standardized Builds
  • Configuration Considerations for BI Technologies
  • BI Architectures
  • SharePoint BI Environments
  • Security Approach to BI Solutions
  • Security Components
  • Security Approach for BI Components
  • The Security Approach in Different BI Environments
  • Application Life Cycle Management for BI Solution
  • Stand-Alone Deployments
  • Team-Based Deployments
  • The Need for Logging and Monitoring
  • Logging Options
  • Monitoring Options
  • Setting Up Alerts
  • Troubleshoot Failed BI Solutions
  • Troubleshooting the Data Warehouse
  • Troubleshooting SQL Server Analysis Services
  • Troubleshooting SQL Server Reporting Services
  • The Need for Performance Tuning
  • BI Queries to Performance Tune
  • Tools for Performance Tuning
  • Remediating Performance Issues

This course teaches students how to implement a SQL Server 2016 Reporting Services solution for data analysis in an organization. The course discusses how to use the Reporting Services development tools to create and manage reports and implement self-service BI solutions.

  • Describe key features of data modeling within business intelligence
  • Describe various report services data sources and how these are configured
  • Create reports with report designer and/or report designer
  • Configure reports with report designer and/or report builder
  • Create SQL Server mobile reports
  • Original-Microsoft-Training
  • MOC On-Demand is currently available only in English
  • combination of video, text, practical tasks and knowledge tests
  • special offers like discounts are considered when taking the exam.

About Microsoft Official Course On-Demand

The courses are a great alternative for anyone wanting to learn independently and at their own pace. As a participant, you will receive an access to a learning platform developed by Microsoft, providing you with content such as videos, tutorials as well as a Live Lab-Environment for exercises.

As one of the leading Microsoft Learning Partners in Germany, GFN AG works closely with Microsoft together. On request, we can offer you additional services like digital training materials or an individual exam preparation in one of our Training center. For further information, you can also visit the following website MoC On Demand-Infoseite or feel free to contact us.

First published: 16. February 2017



  • database professionals who need to fulfil a BI developer role to create reports.Primary responsibilities will include implementing reports and mobile reports.
  • power information workers

One more important note, all Microsoft MOC On-Demand courses are currently available in English only. To successfully complete this course, therefore a safe handling like IT-specialized English is essential.


  • 20761A/B: Querying Data with Transact-SQL

Recommended system requirements for Microsoft Official Courses On-Demand and labs include:

  • Windows 10
  • Current version of Internet Explorer or Microsoft Edge
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed ActiveX control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required
  • 1280 x 1024 or higher

Note You can also take a MOC On-Demand on your iPad® Retina 4th Generation; however, the lab experience is not optimized for tablets.

Note Regularly scheduled maintenance for the Microsoft Labs Online (MLO) platform is currently at 10?12 P.M. Pacific Time every Thursday. During that time, you may not be able to access the MLO associated with a MOC On-Demand.

The minimum system requirements for MOC On-Demand and labs include:

  • Windows 7 or later
  • Internet Explorer 9 or later
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed Active X control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required

This Online-Training covers the following topics:

  • Introduction to business intelligence
  • The Microsoft business intelligence platform
  • Introduction to reporting services
  • Data sources
  • Connection strings
  • Datasets
  • Filters and parameters
  • Creating a report with the report wizard
  • Creating a report
  • Showing data graphically in a report
  • Implementing filters and parameters
  • Implementing sorting and grouping
  • Publishing a report
  • Overview of SQL Server mobile reports
  • Preparing data for mobile reports
  • SQL Server Mobile report publisher






This course covers a range of components, including Azure Compute, Azure Storage, and network services that customers can benefit from when deploying hybrid solutions. In this context, the term hybridmeans integrating infrastructure technologies that customers host in on-premises datacenters with Azure IaaS and PaaS services. This course offers an overview of these services, providing the knowledge necessary to design hybrid solutions properly. It also includes a number of demonstrations and labs that enable students to develop hands-on skills that are necessary when implementing such solutions.

  • Describe the core concepts of Azure.
  • Explain the primary methods for integrating an on-premises environment with Azure Virtual Machines and Azure Cloud Services.
  • Describe Azure hybrid networking technologies.
  • Describe the Azure services that provide data storage, management, and analytics capabilities in hybrid scenarios.
  • Explain the use of Azure disaster recovery and business continuity solutions for on-premises environments.
  • Explain how to design and implement cross-premises applications.
  • Describe Azure monitoring and management solutions that offer hybrid capabilities.
  • Original-Microsoft-Training
  • MOC On-Demand is currently available only in English
  • combination of video, text, practical tasks and knowledge tests
  • special offers like discounts are considered when taking the exam.

About Microsoft Official Course On-Demand

The courses are a great alternative for anyone wanting to learn independently and at their own pace. As a participant, you will receive an access to a learning platform developed by Microsoft, providing you with content such as videos, tutorials as well as a Live Lab-Environment for exercises.

As one of the leading Microsoft Learning Partners in Germany, GFN AG works closely with Microsoft together. On request, we can offer you additional services like digital training materials or an individual exam preparation in one of our Training center. For further information, you can also visit the following website MoC On Demand-Infoseite or feel free to contact us.

First published: 13. April 2017



  • IT professionals who have used on-premises virtualization technologies, including both Hyper-V and VMware platforms, but who want to deploy, configure, and administer services and virtual machines in Azure.
  • IT professionals who have used Microsoft System Center to manage and orchestrate an on-premises server infrastructure.
  • Windows and Linux administrators who are looking to evaluate and migrate on-premises workloads and services to the cloud.
  • IT professionals who need to implement network connectivity between on-premises environments and services that Azure or Microsoft Office 365 hosts.
  • IT professionals who want to use Azure to increase the resiliency and agility of their on-premises environments.
  • DevOps personnel who are considering deploying hybrid solutions that consist of both cloud-based and on-premises components.
  • IT professionals and DevOps personnel who are experienced in other non-Microsoft cloud technologies, who meet the course prerequisites, and how are looking to cross-train on Azure.

One more important note, all Microsoft MOC On-Demand courses are currently available in English only. To successfully complete this course, therefore a safe handling like IT-specialized English is essential.


  • An understanding of on-premises virtualization technologies, including virtual machines, virtual networking, and virtual hard disks.
  • An understanding of network configuration, including TCP/IP, Domain Name System (DNS), VPNs, firewalls, and encryption technologies.
  • An understanding of web applications, including creating, configuring, monitoring, and deploying web applications on Internet Information Services (IIS).
  • An understanding of Active Directory concepts, including domains, forests, domain controllers, replication, the Kerberos protocol, and Lightweight Directory Access Protocol (LDAP).
  • Knowledge of Windows Server 2012 and Windows Server 2016 fundamentals.
  • Knowledge of Windows PowerShell command-line interface basics.
  • Knowledge of cloud computing basics.

Recommended system requirements for Microsoft Official Courses On-Demand and labs include:

  • Windows 10
  • Current version of Internet Explorer or Microsoft Edge
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed ActiveX control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required
  • 1280 x 1024 or higher

Note You can also take a MOC On-Demand on your iPad® Retina 4th Generation; however, the lab experience is not optimized for tablets.

Note Regularly scheduled maintenance for the Microsoft Labs Online (MLO) platform is currently at 10?12 P.M. Pacific Time every Thursday. During that time, you may not be able to access the MLO associated with a MOC On-Demand.

The minimum system requirements for MOC On-Demand and labs include:

  • Windows 7 or later
  • Internet Explorer 9 or later
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed Active X control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required

This Online-Training covers the following topics:

  • Overview of cloud computing and Azure
  • Overview of the Azure deployment models
  • Deploying Azure-based virtual machines by using the Azure portal
  • Deploying Azure-based virtual machines by using Azure PowerShell
  • Creating and deploying an Azure Resource Manager deployment template
  • Identify and delete newly deployed resources
  • Describe cloud computing and Azure.
  • Describe the Azure deployment models.
  • Overview of Virtual Machines and Cloud Services
  • Extending workloads to Azure Virtual Machines by using virtual machine images and disks
  • Extending Big Compute workloads to Azure
  • Integrating compute workloads by using containers and Azure Service Fabric
  • Preparing your on premises .vhd file for upload
  • Uploading and attaching a .vhd file to an Azure virtual machine
  • Detaching a .vhd file and downloading and attaching it to your on-premises virtual machine
  • Creating a Docker host with Docker Machine
  • Deploying Docker Registry in Azure
  • Describe Virtual Machines and Cloud Services.
  • Extend workloads to Azure Virtual Machines.
  • Extend Big Compute workloads to Azure.
  • Integrate compute workloads by using containers and Azure Service Fabric.
  • Overview of the Azure Virtual Network service
  • Extending on-premises networks to Azure
  • Preparing your Azure subscription for the implementation
  • Configuring an on-premises virtual machine
  • Testing a point-to-site VPN from an on-premises virtual machine
  • Explain how to use the Azure Virtual Network service.
  • Extend on-premises networks to Azure.
  • Overview of Azure Storage, Data, and Analytics services
  • Implementing Azure Backup for on-premises workloads
  • Preparing your Azure subscription for the implementation
  • Configuring a virtual machine for Azure Backup agent?based backups
  • Testing the backup of the virtual machine files and folders
  • Testing the restore operation of the virtual machine files and folders
  • Describe the Azure Storage, Data, and Analytics services.
  • Implement Azure Backup for on-premises workloads.
  • Overview of Azure Site Recovery
  • Planning for Azure Site Recovery
  • Azure Site Recovery with Azure as the disaster recovery site
  • Using StorSimple to enhance disaster recovery capabilities
  • Preparing your Azure subscription for the implementation
  • Preparing your Hyper-V host for the implementation
  • Configuring the target environment
  • Describe Azure Site Recovery.
  • Plan for Azure Site Recovery.
  • Explain how to use Azure Site Recovery with Azure as the disaster recovery site.
  • Use StorSimple to enhance disaster recovery capabilities
  • Overview of cross-premises application capabilities and design considerations
  • Implementing cross-premises solutions for desktop, web, and mobile apps
  • Creating two instances of an organizational website using the Web Apps feature of Azure App Service
  • Creating and configuring an Azure Traffic Manager profile
  • Testing the distribution of traffic targeting the Azure Traffic Manager profile
  • Describe cross-premises application capabilities and design considerations.
  • Implement cross-premises solutions for desktop, web, and mobile apps.
  • Overview of cross-premises Azure monitoring and management capabilities
  • Implementing cross-premises Azure monitoring and management solutions
  • Creating and configuring an Automation account
  • Creating and configuring an Operations Management Suite account
  • Configuring a target computer
  • Starting the runbook on the on-premises system and examining the outcome
  • Describe cross-premises Azure monitoring and management capabilities.
  • Implement cross-premises Azure monitoring and management solutions.

This course teaches IT professionals how to integrate their on-premises AD DS environment with Azure AD and how to use Azure AD as a directory service. It also teaches candidates how to use Azure RMS to protect sensitive documents. Additionally, it focusses on how to enhance authentication with multi-factor authentication and how to monitor directory synchronization health.

  • Compare Azure AD to AD DS, perform Azure AD tenant provisioning, and manage objects and user roles in Azure AD.
  • Implement and configure directory synchronization and manage synchronized directories.
  • Use Azure AD as a directory service for an on-premises environment, configure single sign-on (SSO) in Azure AD, and protect privileged identities.
  • Implement multi-factor authentication.
  • Implement Azure RMS and integrate Azure RMS with on-premises services.
  • Configure alerts and monitor directory services infrastructure.
  • Original-Microsoft-Training
  • MOC On-Demand is currently available only in English
  • combination of video, text, practical tasks and knowledge tests
  • special offers like discounts are considered when taking the exam.

About Microsoft Official Course On-Demand

The courses are a great alternative for anyone wanting to learn independently and at their own pace. As a participant, you will receive an access to a learning platform developed by Microsoft, providing you with content such as videos, tutorials as well as a Live Lab-Environment for exercises.

As one of the leading Microsoft Learning Partners in Germany, GFN AG works closely with Microsoft together. On request, we can offer you additional services like digital training materials or an individual exam preparation in one of our Training center. For further information, you can also visit the following website MoC On Demand-Infoseite or feel free to contact us.

First published: 21. April 2017



  • AD DS administrators who are looking to train in cloud identity and access technologies.
  • System or infrastructure administrators with general AD DS experience and knowledge, who are looking for more advanced identity training for Azure services.

One more important note, all Microsoft MOC On-Demand courses are currently available in English only. To successfully complete this course, therefore a safe handling like IT-specialized English is essential.


  • Experience with AD DS concepts and technologies in Windows Server 2012 or Windows Server 2016.
  • Experience working with and configuring Windows Server 2012 or Windows Server 2016.
  • Basic experience with Windows PowerShell.
  • Basic experience with cloud services such as Microsoft Office 365.
  • Basic experience with the Azure platform.
  • Basic experience with identities on premises or in cloud.

Recommended system requirements for Microsoft Official Courses On-Demand and labs include:

  • Windows 10
  • Current version of Internet Explorer or Microsoft Edge
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed ActiveX control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required
  • 1280 x 1024 or higher

Note You can also take a MOC On-Demand on your iPad® Retina 4th Generation; however, the lab experience is not optimized for tablets.

Note Regularly scheduled maintenance for the Microsoft Labs Online (MLO) platform is currently at 10?12 P.M. Pacific Time every Thursday. During that time, you may not be able to access the MLO associated with a MOC On-Demand.

The minimum system requirements for MOC On-Demand and labs include:

  • Windows 7 or later
  • Internet Explorer 9 or later
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed Active X control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required

This Online-Training covers the following topics:

  • Azure AD overview
  • Implementing and configuring Azure AD
  • Managing Azure AD
  • Activating an Azure trial subscription
  • Creating an Azure AD tenant and objects in Azure AD
  • Configuring user roles in Azure AD
  • Describe Azure AD and compare it to AD DS.
  • Explain Azure AD versions and describe how to perform Azure AD tenant provisioning.
  • Manage objects and user roles in Azure AD.
  • Extending an on-premises Active Directory domain to Azure
  • Directory synchronization overview
  • Implementing and configuring directory synchronization
  • Managing synchronized directories
  • Implementing Azure AD Connect
  • Managing directory synchronization
  • Explain how to extend AD DS to the Azure platform.
  • Describe directory synchronization.
  • Implement and configure directory synchronization.
  • Manage synchronized directories.
  • Azure AD as a directory service for on-premises environments
  • Configuring SSO with Azure AD
  • Implementing privileged identity management in Azure AD
  • Joining a Windows 10 computer to Azure AD
  • Implementing SSO with Azure AD
  • Configuring and using Azure AD Privileged Identity Management
  • Describe how to use Azure AD as a directory service for an on-premises environment.
  • Configure SSO in Azure AD.
  • Explain how to protect privileged identities.
  • Authentication in hybrid environments
  • Implementing Azure Multi-Factor Authentication
  • Implementing self-service password reset
  • Implementing Azure Multi-Factor Authentication
  • Implementing Azure Multi-Factor Authentication Server on-premises
  • Describe how authentication works.
  • Implement Azure Multi-Factor Authentication.
  • RMS overview
  • Implementing Azure RMS
  • Integrating Azure RMS with on-premises services
  • Enabling and configuring Azure RMS
  • Integrating Azure RMS with File Classification Infrastructure (FCI)
  • Using the RMS sharing application on a client
  • Describe the rights management technologies, AD RMS and Azure RMS.
  • Implement Azure RMS.
  • Integrate Azure RMS with on-premises services.
  • Azure AD reporting
  • Monitoring Azure AD
  • Configuring Azure AD reports and notifications
  • Configuring Azure AD monitoring
  • Describe reports on Azure AD and describe how to configure alerts.
  • Monitor directory services infrastructure.

The main purpose of the course is to give students the ability to add analysis capabilities to Excel spreadsheets and to provide students with a foundation to learn about more advanced data analytics with Excel or Power BI.

  • Create an Excel report
  • Create an Excel table
  • Create a pivot table and pivot chart
  • Create a dashboard and analyze data
  • Create Hierarchies
  • Create an Excel data model and connect to external data
  • Original-Microsoft-Training
  • MOC On-Demand is currently available only in English
  • combination of video, text, practical tasks and knowledge tests
  • special offers like discounts are considered when taking the exam.

About Microsoft Official Course On-Demand

The courses are a great alternative for anyone wanting to learn independently and at their own pace. As a participant, you will receive an access to a learning platform developed by Microsoft, providing you with content such as videos, tutorials as well as a Live Lab-Environment for exercises.

As one of the leading Microsoft Learning Partners in Germany, GFN AG works closely with Microsoft together. On request, we can offer you additional services like digital training materials or an individual exam preparation in one of our Training center. For further information, you can also visit the following website MoC On Demand-Infoseite or feel free to contact us.

First published: 21. April 2017



This course is intended for anyone who wants to take the data analysis technologies in Excel beyond formulas and add more advanced capabilities such as dashboards, hierarchies, and relationships.

One more important note, all Microsoft MOC On-Demand courses are currently available in English only. To successfully complete this course, therefore a safe handling like IT-specialized English is essential.


  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Advanced working knowledge of Excel spreadsheets including formulas.

Recommended system requirements for Microsoft Official Courses On-Demand and labs include:

  • Windows 10
  • Current version of Internet Explorer or Microsoft Edge
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed ActiveX control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required
  • 1280 x 1024 or higher

Note You can also take a MOC On-Demand on your iPad® Retina 4th Generation; however, the lab experience is not optimized for tablets.

Note Regularly scheduled maintenance for the Microsoft Labs Online (MLO) platform is currently at 10?12 P.M. Pacific Time every Thursday. During that time, you may not be able to access the MLO associated with a MOC On-Demand.

The minimum system requirements for MOC On-Demand and labs include:

  • Windows 7 or later
  • Internet Explorer 9 or later
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed Active X control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required

This Online-Training covers the following topics:

  • Filtering and Formatting Data
  • Charts
  • Filtering Excel Data
  • Formatting Excel Data
  • Create excel Charts
  • Filter and format data.
  • Create charts.
  • Excel Data Tables
  • Summarizing Data
  • Create an Excel Table
  • Summarize Excel Data
  • Explain what Excel Data tables are.
  • Sort, filter, and validate data.
  • Summarize data.
  • Format summarized data.
  • Pivot Tables
  • Pivot Charts
  • Editing Pivot Tables and Pivot Charts
  • Creating a Pivot Table
  • Creating a Pivot Chart
  • Editing Pivot Tables and Pivot Charts
  • Describe pivot tables and how to create them.
  • Describe the various elements of a pivot chart.
  • Edit pivot tables and pivot charts.
  • Creating a Dashboard
  • Data Analysis in Excel Pivot Tables
  • Arranging Tables and Charts
  • Slicing Data
  • Data Analysis
  • Describe a dashboard.
  • Filter data using a slicer.
  • Add calculated columns to a dashboard.
  • Find anomalies.
  • Hierarchies
  • Time Data
  • Create a Hierarchy
  • Configure Time data
  • Create an Animated Time Chart
  • Describe hierarchies.
  • Create levels within a hierarchy.
  • Explain why time data is different and how to work with it.
  • Using an Excel Data Model
  • External Data
  • Add Multiple Tables
  • Create Relationships
  • Add External Data
  • Explain an Excel Data Model and how to use it.
  • Import External Data and use it.
  • Link out to external data.

This is a three-day Instructor Led Training (ILT) course that targets the needs of information technology (IT) professionals who take part in administering, configuring, troubleshooting, and operatingOffice 365 services, including its identities, dependencies, requirements, and supporting technologies. This course focuses on skills required to administer and troubleshoot Office 365 tenant and key services of Office 365, such as Exchange Online, SharePoint Online and Skype for Business. It also covers security and compliance features of Office 365.

  • Describe Office 365 services.
  • Administer Office 365 by using graphical user interface (GUI) and Windows PowerShell.
  • Administer and troubleshoot directory synchronization and directory objects.
  • Administer and troubleshoot Skype for Business.
  • Administer and troubleshoot SharePoint Online.
  • Administer and troubleshoot Office 365 ProPlus.
  • Administer and troubleshoot compliance and security in Office 365.
  • Original-Microsoft-Training
  • MOC On-Demand is currently available only in English
  • combination of video, text, practical tasks and knowledge tests
  • special offers like discounts are considered when taking the exam.

About Microsoft Official Course On-Demand

The courses are a great alternative for anyone wanting to learn independently and at their own pace. As a participant, you will receive an access to a learning platform developed by Microsoft, providing you with content such as videos, tutorials as well as a Live Lab-Environment for exercises.

As a Microsoft Gold Learning Partner, GFN AG works closely with Microsoft together. On request, we can offer you additional services like digital training materials or an individual exam preparation in one of our Training center. For further information, you can also visit the following website MoC On Demand-Infoseite or feel free to contact us.



This course is intended for both novice and experienced programmers who have a minimum of three months programming experience and have basic Windows navigation skills.This course is intended for IT professionals and system administrators who want to learn about administration and troubleshooting techniques in Office 365. These professionals should have at least three years of experience working in their respective fields?typically in the areas of system administration, network administration, and messaging.


  • A minimum of two years of experience administering the Windows Server operating system, including Windows Server 2012 or newer.
  • A minimum of one year of experience working with Active Directory Domain Services (AD DS).
  • A minimum of one year of experience working with name resolution, including DNS.
  • Experience working with certificates, including public key infrastructure (PKI) certificates.
  • Experience working with Windows PowerShell.
  • Experience working with Exchange Server 2013 or newer, Lync 2013 Server or Skype for Business 2015 Server, and SharePoint Server 2013 or newer is beneficial but not required.
  • Understanding of Microsoft cloud services.
  • Understanding of the Office 365 platform.

Recommended system requirements for Microsoft Official Courses On-Demand and labs include:

  • Windows 10
  • Current version of Internet Explorer or Microsoft Edge
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed ActiveX control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required
  • 1280 x 1024 or higher

Note You can also take a MOC On-Demand on your iPad® Retina 4th Generation; however, the lab experience is not optimized for tablets.

Note Regularly scheduled maintenance for the Microsoft Labs Online (MLO) platform is currently at 10?12 P.M. Pacific Time every Thursday. During that time, you may not be able to access the MLO associated with a MOC On-Demand.

The minimum system requirements for MOC On-Demand and labs include:

  • Windows 7 or later
  • Internet Explorer 9 or later
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed Active X control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required

This Online-Training covers the following topics:

  • Overview of Office 365 services
  • Office 365 licensing overview
  • Office 365 tenant configuration
  • Office 365 clients
  • Managing Office 365 with administrative portals
  • Managing Office 365 with Windows PowerShell
  • Managing administrative access in Office 365
  • Troubleshooting administration in Office 365
  • Directory synchronization and federation overview
  • Azure AD Connect management
  • Managing users and groups objects in Office 365
  • Troubleshooting objects and directory synchronization in Office 365
  • Overview of Exchange Online management
  • Administering Exchange Online recipients
  • Administering client access policies in Exchange Online
  • Troubleshooting Exchange Online
  • Skype for Business management overview
  • Administering users and connectivity in Skype for Business
  • Troubleshooting Skype for Business
  • SharePoint Online management overview
  • Administering SharePoint Online site collections
  • Administering external users in SharePoint Online
  • Configuring OneDrive for Business
  • Troubleshooting SharePoint Online
  • Overview of Office 365 ProPlus
  • Managing user-driven Office 365 ProPlus deployments
  • Troubleshooting Office 365 ProPlus deployments
  • Overview of compliance features in Office 365
  • Administering Azure Rights Management in Office 365
  • Administering compliance features in Office 365
  • Configuring and administering email security in Office 365
  • Troubleshooting Office 365 compliance and protection






This course is aimed at database professionals looking to implement SQL Server on Linux.

  • Describe key capabilities and components of SQL Server on Linux
  • Describe how to deploy SQL Server on Linux
  • Describe how to install the additional optional components to SQL Server
  • Describe how to configure SQL Server on Linux
  • Describe how to connect and manage SQL server images on Linux
  • Describe how to migrate databases from other database systems to SQL Server on Linux and provide disaster recovery
  • Describe the high availability features of SQL Server on Linux
  • Original-Microsoft-Training
  • MOC On-Demand is currently available only in English
  • combination of video, text, practical tasks and knowledge tests
  • special offers like discounts are considered when taking the exam.

About Microsoft Official Course On-Demand

The courses are a great alternative for anyone wanting to learn independently and at their own pace. As a participant, you will receive an access to a learning platform developed by Microsoft, providing you with content such as videos, tutorials as well as a Live Lab-Environment for exercises.

As a Microsoft Gold Learning Partner, GFN AG works closely with Microsoft together. On request, we can offer you additional services like digital training materials or an individual exam preparation in one of our Training center. For further information, you can also visit the following website MoC On Demand-Infoseite or feel free to contact us.

First published: 26. April 2018



The primary audience for this course is existing database professionals with experience of database systems running on Linux.

The secondary audience is Linux professionals who are interested in adding database capabilities.


Recommended system requirements for Microsoft Official Courses On-Demand and labs include:

  • Windows 10
  • Current version of Internet Explorer or Microsoft Edge
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed ActiveX control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required
  • 1280 x 1024 or higher

Note You can also take a MOC On-Demand on your iPad® Retina 4th Generation; however, the lab experience is not optimized for tablets.

Note Regularly scheduled maintenance for the Microsoft Labs Online (MLO) platform is currently at 10?12 P.M. Pacific Time every Thursday. During that time, you may not be able to access the MLO associated with a MOC On-Demand.

The minimum system requirements for MOC On-Demand and labs include:

  • Windows 7 or later
  • Internet Explorer 9 or later
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed Active X control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required


This course provides students with the knowledge and skills that are required to plan, deploy, configure, and administer a Skype for Business 2015 solution. Students will learn how to deploy a multi-site and highly available Skype for Business infrastructure that supports instant messaging, conferencing, Persistent Chat, archiving, and monitoring. Students will also learn how to manage and maintain the infrastructure and how to troubleshoot issues that might arise. This course focuses primarily on an on-premises Skype for Business deployment, but it does include information on how to integrate an on-premises deployment with Skype for Business Online and how to migrate from previous versions of Lync Server. This course helps students prepare for Exam 70-334.

  • Describe the Skype for Business 2015 architecture and design a Skype for Business 2015 topology.
  • Install and implement Skype for Business Server 2015.
  • Administer Skype for Business Server 2015 by using various tools.
  • Configure users and clients in Skype for Business 2015.
  • Configure and implement conferencing in Skype for Business 2015.
  • Implement additional conferencing options, such as dial-in conferencing, Microsoft Lync Room System (LRS), and Skype Meeting Broadcast.
  • Design and implement monitoring and archiving in Skype for Business 2015.
  • Deploy Skype for Business 2015 external access.
  • Implement Persistent Chat in Skype for Business 2015.
  • Implement high availability in Skype for Business 2015.
  • Implement disaster recovery in Skype for Business 2015.
  • Design and deploy a hybrid Skype for Business environment.
  • Plan and implement an upgrade from Lync Server to Skype for Business Server 2015.
  • Original-Microsoft-Training
  • MOC On-Demand is currently available only in English
  • combination of video, text, practical tasks and knowledge tests
  • special offers like discounts are considered when taking the exam.

About Microsoft Official Course On-Demand

The courses are a great alternative for anyone wanting to learn independently and at their own pace. As a participant, you will receive an access to a learning platform developed by Microsoft, providing you with content such as videos, tutorials as well as a Live Lab-Environment for exercises.

As one of the leading Microsoft Learning Partners in Germany, GFN AG works closely with Microsoft together. On request, we can offer you additional services like digital training materials or an individual exam preparation in one of our Training center. For further information, you can also visit the following website MoC On Demand-Infoseite or feel free to contact us.

First published: 07. July 2016



  • information technology (IT) professionals who are responsible for the Skype for Business 2015 deployment in their organizations. Experience with previous versions of Lync Server is beneficial but not required to take this course. Students should be proficient with Active Directory Domain Services (AD DS), data networks, and telecommunications standards and components that support the configuration of Skype for Business. Students should also be familiar with Microsoft Exchange Server and Microsoft Office 365.
  • IT professionals who are planning to take the exam 70-334: Core Solutions of Skype for Business 2015 as a stand-alone exam or as part of the requirement for the Microsoft Certified Solutions Expert (MCSE): Communications certification exam.

One more important note, all Microsoft MOC On-Demand courses are currently available in English only. To successfully complete this course, therefore a safe handling like IT-specialized English is essential.


  • A minimum of two years of experience administering Windows Server 2012 or Windows Server 2008 R2.
  • A minimum of two years of experience working with AD DS.
  • A minimum of two years of experience working with name resolution, including Domain Name System (DNS).
  • Experience working with certificates, including public key infrastructure (PKI) certificates.
  • Experience working with the Windows PowerShell command-line interface.
  • An understanding of data networks and telecommunications standards and components.

Recommended system requirements for Microsoft Official Courses On-Demand and labs include:

  • Windows 10
  • Current version of Internet Explorer or Microsoft Edge
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed ActiveX control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required
  • 1280 x 1024 or higher

Note You can also take a MOC On-Demand on your iPad® Retina 4th Generation; however, the lab experience is not optimized for tablets.

Note Regularly scheduled maintenance for the Microsoft Labs Online (MLO) platform is currently at 10?12 P.M. Pacific Time every Thursday. During that time, you may not be able to access the MLO associated with a MOC On-Demand.

The minimum system requirements for MOC On-Demand and labs include:

  • Windows 7 or later
  • Internet Explorer 9 or later
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed Active X control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required

This Online-Training covers the following topics:

  • Overview of Skype for Business Components and Features
  • Introduction to the Skype for Business Administrative Tools
  • Server and Service Dependencies
  • Planning SIP Domains
  • Installing Skype for Business Server
  • Integrating Skype for Business Server with Exchange Server and SharePoint Server
  • Using Skype for Business Server Control Panel
  • Using the Skype for Business Server Management Shell
  • Implementing Role-Based Access Control
  • Using Test Cmdlets
  • Tools for Troubleshooting Skype for Business
  • Configuring Users
  • Deploying the Skype for Business Client
  • Registration, Sign-In, and Authentication
  • Configuring Skype for Business Client Policies
  • Managing the Skype for Business Address Book
  • Introducion to Conferencing in Skype for Business 2015
  • Integrating Skype for Business Server and Office Online Server
  • Bandwidth Planning
  • Configuring Conferencing Settings
  • Overview of the Conferencing Lifecycle
  • Designing and Configuring Audio/Video and Web Conferencing Policies
  • Deploying Dial-In Conferencing
  • Configuring an LRS
  • Configuring Large Meetings and Skype Meeting Broadcasts
  • Components of the Monitoring Service
  • Overview of Archiving
  • Designing an Archiving Policy
  • Implementing Archiving
  • Overview of External Access
  • Configuring External Access Policies and Security
  • Configuring External Access Network and Certificates
  • Configuring Reverse Proxy
  • Designing Mobility in Skype for Business Server
  • Designing Federation in Skype for Business Server
  • Designing a Persistent Chat Server Topology
  • Deploying Persistent Chat Server
  • Configuring and Managing Persistent Chat
  • Planning for Front End Pool High Availability
  • Planning for Back End Server High Availability
  • High Availability for Other Component Servers
  • Disaster Recovery Options in Skype for Business Server
  • Implementing Disaster Recovery in Skype for Business Server
  • Additional Disaster Recovery Options in Skype for Business Server
  • Overview of Skype for Business Online
  • Preparing for a Hybrid Skype for Business Deployment
  • Configuring a Hybrid Skype for Business Environment
  • Overview of Upgrade and Migration Paths
  • Migrating to Skype for Business 2015
  • In-Place Upgrade to Skype for Business Server 2015

This course will provide you with the knowledge and skills to plan and administer a Microsoft SharePoint 2016 environment. The course teaches you how to deploy, administer, and troubleshoot your SharePoint environment. This course also provides guidelines, best practices, and considerations that help you optimize your SharePoint deployment. This is the first in a sequence of two courses for IT professionals and is aligned with the SharePoint 2016 IT Pro certification.

  • Describe the key features of SharePoint 2016.
  • Design an information architecture for a SharePoint 2016 deployment.
  • Design a logical architecture for a SharePoint 2016 deployment.
  • Design the physical architecture for a SharePoint 2016 deployment.
  • Install and configure SharePoint 2016.
  • Create and configure web applications and site collections.
  • Plan and configure service applications for a SharePoint 2016 deployment.
  • Manage users and permissions, and secure content in a SharePoint 2016 deployment.
  • Configure authentication in a SharePoint 2016 deployment.
  • Configure platform and farm-level security in a SharePoint 2016 deployment.
  • Manage information taxonomy in SharePoint web applications and site collections.
  • Configure and manage user profiles and audiences.
  • Configure and manage the search experience in SharePoint 2016.
  • Monitor, maintain, and troubleshoot a SharePoint 2016 deployment.
  • Original-Microsoft-Training
  • MOC On-Demand is currently available only in English
  • combination of video, text, practical tasks and knowledge tests
  • special offers like discounts are considered when taking the exam.

About Microsoft Official Course On-Demand

The courses are a great alternative for anyone wanting to learn independently and at their own pace. As a participant, you will receive an access to a learning platform developed by Microsoft, providing you with content such as videos, tutorials as well as a Live Lab-Environment for exercises.

As one of the leading Microsoft Learning Partners in Germany, GFN AG works closely with Microsoft together. On request, we can offer you additional services like digital training materials or an individual exam preparation in one of our Training center. For further information, you can also visit the following website MoC On Demand-Infoseite or feel free to contact us.

First published: 11. May 2017



The course is targeted at experienced IT professionals who are interested in learning how to install, configure, deploy, and manage SharePoint 2016 installations either in a data center or in the cloud.

Students typically have more than one year of hands-on experience* with planning and maintaining SharePoint and two years? experience with other core technologies on which SharePoint depends, including Windows Server 2012 R2 or later, Internet Information Services (IIS), Microsoft SQL Server 2014 or later, Active Directory Domain Services (AD DS), and networking infrastructure services.

  • Is an IT professional who plans, implements, and maintains a multi-server deployment of SharePoint 2016.
  • Has a working knowledge of, and preferably hands-on experience, with SharePoint Online.
  • Has broad familiarity with SharePoint workloads.
  • Has experience with business continuity management, including data backup, restoration, and high availability.
  • Has experience with authentication and security technologies.
  • Has experience with Windows PowerShell.

* The hands-on experience or job experience should be from a solutions-based role where the candidate has worked on multiple solutions in the SharePoint space that includes document management, content management, and search.

One more important note, all Microsoft MOC On-Demand courses are currently available in English only. To successfully complete this course, therefore a safe handling like IT-specialized English is essential.


  • Software management in a Windows Server 2012 or Windows Server 2012 R2 enterprise server environment.
  • Deploying and managing applications natively, virtually, and in the cloud.
  • Administering IIS.
  • Configuring AD DS for use in authentication, authorization, and as a user store.
  • Managing an application remotely by using Windows PowerShell 4.0.
  • Managing databases and server roles in SQL Server.
  • Connecting applications to SQL Server.
  • Implementing claims-based security.
  • Using Microsoft Hyper-V virtual machines.

An ideal candidate for this course must have at least one year of experience with deploying and administering multiple SharePoint 2013 farms across a large enterprise. Because many customers have not upgraded from SharePoint 2010, a candidate can also have at least two years of experience with SharePoint 2010. However, they also must understand the differences between SharePoint 2010 and SharePoint 2013, particularly in terms of hybridization.

Recommended system requirements for Microsoft Official Courses On-Demand and labs include:

  • Windows 10
  • Current version of Internet Explorer or Microsoft Edge
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed ActiveX control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required
  • 1280 x 1024 or higher

Note You can also take a MOC On-Demand on your iPad® Retina 4th Generation; however, the lab experience is not optimized for tablets.

Note Regularly scheduled maintenance for the Microsoft Labs Online (MLO) platform is currently at 10?12 P.M. Pacific Time every Thursday. During that time, you may not be able to access the MLO associated with a MOC On-Demand.

The minimum system requirements for MOC On-Demand and labs include:

  • Windows 7 or later
  • Internet Explorer 9 or later
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed Active X control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required

This Online-Training covers the following topics:

  • Key components of a SharePoint deployment
  • New features in SharePoint 2016
  • SharePoint 2016 deployment options
  • Identify the architecture and capabilities of SharePoint 2016.
  • Identify new and deprecated features in SharePoint 2016.
  • Identify deployment options for SharePoint 2016.
  • Identifying business requirements
  • Understanding business requirements
  • Organizing information in SharePoint 2016
  • Planning for discoverability
  • Identifying site columns and content types
  • Designing a business taxonomy
  • Explain how understanding business requirements drives the design of an organizational information architecture.
  • Describe the key components available in SharePoint 2016 to deploy an information architecture.
  • Plan for discoverability as part of an information architecture deployment.
  • Overview of the SharePoint 2016 logical architecture
  • Documenting your logical architecture
  • Planning a logical architecture
  • Producing a logical architecture diagram
  • Map business requirements to SharePoint 2016 architecture components.
  • Explain the importance of documentation and describe the options for documenting the logical architecture.
  • Designing physical components for SharePoint deployments
  • Designing supporting components for SharePoint deployments
  • SharePoint farm topologies
  • Mapping a logical architecture design to a physical architecture design
  • Designing a physical architecture
  • Developing a physical architecture design diagram
  • Describe the requirements for the physical components that are needed for a SharePoint 2016 deployment.
  • Describe the requirements for the supporting components that are needed for a successful SharePoint 2016 deployment.
  • Identify SharePoint farm topologies.
  • Map a logical architecture design to a physical architecture design.
  • Installing SharePoint 2016
  • Scripting installation and configuration of SharePoint
  • Configuring SharePoint 2016 farm settings
  • Provisioning a SharePoint 2016 farm
  • Configuring incoming email
  • Configuring outgoing email
  • Configuring integration with Office Online Server
  • Install SharePoint 2016.
  • Deploy and configure SharePoint 2016.
  • Script the installation and configuration of SharePoint 2016.
  • Configure SharePoint 2016 farm settings.
  • Creating web applications
  • Configuring web applications
  • Creating and configuring site collections
  • Creating a web application
  • Configuring a web application
  • Creating and configuring site collections
  • Creating a site collection in a new content database
  • Using Fast Site Collection Creation
  • Create web applications.
  • Configure web applications.
  • Create and configure site collections.
  • Introduction to the service application architecture
  • Creating and configuring service applications
  • Provisioning a Managed Metadata Service application with Central Administration
  • Provisioning a Managed Metadata Service application with Windows PowerShell
  • Configuring the Word Automation Services service application for document conversion
  • Configuring service application proxy groups
  • Explain the key components and topologies for a SharePoint 2016 service application architecture.
  • Plan for service accounts and service application dependencies.
  • Understand the purpose of mapping service applications to business requirements.
  • Describe how to provision and manage SharePoint 2016 service applications
  • Configuring authorization in SharePoint 2016
  • Managing access to content
  • Creating a web-application policy
  • Creating and managing SharePoint groups
  • Creating custom permission levels
  • Managing permissions and inheritance
  • Managing site-collection security
  • Enabling anonymous access to a site
  • Manage users and permissions in SharePoint 2016.
  • Manage access to content in SharePoint 2016.
  • Overview of authentication
  • Configuring federated authentication
  • Configuring server-to-server authentication
  • Configuring Microsoft SharePoint 2016 to use federated identities
  • Configuring Active Directory Federation Services (AD FS) to enable a web application a relying party
  • Configuring SharePoint to trust AD FS as an identity provider
  • Configuring a web application to use the AD FS identity provider
  • Explain the authentication infrastructure of SharePoint 2016.
  • Configure claims providers and identity federation for SharePoint 2016.
  • Configure server-to-server authentication for SharePoint 2016.
  • Securing the platform
  • Configuring farm-level security
  • Configuring SharePoint Server communication security
  • Hardening a SharePoint server farm
  • Configuring blocked file types
  • Configuring Web Part security
  • Implementing security auditing
  • Secure a SharePoint 2016 deployment at the platform level.
  • Configure farm-level security settings for a SharePoint 2016 deployment.
  • Managing content types
  • Understanding managed metadata
  • Configuring the managed metadata service
  • Creating content types for propagation
  • Publishing content types across site collections
  • Configuring the managed metadata service
  • Creating term sets and terms
  • Consuming term sets
  • Create and manage content types and content-type propagation.
  • Explain how to implement managed metadata in SharePoint web applications and site collections.
  • Configure the managed metadata service application in SharePoint 2016.
  • Configuring the User Profile Service Application
  • Managing user profiles and audiences
  • Configuring the User Profile Service Application
  • Configuring directory import and synchronization
  • Configuring My Sites
  • Configuring audiences
  • Configure the User Profile service application.
  • Manage user profiles and audiences.
  • Understanding the Search Service Application architecture
  • Configuring Enterprise Search
  • Managing Enterprise Search
  • Configuring the Search Service Application
  • Configuring a file share content source
  • Configuring a local SharePoint content source
  • Creating a search center
  • Configuring a result source and a query rule
  • Customizing the search experience
  • Creating and deploying a thesaurus
  • Configuring entity extractors and refiners
  • Managing query spelling correction
  • Describe the Search service architecture in SharePoint 2016.
  • Configure the Search service in SharePoint 2016.
  • Manage the search experience in SharePoint 2016.
  • Monitoring a SharePoint 2016 environment
  • Tuning and optimizing a SharePoint 2016 environment
  • Planning and configuring caching
  • Troubleshooting a SharePoint 2016 environment
  • Configuring usage and health data collection
  • Configuring Sharepoint diagnostic logging
  • Configuring Health Analyzer rules
  • Reviewing usage and health data
  • Analyzing network traffic
  • Analyzing SharePoint page performance
  • Develop and implement a monitoring plan for a SharePoint 2016 environment.
  • Tune and optimize a SharePoint 2016 server farm on an ongoing basis.
  • Plan and configure caching to improve the performance of a SharePoint 2016 deployment.
  • Troubleshoot errors and other issues in a SharePoint 2016 deployment

This course will teach you how to plan, configure, and manage the advanced features in a SharePoint 2016 environment. The special areas of focus for this course include implementing high availability,disaster recovery, service application architecture, and Microsoft Business Connectivity Services. This course also focuses on social computing features, productivity, and collaboration platforms andfeatures. Students also will learn about business intelligence solutions, Enterprise Content Management, web content management infrastructure, solutions, and apps. This course also covers how to develop and implement a governance plan, and how to perform an upgrade or a migration to SharePoint 2016. This is the second in a sequence of two courses for IT Professionals and is aligned with the SharePoint 2016 IT Pro certification.

  • Describe the core SharePoint 2016 architecture and its new and improved features.
  • Describe the key hybrid features in SharePoint 2016.
  • Plan and design a SharePoint 2016 environment to meet requirements for high availability and disaster recovery.
  • Plan and implement Business Connectivity Services and Secure Store Service.
  • Configure and manage productivity services for a SharePoint 2016 deployment.
  • Manage solutions in a SharePoint 2016 deployment.
  • Plan and configure social computing features.
  • Plan and configure web content management for an Internet-facing environment.
  • Plan and configure Enterprise Content Management in a SharePoint 2016 deployment.
  • Plan and configure business intelligence solutions.
  • Plan and configure work management, productivity, and collaboration platforms and features.
  • Perform an upgrade or migration to SharePoint 2016.
  • Original-Microsoft-Training
  • MOC On-Demand is currently available only in English
  • combination of video, text, practical tasks and knowledge tests
  • special offers like discounts are considered when taking the exam.

About Microsoft Official Course On-Demand

The courses are a great alternative for anyone wanting to learn independently and at their own pace. As a participant, you will receive an access to a learning platform developed by Microsoft, providing you with content such as videos, tutorials as well as a Live Lab-Environment for exercises.

As one of the leading Microsoft Learning Partners in Germany, GFN AG works closely with Microsoft together. On request, we can offer you additional services like digital training materials or an individual exam preparation in one of our Training center. For further information, you can also visit the following website MoC On Demand-Infoseite or feel free to contact us.

First published: 11. May 2017



The course is targeted at experienced IT Professionals who are interested in learning how to install, configure, deploy, and manage SharePoint 2016 installations either in a data center or in the cloud. Students typically should have more than four years of hands-on experience* planning and maintaining SharePoint Server and other core technologies upon which SharePoint depends, including Windows Server 2012 R2 or later, Internet Information Services (IIS), Microsoft SQL Server 2014 R2 or later, Active Directory Domain Services (AD DS), and networking infrastructure services. Students should have completed Course 20339-1A: Planning and Administering Microsoft SharePoint 2016, or have gained equivalent knowledge and experience before taking this course.

  • Has a working knowledge of, and preferably hands-on experience, with Microsoft SharePoint Online.
  • Has broad familiarity with SharePoint Server workloads.
  • Has experience with business continuity management, including data backup, restoration, and high availability.
  • Has experience with authentication and security technologies.
  • Has experience with Windows PowerShell.

* The hands-on experience or job experience should be from a solutions-based role where the candidate has worked on multiple solutions in the SharePoint Server space that includes document management, content management, and search.

One more important note, all Microsoft MOC On-Demand courses are currently available in English only. To successfully complete this course, therefore a safe handling like IT-specialized English is essential.


  • At least a one-year experience of mapping business requirements to both logical and physical technical designs.
  • Working knowledge of network design, including network security.
  • Software management experience in a Windows Server 2012 R2 enterprise server or Windows Server 2016 environment.
  • Deploying and managing applications natively, virtually, and in the cloud.
  • Administering IIS.
  • Configuring AD DS for use in authentication and authorization, and as a user store.
  • Managing an application remotely by using Windows PowerShell 2.0 or later.
  • Connecting applications to SQL Server.
  • Implementing claims-based security.

An ideal candidate for this course must have at least one year experience with deploying and administering multiple SharePoint Server 2013 farms across a large enterprise. The candidate should have completed Course 20339-1A: Planning and Administering Microsoft SharePoint 2016, or should demonstrate equivalent skills.

Recommended system requirements for Microsoft Official Courses On-Demand and labs include:

  • Windows 10
  • Current version of Internet Explorer or Microsoft Edge
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed ActiveX control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required
  • 1280 x 1024 or higher

Note You can also take a MOC On-Demand on your iPad® Retina 4th Generation; however, the lab experience is not optimized for tablets.

Note Regularly scheduled maintenance for the Microsoft Labs Online (MLO) platform is currently at 10?12 P.M. Pacific Time every Thursday. During that time, you may not be able to access the MLO associated with a MOC On-Demand.

The minimum system requirements for MOC On-Demand and labs include:

  • Windows 7 or later
  • Internet Explorer 9 or later
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed Active X control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required

This Online-Training covers the following topics:

  • Core components of the SharePoint 2016 architecture
  • New, deprecated, and removed features in SharePoint 2016
  • SharePoint 2016 and SharePoint Online editions
  • Configuring SharePoint 2016 farms
  • Creating and configuring site collections and sites
  • Provisioning service applications by using the SharePoint 2016 Management Shell
  • Describe the architectural features of a Microsoft-SharePoint 2016.
  • Identify the new, deprecated, and removed features in SharePoint 2016.
  • Describe the editions for SharePoint 2016 on-premises and Microsoft SharePoint Online.
  • Exploring the hybrid features in SharePoint 2016
  • Preparing for a hybrid SharePoint 2016 deployment
  • Creating an Office 365 tenant
  • Preparing the SharePoint environment
  • Running the SharePoint Hybrid picker
  • Describe the key hybrid features in SharePoint Server 2016.
  • Prepare for a hybrid SharePoint 2016 deployment.
  • Designing database topologies for high availability and disaster recovery
  • Designing a SharePoint infrastructure for high availability
  • Planning for disaster recovery
  • Create a backup and restore plan
  • Test the backup and restore process
  • Select an appropriate database server configuration to meet availability requirements.
  • Design a physical architecture and infrastructure to meet high-availability requirements.
  • Develop and implement a backup and restore strategy.
  • Planning and configuring BCS
  • Configuring the Secure Store Service
  • Managing BCS models
  • Configuring the BDC Service Application
  • Configuring the Secure Store Service
  • Configuring a Secure Store Service target application
  • Importing and configuring BDC models
  • Plan and Configure Business Connectivity service application.
  • Plan and configure  the Secure Store Service application.
  • Manage the Business Data Connectivity models.
  • Understanding the SharePoint Add-in architecture
  • Provisioning and managing apps and App Catalogs
  • Provisioning productivity services
  • Configuring a SharePoint farm to support apps
  • Creating and configuring a corporate App Catalog
  • Deploying and monitoring apps
  • Describe Microsoft SharePoint Add-ins and the supporting SharePoint infrastructure.
  • Provision and configure SharePoint Add-ins and App Catalogs.
  • Manage how apps are used within a SharePoint 2016 deployment.
  • Understanding the SharePoint 2016 solution architecture
  • Managing sandboxed solutions
  • Configuring a SharePoint farm to support sandboxed solutions
  • Configuring a SharePoint site to support sandboxed solutions
  • Deploying farm solutions
  • Manage features and solutions in Microsoft SharePoint 2016..
  • Manage sandboxed solutions in a SharePoint 2016 deployment.
  • Managing user profiles
  • Enabling social interaction
  • Building communities
  • Configuring profile synchronization
  • Configuring My Sites
  • Creating a community site infrastructure
  • Configuring Community Site participation
  • Manage user profiles in Microsoft SharePoint 2016 and configure user profile synchronization by using Microsoft Identity Manager (MIM) 2016.
  • Enable social interaction in SharePoint 2016.
  • Build communities and community sites in SharePoint 2016.
  • Planning and implementing a web content management infrastructure
  • Configuring managed navigation and catalog sites
  • Supporting multiple languages and locales
  • Enabling design and customization
  • Supporting mobile users
  • Configuring a product catalog site
  • Configuring Cross-Site Publishing
  • Configuring publishing sites
  • Configuring device channels
  • Plan and configure a web content management infrastructure.
  • Configure managed navigation and product catalog sites.
  • Plan and Configure support for multilingual sites and locales.
  • Manage design and customization for publishing sites.
  • Plan and configure support for mobile users.
  • Planning Enterprise Content Management
  • Planning and configuring eDiscovery
  • Planning records management
  • Creating and configuring an eDiscovery Center
  • Discovering and preserving content
  • Querying and exporting content
  • Configuring in-place records management
  • Plan how to manage content and documents.
  • Plan and configure eDiscovery.
  • Plan records management and compliance.
  • Planning BI architecture
  • Planning, deploying, and managing BI services
  • Planning and configuring advanced analysis tools
  • Deploy Office Online Server
  • Configuring PowerPivot for SharePoint 2016
  • Configuring Power View for SharePoint
  • Explain the Microsoft SharePoint business intelligence (BI) architecture, its components, and plan for business intelligence.
  • Plan, deploy, and manage the core Microsoft SharePoint 2016 BI services.
  • Configure the advanced BI options available in SharePoint 2016 and Microsoft SQL Server 2014.
  • Planning and configuring collaboration features
  • Planning and configuring composites
  • Creating an Office Online Server farm and configuring integration in SharePoint 2016
  • Creating project sites
  • Configuring project sites
  • Engaging project teams
  • Configuring Project Server integration
  • Configuring Microsoft Azure Workflow and Microsoft SharePoint Workflow Services
  • Creating and testing a workflow
  • Describe how to plan and configure SharePoint collaborative and coauthoring options.
  • Configure project sites and engage teams.
  • Plan and configure composites.
  • Configure workflows in SharePoint 2016.
  • Preparing for an upgrade or migration
  • Upgrade to SharePoint 2016
  • Planning and managing a site-collection upgrade
  • Migrating SharePoint Server 2013 Managed Metadata Service
  • Upgrading a SharePoint Server 2013 content database
  • Preparing site collections for upgrade
  • Upgrading site collections
  • Plan and prepare for an upgrade.
  • Perform upgrades to data and service applications.
  • Upgrade site collections.
  • Upgrade advanced content from SharePoint Server 2013 to SharePoint 2016.

This course teaches IT professionals how to administer and support Exchange Server 2016. Students will learn how to install Exchange Server 2016, and how to configure and manage an Exchange Server environment. The course covers how to manage mail recipients and public folders, including how to perform bulk operations using Exchange Management Shell. Students also will learn how to manage client connectivity, message transport and hygiene, how to implement and manage highly available Exchange Server deployments, and how to implement back up and disaster recovery solutions. The course also teaches students how to maintain and monitor an Exchange Server 2016 deployment. In addition, students will learn how to administer Exchange Online in an Office 365 deployment.

  • Perform deployment and basic management of Exchange Server 2016.
  • Manage Exchange Server 2016.
  • Create and manage various recipient objects in Exchange Server 2016.
  • Use Exchange Management Shell to create and manage various recipient objects in Exchange Server 2016, and perform various tasks to automate Exchange management procedures.
  • Configure client connectivity to Exchange Server 2016, and manage Client Access services.
  • Implement and manage high availability.
  • Implement backup and disaster recovery for Exchange Server 2016.
  • Configure message transport options.
  • Configure message hygiene and security options.
  • Implement and manage Exchange Online deployments.
  • Monitor and troubleshoot Exchange Server 2016.
  • Secure and maintain Exchange Server 2016.
  • Original-Microsoft-Training
  • MOC On-Demand is currently available only in English
  • combination of video, text, practical tasks and knowledge tests
  • special offers like discounts are considered when taking the exam.

About Microsoft Official Course On-Demand

The courses are a great alternative for anyone wanting to learn independently and at their own pace. As a participant, you will receive an access to a learning platform developed by Microsoft, providing you with content such as videos, tutorials as well as a Live Lab-Environment for exercises.

As one of the leading Microsoft Learning Partners in Germany, GFN AG works closely with Microsoft together. On request, we can offer you additional services like digital training materials or an individual exam preparation in one of our Training center. For further information, you can also visit the following website MoC On Demand-Infoseite or feel free to contact us.

First published: 11. August 2016



  • people aspiring to become enterprise-level messaging administrators for Exchange Server 2016. IT generalists and help-desk professionals who want to learn about Exchange Server 2016 might also take this course. Students taking this course are expected to have at least two years of experience working in the IT field?typically in the areas of Windows Server administration, network administration, help desk, or system administration. They are not expected to have experience with previous Exchange Server versions.
  • IT professionals who take this course as preparation material for exam 70-345: Designing and Deploying Microsoft Exchange Server 2016, or as part of the requirement for the MCSE: Microsoft Exchange Server 2016 certification.

One more important note, all Microsoft MOC On-Demand courses are currently available in English only. To successfully complete this course, therefore a safe handling like IT-specialized English is essential.


  • A minimum two years of experience administering Windows Server, including Windows Servier 2012 R@ or Windows Server 2016.
  • A minimum two years experience working with active Directory Domain Services (AD DS).  A minimum two years of experience working with name resolution including Domain Name System (DNS).
  • Understanding of TCP/IP and networking concepts.
  • Understanding of Windows Server 2012 R2 or later, and AD DS, including planning, designing, and deploying.
  • Understanding of security concepts such as authentication and authorization.
  • Understanding of Simple Mail Transfer Protocol (SMTP).
  • Working knowledge of public key infrastructure (PKI) technologies, including Active Directory Certificate Services (AD CS).

Recommended system requirements for Microsoft Official Courses On-Demand and labs include:

  • Windows 10
  • Current version of Internet Explorer or Microsoft Edge
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed ActiveX control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required
  • 1280 x 1024 or higher

Note You can also take a MOC On-Demand on your iPad® Retina 4th Generation; however, the lab experience is not optimized for tablets.

Note Regularly scheduled maintenance for the Microsoft Labs Online (MLO) platform is currently at 10?12 P.M. Pacific Time every Thursday. During that time, you may not be able to access the MLO associated with a MOC On-Demand.

The minimum system requirements for MOC On-Demand and labs include:

  • Windows 7 or later
  • Internet Explorer 9 or later
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed Active X control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required

This Online-Training covers the following topics:

  • Overview of Exchange Server 2016
  • Requirements and deployment options for Exchange Server 2016
  • Lab: Deploying Microsoft Exchange Server 2016
  • Evaluating requirements and prerequisites for an Exchange Server 2016 installation
  • Deploying Exchange Server 2016
  • Exchange Server 2016 management
  • Overview of the Exchange 2016 Mailbox server
  • Configuring Mailbox servers
  • Lab: Configuring Mailbox servers
  • Creating and configuring mailbox databases
  • Exchange Server 2016 recipients
  • Managing Exchange Server recipients
  • Configuring address lists and policies
  • Lab: Managing Exchange Server recipients and public folders
  • Managing recipients
  • Managing public folder mailboxes
  • Lab: Managing Exchange Server email address lists and policies
  • Managing email-address policies
  • Managing address lists and address book policies
  • Overview of the Exchange Management Shell
  • Managing Exchange Server 2016 by using Exchange Management Shell
  • Managing Exchange Server 2016 by using Exchange Management Shell scripts
  • Lab: Managing Exchange Server and recipient objects by using Exchange Management Shell
  • Using Exchange Management Shell to manage recipients
  • Using Exchange Management Shell to manage Exchange Server
  • Configuring client access services in Exchange Server 2016
  • Managing client services
  • Client connectivity and publishing of Exchange Server 2016 services
  • Configuring Outlook on the web
  • Configuring mobile messaging on Exchange Server 2016
  • Lab: Deploying and configuring client access services on Exchange Server 2016
  • Configuring certificates for client access
  • Configuring client access options
  • Configuring custom MailTips
  • Lab: Deploying and configuring client access services on Exchange Server
  • Configuring Exchange Server 2016 for Outlook
  • Configuring Outlook on the web
  • Configuring Microsoft Exchange ActiveSync
  • High availability on Exchange Server 2016
  • Configuring highly available mailbox databases
  • Configuring high availability of Client Access services
  • Lab: Implementing DAGs
  • Creating and configuring a database availability group
  • Lab: Implementing and testing high availability
  • Deploying a high availability solution for client access services
  • Testing the high availability configuration
  • Implementing Exchange Server 2016 backup
  • Implementing Exchange Server 2016 recovery
  • Lab: Backing up Exchange Server 2016
  • Backing up Exchange Server 2016
  • Lab: Implementing disaster recovery for Exchange Server 2016
  • Restoring Exchange Server 2016 data
  • Restore an Exchange Server DAG member (optional)
  • Overview of message transport
  • Configuring message transport
  • Managing transport rules
  • Lab: Configuring message transport
  • Configuring message transport
  • Troubleshooting message delivery
  • Configuring a disclaimer transport rule
  • Configuring a DLP policy for financial data
  • Deploying and managing an Edge Transport server for message security
  • Implementing an antivirus solution for Exchange Server 2016
  • Implementing an antispam solution for Exchange Server 2016
  • Lab: Configuring message security
  • Configuring and testing EdgeSync
  • Configuring antivirus, antispam, and malware protection features on Exchange Server 2016
  • Overview of Exchange Online and Office 365
  • Managing Exchange Online
  • Implementing the migration to Exchange Online
  • Lab: Managing Exchange Online
  • Managing Exchange Online
  • Monitoring Exchange Server 2016
  • Troubleshooting Exchange Server 2016
  • Lab: Monitoring and troubleshooting Exchange Server 2016
  • Monitoring Exchange Server
  • Troubleshooting database availability
  • Troubleshooting client access services
  • Securing Exchange Server with role-based access control (RBAC)
  • Configuring audit logging on Exchange Server 2016
  • Maintaining Exchange Server 2016
  • Lab: Securing and maintaining Exchange Server 2016
  • Configuring Exchange Server permissions
  • Configuring audit logging
  • Maintaining updates on Exchange Server 2016

This course provides experienced Exchange Server administrators with the knowledge to design and implement an Exchange Server 2016 messaging environment. Students will learn how to design and configure advanced components in an Exchange Server 2016 deployment such as site resiliency, advanced security, compliance, archiving, and discovery solutions. In addition, students will learn about coexistence with other Exchange organizations or Exchange Online, and migration from previous versions of Exchange Server. The course will provide guidelines, best practices, and considerations that will help students optimize their Exchange Server deployment.

  • Plan for Exchange Server deployments.
  • Plan and deploy Exchange Server 2016 Mailbox services.
  • Plan and deploy message transport.
  • Plan and deploy client access.
  • Design and implement high availability.
  • Maintain Exchange Server 2016.
  • Design messaging security.
  • Design and implement message retention.
  • Design messaging compliance.
  • Design and implement messaging coexistence.
  • Upgrade to Exchange Server 2016.
  • Plan a hybrid Exchange Server deployment.
  • Original-Microsoft-Training
  • MOC On-Demand is currently available only in English
  • combination of video, text, practical tasks and knowledge tests
  • special offers like discounts are considered when taking the exam.

About Microsoft Official Course On-Demand

The courses are a great alternative for anyone wanting to learn independently and at their own pace. As a participant, you will receive an access to a learning platform developed by Microsoft, providing you with content such as videos, tutorials as well as a Live Lab-Environment for exercises.

As one of the leading Microsoft Learning Partners in Germany, GFN AG works closely with Microsoft together. On request, we can offer you additional services like digital training materials or an individual exam preparation in one of our Training center. For further information, you can also visit the following website MoC On Demand-Infoseite or feel free to contact us.

First published: 08. September 2016



This course is intended for IT professionals who are experienced messaging administrators, messaging architects, or consultants. This course is designed for professionals in an enterprise environment who are responsible for designing and deploying Exchange Server 2016 solutions, including environments that contain previous versions of Exchange Server or Exchange Online. Students are expected to have experience with Exchange Server 2016 or previous versions of Exchange Server.

One more important note, all Microsoft MOC On-Demand courses are currently available in English only. To successfully complete this course, therefore a safe handling like IT-specialized English is essential.


  • A+ certification or equivalent knowledge.
  • Network+ certification or equivalent knowledge.
  • Completed Course 2028A, Basic Administration of Microsoft Windows 2000, or have equivalent knowledge of administrative tasks.
  • Attended course 20345-1A: Administering Exchange Server 2016, or have equivalent knowledge.
  • Minimum two years of experience working with  any version of Exchange Server.
  • Minimum of six months of experience working with Exchange Server 2013 or Exchange Server 2016.
  • Minimum of two years of experience administering the Windows Server 2012 R2.
  • Minimum two years  of experience working with Active Directory Domain Services (AD DS).
  • Minimum of two years of experience working with name resolution, including Domain Name System (DNS).
  • Experience working with certificates, including public key  infrastructure (PKI) certificates.
  • Experience working with Windows Powershell.

Recommended system requirements for Microsoft Official Courses On-Demand and labs include:

  • Windows 10
  • Current version of Internet Explorer or Microsoft Edge
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed ActiveX control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required
  • 1280 x 1024 or higher

Note You can also take a MOC On-Demand on your iPad® Retina 4th Generation; however, the lab experience is not optimized for tablets.

Note Regularly scheduled maintenance for the Microsoft Labs Online (MLO) platform is currently at 10?12 P.M. Pacific Time every Thursday. During that time, you may not be able to access the MLO associated with a MOC On-Demand.

The minimum system requirements for MOC On-Demand and labs include:

  • Windows 7 or later
  • Internet Explorer 9 or later
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed Active X control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required

This Online-Training covers the following topics:

  • New features in Exchange Server 2016
  • Gathering business requirements for an Exchange Server 2016 deployment
  • Planning for an Exchange Server deployment
  • Designing a Unified Messaging (UM) deployment
  • Planning Exchange Server hardware requirements
  • Planning Exchange Server for virtualization and Microsoft Azure integration
  • Planning and implementing public folders
  • Designing message routing
  • Designing transport services
  • Designing the message-routing perimeter
  • Designing and implementing transport compliance
  • Planning for Exchange Server 2016 clients
  • Planning for client access
  • Planning and implementing Office Online Server
  • Planning and implementing coexistence of SharePoint 2016 with Exchange
  • Designing external client access
  • Planning high availability for Exchange Server 2016
  • Planning for load balancing
  • Planning for site resilience
  • Using Managed Availability to improve high availability
  • Implementing DSC
  • Planning messaging security
  • Designing and implementing AD RMS and Azure RMS integration
  • Overview of messaging records management and archiving
  • Designing In-Place Archiving
  • Designing and implementing message retention
  • Designing and implementing data loss prevention
  • Designing and implementing In-Place Hold
  • Designing and implementing In-Place eDiscovery
  • Designing and implementing federation
  • Designing coexistence between Exchange organizations
  • Designing and implementing cross-forest mailbox moves
  • Planning an upgrade from previous Exchange Server versions
  • Implementing the upgrade from previous Exchange Server versions
  • Basics of a hybrid deployment
  • Planning and implementing a hybrid deployment
  • Implementing advanced functionality for hybrid deployments

This course that targets the needs of IT professionals who take part in evaluating, planning, deploying, and operating Office 365 services, including its identities, dependencies, requirements, and supporting technologies. This course focuses on skills required to set up an Office 365 tenant, including federation with existing user identities, and skills required to sustain an Office 365 tenant and its users.

  • Plan an Office 365 deployment, configure the Office 365 tenant, and plan a pilot deployment.
  • Manage Office 365 users, groups, and licenses, and configure delegated administration.
  • Plan and configure client connectivity to Office 365.
  • Plan and configure directory synchronization between Azure AD and on-premises AD DS.
  • Plan and implement the deployment of Office 365 ProPlus.
  • Plan and manage Exchange Online recipients and permissions.
  • Plan and configure Exchange Online services.
  • Plan and implement the Skype for Business Online deployment.
  • Plan and configure SharePoint Online.
  • Plan and configure an Office 365 collaboration solution that includes Yammer Enterprise, OneDrive for Business, and Office 365 groups.
  • Plan and configure the integration between Office 365 and Azure RMS, and configure compliance features in Office 365.
  • Monitor and review Office 365 services, and troubleshoot Office 365 issues.
  • Plan and implement identity federation between on-premises AD DS and Azure AD.
  • Original-Microsoft-Training
  • MOC On-Demand is currently available only in English
  • combination of video, text, practical tasks and knowledge tests
  • special offers like discounts are considered when taking the exam.

About Microsoft Official Course On-Demand

The courses are a great alternative for anyone wanting to learn independently and at their own pace. As a participant, you will receive an access to a learning platform developed by Microsoft, providing you with content such as videos, tutorials as well as a Live Lab-Environment for exercises.

As one of the leading Microsoft Learning Partners in Germany, GFN AG works closely with Microsoft together. On request, we can offer you additional services like digital training materials or an individual exam preparation in one of our Training center. For further information, you can also visit the following website MoC On Demand-Infoseite or feel free to contact us.

First published: 16. March 2017



This course will provide experienced IT professionals with the training that they need to plan, configure, and manage an Office 365 environment. Students who attend this course are expected to have a fairly broad understanding of several on-premises technologies such as Domain Name System (DNS) and AD DS, and a general understanding of Exchange Server, Microsoft Lync Server or Skype for Business Server, and Microsoft SharePoint Server.

One more important note, all Microsoft MOC On-Demand courses are currently available in English only. To successfully complete this course, therefore a safe handling like IT-specialized English is essential.


  • A minimum of two years of experience administering the Windows Server operating system, including Windows Server 2012 or Windows Server 2012 R2.
  • A minimum of one year of experience working with AD DS.A minimum of one year of experience working with name resolution, including DNS.
  • Experience working with certificates, including public key infrastructure (PKI) certificates.
  • Experience working with Windows PowerShell.Experience working with Exchange Server 2013 or later, Lync Server 2013 or Skype for Business Server 2015, and SharePoint Server 2013 or later is beneficial but not required.

Recommended system requirements for Microsoft Official Courses On-Demand and labs include:

  • Windows 10
  • Current version of Internet Explorer or Microsoft Edge
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed ActiveX control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required
  • 1280 x 1024 or higher

Note You can also take a MOC On-Demand on your iPad® Retina 4th Generation; however, the lab experience is not optimized for tablets.

Note Regularly scheduled maintenance for the Microsoft Labs Online (MLO) platform is currently at 10?12 P.M. Pacific Time every Thursday. During that time, you may not be able to access the MLO associated with a MOC On-Demand.

The minimum system requirements for MOC On-Demand and labs include:

  • Windows 7 or later
  • Internet Explorer 9 or later
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed Active X control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required

This Online-Training covers the following topics:

  • Overview of Office 365
  • Provisioning an Office 365 tenant
  • Planning a pilot deployment
  • Managing user accounts and licenses
  • Managing passwords and authentication
  • Managing security groups in Office 365
  • Managing Office 365 users and groups with Windows PowerShell
  • Configuring administrative access
  • Planning for Office 365 clients
  • Planning connectivity for Office 365 clients
  • Configuring connectivity for Office 365 clients
  • Planning and preparing for directory synchronization
  • Implementing directory synchronization by using Azure AD Connect
  • Managing Office 365 identities with directory synchronization
  • Overview of Office 365 ProPlus
  • Planning and managing user-driven Office 365 ProPlus deployments
  • Planning and managing centralized deployments of Office 365 ProPlus
  • Office telemetry and reporting
  • Overview of Exchange Online
  • Managing Exchange Online recipients
  • Planning and configuring Exchange Online permissions
  • Planning and configuring email flow in Office 365
  • Planning and configuring email protection in Office 365
  • Planning and configuring client access policies
  • Migrating to Exchange Online
  • Planning and configuring Skype for Business Online service settings
  • Configuring Skype for Business Online users and client connectivity
  • Planning voice integration with Skype for Business Online
  • Configuring SharePoint Online services
  • Planning and configuring SharePoint site collections
  • Planning and configuring external user sharing
  • Planning and managing Yammer Enterprise
  • Planning and configuring OneDrive for Business
  • Configuring Office 365 groups
  • Overview of the compliance features in Office 365
  • Planning and configuring Azure Rights Mmanagement in Office 365
  • Managing the compliance features in Office 365
  • Troubleshooting Office 365
  • Monitoring Office 365 service health
  • Understanding identity federation
  • Planning an AD FS deployment
  • Deploy AD FS for identity federation with Office 365
  • Planning and implementing hybrid solutions (Optional)

This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2014. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. The main purpose of the course is to prepare people for the exam "70-461: Writing Queries Using Microsoft® SQL Server® 2014 Transact-SQL." This exam will be the underlying exam for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. As such, the primary target audience for this course is: Database Administrators, Database Developers and BI professionals. Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.

  • Describe the basic architecture and concepts of Microsoft SQL Server 2014.
  • Understand the similarities and differences between Transact-SQL and other computer languages.
  • Write SELECT queries
  • Query multiple tables
  • Sort and filter data
  • Describe the use of data types in SQL Server
  • Modify data using Transact-SQL
  • Use built-in functions
  • Group and aggregate data
  • Use subqueries
  • Use table expressions
  • Use set operators
  • Use window ranking, offset and aggregate functions
  • Implement pivoting and grouping sets
  • Execute stored procedures
  • Program with T-SQL
  • Implement error handling
  • Implement transactions
  • Original-Microsoft-Training
  • MOC On-Demand is currently available only in English
  • combination of video, text, practical tasks and knowledge tests
  • special offers like discounts are considered when taking the exam.

About Microsoft Official Course On-Demand

The courses are a great alternative for anyone wanting to learn independently and at their own pace. As a participant, you will receive an access to a learning platform developed by Microsoft, providing you with content such as videos, tutorials as well as a Live Lab-Environment for exercises.

As one of the leading Microsoft Learning Partners in Germany, GFN AG works closely with Microsoft together. On request, we can offer you additional services like digital training materials or an individual exam preparation in one of our Training center. For further information, you can also visit the following website MoC On Demand-Infoseite or feel free to contact us.

First published: 31. March 2016



This course is intended for Database Administrators, Database Developers, and Business Intelligence professionals. The course will very likely be well attended by SQL power users who aren?t necessarily database-focused or plan on taking the exam; namely, report writers, business analysts and client application developers.

One more important note, all Microsoft MOC On-Demand courses are currently available in English only. To successfully complete this course, therefore a safe handling like IT-specialized English is essential.


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

Recommended system requirements for Microsoft Official Courses On-Demand and labs include:

  • Windows 10
  • Current version of Internet Explorer or Microsoft Edge
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed ActiveX control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required
  • 1280 x 1024 or higher

Note You can also take a MOC On-Demand on your iPad® Retina 4th Generation; however, the lab experience is not optimized for tablets.

Note Regularly scheduled maintenance for the Microsoft Labs Online (MLO) platform is currently at 10?12 P.M. Pacific Time every Thursday. During that time, you may not be able to access the MLO associated with a MOC On-Demand.

The minimum system requirements for MOC On-Demand and labs include:

  • Windows 7 or later
  • Internet Explorer 9 or later
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed Active X control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required

This Online-Training covers the following topics:

  • The Basic Architecture of SQL Server
  • SQL Server Editions and Versions
  • Getting Started with SQL Server Management Studio
  • Introducing T-SQL
  • Understanding Sets
  • Understanding Predicate Logic
  • Understanding the Logical Order of Operations in SELECT statements
  • Writing Simple SELECT Statements
  • Eliminate Duplicates with DISTINCT
  • Using Column and Table Aliases
  • Write Simple CASE Expressions
  • Understanding Joins
  • Querying with Inner Joins
  • Querying with Outer Joins
  • Querying with Cross Joins and Self Joins
  • Sorting Data
  • Filtering Data with Predicates
  • Filtering with the TOP and OFFSET-FETCH
  • Working with Unknown Values
  • Introducing SQL Server 2014 Data Types
  • Working with Character Data
  • Working with Date and Time Data
  • Inserting Data
  • Modifying and Deleting Data
  • Writing Queries with Built-In Functions
  • Using Conversion Functions
  • Using Logical Functions
  • Using Functions to Work with NULL
  • Using Aggregate Functions
  • Using the GROUP BY Clause
  • Filtering Groups with HAVING
  • Writing Self-Contained Subqueries
  • Writing Correlated Subqueries
  • Using the EXISTS Predicate with Subqueries
  • Using Views
  • Using Inline Table-Valued Functions
  • Using Derived Tables
  • Using Common Table Expressions
  • Writing Queries with the UNION Operator
  • Using EXCEPT and INTERSECT
  • Using APPLY
  • Creating Windows with OVER
  • Exploring Window Functions
  • Writing Queries with PIVOT and UNPIVOT
  • Working with Grouping Sets
  • Writing Queries with PIVOT and UNPIVOT
  • Passing Parameters to Stored Procedures
  • Creating Simple Stored Procedures
  • Working with Dynamic SQL
  • T-SQL Programming Elements
  • Controlling Program Flow
  • Using TRY / CATCH Blocks
  • Working with Error Information
  • Transactions and the Database Engine
  • Controlling Transactions
  • Factors in Query Performance
  • Displaying Query Performance DataModule 20: Appendix 2: Querying SQL Server Metadata
  • Querying System Catalog Views and Functions
  • Executing System Stored Procedures
  • Querying Dynamic Management Objects

This course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2014 database. The course focuses on teaching individuals how to use SQL Server 2014 product features andtools related to maintaining a database. Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.

  • Describe core database administration tasks and tools.
  • Install and configure SQL Server 2014.
  • Configure SQL Server databases and storage.
  • Plan and implement a backup strategy.
  • Restore databases from backups.
  • Import and export data. Monitor SQL Server.
  • Trace SQL Server activity.
  • Manage SQL Server security.
  • Audit data access and encrypt data.
  • Perform ongoing database maintenance.
  • Automate SQL Server maintenance with SQL Server Agent Jobs.
  • Configure Database Mail, alerts and notifications.
  • Original-Microsoft-Training
  • MOC On-Demand is currently available only in English
  • combination of video, text, practical tasks and knowledge tests
  • special offers like discounts are considered when taking the exam.

About Microsoft Official Course On-Demand

The courses are a great alternative for anyone wanting to learn independently and at their own pace. As a participant, you will receive an access to a learning platform developed by Microsoft, providing you with content such as videos, tutorials as well as a Live Lab-Environment for exercises.

As one of the leading Microsoft Learning Partners in Germany, GFN AG works closely with Microsoft together. On request, we can offer you additional services like digital training materials or an individual exam preparation in one of our Training center. For further information, you can also visit the following website MoC On Demand-Infoseite or feel free to contact us.

First published: 14. April 2016



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

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

One more important note, all Microsoft MOC On-Demand courses are currently available in English only. To successfully complete this course, therefore a safe handling like IT-specialized English is essential.


  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Working knowledge of Transact-SQL.
  • Working knowledge of relational databases.
  • Some experience with database design.

Recommended system requirements for Microsoft Official Courses On-Demand and labs include:

  • Windows 10
  • Current version of Internet Explorer or Microsoft Edge
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed ActiveX control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required
  • 1280 x 1024 or higher

Note You can also take a MOC On-Demand on your iPad® Retina 4th Generation; however, the lab experience is not optimized for tablets.

Note Regularly scheduled maintenance for the Microsoft Labs Online (MLO) platform is currently at 10?12 P.M. Pacific Time every Thursday. During that time, you may not be able to access the MLO associated with a MOC On-Demand.

The minimum system requirements for MOC On-Demand and labs include:

  • Windows 7 or later
  • Internet Explorer 9 or later
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed Active X control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required

This Online-Training covers the following topics:

  • Database Administration Overview
  • Introduction to the SQL Server Platform
  • Database Management Tools and Techniques
  • Planning SQL Server Installation
  • Installing SQL Server 2014
  • Post-Installation Configuration
  • Introduction to Data Storage with SQL Server
  • Managing Storage for System Databases
  • Managing Storage for User Databases
  • Moving Database Files
  • Configuring the Buffer Pool Extension
  • Understanding SQL Server Recovery Models
  • Planning a Backup Strategy
  • Backing up Databases and Transaction Logs
  • Using Backup Options
  • Ensuring Backup Reliability
  • Understanding the Restore Process
  • Restoring Databases
  • Advanced Restore Scenarios
  • Working with Point-in-Time Recovery
  • Introduction to Transferring Data
  • Importing and Exporting Table Data
  • Copying or Moving a Database
  • Introduction to Monitoring SQL Server
  • Dynamic Management Views and Functions
  • Performance Monitor
  • Tracing SQL Server Workload Activity
  • Using Traces
  • Introduction to SQL Server Security
  • Managing Server-Level Security
  • Managing Database-Level Principals
  • Managing Database Permissions
  • Auditing Data Access in SQL Server
  • Implementing SQL Server Audit
  • Implementing SQL Server Audit
  • Ensuring Database Integrity
  • Maintaining Indexes
  • Automating Routine Database Maintenance
  • Automating SQL Server Management
  • Implementing SQL Server Agent Jobs
  • Managing SQL Server Agent Jobs
  • Managing Job Step Security Contexts
  • Managing Jobs on Multiple Servers
  • Monitoring SQL Server Errors
  • Configuring Database Mail
  • Configuring Operators, Alerts, and Notifications

This course describes how to implement a data warehouse platform to support a BI solution. Students will learn how to create a data warehouse with Microsoft® SQL Server® 2014, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services. Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.

  • Describe data warehouse concepts and architecture considerations.
  • Select an appropriate hardware platform for a data warehouse.
  • Design and implement a data warehouse.
  • Implement Data Flow in an SSIS Package.
  • Implement Control Flow in an SSIS Package.
  • Debug and Troubleshoot SSIS packages.
  • Implement an ETL solution that supports incremental data extraction.
  • Implement an ETL solution that supports incremental data loading.
  • Implement data cleansing by using Microsoft Data Quality Services.
  • Implement Master Data Services to enforce data integrity.
  • Extend SSIS with custom scripts and components.
  • Deploy and Configure SSIS packages.
  • Describe how BI solutions can consume data from the data warehouse.
  • Original-Microsoft-Training
  • MOC On-Demand is currently available only in English
  • combination of video, text, practical tasks and knowledge tests
  • special offers like discounts are considered when taking the exam.

About Microsoft Official Course On-Demand

The courses are a great alternative for anyone wanting to learn independently and at their own pace. As a participant, you will receive an access to a learning platform developed by Microsoft, providing you with content such as videos, tutorials as well as a Live Lab-Environment for exercises.

As one of the leading Microsoft Learning Partners in Germany, GFN AG works closely with Microsoft together. On request, we can offer you additional services like digital training materials or an individual exam preparation in one of our Training center. For further information, you can also visit the following website MoC On Demand-Infoseite or feel free to contact us.

First published: 28. April 2016



This course is intended for database professionals who need to fulfil a Business Intelligence Developer role.  They will need to focus on hands-on work creating BI solutions including Data Warehouse implementation, ETL, and data cleansing.

One more important note, all Microsoft MOC On-Demand courses are currently available in English only. To successfully complete this course, therefore a safe handling like IT-specialized English is essential.


  • At least 2 years? experience of working with relational databases, including:
  • Designing a normalized database.
  • Creating tables and relationships.
  • Querying with Transact-SQL.
  • Some exposure to basic programming constructs (such as looping and branching).

Recommended system requirements for Microsoft Official Courses On-Demand and labs include:

  • Windows 10
  • Current version of Internet Explorer or Microsoft Edge
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed ActiveX control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required
  • 1280 x 1024 or higher

Note You can also take a MOC On-Demand on your iPad® Retina 4th Generation; however, the lab experience is not optimized for tablets.

Note Regularly scheduled maintenance for the Microsoft Labs Online (MLO) platform is currently at 10?12 P.M. Pacific Time every Thursday. During that time, you may not be able to access the MLO associated with a MOC On-Demand.

The minimum system requirements for MOC On-Demand and labs include:

  • Windows 7 or later
  • Internet Explorer 9 or later
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed Active X control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required

This Online-Training covers the following topics:

  • Overview of Data Warehousing
  • Considerations for a Data Warehouse Solution
  • Considerations for building a Data Warehouse
  • Data Warehouse Reference Architectures and Appliances
  • Logical Design for a Data Warehouse
  • Physical design for a data warehouse
  • Introduction to ETL with SSIS
  • Exploring Data Sources
  • Implementing Data Flow
  • Introduction to Control Flow
  • Creating Dynamic Packages
  • Using Containers
  • Managing Consistency
  • Debugging an SSIS Package
  • Logging SSIS Package Events
  • Handling Errors in an SSIS Package
  • Introduction to Incremental ETL
  • Extracting Modified Data
  • Loading Modified data
  • Introduction to Data Quality
  • Using Data Quality Services to Cleanse Data
  • Using Data Quality Services to Match data
  • Master Data Services Concepts
  • Implementing a Master Data Services Model
  • Managing Master Data
  • Creating a Master Data Hub
  • Using Scripts in SSIS
  • Using Custom Components in SSIS
  • Overview of SSIS Deployment
  • Deploying SSIS Projects
  • Planning SSIS Package Execution
  • Introduction to Business Intelligence
  • Introduction to Reporting
  • An Introduction to Data Analysis

This course provides an introduction to HTML5, CSS3, and JavaScript. This course helps students gain basic HTML5/CSS3/JavaScript programming skills. This course is an entry point into both the Web application and Windows Store apps training paths. The course focuses on using HTML5/CSS3/JavaScript to implement programming logic, define and use variables, perform looping and branching, develop user interfaces, capture and validate user input, store data, and create well-structured application.

  • Explain how to use Visual Studio 2012 to create and run a Web application.
  • Describe the new features of HTML5, and create and style HTML5 pages.
  • Add interactivity to an HTML5 page by using JavaScript.
  • Create HTML5 forms by using different input types, and validate user input by using HTML5 attributes and JavaScript code.
  • Send and receive data to and from a remote data source by using XMLHTTPRequest objects and jQuery AJAX operations.
  • Style HTML5 pages by using CSS3.
  • Create well-structured and easily-maintainable JavaScript code.
  • Use common HTML5 APIs in interactive Web applications.
  • Create Web applications that support offline operations.
  • Create HTML5 Web pages that can adapt to different devices and form factors.
  • Add advanced graphics to an HTML5 page by using Canvas elements, and by using and Scalable Vector Graphics.
  • Enhance the user experience by adding animations to an HTML5 page.
  • Use Web Sockets to send and receive data between a Web application and a server.
  • Improve the responsiveness of a Web application that performs long-running operations by using Web Worker processes.
  • Original-Microsoft-Training
  • MOC On-Demand is currently available only in English
  • combination of video, text, practical tasks and knowledge tests
  • special offers like discounts are considered when taking the exam.

About Microsoft Official Course On-Demand

The courses are a great alternative for anyone wanting to learn independently and at their own pace. As a participant, you will receive an access to a learning platform developed by Microsoft, providing you with content such as videos, tutorials as well as a Live Lab-Environment for exercises.

As one of the leading Microsoft Learning Partners in Germany, GFN AG works closely with Microsoft together. On request, we can offer you additional services like digital training materials or an individual exam preparation in one of our Training center. For further information, you can also visit the following website MoC On Demand-Infoseite or feel free to contact us.

First published: 03. March 2016



  • 1 ? 3 months experience creating Web applications, including writing simple JavaScript code
  • 1 month experience creating Windows client applications
  • 1 month of experience using Visual Studio 2010 or 2012

One more important note, all Microsoft MOC On-Demand courses are currently available in English only. To successfully complete this course, therefore a safe handling like IT-specialized English is essential.


  • Understand the basic HTML document structure:
  • How to use HTML tags to display text content.
  • How to use HTML tags to display graphics.
  • How to use HTML APIs.
  • Understand how to style common HTML elements using CSS, including:
  • How to separate presentation from content
  • How to manage content flow.
  • How to control the position of individual elements.
  • How to implement basic CSS styling.
  • Understand how to write JavaScript code to add functionality to a web page:
  • How o create and use variables
  • How to use:
  • arithmetic operators to perform arithmetic calculations involving one or more variables
  • relational operators to test the relationship between two variables or expressions
  • logical operators to combine expressions that contain relational operators
  • How to control the program flow by using if ? else statements.
  • How to implement iterations by using loops.
  • How to write simple functions.

Recommended system requirements for Microsoft Official Courses On-Demand and labs include:

  • Windows 10
  • Current version of Internet Explorer or Microsoft Edge
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed ActiveX control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required
  • 1280 x 1024 or higher

Note You can also take a MOC On-Demand on your iPad® Retina 4th Generation; however, the lab experience is not optimized for tablets.

Note Regularly scheduled maintenance for the Microsoft Labs Online (MLO) platform is currently at 10?12 P.M. Pacific Time every Thursday. During that time, you may not be able to access the MLO associated with a MOC On-Demand.

The minimum system requirements for MOC On-Demand and labs include:

  • Windows 7 or later
  • Internet Explorer 9 or later
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed Active X control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required

This Online-Training covers the following topics:

  • Overview of HTML
  • Overview of CSS
  • Creating a Web Application by Using Visual Studio 2012
  • Creating an HTML5 Page
  • Styling an HTML5 Page
  • Overview of JavaScript Syntax
  • Programming the HTML DOM with JavaScript
  • Introduction to jQuery
  • Overview of Forms and Input Types
  • Validating User Input by Using HTML5 Attributes
  • Validating User Input by Using JavaScript
  • Sending and Receiving Data by Using XMLHTTPRequest
  • Sending and Receiving Data by Using jQuery AJAX operations
  • Styling Text
  • Styling Block Elements
  • CSS3 Selectors
  • Enhancing Graphical Effects by Using CSS3
  • Writing Well-Structured JavaScript
  • Creating Custom Objects
  • Extending Objects
  • Interacting with Files
  • Incorporating Multimedia
  • Reacting to Browser Location and Context
  • Debugging and Profiling a Web Application
  • Reading and Writing Data Locally
  • Adding Offline Support by Using the Application Cache
  • Supporting Multiple Form Factors
  • Creating an Adaptive User Interface
  • Creating Interactive Graphics by Using Scalable Vector Graphics
  • Programmatically Drawing Graphics by Using a Canvas
  • Applying CSS Transitions
  • Transforming Elements
  • Applying CSS Key-frame Animations
  • Introduction to Web Sockets
  • Sending and Receiving Data by Using Web Sockets
  • Introduction to Web Workers
  • Performing Asynchronous Processing by Using a Web Worker

This training course teaches developers the programming skills that are required for developers to create Windows applications using the C# language. During this course, students review the basics of C# program structure, language syntax, and implementation details, and then consolidate their knowledge throughout the week as they build an application that incorporates several features of the .NET Framework 4.5.

  • Describe the core syntax and features of C#.
  • Create and call methods, catch and handle exceptions, and describe the monitoring requirements of large-scale applications.
  • Implement the basic structure and essential elements of a typical desktop application.
  • Create classes, define and implement interfaces, and create and use generic collections.
  • Use inheritance to create a class hierarchy, extend a .NET Framework class, and create generic classes and methods.
  • Read and write data by using file input/output and streams, and serialize and deserialize data in different formats.
  • Create and use an entity data model for accessing a database and use LINQ to query and update data.
  • Use the types in the System.Net namespace and WCF Data Services to access and query remote data.
  • Build a graphical user interface by using XAML.
  • Improve the throughput and response time of applications by using tasks and asynchronous operations.
  • Integrate unmanaged libraries and dynamic components into a C# application.
  • Examine the metadata of types by using reflection, create and use custom attributes, generate code at runtime, and manage assembly versions.
  • Encrypt and decrypt data by using symmetric and asymmetric encryption.
  • Original-Microsoft-Training
  • MOC On-Demand is currently available only in English
  • combination of video, text, practical tasks and knowledge tests
  • special offers like discounts are considered when taking the exam.

About Microsoft Official Course On-Demand

The courses are a great alternative for anyone wanting to learn independently and at their own pace. As a participant, you will receive an access to a learning platform developed by Microsoft, providing you with content such as videos, tutorials as well as a Live Lab-Environment for exercises.

As one of the leading Microsoft Learning Partners in Germany, GFN AG works closely with Microsoft together. On request, we can offer you additional services like digital training materials or an individual exam preparation in one of our Training center. For further information, you can also visit the following website MoC On Demand-Infoseite or feel free to contact us.

First published: 12. January 2016



This course is intended for experienced developers who already have programming experience in C, C++, JavaScript, Objective-C, Microsoft Visual Basic®, or Java and understand the concepts of object-oriented programming.

One more important note, all Microsoft MOC On-Demand courses are currently available in English only. To successfully complete this course, therefore a safe handling like IT-specialized English is essential.


  • How to name, declare, initialize and assign values to variables within an application.
  • How to use:
  • arithmetic operators to perform arithmetic calculations involving one or more variables;
  • relational operators to test the relationship between two variables or expressions;
  • logical operators to combine expressions that contain relational operators.
  • How to create the code syntax for simple programming statements using C# language keywords and recognize syntax errors using the Visual Studio IDE.
  • How to create a simple branching structure using an IF statement.
  • How to create a simple looping structure using a For statement to iterate through a data array.
  • How to use the Visual Studio IDE to locate simple logic errors.
  • How to create a Function that accepts arguments (parameters and returns a value of a specified type.
  • How to design and build a simple user interface using standard controls from the Visual Studio toolbox.
  • How to connect to a SQL Server database and the basics of how to retrieve and store data.
  • How to sort data in a loop.
  • How to recognize the classes and methods used in a program.

Recommended system requirements for Microsoft Official Courses On-Demand and labs include:

  • Windows 10
  • Current version of Internet Explorer or Microsoft Edge
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed ActiveX control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required
  • 1280 x 1024 or higher

Note You can also take a MOC On-Demand on your iPad® Retina 4th Generation; however, the lab experience is not optimized for tablets.

Note Regularly scheduled maintenance for the Microsoft Labs Online (MLO) platform is currently at 10?12 P.M. Pacific Time every Thursday. During that time, you may not be able to access the MLO associated with a MOC On-Demand.

The minimum system requirements for MOC On-Demand and labs include:

  • Windows 7 or later
  • Internet Explorer 9 or later
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed Active X control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required

This Online-Training covers the following topics:

  • Overview of Writing Applications using C#
  • Datatypes, Operators, and Expressions
  • C# Programming Language Constructs
  • Creating and Invoking Methods
  • Creating Overloaded Methods and Using Optional and Output Parameters
  • Handling Exceptions
  • Monitoring Applications
  • Implementing Structs and Enums
  • Organizing Data into Collections
  • Handling Events
  • Creating Classes
  • Defining and Implementing Interfaces
  • Implementing Type-safe Collections
  • Creating Class Hierarchies
  • Extending .NET Framework Classes
  • Creating Generic Types
  • Reading and Writing Files
  • Serializing and Deserializing Data
  • Performing I/O Using Streams
  • Creating and Using Entity Data Models
  • Querying Data by Using LINQ
  • Updating Data by Using LINQ
  • Accessing Data Across the Web
  • Accessing Data in the Cloud
  • Using XAML to Design a User Interface
  • Binding Controls to Data
  • Styling a User Interface
  • Implementing Multitasking by using Tasks and Lambda Expressions
  • Performing Operations Asynchronously
  • Synchronizing Concurrent Access to Data
  • Creating and Using Dynamic Objects
  • Managing the Lifetime of Objects and Controlling Unmanaged Resources
  • Examining Object Metadata
  • Creating and Using Custom Attributes
  • Generating Managed Code
  • Versioning, Signing and Deploying Assemblies
  • Implementing Symmetric Encryption
  • Implementing Asymmetric Encryption











Erfolg dank Cloud-Computing: Werden Sie zum Microsoft Azure-Spezialisten. Der Kurs ?MoD 20537: Configuring and Operating a Hybrid Cloud with Microsoft Azure Stack? vermittelt grundlegende Kenntnisse die benötigt werden, um den Microsoft Azure Stack im Unternehmen einführen und verwalten zu können..

  • Die Grundfunktionen, die Unterschiede zwischen Microsoft Azure Stack, Microsoft Azure und Windows Azure Pack.
  • Architektur und Komponenten
  • Windows Server Rollen und Features die in Microsoft Azure Stack genutzt werden
  • Microsoft Azure Stack und DevOps
  • Azure Resource Manager Templates
  • Offers und Delegation
  • Der Marktplatz in Microsoft Azure Stack
  • Software-definiertes Networking in Microsoft Azure Stack
  • Storage Management, Virtual Machines und Resource Providers in Microsoft Azure Stack.
  • Überwachen und Troubleshooting
  • Lizenzierung und Abrechnung bei Microsoft Azure Stack.
  • Original-Microsoft-Training
  • MOC On-Demand is currently available only in English
  • combination of video, text, practical tasks and knowledge tests
  • special offers like discounts are considered when taking the exam.

About Microsoft Official Course On-Demand

The courses are a great alternative for anyone wanting to learn independently and at their own pace. As a participant, you will receive an access to a learning platform developed by Microsoft, providing you with content such as videos, tutorials as well as a Live Lab-Environment for exercises.

As one of the leading Microsoft Learning Partners in Germany, GFN AG works closely with Microsoft together. On request, we can offer you additional services like digital training materials or an individual exam preparation in one of our Training center. For further information, you can also visit the following website MoC On Demand-Infoseite or feel free to contact us.

First published: 28. July 2016



Das Microsoft-Training MoD 20537 richtet sich an Service-Spezialisten, Devops und Cloud-Architekten die daran interessiert sind, mit Microsoft Azure Stack ihren Endbenutzern und Kunden Cloud-Services aus dem eigenen Datacenter heraus zur Verfügung zu stellen.

One more important note, all Microsoft MOC On-Demand courses are currently available in English only. To successfully complete this course, therefore a safe handling like IT-specialized English is essential.


  • Working Knowledge of Windows Server 2016
  • Working Knowledge of SQL Server 2014.
  • Working Knowledge of Microsoft Azure.

Recommended system requirements for Microsoft Official Courses On-Demand and labs include:

  • Windows 10
  • Current version of Internet Explorer or Microsoft Edge
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed ActiveX control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required
  • 1280 x 1024 or higher

Note You can also take a MOC On-Demand on your iPad® Retina 4th Generation; however, the lab experience is not optimized for tablets.

Note Regularly scheduled maintenance for the Microsoft Labs Online (MLO) platform is currently at 10?12 P.M. Pacific Time every Thursday. During that time, you may not be able to access the MLO associated with a MOC On-Demand.

The minimum system requirements for MOC On-Demand and labs include:

  • Windows 7 or later
  • Internet Explorer 9 or later
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed Active X control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required

This Online-Training covers the following topics:

  • What is Azure Stack?
  • Comparing Azure Stack with Microsoft Azure.
  • Comparing Azure Stack to Windows Azure Pack.
  • Windows Server 2016 and System Center 2016.
  • Identity and Authentication.
  • Microsoft Azure Stack Architecture.
  • Azure Stack Prerequisites.
  • Installing Azure Stack.
  • Working with Plans and Offers.
  • Microsoft Azure Stack Marketplace.
  • Enabling Multi-Tenancy in Azure Stack.
  • Integrating Azure Stack with Windows Azure Pack.
  • Technologies used in Microsoft Azure Stack for DevOps.
  • Azure Resource Manager Templates.
  • Third-party Resource Providers.
  • Software Defined Networking improvements with Microsoft Azure Stack and Windows Server 2016.
  • Azure Stack Storage.
  • Virtual Machines in Microsoft Azure Stack.
  • Understanding the Platform as a Service.
  • SQL Server and MySQL Server Providers in Microsoft Azure Stack.
  • App Service Resource Provider.
  • Azure Key Vault.
  • Azure Functions.
  • Field Replaceable Unit.
  • Azure Stack Control Plane Monitoring.
  • Patching the Azure Stack Infrastructure.
  • Monitoring Guest Workloads in Microsoft Azure Stack.
  • Troubleshooting Azure Stack.
  • Protecting Azure Stack and Tenant Workloads.
  • How to license and pay for Azure Stack.
  • Azure Consistent Usage API.
  • Business Costs and Models with Azure Stack.

This course describes how to assess operating system and application deployment options, determine the most appropriate deployment strategy, and then implement a deployment solution for Windows devices and apps that meets your environment?s needs. Solutions that this course details include operating system deployment scenarios ranging from high-touch solutions to zero-touch solutions. It also discusses the technologies that you use to implement these solutions, including the MDT and Configuration Manager.  

  • Assess the network environment to support operating system and application deployment tasks.
  • Identify the most appropriate operating system deployment strategy based upon organizational requirements.
  • Assess application compatibility issues and identify mitigation solutions to ensure that applications function successfully after an operating system deployment.
  • Describe and configure strategies to migrate user state during operating system deployments.
  • Determine the most appropriate image management strategy to support operating system and application deployments.
  • Describe and use the tools provided in the Windows ADK to prepare for and support automated deployment strategies.
  • Identify solutions to support PXE-initiated and multicast solutions when performing operating system deployment tasks.
  • Configure an operating system deployment strategy by using the MDT.
  • Configure an operating system deployment strategy using Configuration Manager.
  • Integrate the MDT with Configuration Manager to support operating system deployment procedures.
  • Implement volume license activation and configuration settings for client computers.
  • Customize and deploy Microsoft Office 2016 to an enterprise network environment, and describe how to use the Windows ICD.
  • Original-Microsoft-Training
  • MOC On-Demand is currently available only in English
  • combination of video, text, practical tasks and knowledge tests
  • special offers like discounts are considered when taking the exam.

About Microsoft Official Course On-Demand

The courses are a great alternative for anyone wanting to learn independently and at their own pace. As a participant, you will receive an access to a learning platform developed by Microsoft, providing you with content such as videos, tutorials as well as a Live Lab-Environment for exercises.

As one of the leading Microsoft Learning Partners in Germany, GFN AG works closely with Microsoft together. On request, we can offer you additional services like digital training materials or an individual exam preparation in one of our Training center. For further information, you can also visit the following website MoC On Demand-Infoseite or feel free to contact us.

First published: 21 July 2016



This course is intended for IT professionals who deploy, manage, and maintain PCs, devices, and apps across medium, large, and enterprise organizations. Typically, this course?s audience has a desktop-support background, and have worked as Enterprise Desktop Administrators. A significant portion of this audience uses or intends to use Configuration Manager to manage and deploy PCs, devices, and enterprise applications. The Enterprise Desktop Administrator also might use several tools, including the Windows ADK and the MDT to support assessment, operating system, and application deployment tasks. Additionally, this course is for individuals who are interested in taking the MCSE exam 70-695: Deploying Windows Desktops and Enterprise Applications.

One more important note, all Microsoft MOC On-Demand courses are currently available in English only. To successfully complete this course, therefore a safe handling like IT-specialized English is essential.


  • Networking fundamentals, including common networking protocols, topologies, hardware, media, routing, switching and addressing
  • Active Directory Domain Services (AD DS) principles and fundamentals of AD DS management
  • Installation, configuration, and troubleshooting for Windows-based personal computers
  • Basic concepts of Public Key Infrastructure (PKI) security
  • Basic understanding of scripting and Windows PowerShell syntax
  • Basic understanding of Windows Server roles and services
  • Basic understanding of management tasks using System Center 2012 R2 Configuration Manager

Recommended system requirements for Microsoft Official Courses On-Demand and labs include:

  • Windows 10
  • Current version of Internet Explorer or Microsoft Edge
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed ActiveX control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required
  • 1280 x 1024 or higher

Note You can also take a MOC On-Demand on your iPad® Retina 4th Generation; however, the lab experience is not optimized for tablets.

Note Regularly scheduled maintenance for the Microsoft Labs Online (MLO) platform is currently at 10?12 P.M. Pacific Time every Thursday. During that time, you may not be able to access the MLO associated with a MOC On-Demand.

The minimum system requirements for MOC On-Demand and labs include:

  • Windows 7 or later
  • Internet Explorer 9 or later
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed Active X control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required

This Online-Training covers the following topics:

  • Overview of the enterprise desktop life cycle
  • Assessing readiness for a desktop deployment by using Configuration Manager
  • Assessing deployment readiness by using MAP
  • Understanding tools and strategies you can use for operating system deployment
  • Using the High Touch with Retail Media deployment strategy
  • Using the High Touch with a Standard Image deployment strategy
  • Using a lite touch deployment strategy
  • Using a zero touch deployment strategy
  • Alternative deployment strategies for Windows desktops
  • Diagnosing application compatibility issues
  • Mitigating application compatibility issues
  • Using ACT to address application compatibility issues
  • Overview of user state migration
  • Overview of USMT 10.0
  • Planning user state migration
  • Migrating user state by using USMT
  • Overview of the Windows image file format
  • Overview of image management
  • Overview of the Windows setup and installation process
  • Preparing boot images by using Windows PE
  • Using Windows SIM and Sysprep to automate and prepare an image installation
  • Capturing and servicing a reference image using DISM
  • Using the Windows ICD
  • Overview of PXE-initiated and multicast operating system deployments
  • Installing and configuring the Windows DS environment
  • Planning for the MDT environment
  • Implementing MDT 2013 Update 2
  • Integrating Windows DS with MDT
  • Overview of operating system deployment
  • Preparing a site for operating system deployment
  • Deploying an operating system
  • Integrating deployment tools with Configuration Manager
  • Integrating MDT with Configuration Manager
  • Solutions for volume license activation
  • Determining additional client configuration settings
  • Methods for deploying Microsoft Office 2016 editions
  • Customizing Office deployments
  • Deploy Office 2016 by using Office 365
  • Managing Office settings
  • Introducing Windows Store for Business
  • Distributing apps by using Windows Store for Business

This course provides students with the knowledge and skills required to install and configure Windows 10 desktops and devices in a corporate Windows Server domain environment. The skills that this course details include learning how to install and customize Windows 10 operating systems and apps, and configure local and remote network connectivity and storage. Students also will learn how to configure security for data, devices, and networks, and maintain, update, and recover Windows 10.

  • Describe the important new features of Windows 10.
  • Install Windows 10.
  • Configure a device that is running Windows 10.
  • Configure network connectivity for a Windows 10 device.
  • Manage storage in Windows 10.
  • Manage folders and printers.
  • Manage apps.
  • Manage data security.
  • Manage device security.
  • Implement Windows 10 features to improve network security.
  • Restore files, roll back drivers, and recover Windows 10 devices.
  • Monitor and update Windows 10 devices.
  • Original-Microsoft-Training
  • MOC On-Demand is currently available only in English
  • combination of video, text, practical tasks and knowledge tests
  • special offers like discounts are considered when taking the exam.

About Microsoft Official Course On-Demand

The courses are a great alternative for anyone wanting to learn independently and at their own pace. As a participant, you will receive an access to a learning platform developed by Microsoft, providing you with content such as videos, tutorials as well as a Live Lab-Environment for exercises.

As one of the leading Microsoft Learning Partners in Germany, GFN AG works closely with Microsoft together. On request, we can offer you additional services like digital training materials or an individual exam preparation in one of our Training center. For further information, you can also visit the following website MoC On Demand-Infoseite or feel free to contact us.

First published: 23 March 2017


Bitte beachten Sie: Dieser Kurs ist nur noch bis zum 31. März 2019 verfügbar.


This course is for information technology (IT) professionals who administer and support Windows 10 desktops, devices, users, and associated network and security resources. The networks with which these professionals typically work are configured as Windows Server domain-based environments with managed access to the Internet and cloud services. Students who seek certification in the 70-697 Windows 10 Configuring exam also will benefit from this course. Additionally, this course builds skills for Enterprise Desktop/Device Support Technicians who provide Tier 2 support to users who are running Windows 10 desktops and devices within a Windows domain environment in medium-sized and larger organizations.

One more important note, all Microsoft MOC On-Demand courses are currently available in English only. To successfully complete this course, therefore a safe handling like IT-specialized English is essential.


  • Knowledge of networking fundamentals, including TCP/IP, User Datagram Protocol (UDP), and DNS.
  • Knowledge of Active Directory Domain Services (AD DS) principles, and fundamentals of AD DS management.
  • Understanding of certificate-based security.
  • Understanding of Windows Server 2008 or Windows Server 2012 fundamentals.
  • Understanding of Windows client operating system essentials, such as a working knowledge of Windows Vista, Windows 7, or Windows 8.

Recommended system requirements for Microsoft Official Courses On-Demand and labs include:

  • Windows 10
  • Current version of Internet Explorer or Microsoft Edge
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed ActiveX control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required
  • 1280 x 1024 or higher

Note You can also take a MOC On-Demand on your iPad® Retina 4th Generation; however, the lab experience is not optimized for tablets.

Note Regularly scheduled maintenance for the Microsoft Labs Online (MLO) platform is currently at 10?12 P.M. Pacific Time every Thursday. During that time, you may not be able to access the MLO associated with a MOC On-Demand.

The minimum system requirements for MOC On-Demand and labs include:

  • Windows 7 or later
  • Internet Explorer 9 or later
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed Active X control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required

This Online-Training covers the following topics:

  • Introducing Windows 10
  • Navigating the User Interface
  • Installing Windows 10
  • Upgrading to Windows 10
  • Overview of Tools You Can Use to Configure Windows 10
  • Common Configuration Options
  • Managing User Accounts
  • Using OneDrive
  • Configuring IP Network Connectivity
  • Implementing Name Resolution
  • Implementing Wireless Network Connectivity
  • Overview of Remote Access
  • Overview of Storage Options
  • Managing Disks, Partitions, and Volumes
  • Maintaining Disks and Volumes
  • Managing Storage Spaces
  • Overview of File Systems
  • Configuring and Managing File Access
  • Configuring and Managing Shared Folders
  • Work Folders
  • Managing Printers
  • Overview of Providing Apps to Users
  • The Windows Store
  • Web Browsers
  • Overview of Data-Related Security Threats
  • Securing Data with EFS
  • Implementing and Managing BitLocker
  • Using Security Settings to Mitigate Threats
  • Configuring UAC
  • Configuring Application Restrictions
  • Overview of Network-Related Security Threats
  • Windows Firewall
  • Connection Security Rules
  • Windows Defender
  • Managing Devices and Drivers
  • Recovering Files
  • Recovering Devices
  • Updating Windows
  • Monitoring Windows 10
  • Optimizing Performance
  • Configuring Updates for a Single Device
  • Configuring Updates with GPOs
  • Monitoring Events
  • Monitoring Reliability and Performance

This course provides administrators with the knowledge and skills necessary to deploy and manage Windows 10 desktops, devices, and applications in an enterprise environment. Students will learn how to plan and implement Windows 10 deployments in large organizations. Students will also learn how to manage the Windows 10 installations after deployment to provide secure identity and data access by using technologies related to User Experience Virtualization (UE-V), Group Policy, Work Folders and Client Hyper-V. To support a variety of device and data management solutions, Microsoft Azure Active Directory (Azure AD), Microsoft Intune, Microsoft Store for Business and Office 365 are used for device management. These services are part of the Enterprise Mobility+ Security, which provides identity and access management, cloud-based device management, application and update management, and more secure data access to information stored both on the cloud and onsite within your corporate network.

  • Manage PCs and devices in an enterprise environment
  • Deploy Windows 10 enterprise desktops
  • Manage Windows 10 sign-in and identity
  • Manage user profiles and User Experience Virtualization
  • Manage desktop and application settings by using Group Policy
  • Manage devices in Office 365
  • Manage PCs and devices by using Intune
  • Configure and using Microsoft Store for Business
  • Deploy apps and manage information access by using Intune
  • Manage data access for Windows-based devices
  • Configure and manage Client Hyper-V

Bitte beachten Sie: Dieser Kurs ist nur noch bis zum 31. März 2019 verfügbar.


This course is intended for IT professionals who are interested in specializing in Windows 10 desktop and application deployments and in managing the cloud-based application and data service environments for medium-to-large enterprise organizations. These professionals typically work with networks that are configured as Windows Server domain-based environments with managed access to the internet and cloud services.


  • Networking fundamentals, including Transmission Control Protocol /Internet Protocol (TCP/IP), User Datagram Protocol (UDP), and Domain Name System (DNS)
  • Microsoft Active Directory Domain Services (AD DS) and Azure AD principles
  • Windows Server 2016 fundamentals
  • The Windows client operating system essentials; for example, working knowledge of Windows 10 and/or Windows 8.1

The following prerequisites are recommended by Microsoft:

  • Managing Windows 10 in the enterprise
  • Managing a mobile workforce and supporting devices
  • Overview of Enterprise Mobility + Security
  • Overview of Windows 10 enterprise deployment
  • Customizing enterprise deployments
  • Maintaining a Windows 10 installation
  • Volume license activation for Windows 10
  • Overview of enterprise identity
  • Overview of Azure AD Premium P2
  • Extending identity to the cloud
  • Managing user profiles and user state
  • Configuring UE-V
  • Managing user state migration
  • Managing Group Policy Objects
  • Configuring enterprise desktops by using Group Policy policies
  • Overview of Group Policy preferences
  • Overview of Office 365
  • MDM for Office 365
  • Overview of Intune
  • Managing devices by using Intune
  • Basic Intune administration
  • Working with Intune device profiles
  • Conditional access with Intune
  • Managing software updates
  • Using Microsoft Store for Business for app deployment
  • Deploying Windows 10 by using Windows AutoPilot
  • App management by using Intune
  • App deployment and management
  • Working with WIP
  • Overview remote data access solutions
  • Implementing Work Folders
  • Implementing cloud data access
  • Publishing and using RemoteApp programs
  • Installing and configuring Client Hyper-V
  • Configuring virtual switches
  • Creating and managing virtual hard disks
  • Creating and managing VMs

This course provides IT professionals with the knowledge and skills required to install and configure Windows 10 desktops in a Windows Server small to medium-sized AD DS domain environment. These skills include learning how to install and customize Windows 10 operating systems and apps, configure local and remote network connectivity, and configure local and online storage.  Students also will learn how to configure security in addition to how to maintain, update, and recover Windows 10.

  • Plan, install, and upgrade to Windows 10.
  • Perform post-installation configuration.
  • Implement networking.
  • Implement network security.
  • Manage Windows 10 with Group Policy.
  • Implement remote management.
  • Manage local storage.
  • Manage files and resources.
  • Install and manage apps.
  • Secure Windows 10.
  • Implement remote connectivity.
  • Maintain and update Windows 10.
  • Recover and troubleshoot Windows 10.
  • Original-Microsoft-Training
  • MOC On-Demand is currently available only in English
  • combination of video, text, practical tasks and knowledge tests
  • special offers like discounts are considered when taking the exam.

About Microsoft Official Course On-Demand

The courses are a great alternative for anyone wanting to learn independently and at their own pace. As a participant, you will receive an access to a learning platform developed by Microsoft, providing you with content such as videos, tutorials as well as a Live Lab-Environment for exercises.

As one of the leading Microsoft Learning Partners in Germany, GFN AG works closely with Microsoft together. On request, we can offer you additional services like digital training materials or an individual exam preparation in one of our Training center. For further information, you can also visit the following website MoC On Demand-Infoseite or feel free to contact us.

First published: 24. May 2017



  • for IT professionals who administer and support Windows 10 desktops and devices in small to medium-sized networks. The networks with which these professionals typically work are configured as AD DS domain-based environments with managed access to the Internet and cloud services.
  • for Students who seek certification in exam 70-698: Installing and Configuring Windows 10 also will benefit from this course.
  • to provide skills for Enterprise Desktop/Device Support Technicians (EDSTs) who work in small to medium-sized organizations, and who provide Tier 1 or Tier 2 support to users running Windows 10 desktops and devices within a Windows domain environment.

One more important note, all Microsoft MOC On-Demand courses are currently available in English only. To successfully complete this course, therefore a safe handling like IT-specialized English is essential.


  • Networking fundamentals, including TCP/IP, User Datagram Protocol (UDP), and DNS.
  • AD DS principles.
  • Windows Server 2012 R2 or Windows Server 2016 fundamentals.
  • Windows Client essentials, such as a working knowledge of Windows 8.1, Windows 8, or Windows 7.

Recommended system requirements for Microsoft Official Courses On-Demand and labs include:

  • Windows 10
  • Current version of Internet Explorer or Microsoft Edge
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed ActiveX control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required
  • 1280 x 1024 or higher

Note You can also take a MOC On-Demand on your iPad® Retina 4th Generation; however, the lab experience is not optimized for tablets.

Note Regularly scheduled maintenance for the Microsoft Labs Online (MLO) platform is currently at 10?12 P.M. Pacific Time every Thursday. During that time, you may not be able to access the MLO associated with a MOC On-Demand.

The minimum system requirements for MOC On-Demand and labs include:

  • Windows 7 or later
  • Internet Explorer 9 or later
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed Active X control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required

This Online-Training covers the following topics:

  • Overview of Windows 10
  • Planning your Windows 10 deployment
  • Installing and deploying Windows 10
  • Upgrading to Windows 10
  • Windows 10 installation maintenance
  • Managing volume activation
  • Overview of management tools
  • Customizing the user interface
  • Managing devices, device drivers, and services
  • Configuring features, mobility, and power options
  • Overview of Client Hyper-V
  • Homegroups, workgroups, and domains
  • Configuring IPv4 network connectivity
  • Configuring IPv6 network connectivity
  • Implementing name resolution
  • Troubleshooting network connectivity
  • Implementing wireless network connectivity
  • Implementing Windows Firewall
  • Connection security rules
  • Implementing Windows Defender
  • Overview of Group Policy
  • Configuring Windows 10 devices with GPOs
  • Remote Desktop
  • Remote Assistance
  • Using Windows PowerShell Remoting
  • Overview of storage options
  • Managing disks, partitions, and volumes
  • Maintaining disks and volumes
  • Implementing Storage Spaces
  • Implementing and managing OneDrive
  • Working with virtual hard disks
  • Overview of file systems
  • Configuring and managing file access
  • Managing shared folders
  • Implementing Work Folders
  • Managing printers
  • Overview of methods used to deploy apps
  • The Windows Store and Windows Store for Business
  • Desktop Apps
  • Web browsers
  • Managing user accounts
  • Configuring UAC
  • Implementing and Managing BitLocker
  • Overview of remote connectivity options
  • Implementing VPNs
  • Implementing DirectAccess
  • Updating Windows 10
  • Monitoring Windows 10
  • Recovering files
  • Managing devices and device drivers
  • Performing system recovery

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

  • Describe the features Configuration Manager and Intune include, and explain how you can use these features to manage PCs and mobile devices in an enterprise environment.
  • Analyze data by using queries and reports.
  • Prepare a management infrastructure, including configuring boundaries, boundary groups, and resource discovery, and integrating mobile-device management with Microsoft Exchange Server.
  • Deploy and manage the Configuration Manager client.
  • Configure, manage, and monitor hardware and software inventory, and use Asset Intelligence and software metering.
  • Identify and configure the most appropriate method to distribute and manage content used for deployments.
  • Distribute, deploy, and monitor applications for managed users and systems.
  • Maintain software updates for PCs that Configuration Manager manages.
  • Implement Endpoint Protection for managed PCs.
  • Manage configuration items, baselines, and profiles to assess and configure compliance settings and data access for users and devices.
  • Configure an operating-system deployment strategy by using Configuration Manager.
  • Manage and maintain a Configuration Manager site.
  • Original-Microsoft-Training
  • MOC On-Demand is currently available only in English
  • combination of video, text, practical tasks and knowledge tests
  • special offers like discounts are considered when taking the exam.

About Microsoft Official Course On-Demand

The courses are a great alternative for anyone wanting to learn independently and at their own pace. As a participant, you will receive an access to a learning platform developed by Microsoft, providing you with content such as videos, tutorials as well as a Live Lab-Environment for exercises.

As one of the leading Microsoft Learning Partners in Germany, GFN AG works closely with Microsoft together. On request, we can offer you additional services like digital training materials or an individual exam preparation in one of our Training center. For further information, you can also visit the following website MoC On Demand-Infoseite or feel free to contact us.



This course is for experienced information technology (IT) professionals, typically described as Enterprise Desktop Administrators (EDAs). These EDAs deploy, manage, and maintain PCs, devices, and applications across medium, large, and enterprise organizations. A significant portion of this audience uses, or intends to use, the latest release of Configuration Manager to manage and deploy PCs, devices, and applications.

This course also is for individuals who are interested in taking Exam 70-703: Administering System Center Configuration Manager and Cloud Services Integration. Courses 20703-1A and 20703-2A, or equivalent knowledge and skills, are necessary to prepare for this exam.


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

Recommended system requirements for Microsoft Official Courses On-Demand and labs include:

  • Windows 10
  • Current version of Internet Explorer or Microsoft Edge
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed ActiveX control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required
  • 1280 x 1024 or higher

Note You can also take a MOC On-Demand on your iPad® Retina 4th Generation; however, the lab experience is not optimized for tablets.

Note Regularly scheduled maintenance for the Microsoft Labs Online (MLO) platform is currently at 10?12 P.M. Pacific Time every Thursday. During that time, you may not be able to access the MLO associated with a MOC On-Demand.

The minimum system requirements for MOC On-Demand and labs include:

  • Windows 7 or later
  • Internet Explorer 9 or later
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed Active X control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required

This Online-Training covers the following topics:

  • Overview of systems management by using enterprise management solutions
  • Overview of the Configuration Manager architecture
  • Overview of the Configuration Manager administrative tools
  • Tools for monitoring and troubleshooting a Configuration Manager site
  • Introduction to queries
  • Configuring Microsoft SQL Server Reporting Services (SSRS)
  • Configuring site boundaries and boundary groups
  • Configuring resource discovery
  • Configuring the Exchange Server Connector for mobile device management
  • Configuring user and device collections
  • Overview of the Configuration Manager client
  • Deploying the Configuration Manager client
  • Configuring and monitoring client status
  • Managing client settings in Configuration Manager
  • Overview of inventory collection
  • Configuring hardware and software inventory
  • Managing inventory collection
  • Configuring software metering
  • Configuring and managing Asset Intelligence
  • Preparing the infrastructure for content management
  • Distributing and managing content on distribution points
  • Overview of application management
  • Creating applications
  • Deploying applications
  • Managing applications
  • Deploying virtual applications by using System Center Configuration Manager (Optional)
  • Deploying and managing Windows Store apps
  • The software updates process
  • Preparing a Configuration Manager site for software updates
  • Managing software updates
  • Configuring automatic deployment rules
  • Monitoring and troubleshooting software updates
  • Overview of Endpoint Protection in Configuration Manager
  • Configuring, deploying, and monitoring Endpoint Protection policies
  • Overview of Compliance Settings
  • Configuring compliance settings
  • Viewing compliance results
  • Managing resource and data access
  • An overview of operating system deployment
  • Preparing a site for operating system deployment
  • Deploying an operating system
  • Managing Windows as a service
  • Configuring role-based administration
  • Configuring Remote Tools
  • Overview of Configuration Manager site maintenance
  • Backing up and recovering a Configuration Manager site

This is a three-day Instructor Led Training (ILT) course that describes mobile device management (MDM) technologies and the integration of various online cloud services with Microsoft System Center Configuration Manager. This course focuses on both hybrid MDM using Microsoft Intune, and the on-premises MDM scenario. This course also covers integration with online services such as Microsoft Store for Business, Microsoft Office 365, and Microsoft Azure.

  • Describe the challenges in managing a mobile and Internet-based workforce and how Configuration Manager integrated with MDM and cloud services solutions can address these challenges.
  • Describe and configure methods used to manage client devices that are located outside of the corporate network and connected to the Internet.
  • Deploy and manage Microsoft Store for Business apps by using Configuration Manager.
  • Deploy and manage Office 365 apps by using Configuration Manager.
  • Manage mobile devices by using Configuration Manager.
  • Describe and configure a hybrid MDM scenario by using Configuration Manager and Intune.
  • Enroll iOS, Android, and Windows-based devices in a hybrid Configuration Manager and Intune MDM solution.
  • Describe and configure on-premises mobile device management using Configuration Manager.
  • Original-Microsoft-Training
  • MOC On-Demand is currently available only in English
  • combination of video, text, practical tasks and knowledge tests
  • special offers like discounts are considered when taking the exam.

About Microsoft Official Course On-Demand

The courses are a great alternative for anyone wanting to learn independently and at their own pace. As a participant, you will receive an access to a learning platform developed by Microsoft, providing you with content such as videos, tutorials as well as a Live Lab-Environment for exercises.

As one of the leading Microsoft Learning Partners in Germany, GFN AG works closely with Microsoft together. On request, we can offer you additional services like digital training materials or an individual exam preparation in one of our Training center. For further information, you can also visit the following website MoC On Demand-Infoseite or feel free to contact us.



This course is intended for experienced information technology (IT) professionals, typically described as Enterprise Desktop Administrators (EDAs). These EDAs deploy, manage, and maintain PCs, devices, and applications across medium, large, and enterprise organizations. A significant portion of this audience uses or intends to use the latest branch of Configuration Manager and Intune together to manage and deploy PCs, devices, and applications.

The secondary audience for this course are individuals who are interested in taking Exam 70-703: ?Administering System Center Configuration Manager and Cloud Services Integration.?


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

Recommended system requirements for Microsoft Official Courses On-Demand and labs include:

  • Windows 10
  • Current version of Internet Explorer or Microsoft Edge
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed ActiveX control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required
  • 1280 x 1024 or higher

Note You can also take a MOC On-Demand on your iPad® Retina 4th Generation; however, the lab experience is not optimized for tablets.

Note Regularly scheduled maintenance for the Microsoft Labs Online (MLO) platform is currently at 10?12 P.M. Pacific Time every Thursday. During that time, you may not be able to access the MLO associated with a MOC On-Demand.

The minimum system requirements for MOC On-Demand and labs include:

  • Windows 7 or later
  • Internet Explorer 9 or later
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed Active X control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required

This Online-Training covers the following topics:

  • Managing a mobile and distributed workforce
  • Integrating Configuration Manager with cloud services and Internet-based management solutions
  • PKI requirements to support the Internet and MDM
  • Expanding content availability by using cloud-based distribution points
  • Managing a mobile and distributed workforce
  • Methods for managing Internet-based clients
  • Planning and implementing Internet-based client management
  • Planning and implementing Cloud Management Gateway
  • Overview of Microsoft Store for Business
  • Managing Microsoft Store for Business apps by using Configuration Manager
  • Overview of Office 365 ProPlus
  • Deploying Office 365 client applications by using Configuration Manager
  • Managing and updating an Office 365 client deploymentProPlus
  • Overview of mobile device management
  • Configuring the Exchange Server connector for mobile device management
  • Planning and preparing for hybrid MDM
  • Configuring hybrid MDM with Configuration Manager and Intune
  • Enrolling Windows devices into MDM
  • Enrolling Android devices into MDM
  • Enrolling iOS devices into MDM
  • Managing mobile devices in Configuration Manager
  • Overview of oOn-premises mobile device management
  • Configuring oOn-premises MDM by using Configuration Manager

This course is designed primarily for IT professionals who have some experience with Windows Server. It is designed for professionals who will be responsible for managing storage and compute by using Windows Server 2016, and who need to understand the scenarios, requirements, and storage and compute options that are available and applicable to Windows Server 2016.

  • Prepare and install Nano Server, a Server Core installation, and plan a server upgrade and migration strategy.
  • Describe the various storage options, including partition table formats, basic and dynamic disks, file systems, virtual hard disks, and drive hardware, and explain how to manage disks and volumes.
  • Describe enterprise storage solutions, and select the appropriate solution for a given situation.
  • Implement and manage Storage Spaces and Data Deduplication.
  • Install and configure Microsoft Hyper-V.
  • Deploy, configure, and manage Windows and Hyper-V containers.
  • Describe the high availability and disaster recovery technologies in Windows Server 2016.
  • Plan, create, and manage a failover cluster.
  • Implement failover clustering for Hyper-V virtual machines.
  • Configure a Network Load Balancing (NLB) cluster, and plan for an NLB implementation.
  • Create and manage deployment images.
  • Manage, monitor, and maintain virtual machine installations.
  • Original-Microsoft-Training
  • MOC On-Demand is currently available only in English
  • combination of video, text, practical tasks and knowledge tests
  • special offers like discounts are considered when taking the exam.

About Microsoft Official Course On-Demand

The courses are a great alternative for anyone wanting to learn independently and at their own pace. As a participant, you will receive an access to a learning platform developed by Microsoft, providing you with content such as videos, tutorials as well as a Live Lab-Environment for exercises.

As one of the leading Microsoft Learning Partners in Germany, GFN AG works closely with Microsoft together. On request, we can offer you additional services like digital training materials or an individual exam preparation in one of our Training center. For further information, you can also visit the following website MoC On Demand-Infoseite or feel free to contact us.

First published: 16. March 2017



  • Windows Server administrators who are relatively new to Windows Server administration and related technologies, and who want to learn more about the storage and compute features in Windows Server 2016.
  • IT professionals with general IT knowledge, who are looking to gain knowledge about Windows Server, especially around storage and compute technologies in Windows Server 2016.

One more important note, all Microsoft MOC On-Demand courses are currently available in English only. To successfully complete this course, therefore a safe handling like IT-specialized English is essential.


  • A basic understanding of networking fundamentals
  • An awareness and understanding of security best practices
  • An understanding of basic AD DS concepts
  • Basic knowledge of server hardware
  • Experience supporting and configuring Windows client operating systems such as Windows 8 or Windows 10

Recommended system requirements for Microsoft Official Courses On-Demand and labs include:

  • Windows 10
  • Current version of Internet Explorer or Microsoft Edge
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed ActiveX control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required
  • 1280 x 1024 or higher

Note You can also take a MOC On-Demand on your iPad® Retina 4th Generation; however, the lab experience is not optimized for tablets.

Note Regularly scheduled maintenance for the Microsoft Labs Online (MLO) platform is currently at 10?12 P.M. Pacific Time every Thursday. During that time, you may not be able to access the MLO associated with a MOC On-Demand.

The minimum system requirements for MOC On-Demand and labs include:

  • Windows 7 or later
  • Internet Explorer 9 or later
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed Active X control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy clien

This Online-Training covers the following topics:

  • Introducing Windows Server 2016
  • Preparing and installing Nano Server and Server Core
  • Preparing for upgrades and migrations
  • Migrating server roles and workloads
  • Windows Server activation models
  • Managing disks in Windows Server 2016
  • Managing volumes in Windows Server 2016
  • Overview of direct-attached storage, network-attached storage, and storage area networks
  • Comparing Fibre Channel, iSCSI, and FCoE
  • Understanding iSNS, data centre bridging, and MPIO
  • Configuring sharing in Windows Server 2016
  • Implementing Storage Spaces
  • Managing Storage Spaces
  • Implementing Data Deduplication
  • Overview of Hyper-V
  • Installing Hyper-V
  • Configuring storage on Hyper-V host servers
  • Configuring networking on Hyper-V host servers
  • Configuring Hyper-V virtual machines
  • Managing Hyper-V virtual machines
  • Overview of containers in Windows Server 2016
  • Deploying Windows Server and Hyper-V containers
  • Installing, configuring, and managing containers
  • Defining levels of availability
  • Planning high availability and disaster recovery solutions with Hyper-V virtual machines
  • Backing up and restoring the Windows Server 2016 operating system and data by using Windows Server B
  • High availability with failover clustering in Windows Server 2016
  • Planning a failover cluster
  • Creating and configuring a new failover cluster
  • Maintaining a failover cluster
  • Troubleshooting a failover cluster
  • Implementing site high availability with stretch clustering
  • Overview of integrating Hyper-V in Windows Server 2016 with failover clustering
  • Implementing and maintaining Hyper-V virtual machines on failover clusters
  • Key features for virtual machines in a clustered environment
  • Overview of NLB clusters
  • Configuring an NLB cluster
  • Planning an NLB implementation
  • Introduction to deployment images
  • Creating and managing deployment images by using MDT
  • Virtual machine environments for different workloads
  • WSUS overview and deployment options
  • Update management process with WSUS
  • Overview of PowerShell DSC
  • Overview of Windows Server 2016 monitoring tools
  • Using Performance Monitor
  • Monitoring Event Logs

This course provides the fundamental networking skills required to deploy and support Windows Server 2016 in most organizations. It covers IP fundamentals, remote access technologies, and more advanced content including Software Defined Networking.

  • Plan and implement an IPv4 network.
  • Implement Dynamic Host Configuration Protocol (DHCP).
  • Implement IPv6.
  • Implement Domain Name System (DNS).
  • Implement and manage IP address management (IPAM).
  • Plan for remote access.
  • Implement DirectAccess.
  • Implement virtual private networks (VPNs).
  • Implement networking for branch offices.
  • Configure advanced networking features.
  • Implement Software Defined Networking.
  • Original-Microsoft-Training
  • MOC On-Demand is currently available only in English
  • combination of video, text, practical tasks and knowledge tests
  • special offers like discounts are considered when taking the exam.

About Microsoft Official Course On-Demand

The courses are a great alternative for anyone wanting to learn independently and at their own pace. As a participant, you will receive an access to a learning platform developed by Microsoft, providing you with content such as videos, tutorials as well as a Live Lab-Environment for exercises.

As one of the leading Microsoft Learning Partners in Germany, GFN AG works closely with Microsoft together. On request, we can offer you additional services like digital training materials or an individual exam preparation in one of our Training center. For further information, you can also visit the following website MoC On Demand-Infoseite or feel free to contact us.

First published: 23. February 2017



  • Network administrators who are looking to reinforce existing skills and learn about new networking technology changes and functionality in Windows Server 2016.
  • System or Infrastructure Administrators with general networking knowledge who are looking to gain core and advanced networking knowledge and skills on Windows Server 2016.

One more important note, all Microsoft MOC On-Demand courses are currently available in English only. To successfully complete this course, therefore a safe handling like IT-specialized English is essential.


  • Experience working with Windows Server 2008 or Windows Server 2012
  • Experience working in a Windows Server infrastructure enterprise environment
  • Knowledge of the Open Systems Interconnection (OSI) model
  • Understanding of core networking infrastructure components and technologies such as cabling, routers, hubs, and switches
  • Familiarity with networking topologies and architectures such as local area networks (LANs), wide area networks (WANs) and wireless networking
  • Some basic knowledge of the TCP/IP protocol stack, addressing and name resolution
  • Experience with and knowledge of Hyper-V and virtualization
  • Hands-on experience working with the Windows client operating systems such as Windows 8.1 or Windows 10

Recommended system requirements for Microsoft Official Courses On-Demand and labs include:

  • Windows 10
  • Current version of Internet Explorer or Microsoft Edge
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed ActiveX control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required
  • 1280 x 1024 or higher

Note You can also take a MOC On-Demand on your iPad® Retina 4th Generation; however, the lab experience is not optimized for tablets.

Note Regularly scheduled maintenance for the Microsoft Labs Online (MLO) platform is currently at 10?12 P.M. Pacific Time every Thursday. During that time, you may not be able to access the MLO associated with a MOC On-Demand.

The minimum system requirements for MOC On-Demand and labs include:

  • Windows 7 or later
  • Internet Explorer 9 or later
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed Active X control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required

This Online-Training covers the following topics:

  • Planning IPv4 addressing
  • Configuring an IPv4 host
  • Managing and troubleshooting IPv4 network connectivity
  • Overview of the DHCP server role
  • Deploying DHCP
  • Managing and troubleshooting DHCP
  • Overview of IPv6 addressing
  • Configuring an IPv6 host
  • Implementing IPv6 and IPv4 coexistence
  • Transitioning from IPv4 to IPv6
  • Overview of IPv6 addressing
  • Configuring an IPv6 host
  • Implementing IPv6 and IPv4 coexistence
  • Transitioning from IPv4 to IPv6
  • Overview of IPv6 addressing
  • Configuring an IPv6 host
  • Implementing IPv6 and IPv4 coexistence
  • Transitioning from IPv4 to IPv6
  • Overview of remote access
  • Implementing Web Application Proxy
  • Overview of DirectAccess
  • Implementing DirectAccess by using the Getting Started Wizard
  • Implementing and managing an advanced DirectAccess infrastructure
  • Planning VPNs
  • Implementing VPNs
  • Networking features and considerations for branch offices
  • Implementing Distributed File System (DFS) for branch offices
  • Implementing BranchCache for branch offices
  • Overview of high performance networking features
  • Configuring advanced Microsoft Hyper-V networking features
  • Overview of Software Defined Networking
  • Implementing network virtualization
  • Implementing Network Controller

This course teaches IT Pros how to deploy and configure Active Directory Domain Services (AD DS) in a distributed environment, how to implement Group Policy, how to perform backup and restore, and howto monitor and troubleshoot Active Directory?related issues with Windows Server 2016. Additionally, this course teaches how to deploy other Active Directory server roles such as Active Directory Federation Services (AD FS) and Active Directory Certificate Services (AD CS).

  • Install and configure domain controllers.
  • Manage objects in AD DS by using graphical tools and Windows PowerShell.
  • Implement AD DS in complex environments.
  • Implement AD DS sites, and configure and manage replication.
  • Implement and manage Group Policy Objects (GPOs).
  • Manage user settings by using GPOs.
  • Secure AD DS and user accounts.
  • Implement and manage a certificate authority (CA) hierarchy with AD CS.
  • Deploy and manage certificates.
  • Implement and administer AD FS.
  • Implement and administer Active Directory Rights Management Services (AD RMS).
  • Implement synchronization between AD DS and Azure AD.
  • Monitor, troubleshoot, and establish business continuity for AD DS services.
  • Original-Microsoft-Training
  • MOC On-Demand is currently available only in English
  • combination of video, text, practical tasks and knowledge tests
  • special offers like discounts are considered when taking the exam.

About Microsoft Official Course On-Demand

The courses are a great alternative for anyone wanting to learn independently and at their own pace. As a participant, you will receive an access to a learning platform developed by Microsoft, providing you with content such as videos, tutorials as well as a Live Lab-Environment for exercises.

As one of the leading Microsoft Learning Partners in Germany, GFN AG works closely with Microsoft together. On request, we can offer you additional services like digital training materials or an individual exam preparation in one of our Training center. For further information, you can also visit the following website MoC On Demand-Infoseite or feel free to contact us.

First published: 29. March 2017



This course is primarily intended for existing IT professionals who have some AD DS knowledge and experience and who aim to develop knowledge about identity and access technologies in Windows Server 2016.

  • AD DS administrators who are looking to train in identity and access technologies with Windows Server 2012 or Windows Server 2016.
  • System or infrastructure administrators with general AD DS experience and knowledge who are looking to cross-train in core and advanced identity and access technologies in Windows Server 2012 or Windows Server 2016.

The secondary audience for this course includes IT professionals who are looking to consolidate their knowledge about AD DS and related technologies, in addition to IT professionals who want to prepare for the 70-742 exam.

One more important note, all Microsoft MOC On-Demand courses are currently available in English only. To successfully complete this course, therefore a safe handling like IT-specialized English is essential.


  • Some exposure to and experience with AD DS concepts and technologies in Windows Server 2012 or Windows Server 2016.
  • Experience working with and configuring Windows Server 2012 or Windows Server 2016
  • Experience and an understanding of core networking technologies such as IP addressing, name resolution, and Dynamic Host Configuration Protocol (DHCP).
  • Experience working with and an understanding of Microsoft Hyper-V and basic server virtualization concepts.
  • An awareness of basic security best practices.
  • Hands-on working experience with Windows client operating systems such as Windows 7, Windows 8, Windows 8.1, or Windows 10.
  • Basic experience with the Windows PowerShell command-line interface.

Recommended system requirements for Microsoft Official Courses On-Demand and labs include:

  • Windows 10
  • Current version of Internet Explorer or Microsoft Edge
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed ActiveX control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required
  • 1280 x 1024 or higher

Note You can also take a MOC On-Demand on your iPad® Retina 4th Generation; however, the lab experience is not optimized for tablets.

Note Regularly scheduled maintenance for the Microsoft Labs Online (MLO) platform is currently at 10?12 P.M. Pacific Time every Thursday. During that time, you may not be able to access the MLO associated with a MOC On-Demand.

The minimum system requirements for MOC On-Demand and labs include:

  • Windows 7 or later
  • Internet Explorer 9 or later
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed Active X control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required

This Online-Training covers the following topics:

  • Overview of AD DS
  • Overview of AD DS domain controllers
  • Deploying a domain controller
  • Deploying AD DS
  • Deploying domain controllers by performing domain controller cloning
  • Administering AD DS
  • Describe AD DS and its main components.
  • Describe the purpose of domain controllers and their roles.
  • Describe the considerations for deploying domain controllers.
  • Managing user accounts
  • Managing groups in AD DS
  • Managing computer objects in AD DS
  • Using Windows PowerShell for AD DS administration
  • Implementing and managing OUs
  • Creating and managing groups in AD DS
  • Creating and configuring user accounts in AD DS
  • Managing computer objects in AD DS
  • Delegate administration for OUs
  • Creating and modifying AD DS objects with Windows PowerShell
  • Manage user accounts in AD DS.
  • Manage groups in AD DS.
  • Manage computer objects in AD DS.
  • Use Windows PowerShell for AD DS administration.
  • Implement and manage OUs.
  • Administer AD DS.
  • Overview of advanced AD DS deployments
  • Deploying a distributed AD DS environment
  • Configuring AD DS trusts
  • Implementing forest trusts
  • Implementing child domains in AD DS
  • Describe the components of an advanced AD DS deployment.
  • Explain how to deploy a distributed AD DS environment.
  • Explain how to configure AD DS trusts.
  • Overview of AD DS replication
  • Configuring AD DS sites
  • Configuring and monitoring AD DS replication
  • Modifying the default site
  • Creating additional sites and subnets
  • Configuring AD DS replication
  • Monitoring and troubleshooting AD DS replication
  • Describe how AD DS replication works.
  • Configure AD DS sites to help optimize authentication and replication traffic.
  • Configure and monitor AD DS replication.
  • Introducing Group Policy
  • Implementing and administering GPOs
  • Group Policy scope and Group Policy processing
  • Troubleshooting the application of GPOs
  • Creating and configuring GPOs
  • Managing GPO scope
  • Verify GPO application
  • Troubleshooting GPOs
  • Explain what Group Policy is.
  • Implement and administer GPOs.
  • Describe Group Policy scope and Group Policy processing.
  • Troubleshoot GPO application.
  • Implementing administrative templates
  • Configuring Folder Redirection, Software Installation, and Scripts
  • Configuring Group Policy preferences
  • Using administrative templates to manage user settings
  • Implement settings by using Group Policy preferences
  • Configuring Folder Redirection
  • Planning Group Policy (optional)
  • Implement administrative templates.
  • Configure Folder Redirection, software installation, and scripts.
  • Configure Group Policy preferences.
  • Securing domain controllers
  • Implementing account security
  • Implementing audit authentication
  • Configuring managed service accounts
  • Implementing security policies for accounts, passwords, and administrative groups
  • Deploying and configuring an RODC
  • Creating and associating a group MSA
  • Secure domain controllers.
  • Implement account security.
  • Implement audit authentication.
  • Configure managed service accounts (MSAs).
  • Deploying CAs
  • Administering CAs
  • Troubleshooting and maintaining CAs
  • Deploying an offline root CA
  • Deploying an enterprise subordinate CA
  • Deploy CAs.
  • Administer CAs.
  • Troubleshoot and maintain CAs.
  • Deploying and managing certificate templates
  • Managing certificate deployment, revocation, and recovery
  • Using certificates in a business environment
  • Implementing and managing smart cards
  • Configuring certificate templates
  • Enrolling and using certificates
  • Configuring and implementing key recovery
  • Deploy and manage certificate templates.
  • Manage certificates deployment, revocation, and recovery.
  • Use certificates in a business environment.
  • Implement and manage smart cards
  • Overview of AD FS
  • AD FS requirements and planning
  • Deploying and configuring AD FS
  • Overview of Web Application Proxy
  • Configuring AD FS prerequisites
  • Installing and configuring AD FS
  • Configuring an internal application for AD
  • Configuring AD FS for federated business partners
  • Describe AD FS.
  • Explain how to deploy AD FS.
  • Explain how to implement AD FS for a single organization.
  • Explain how to extend AD FS to external clients.
  • Implement single sign-on (SSO) to support online services.
  • Overview of AD RMS
  • Deploying and managing an AD RMS infrastructure
  • Configuring AD RMS content protection
  • Installing and configuring AD RMS
  • Configuring AD RMS templates
  • Using AD RMS on clients
  • Describe AD RMS.
  • Describe usage scenarios for AD RMS.
  • Describe the AD RMS components.
  • Planning and preparing for directory synchronization
  • Implementing directory synchronization by using Azure AD Connect
  • Managing identities with directory synchronization
  • Preparing for directory synchronization
  • Configuring directory synchronization
  • Managing Active Directory users and groups
  • Plan and prepare for directory synchronization.
  • Implement directory synchronization by using Microsoft Azure Active Directory Connect (Azure AD Connect).
  • Manage identities with directory synchronization.
  • Monitoring AD DS
  • Managing the Active Directory database
  • Active Directory backup and recovery options for AD DS and other identity and access solutions
  • Backing up and restoring AD DS
  • Recovering objects in AD DS
  • Monitor AD DS.
  • Manage the Active Directory database.
  • Describe the backup and recovery options for AD DS and other identity access solutions.

This course explains how to implement and configure new Windows Server 2016 features and functionality. This course is for information technology (IT) professionals who want to upgrade their technicalskills from Windows Server 2008 or Windows Server 2012 to Windows Server 2016. This course presumes a high level of knowledge about previous Windows Server technologies and skills equivalent to the Microsoft Certified Solutions Associate (MCSA): Windows Server 2008 or Windows Server 2012 credential.

  • Install and configure Windows Server 2016
  • Describe storage in Windows Server 2016
  • Implement directory services
  • Implement Active Directory Federation Services (AD FS)
  • Describe networking
  • Implement Hyper-V
  • Configure advanced networking features
  • Implement software-defined networking
  • Implement remote access
  • Deploy and manage Windows and Hyper-V containers
  • Implement failover clustering
  • Implement failover clustering by using virtual machines
  • Original-Microsoft-Training
  • MOC On-Demand is currently available only in English
  • combination of video, text, practical tasks and knowledge tests
  • special offers like discounts are considered when taking the exam.

About Microsoft Official Course On-Demand

The courses are a great alternative for anyone wanting to learn independently and at their own pace. As a participant, you will receive an access to a learning platform developed by Microsoft, providing you with content such as videos, tutorials as well as a Live Lab-Environment for exercises.

As one of the leading Microsoft Learning Partners in Germany, GFN AG works closely with Microsoft together. On request, we can offer you additional services like digital training materials or an individual exam preparation in one of our Training center. For further information, you can also visit the following website MoC On Demand-Infoseite or feel free to contact us.

First published: 05. May 2017



This course is for IT professionals who are experienced Windows Server 2012 or Windows Server 2008 system administrators, with real-world experience working in a Windows Server 2008 R2 or Windows Server 2008 enterprise environment. Additionally, students should have obtained the MCSA credential for Windows Server 2008 or Windows Server 2012, or they should have equivalent knowledge.

One more important note, all Microsoft MOC On-Demand courses are currently available in English only. To successfully complete this course, therefore a safe handling like IT-specialized English is essential.


  • Two or more years of experience with deploying and managing Windows Server 2012 or Windows Server 2008 environments; NS experience with day-to-day Windows Server 2012 or Windows Server 2008 system-administration management and maintenance tasks.
  • Experience with Windows networking technologies and implementation.
  • Experience with Active Directory technologies and implementation.
  • Experience with Windows Server virtualization technologies and implementation.
  • Knowledge equivalent to the MCSA credentials of Windows Server 2008 or Windows Server 2012.

Recommended system requirements for Microsoft Official Courses On-Demand and labs include:

  • Windows 10
  • Current version of Internet Explorer or Microsoft Edge
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed ActiveX control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required
  • 1280 x 1024 or higher

Note You can also take a MOC On-Demand on your iPad® Retina 4th Generation; however, the lab experience is not optimized for tablets.

Note Regularly scheduled maintenance for the Microsoft Labs Online (MLO) platform is currently at 10?12 P.M. Pacific Time every Thursday. During that time, you may not be able to access the MLO associated with a MOC On-Demand.

The minimum system requirements for MOC On-Demand and labs include:

  • Windows 7 or later
  • Internet Explorer 9 or later
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed Active X control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required

This Online-Training covers the following topics:

  • Introducing Windows Server 2016
  • Installing Windows Server 2016
  • Configuring Windows Server 2016
  • Preparing for upgrades and migrations
  • Migrating server roles and workloads
  • Windows Server activation models
  • Overview of storage in Windows Server 2016
  • Configuring Internet SCSI (iSCSI) storage
  • Configuring the Storage Spaces feature in Windows Server 2016
  • Implementing the Data Deduplication feature
  • Deploying AD DS domain controllers
  • Implementing service accounts
  • What is Azure AD?
  • Overview of AD FS
  • Deploying AD FS
  • Implementing AD FS for a single organization
  • Implementing Web Application Proxy
  • Implementing Azure AD FS SSO with Microsoft Online Services
  • Overview of networking enhancements
  • Implementing the IP address management
  • Managing IP address spaces with IPAM
  • Configuring the Hyper-V role in Windows Server 2016
  • Configuring Hyper-V storage
  • Configuring Hyper-V networking
  • Configuring Hyper-V virtual machines
  • Overview of high-performance networking features
  • Configuring advanced Hyper-V networking features
  • Overview of software-defined networking
  • Implementing network virtualization
  • Implementing the Network Controller feature
  • Remote access overview
  • Implementing DirectAccess
  • Implementing a virtual private network (VPN)
  • Overview of Windows Server 2016 containers
  • Deploying Windows Server and Hyper-V containers
  • Installing, configuring, and managing containers
  • Overview of failover clustering
  • Implementing a failover cluster
  • Configuring highly-available applications and services on a failover cluster
  • Maintaining a failover cluster
  • Implementing a stretch cluster
  • Overview of the integration of Hyper-V Server 2016 with failover clustering
  • Implementing Hyper-V virtual machines on failover clusters
  • Implementing Windows Server 2016 Hyper-V virtual machine migration
  • Implementing the Hyper-V Replica feature

This course teaches IT professionals how they can enhance the security of the IT infrastructure that they administer. This course begins by emphasizing the importance of assuming that network breacheshave occurred already, and then teaches you how to protect administrative credentials and rights to ensure that administrators can perform only the tasks that they need to, when they need to. This course also details how you can mitigate malware threats, identify security issues by using auditing and the Advanced Threat Analysis feature in Windows Server 2016, secure your virtualization platform,and use new deployment options, such as Nano server and containers to enhance security. The course also explains how you can help protect access to files by using encryption and dynamic access control, and how you can enhance your network?s security.

  • Secure Windows Server.
  • Secure application development and a server workload infrastructure.
  • Manage security baselines.
  • Configure and manage just enough and just-in-time (JIT) administration.
  • Manage data security.
  • Configure Windows Firewall and a software-defined distributed firewall.
  • Secure network traffic.
  • Secure your virtualization infrastructure.
  • Manage malware and threats.
  • Configure advanced auditing.
  • Manage software updates.
  • Manage threats by using Advanced Threat Analytics (ATA) and Microsoft Operations Management Suite (OMS).
  • Original-Microsoft-Training
  • MOC On-Demand is currently available only in English
  • combination of video, text, practical tasks and knowledge tests
  • special offers like discounts are considered when taking the exam.

About Microsoft Official Course On-Demand

The courses are a great alternative for anyone wanting to learn independently and at their own pace. As a participant, you will receive an access to a learning platform developed by Microsoft, providing you with content such as videos, tutorials as well as a Live Lab-Environment for exercises.

As one of the leading Microsoft Learning Partners in Germany, GFN AG works closely with Microsoft together. On request, we can offer you additional services like digital training materials or an individual exam preparation in one of our Training center. For further information, you can also visit the following website MoC On Demand-Infoseite or feel free to contact us.

First published: 25. May 2017



This course is for IT professionals who need to administer Windows Server 2016 networks securely. These professionals typically work with networks that are configured as Windows Server domain-based environments, with managed access to the Internet and cloud services.

Students who seek certification in the 70-744 Securing Windows server exam also will benefit from this course.

One more important note, all Microsoft MOC On-Demand courses are currently available in English only. To successfully complete this course, therefore a safe handling like IT-specialized English is essential.


  • Completed courses 740, 741, and 742, or the equivalent.
  • A solid, practical understanding of networking fundamentals, including TCP/IP, User Datagram Protocol (UDP), and Domain Name System (DNS).
  • A solid, practical understanding of Active Directory Domain Services (AD DS) principles.
  • A solid, practical understanding of Microsoft Hyper-V virtualization fundamentals.
  • An understanding of Windows Server security principles.

Recommended system requirements for Microsoft Official Courses On-Demand and labs include:

  • Windows 10
  • Current version of Internet Explorer or Microsoft Edge
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed ActiveX control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required
  • 1280 x 1024 or higher

Note You can also take a MOC On-Demand on your iPad® Retina 4th Generation; however, the lab experience is not optimized for tablets.

Note Regularly scheduled maintenance for the Microsoft Labs Online (MLO) platform is currently at 10?12 P.M. Pacific Time every Thursday. During that time, you may not be able to access the MLO associated with a MOC On-Demand.

The minimum system requirements for MOC On-Demand and labs include:

  • Windows 7 or later
  • Internet Explorer 9 or later
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed Active X control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required

This Online-Training covers the following topics:

  • Overview of breach detection
  • Using the Sysinternals tools to detect breaches
  • Identifying attack types
  • Using incident-response strategies
  • Exploring the Sysinternals tools
  • Describe breach detection.
  • Describe how to detect a breach by using the Sysinternals tools.
  • Understanding user rights
  • Computer and service accounts
  • Protecting credentials
  • Understanding privileged-access workstations and jump servers
  • Deploying a local administrator-password solution
  • Configuring security options
  • Configuring restricted groups
  • Delegating privileges
  • Creating and managing group managed service accounts (MSAs)
  • Configuring the Credential Guard feature
  • Locating problematic accounts
  • Installing local administrator password solution (LAPs)
  • Configuring LAPs
  • Deploying LAPs
  • Understand user rights.
  • Describe computer and service accounts.
  • Help protect credentials.
  • Understand privileged-access workstations and jump servers.
  • Understand how to use a local administrator-password solution.
  • Understanding JEA
  • Configuring and deploying JEA
  • Creating a role-capability file
  • Creating a session-configuration file
  • Creating a JEA endpoint
  • Connecting to a JEA endpoint
  • Deploying JEA by using Desire State Configuration (DSC)
  • Understand JEA.
  • Configure and deploy JEA.
  • Understanding ESAE forests
  • Overview of MIM
  • Implementing JIT and Privileged Access Management by using MIM
  • Using a layered approach to security
  • Exploring MIM
  • Configuring a MIM web portal
  • Configuring the Privileged Access feature
  • Requesting privileged access
  • Understand enhanced security administrative environment forests.
  • Understand MIM.
  • Understand how to implement JIT and Privileged Access Management by using MIM.
  • Configuring and managing Windows Defender
  • Using software restricting policies (SRPs) and AppLocker
  • Configuring and using Device Guard
  • Using and deploying the Enhanced Mitigation Experience Toolkit
  • Configuring Windows Defender
  • Configuring AppLocker
  • Configuring and deploying Device Guard
  • Deploying and using EMET
  • After completing this module, students will be able to:
  • Configure and manage Windows Defender.
  • Use Software Restricting Policies and AppLocker.
  • Configure and use Device Guard.
  • Use and deploy the EMET.
  • Overview of auditing
  • Understanding advanced auditing
  • Configuring Windows PowerShell auditing and logging
  • Configuring auditing of file-system access
  • Auditing domain logons
  • Managing the configuration of advanced audit policies
  • Windows PowerShell logging and auditing
  • Understanding auditing.
  • Understand advanced auditing.
  • Audit and log Windows PowerShell.
  • Overview of Advanced Threat Analytics
  • Understanding OMS
  • Using ATA and OMS
  • Preparing and deploying ATA
  • Preparing and deploying OMS
  • Understand Advanced Threat Analytics.
  • Understand OMS.
  • Overview of Guarded Fabric VMs
  • Understanding shielded and encryption-supported VMs
  • Deploying Guarded Fabric VMs with administrator-trusted attestation
  • Deploying a shielded VM
  • Understand Guarded Fabric VMs.
  • Understand shielded and encryption-supported VMs.
  • Using Security Compliance Manager
  • Introduction to Nano Server
  • Understanding containers
  • Configuring a security baseline for Windows Server 2016
  • Deploying a security baseline for Windows Server 2016
  • Deploying, managing, and securing Nano Server
  • Deploying, managing, and securing Windows Server containers
  • Deploying, managing, and securing Hyper-V containers
  • Understand Security Compliance Manager.
  • Describe Nano Server.
  • Understand containers.
  • Planning and implementing encryption
  • Planning and implementing BitLocker
  • Encrypting and recovering access to encrypted files
  • Using BitLocker to protect data
  • Plan and implement encryption.
  • Plan and implement BitLocker.
  • Introduction to FSRM
  • Implementing classification management and file-management tasks
  • Understanding Dynamic Access Control (DAC)
  • Configuring FSRM quotas
  • Configuring file screening
  • Preparing DAC
  • Implementing DAC
  • Understand FSRM.
  • Implement classification management and file-management tasks.
  • Understand DAC.
  • Understanding Windows Firewall
  • Software-defined distributed firewalls
  • Creating and testing inbound rules
  • Creating and testing outbound rules
  • Describe Windows Firewall.
  • Understand software-defined distributed firewalls.
  • Network-related security threats and connection-security rules
  • Configuring advanced DNS settings
  • Examining network traffic with Microsoft Message Analyzer
  • Securing SMB traffic, and analysing SMB traffic
  • Creating and testing connection security rules
  • Configuring and testing DNSSEC
  • Using Microsoft Message Analyzer
  • Configuring and verifying SMB encryption on SMB shares
  • Understand network-related security threats and connection security rules.
  • Configure advanced DNS settings.
  • Examine network traffic with Microsoft Message Analyzer.
  • Secure SMB traffic, and analyze SMB traffic.
  • Overview of WSUS
  • Deploying updates by using WSUS
  • Implementing the WSUS server role
  • Configuring update settings
  • Approving and deploying an update by using WSUS
  • Deploying Windows Defender definition updates by using WSUS
  • Understand WSUS.
  • Deploy updates with WSUS.

This course explains how to implement and manage virtualization infrastructure in a software-defined datacenter by using System Center 2016 Virtual Machine Manager. The course also describes how to monitor the infrastructure by using System Center Operations Manager and protect it by using Data Protection Manager.

The main focus of this course is on managing Hyper-V virtualization infrastructure in Windows Server 2016, although the course also covers other virtualization platforms that can be managed by using Virtual Machine Manager 2016.

  • Explain the different virtualization options.
  • Install and manage Hyper-V on Windows Server 2016.
  • Install and configure System Center 2016 Virtual Machine Manager.
  • Manage storage fabric and fabric updates.
  • Configure and manage Virtual Machine Manager library and library objects.
  • Manage the networking fabric.
  • Create and manage virtual machines by using Virtual Machine Manager.
  • Manage clouds in Virtual Machine Manager.
  • Manage services in Virtual Machine Manager.
  • Monitor virtualization infrastructure by using System Center Operations Manager.
  • Implement and manage Hyper-V Replica and Azure Site Recovery.
  • Protect virtualization infrastructure by using Data Protection Manager.
  • Original-Microsoft-Training
  • MOC On-Demand is currently available only in English
  • combination of video, text, practical tasks and knowledge tests
  • special offers like discounts are considered when taking the exam.

About Microsoft Official Course On-Demand

The courses are a great alternative for anyone wanting to learn independently and at their own pace. As a participant, you will receive an access to a learning platform developed by Microsoft, providing you with content such as videos, tutorials as well as a Live Lab-Environment for exercises.

As one of the leading Microsoft Learning Partners in Germany, GFN AG works closely with Microsoft together. On request, we can offer you additional services like digital training materials or an individual exam preparation in one of our Training center. For further information, you can also visit the following website MoC On Demand-Infoseite or feel free to contact us.

First published: 13 July 2017



This course is intended for IT professionals and administrators who are responsible for designing, implementing, and managing virtualization infrastructure in a software-defined datacenter by using System Center 2016 Virtual Machine Manager.

This course is also intended for IT decision makers who want to determine which virtualization product to implement in their software-defined datacenters and who want to become familiar with the System Center 2016 solution for managing virtualization infrastructure.

One more important note, all Microsoft MOC On-Demand courses are currently available in English only. To successfully complete this course, therefore a safe handling like IT-specialized English is essential.


  • An understanding of TCP/IP and networking concepts
  • An understanding of different storage technologies and concepts
  • Familiarity with different types of virtualizations
  • Familiarity with Windows Server and Windows Server administration
  • An understanding of Windows PowerShell
  • Students should have the ability to work in a team/virtual team and possess good documentation and communication skills.

Recommended system requirements for Microsoft Official Courses On-Demand and labs include:

  • Windows 10
  • Current version of Internet Explorer or Microsoft Edge
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed ActiveX control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required
  • 1280 x 1024 or higher

Note You can also take a MOC On-Demand on your iPad® Retina 4th Generation; however, the lab experience is not optimized for tablets.

Note Regularly scheduled maintenance for the Microsoft Labs Online (MLO) platform is currently at 10?12 P.M. Pacific Time every Thursday. During that time, you may not be able to access the MLO associated with a MOC On-Demand.

The minimum system requirements for MOC On-Demand and labs include:

  • Windows 7 or later
  • Internet Explorer 9 or later
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed Active X control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required

This Online-Training covers the following topics:

  • Overview of Microsoft Virtualization
  • Introduction to the Software-Defined Datacenter
  • Extending virtualization to the cloud
  • Installing and configuring the Hyper-V role
  • Creating and managing virtual hard disks and virtual machines
  • Creating and using Hyper-V virtual switches
  • Implementing failover clustering with Hyper-V
  • Overview of System Center 2016 Virtual Machine Manager
  • Installing System Center 2016 Virtual Machine Manager
  • Adding hosts and managing host groups
  • Overview of server virtualization storage technologies
  • Managing storage fabric
  • Managing fabric updates
  • Overview of the Virtual Machine Manager library
  • Preparing Windows for deployment in Virtual Machine Manager
  • Working with profiles
  • Working with VM templates
  • Networking concepts in Virtual Machine Manager
  • Managing software-defined networking
  • Configuring network virtualization
  • Virtual machine management tasks
  • Creating, cloning, and converting virtual machines
  • Introduction to clouds
  • Creating and managing a cloud
  • Creating user roles in Virtual Machine Manager
  • Overview of services in Virtual Machine Manager
  • Creating and managing services in Virtual Machine Manager
  • Operations Manager architecture and security
  • Using Operations Manager for monitoring and reporting
  • Integrating Operations Manager with Virtual Machine Manager and Data Protection Manager
  • Implementing and managing Hyper-V Replica
  • Implementing and managing Azure Site Recovery
  • Overview of backup and restore options for virtual machines
  • Configuring and managing Data Protection Manager for virtualization infrastructure protection

The main purpose of this 3 day instructor led  course is to give students a good understanding of the Transact-SQL language which is used by all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. As such, the primary target audience for this course is: Database Administrators, Database Developers and BI professionals. The course will very likely be well attended by SQL power users who aren?t necessarily database-focused; namely, report writers, business analysts and client application developers.

  • Describe the basic architecture and concepts of Microsoft SQL Server 2016.
  • Understand the similarities and differences between Transact-SQL and other computer languages.
  • Write SELECT queries
  • Query multiple tables
  • Sort and filter data
  • Describe the use of data types in SQL Server
  • Modify data using Transact-SQL
  • Use built-in functions
  • Group and aggregate data
  • Use subqueries
  • Use table expressions
  • Use set operators
  • Use window ranking, offset and aggregate functions
  • Implement pivoting and grouping sets
  • Execute stored procedures
  • Program with T-SQL
  • Implement error handling
  • Implement transactions
  • Original-Microsoft-Training
  • MOC On-Demand is currently available only in English
  • combination of video, text, practical tasks and knowledge tests
  • special offers like discounts are considered when taking the exam.

About Microsoft Official Course On-Demand

The courses are a great alternative for anyone wanting to learn independently and at their own pace. As a participant, you will receive an access to a learning platform developed by Microsoft, providing you with content such as videos, tutorials as well as a Live Lab-Environment for exercises.

As one of the leading Microsoft Learning Partners in Germany, GFN AG works closely with Microsoft together. On request, we can offer you additional services like digital training materials or an individual exam preparation in one of our Training center. For further information, you can also visit the following website MoC On Demand-Infoseite or feel free to contact us.

First published: 28. July 2016



This course is intended for Database Administrators, Database Developers, and Business Intelligence professionals. The course will very likely be well attended by SQL power users who aren?t necessarily database-focused; namely, report writers, business analysts and client application developers.

One more important note, all Microsoft MOC On-Demand courses are currently available in English only. To successfully complete this course, therefore a safe handling like IT-specialized English is essential.


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

Recommended system requirements for Microsoft Official Courses On-Demand and labs include:

  • Windows 10
  • Current version of Internet Explorer or Microsoft Edge
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed ActiveX control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required
  • 1280 x 1024 or higher

Note You can also take a MOC On-Demand on your iPad® Retina 4th Generation; however, the lab experience is not optimized for tablets.

Note Regularly scheduled maintenance for the Microsoft Labs Online (MLO) platform is currently at 10?12 P.M. Pacific Time every Thursday. During that time, you may not be able to access the MLO associated with a MOC On-Demand.

The minimum system requirements for MOC On-Demand and labs include:

  • Windows 7 or later
  • Internet Explorer 9 or later
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed Active X control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required

This Online-Training covers the following topics:

  • The Basic Architecture of SQL Server
  • SQL Server Editions and Versions
  • Getting Started with SQL Server Management Studio
  • Introducing T-SQL
  • Understanding Sets
  • Understanding Predicate Logic
  • Understanding the Logical Order of Operations in SELECT statements
  • Writing Simple SELECT Statements
  • Eliminating Duplicates with DISTINCT
  • Using Column and Table Aliases
  • Writing Simple CASE Expressions
  • Understanding Joins
  • Querying with Inner Joins
  • Querying with Outer Joins
  • Querying with Cross Joins and Self Joins
  • Sorting Data
  • Filtering Data with Predicates
  • Filtering with the TOP and OFFSET-FETCH Options
  • Working with Unknown Values
  • Introducing SQL Server 2016 Data Types
  • Working with Character Data
  • Working with Date and Time Data
  • Inserting Data
  • Modifying and Deleting Data
  • Writing Queries with Built-In Functions
  • Using Conversion Functions
  • Using Logical Functions
  • Using Functions to Work with NULL
  • Using Aggregate Functions
  • Using the GROUP BY Clause
  • Filtering Groups with HAVING
  • Writing Self-Contained Subqueries
  • Writing Correlated Subqueries
  • Using the EXISTS Predicate with Subqueries
  • Writing Queries with the UNION Operator
  • Using EXCEPT and INTERSECT
  • Using APPLY

This course provides students with the knowledge and skills to develop a Microsoft SQL Server 2016 database. The course focuses on teaching individuals how to use SQL Server 2016 product features and tools related to developing a database.

  • Design and Implement Tables.
  • Describe advanced table designs
  • Ensure Data Integrity through Constraints.
  • Describe indexes, including Optimized and Columnstore indexes
  • Design and Implement Views.
  • Design and Implement Stored Procedures.
  • Design and Implement User Defined Functions.
  • Respond to data manipulation using triggers.
  • Design and Implement In-Memory Tables.
  • Implement Managed Code in SQL Server.
  • Store and Query XML Data.
  • Work with Spatial Data.
  • Store and Query Blobs and Text Documents.
  • Original-Microsoft-Training
  • MOC On-Demand is currently available only in English
  • combination of video, text, practical tasks and knowledge tests
  • special offers like discounts are considered when taking the exam.

About Microsoft Official Course On-Demand

The courses are a great alternative for anyone wanting to learn independently and at their own pace. As a participant, you will receive an access to a learning platform developed by Microsoft, providing you with content such as videos, tutorials as well as a Live Lab-Environment for exercises.

As one of the leading Microsoft Learning Partners in Germany, GFN AG works closely with Microsoft together. On request, we can offer you additional services like digital training materials or an individual exam preparation in one of our Training center. For further information, you can also visit the following website MoC On Demand-Infoseite or feel free to contact us.

First published: 28. April 2017



  • IT Professionals who want to become skilled on SQL Server 2016 product features and technologies for implementing a database.
  • individuals who are developers from other product platforms looking to become skilled in the implementation of a SQL Server 2016 database.

One more important note, all Microsoft MOC On-Demand courses are currently available in English only. To successfully complete this course, therefore a safe handling like IT-specialized English is essential.


  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Working knowledge of Transact-SQL.
  • Working knowledge of relational databases.

Recommended system requirements for Microsoft Official Courses On-Demand and labs include:

  • Windows 10
  • Current version of Internet Explorer or Microsoft Edge
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed ActiveX control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required
  • 1280 x 1024 or higher

Note You can also take a MOC On-Demand on your iPad® Retina 4th Generation; however, the lab experience is not optimized for tablets.

Note Regularly scheduled maintenance for the Microsoft Labs Online (MLO) platform is currently at 10?12 P.M. Pacific Time every Thursday. During that time, you may not be able to access the MLO associated with a MOC On-Demand.

The minimum system requirements for MOC On-Demand and labs include:

  • Windows 7 or later
  • Internet Explorer 9 or later
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed Active X control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required

This Online-Training covers the following topics:

  • Introduction to the SQL Server Platform
  • SQL Server Database Development Tasks
  • Designing Tables
  • Data Types
  • Working with Schemas
  • Creating and Altering Tables
  • Partitioning Data
  • Compressing Data
  • Temporal Tables
  • Enforcing Data Integrity
  • Implementing Data Domain Integrity
  • Implementing Entity and Referential Integrity
  • Core Indexing Concepts
  • Data Types and Indexes
  • Heaps, Clustered, and Nonclustered Indexes
  • Single Column and Composite Indexes
  • Index Strategies
  • Managing Indexes
  • Execution Plans
  • The Database Engine Tuning Advisor
  • Query Store
  • Introduction to Columnstore Indexes
  • Creating Columnstore Indexes
  • Working with Columnstore Indexes
  • Introduction to Views
  • Creating and Managing Views
  • Performance Considerations for Views
  • Introduction to Stored Procedures
  • Working with Stored Procedures
  • Implementing Parameterized Stored Procedures
  • Controlling Execution Context
  • Overview of Functions
  • Designing and Implementing Scalar Functions
  • Designing and Implementing Table-Valued Functions
  • Considerations for Implementing Functions
  • Alternatives to Functions
  • Designing DML Triggers
  • Implementing DML Triggers
  • Advanced Trigger Concepts
  • Memory-Optimized Tables
  • Natively Compiled Stored Procedures
  • Introduction to CLR Integration in SQL Server
  • Implementing and Publishing CLR Assemblies
  • Introduction to XML and XML Schemas
  • Storing XML Data and Schemas in SQL Server
  • Implementing the XML Data Type
  • Using the Transact-SQL FOR XML Statement
  • Getting Started with XQuery
  • Shredding XML
  • Introduction to Spatial Data
  • Working with SQL Server Spatial Data Types
  • Using Spatial Data in Applications
  • Considerations for BLOB Data
  • Working with FILESTREAM
  • Using Full-Text Search
  • Concurrency and Transactions
  • Locking Internals
  • Extended Events
  • Working with extended Events
  • Live Query Statistics
  • Optimize Database File Configuration
  • Metrics

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

  • Authenticate and authorize users
  • Assign server and database roles
  • Authorize users to access resources
  • Protect data with encryption and auditing
  • Describe recovery models and backup strategies
  • Backup SQL Server databases
  • Restore SQL Server databases
  • Automate database management
  • Configure security for the SQL Server agent
  • Manage alerts and notifications
  • Managing SQL Server using PowerShell
  • Trace access to SQL Server
  • Monitor a SQL Server infrastructure
  • Troubleshoot a SQL Server infrastructure
  • Import and export data
  • Original-Microsoft-Training
  • MOC On-Demand is currently available only in English
  • combination of video, text, practical tasks and knowledge tests
  • special offers like discounts are considered when taking the exam.

About Microsoft Official Course On-Demand

The courses are a great alternative for anyone wanting to learn independently and at their own pace. As a participant, you will receive an access to a learning platform developed by Microsoft, providing you with content such as videos, tutorials as well as a Live Lab-Environment for exercises.

As one of the leading Microsoft Learning Partners in Germany, GFN AG works closely with Microsoft together. On request, we can offer you additional services like digital training materials or an individual exam preparation in one of our Training center. For further information, you can also visit the following website MoC On Demand-Infoseite or feel free to contact us.

First published: 18. May 2017



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

One more important note, all Microsoft MOC On-Demand courses are currently available in English only. To successfully complete this course, therefore a safe handling like IT-specialized English is essential.


  • Basic knowledge of the Microsoft Windows operating system and its core fun
  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Working knowledge of Transact-SQL.
  • Working knowledge of relational databases.
  • Some experience with database design.

Recommended system requirements for Microsoft Official Courses On-Demand and labs include:

  • Windows 10
  • Current version of Internet Explorer or Microsoft Edge
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed ActiveX control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required
  • 1280 x 1024 or higher

Note You can also take a MOC On-Demand on your iPad® Retina 4th Generation; however, the lab experience is not optimized for tablets.

Note Regularly scheduled maintenance for the Microsoft Labs Online (MLO) platform is currently at 10?12 P.M. Pacific Time every Thursday. During that time, you may not be able to access the MLO associated with a MOC On-Demand.

The minimum system requirements for MOC On-Demand and labs include:

  • Windows 7 or later
  • Internet Explorer 9 or later
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed Active X control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required

This Online-Training covers the following topics:

  • Authenticating Connections to SQL Server
  • Authorizing Logins to Connect to databases
  • Authorization Across Servers
  • Partially Contained Databases
  • Create Logins
  • Create Database Users
  • Correct Application Login Issues
  • Configure Security for Restored Databases
  • SQL Server basic concepts.
  • SQL Server connection authentication.
  • User login authorization to databases.
  • Partially contained databases.
  • Authorization across servers.
  • Working with server roles
  • Working with Fixed Database Roles
  • Assigning User-Defined Database Roles
  • Assigning Server Roles
  • Assigning Fixed Database Roles
  • Assigning User-Defined Database Roles
  • Verifying Security
  • Describe and use server roles to manage server-level security.
  • Describe and use fixed database roles.
  • Use custom database roles and application roles to manage database-level security.
  • Authorizing User Access to Objects
  • Authorizing Users to Execute Code
  • Configuring Permissions at the Schema Level
  • Granting, Denying, and Revoking Permissions on Objects
  • Granting EXECUTE Permissions on Code
  • Granting Permissions at the Schema Level
  • Authorize user access to objects.
  • Authorize users to execute code.
  • Configure permissions at the schema level.
  • Options for auditing data access in SQL Server
  • Implementing SQL Server Audit
  • Managing SQL Server Audit
  • Protecting Data with Encryption
  • Working with SQL Server Audit
  • Encrypt a Column as Always Encrypted
  • Encrypt a Database using TDE
  • Describe the options for auditing data access.
  • Implement SQL Server Audit.
  • Manage SQL Server Audit.
  • Describe and implement methods of encrypting data in SQL Server.
  • Implement encryption
  • Understanding Backup Strategies
  • SQL Server Transaction Logs
  • Planning Backup Strategies
  • Plan a Backup Strategy
  • Configure Database Recovery Models
  • Describe various backup strategies.
  • Describe how database transaction logs function.
  • Plan SQL Server backup strategies.
  • Backing Up Databases and Transaction Logs
  • Managing Database Backups
  • Advanced Database Options
  • Backing Up Databases
  • Performing Database, Differential, and Transaction Log Backups
  • Performing a Partial Backup
  • Perform backups of SQL Server databases and transaction logs.
  • Manage database backups.
  • Describe advanced backup options.
  • Understanding the Restore Process
  • Restoring Databases
  • Advanced Restore Scenarios
  • Point-in-Time Recovery
  • Restoring a Database Backup
  • Restring Database, Differential, and Transaction Log Backups
  • Performing a Piecemeal Restore
  • Explain the restore process.
  • Restore databases.
  • Perform advanced restore operations.
  • Perform a point-in-time recovery.
  • Automating SQL Server management
  • Working with SQL Server Agent
  • Managing SQL Server Agent Jobs
  • Multi-server Management
  • Create a SQL Server Agent Job
  • Test a Job
  • Schedule a Job
  • Configure Master and Target Servers
  • Describe methods for automating SQL Server Management.
  • Configure jobs, job step types, and schedules.
  • Manage SQL Server Agent jobs.
  • Configure master and target servers.
  • Understanding SQL Server Agent Security
  • Configuring Credentials
  • Configuring Proxy Accounts
  • Analyzing Problems in SQL Server Agent
  • Configuring a Credential
  • Configuring a Proxy Account
  • Configuring and testing the Security Context of a Job
  • Explain SQL Server Agent security.
  • Configure credentials.
  • Configure proxy accounts.
  • Monitoring SQL Server Errors
  • Configuring Database Mail
  • Operators, Alerts, and Notifications
  • Alerts in Azure SQL Database
  • Configuring Database Mail
  • Configuring Operators
  • Configuring Alerts and Notifications
  • Testing Alerts and Notifications
  • Monitor SQL Server errors.
  • Configure database mail.
  • Configure operators, alerts, and notifications.
  • Work with alerts in Azure SQL Database.
  • Getting Started with Windows PowerShell
  • Configure SQL Server using PowerShell
  • Administer and Maintain SQL Server with PowerShell
  • Managing Azure SQL Databases using PowerShell
  • Getting Started with PowerShell
  • Using PowerShell to Change SQL Server settings
  • Describe the benefits of PowerShell and its fundamental concepts.
  • Configure SQL Server by using PowerShell.
  • Administer and maintain SQL Server by using PowerShell.
  • Manage an Azure SQL Database by using PowerShell.
  • Extended Events Core Concepts
  • Working with Extended Events
  • Using the System_Health Extended Events Session
  • Tracking Page Splits Using Extended Events
  • Describe Extended Events core concepts.
  • Create and query Extended Events sessions.
  • Monitoring activity
  • Capturing and Managing Performance Data
  • Analyzing Collected Performance Data
  • SQL Server Utility

Lab : Monitoring SQL Server

  • Monitor current activity.
  • Capture and manage performance data.
  • Analyze collected performance data.
  • Configure SQL Server Utility.
  • A Trouble Shooting Methodology for SQL Server
  • Resolving Service Related Issues
  • Resolving Connectivity and Log-in issues
  • Troubleshoot and Resolve a SQL Login Issue
  • Troubleshoot and Resolve a Service Issue
  • Troubleshoot and Resolve a Windows Login Issue
  • Troubleshoot and Resolve a Job Execution Issue
  • Troubleshoot and Resolve a Performance Issue
  • Describe a troubleshooting methodology for SQL Server.
  • Resolve service-related issues.
  • Resolve login and connectivity issues.
  • While a great deal of data residing in a Microsoft SQL Server system is entered directly by users who are running application programs, there is often a need to move data in other locations, to and from SQL Server. SQL Server provides a set of tools you can use to transfer data in and out. Some of these tools, such as the bcp (Bulk Copy Program) utility and SQL Server Integration Services, are external to the database engine. Other tools, such as the BULK INSERT statement and the OPENROWSET function, are implemented in the database engine. With SQL Server, you can also create data-tier applications that package all the tables, views, and instance objects associated with a user database into a single unit of deployment. In this module, you will explore these tools and techniques so that you can import and export data to and from SQL Server.
  • Transferring Data to and from SQL Server
  • Importing and Exporting Table Data
  • Using bcp and BULK INSERT to Import Data
  • Deploying and Upgrading Data-Tier Application
  • Import and Excel Data Using the Import Wizard
  • Import a Delimited Text File Using bcp
  • Import a Delimited Text File using BULK INSERT
  • Create and Test an SSIS Package to Extract Data
  • Deploy a Data-Tier Application
  • Describe tools and techniques for transferring data.
  • Import and export table data.
  • Use bcp and BULK INSERT to import data.
  • Use data-tier applications to import and export database applications.

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

  • Provision a Database Server
  • Upgrade SQL Server
  • Configure SQL Server
  • Manage Databases and Files (shared)
  • Provision, migrate and manage databases in the cloud
  • Original-Microsoft-Training
  • MOC On-Demand is currently available only in English
  • combination of video, text, practical tasks and knowledge tests
  • special offers like discounts are considered when taking the exam.

About Microsoft Official Course On-Demand

The courses are a great alternative for anyone wanting to learn independently and at their own pace. As a participant, you will receive an access to a learning platform developed by Microsoft, providing you with content such as videos, tutorials as well as a Live Lab-Environment for exercises.

As one of the leading Microsoft Learning Partners in Germany, GFN AG works closely with Microsoft together. On request, we can offer you additional services like digital training materials or an individual exam preparation in one of our Training center. For further information, you can also visit the following website MoC On Demand-Infoseite or feel free to contact us.

First published: 29. June 2017



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

One more important note, all Microsoft MOC On-Demand courses are currently available in English only. To successfully complete this course, therefore a safe handling like IT-specialized English is essential.


  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Working knowledge of Transact-SQL.
  • Working knowledge of relational databases.
  • Some experience with database design

Recommended system requirements for Microsoft Official Courses On-Demand and labs include:

  • Windows 10
  • Current version of Internet Explorer or Microsoft Edge
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed ActiveX control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required
  • 1280 x 1024 or higher

Note You can also take a MOC On-Demand on your iPad® Retina 4th Generation; however, the lab experience is not optimized for tablets.

Note Regularly scheduled maintenance for the Microsoft Labs Online (MLO) platform is currently at 10?12 P.M. Pacific Time every Thursday. During that time, you may not be able to access the MLO associated with a MOC On-Demand.

The minimum system requirements for MOC On-Demand and labs include:

  • Windows 7 or later
  • Internet Explorer 9 or later
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed Active X control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required

This Online-Training covers the following topics:

  • Introduction to the SQL Server Platform
  • Overview of SQL Server Architecture
  • SQL Server Services and Configuration Options
  • When we do use a separate installation of SQL Server and when would use a separate instance?
  • Which version of SQL Server is most suitable in your organization?
  • Describe SQL Server components and versions.
  • Describe SQL Server architecture and resource usage.
  • Describe SQL Server services and how you manage the configuration of those services.
  • Considerations for SQL Installing Server
  • TempDB Files
  • Installing SQL Server 2016
  • Automating Installation
  • Assess the available resources
  • Install an instance of SQL Server
  • Perform post installation checks
  • Automating Installation
  • Describe the considerations when installing SQL Server.
  • Describe TempDB files.
  • Install SQL Server 2016.
  • Automate a SQL Server installation.
  • Upgrade Requirements
  • Upgrade SQL Server Services
  • Migrating SQL Server Data and Applications
  • Create the Application Logins
  • Restore Database Backups
  • Orphaned Users and Database Compatibility Level
  • Describe the upgrade requirements for SQL Server.
  • Upgrade SQL Server.
  • Migrate SQL Server data and applications.
  • Introduction to Data Storage with SQL Server
  • Managing Storage for System Databases
  • Managing Storage for User Databases
  • Moving and Copying Database Files
  • Side-by-Side Upgrade: Migrating SQL Server Data and Applications
  • Buffer Pool Extension
  • Configuring tempdb Storage
  • Creating Databases
  • Attaching a Database
  • Enable Buffer Pool Extension
  • Describe Data Storage with SQL Server.
  • Manage Storage for System Databases.
  • Manage Storage for User Databases.
  • Move and Copy Database Files.
  • Describe the Side-by-Side Upgrade: Migrating SQL Server Data and Applications process.
  • Describe and use Buffer Pool Extensions.
  • Ensuring Database Integrity
  • Maintaining Indexes
  • Automating Routine Database Maintenance
  • Use DBCC CHECKDB to Verify Database Integrity
  • Rebuild Indexes
  • Create a Database Maintenance Plan
  • Ensure Database Integrity.
  • Maintain Indexes.
  • Automate Routine Database Maintenance.
  • SQL Server storage Performance
  • SMB Fileshare
  • SQL Server Storage in Microsoft Azure
  • Stretch Databases
  • Run Stretch Database Advisor
  • Implement Stretch Database
  • Describe SQL Server Storage Performance.
  • Describe SMB Fileshare.
  • Explain SQL Server Storage in Microsoft Azure.
  • Describe Stretch Database.
  • SQL Server Virtual Machines in Azure
  • Azure Storage
  • Azure SQL Authentication
  • Deploying an Azure SQL Database
  • Plan an Azure SQL Database, Networking, performance tiers, security
  • Provision an Azure SQL Database
  • Connect to an Azure SQL Database
  • Describe SQL Server Virtual Machines in Azure.
  • Describe Azure Storage.
  • Explain Azure SQL Authentication, auditing and compliance.
  • Deploy an Azure SQL Database.
  • Database Migration Testing Tools
  • Database Migration Compatibility Issues
  • Migrating a SQL Server Database to Azure SQL Database
  • Perform Migration Testing
  • Migrate a SQL Server Database to Azure SQL Database
  • Test a Migrated Database
  • Describe various database migration testing tools.
  • Explain database migration compatibility issues.
  • Migrate a SQL Server database to Azure SQL database.
  • Deploying SQL Server on an Azure VM
  • The Deploy Database to a Microsoft Azure VM Wizard
  • Provision an Azure VM
  • Use the Deploy Database to Azure VM Wizard
  • Deploy SQL Server on an Azure VM.
  • Use The Deploy Database to a Microsoft Azure VM Wizard.
  • Managing Azure SQL Database Security
  • Configure Azure storage
  • Azure Automation
  • Configure Azure Security
  • Automate Azure Deployment
  • Manage Azure SQL Database Security.
  • Configure Azure storage.
  • Implement Azure Automation.

This course provides students with the knowledge and skills to provision a Microsoft SQL Server 2016 database. The course covers SQL Server 2016 provision both on-premise and in Azure, and covers installing from new and migrating from an existing install.

  • Provision a Database Server.
  • Upgrade SQL Server.
  • Configure SQL Server.
  • Manage Databases and Files (shared).
  • Create an Excel data model and connect to external data
  • Original-Microsoft-Training
  • MOC On-Demand is currently available only in English
  • combination of video, text, practical tasks and knowledge tests
  • special offers like discounts are considered when taking the exam.

About Microsoft Official Course On-Demand

The courses are a great alternative for anyone wanting to learn independently and at their own pace. As a participant, you will receive an access to a learning platform developed by Microsoft, providing you with content such as videos, tutorials as well as a Live Lab-Environment for exercises.

As one of the leading Microsoft Learning Partners in Germany, GFN AG works closely with Microsoft together. On request, we can offer you additional services like digital training materials or an individual exam preparation in one of our Training center. For further information, you can also visit the following website MoC On Demand-Infoseite or feel free to contact us.

First published: 02. June 2017



The primary audience for this course are database professionals who need to fulfil a Business Intelligence Developer role.  They will need to focus on hands-on work creating BI solutions including Data Warehouse implementation, ETL, and data cleansing. 

One more important note, all Microsoft MOC On-Demand courses are currently available in English only. To successfully complete this course, therefore a safe handling like IT-specialized English is essential.


  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Working knowledge of relational databases.
  • Some experience with database design.

Recommended system requirements for Microsoft Official Courses On-Demand and labs include:

  • Windows 10
  • Current version of Internet Explorer or Microsoft Edge
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed ActiveX control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required
  • 1280 x 1024 or higher

Note You can also take a MOC On-Demand on your iPad® Retina 4th Generation; however, the lab experience is not optimized for tablets.

Note Regularly scheduled maintenance for the Microsoft Labs Online (MLO) platform is currently at 10?12 P.M. Pacific Time every Thursday. During that time, you may not be able to access the MLO associated with a MOC On-Demand.

The minimum system requirements for MOC On-Demand and labs include:

  • Windows 7 or later
  • Internet Explorer 9 or later
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed Active X control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required

This Online-Training covers the following topics:

  • Overview of Data Warehousing
  • Considerations for a Data Warehouse Solution
  • Exploring data sources
  • Exploring an ETL process
  • Exploring a data warehouse
  • Describe the key elements of a data warehousing solution
  • Describe the key considerations for a data warehousing solution
  • Considerations for data warehouse infrastructure.
  • Planning data warehouse hardware.
  • Planning data warehouse hardware
  • Describe the main hardware considerations for building a data warehouse
  • Explain how to use reference architectures and data warehouse appliances to create a data warehouse
  • Designing dimension tables
  • Designing fact tables
  • Physical Design for a Data Warehouse
  • Implementing a star schema
  • Implementing a snowflake schema
  • Implementing a time dimension table
  • Implement a logical design for a data warehouse
  • Implement a physical design for a data warehouse
  • Introduction to Columnstore Indexes
  • Creating Columnstore Indexes
  • Working with Columnstore Indexes
  • Create a Columnstore index on the FactProductInventory table
  • Create a Columnstore index on the FactInternetSales table
  • Create a memory optimized Columnstore table
  • Create Columnstore indexes
  • Work with Columnstore Indexes
  • Advantages of Azure SQL Data Warehouse
  • Implementing an Azure SQL Data Warehouse
  • Developing an Azure SQL Data Warehouse
  • Migrating to an Azure SQ Data Warehouse
  • Copying data with the Azure data factory
  • Create an Azure SQL data warehouse database
  • Migrate to an Azure SQL Data warehouse database
  • Copy data with the Azure data factory
  • Describe the advantages of Azure SQL Data Warehouse
  • Implement an Azure SQL Data Warehouse
  • Describe the considerations for developing an Azure SQL Data Warehouse
  • Plan for migrating to Azure SQL Data Warehouse
  • Introduction to ETL with SSIS
  • Exploring Source Data
  • Implementing Data Flow
  • Exploring source data
  • Transferring data by using a data row task
  • Using transformation components in a data row
  • Describe ETL with SSIS
  • Explore Source Data
  • Implement a Data Flow
  • Introduction to Control Flow
  • Creating Dynamic Packages
  • Using Containers
  • Managing consistency.
  • Using tasks and precedence in a control flow
  • Using variables and parameters
  • Using containers
  • Using transactions
  • Using checkpoints
  • Describe control flow
  • Create dynamic packages
  • Use containers
  • Debugging an SSIS Package
  • Logging SSIS Package Events
  • Handling Errors in an SSIS Package
  • Debugging an SSIS package
  • Logging SSIS package execution
  • Implementing an event handler
  • Handling errors in data flow
  • Debug an SSIS package
  • Log SSIS package events
  • Handle errors in an SSIS package
  • Introduction to Incremental ETL
  • Extracting Modified Data
  • Loading modified data
  • Temporal Tables
  • Using a datetime column to incrementally extract data
  • Using change data capture
  • Using the CDC control task
  • Using change tracking
  • Loading data from CDC output tables
  • Using a lookup transformation to insert or update dimension data
  • Implementing a slowly changing dimension
  • Using the merge statement
  • Describe incremental ETL
  • Extract modified data
  • Load modified data.
  • Describe temporal tables
  • Introduction to Data Quality
  • Using Data Quality Services to Cleanse Data
  • Using Data Quality Services to Match Data
  • Creating a DQS knowledge base
  • Using a DQS project to cleanse data
  • Using DQS in an SSIS package
  • Creating a matching policy
  • Using a DS project to match data
  • Describe data quality services
  • Cleanse data using data quality services
  • Match data using data quality services
  • De-duplicate data using data quality services
  • Introduction to Master Data Services
  • Implementing a Master Data Services Model
  • Hierarchies and collections
  • Creating a Master Data Hub
  • Creating a master data services model
  • Using the master data services add-in for Excel
  • Enforcing business rules
  • Loading data into a model
  • Consuming master data services data
  • Describe the key concepts of master data services
  • Implement a master data service model
  • Manage master data
  • Create a master data hub
  • Using scripting in SSIS
  • Using custom components in SSIS
  • Using a script task
  • Use custom components in SSIS
  • Use scripting in SSIS
  • Overview of SSIS Deployment
  • Deploying SSIS Projects
  • Planning SSIS Package Execution
  • Creating an SSIS catalog
  • Deploying an SSIS project
  • Creating environments for an SSIS solution
  • Running an SSIS package in SQL server management studio
  • Scheduling SSIS packages with SQL server agent
  • Describe an SSIS deployment
  • Deploy an SSIS package
  • Plan SSIS package execution
  • Introduction to Business Intelligence
  • An Introduction to Data Analysis
  • Introduction to reporting
  • Analyzing Data with Azure SQL Data Warehouse
  • Exploring a reporting services report
  • Exploring a PowerPivot workbook
  • Exploring a power view report
  • Describe at a high level business intelligence
  • Show an understanding of reporting
  • Show an understanding of data analysis
  • Analyze data with Azure SQL data warehouse

The focus of this course is on creating managed enterprise BI solutions. It describes how to implement both multidimensional and tabular data models and how to create cubes, dimensions, measures, and measure groups. This course helps you prepare for the Exam 70-768.

  • Describe the components, architecture, and nature of a BI solution
  • Create a multidimensional database with Analysis Services
  • Implement dimensions in a cube
  • Implement measures and measure groups in a cube
  • Use MDX syntax
  • Customize a cube
  • Implement a tabular database
  • Use DAX to query a tabular model
  • Use data mining for predictive analysis
  • Original-Microsoft-Training
  • MOC On-Demand is currently available only in English
  • combination of video, text, practical tasks and knowledge tests
  • special offers like discounts are considered when taking the exam.

About Microsoft Official Course On-Demand

The courses are a great alternative for anyone wanting to learn independently and at their own pace. As a participant, you will receive an access to a learning platform developed by Microsoft, providing you with content such as videos, tutorials as well as a Live Lab-Environment for exercises.

As one of the leading Microsoft Learning Partners in Germany, GFN AG works closely with Microsoft together. On request, we can offer you additional services like digital training materials or an individual exam preparation in one of our Training center. For further information, you can also visit the following website MoC On Demand-Infoseite or feel free to contact us.

First published: 05. October 2017



This course is intended for people who audience are database professionals and need to fulfil BI Developer role to create enterprise BI solutions. 

  • Implementing multidimensional databases by using SQL Server Analysis Services
  • Creating tabular semantic data models for analysis by using SQL Server Analysis Services

One more important note, all Microsoft MOC On-Demand courses are currently available in English only. To successfully complete this course, therefore a safe handling like IT-specialized English is essential.


  • Experience of querying data using Transact-SQL

Recommended system requirements for Microsoft Official Courses On-Demand and labs include:

  • Windows 10
  • Current version of Internet Explorer or Microsoft Edge
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed ActiveX control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required
  • 1280 x 1024 or higher

Note You can also take a MOC On-Demand on your iPad® Retina 4th Generation; however, the lab experience is not optimized for tablets.

Note Regularly scheduled maintenance for the Microsoft Labs Online (MLO) platform is currently at 10?12 P.M. Pacific Time every Thursday. During that time, you may not be able to access the MLO associated with a MOC On-Demand.

The minimum system requirements for MOC On-Demand and labs include:

  • Windows 7 or later
  • Internet Explorer 9 or later
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed Active X control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required

This Online-Training covers the following topics:

  • Introduction to Business Intelligence
  • The Microsoft business intelligence platform
  • Introduction to Multidimensional Analysis
  • Creating Data Sources and Data Source Views
  • Creating a Cube
  • Overview of Cube Security
  • Configure SSAS
  • Monitoring SSAS
  • Configuring Dimensions
  • Defining Attribute Hierarchies
  • Sorting and Grouping Attributes
  • Slowly Changing Dimensions
  • Working with Measures
  • Working with Measure Groups
  • MDX fundamentals
  • Adding Calculations to a Cube
  • Using MDX to Query a Cube
  • Introduction to Business Intelligence
  • The Implementing Key Performance Indicators
  • Implementing Actions
  • Implementing Perspectives
  • Implementing Translations
  • Introduction to Tabular Data Models
  • Creating a Tabular Data Model
  • Using an Analysis Services Tabular Data Model in an Enterprise BI Solution
  • DAX Fundamentals
  • Using DAX to Create Calculated Columns and Measures in a Tabular Data Model
  • Overview of Data Mining
  • Creating a Custom Data Mining Solution
  • Validating a Data Mining Model
  • Connecting to and Consuming a Data-Mining Model
  • Using the Data Mining add-in for Excel






The main purpose of the course is to give students a good understanding of data analysis with Power BI. The course includes creating visualizations, the Power BI Service, and the Power BI Mobile App.

  • Perform Power BI desktop data transformation.
  • Describe Power BI desktop modelling.
  • Create a Power BI desktop visualization.
  • Implement the Power BI service.
  • Describe how to connect to Excel data.
  • Describe how to collaborate with Power BI data.
  • Connect directly to data stores.
  • Describe the Power BI developer API.
  • Describe the Power BI mobile app.
  • Original-Microsoft-Training
  • MOC On-Demand is currently available only in English
  • combination of video, text, practical tasks and knowledge tests
  • special offers like discounts are considered when taking the exam.

About Microsoft Official Course On-Demand

The courses are a great alternative for anyone wanting to learn independently and at their own pace. As a participant, you will receive an access to a learning platform developed by Microsoft, providing you with content such as videos, tutorials as well as a Live Lab-Environment for exercises.

As one of the leading Microsoft Learning Partners in Germany, GFN AG works closely with Microsoft together. On request, we can offer you additional services like digital training materials or an individual exam preparation in one of our Training center. For further information, you can also visit the following website MoC On Demand-Infoseite or feel free to contact us.

First published: 10. August 2017



This course is intended for people who attended by SQL Server report creators who are interested in alternative methods of presenting data.

One more important note, all Microsoft MOC On-Demand courses are currently available in English only. To successfully complete this course, therefore a safe handling like IT-specialized English is essential.


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

Recommended system requirements for Microsoft Official Courses On-Demand and labs include:

  • Windows 10
  • Current version of Internet Explorer or Microsoft Edge
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed ActiveX control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required
  • 1280 x 1024 or higher

Note You can also take a MOC On-Demand on your iPad® Retina 4th Generation; however, the lab experience is not optimized for tablets.

Note Regularly scheduled maintenance for the Microsoft Labs Online (MLO) platform is currently at 10?12 P.M. Pacific Time every Thursday. During that time, you may not be able to access the MLO associated with a MOC On-Demand.

The minimum system requirements for MOC On-Demand and labs include:

  • Windows 7 or later
  • Internet Explorer 9 or later
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed Active X control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required

This Online-Training covers the following topics:

  • Introduction to business intelligence
  • Introduction to data analysis
  • Introduction to data visualization
  • Overview of self-service BI
  • Considerations for self-service BI
  • Microsoft tools for self-service BI
  • Power BI
  • The Power BI service
  • Using Excel as a data source for Power BI
  • The Power BI data model
  • Using databases as a data source for Power BI
  • The Power BI service
  • Power BI desktop queries
  • Shaping data
  • Combining data
  • Lessons
  • Relationships
  • DAX queries
  • Calculations and measures
  • Creating Power BI reports
  • Managing a Power BI solution
  • Cloud data
  • Connecting to analysis services
  • The developer API
  • Custom visuals
  • The Power BI mobile app
  • Using the Power BI mobile app
  • Power BI embedded

The main purpose of the course is to give students the ability to add BI techniques to Excel data analysis. The course goes beyond the capabilities of tables and charts and uses Pivot Charts, the Excel Data Model, and Power BI.

  • Explore and extend a classic Excel dashboard.
  • Explore and extend an Excel data model.
  • Pre-format and import a .CSV file.
  • Import data from a SQL Server database
  • Import data from a report.
  • Create measures using advanced DAX functions.
  • Create data visualizations in Excel.
  • Create a Power BI dashboard with Excel.
  • Original-Microsoft-Training
  • MOC On-Demand is currently available only in English
  • combination of video, text, practical tasks and knowledge tests
  • special offers like discounts are considered when taking the exam.

About Microsoft Official Course On-Demand

The courses are a great alternative for anyone wanting to learn independently and at their own pace. As a participant, you will receive an access to a learning platform developed by Microsoft, providing you with content such as videos, tutorials as well as a Live Lab-Environment for exercises.

As one of the leading Microsoft Learning Partners in Germany, GFN AG works closely with Microsoft together. On request, we can offer you additional services like digital training materials or an individual exam preparation in one of our Training center. For further information, you can also visit the following website MoC On Demand-Infoseite or feel free to contact us.

First published: 21. April 2017



This course is intended for students who are experienced with analyzing data with Excel and who wish to add BI techniques.

The course will likely be attended by SQL Server report creators who are interested in alternative methods of presenting data.

One more important note, all Microsoft MOC On-Demand courses are currently available in English only. To successfully complete this course, therefore a safe handling like IT-specialized English is essential.


  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Working knowledge of relational databases.
  • Extensive knowledge of Excel spreadsheets including formulas, charts, filtering, sorting, and sub-totals.
  • Basic knowledge of data analytics equivalent to having attended course 10994.

Recommended system requirements for Microsoft Official Courses On-Demand and labs include:

  • Windows 10
  • Current version of Internet Explorer or Microsoft Edge
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed ActiveX control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required
  • 1280 x 1024 or higher

Note You can also take a MOC On-Demand on your iPad® Retina 4th Generation; however, the lab experience is not optimized for tablets.

Note Regularly scheduled maintenance for the Microsoft Labs Online (MLO) platform is currently at 10?12 P.M. Pacific Time every Thursday. During that time, you may not be able to access the MLO associated with a MOC On-Demand.

The minimum system requirements for MOC On-Demand and labs include:

  • Windows 7 or later
  • Internet Explorer 9 or later
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed Active X control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required

This Online-Training covers the following topics:

  • Classic Data Analysis with Excel
  • Excel Pivot Tables
  • Limitations of Classic Data Analysis
  • Filtering and Formatting Data
  • Building a Pivot Table
  • Building a Pivot Chart
  • Building a Dashboard
  • Describe classic data analysis with Excel
  • Describe Excel pivot tables
  • Describe the limitations of classic data analysis with Excel
  • Using an Excel Data Model
  • DAX
  • Create Calculated Columns
  • Format Data Model Data
  • Create Measures
  • Analyze the Data
  • Describe an Excel data model
  • View data within an Excel data table
  • Describe DAX
  • Importing Data into Excel
  • Shaping and Transforming Data
  • Loading Data
  • Import and Transform Data from a CSV File
  • Add Data from a Folder
  • Import data into excel.
  • Shape and transform data.
  • Load data.
  • Available Data Sources
  • Previewing, Shaping, and Transforming Data
  • Table Relationships and Hierarchies
  • Loading Data
  • Import Data from SQL Server
  • Import Data from a CSV File
  • Create a Data Table
  • Identify available data sources.
  • Preview, shape, and transform data.
  • Explain table relationships and hierarchies.
  • Load data from various sources.
  • Importing Data from Excel Reports
  • Transforming Excel report Data
  • Import Data from Excel
  • Transform the Excel Data
  • Load the Data into an Excel Data Model
  • Import data from Excel reports.
  • Transform Excel report data.
  • DAX
  • Measures
  • Advanced DAX Functions
  • Last year comparison
  • Year to date
  • Market Share
  • Explain what DAX is and when to use it.
  • Describe a measure.
  • Use some of the advanced functions within DAX.
  • Pivot Charts
  • Cube Functions
  • Charts for Cube Functions
  • Create a Tabular Report
  • Create a Pivot Chart
  • Add Slicers to Charts
  • Create and refine a pivot chart.
  • Describe cube functions and when to use them.
  • Describe a number of charts for use with cube functions.
  • Power BI
  • Uploading Excel Data to Power BI
  • Power BI Mobile App
  • Uploading Excel Data
  • Creating a Power BI Dashboard
  • Describe Power Bi and the various versions available.
  • Upload Excel data to Power BI.
  • Describe the Power BI App.

Welcome to Introduction to Cloud Computing. Congratulations on taking the first step toward learning about the fundamental principles and concepts of cloud computing as you consider a career in IT, orseek to add to your existing knowledge and experience. This course provides a primer to help you understand the business benefits of cloud computing solutions, become familiar with "cloud terminology,"  and explore the basic concepts behind the cloud.

  • Original-Microsoft-Training
  • MOC On-Demand is currently available only in English
  • combination of video, text, practical tasks and knowledge tests

About Microsoft Official Course On-Demand

The courses are a great alternative for anyone wanting to learn independently and at their own pace. As a participant, you will receive an access to a learning platform developed by Microsoft, providing you with content such as videos, tutorials as well as a Live Lab-Environment for exercises.

As one of the leading Microsoft Learning Partners in Germany, GFN AG works closely with Microsoft together. On request, we can offer you additional services like digital training materials or an individual exam preparation in one of our Training center. For further information, you can also visit the following website MoC On Demand-Infoseite or feel free to contact us.

First published: 06. April 2017



One more important note, all Microsoft MOC On-Demand courses are currently available in English only. To successfully complete this course, therefore a safe handling like IT-specialized English is essential.


Recommended system requirements for Microsoft Official Courses On-Demand and labs include:

  • Windows 10
  • Current version of Internet Explorer or Microsoft Edge
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed ActiveX control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required
  • 1280 x 1024 or higher

Note You can also take a MOC On-Demand on your iPad® Retina 4th Generation; however, the lab experience is not optimized for tablets.

Note Regularly scheduled maintenance for the Microsoft Labs Online (MLO) platform is currently at 10?12 P.M. Pacific Time every Thursday. During that time, you may not be able to access the MLO associated with a MOC On-Demand.

The minimum system requirements for MOC On-Demand and labs include:

  • Windows 7 or later
  • Internet Explorer 9 or later
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed Active X control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required

This Online-Training covers the following topics:

  • What is a Cloud?
  • Evolving IT Operations Models
  • Business Drivers for the Cloud
  • Types of Cloud Services
  • Public Cloud
  • Private Cloud
  • Hybrid Cloud
  • Moving to a Cloud Model
  • Managing Cloud Infrastructure
  • Introducing Microsoft Azure
  • Azure Services
  • Azure Data Centers
  • Setting Up Your Azure Subscription
  • The Full Azure Management Portal
  • The New Azure Preview Portal
  • Lab : Exploring Azure Portals

Welcome to First Look Clinic: Microsoft Azure. Congratulations on taking the first step toward learning about how to successfully manage and administer a Microsoft Azure cloud solution. This course will help you to become familiar with the fundamentals of Microsoft Azure including the web-based portals for deploying resources and managing Azure subscriptions. You'll learn about Azure Resource Manager and how to use templates to manage resources. This course also introduces PowerShell as a key tool to manage and automate Azure resources.

  • Original-Microsoft-Training
  • MOC On-Demand is currently available only in English
  • combination of video, text, practical tasks and knowledge tests

About Microsoft Official Course On-Demand

The courses are a great alternative for anyone wanting to learn independently and at their own pace. As a participant, you will receive an access to a learning platform developed by Microsoft, providing you with content such as videos, tutorials as well as a Live Lab-Environment for exercises.

As one of the leading Microsoft Learning Partners in Germany, GFN AG works closely with Microsoft together. On request, we can offer you additional services like digital training materials or an individual exam preparation in one of our Training center. For further information, you can also visit the following website MoC On Demand-Infoseite or feel free to contact us.

First published: 23. March 2017



One more important note, all Microsoft MOC On-Demand courses are currently available in English only. To successfully complete this course, therefore a safe handling like IT-specialized English is essential.


Recommended system requirements for Microsoft Official Courses On-Demand and labs include:

  • Windows 10
  • Current version of Internet Explorer or Microsoft Edge
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed ActiveX control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required
  • 1280 x 1024 or higher

Note You can also take a MOC On-Demand on your iPad® Retina 4th Generation; however, the lab experience is not optimized for tablets.

Note Regularly scheduled maintenance for the Microsoft Labs Online (MLO) platform is currently at 10?12 P.M. Pacific Time every Thursday. During that time, you may not be able to access the MLO associated with a MOC On-Demand.

The minimum system requirements for MOC On-Demand and labs include:

  • Windows 7 or later
  • Internet Explorer 9 or later
  • Broadband Internet connection (256 kilobytes per second)
  • External access to the Internet
  • Either an installed Active X control (requires local administrator permissions) or Internet Explorer 11 or later
  • For some corporate firewalls, a proxy client (such as TMG Client) may be required

This Online-Training covers the following topics:

  • Introduction to Cloud Computing
  • Overview of Microsoft Azure
  • Azure Data Centers and Services
  • Classic Azure Portal
  • New Azure Portal
  • Azure Subscriptions
  • Virtual Machines, Networks, and Storage
  • Introduction to Resource Manager
  • Azure PowerShell Modules
  • Azure PowerShell Cmdlets
  • Take an Azure Virtual Data Center Tour
  • Sign-in and Explore the Classic Azure Portal
  • Sign-in and Explore the New Azure Portal
  • Azure Subscriptions
  • Deploy a New Virtual Machine
  • Work with Azure Resource Manager and a VM Template
  • Download and install the Azure PowerShell modules
  • Connect to Azure by using PowerShell
  • Work with Azure Resource Manager by using PowerShell

MOC On-Demand – So einfach geht's!


Kurs wählen & buchen

Wählen Sie einfach den gewünschten Kurs und buchen Sie online.


Zugangscode erhalten

Sie erhalten elektronisch Ihren Zugangscode für MOC On-Demand.


Code aktivieren & Kurs beginnen

Lernen Sie, wann immer Sie wollen dank voller Verfügbarkeit.

Kurspaket flexibel buchen

Bei der Buchung Ihre MOC On Demand-Kurses haben Sie die Möglichkeit, sich ein individuelles Paket zusammenzustellen, das Ihren Bedürfnissen entspricht. Sie haben die Wahl:

  • Dauer: Die Zeit, in der Sie Zugriff auf die Live Lab-Umgebung haben.
  • Basiskurs: Eine preisgünstige, fokussierte Kursvariante mit Zugriff auf alle Training-Videos sowie ergänzende Hands-on-Labs, Übungen und Wissensabfragen.
  • Digitale Schulungsunterlagen: Sie erhalten zusätzlich Zugriff auf das Digital Courseware Book (dMOC).
  • Exam Voucher: Sie erhalten zusätzlich einen Gutschein, um den MOD-Kurs mit einer offiziellen Prüfung abzuschließen, mit der Sie Ihr erworbenes Wissen gegenüber Arbeitgebern oder Kunden belegen können.
  • Practice Test: Zur besseren Prüfungsvorbereitung erhalten Sie Zugriff auf einen umfassenden Übungstest.
  • 1 Tag individuelle Prüfungsvorbereitung: Diese findet im Präsenzunterricht in einem GFN-Trainingscenter mit einem unserer zertifizierten Microsoft-Trainer statt.

MOC On-Demand
Einfach mehr Flexibilität

Microsoft MOC On-Demand bietet Ihnen die Möglichkeit, Ihre Schulungen flexibler zu gestalten. Sie haben jederzeit Zugriff auf alle Bestandteile des Kurses und entscheiden, wann, wo und was Sie lernen. Auf der Lernplattform finden Sie hochwertige Videos, in denen erfahrene Trainer Ihnen Lerninhalte vermitteln, sowie praktische Übungen. Am Ende jedes Moduls können Sie Ihr Wissen mithilfe von Knowledge-Checks überprüfen.

Auf Wunsch schließen Sie die Microsoft Official On-Demand-Kurse bei der GFN AG mit international anerkannten Zertifizierungen ab. Dazu erhalten Sie neben Original Practice Tests weitere Zusatzleistungen wie Exam Vouchers, den Zugang zu 600 e-Books und eine kostenfreie Wiederholungsprüfung pro Kurs, falls es mal auf Anhieb nicht klappt (Second Shot).

Flexibilität

Profitieren Sie von maximaler Flexibilität und absolvieren Sie die offiziellen Microsoft Schulungen jetzt auch Online.

On- und Offline lernen

Maximaler Lernerfolg dank einer didaktisch sinnvollen Verzahnung von Präsenzunterricht und Online-Lerninhalten.

Originalunterlagen

Sie erhalten zu allen MOC On-Demand Kursen originale Schulungsunterlagen von Microsoft sowie den Zugang zur Live Lab-Umgebung.

Beste Lernumgebung

Profitieren Sie von praxiserfahrenen Trainern in unseren modernen, zentral gelegenen Trainingscentern.

High Quality Videos

Erfahrene Microsoft Trainer vermitteln in detaillierten Videos die Lerninhalte. Alle Inhalte wurden von Experten entwickelt.

Originalunterlagen

Sie erhalten Zugriff auf original Schulungsunterlagen von Microsoft – sowohl für die Präsenz- als auch für die MOD-Kurse.

Modularer Aufbau

Eine klar gegliederte Kursstruktur, die sich auch in kleineren Einheiten gut bearbeiten lässt. Ergo: Volle Flexibilität!

Zusatzleistungen

Exklusive Zusatzleistungen wie z.B. kostenlose Wiederholungsprüfungen, Exam-Voucher und ca. 600 E-Books warten auf Sie.

Knowledge Checks

Zahlreiche Übungsaufgaben am Ende von Kursen und Modulen, um das erlernte Wissen praxisnah zu testen und zu vertiefen.

Live-Lab-Zugriff

Sie haben vollen Zugriff auf die virtuelle Lernumgebung von Microsoft – inkl. Tutorials, High Quality Videos und Knowledge Checks.

Rund um die Uhr

Die Kursinhalte und Übungsaufgaben stehen 24 Stunden am Tag zur Verfügung. Lernen Sie wann Sie wollen, wo Sie wollen.

Hoher Praxisanteil

Alle Präsenzkurse zeichnen sich durch einen besonders hohen Praxisanteil und realistisch gestalteten Übungsaufgaben aus.

MOC On-Demand – Ihre Vorteile

  • Abwechslungsreiche Lernmethoden
    Von Experten entwickelte Lerninhalte werden in ausführlichen Videos, interaktiven Übungen und Reading Parts vermittelt.
  • Offizielle Schulungsunterlagen und Live Lab
    Zu jedem MOC On-Demand Kurs erhalten Sie Original-Schulungsunterlagen von Microsoft sowie den Zugang zum Live Lab-Umgebung.
  • Sie bestimmen!
    Entscheiden Sie selbst, wann, wo und was Sie lernen.
  • Knowledge-Checks
    Überprüfen Sie Ihr Wissen nach jedem Modul mit den Knowledge-Checks.

Ihr Kontakt zur GFN AG

* Pflichtfeld
Ihre Daten nutzen wir ausschließlich zur Bearbeitung Ihrer
Anfrage. Eine Weitergabe an Dritte ist ausgeschlossen.

Haben Sie Fragen?

Sie haben Fragen zu unseren Angeboten, Leistungen und Services? Nutzen Sie einfach das Kontaktformular, wir melden uns schnellstmöglich bei Ihnen.

Nutzen Sie gerne auch dieses Formular, wenn Sie Anregungen zur Qualitätssteigerung unserer Schulungen oder Dienstleistungen haben.

Ihre schnellste Verbindung zu uns

Für eine noch schnellere Bearbeitung Ihres Anliegens hinterlassen Sie uns einfach eine Telefonnummer, unter der Sie gut erreichbar sind. Durch die Mitteilung Ihrer Postleitzahl können wir Ihr Anliegen direkt an das zuständige GFN-Trainingscenter weiterleiten.

Übrigens: Unsere 36 Trainingscenter sind über die gesamte Bundesrepublik Deutschland verteilt und garantiert auch in Ihrer Nähe. Wir freuen uns auf Ihren Besuch!