Course: Microsoft MOC On-Demand

About This Course

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.

Audience Profile

This course is intended for 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. This course is also intended to provide skills for Enterprise Desktop/Device Support Technicians (EDSTs) who provide Tier 2 support to users who run Windows 10 desktops and devices within a Windows domain environment in medium to large enterprise organizations.

At Course Completion

After completing this course, students will be able to:

• Describe the important new features of Windows 10
• Install Windows 10
• Configure a device running Windows 10
• Configure network connectivity for a Windows 10 device
• Manage storage in Windows 10
• Manage files and printers
• Manage apps
• Manage data security
• Manage device security
• Implement Windows 10 features to improve network security
• Monitor and update Windows 10 devices
• Restore files, roll back drivers, and recover Windows 10 devices

For more information, contact one of our course advisors

About This Course

This three-day instructor-led 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.

Audience Profile

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

At Course Completion

After completing this course, students will be able to:

• 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

For more information, contact one of our course advisors

About This Course

This course provides students with the knowledge and skills that they need to support and troubleshoot Windows 10 PCs and devices in a Windows Server domain environment.Students who take this course must have a good understanding of how to
configure Windows 10 and its features, and how they can use these features in enterprise environments.This course focuses on troubleshooting issues with Windows 10 devices.

Audience Profile

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; 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.

At Course Completion

After completing this course, students will be able to:

• Describe the processes involved in planning and using a troubleshooting methodology for Windows 10.
• Troubleshoot startup issues and operating system services on a Windows 10 PC.
• Resolve issues related to hardware devices and device drivers.
• Troubleshoot Windows 10 PCs remotely.
• Troubleshoot issues related to network connectivity.
• Troubleshoot client configuration failures and GPO application issues.
• Troubleshoot issues related to user settings.
• Troubleshoot remote connectivity issues.
• Resolve issues related to accessing resources from computers that are domain-joined.
• Resolve issues related to accessing resources from computers that are not domain-joined.
• Troubleshoot issues related to application installation and operation.
• Recover a PC running Windows 10.

For more information, contact one of our course advisors

About This Course

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

Audience Profile

The primary audience for this course are existing database professionals with experience of SQL Server 2014 who want toupdate 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.

At Course Completion

After completing this course, students will be able to:

• 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
• Troubleshoot client configuration failures and GPO application issues.
• Describe new and enhanced data access features
• Describe new and enhanced features in SQL Server OLAP
• Describe new SQL Server cloud functionality

For more information, contact one of our course advisors

About This Course

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.

Audience Profile

Typically, this course’s audience has a desktop-support background, and have worked as Enterprise Desktop Administrators. 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.

At Course Completion

After completing this course, students will be able to:

• Assess the network environment to support operating system and application deployment tasks.
• Identify the most appropriate operating system deploymenet stratengy abased upon organisational requirements.
• Assess application compatability 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 multicase soltuions when performing operating system deployment tasks.
• Configure an operating system deployment stratefy 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 licence activation and configuration settings for client computers.
• Customise and deploy Microsoft Office 2016 to an enterprise network environment and describe how to use the Windows ICD.

For more information, contact one of our course advisors

About This Course

Get expert instruction and hands-on practice configuring and managing clients and devices by using Microsoft System Center v1511 Configuration Manager, Microsoft Intune, and their associated site systems. In this five-day course, you will learn day-to-day management tasks, including how to manage software, client health, hardware and software inventory, applications, and integration with Intune. You also will learn how to optimize System Center Endpoint Protection, manage compliance, and create management queries and reports. Additionally, this course, in conjunction
with Microsoft Official Course 20695C, also helps certification candidates prepare for Exam 70-696: Managing Enterprise Devices and Apps.

Audience Profile

This course is for experienced information technology (IT) professionals, typically described as Enterprise Desktop Administrators (EDAs). 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 and Intune to manage and deploy PCs, devices, and applications. By using Configuration Manager with Intune, EDAs also can support either domain-joined or non-domain-joined Bring Your Own Device (BYOD) scenarios, mobile-device management, and secure data access on common operating-system platforms, such as Windows, Windows Phone, Apple iOS, and Android.

This course also is for individuals who are interested in taking exam 70-696: Managing Enterprise Devices and Apps.

At Course Completion

After completing this course, students will be able to:

• Describe the features Configuration Manager and Intune include, and explain how you can use these features to manage PCs and mobile devices in an enterprise environment.
• 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.
• Use Configuration Manager to implement Endpoint Protection.
• 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 mobile devices by using Configuration Manager and Intune.
• Manage and maintain a Configuration Manager site.

For more information, contact one of our course advisors

About This Course

This course provides students with the fundamental knowledge and skills to configure and manage Internet Information Services. This course is intended to help provide pre-requisite skills supporting a broad range of Internet web applications,security, and knowledge to help support other products that use IIS such as Exchange and SharePoint.In keeping with that goal, this course will not focus on any particular web application or development practice.

Audience Profile

This course is intended for IT Professionals already experienced in general Windows Server and Windows Client administration. No prior experience with any version of Internet Information Services is assumed.

At Course Completion

After completing this course, students will be able to:

• Install IIS
• Configure the default website
• Configure and manage application pools
• Create additional websites
• Configure websites and application support
• Secure websites and applications
• Secure website data transmission
• Manage certificates in the Centralised Certificate Store
• Configure remote administration
• Implement FTP
• Monitor IIS
• Backup and Restore IIS
• Build load-balanced web forms

For more information, contact one of our course advisors

About This Course

Learn the fundamental knowledge and skills that you need to build a Windows Server infrastructure with Windows Server 2012.

This five day course provides the networking, security, and system administration information that you need to implement a Windows Server infrastructure. It covers the basics of installation and configuration, storage, network infrastructure, network components, network protocols, server roles, Active Directory Domain Services (AD DS), Group Policy, IT security, server security, network security, security software, monitoring server performance, and maintaining a Windows Server.

This course includes the foundational level knowledge to prepare students to start a career or cross train in Microsoft Windows Server technologies.

Audience Profile

Students for this course are just starting their Information Technology (IT) careers or want to change careers into Windows Server technologies. This fundamental knowledge and skills can be used by home computer users, small business owners, academic students, information workers, technical managers, help desk technicians, or students who want to cross train from another technology.

This course is a first step in preparing for a job in IT or as prerequisite training before you start the Microsoft Certified System Administrator (MCSA) training and certification path.

At Course Completion

After completing this course, students will be able to:

• Perform a local media-based installation of Windows Server 2012.
• Select appropriate storage technologies and configure on a Windows Server.
• Describe fundamental network components and terminology so you can select an appropriate network component.
• Implement a network by selecting network hardware components and technologies and determine the appropriate network hardware and wiring components for a given situation.
• Describe the protocols and services within the Transmission Control Protocol/Internet Protocol (TCP/IP) suite of protocols and implement IPv4 within a Windows Server environment.
• Describe and implement server roles.
• Implement and configure an Active Directory Domain Service (AD DS) forest.
• Describe the concept of defense-in-depth and determine how to implement this approach with Windows Server.
• Identify the security features in Windows Server that help to provide defense-in-depth.
• Identify the network-related security features in Windows Server to mitigate security threats to your network.
• Identify and implement additional software components to enhance your organization’s security.
• Monitor a server to determine the performance level.
• Identify the Windows Server tools available to maintain and troubleshoot Windows Server.

Prerequisites

Before attending this course, students must have:

• Basic knowledge/experience with Windows Server 2012.

For more information, contact one of our course advisors

About This Course

Get hands-on instruction and practice installing and configuring Windows Server 2012, including Windows Server 2012 R2, in this Microsoft Official On Demand Course. This course is part one in a series of three courses that provides the skills and knowledge necessary to implement a core Windows Server 2012 infrastructure in an
existing enterprise environment.

The three courses collectively cover implementing, managing, maintaining and provisioning services and infrastructure in a Windows Server 2012 environment. Although there is some cross-over of skills and tasks across these courses, this course focuses on the initial implementation and configuration of core services, such
as Networking, Storage, Active Directory Domain Services (AD DS), Group Policy, File and Print Services, and Hyper-V.

Labs in this course are based on Windows Server 2012 R2 and Windows 8.1.

Audience Profile

This course is intended for information technology (IT) professionals who have some knowledge and experience working with Windows operating systems and who want to acquire ,the skills and knowledge necessary to install and perform the initial configuration of a Windows Server 2012 or Windows Server 2012 R2 server in an existing Windows server environment. Typically, candidates who are interested in attending this course include:

• Windows Server administrators who are relatively new to Windows Server administration and related technologies who are looking to learn more about Windows Server 2012 and Windows Server 2012 R2.
• IT professionals who are experienced in other non-Microsoft technologies, who meet the course prerequisites and are looking to cross-train on Windows Server 2012 and Windows Server 2012 R2.
• IT professionals who are looking to take the Microsoft Certified Solutions Associate (MCSA) 410: Installing and Configuring Windows Server 2012 exam.
• IT professionals who want to take the Microsoft Certified Solutions Expert (MCSE) exams in DataCenter, Desktop Infrastructure, Messaging, Collaboration and Communications will also be interested in taking this course as they prepare for the Microsoft Certified Solutions Associate (MCSA) exams. These are a prerequisite for their individual specialties.

At Course Completion

After completing this course, students will be able to:

• Install and configure Windows Server 2012
• Decribe AD DS
• Manage Active Directory objects
• Automate Active Directory administration
• Implement IPv4
• Implement Dynamic Host Configuration Protocol (DHCP)
• Implement Domain Name System (DNS)
• Implement IPv6
• Implement local storage
• Implement file and print services
• Implement group policy
• Secure Windows servers by using Group Policy Objects (GPOs)
• Implement server virtualization by using Hyper-V

Prerequisites

Before attending this course, students must have:

• Knowledge and skills concerning the initial implementation and configuration of core Windows Server services including Active Directory Domain Services (AD DS), Networking Services and Microsoft Hyper-V.

For more information, contact one of our course advisors

About This Course

Get hands-on instruction and practice administering Windows Server 2012, including Windows Server 2012 R2, in this Microsoft On-Demand course.This course is part two in a series of three courses that provides the skills and knowledge necessary to implement a core Windows Server 2012 infrastructure in an existing enterprise environment.

The three courses collectively cover implementing, managing, maintaining and provisioning services and infrastructure in a Windows Server 2012 environment. Although there is some cross-over of skills and tasks across these courses, this course focuses on the administration tasks necessary to maintain a Windows Server 2012 infrastructure such as configuring and troubleshooting name resolution, user and group management with Active Directory Domain Services (AD DS) and Group Policy, implementing Remote Access solutions such as DirectAccess, VPNs and Web Application Proxy, implementing Network Policies and Network Access Protection, Data Security, deployment and maintenance of server images, as well as update
management and monitoring of Windows Server 2012 environments.

Labs in this course are based on Windows Server 2012 R2 and Windows 8.1.

Audience Profile

This course is intended for Information Technology (IT) Professionals with hands on experience working in a Windows server 2008 or Windows Server 2012 environment who wish to acquire the skills and knowledge necessary to be able to manage and maintain the core infrastructure required for a Windows Server 2012 and Windows Server 2012 R2 environment. The key focus for students is to broaden the initial deployment of Windows Server 2012 services and infrastructure and provide the skills necessary to Manage and Maintain a domain based Windows Server 2012 environment, providing skills in areas such as User and Group management, Network Access and Data Security. Candidates typically interested in attending this course would be

• Windows Server Administrators experienced in working with Windows Server 2008 or Windows
  Server 2012 who wish to gain skills necessary to perform daily management and maintenance tasks in a Windows Server 2012 or Windows Server 2012 R2
  environment.
• IT Professionals who are looking to take the 411, Administering Windows Server 2012 exam
• IT professional wishing to take the Microsoft Certified Solutions Expert (MCSE) exams in
  DataCenter, Desktop Infrastructure, Messaging, Collaboration and Communications will also be interested in taking this course as they prepare for
  the Microsoft Certified Solutions Associate (MCSA) exams, which are a pre-requisite for their individual specialties.

At Course Completion

After completing this course, students will be able to:

• Configure and Troubleshoot Domain Name System
• Maintain Active Directory Domain Services
• Manage User and Service Accounts
• Implement Group Policy Infrastructure
• Manage User Desktops using Group Policy
• Install, Configure and Troubleshoot Network Policy Server
• Implement Network Access Protection
• Implement Remote Access
• Optimize File Services
• Configure Encryption and Advanced Auditing
• Deploy and Maintain Server Images
• Implement Update Managements
• Monitor Windows Server 2012

Prerequisites

Before attending this course, students must have:

• Knowledge and skills concerning the initial implementation and configuration
  of core Windows Server services including Active Directory Domain Services (AD DS), Networking Services and Microsoft Hyper-V.

For more information, contact one of our course advisors

About This Course

Get hands-on instruction and practice configuring advanced Windows Server 2012, including Windows Server 2012 R2, services in this MOC On-Demand course. This course is part three in a series of three courses that provides the skills and knowledge necessary to implement a core Windows Server 2012 infrastructure in an existing enterprise environment.

The three courses collectively cover implementing, managing, maintaining and provisioning services and infrastructure in a Windows Server 2012 environment. Although there is some cross-over of skills and tasks across these courses, this course focuses on advanced configuration of services necessary to deploy, manage and maintain a Windows Server 2012 infrastructure, such as advanced networking services, Active Directory Domain Services (AD DS), Active Directory Rights Management Services (AD RMS), Active Directory Federation Services (AD FS), Network Load Balancing, Failover Clustering, business continuity and disaster recovery services as well as access and information provisioning and protection technologies such as Dynamic Access Control (DAC), and Web Application Proxy integration with AD FS and Workplace Join.

Audience Profile

This course is intended for Information Technology (IT) Professionals with hands on experience implementing, managing and
maintaining a Windows Server 2012 or Windows Server 2012 R2 environment who wish to acquire the skills and knowledge necessary
to perform advanced management and provisioning of services within that Windows Server 2012 environment. Candidates who would
typically be interested in attending this course will be:

• Experienced Windows Server Administrators who have real world experience working in a Windows Server 2008 or Windows Server 2012 enterprise environment.
• IT Professionals who are looking to take the 70-412 exam (Configuring Advanced Windows Server 2012 Services).
• IT Professionals wishing to take the Microsoft Certified Solutions Expert (MCSE) exams in Datacenter, Desktop Infrastructure, Messaging, Collaboration and Communications will also be interested in taking this course as they prepare for the MCSA exams, which are a pre-requisite for their individual specialties.

At Course Completion

After completing this course, students will be able to:

• Configure advanced features for Dynamic Host Configuration Protocol (DHCP), Domain Name System (DNS), and configure IP Address Management (IPAM) with Windows Server 2012.
• Configure and manage iSCSI, BranchCache and FSRM.
• Configure DAC to manage and audit access to shared files.
• Plan and implement an AD DS deployment that includes multiple domains and forests.
• Plan and implement an AD DS deployment that includes locations.
• Implement and configure an Active Directory Certificate Services (AD CS) deployment.
• Implement an AD RMS deployment.
• Implement an AD FS deployment.
• Provide high availability and load balancing for web-based applications by implementing Network Load Balancing (NLB).
• Implement and validate high availability and load balancing for web-based applications by implementing NLB.
• Provide high availability for network services and applications by implementing failover clustering.
• Implement a failover cluster, and configure and validate a highly available network service.
• Deploy and manage Hyper-V virtual machines in a failover cluster.
• Implement a backup and disaster recovery solution based on business and technical requirements.

Prerequisites

Before attending this course, students must have:

• Experience working with Windows Server 2008 or Windows Server 2012 servers day to day in an Enterprise environment.

The course pre-requisites can be met by having knowledge equivalent to, or by attendance at, courses 20410C: Installing and Configuring Windows Server 2012 and 20411C: Administering Windows Server 2012 as this course will build upon the knowledge and skills covered in those courses.

For more information, contact one of our course advisors

About This Course

Get hands-on instruction and practice planning, designing and deploying a physical and logical Windows Server 2012 R2 enterprise
infrastructure in this 5-day Microsoft Official course. This course is part one in a series of two courses that provides the skills
and knowledge necessary to design and implement a Windows Server 2012 R2 infrastructure in an enterprise environment. The two courses
collectively cover designing, planning, deploying, securing, monitoring, automating, and virtualizing an enterprise server infrastructure.

This course covers the knowledge and skills needed to provide an enterprise solution that supports manual and automated server installations
in a physical and virtual environment including the supporting file and storage services. You will also learn the skills necessary to provide
enterprise networking solutions such as DHCP, IPAM, VPN, and DirectAccess. You will also learn the skills necessary to design and implement a
forest and domain infrastructure including multi domains/forest and branch office scenarios. This course maps directly to and is the preferred
choice for hands-on preparation for Microsoft Certified Solutions Expert (MCSE): Exam 413: Designing and Implementing and Server Infrastructure,
which is the fourth of five exams required for MCSE: Server Infrastructure certification.

Labs in this course are based on Windows Server 2012 R2 and System Center 2012 R2. This course is designed for experienced IT professionals who
support medium to large enterprises and have experience administering Windows Server 2012 R2 and have an MCSA: Windows Server 2012 certification or
equivalent skills.

Audience Profile

This course is intended for IT professionals who are responsible for planning, designing, and deploying a physical and a logical Windows Server 2012
enterprise Active Directory Domain Services (AD DS) infrastructure including the network services necessary. They have experience of previous Windows
Server operating systems and possess Windows Server 2012 certification Microsoft Certified Solutions Associate (MCSA) or equivalent skills. The course
is also intended for IT professionals who are looking to take the exam 70-413: Designing and Implementing a Server Infrastructure, as a stand-alone, or
as part of the requirement for the Microsoft Certified Solutions Expert (MCSE): Server Infrastructure Certification.

At Course Completion

After completing this course, students will be able to:

• Plan server upgrade and migration
• Plan and implement a server deployment strategy
• Plan and deploy servers by using System Centre 2012 R2 Virtual Machine Manager (VMM)
• Design and maintain an IP configuration and address management solution
• Design and implement name resolution
• Design and implement AD DS forest and domain infrastructure
• Design and implement an AD DS organizational unit (OU) infrastructure
• Design and implement a Group Policy Object (GPO) strategy
• Design and implement an AD DS physical strategy
• Design and implement an AD DS physical topology
• Design and implement storage and file services
• Design and implement network protection
• Design and implement remote access services

Prerequisites

Before attending this course, students must have:

• Experience working with Windows Server 2008 or Windows Server 2012 servers day to day in an Enterprise environment.

The course pre-requisites can be met by having knowledge equivalent to, or by attendance at, courses 20410C: Installing and Configuring Windows Server 2012 and 20411C: Administering Windows Server 2012 as this course will build upon the knowledge and skills covered in those courses.

For more information, contact one of our course advisors

About This Course

This course is intended for students who have experience building ASP.NET and C# applications. Students will also have experience with the Microsoft Azure platform and a basic understanding of the services offered.

This course offers students the opportunity to take an existing ASP.NET MVC application and expand its functionality as part of moving it to Azure. This course focuses on the considerations necessary when building a highly available solution in the cloud. This course also prepares the students for the 70-532: Developing Microsoft Azure Solutions certification exam.

Audience Profile

The candidates targeted by this training have basic experience in implementing and monitoring Microsoft Azure solutions. Candidates are also proficient with the development tools, techniques, and approaches used to build application solutions.

At Course Completion

After completing this course, students will be able to:

• Compare the services available in the Azure platform.
• Configure and deploy web applications.
• Creating Azure Web Apps from the gallery.
• Deploying and monitoring Azure Web Apps.
• Creating and configuring Azure Virtual Machines.
• Create and manage a storage account.
• Manage blobs and containers in a storage account.
• Create, configure and connect to a SQL Databases instance.
• Identify the implications of importing a SQL standalone database.
• Manage users, groups and subscriptions in an Azure Active Directory instance.
• Create a virtual network.
• Implement a point-to-site network.

Prerequisites

In addition to their professional experience, students must have experience working with the Azure platform. They will also have a general
understanding of C# concepts for the lab scenario. Candidates experience can include:

• Compare the services available in the Azure platform
• Configure and deploy web applications
• Creating Azure Web Apps from the gallery
• Deploying and monitoring Azure Web Apps
• Creating and configuring Azure Virtual Machines
• Create and manage a storage account
• Manage blobs and containers in a storage account
• Create, configure, and connect to a SQL Databases instance
• Identify the implications of importing a SQL standalone database
• Manage users, groups, and subscriptions in an Azure Active Directory instance
• Create a virtual network
• Implement a point-to-site network

For more information, contact one of our course advisors

About This Course

This Microsoft First Look Clinic introduces IT Professionals to the new features and capabilities of Windows Server 2016. It’s designed to provide a broad range of knowledge across a broad array of technologies focusing on the pillars Identity, Compute & Networking. No topic is covered fully, but students will finish the clinic with an understanding of the new and improved features and capabilities of Windows Server 2016. This course is based on Windows Server 2016 Technical Preview 4, and the technologies are subject to change in the final release.

Audience Profile

This clinic is intended for IT Professionals who are interested in learning about the new features and functionality in Windows Server 2016. People who are key influencers and technology decision makers in an IT organization will also be interested in attending this clinic and will benefit from gaining early insight into some of the latest technologies included in Windows Server 2016. In general, early adopters of new technology or people looking to gain early insight into new functionality in Windows Server 2016 will benefit from attending this First Look Clinic.

Prerequisites

While there are no specific prerequisites for attending the course, students will benefit most if they have experience in the following areas:

• Experience with Windows Server 2012 & 2012 R2
• Familiar with AD DS
• Experience configuring storage in an enterprise
• Experience managing an enterprise network
• Experience with virtual machines & clustering

For more information, contact one of our course advisors

About This Course

Get hands-on instruction and practice configuring and implementing new features and functionality in Windows Server 2012, including Windows Server 2012 R2, in this course. This course is designed for IT professionals who want to upgrade their existing Windows Server technical skills to Windows Server 2012 and Windows Server 2012 R2. It presumes a high level of knowledge about previous Windows Server technologies and skills equivalent to MCSA: Windows Server 2008 credential.

The course covers the new features and functionality in Windows Server 2012 and Windows Server 2012 R2, including management, network infrastructure, storage, access control,virtualization, high availability, and identity federation. Specific technologies covered include Windows PowerShell, Storage Spaces and Internet Small Computer System interface (iSCSI),
Active Directory, Hyper-V, implementation of Remote Access solutions such as DirectAccess, VPNs, and Web Application Proxy (WAP). The course also covers Failover Clustering, Federation Services as well as access and information provisioning and protection technologies such as Dynamic Access Control, and Web Application Proxy integration with Federation Services and Workplace Join.

This course is not a product upgrade course, detailing considerations for migrating and upgrading your specific environment to Windows Server 2012. Rather, this course will update your existing Windows Server knowledge and skills to Windows Server 2012, including Windows Server 2012 R2.

Audience Profile

This course is intended for Information Technology (IT) Professionals who are experienced Windows Server system administrators who are familiar with carrying out day to day Windows Server management and maintenance tasks. The course will update their skill to Windows Server 2012 and Windows Server 2012 R2. Candidates suitable for this course would be:

• Experienced Windows Server Administrators who have real world experience working in a Windows Server enterprise environment.
• IT professionals who have obtained the MCSA: Windows Server 2008, or a qualifying upgradeable certification, details of which are available here, or have equivalent knowledge.
• IT Professionals wanting to take the Microsoft Certified Solutions Expert (MCSE) exams in Data Center, Desktop Infrastructure, Messaging, Collaboration and Communication will
  also be interested in taking this course as they prepare for the Microsoft Certified Solutions Associate (MCSA) Windows Server 2012 credential, which is a pre-requisite for their
  individual specialities.

At Course Completion

After completing this course, students will be able to:

• Install and configure Windows Server 2012
• Manage Windows Server 2012 by using Windows PowerShell
• Manage storage in Windows Server 2012
• Implement network services
• Implement Remote Access
• Implement Failover Clustering
• Implement Hyper-V™
• Implement Failover Clustering with Hyper-V
• Implementing secure data access for users and devices
• Implement Active Directory Domain Services (AD DS)
• Implement Active Directory Federation Services (AD FS)
• Monitor and maintain Windows Server 2012

Prerequisites

Before attending this course, students must have:

• Experience working with Windows Server 2008 or Windows Server 2012 servers day to day in an Enterprise environment.

The course pre-requisites can be met by having knowledge equivalent to, or by attendance at, courses 20410C: Installing and Configuring Windows Server 2012 and 20411C: Administering Windows Server 2012 as this course will build upon the knowledge and skills covered in those courses.

For more information, contact one of our course advisors

About This Course

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 technical skills 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.

This course is not a product-upgrade course, detailing considerations for migrating and upgrading students’ specific environment to Windows Server 2016. Rather, this course provides updates to students' existing Windows Server knowledge and skills, as they pertain to Windows Server 2016.

Audience Profile

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.

Additionally, IT professionals who plan to take the Microsoft Certified Solutions Expert (MCSE) exams might be interested in this course, as preparation for the MCSA exams, which are a prerequisite for the MCSE specialties.

At Course Completion

After completing this course, students will be able to:

• 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.

Prerequisites

Before attending this course, students must have:

• 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.

For more information, contact one of our course advisors

About This Course

Learn how with Windows PowerShell 4.0, you can remotely manage multiple Windows based servers and automate day to day management and administration tasks.

The course is built on Windows Server 2012 R2 and Windows 8.1 and while it is specifically focused on Windows PowerShell v4.0, is also relevant in v2.0 and v3.0 Windows PowerShell environments

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.

In this course you will learn to execute and monitor scripts more efficiently through more robust session connectivity, workflow capabilities, enhanced job scheduling, and Windows PowerShell Web Access. Learn Windows PowerShell with greater ease through improved cmdlet discovery and simplified, consistent syntax across all cmdlets. Write Windows PowerShell scripts quicker and more intuitively through the new Integrated Scripting Environment (ISE) that enables script sharing, which connects IT pros to a larger Windows PowerShell user community. Learn all this and more in this On Demand Microsoft Official Course in Windows PowerShell 4.0.

Audience Profile

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.

This course is not intended to be a scripting or programming course, and includes only basic coverage of scripting and programming topics. Students are not expected to have prior scripting or programming experience, and are not expected to have prior Windows PowerShell experience

At Course Completion

After completing this course, students will be able to:

• 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

Prerequisites

Before attending this course, students must have:

• 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.

For more information, contact one of our course advisors

About This Course

Get hands-on instruction and practice planning, designing and deploying a physical and logical Windows Server® 2012 R2 enterprise infrastructure in this 5-day
Microsoft Official course. This course is part two in a series of two courses that provides the skills and knowledge necessary to design and implement a Windows
Server 2012 R2 infrastructure in an enterprise environment. The two courses collectively cover designing, planning, deploying, securing, monitoring, automating,
and virtualizing an enterprise server infrastructure. This course covers the knowledge and skills to plan and implement a highly available, secure infrastructure
with focus on Active Directory® Federation Service (AD FS), public key infrastructure (PKI), and Active Directory Rights Management Services (AD RMS). You will
also learn the skills needed to plan and deploy virtual machines including self-service and automation of virtual machine deployments as well as planning and
implementing a monitoring strategy that includes Microsoft® System Center 2012 R2-Operations Manager. This course maps directly to and is the preferred choice
for hands-on preparation for Microsoft Certified Solutions Expert (MCSE): Exam 414: Implementing an Advanced Server Infrastructure, which is the fifth of five
exams required for MCSE: Server Infrastructure certification. NOTE: Labs in this course are based on Windows Server 2012 R2 and System Center 2012 R2.

This course is designed for experienced IT professionals who support medium to large enterprises and have experience administering Windows Server 2012 R2 and
have an MCSA: Windows Server 2012 certification or equivalent skills.

Audience Profile

This course is intended for Information Technology (IT) professionals who are responsible for planning, designing and deploying a physical and logical Windows Server
2012 enterprise and Active Directory Domain Services (AD DS) infrastructures including the network services. Candidates would typically have experience of previous
Windows Server operating systems and have Windows Server 2012 certification (MCSA) or equivalent skills.

The secondary audience for this course will be candidates are IT professionals who are looking to take the exam 70-414: Implementing an Advanced Enterprise Server
Infrastructure, as a stand-alone, or as part of the requirement for the MCSE certification.

At Course Completion

After completing this course, students will be able to:

• Describe an enterprise data center.
• Plan and implement a server virtualization strategy using System Center 2012.
• Plan and implement the network and storage infrastructure required to deploy a virtualized server infrastructure.
• Plan and deploy virtual machines on Windows Hyper-V®.
• Plan and implement a virtualization administration solution by using System Center 2012.
• Plan and implement a server monitoring strategy using the Windows Server 2012 tools and using Microsoft System Center 2012 - Operations Manager.
• Plan and implement an application and a file services infrastructure that is highly available.
• Moving From a Command to a Script to a Module
• Plan and implement a highly available server infrastructure by using the failover clustering features in Windows Server 2012.
• Plan and implement a business continuity strategy in a Windows Server 2012 environment.
• Plan and implement a PKI deployment, and plan and implement a certificate management solution.
• Plan and implement an AD FS server deployment and claims aware application access.
• Plan and implement Dynamic Access Control, Workplace Join and Work Folders.
• Plan and implement an AD RMS deployment, plan and manage AD RMS templates and access, and plan and implement external access to AD RMS services.

Prerequisites

Before attending this course, students must have:

• An understanding of TCP/IP and networking concepts.
• An understanding of Windows Server 2012 and AD DS, including planning, designing and deploying.
• An understanding of scripts and batch files.
• An understanding of security concepts such as authentication and authorization.
• An understanding of deployment, packaging, and imaging tools.
• Experience working in a team or a virtual team.
• Achieved the Windows Server 2012 MCSA certification as well as information in the course 20413C: Designing and Implementing an Enterprise Server Infrastructure.

For more information, contact one of our course advisors

About This Course

Learn how to automate and streamline day to day management and administration tasks and functions in your Windows Server Infrastructure.

The course is built on Windows Server 2012 R2 and Windows 8.1 and while it is specifically focused on Windows
PowerShell v4.0, is also relevant in v2.0 and v3.0 Windows PowerShell environments

This course is a follow on course from the 10961B: Automating Administration with Windows PowerShell course. It is built on Windows Server 2012 R2
and Windows 8.1 and while it is specifically focused on Windows PowerShell v4.0, is also relevant in v2.0 and v3.0 Windows PowerShell environments.

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 robust by 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.

The detailed hands on labs and in depth content and learning will help remove manual tasks that you may currently have to perform as an Administrator,
allowing you to make your own Windows PowerShell tools for automated, repeated, accurate management and provisioning of your Windows Server infrastructure.

Audience Profile

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.

At Course Completion

After completing this course, students will be able to:

• 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

Prerequisites

Before attending this course, students must have:

• 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.

For more information, contact one of our course advisors

About This Course

This course equips students with the skills they require to deploy and configure System Center 2012 R2 Operations Manager. Using hands-on labs, students learn the following:

• How to architect and implement a System Center 2012 R2 Operations Manager Management Group.
• How to upgrade and migrate from an existing Operations Manager 2007 R2 Management Group to System Center 2012 Operations Manager, System Center 2012 SP1 Operations Manager and System Center 2012 R2 Operations Manager.
• Understand the key elements of Management Packs including Object Discoveries, Rules, Monitors, Targeting and Run As Accounts and Run As Profiles. This includes authoring Management Packs.
• How to configure fabric and application monitoring in System Center 2012 R2 Operations Manager including both datacenter and cloud resources such as networking, storage and compute.
• How to configure monitoring of .NET and Java based applications using Application Performance Monitoring.
• How to configure end-to-end service monitoring including synthetic transactions and Distributed Application Diagrams.
• How to configure Dashboards, Service Level Tracking Reporting and the SharePoint Web Part to enable visualization of key performance and availability metrics.
• How to customize the Operations Manager Console to meet the needs of different application support teams.
• How to integrate Operations Manager with other System Center 2012 R2 components and extend monitoring to include key business processes and procedures.
• How to troubleshoot an Operations Manager Management Group and perform disaster recovery procedures such as database and management server recovery.
• How to use new features in System Center 2012 R2 including: Integration with System Center Advisor, Integration with Team Foundation Server, IntelliTrace, and Managing Windows Azure.

Audience Profile

The primary audience for this course is cloud and datacenter administrators who are new to System Center 2012 R2 Operations Manager and are responsible for deploying, configuring and operating it in their cloud or datacenter. The secondary audience for this course is cloud and datacenter administrators who are already familiar with Operations Manager and want to upgrade their skills to include the new features found in System Center 2012 Operations Manager, System Center 2012 SP1 Operations Manager and System Center 2012 R2 Operations Manager.

At Course Completion

After completing this course, students will be able to:

• Plan for the deployment of System Center 2012 R2 Operations Manager.
• Defining hardware and software requirements.
• Describing security considerations.
• Architect a highly available System Center and Microsoft SQL platform utilising Microsoft SQL Server AlwaysOn.
• Planning for migration and upgrade scenarious to System Center 2012 R2 Operations Manager.
• Customise the Operations Console with User Roles.
• Perform different methods of Agent deployment with System Center 2012 R2 Operations Manager.

Configure the following:

• Audit Collection Services
• Agentless Exception Monitoring
• Operations Manager SharePoint Web Part in System Center 2012 R2 Operations Manager.
• Configure Application Performance Monitoring and Network Device monitoring in System Center 2012 R2 Operations Manager.
• Configure dashboards and widgets in System Center 2012 R2 Operations Manager.
• Describe how to use new cloud-based features including System Center Global Service Monitor and System Center Advisor.
• Configure integration between System Center 2012 R2 Operations Manager and other System Center 2012 R2 components.
• Troubleshoot an Operations Manager Management Group.
• Perform disaster recovery in System Center 2012 R2 Operations Manager.

For more information, contact one of our course advisors

About This Course

Get Hands on instruction and practice administering Active Directory technologies in Windows Server 2012 and Windows Server 2012 R2 in this course. You will learn the skills you need to better manage and protect data access and information, simplify deployment and management of your identity infrastructure, and provide more secure access to data. You will learn how to configure some of the key features in Active Directory such as Active Directory Domain Services (AD DS), Group Policy, Dynamic Access Control (DAC), Work Folders, Work Place Join, Certificate Services, Rights Management Services (RMS), Federation Services, as well as integrating your on premise environment with cloud based technologies such as Windows Azure Active Directory. As part of the learning experience, you will perform hands-on exercises in a virtual lab environment.

Audience Profile

This course is intended for Information Technology (IT) Professionals who have Active Directory Domain Services (AD DS) experience and are looking to for a single course that will further develop knowledge and skills using Access and Information Protection technologies in Windows Server 2012 and Windows Server 2012 R2. This would typically include:

• AD DS Administrators who are looking to further develop skills in the latest Access and Information Protection technologies with Windows Server 2012 and Windows Server 2012 R2.
• System or Infrastructure administrators with general AD DS experience and knowledge who are lookig to build upon that core knowledge and cross-train into advanced Active Directory technologies in Windows Server 2012 and Windows Server 2012 R2.
• IT Professionals who have taken the 10967A: Fundamentals of a Windows Server Infrastructure course and are looking to build upon that Active directory knowledge.

At Course Completion

After completing this course, students will be able to:

• Understand available solutions for identity management and be able to address scenarios with appropriate solutions.
• Deploy and administer AD DS in Windows Server 2012.
• Secure AD DS sites as well as configure and manage replication.
• Implement and manage Group Policy.
• Implement Certification Authority (CA) hierarchy with AD CS and how to manage CAs.
• Implement, deploy and manage certificates.
• Implement and manage AD RMS.
• Implement and manage AD FS.
• Secure and provision data access using technologies such as Dynamic Access Control, Work Folders and Workplace Join
• Monitor, troubleshoot and establish business continuity for AD DS services.
• Implement Windows Azure Active Directory.
• Implement and administer Active Directory Lightweight Directory Services (AD LDS).

Prerequisites

Before attending this course, students must have:

• 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.

For more information, contact one of our course advisors

About This Course

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.

Audience Profile

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.

At Course Completion

After completing this course, students will be able to:

• 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

Prerequisites

Those taking this course should already have gained some limited experience using SQL to complete basic tasks.
More specifically, students should have System Administrator level experience and be able to demonstrate their understanding of such systems.

For more information, contact one of our course advisors

About This Course

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 and tools 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.

Audience Profile

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

At Course Completion

After completing this course, students will be able to:

• 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

Prerequisites

Those taking this course should already have gained some limited experience using SQL to complete basic tasks.
More specifically, students should have System Administrator level experience and be able to demonstrate their understanding of such systems.

For more information, contact one of our course advisors

About This Course

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.

Audience Profile

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. Primary responsibilities include:

• Implementing a data warehouse.
• Developing SSIs packages for data extraction, transformation and loading.
• Enforcing data integrity by using Master Data Services.
• Cleansing data by using Data Quality Services.

At Course Completion

After completing this course, students will be able to:

• Describe data warehouse concepts and architecture considerations.
• Select an appropriate hardware platform for a data warehouse.
• Implement Data Flow in an SSIS package.
• Implement Control Flow in an SSIS package.
• Debug and troubleshoot SSIS package.
• 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 enfore data integrity.
• Extend SSIS with custom scripts and components.
• Deploy and configure SSIS packages.
• Describe how DI solutions can consume data from the data warehouse.

Prerequisites

Those taking this course should already have gained some limited experience using SQL to complete basic tasks.
More specifically, students should have System Administrator level experience and be able to demonstrate their understanding of such systems.

For more information, contact one of our course advisors

About This Course

This course is intended for IT professionals who are familiar with managing on-premises IT deployments that include AD DS, virtualization technologies, and applications. The students typically work for organizations that are planning to locate some or all of their infrastructure services on Azure. This course also is intended for IT professionals who want to take the Microsoft Certification exam, 70-533, Implementing Azure Infrastructure Solutions.

NOTE: for this course, learning partners do not need to order Azure passes or distribute them to students.

This process for students to access the On-Demand labs for OD20533 is different from the MOC Process (where the Learning Partner provides to the student).

• Student buys the OD20533 MOC On-Demand course from Learning Partner.
• In the first lab of the course, students will access the Azure pass required for hands-on labs from our lab hoster.

Audience Profile

This course is intended for IT professionals who have some knowledge of cloud technologies and want to learn more about Azure.

• IT professionals who want to deploy, configure, and administer services and virtual machines (VMs) in Azure.
• IT professional who use Microsoft System Center to manage and orchestrate server infrastructure.
• Windows Server administrators who are looking to evaluate and migrate on-premises Active Directory roles and services to the cloud.
• IT professionals who want to use Windows Azure to host websites and mobile app backend services.
• IT professionals who are experienced in other non-Microsoft cloud technologies, meet the course prerequisites, and want to cross-train on Azure.
• IT professionals who want to take the Microsoft Certification exam 70-533, Implementing Azure Infrastructure Solutions.

At Course Completion

After completing this course, students will be able to:

• Describe data warehouse concepts and architecture considerations.
• Select an appropriate hardware platform for a data warehouse.
• Implement Data Flow in an SSIS package.
• Implement Control Flow in an SSIS package.
• Debug and troubleshoot SSIS package.
• 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 enfore data integrity.
• Extend SSIS with custom scripts and components.
• Deploy and configure SSIS packages.
• Describe how DI solutions can consume data from the data warehouse.

Prerequisites

Before attending this course, students must have the following technical knowledge:

• Completed the Microsoft Certified Systems Administrator (MCSA) certification in Windows Server 2012.
• Understanding of on-premises virtualization technologies, including: virtual machines, virtual networking, and virtual hard disks (VHDs).
• Understanding of network configuration, including: TCP/IP, Domain Name System (DNS), virtual private networks (VPNs), firewalls, and encryption technologies.
• Understanding of websites, including: how to create, configure, monitor and deploy a website on Internet Information Services (IIS).
• Understanding of Active Directory concepts, including: domains, forests, domain controllers, replication, Kerberos protocol, and Lightweight Directory Access Protocol (LDAP).
• Understanding of database concepts, including: tables, queries, Structured Query Language (SQL), and database schemas.
• Understanding of resilience and disaster recovery, including backup and restore operations.

For more information, contact one of our course advisors

About This Course

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.

Audience Profile

This course is intended for 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. This course is also intended to provide skills for Enterprise Desktop/Device Support Technicians (EDSTs) who provide Tier 2 support to users who run Windows 10 desktops and devices within a Windows domain
environment in medium to large enterprise organizations.

At Course Completion

After completing this course, students will be able to:

• Describe the important new features of Windows 10.
• Install Windows 10.
• Configure a device running Windows 10.
• Configure network connectivity for a Windows 10 device.
• Manage storage in Windows 10.
• Manage files and printers.
• Manage apps.
• Manage data security.
• Manage device security.
• Implement Windows 10 features to improve network security.
• Monitor and update Windows 10 devices.
• Restore files, roll back drivers, and recover Windows 10 devices.

Prerequisites

Before attending this course, students must have:

• At least two years of experience in the IT field.
• Knowledge of networking fundamentals, including Transmission Control Protocol /Internet Protocol (TCP/IP), User Datagram Protocol (UDP), and Domain Name System (DNS).
• Knowledge of Microsoft Active Directory Domain Services (AD DS) principles and fundamentals of AD DS management.
• Understanding of Windows Server 2008 R2 or Windows Server 2012 fundamentals.
• Understanding of Microsoft Windows Client essentials; for example, working knowledge of Windows 7, Windows 8 and/or Windows 10.
• Basic understanding of Windows PowerShell syntax.

For more information, contact one of our course advisors

About This Course

The purpose of this 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.

Audience Profile

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.

At Course Completion

After completing this course, students will be able to:

• 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.

For more information, contact one of our course advisors

About This Course

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.

Audience Profile

The primary audience for this course is IT Professionals who want to become skilled on SQL Server 2016 product features and technologies for implementing a database.

The secondary audiences for this course are individuals who are developers from other product platforms looking to become skilled in the implementation of a SQL Server 2016 database.

At Course Completion

After completing this course, students will be able to:

• Design and implement tables
• Describe advanced table designs
• Ensure data integrity through constraints
• Describe indexes; including optimised 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

For more information, contact one of our course advisors

About This Course

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. The lab scenarios in this course are selected to support and demonstrate the structure of various application scenarios. They are intended to focus on the principles and coding components/structures that are used to establish an HTML5 software application.

Audience Profile

This course is intended for professional developers who have 6-12 months of programming experience and who are interested in developing applications using HTML5 with JavaScript and CSS3 (either Windows Store apps for Windows 8 or web applications). This course is intended for students who have the following experience:

• 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.

This course is not intended for developers with three or more months of HTML5 coding experience.Students choosing to attend this course without a developer background should pay special attention to the training prerequisites.
Developers who have more than 5 years programming experience may find that portions of this training are fundamental in nature when presenting the syntax associated with certain programming tasks.

At Course Completion

After completing this course, students will be able to:

• 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.

Prerequisites

Developers attending this course should already have gained some limited experience using C# to complete basic programming tasks.
More specifically, students should have hands-on experience using C# that demonstrates their understanding of the following:

• 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.

For more information, contact one of our course advisors

About This Course

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.

The course introduces many of the techniques and technologies employed by modern desktop and enterprise applications, including:

• Building new data types.
• Handling events.
• Programming the user interface.
• Accessing a database.
• Using remote data.
• Performing operations asynchronously.
• Integrating with unmanaged code.
• Creating custom attributes.
• Encrypting and decrypting data.

At the end of the course, students should leave the class with a solid knowledge of C# and how to use it to develop .NET Framework 4.5 applications. This course uses Visual Studio 2012, running on Windows 8.

Audience Profile

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.

This course is not designed for students who are new to programming; it is targeted at professional developers with at least one month of experience programming in an object-oriented environment.

At Course Completion

After completing this course, students will be able to:

• 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.

Prerequisites

Developers attending this course should already have gained some limited experience using C# to complete basic programming tasks.
More specifically, students should have hands-on experience using C# that demonstrates their understanding of the following:

• 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.

For more information, contact one of our course advisors

About This Course

This course provides knowledge and skills on developing Web applications by using Microsoft Visual Studio.

Audience Profile

This course is intended for Web developers who are beginners and have knowledge of Hypertext Markup Language (HTML)
or Dynamic HTML (DHTML), along with some knowledge of a scripting language such as Visual Basic Scripting Edition or
Microsoft Jscript.
Students are required to have the following skills:

At Course Completion

After completing this course, students will be able to:

• Explore ASP.NET Web applications in Microsoft Visual Studio.
• Create Web applications by using Microsoft Visual Studio and Microsoft .NET–based languages.
• Create a Microsoft ASP.NET Web Form.
• Add functionality to a Microsoft ASP.NET Web Form.
• Implement master pages and user controls.
• Validate user input.
• Debug Microsoft ASP.NET Web applications.
• Manage data in an ASP.NET 3.5 Web application.
• Manage data access tasks by using LINQ.
• Manage data by using ASP.NET Dynamic Data.
• Create a Microsoft ASP.NET AJAX application.
• Consume and Windows Communication Foundation (WCF) services.
• Manage state in Web applications.
• Configure and deploy a Microsoft ASP.NET Web application.
• Secure a Microsoft ASP.NET Web application.
• Implement new technologies supported by Visual Studio 2010 for Web development.

Prerequisites

Before attending this course, students must have
a working knowledge of:

• Ability to construct a simple Web page using a Microsoft or 3rd Party tool.
  For example, create or customize a Web Page on a SharePoint site.

For more information, contact one of our course advisors

About This Course

This course describes how to configure and manage a System Center 2012 R2 Configuration Manager site and its associated
site systems. The course focuses on day-to-day management tasks for System Center 2012 R2 Configuration Manager.

Audience Profile

The primary audience for this course is intended for IT Professionals who are responsible for configuring and managing
endpoints in one or more System Center 2012 R2 Configuration Manager sites and all supporting systems. They have one to
three years of experience managing and maintaining client computers, devices, and servers in medium to large enterprise
organizations. Administrators may have previous Configuration Manager experience, or be new to the product.

The secondary audience for this course is intended for individuals who are interested in taking exam
70-243 TS: Microsoft System Center 2012 Configuration Manager, Configuring. Both 10747D:
Administering System
Center 2012 R2 Configuration Manager
, and 10748C: Planning and Deploying System Center 2012 Configuration Manager,
are necessary to prepare for this exam.

At Course Completion

After completing this course, students will be able to:

• Describe the System Center 2012 R2 Configuration Manager feature set and manage and troubleshoot sites by using the Configuration Manager Console and associated toolset.
• Configure boundaries and boundary groups, configure discovery methods, manage user and device collections, and implement role-based administration.
• Describe the inventory collection process, configure and manage hardware and software inventory, monitor inventory data flow, and use Asset Intelligence and Software Metering.
• Analyze data by creating queries and running reports.
• Create, deploy, and manage software packages and programs.
• Create and deploy applications by using the System Center 2012 R2 Configuration Manager application model.
• Configure multiple deployment types.
• Deploy and manage software updates.
• Integrate and implement Endpoint Protection by using System Center 2012 R2 Configuration Manager.
• Deploy operating systems by using the Configuration Manager infrastructure.
• Manage configuration items, baselines, and profiles to assess and configure settings for devices.
• Manage mobile devices by using System Center 2012 R2 Configuration Manager.
• Configure Wake On LAN, Power Management policies, and Remote Control.

Prerequisites

Before attending this course, students must have
System Administrator–level working knowledge of:

• Installation, configuration, and troubleshooting for Windows-based personal computers.
• Windows client management including endpoint security fundamentals.
• Networking fundamentals, including TCP/IP and Domain Name System (DNS).
• Windows Server administration concepts including Active Directory and group policy principles and management.
• Basic concepts of Public Key Infrastructure (PKI) security.
• Familiarity with Windows Intune
• Desired: Basic understanding of Windows Server roles and services
• Desired: Basic understanding of Microsoft SQL Server Reporting Services

For more information, contact one of our course advisors

About This Course

Get detailed instruction and hands-on practice planning and deploying Microsoft System Center 2012 R2 Configuration Manager and its associated site systems. This course is designed for IT Professionals who are responsible for designing and deploying one or more System Center 2012 R2 Configuration Manager sites and all supporting systems, as well as configuring and managing endpoints in those systems. You will learn how to plan for the deployment of the central administration site, one or more primary sites and secondary sites, and all associated site systems. You will also learn how to migrate from System Center 2012 Configuration Manager to System Center 2012 R2 Configuration Manager.

This course also helps candidates prepare for Exam 70-243, MCTS: Administering and Deploying System Center 2012 Configuration Manager. Both Configuration Manager courses,
10747D and 10748C, or the equivalent knowledge and skills will be necessary to prepare for the exam.

Please Note: Windows Intune is used as part of the lab for this course, which may not be available in all countries. Please confirm with your Microsoft training provider that this
cloud service is available in your area. Training Providers: please reference the course setup guide for more details.

Audience Profile

This course is intended for Information Technology (IT) professionals who are responsible for designing and deploying one or more System Center 2012 R2 Configuration Manager sites and all
supporting systems. They should have three to five years of experience in medium to large enterprise organizations, in a role in which they are supporting multiple desktop and server
computers that run Windows®-based operating systems.

This course is also for individuals who are interested in taking exam 70-243 TS: Administering and Deploying System Center 2012 Configuration Manager.

Both 10747D: Administering System Center 2012 Configuration Manager and 10748C: Planning and Deploying System Center 2012 Configuration Manager are necessary to prepare for this exam.

After completing this course, students will be able to:

• Describe the System Center 2012 R2 Configuration Manager infrastructure.
• Plan and deploy a stand-alone primary site.
• Plan and configure role-based administration.
• Plan and deploy a multiple site hierarchy.
• Replicate data and manage content in Configuration Manager.
• Plan resource discovery and client deployment.
• Configure Internet and cloud-based client management.
• Maintain and monitor System Center 2012 R2 Configuration Manager.
• Migrate to System Center 2012 R2 Configuration Manager.

For more information, contact one of our course advisors

About This Course

This five day course will provide students with the key knowledge required to deploy and configure System Center 2012 R2 Service Manager. Using hands-on labs, students will learn the following:

• Where Service Manager sits within the System Center 2012 R2 product.
• What business and technical needs Service Manager is designed to meet.
• How Service Manager aligns itself to ITIL and MOF.
• How to architect and implement a System Center 2012 R2 Service Manager deployment.
• How to upgrade an existing Service Manager 2010 environment to System Center 2012.
• How to customize System Center 2012 R2 Service Manager to be in line with corporate standards.
• How to configure Incident and Problem Management.
• How to configure Activity, Change and Release Management.
• How to configure Service Requests.
• How to configure Service Level Management.
• How to customize the Self-Service Portal.
• How to configure Reporting and Analysis.
• How to troubleshoot Service Manager and perform disaster recovery.
• How to create customised Service Manager forms.

Audience Profile

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.

At Course Completion

After completing this course, students will be able to:

• 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.

For more information, contact one of our course advisors

About This Course

This course provides an in-depth discussion and practical hands-on training of Microsoft Azure Infrastructure Services (IaaS) including Azure Virtual Machines, Storage, Virtual Networking, Azure Active Directory and deployment options. This training is designed to relate IaaS technologies used in Amazon Web Services (AWS) to those used in Microsoft Azure.

Audience Profile

IT Professionals, and Enterprise Architects with cloud computing experience using Amazon Web Services. However, this course focuses on providing a basis for
understanding and working hands-on with Azure IaaS services, so prior knowledge of AWS is not a requirement for learning those services.

At Course Completion

After completing this course, students will have a working understanding of:

• Implementing and managing Virtual Machines and Storage
• Implementing and managing Azure Virtual Networking
• Implementing and managing Azure Resource Manager and Resource Groups
• Implementing and managing Azure Active Directory
• Comparing Microsoft Azure and AWS features and services
• Azure AD fundamentals

For more information, contact one of our course advisors

About This Course

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.

Audience Profile

This course is intended for individuals who want to evaluate deploying, configuring, and administering services and VMs using Azure, including:

• 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.

At Course Completion

After completing this course, students will be able to:

• 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.

For more information, contact one of our course advisors

About This Course

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.

Audience Profile

This course is intended for existing IT professionals who have some networking knowledge and experience and are looking for a single course that
provides insight into core and advanced networking technologies in Windows Server 2016. This audience would typically include:

• 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.

The secondary audience for this course is those IT professionals who are looking to take the MCSA 70-741: Networking with Windows Server 2016 exam.

At Course Completion

After completing this course, students will be able to:

• 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.

For more information, contact one of our course advisors

About This Course

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

Audience Profile

The primary audience for this course is 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.

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

At Course Completion

After completing this course, students will be able to:

• 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.

For more information, contact one of our course advisors

About This Course

This course will provide you with the knowledge and skills to configure and manage a Microsoft SharePoint Server 2013 environment. This course will teach you how to configure SharePoint Server 2013, as well as provide guidelines, best practices, and considerations that will help you optimize your SharePoint server deployment.

This is the first in a sequence of two courses for IT Professionals and will align with the first exam in the SharePoint Server 2013 IT Pro certification.

Audience Profile

The course is targeted at experienced IT Professionals interested in learning how to install, configure, deploy and manage SharePoint Server 2013 installations in either the data center or the cloud.

Students typically have more than four years of hands-on experience* planning and maintaining SharePoint and other core technologies upon which SharePoint depends, including Windows Server 2008 R2 or later, Internet Information Services (IIS), SQL Server 2008 R2 or later, Active Directory, and networking infrastructure services.

The minimally qualified candidate typically:

• Is an IT professional who plans, implements, and maintains a multi-server deployment of SharePoint Server 2013.
• Has a working knowledge of, and preferably hands-on experience, with SharePoint Online.
• Has broad familiarity with SharePoint workloads.
• Have experience with business continuity management, including data backup, restoration, and high availability.
• Has experience with authentication and security technologies
• Has experience with Windows PowerShell.
• Hands-on experience or job experience is considered a solutions-based role where the candidate works within the solutions space covered by SharePoint, working on multiple solutions in the SharePoint space that includes document management, content management, and search.

The secondary audience for this course are Business Application Administrators (BAAs) who are engaged in the administering line-of-business (LOB) projects in conjunction with internal business customers would benefit from an understanding of how to manage SharePoint Server 2013.

Administrators who are entirely new to SharePoint will gain some benefit from the course, but it is recommended that they familiarize themselves with the basic concepts of the SharePoint platform before attending.

At Course Completion

After completing this course, students will be able to:

• Describe the key features of SharePoint 2013
• Design an information architecture
• Design logical and physical architectures
• Install and configure SharePoint Server 2013
• Create web applications and site collections
• Plan and configure service applications
• Manage users and permissions
• Configure authentication for SharePoint 2013
• Secure a SharePoint 2013 deployment
• Manage taxonomy
• Configure user profiles
• Configure enterprise search
• Monitor and maintain a SharePoint 2013 environment

Prerequisites

An ideal candidate will have at least one year of experience with deploying and administering multiple SharePoint 2010 farms across a large enterprise. Because many customers skipped upgrading from SharePoint 2007, a candidate can also have at least 2 years of experience with SharePoint 2007 and knowledge of the differences between 2007 and 2010, particularly the Service Application model. A candidate can demonstrate the following skills:

• Software management in a Windows 2008 R2 enterprise server or Windows Server 2012 environment.
• Deploying and managing applications natively, virtually and in the cloud.
• Administering Internet Information Services (IIS).
• Configuring Active Directory for use in authentication, authorization and as a user store.
• Managing an application remotely using Windows PowerShell 2.0.
• Connecting applications to Microsoft SQL Server.
• Implementing Claims-based Security.

For more information, contact one of our course advisors

About This Course

In this course, students learn core skills that are common to almost all SharePoint development activities. These include working with the server-side and client-side object models, developing and deploying features, solutions, and apps, managing identity and permissions, querying and updating list data, managing taxonomy, using workflow to manage business processes, and customizing the user interface.

Audience Profile

The course is intended for professional developers who develop solutions for SharePoint products and technologies in a team-based, medium-sized to large development environment. While some familiarity with SharePoint solution development is required, candidates are not expected to have prior experience with the new features in SharePoint Server 2013.

The ideal candidate is a technical lead with at least four years of SharePoint and web development experience. The candidate is responsible for designing custom code for projects that are deployed to or interact with SharePoint environments. This includes:

• Selecting an appropriate approach and building customisations in SharePoint.
• Creating and implementing a strategy for solution packaging, deployment, and upgrading.
• Identifying SharePoint data and content structures for customizations.
• Performing diagnostics and debugging.
• Planning and designing applications for scalability and performance.
• Identifying and mitigating performance issues of customizations.
• Understanding authentication and authorization.
• Experience with Windows PowerShell.
• Broad familiarity with SharePoint capabilities.
• Familiarity with Online Services such as Azure and SharePoint Online.

At Course Completion

After completing this course, students will be able to:

• Design and manage features and solutions.
• Develop code for custom server-side components.
• Manage and customise authentication and authorisation.
• Create custom sites and lists and manag the site lifecycle.
• Explain the capabilities and design choices for SharePoint apps.
• Use the client-side object model and the REST API.
• Develop provider-hosted and auto-hosted SharePoint apps.
• Distribute and deploy SharePoint apps.
• Create custom workflows to automate business processes.
• Use fields and content types to manage taxonomy.
• Customise the appearance and behaviour of user interface elements.
• Customise navigaton and site branding.

Prerequisites

An ideal candidate will have at least one year of experience with deploying and administering multiple SharePoint 2010 farms across a large enterprise. Because many customers skipped upgrading from SharePoint 2007, a candidate can also have at least 2 years of experience with SharePoint 2007 and knowledge of the differences between 2007 and 2010, particularly the Service Application model. A candidate can demonstrate the following skills:

• Software management in a Windows 2008 R2 enterprise server or Windows Server 2012 environment.
• Deploying and managing applications natively, virtually and in the cloud.
• Administering Internet Information Services (IIS).
• Configuring Active Directory for use in authentication, authorization and as a user store.
• Managing an application remotely using Windows PowerShell 2.0.
• Connecting applications to Microsoft SQL Server.
• Implementing Claims-based Security.

For more information, contact one of our course advisors

About This Course

This course examines how to plan, configure, and manage a Microsoft SharePoint Server 2013 environment. Special areas of focus include implementing high availability, disaster recovery, service application architecture, Business Connectivity Services, social computing features, productivity and collaboration platforms and features, business intelligence solutions, enterprise content management, web content management infrastructure, solutions, and apps. The course also examines how to optimize the Search experience, how to develop and implement a governance plan. and how to perform an upgrade or migration to SharePoint Server 2013.

Audience Profile

The course track is targeted at experienced IT Professionals interested in learning how to install, configure, deploy and manage SharePoint Server 2013 installations in either the data center or cloud.
In addition, Business Application Administrators (BAAs) who are engaged in the administering line-of-business (LOB) projects in conjunction with internal business customers would benefit from understanding
of managing SharePoint Server 2013.

The training addresses three audiences:

• Existing SharePoint 2010 customers and partners who need to understand the major changes in SharePoint 2013. In addition there have been other improvements in tools and methodologies.
• Customer who are new to SharePoint. SharePoint market size is growing significantly and is expected to continue to grow, so there are many new customers with no previous experience.
• Customers running a previous version of SharePoint (SharePoint 2003 and SharePoint 2007) which did not upgrade to SharePoint 2010, so are not familiar with the architecture of SharePoint 2010 or SharePoint Server 2013.

At Course Completion

After completing this course, students will be able to:

• Describe the core features of SharePoint 2013.
• Plan and design a SharePoint 2013 environment to meet requirements for high availability and disaster recovery.
• Plan and implement a service application architecture for a SharePoint 2013 deployment.
• Configure and manage Business Connectivity Services features in a SharePoint 2013 deployment.
• Plan and configure social computing features.
• Plan and configure productivity and collaboration platforms and features.
• Plan and configure Business Intelligence solutions.
• Optimize the search experience for an enterprise environment.
• Plan and configure enterprise content management in a SharePoint 2013 deployment.
• Plan and configure a web content management infrastructure to meet business requirements.
• Manage solutions in a SharePoint 2013 deployment.
• Configure and manage apps in a SharePoint Server 2013 environment.
• Develop and implement a governance plan for SharePoint Server 2013.
• Perform an upgrade or migration to SharePoint Server 2013.

Prerequisites

An ideal candidate will have at least one year of experience with deploying and administering multiple SharePoint 2010 farms across a large enterprise. Because many customers skipped upgrading from SharePoint 2007, a candidate can also have at least 2 years of experience with SharePoint 2007 and knowledge of the differences between 2007 and 2010, particularly the Service Application model. A candidate can demonstrate the following skills:

• Study of the Core Solutions of Microsoft SharePoint Server 2013.
• Software management in a Windows 2008 R2 enterprise server or Windows Server 2012 environment.
• Deploying and managing applications natively, virtually and in the cloud.
• Administering Internet Information Services (IIS).
• Configuring Active Directory for use in authentication, authorization and as a user store.
• Managing an application remotely using Windows PowerShell 2.0.
• Connecting applications to Microsoft SQL Server.
• Implementing Claims-based Security.

For more information, contact one of our course advisors

About This Course

This course provides students with the knowledge and skills analyze data with Power BI.

The MOC On-Demand courses are available for 90 days and students need to use Office 365 to complete the lab work. Students can utilize the trial for Office 365 which lasts for 30 days from when the trial is activated. It is recommended that students using the trial of Office 365 plan their lab work accordingly. The labs provide instructions on how to register for this account.

Audience Profile

The primary audience for this course is BI professionals who need to analyze data utilizing Power BI.

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

At Course Completion

After completing this course, students will be able to:

• Describe key features of a self-service BI solution
• Describe Power BI and its data sources
• Model, shape, and combine data
• Describe Power BI data visualizations

Prerequisites

This course requires that you meet the following prerequisites:

• Basic knowledge of the Microsoft Windows operating system and its core functionality.
• Basic knowledge of data warehouse schema topology (including star and snowflake schemas).
• Some exposure to basic programming concepts (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.

For more information, contact one of our course advisors

About This Course

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.

Audience Profile

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

At Course Completion

After completing this course, students will be able to:

• 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

For more information, contact one of our course advisors

About This Course

This three-day instructor-led 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.

Audience Profile

The primary audience for this course is database professionals who need to fulfil a BI developer role to create reports. Primary responsibilities will include implementing reports and mobile reports.

The secondary audiences for this course are power information workers.

At Course Completion

After completing this course, students will be able to:

• 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

Prerequisites

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

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

For more information, contact one of our course advisors

About This Course

This course teaches IT professionals how 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, maintain, and troubleshoot issues in the infrastructure. This course focuses primarily on the on-premises deployment of Skype for Business, but does include information on how to integrate the on-premises deployment with Skype for Business Online as well as how to migrate from previous versions of Lync Server. This course helps the student prepare for Exam 70-334.

Audience Profile

This course is intended for IT professionals who are responsible for the Skype for Business 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, data networks, and telecommunications
standards and components that support the configuration of Skype for Business. Students should also be familiar with Exchange Server and Office 365.

Also, IT professionals who are looking to take the exam 70-334A: Core Solutions of Skype for Business 2015, as a stand-alone, or as part of the requirement for the
MCSE: Communications certification will take this course as preparation material.

At Course Completion

After completing this course, students will be able to:

• Describe the architecture of Skype for Business 2015 and design a Skype for Business 2015 topology.
• Install and implement Skype for Business Server 2015.
• Administer and manage Skype for Business Server 2015 by using the various available tools.
• Design and implement clients and users in Skype for Business 2015.
• Implement conferencing in Skype for Business 2015.
• Design and implement additional conferencing options.
• Design and implement monitoring and archiving in Skype for Business 2015.
• Design and implement Persistent Chat in Skype for Business 2015.
• Design and implement high availability in Skype for Business 2015.
• Design and implement disaster recovery scenarios for Skype for Business 2015.
• Design and deploy Skype for Business hybrid.
• Design and implement an upgrade from Lync to Skype for Business 2015.

For more information, contact one of our course advisors

About This Course

This course will provide you with the knowledge and skills to plan, deploy, manage, secure, and support Microsoft Exchange Server 2013. This course will teach you how to configure Exchange Server 2013 and supply you with the information you will need to monitor, maintain, and troubleshoot Exchange Server 2013. This course will also provide guidelines, best practices, and considerations that will help you optimize performance and minimize errors and security threats in Exchange Server 2013.

Audience Profile

This course is intended for people aspiring to be enterprise-level messaging administrators. Others who may take this course include IT generalists and help desk professionals who want to learn about Exchange Server 2013. People coming into the course are expected to have at least 3 years of experience working in the IT field—typically in the areas of network administration, help desk, or system administration. They are not expected to have experience with previous Exchange Server versions.

The secondary audience for this course will be candidates that are IT professionals who are looking to take the exam 70-341: Core Solutions of Microsoft Exchange Server 2013 as a standalone, or as part of the requirement for the Microsoft Certified Solutions Expert (MCSE) certification.

At Course Completion

After completing this course, students will be able to:

• Deploy and manage Exchange Server 2013.
• Plan and configure the Mailbox server role.
• Manage recipient objects, address policies, and address lists in Exchange Server 2013.
• Plan and implement the Client Access server role in Exchange Server 2013.
• Securely plan and configure Microsoft Outlook Web App and mobile messaging using the Client Access server.
• Understand and manage highly available Client Access servers in Exchange Sever 2013.
• Plan for disaster mitigation, implement back up and recovery for Exchange Server 2013.
• Plan and configure message transport in an Exchange Server 2013 organization.
• Plan message security options, implement an antivirus solutions, and implement an anti-spam solution.
• Configure permissions and secure Exchange Server 2013.
• Monitor, maintain, and troubleshoot an Exchange Server 2013 environment.

Prerequisites

Before attending this course, students must have:

• Minimum of two years of experience administering Windows Server, including Windows Server 2008 R2 or Windows Server 2012.
• Minimum of two years of experience working with Active Directory Domain Services (AD DS).
• Minimum of two years of experience working with name resolution, including DNS.
• Experience working with certificates, including PKI certificates.

For more information, contact one of our course advisors

About This Course

This course will provide you with the knowledge and skills to configure and manage a Microsoft Exchange Server 2013 messaging environment. This course will teach you how to configure Exchange Server 2013, and it will provide guidelines, best practices, and considerations that will help you optimize your Exchange Server deployment.

Audience Profile

This course is intended for people aspiring to be enterprise-level messaging administrators. Others who may take this course include IT generalists and help desk professionals who want to learn about Exchange Server 2013. People coming into the course are expected to have at least 3 years of experience working in the IT field—typically in the areas of network administration, help desk, or system administration. Students are expected to have experience with Exchange Server 2013 or with previous versions of Exchange Server.

In addition, this course is intended as preparation material for IT professionals who are looking to take the exam 70-342A: Microsoft Exchange Server 2013, Advanced Solutions, as a stand-alone, or as part of the requirement for the MCSE: Microsoft Exchange Server 2013 certification.

At Course Completion

After completing this course, students will be able to:

• Design and implement Exchange Server 2013 Unified Messaging.
• Design and implement site resiliency for Exchange Server 2013.
• Plan a virtualization strategy for Exchange Server 2013 roles.
• Design and implement message transport security.
• Design and implement message retention in Exchange Server 2013.
• Design and implement messaging compliance.
• Design and implement administrative security in an Exchange Server 2013 environment.
• Use the Windows PowerShell 3.0 command-line interface to manage Exchange Server 2013.
• Design and implement integration with Exchange Online.
• Design and implement messaging coexistence.
• Design and implement Exchange Server migrations from non-Exchange messaging systems, and upgrades from previous Exchange Server versions.

Prerequisites

Before attending this course, students must have:

• Study of the Core Solutions of Microsoft Exchange Server 2013
• Minimum of two years of experience administering Windows Server, including Windows Server 2008 R2 or Windows Server 2012.
• Minimum of two years of experience working with Active Directory Domain Services (AD DS).
• Minimum of two years of experience working with name resolution, including DNS.
• Experience working with certificates, including PKI certificates.

For more information, contact one of our course advisors

About This Course

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.

Audience Profile

This course is primarily intended for 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.

The secondary audience for this course includes 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.

At Course Completion

After completing this course, students will be able to:

• Perform deployment and basic management of Exchange Server 2016.
• Manage Exchange Server 2016.
• Create and manage various recipient objects in Exchange Server 2016.
• Use the Exchange Management Shell to create and manager 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.
• Implement and manage Exchange Online deployments.
• Monitor and troubleshoot Exchange Server 2016.
• Secure and maintain Exchange Server 2016.

Prerequisites

Before attending this course, students must have:

• Study of the Core Solutions of Microsoft Exchange Server 2013
• Minimum of two years of experience administering Windows Server, including Windows Server 2008 R2 or Windows Server 2012.
• Minimum of two years of experience working with Active Directory Domain Services (AD DS).
• Minimum of two years of experience working with name resolution, including DNS.
• Experience working with certificates, including PKI certificates.

For more information, contact one of our course advisors

About This Course

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.

Audience Profile

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.

This course is also intended as preparation material for IT professionals who are looking to take the 70-345: Designing and Deploying Microsoft Exchange Server 2016 exam as part of the requirement for the MCSE: Microsoft Exchange Server 2016 certification.

At Course Completion

After completing this course, students will be able to:

• 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.

Prerequisites

Before attending this course, students must have:

• 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.

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

• 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.

For more information, contact one of our course advisors

About This Course

In this demo course, you will learn how to use the Microsoft Official Course On-Demand (MOC On-Demand) player, understand the various content components the course contains and experience one module of the course Installing and Configuring Windows 10. The course is divided into two parts. In the first part, you will learn about the overall course structure, understand the various content components, learn to navigate through the course and learn to access Microsoft Labs Online. In the second part, you can access real content from the first module of the course Installing and Configuring Windows 10. This means you can watch videos, take assessments and try out Module 1 labs to get a real sense of how you will experience a Microsoft Official Course On-Demand. Please note that your lab access is limited to a total of 30 minutes, so make the most of your lab session. We hope this demo course provides you with everything you want to know before you make a decision to buy Microsoft Official Course On-Demand.

For more information, contact one of our course advisors

For more information, contact one of our course advisors

About This Course

In this demo course you will learn how to use the Microsoft Official Course On-Demand (MOC On-Demand) player and understand the various content components that make up a course. You will start by learning about the overall course structure and understand the various content components. Next, you will learn to navigate through the course and access various hands-on components. Microsoft Labs Online are a key feature of a MOC On-Demand course. You will learn about the
ways to make the most out of your lab experience. Finally, you will learn about assessments and will take a look at how to access the Support section from within a course.

Audience Profile

Anyone who is interested in taking a MOC On-Demand course for the first time. You could be a Developer, IT Professional, or working at a Learning Partner.

For more information, contact one of our course advisors