Course OD10990B:Analyzing Data with SQL Server Reporting Services

In development
Publication date: 16 February 2017

Choose how you want to learn: online or in a classroom

Compare learning environments  

Classroom training
Learn more

Find a Microsoft Learning Partner   Find a classroom training partner
Anytime access   No
Anywhere access to recorded instructor   No
Microsoft official training content   Yes
In-depth training   Yes
Hands-on labs   Yes
SATV redemption   Yes
Ask instructor questions in person   Yes
Attend live class in person   Yes
Attend live class remotely   Yes
Time commitment   3 days

About this course

Audience(s): Data Professionals
Technology: Microsoft SQL Server
Level: 300
This Revision: B
Delivery method:
Classroom
Length: 3 days
Language(s): English
Publication date: 16 February 2017

Overview

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
 

Course details

Course Outline

Module 1: Introduction to Business Intelligence and Data Modeling

In this module students will be introduced to the key concepts in business intelligence, and the Microsoft BI product suite.

Lessons

  • Introduction to business intelligence
  • The Microsoft business intelligence platform
  • Introduction to reporting services

Lab : Exploring an enterprise BI solution

After completing this module, you will be able to:
• Describe key concepts in business intelligence
• Describe the Microsoft BI platform
• Describe key concepts in reporting services

Module 2: Reporting Services Data

Describe various Report Services data sources and how these are configured.

Lessons

  • Data sources
  • Connection strings
  • Datasets
  • Filters and parameters

Lab : Configuring a data connection

After completing this module, you will be able to:
• Describe data connections and connection strings
• Describe filters and parameters

Module 3: Implementing reports

Create reports with report designer or report builder.

Lessons

  • Creating a report with the report wizard
  • Creating a report
  • Showing data graphically in a report

Lab : Creating a report

After completing this module, you will be able to:
• Create a report using the report wizard
• Show data graphically

Module 4: Configuring reports

This module describes how to configure reports with report builder or report designer.

Lessons

  • Implementing filters and parameters
  • Implementing sorting and grouping
  • Publishing a report

Lab : Create and Publish reports that include parameters

After completing this module, you will be able to:
• Implement filters and parameters
• Implement sorting and grouping
• Publish a report

Module 5: Creating Mobile Reports

This module describes how to create SQL Server mobile reports.

Lessons

  • Overview of SQL Server mobile reports
  • Preparing data for mobile reports
  • SQL Server Mobile report publisher

Lab : Working with mobile reports

After completing this module, you will be able to:
• Describe SQL Server mobile reports
• Prepare data for mobile reports
• Publish 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

Course OD20762A:Developing SQL Databases

Choose how you want to learn: online or in a classroom

Compare learning environments    

Classroom training

Learn more

Find a Microsoft Learning Partner     Find a classroom training partner
Anytime access     No
Anywhere access to recorded instructor     No
Microsoft official training content     Yes
In-depth training     Yes
Hands-on labs     Yes
SATV redemption     Yes
Ask instructor questions in person     Yes
Attend live class in person     Yes
Attend live class remotely     Yes
Time commitment     5 days

About this course

Audience(s): IT Professionals
Technology: Microsoft SQL Server
Level: 300
This Revision: A
Delivery method:
Classroom
Length: 2 days
Language(s): English
First published: 18 August 2016

Overview

About this course

This four-day instructor-led 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 Optimized and Columnstore indexes
  • Design and Implement Views.
  • Design and Implement Stored Procedures.
  • Design and Implement User Defined Functions.
  • Respond to data manipulation using triggers.
  • Design and Implement In-Memory Tables.
  • Implement Managed Code in SQL Server.
  • Store and Query XML Data.
  • Work with Spatial Data.
  • Store and Query Blobs and Text Documents.

Course details

Course Outline

Module 1: Introduction to Database DevelopmentThis module is used to introduce the entire SQL Server platform and its major tools. It will cover editions, versions, basics of network listeners, and concepts of services and service accounts.

Lessons

  • Introduction to the SQL Server Platform
  • SQL Server Database Development Tasks

Lab : SQL Server Database Development Tasks

After completing this module, you will be able to:

  • Describe the SQL Server platform.
  • Use SQL Server administration tools.

Module 2: Designing and Implementing TablesThis modules describes the design and implementation of tables. (Note: partitioned tables are not covered).

Lessons

  • Designing Tables
  • Data Types
  • Working with Schemas
  • Creating and Altering Tables

Lab : Designing and Implementing Tables

After completing this module, you will be able to:

  • Design Tables
  • Describe the various types of data
  • Be able to work with schemas
  • Be able to create and amend tables

Module 3: Advanced Table DesignsThis module describes more advanced table designs.

Lessons

  • Partitioning data
  • Compressing Data
  • Temporal Tables

Lab : Using Advanced Table Designs

After completing this module, you will be able to:

  • Describe how data can be partitioned
  • Describe how data can be compressed.
  • Describe Temporal tables

Module 4: Ensuring Data Integrity through ConstraintsThis module describes the design and implementation of constraints.

Lessons

  • Enforcing data Integrity
  • Implementing Domain Integrity
  • Implementing Entity and Referential Integrity

Lab : Ensuring Data Integrity through Constraints

After completing this module, you will be able to:

  • Describe how to enforce data integrity
  • Describe how to implement domain integrity
  • Describe how to implement entity and referential integrity

Module 5: Introduction to IndexesThis module describes the concept of an index and discusses selectivity, density and statistics. It covers appropriate data type choices and choices around composite index structures.

Lessons

  • Core Indexing Concepts
  • Data Types and Indexes
  • Single Column and Composite Indexes

Lab : Implementing Indexes

After completing this module, you will be able to:

  • Explain the need for indexes and describe the core concepts of index design
  • Choose appropriate data types for indexes
  • Design single column and composite indexes

Module 6: Designing Optimized Index StrategiesThis module includes covering indexes and the INCLUDE clause, hints, padding / fillfactor, statistics. It also execution plans and the DTE Lessons.

Lessons

  • Covering Indexes
  • Managing Indexes
  • Execution Plans
  • Using the DTE

Lab : Designing Optimized Index Strategies

After completing this module, you will be able to:

  • Choose an appropriate table structure
  • Implement clustered indexes and heaps

Module 7: Columnstore IndexesThis module introduces Columnstore indexes.

Lessons

  • Introduction to Columnstore indexes
  • Creating Columnstore indexes
  • Working Columnstore indexes

Lab : Using Columnstore indexes

After completing this module, you will be able to:

  • Describe suitable scenarios for Columnstore indexes
  • Create clustered and non-clustered Columnstore indexes
  • Describe considerations for updating non-clustered Columnstore indexed tables
  •  

Module 8: Designing and Implementing ViewsThis module describes the design and implementation of views.

Lessons

  • Introduction to views
  • Creating and managing views
  • Performance considerations for views

Lab : Designing and Implementing Views

After completing this module, you will be able to:

  • Explain the concept of views
  • Design, Create and Alter Views
  • Create Partitioned Views

Module 9: Designing and Implementing Stored ProceduresThis module describes the design and implementation of stored procedures.

Lessons

  • Introduction to Stored Procedures
  • Working with Stored Procedures
  • Implementing Parameterized Stored Procedures
  • Controlling Execution Context

Lab : Designing and Implementing Stored Procedures

After completing this module, you will be able to:

  • Design, Create and Alter Stored Procedures
  • Control the Execution Context of Stored Procedures
  • Implement Stored Procedures that use Parameters

Module 10: Designing and Implementing User-Defined FunctionsThis module describes the design and implementation of functions, both scalar and table-valued. (Also discusses where they can lead to performance issues).

Lessons

  • Overview of Functions
  • Designing and Implementing Scalar Functions
  • Designing and Implementing Table-Valued Functions
  • Implementation Considerations for Functions
  • Alternatives to Functions

Lab : Designing and Implementing User-defined Functions

After completing this module, you will be able to:

  • Design, create and alter scalar functions
  • Design, create and alter table-valued functions
  • Describe the performance impacts of functions

Module 11: Responding to Data Manipulation via TriggersThis module describes the design and implementation of triggers.

Lessons

  • Designing DML Triggers
  • Implementing DML Triggers
  • Advanced Trigger Concepts

Lab : Responding to Data Manipulation via Triggers

After completing this module, you will be able to:

  • Design DML triggers
  • Implement DML triggers
  • Work with Nested and Recursive Triggers

Module 12: Using In-Memory TablesThis module covers the creation of in-memory tables and native stored procedures. Furthermore, advantages of in-memory tables are discussed, for example the removal of transaction blocking.

Lessons

  • In-Memory tables
  • Native Stored Procedures

Lab : In Memory OLTP

After completing this module, you will be able to:

  •  Implement in-memory tables
  • Implement native stored procedures

Module 13: Implementing Managed Code in SQL ServerThis module describes the implementation of and target use-cases for SQL CLR integration.

Lessons

  • Introduction to SQL CLR Integration
  • Importing and Configuring Assemblies
  • Implementing SQL CLR Integration

Lab : Implementing Managed Code in SQL Server

After completing this module, you will be able to:

  • Describe SQL CLR Integration
  • Detail appropriate use cases for SQL CLR Integration
  • Implement SQL CLR code

Module 14: Storing and Querying XML Data in SQL ServerThis module covers the XML data type, schema collections, typed and un-typed columns and appropriate use cases for XML in SQL Server.

Lessons

  • Introduction to XML and XML Schemas
  • Storing XML Data and Schemas in SQL Server
  • Implementing the XML Data Type
  • Using the T-SQL FOR XML Statement
  • Getting Started with xQuery

Lab : Storing and Querying XML Data in SQL Server

After completing this module, you will be able to:

  • Explain the purpose and structure of XML and XML schemas
  • Describe how XML data and schemas can be stored in SQL Server
  • Implement the XML data type

Module 15: Working with SQL Server Spatial DataThis module describes spatial data and how this data can be implemented within SQL Server.

Lessons

  • Introduction to Spatial Data
  • Working with SQL Server Spatial Data Types
  • Using Spatial Data in Applications

Lab : Working with SQL Server Spatial Data

After completing this module, you will be able to:

  • Describe how spatial data can be stored in SQL Server
  • Use basic methods of the GEOMETRY and GEOGRAPHY data types
  • Query databases containing spatial data

Module 16: Storing and Querying Blobs and Text Documents in SQL ServerThis module covers full text indexes and queries.

Lessons

  • Considerations for BLOB Data
  • Working with FileStream
  • Using Full-Text Search

Lab : Storing and Querying Blobs and Text Documents in SQL Server

After completing this module, you will be able to:

  • Describe the need for full-text indexing in SQL Server
  • Implement a full-text index
  • Perform basic full-text queries

Prerequisites

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

Course OD10985A:Introduction to SQL Databases

Choose how you want to learn: online or in a classroom

Compare learning environments

 

 

Classroom training

Learn more

Find a Microsoft Learning Partner     Find a classroom training partner
Anytime access     No
Anywhere access to recorded instructor     No
Microsoft official training content     Yes
In-depth training     Yes
Hands-on labs     Yes
SATV redemption     Yes
Ask instructor questions in person     Yes
Attend live class in person     Yes
Attend live class remotely     Yes
Time commitment     3 days

About this course

Audience(s): IT Professionals
Technology: Microsoft SQL Server
Level: 300
This Revision: A
Delivery method:
Classroom
Length: 2 days
Language(s): English
First published: 28 July 2016

Overview

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

About this course

This four-day instructor-led 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 Optimized and Columnstore indexes
  • Design and Implement Views.
  • Design and Implement Stored Procedures.
  • Design and Implement User Defined Functions.
  • Respond to data manipulation using triggers.
  • Design and Implement In-Memory Tables.
  • Implement Managed Code in SQL Server.
  • Store and Query XML Data.
  • Work with Spatial Data.
  • Store and Query Blobs and Text Documents.

Course details

Course Outline

Module 1: Introduction to databasesThis module introduces key database concepts in the context of SQL Server 2016.

Lessons

  • Introduction to relational databases
  • Other types of database
  • Data analysis
  • Database languages

Lab : Querying SQL Server

After completing this module, you will be able to:
• Describe what a database is
• Understand basic relational aspects
• Describe database languages used in SQL Server 2016
• Describe data analytics
• Describe database languages used in SQL Server 2016

Module 2: Data ModellingThis module describes data modelling techniques.

Lessons

  • Data modelling
  • ANSI/SPARC database model
  • Entity relationship modelling

Lab : Entity relationship modellingAfter completing this module, you will be able to:
• Understand the common data modelling techniques
• Describe the ANSI/SPARC database model
• Describe entity relationship modelling

Module 3: NormalizationThis module describes normalization and denormalization techniques.

Lessons

  • Why normalize data?
  • Normalization terms
  • Levels of normalization
  • Denormalization

Lab : Normalizing raw data

After completing this module, you will be able to:
• Describe normalization benefits and notation
• Describe important normalization terms
• Describe the normalization levels
• Describe the role of denormalization

Module 4: RelationshipsThis module describes relationship types and effects in database design.

Lessons

  • Schema mapping
  • Referential integrity

Lab : Designing relationships

After completing this module, you will be able to:
• Describe relationship types
• Describe the use, types, and effects of referential integrity

Module 5: PerformanceThis module introduces the effects of database design on performance.

Lessons

  • Indexing
  • Query performance
  • Concurrency

Lab : Query performance

After completing this module, you will be able to:
• Discuss the performance effects of indexing
• Describe the performance effects of join and search types
• Describe the performance effects of concurrency

Module 6: Database ObjectsThis module introduces commonly used database objects.

Lessons

  • Tables
  • Views
  • Stored procedures
  • Other database objects

Lab : Using SQL Server in a hybrid cloud

After completing this module, you will be able to:
• Describe the use of tables in SQL Server 2016
• Describe the use of views in SQL Server 2016
• Describe the use of stored procedures in SQL Server 2016
• Describe other database objects commonly used in SQL Server 2016

Prerequisites

  • This is a foundation level course and therefore only requires general computer literacy.

Course OD20762A:Developing SQL Databases

Choose how you want to learn: online or in a classroom

Compare learning environments    

Classroom training

Learn more

Find a Microsoft Learning Partner     Find a classroom training partner
Anytime access     No
Anywhere access to recorded instructor     No
Microsoft official training content     Yes
In-depth training     Yes
Hands-on labs     Yes
SATV redemption     Yes
Ask instructor questions in person     Yes
Attend live class in person     Yes
Attend live class remotely     Yes
Time commitment     4 days

About this course

Audience(s): IT Professionals
Technology: Microsoft SQL Server
Level: 300
This Revision: A
Delivery method:
Classroom
Length: 2 days
Language(s): English
First published: 20 October 2016

Overview

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.

Course details

Course Outline

Module 1: SQL Server Architecture, Scheduling, and WaitsThis module covers high level architectural overview of SQL Server and its various components. It dives deep into SQL Server execution model, waits and queues.Lessons

  • SQL Server Components and SQL OS
  • Windows Scheduling vs SQL Scheduling
  • Waits and Queues

Lab : SQL Server Architecture, Scheduling, and Waits

After completing this module, you will be able to:

  • Describe the SQL Server components and SQL OS
  • Describe the differences between Windows Scheduling and SQL scheduling
  • Describe waits and queues

Module 2: SQL Server I/OThis module covers core I/O concepts, Storage Area Networks and performance testing. It focuses on SQL Server I/O operations and how to test storage performance.Lessons

  • Core Concepts
  • Storage Solutions
  • I/O Setup and Testing

Lab : Testing Storage Performance

After completing this module, you will be able to:

  • Describe the core concepts of SQL I/O
  • Describe storage solutions
  • Setup and test I/O

Module 3: Database StructuresThis module covers Database Structures, Data File and TempDB Internals. It focuses on architectural concepts and best practices related to data files for user databases and TempDB.Lessons

  • Database Structure Internals
  • Data File Internals
  • TempDB Internals

Lab : Database Structures

After completing this module, you will be able to:

  • Describe the internal setup of database structures
  • Describe the internal setup of data files.
  • Describe the internal setup of TempDB

Module 4: SQL Server MemoryThis module covers Windows and SQL Server Memory internals. It focuses on architectural concepts and best practices related to SQL Server Memory Configuration.Lessons

  • Windows Memory
  • SQL Server Memory
  • In-Memory OLTP

Lab : SQL Server Memory

After completing this module, you will be able to:

  • Describe the components of Windows memory
  • Describe the components of SQL Server memory
  • Describe In-Memory OLTP

Module 5: Concurrency and TransactionsThis module covers Transactions and Locking Internals. It focuses on architectural concepts and best practices related to Concurrency, Transactions, Isolation Levels and Locking.Lessons

  • Concurrency and Transactions
  • Locking Internals

Lab : Concurrency and Transactions

After completing this module, you will be able to:

  • Explain concurrency and transactions
  • Describe locking

Module 6: Statistics and Index InternalsThis module covers Statistics and Index Internals. It focuses on architectural concepts and best practices related to Statistics and Indexes.Lessons

  • Statistics Internals and Cardinality Estimation
  • Index Internals
  • Columnstore Indexes

Lab : Statistics and index Internals

After completing this module, you will be able to:

  • Describe statistics internals
  • Explain cardinality estimation
  • Describe why you would use Columnstore indexes and be able to implement one

Module 7: Query Execution and Query Plan AnalysisThis module covers Query Execution and Query Plan Analysis. It focuses on architectural concepts of the Optimizer and how to identify and fix query plan issues.Lessons

  • Query execution and optimizer internals
  • Analyzing query plans

Lab : Query execution and query plan analysis

After completing this module, you will be able to:

  • Describe query execution and optimizer
  • Analyze query plans and resolve common issues

Module 8: Plan Caching and RecompilationThis module covers Plan Caching and Recompilation. It focuses on architectural concepts, troubleshooting scenarios and best practices related to Plan Cache.Lessons

  • Plan cache internals
  • Troubleshooting plan cache issues
  • Query store

Lab : Plan caching and recompilation

After completing this module, you will be able to:

  • Describe plan cache
  • Troubleshoot plan cache issues
  • Describe query store and why you would use it

Module 9: Extended EventsThis module covers Extended Events. It focuses on architectural concepts, troubleshooting strategy and usage scenarios for Extended Events.Lessons

  • Extended events core concepts
  • Implementing extended events

Lab : Extended events

After completing this module, you will be able to:

  • Describe the core concepts of extended events
  • Implement extended events

Module 10: Monitoring, Tracing, and BaseliningThis module covers tools and techniques to monitor, trace and baseline SQL Server performance data. It focuses on data collection strategy and techniques to analyze collected data.Lessons

  • Monitoring and tracing
  • Baselining and benchmarking

Lab : Monitoring, Tracing and Baselining

After completing this module, you will be able to:

  • Describe various options for monitoring and tracing
  • Describe various options for benchmarking and baselining

Module 11: Troubleshooting Common Performance IssuesThis module covers common performance bottlenecks related to CPU, Memory, IO, TempDB and Concurrency. It focuses on techniques to identify and diagnose bottlenecks to improve overall performance.Lessons

  • Troubleshoot CPU performance
  • Troubleshoot memory performance
  • Troubleshoot I/O performance
  • Troubleshoot Concurrency performance
  • Troubleshoot TempDB performance

Lab : Troubleshooting common performance issues

After completing this module, you will be able to:

  • Troubleshoot common performance issues

Prerequisites

    • Basic knowledge of the Microsoft Windows operating system and its core functionality.
    • Working knowledge of database administration and maintenance
    • Working knowledge of Transact-SQL.In addition to their professional experience, students who attend this training should already have the following technical knowledge:

Course OD20332B:Advanced Solutions of Microsoft® SharePoint® Server 2013

Choose how you want to learn: online or in a classroom

Compare learning environments

 

 

Classroom training

Learn more

Find a Microsoft Learning Partner     Find a classroom training partner
Anytime access     No
Anywhere access to recorded instructor     No
Microsoft official training content     Yes
In-depth training     Yes
Hands-on labs     No
SATV redemption     Yes
Ask instructor questions in person     Yes
Attend live class in person     Yes
Attend live class remotely     Yes
Time commitment     5 days

About this course

Audience(s): IT Professionals
Technology: Microsoft SharePoint Server
Level: 300
This Revision: B
Delivery method:
Online
Length: 2 days
Language(s): English
First published: 12 May 2016

Overview

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

Course details

Course Outline

Module 1: Understanding the SharePoint Server 2013 Architecture

This module introduces the architectural features that underpin Microsoft SharePoint Server 2013, both for on-premises and online deployments. This includes an examination of the features that are new in this version, as well as those that have been removed. This module reviews the basic structural elements of a farm deployment, and the different deployment options that are available in SharePoint 2013.

Lessons

  • Core Components of the SharePoint 2013 Architecture
  • New Features in SharePoint Server 2013
  • SharePoint Server 2013 and SharePoint Online Editions

Lab : Reviewing Core SharePoint Concepts

After completing this module, students will be able to:
  • Describe the architectural features of SharePoint Server 2013.
  • Identify new and deprecated features in SharePoint 2013.
  • Describe the editions for SharePoint Server 2013 on-premise and SharePoint Online.

Module 2: Designing Business Continuity Management Strategies

This module examines high availability and disaster recovery in SharePoint 2013. When designing high availability and disaster recovery strategies for a SharePoint farm, it is important to understand the different approaches required by each logical tier in the farm. High availability for the database tier requires understanding of how SQL Server provides high availability and the associated requirements. High availability for the application tier can be straightforward for some service applications, while other applications, such as Search, require additional planning and configuration for high availability. The web front end tier will also require additional planning and configuration for high availability, and architects should consider the new SharePoint 2013 request management feature. SharePoint farm disaster recovery has always required considerable planning and understanding of the necessary components and backup tools available. In this regard SharePoint 2013 is no different, and farm administrators should create a disaster recovery plan that states how content and configurations are backed up, how data can be restored, and what backup schedules are required.

Lessons

  • Designing Database Topologies for High Availability and Disaster Recovery
  • Designing SharePoint Infrastructure for High Availability
  • Planning for Disaster Recovery

Lab : Planning and Performing Backups and Restores

After completing this module, students will be able to:
  • Select an appropriate database server configuration to meet availability requirements.
  • Design a physical architecture and infrastructure to meet availability requirements.
  • Develop and implement a backup and restore strategy.

Module 3: Planning and Implementing a Service Application Architecture

Service applications were introduced in SharePoint 2010, replacing the Shared Service Provider architecture of Microsoft Office SharePoint Server 2007. Service applications provide a flexible design for delivering services, such as managed metadata or PerformancePoint, to users who need them. There are several deployment topologies available to you when you plan your service application implementation. These range from a simple, single-farm, single-instance service application model to more complex, cross-farm, multiple-instance designs. What remains most important is that you create a design that matches the needs of your organization's users in terms of performance, functionality, and security.
 
This module reviews the service application architecture, how to map business requirements to design, and the options for enterprise scale, federated service application architectures.

Lessons

  • Planning Service Applications
  • Designing and Configuring a Service Application Topology
  • Configuring Service Application Federation

Lab : Planning a Service Application ArchitectureLab : Federating Service Applications between SharePoint Server Farms

After completing this module, students will be able to:
  • Explain the service application architecture.
  • Describe the fundamental options of service application design.
  • Describe how to configure a federated service application deployment.

Module 4: Configuring and Managing Business Connectivity Services

Most organizations store information in a variety of disparate systems. In many cases, these organizations want to be able to view and interact with information from these disparate systems from a single interface. This reduces the need for information workers to constantly switch between systems and creates opportunities for power users or analysts to aggregate data from multiple sources.
In SharePoint 2013, Business Connectivity Services (BCS) is a collection of technologies that enable you to query, view, and interact with data from external systems. In this module, you will learn how to plan and configure various components of BCS.

Lessons

  • Planning and Configuring Business Connectivity Services
  • Configuring the Secure Store Service
  • Managing Business Data Connectivity Models

Lab : Configuring BCS and the Secure Store ServiceLab : Managing Business Data Connectivity Models

After completing this module, students will be able to:
  • Plan and configure the Business Data Connectivity Service application.
  • Plan and configure the Secure Store Service application.
  • Manage Business Data Connectivity models.

Module 5: Connecting People

Talking about connecting people in Microsoft SharePoint Server 2013 really means talking about taking people out of their isolated workspaces and giving them the ability and tools to collaborate with other people in the organization such as their work colleagues, peers, and executives. It is about finding people with expertise, and identifying shared interests and about creating networks of people that share common goals.   
 
In this module, you will learn about the concepts and ways of connecting people in SharePoint 2013. You will examine user profiles and user profile synchronization, social interaction features and capabilities, and communities and community sites in SharePoint 2013.

Lessons

  • Managing User Profiles
  • Enabling Social Interaction
  • Building Communities

Lab : Configuring Profile Synchronization and My SitesLab : Configuring Community Sites

After completing this module, students will be able to:
  • Understand and manage user profiles and user profile synchronization in SharePoint 2013.
  • Enable social interaction in SharePoint 2013.
  • Understand and build communities and community sites in SharePoint 2013

Module 6: Enabling Productivity and Collaboration

This module examines how SharePoint 2013 extends the ability of users to work collaboratively and increase productivity through seamless integration with external software platforms, additional SharePoint collaboration features, and the provision of flexible tools, with which users can develop their own solutions to business problems.

Lessons

  • Aggregating Tasks
  • Planning and Configuring Collaboration Features
  • Planning and Configuring Composites

Lab : Configuring Project SitesLab : Configuring Workflow

After completing this module, students will be able to:
  • Explain how the integration options for Exchange 2013 and Project Server 2013 improve task aggregation.
  • Describe how to plan and configure SharePoint collaborative and co-authoring options.
  • Describe how to plan and use workflows in SharePoint 2013.

Module 7: Planning and Configuring Business intelligence

Business Intelligence (BI) continues to be an important area for large enterprise organizations. The key to successful BI is the ability to integrate the components that deliver the right information, to the right people, at the right time. Microsoft SharePoint Server 2013 Enterprise Edition provides a range of integrated solutions that enable both users and administrators across an organization to develop BI solutions to fit their business requirements. These BI tools extend beyond SharePoint to provide consistent information management from personal data analysis environments, which use Microsoft Excel, through to departmental or organizational data repositories, which use SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).
 
In this module you will see how SharePoint 2013 can deliver BI solutions for your business.

Lessons

  • Planning for Business Intelligence
  • Planning, Deploying, and Managing Business Intelligence Services
  • Planning and Configuring Advanced Analysis Tools

Lab : Configuring Excel ServicesLab : Configuring PowerPivot and Power View for SharePoint

After completing this module, students will be able to:
  • Explain the SharePoint BI architecture, its components, and how to identify BI opportunities in your organization.
  • Describe how to plan, deploy, and manage the core SharePoint 2013 BI services.
  • Describe the advanced BI options available with SharePoint 2013 and Microsoft SQL Server 2012.

Module 8: Planning and Configuring Enterprise Search

The Search service remains a cornerstone of the SharePoint platform’s success. In Microsoft SharePoint Server 2013 there have been major changes to the components that make up the service, to increase performance and configurability.
 
In this module, you will examine the configuration options in SharePoint Search that enable you to provide greater search result effectiveness by fine-tuning the service in various ways. The introduction of new functionality, such as result types and the increased move towards search-driven navigation mean that the role of the Search administrator has become even more important for business success. Search now enables you to delegate more of this management to site collection administrator and site owner levels, improving Search flexibility without increasing the administrative burden on a few Search service application administrators.
 
This module also examines Search analytics and reporting. To help you in your management of a Search environment, SharePoint 2013 now incorporates Search analytics and reporting into the Search service, rather than in a separate service application, as was the case in SharePoint Server 2010. The reports available will help you to monitor the service and optimize its configuration.

Lessons

  • Configuring Search for an Enterprise Environment
  • Configuring the Search Experience
  • Optimizing Search

Lab : Planning an Enterprise Search DeploymentLab : Managing Search Relevance in SharePoint Server 2013

After completing this module, students will be able to:
  • Describe the Search service architecture and key areas of configuration.
  • Explain how to configure the Search service to improve the end-user experience.
  • Describe how to use analytics reports to optimize your Search environment.

Module 9: Planning and Configuring Enterprise Content Management

This module examines Enterprise Content Management (ECM), which is a set of technologies and features that administrators use to provide some control over sites and content. This could include control over how information is stored, how long information is kept, how information is visible to users while in use, and how information growth is kept under control.
 
Planning support for your ECM requirements requires a clear understanding of content requirements and how that content supports the organization. This means that, as a best practice, many different organizational roles should have input into the ECM strategy and supporting features.

Lessons

  • Planning Content Management
  • Planning and Configuring eDiscovery
  • Planning Records Management

Lab : Configuring eDiscovery in SharePoint Server 2013Lab : Configuring Records Management in SharePoint Server 2013

After completing this module, students will be able to:
  • Plan how to manage content and documents.
  • Plan and configure eDiscovery.
  • Plan records management and compliance.

Module 10: Planning and Configuring Web Content Management

The web content management capabilities in Microsoft SharePoint Server 2013 can help an organization to communicate and integrate more effectively with employees, partners, and customers. SharePoint Server 2013 provides easy-to-use functionality to create, approve, and publish web content. This enables you to get information out quickly to intranet, extranet, and Internet sites and give your content a consistent look and feel. You can use these web content management capabilities to create, publish, manage, and control a large and dynamic collection of content. As part of Enterprise Content Management (ECM) in SharePoint Server 2013, web content management can help to streamline your process for creating and publishing web sites.

Lessons

  • Planning and Implementing a Web Content Management Infrastructure
  • Configuring Managed Navigation and Catalog Sites
  • Supporting Multiple Languages and Locales
  • Enabling Design and Customization
  • Supporting Mobile Users

Lab : Configuring Managed Navigation and Catalog SitesLab : Configuring Device Channels

After completing this module, students will be able to:
  • Plan and configure a Web Content Management infrastructure to meet business requirements.
  • Configure managed navigation and product catalog sites.
  • Plan and configure support for multilingual sites.
  • Manage design and customization for publishing sites.
  • Plan and configure support for mobile users

Module 11: Managing Solutions in SharePoint Server 2013

As a SharePoint administrator, it is important to understand the features that are available in Microsoft SharePoint Server 2013. However, there are often specific functional requirements that may be part of SharePoint’s feature set but are not included in certain site templates. There may also be sites that require repeatable customization of lists or libraries, or custom code deployments that are necessary to add capabilities that are not available out-of-the-box. Developers use features and solutions to add and control these functionality requirements. Administrators, on the other hand, must understand how features and solutions are deployed and managed in order to meet user needs in a SharePoint farm.

Lessons

  • Understanding the SharePoint Solution Architecture
  • Managing Sandbox Solutions

Lab : Managing Solutions

After completing this module, students will be able to:
  • Describe and manage SharePoint features and solutions
  • Manage sandboxed solutions in a SharePoint 2013 deployment

Module 12: Managing Apps for SharePoint Server 2013

SharePoint apps are new to Microsoft SharePoint Server 2013 and provide an additional capability to provide application functionality within the context of SharePoint. SharePoint apps supplement the capabilities of farm solutions and sandbox solutions, while providing a user experience that offers a measure of self-service customization capabilities without putting the stability or security of the farm at risk.

Lessons

  • Understanding the SharePoint App Architecture
  • Provisioning and Managing Apps and App Catalogs

Lab : Configuring and Managing SharePoint Apps

After completing this module, students will be able to:
  • Describe SharePoint apps and the supporting SharePoint infrastructure
  • Provision and configure SharePoint apps and app catalogs
  • Manage how apps are used within a SharePoint 2013 deployment

Module 13: Developing a Governance Plan

Governance as it relates to SharePoint can be described as a way of controlling a SharePoint environment through the application of people, policies, and processes. Governance is necessary for all IT systems as a whole, and in particular for SharePoint deployments, which often introduce significant change in business processes, available functionality, and day-to-day working practices.
 
It is important to understand that governance must reflect the needs of the organization and how it should best use SharePoint. Therefore, the IT department cannot be the only body governing SharePoint; input must come from corporate sponsorship across the organization. The IT department must still act as the technical authority for SharePoint; however, this is just a single part of how SharePoint governance must be brought together from different parts of the organization.

Lessons

  • Introduction to Governance Planning
  • Key Elements of a Governance Plan
  • Planning for Governance in SharePoint 2013
  • Implementing Governance in SharePoint 2013

Lab : Developing a Plan for GovernanceLab : Managing Site Creation and Deletion

After completing this module, students will be able to:
  • Describe the concepts of governance
  • Describe the key elements of a governance plan
  • Plan for governance in SharePoint Server 2013

Module 14: Upgrading and Migrating to SharePoint Server 2013

Upgrading your Microsoft SharePoint Server 2010 farm(s) to SharePoint 2013 is a major undertaking, so it is important that you carefully plan the upgrade activities. You need to ensure that your upgrade path—moving from version to version—is supported, that you have reviewed the business impact of your upgrade, and that you test your upgrade strategy to ensure business continuity. As with all such activities, preparation is crucial.
 
In contrast with earlier version of SharePoint, SharePoint 2013 supports only database-attach upgrades for content, but it now supports upgrades for some of the databases associated with service applications. You need to plan for these and ensure that you are prepared for any troubleshooting that may be required.
 
Another change in SharePoint 2013 is the approach to upgrading site collections. These are upgraded separately from the data and service applications. You can also delegate the upgrade tasks to site collection administrators.

Lessons

  • Preparing the Upgrade or Migration Environment
  • Performing the Upgrade Process
  • Managing a Site Collection Upgrade

Lab : Performing a Database-Attach UpgradeLab : Managing Site Collection Upgrades

After completing this module, students will be able to:
  • Describe how to plan and prepare for your upgrade.
  • Explain the steps involved in data and service application upgrades.
  • Describe the process for upgrading site collections.

Prerequisites

  • Before attending this course, students must have:
    • Completed Course 20331: Core Solutions of Microsoft SharePoint Server 2013, successful completion of Exam 70-331: Core Solutions of Microsoft SharePoint 2013, or equivalent skills.
    • At least one year’s experience of mapping business requirements to logical and physical technical design.
    • Working knowledge of network design, including network security.
    • Experience managing software in a Windows 2008 R2 enterprise server or Windows Server 2012 environment.
    • Deployed and managed applications natively, virtually, and in the cloud.
    • Administered Internet Information Services (IIS).
    • Configured Active Directory for use in authentication, authorization and as a user store.
    • Managed an application remotely using Windows PowerShell 2.0.
    • Connected applications to Microsoft SQL Server.
    • Implemented Claims-based security.

Course OD20331B:Core Solutions of Microsoft® SharePoint® Server 2013

Choose how you want to learn: online or in a classroom

Compare learning environments    

Classroom training

Learn more

Find a Microsoft Learning Partner     Find a classroom training partner
Anytime access     No
Anywhere access to recorded instructor     No
Microsoft official training content     Yes
In-depth training     Yes
Hands-on labs     Yes
SATV redemption     Yes
Ask instructor questions in person     Yes
Attend live class in person     Yes
Attend live class remotely     Yes
Time commitment     5 days

About this course

Audience(s): IT Professionals
Technology: Microsoft SharePoint Server
Level: 300
This Revision: B
Delivery method:
Online
Length: 2 days
Language(s): English
First published: 11 February 2016

Overview

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

Course details

Course Outline

Module 1: Introducing SharePoint Server 2013

Microsoft SharePoint Server 2013 is a document storage and collaboration platform that offers many benefits to organizations. SharePoint deployments may take many different forms in scope, where a deployment may be focused on only delivering one feature, such as enterprise search, or many features, such as document management, business intelligence, web content management, and workflows. Deployments can also differ greatly in size, with small deployments of a single server up to large deployments with farms of 15 or more servers.
 
In this module, you will learn about the core features of SharePoint 2013, the new features in this version, and what has been removed. You will also learn about the basic structural elements of a farm deployment and how they fit together. Finally you will learn about the different deployment options available to SharePoint 2013.

Lessons

  • Key Components of a SharePoint Deployment
  • New Features in SharePoint 2013
  • SharePoint 2013 Deployment Options
After completing this module, you will be able to:
  • Identify the capabilities and architecture of SharePoint 2013.
  • Identify new and deprecated features in SharePoint 2013.
  • Identify deployment options for SharePoint 2013.

Module 2: Designing an Information Architecture

Information architecture (IA) defines the structures by which an organization catalogs information. Designing an IA requires a detailed understanding of the information held in an organization and its usage, context, volatility, and governance. A good IA rationalizes the creation and storage of content and streamlines its surfacing and use.
 
IA design should be platform-neutral, but it must also be driven by the functionality of its environment. Microsoft SharePoint Server 2013 provides a rich and functional platform for the development and implementation of efficient and effective IA structures. The integral use of metadata throughout SharePoint 2013 means that an IA designer has a range of storage, navigation, and retrieval options to maximize usability in a well-structured IA.
 
In this module, you will learn about the core elements of IA design and the facilities and devices available in SharePoint 2013 to deploy an effective information management solution.

Lessons

  • Identifying Business Requirements
  • Understanding Business Requirements
  • Organizing Information in SharePoint 2013
  • Planning for Discoverability

Lab : Creating an Information Architecture - Part OneLab : Creating an Information Architecture - Part Two

After completing this module, you will be able to:
  • Explain how understanding business requirements drives the design of an organizational IA.
  • Describe the key components available in SharePoint 2013 to deploy an IA.
  • Plan for discoverability as part of an IA deployment.

Module 3: Designing a Logical Architecture

This module reviews the logical constructs of Microsoft SharePoint Server 2013 and SharePoint Online. It discusses the importance of creating a logical architecture design based on business requirements before you implement a solution. The module covers conceptual content, defining a logical architecture, and the components of Microsoft SharePoint Server 2013 that you must map to business specifications.

Lessons

  • Overview of SharePoint 2013 Logical Architecture
  • Documenting Your Logical Architecture

Lab : Designing a Logical Architecture

After completing this module, you will be able to:
  • Map business requirements to SharePoint 2013 architecture components.
  • Explain the importance of documentation and describe the options for documenting logical architecture.

Module 4: Designing a Physical Architecture

When you design a Microsoft SharePoint Server 2013 deployment, you must carefully consider the hardware and farm topology requirements. Your choices of server hardware and the number of servers that you specify for the farm can have a significant impact on how the farm meets user requirements, how users perceive the SharePoint solution, and how long before the farm requires additional hardware.
 
This module describes the factors that you should consider when you design the physical architecture of a SharePoint 2013 deployment. The physical architecture refers to the server design, farm topology, and supporting elements—such as network infrastructure—for your deployment. This physical architecture underpins the operations of your SharePoint 2013 environment, so it is essential that your physical design fully meets the operational requirements.

Lessons

  • Designing Physical Components for SharePoint Deployments
  • Designing Supporting Components for SharePoint Deployments
  • SharePoint Farm Topologies
  • Mapping a Logical Architecture Design to a Physical Architecture Design

Lab : Designing a Physical Architecture

After completing this module, you will be able to:
  • Describe the physical design requirements for SharePoint 2013.
  • Describe the supporting requirements for a successful SharePoint 2013 physical design.
  • Identify SharePoint farm topologies.
  • Map a logical architecture design to a physical architecture design.

Module 5: Installing and Configuring SharePoint Server 2013

After you design and plan your logical and physical architectures for a Microsoft SharePoint Server 2013 deployment, the next installation steps are to implement the deployment design and specify configuration settings for the deployment.
 
In this module, you will learn about installing SharePoint 2013 in various topologies. You will learn how to configure farm settings, and how to script the installation and configuration of SharePoint 2013.

Lessons

  • Installing SharePoint Server 2013
  • Scripting Installation and Configuration
  • Configuring SharePoint Server 2013 Farm Settings

Lab : Deploying and Configuring SharePoint Server 2013 - Part OneLab : Configuring SharePoint Server 2013 Farm Settings

After completing this module, you will be able to:
  • Install SharePoint 2013.
  • Configure SharePoint 2013 farm settings.
  • Script the installation and configuration of SharePoint 2013.

Module 6: Creating Web Applications and Site Collections

After installing your Microsoft SharePoint Server 2013 farm, you are ready to begin deploying sites and content, such as an organizational intranet site.
 
In this module, you will learn about the key concepts and skills related to the logical architecture of SharePoint including web applications, site collections, sites, and content databases. Specifically, you will learn how to create and configure web applications and to create and configure site collections.

Lessons

  • Creating Web Applications
  • Configuring Web Applications
  • Creating and Configuring Site Collections

Lab : Creating and Configuring Web ApplicationsLab : Creating and Configuring Site Collections

After completing this module you will be able to perform the following tasks in SharePoint 2013:
  • Create web applications.
  • Configure web applications.
  • Create site collections.
  • Configure site collections.

Module 7: Planning and Configuring Service Applications

Service applications were introduced in Microsoft SharePoint Server 2010, replacing the Shared Service Provider architecture of Microsoft Office SharePoint Server 2007. Service applications provide a flexible design for delivering services, such as Managed Metadata or PerformancePoint, to users who need them. Microsoft SharePoint Server 2013 includes more than 20 services, some of which are new to this version, whereas others are enhanced. In planning and configuring service applications, it is important that you understand the dependencies, resource usage, and business requirements for each.
 
This module reviews the basic service application architecture, the essentials of planning your service application deployment, and the configuration of your service applications. This module does not discuss sharing, or federation, of service applications. This is covered in more detail in course 20332B: Advanced Solutions of Microsoft SharePoint Server 2013.

Lessons

  • Introduction to Service Application Architecture
  • Creating and Configuring Service Applications

Lab : Planning and Configuring Service Applications

After completing this module, you will be able to:
  • Explain the key components and topologies for SharePoint Server 2013 service application architecture.
  • Describe how to provision and manage SharePoint 2013 service applications.

Module 8: Managing Users and Permissions

Many organizations need to store sensitive or confidential information. Microsoft SharePoint Server 2013 includes a complete set of security features, which you can use to help ensure that users with the appropriate rights and permissions can access the information they need, can modify the data they are responsible for, but that they cannot view or modify confidential information, or information that is not intended for them. The SharePoint 2013 security model is highly flexible and adaptable to your organization’s needs.
 
In this module, you will learn about the various authorization and security features available in SharePoint 2013 to help you maintain a secure SharePoint environment. Specifically, you will be learning about authorization and permissions in SharePoint 2013, and how to manage access to content in SharePoint 2013.

Lessons

  • Authorization in SharePoint 2013
  • Managing Access to Content

Lab : Managing Users and GroupsLab : Securing Content in SharePoint Sites

After completing this module, you will be able to:
  • Understand and manage authorization and permissions in SharePoint 2013.
  • Manage access to content in SharePoint 2013.

Module 9: Configuring Authentication for SharePoint 2013

Authentication is the process by which you establish the identity of users and computers. Authorization controls access to resources by assigning permissions to users and computers. To provide authorization to consumers of Microsoft SharePoint content and services, whether they are end users, server platforms, or SharePoint apps, you first need to verify that they are who they claim to be. Together, authentication and authorization play a central role in the security of a SharePoint 2013 deployment by ensuring that consumers can only access resources to which you have explicitly granted them access.
 
In this module, you will learn about the authentication infrastructure in SharePoint 2013. You will learn how to configure SharePoint to work with a variety of authentication providers, and you will learn how to configure authenticated connections between SharePoint and other server platforms.

Lessons

  • Overview of Authentication
  • Configuring Federated Authentication
  • Configuring Server-to-Server Authentication

Lab : Configuring SharePoint 2013 to Use Federated Identities

After completing this module, you will be able to:
  • Explain the authentication infrastructure of SharePoint 2013.
  • Configure claims providers and identity federation for SharePoint 2013.
  • Configure server-to-server authentication for SharePoint 2013.

Module 10: Securing a SharePoint 2013 Deployment

Microsoft SharePoint Server 2013 is not just a group of websites―it is also a site-provisioning engine for intranets, extranets, and Internet sites, a collection of databases, an application platform, and a platform for collaboration and social features, as well as being many other things. In addition to it touching your network, it also touches your line-of-business (LOB) applications and Microsoft Active Directory; therefore, it has a large attack surface to consider and protect. SharePoint 2013 is supplied with several security features and tools out-of-the-box to help you secure it.
 
In this module, you will learn how to secure and harden your SharePoint 2013 farm deployment and how to configure several security settings at the farm level.

Lessons

  • Securing the Platform
  • Configuring Farm-Level Security

Lab : Hardening a SharePoint 2013 Server FarmLab : Configuring Farm-Level Security

After completing this module you will be able to:
  • Secure the SharePoint 2013 platform.
  • Configure farm-level security in SharePoint 2013.

Module 11: Managing Taxonomy

In order to organize information and make that information easier to find and work with, you can label or categorize information. With files and items in Microsoft SharePoint, you can apply metadata, which could be a category, a classification, or a tag, in order to organize your content and make it easier to work with.
 
In most organizations, the most effective way to implement metadata is through a defined taxonomy that you have standardized through stakeholder input. This enables users to select metadata terms from a predefined list, which provides standard results.
 
Microsoft SharePoint Server 2013 can further enhance the application of metadata by using content types. Organizations can use content types to standardize specific types of files, documents, or list items and include metadata requirements, document templates, retention settings, and workflow directly.

Lessons

  • Managing Content Types
  • Understanding Term Stores and Term Sets
  • Managing Term Stores and Term Sets

Lab : Configuring Content Type PropagationLab : Configuring and Using Managed Metadata Term Sets

After completing this module, you will be able to:
  • Describe the function of content types and explain how to apply them to business requirements.
  • Describe the function of managed metadata in SharePoint 2013.
  • Configure the Managed Metadata Service and supporting components.

Module 12: Configuring User Profiles

Social computing environments enable organizations to quickly identify colleagues, team members, and others with similar roles or requirements in an organization. Social features in Microsoft SharePoint Server 2013 enable users to quickly gain updates and insight into how other members of the organization are working and what information or processes people are developing, along with the progress being achieved.
 
The SharePoint 2013 social platform is based around the capabilities provided by the user profile service application, supported by other services, such as the Managed Metadata Service and the Search service. The User Profile Service provides configuration and control over importing profile data, creating My Sites, managing audiences, and users can utilize these features.

Lessons

  • Configuring the User Profile Service Application
  • Managing User Profiles and Audiences

Lab : Configuring User ProfilesLab : Configuring My Sites and Audiences

After completing this module, you will be able to:
  • Plan for and configure user profile synchronization with Active Directory Domain Services.
  • Plan for and configure My Sites and audiences.

Module 13: Configuring Enterprise Search

Search has been a cornerstone of Microsoft SharePoint Products and Technologies since SharePoint Portal Server 2003. Since those early days, the architecture of the search service has evolved through the Shared Service Provider architecture to the service application architecture of SharePoint Server 2010. It has also grown with the addition of FAST technologies. SharePoint Server 2013 continues this growth by re-architecting the service and integrating many of the components that were intrinsic to FAST Search to deliver a more robust and richer experience for IT staff and users.
 
In this module, you will learn about the new architecture of the Search service, how to configure the key components of search, and how to manage search functionality in your organization.

Lessons

  • Understanding the Search Service Architecture
  • Configuring Enterprise Search
  • Managing Enterprise Search

Lab : Configuring Enterprise SearchLab : Configuring the Search Experience

After completing this module, you will be able to:
  • Describe the core architecture of the Search service and its supported topologies.
  • Explain the steps required to configure the Search service in an enterprise environment.
  • Describe how to manage and maintain a well-performing Search environment.

Module 14: Monitoring and Maintaining a SharePoint 2013 Environment

Careful planning and configuration alone will not guarantee an effective Microsoft SharePoint Server 2013 deployment. To keep your SharePoint 2013 deployment performing well, you need to plan and conduct ongoing monitoring, maintenance, optimization, and troubleshooting.
 
In this module, you will learn how to plan and configure monitoring in a SharePoint 2013 server farm, and how to tune and optimize the performance of your farm on an ongoing basis. You will also learn how to use a range of tools and techniques to troubleshoot unexpected problems in your SharePoint 2013 deployments.

Lessons

  • Monitoring a SharePoint 2013 Environment
  • Tuning and Optimizing a SharePoint Environment
  • Planning and Configuring Caching
  • Troubleshooting a SharePoint 2013 Environment

Lab : Monitoring a SharePoint 2013 DeploymentLab : Investigating Page Load Times

After completing this module, you will be able to:
  • Develop and implement a monitoring plan for a SharePoint 2013 environment.
  • Tune and optimize a SharePoint 2013 server farm on an ongoing basis.
  • Plan and configure caching to improve the performance of a SharePoint 2013 deployment.
  • Troubleshoot errors and other issues in a SharePoint 2013 deployment.
  • Before attending this course, students must have:
    • Completed Course 20331: Core Solutions of Microsoft SharePoint Server 2013, successful completion of Exam 70-331: Core Solutions of Microsoft SharePoint 2013, or equivalent skills.
    • At least one year’s experience of mapping business requirements to logical and physical technical design.
    • Working knowledge of network design, including network security.
    • Experience managing software in a Windows 2008 R2 enterprise server or Windows Server 2012 environment.
    • Deployed and managed applications natively, virtually, and in the cloud.
    • Administered Internet Information Services (IIS).
    • Configured Active Directory for use in authentication, authorization and as a user store.
    • Managed an application remotely using Windows PowerShell 2.0.
    • Connected applications to Microsoft SQL Server.
    • Implemented Claims-based security.

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.

Course OD20488B:Developing Microsoft SharePoint® Server 2013 Core Solutions

Choose how you want to learn: online or in a classroom

 

Compare learning environments    

Classroom training

Learn more

Find a Microsoft Learning Partner     Find a classroom training partner
Anytime access     No
Anywhere access to recorded instructor     No
Microsoft official training content     Yes
In-depth training     Yes
Hands-on labs     Yes
SATV redemption     Yes
Ask instructor questions in person     Yes
Attend live class in person     Yes
Attend live class remotely     Yes
Time commitment     5 days

About this course

Audience(s): Developers
Technology: Microsoft SharePoint Server
Level: 300
This Revision: B
Delivery method:
Online
Length: 2 days
Language(s): English
First published: 26 May 2016

Overview

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 customizations 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 customize authentication and authorization.
  • Create custom sites and lists and manage 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.
  • Customize the appearance and behavior of user interface elements.
  • Customize navigation and site branding.

Course details

Course Outline

Module 1: SharePoint as a Developer Platform

This module examines different approaches that can be used to develop applications with SharePoint Server 2013 the scenarios in which each approach might be appropriate.

Lessons

  • Introducing the SharePoint Developer Landscape
  • Choosing Approaches to SharePoint Development
  • Understanding SharePoint 2013 Deployment and Execution Models

Lab : Comparing Web Parts and App Parts

After completing this module, students will be able to:
  • Describe the opportunities for developers in SharePoint Server 2013.
  • Choose appropriate execution models for custom SharePoint components.
  • Choose appropriate deployment models for custom SharePoint components.

Module 2: Working with SharePoint Objects

This module introduces the server-side SharePoint object model and how the core classes relate to sites and collections. The server-side SharePoint object model provides a core set of classes that represent different items in the logical architecture of a SharePoint deployment. Students also learn how manage permissions for server-side code.

Lessons

  • Understanding the SharePoint Object Hierarchy
  • Working with Sites and Webs
  • Working with Execution Contexts

Lab : Working with Sites and Webs

Lab : Working with Execution Contexts

After completing this module, students will be able to:
  • Explain the purpose of key classes in the server-side SharePoint object model.
  • Programmatically interact with SharePoint site collections and sites.
  • Adapt solutions for users with different levels of permissions.

Module 3: Working with Lists and Libraries

This module explains how to interact with lists and libraries. Students learn about how to work with lists and libraries programmatically using the server-side SharePoint object model and how to use query classes and LINQ to SharePoint to query and retrieve data from SharePoint lists. Student also learn how to efficiently work with lists that contain large numbers of items.

Lessons

  • Using List and Library Objects
  • Querying and Retrieving List Data
  • Working with Large Lists

Lab : Querying and Retrieving List Data

Lab : Working with Large Lists

After completing this module, students will be able to:
  • Interact with lists and libraries programmatically.
  • Query and retrieve list data.
  • Perform operations efficiently on large lists.

Module 4: Designing and Managing Features and Solutions

This module examines creating and deploying custom Developing a SharePoint solutions and features. The students also learn how and when to use sandbox solutions.

Lessons

  • Understanding Features and Solutions
  • Configuring Features and Solutions
  • Working with Sandboxed Solutions

Lab : Working with Features and Solutions

After completing this module, students will be able to:
  • Explain the purpose and key functionality of Features and solutions.
  • Configure and manage Features and solutions.
  • Create and manage sandboxed solutions.

Module 5: Working with Server-Side Code

This module describes how to develop and deploy Web Parts and event receivers in a solution.

Lessons

  • Developing Web Parts
  • Using Event Receivers
  • Using Timer Jobs
  • Storing Configuration Data

Lab : Working with Server-Side Code

After completing this module, students will be able to:
  • Describe the process for developing a web part.
  • Use event receivers to handle SharePoint events.
  • Use timer jobs to perform out of process, and scheduled operations.
  • Store and manipulate configuration data for custom components.

Module 6: Managing Identity and Permissions

This module describes how manage permissions through code and customize authentication using custom claims providers.

Lessons

  • Understanding Identity Management in SharePoint 2013
  • Managing Permissions in SharePoint 2013
  • Configuring Forms-Based Authentication
  • Customizing the Authentication Experience

Lab : Managing Permissions Programmatically in SharePoint 2013

Lab : Creating and Deploying a Custom Claims Provider

After completing this module, students will be able to:
  • Describe how authentication and identity management work in SharePoint 2013.
  • Verify and manage permissions programmatically in SharePoint 2013.
  • Create and configure custom membership providers and role managers for forms-based authentication.
  • Create claims providers and customize the sign-in experience.

Module 7: Introducing Apps for SharePoint

This module introduces the SharePoint App, a new way to customize SharePoint functionality with SharePoint Server 2013. 

Lessons

  • Overview of Apps for SharePoint
  • Developing Apps for SharePoint

Lab : Creating a Site Suggestions App

After completing this module, students will be able to:
  • Describe SharePoint apps and compare them to SharePoint farm solutions and sandboxed solutions.
  • Describe how to develop apps for SharePoint 2013 that work on-premises and in the cloud.

Module 8: Client-Side SharePoint Development

This module describes how to use JavaScript Client Object Model (CSOM), managed code CSOM and the REST API to build SharePoint Apps. 

Lessons

  • Using the Client-Side Object Model for Managed Code
  • Using the Client-Side Object Model for JavaScript
  • Using the REST API with JavaScript

Lab : Using the Client-Side Object Model for Managed Code

Lab : Using the REST API with JavaScript

After completing this module, students will be able to:
  • Use the client-side object model for managed code to interact with a SharePoint deployment.
  • Use the client-side object model for JavaScript to interact with a SharePoint deployment.
  • Use the REST API with JavaScript or C# to interact with a SharePoint deployment.

Module 9: Developing Remote Hosted SharePoint Apps

This module examines the difference between provider hosted Apps and Remote Hosted Apps. The students will also create and deploy a Provider Hosted App.

Lessons

  • Overview of Remote Hosted Apps
  • Configuring Remote Hosted Apps
  • Developing Remote Hosted Apps

Lab : Configuring a Provider Hosted SharePoint App

Lab : Developing a Provider Hosted SharePoint App

After completing this module, students will be able to:
  • Describe how remote-hosted apps work and how to configure the permissions and cross-domain calls that they may require.
  • Configure apps for hosting on Windows Azure or remote servers.
  • Develop apps for hosting on Windows Azure or remote servers.

Module 10: Publishing and Distributing Apps

This module introduces the App Catalog so users to locate, purchase, and install apps easily. The students learn how to package and publish Apps to the App Catalog.

Lessons

  • Understanding the App Management Architecture
  • Understanding App Packages
  • Publishing Apps
  • Installing, Updating, and Uninstalling Apps

Lab : Publishing an App to a Corporate Catalog

Lab : Installing, Updating, and Uninstalling Apps

After completing this module, students will be able to:
  • Explain how SharePoint manages app publishing and distribution.
  • Describe the contents of an app package.
  • Publish apps to a corporate catalog or the Office Marketplace.
  • Install, update, and uninstall apps.

Module 11: Automating Business Processes

This module explains how to create workflows and workflow actions using Visio 2013, SharePoint Designer 2013 and Visual Studio 2012.

Lessons

  • Understanding Workflow in SharePoint 2013
  • Building Workflows by using Visio 2013 and SharePoint Designer 2013
  • Developing Workflows in Visual Studio 2012

Lab : Building Workflows in Visio 2013 and SharePoint Designer 2013

Lab : Creating Workflow Actions in Visual Studio 2012

At the end of this module, student will be able to:
  • Describe the architecture and capabilities of workflow in SharePoint 2013.
  • Create declarative workflows in Visio 2013 and SharePoint Designer 2013.
  • Create and deploy custom workflows by using Visual Studio 2012.

Module 12: Managing Taxonomy

This module explains the importance of a good taxonomy in SharePoint and working with the components of the taxonomy. The students also see how to tie event receivers to the taxonomy.

Lessons

  • Managing Taxonomy in SharePoint 2013
  • Working with Content Types
  • Working with Advanced Features of Content Types

Lab : Working with Content Types

Lab : Working with Advanced Features of Content Types

After completing this module, student will be able to:
  • Work with taxonomy building blocks in SharePoint 2013.
  • Create and configure content types declaratively and programmatically.
  • Work with advanced features of content types.

Module 13: Managing Custom Components and Site Life Cycles

This module explains how you can create custom component definitions and templates, which enable you to deploy custom sites, lists and other components across a farm.

Lessons

  • Defining Custom Lists
  • Defining Custom Sites
  • Managing SharePoint Sites

Lab : Managing Custom Components and Site Life Cycles

After completing this module, students will be able to:

  • Define and provision custom lists
  • Define and provision custom sites.
  • Manage the SharePoint site life cycle.

Module 14: Customizing User Interface Elements

This module explains different ways of customizing the SharePoint user interface, such as adding buttons to the ribbon or modifying the appearance of list views.

Lessons

  • Working with Custom Actions
  • Using Client-Side User Interface Components
  • Customizing the SharePoint List User Interface

Lab : Using the Edit Control Block to Launch an App

Lab : Using jQuery to Customize the SharePoint List User Interface

After completing this module, students will be able to:
  • Use custom actions to modify the SharePoint user interface.
  • Use JavaScript to work with client-side SharePoint user interface components.
  • Describe how to modify the appearance and behavior of list views and forms.

Module 15: Working with Branding and Navigation

This module explains ways to customize branding, designing, publishing and navigating sites in SharePoint Server 2013. The students also learn how to create devise independent sites standard web technologies, such as HTML, CSS, and JavaScript.

Lessons

  • Creating and Applying Themes
  • Branding and Designing Publishing Sites
  • Tailoring Content to Platforms and Devices
  • Configuring and Customizing Navigation

Lab : Branding and Designing Publishing Sites

Lab : Configuring Farm-Wide Navigation

After completing this module, students will be able to:
  • Create and apply themes to SharePoint sites.
  • Create publishing site design assets such as master pages and page layouts.
  • Use device channels and image renditions to adapt content for different devices.
  • Configure and customize the navigation experience for publishing sites.

Prerequisites

Before attending this course, students must have:

  • A working knowledge of using Visual Studio 2010 or Visual Studio 2012 to develop solutions.
  • A basic working knowledge of SharePoint solution development, either in SharePoint 2013 or in earlier versions of SharePoint.
  • A working knowledge of Visual C# and the .NET Framework 4.5.
  • A basic understanding of ASP.NET and server-side web development technologies, including request/response and the page lifecycle.
  • A basic understanding of AJAX and asynchronous programming techniques.
  • A basic working knowledge of client-side web technologies including HTML, CSS, and JavaScript.
  • Familiarity with approaches to authentication and authorization, including claims-based authentication.

Course OD10989A:Analyzing Data with Power BI

Choose how you want to learn: online or in a classroom

Compare learning environments    

Classroom training

Learn more

Find a Microsoft Learning Partner     Find a classroom training partner
Anytime access     No
Anywhere access to recorded instructor     No
Microsoft official training content     Yes
In-depth training     Yes
Hands-on labs     Yes
SATV redemption     Yes
Ask instructor questions in person     Yes
Attend live class in person     Yes
Attend live class remotely     Yes
Time commitment     2 days

About this course

Audience(s): Data Professionals
Technology: Power BI
Level: 300
This Revision: A
Delivery method:
Classroom
Length: 2 days
Language(s): English
First published: 03 November 2016

Overview

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

Course details

Course Outline

Module 1: Introduction to Self-Service BI Solutions

In this module students will be introduced to the key concepts in business intelligence, data analysis, and data visualization. In addition they will learn the rationale for self-service BI, considerations for using self-service BI, and how Microsoft products can be used to implement a self-service BI solution.

Lessons

  • Introduction to business intelligence
  • Introduction to data analysis
  • Introduction to data visualization
  • Overview of self-service BI
  • Considerations of self-service BI
  • Microsoft tools for self-service BI

Lab : Exploring an enterprise BI solution

After completing this module, you will be able to:
• Describe key concepts in business intelligence
• Describe key concepts in data analysis
• Describe key concepts in data visualization
• Describe the rationale for self-service BI
• Describe considerations for self-service BI
• Describe how Microsoft products can be used to implement a self-service BI solution

Module 2: Introducing Power BIThis module introduces Power BI.

Lessons

  • Power BI
  • The Power BI service
  • Power BI mobile apps

Lab : Cresting a Power BI dashboard

After completing this module, you will be able to:
• Describe Power BI
• Describe the Power BI Service
• Implement Tenant Management
• Describe Power BI mobile apps
• Create a simple dashboard

Module 3: Power BI DataThis module describes Power BI data sources.

Lessons

  • Using Excel as a Power BI data source
  • Using databases as a Power BI data source
  • The Power BI service

Lab : Import data into Power BI

After completing this module, you will be able to:
• Use Excel as a Power BI data source
• Use databases as a Power BI data source and describe the R language
• Configure the Power BI Service

Module 4: Shaping and Combining DataThis module describes how to shape and combine data.

Lessons

  • Power BI desktop queries
  • Shaping data
  • Combining data

Lab : Shaping and combining data

After completing this module, you will be able to:
• Create Power BI Desktop queries
• Shape data
• Combine data

Module 5: Modelling DataThis module describes how to model data in Power BI.

Lessons

  • Relationships
  • DAX queries
  • Calculations and measures

Lab : Modelling data

After completing this module, you will be able to:
• Configure the Power BI Service
• Create Relationships
• Write simple DAX queries
• Create calculations and measures

Module 6: Interactive Data VisualizationsThis module describes Power BI visualizations.Lessons

  • Creating Power BI reports
  • Managing a Power BI solution

Lab : Creating a Power BI report

After completing this module, you will be able to:
• Use Power BI Desktop to create interactive data visualizations
• Describe the management of a Power BI solution

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.

These prerequisites can be achieved by attending courses
• 20761A – Querying Data with Transact-SQL
• 20767A -  Implementing a SQL Server Data Warehouse

Course OD10969B:Active Directory® Services with Windows Server®

Choose how you want to learn: online or in a classroom 

Compare learning environments    

Classroom training
Learn more

Find a Microsoft Learning Partner     Find a classroom training partner
Anytime access     No
Anywhere access to recorded instructor     No
Microsoft official training content     Yes
In-depth training     Yes
Hands-on labs     Yes
SATV redemption     Yes
Ask instructor questions in person     Yes
Attend live class in person     Yes
Attend live class remotely     Yes
Time commitment     5 days

About this course

Audience(s): IT Professionals
Technology: Windows Server
Level: 300+
This Revision: B
Delivery method:
Online
Length: 5 days
Language(s): English
First published: 28 April 2016

Overview

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 deployment.
  • Implement AD DS sites, configure and manage replication
  • Implement and manage Group Policy
  • Manage user settings with 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 administer 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).

Course details

Course Outline

Module 1: Overview of Access and Information Protection

This module provides an overview of multiple Access and Information Protection (AIP) technologies and services what are available with Windows Server 2012 and Windows Server 2012 R2 from a business perspective and maps business problems to technical solutions. It also includes coverage of Forefront Identify Manager (FIM).

Lessons

  • Introduction to Access and Information Protection Solutions in Business
  • Overview of AIP Solutions in Windows Server 2012
  • Overview of FIM 2010 R2

Lab : Choosing an Appropriate Access and Information Protection Management Solution

After completing this module students will be able to:
  • Describe Access and Information Protection solutions in business.
  • Describe Access and Information Protection solutions in Windows Server 2012 and Windows Server 2012 R2.
  • Describe Microsoft Forefront Identity Manager (FIM) 2010 R2.

Module 2: Advanced Deployment and Administration of AD DS

This module explains how to deploy AD DS remotely and describes the virtualization safeguards, cloning abilities and extending AD DS to the cloud.

Lessons

  • Deploying AD DS
  • Deploying and Cloning Virtual Domain Controllers
  • Deploying Domain Controllers in Windows Azure
  • Administering AD DS

Lab : Deploying and Administering AD DS

After completing this module, students will be able to:
  • Describe and perform various deployment techniques for AD DS.
  • Describe virtual domain controller deployment considerations.
  • Explain how new technologies in Windows Server 2012 and Windows Server 2012 R2 support virtual domain controllers.
  • Describe Domain Controller cloning.
  • Implement AD DS using the tools provided in Windows Server 2012 and Windows Server 2012 R2.

Module 3: Securing AD DS

This module describes the threats to domain controllers and what methods can be used to secure the AD DS and its domain controllers.

Lessons

  • Securing Domain Controllers
  • Implementing Account Security
  • Implementing Audit Authentication

Lab : Securing AD DS

After completing this module, students will be able to:
  • Understand the importance of securing domain controllers.
  • Describe the benefit of read-only domain controllers (RODCs).
  • Explain and implement password and account lockout policies.
  • Implement audit authentication.

Module 4: Implementing and Administering AD DS Sites and Replication

This module explains how AD DS replicates information between domain controllers within a single site and throughout multiple sites. This module also explains how to create multiple sites and how to monitor replication to help optimize AD DS replication and authentication traffic.

Lessons

  • Overview of AD DS Replication
  • Configuring AD DS Sites
  • Configuring and Monitoring AD DS Replication

Lab : Implementing AD DS Sites and Replication

After completing this module, students will be able to:
  • Describe AD DS replication.
  • Configure AD DS sites.
  • Configure and monitor AD DS replication.

Module 5: Implementing Group Policy

This module describes Group Policy, how it works, and how best to implement it within your organization.

Lessons

  • Introducing Group Policy
  • Implementing and Administering GPOs
  • Group Policy Scope and Group Policy Processing
  • Troubleshooting the Application of GPOs

Lab : Implementing and Troubleshooting a Group Policy Infrastructure

After completing this module, students will be able to:
  • Describe Group Policy.
  • Implement and administer GPOs.
  • Describe Group Policy scope and Group Policy processing.
  • Troubleshoot the application of GPOs.

Module 6: Managing User Settings with Group Policy

This module describes how to how to use GPO Administrative Templates, Folder Redirection, and Group Policy features to configure users’ computer settings.

Lessons

  • Implementing Administrative Templates
  • Configuring Folder Redirection and Scripts
  • Configuring Group Policy Preferences

Lab : Managing User Desktops with Group Policy

After completing this module, students will be able to:
  • Implement Administrative Templates.
  • Configure Folder Redirection and scripts.
  • Configure Group Policy preferences.

Module 7: Deploying and Managing AD CS

This module explain how to deploy and manage Certificate Authorities (CAs) with Active Directory Certificate Services (AD CS)

Lessons

  • Deploying CAs
  • Administering CAs
  • Troubleshooting, Maintaining, and Monitoring CAs

Lab : Deploying and Configuring a Two-Tier CA Hierarchy

After completing this module, students will be able to:
  • Deploy Certificate Authorities.
  • Administer Certificate Authorities.
  • Troubleshoot, maintain, and monitor Certificate Authorities.

Module 8: Deploying and Managing Certificates

This module describes certificate usage in business environments and explains how to deploy and manage certificates, configure certificate templates and manage enrolment process. This module also covers the deployment and management of smart cards.

Lessons

  • Using Certificates in a Business Environment
  • Deploying and Managing Certificate Templates
  • Managing Certificates Deployment, Revocation, and Recovery
  • Implementing and Managing Smart Cards

Lab : Deploying and Using Certificates

After completing this module, students will be able to:
  • Use certificates in business environments.
  • Deploy and manage certificate templates.
  • Manage certificates deployment, revocation and recovery.
  • Implement and manage smart cards.

Module 9: Implementing and Administering AD RMS

This module introduces Active Directory Rights Management Services (AD RMS). It also describes how to deploy AD RMS, how to configure content protection, and how to make AD RMS–protected documents available to external users.

Lessons

  • Overview of AD RMS
  • Deploying and Managing an AD RMS Infrastructure
  • Configuring AD RMS Content Protection
  • Configuring External Access to AD RMS

Lab : Implementing an AD RMS Infrastructure

After completing this module, students will be able to:
  • Describe AD RMS.
  • Explain how to deploy and manage an AD RMS infrastructure.
  • Explain how to configure AD RMS content protection.
  • Explain how to configure external access to AD RMS.

Module 10: Implementing and Administering AD FS

This module explains AD FS, and then provides details on how to configure AD FS in both a single organization scenario and in a partner organization scenario. This module also describes the Web Application Proxy feature in Windows Server 2012 R2 that functions as an AD FS proxy and reverse proxy for web-based applications.

Lessons

  • Overview of AD FS
  • Deploying AD FS
  • Implementing AD FS for a Single Organization
  • Deploying AD FS in a Business-to-Business Federation Scenario
  • Extending AD FS to External Clients

Lab : Implementing AD FS

After completing this module, students will be able to:
  • Describe AD FS.
  • Explain how to configure the AD FS prerequisites, and deploy AD FS services.
  • Describe how to implement AD FS for a single organization.
  • Deploy AD FS in a business-to-business federation scenario.
  • Deploy the Web Application Proxy.

Module 11: Implementing Secure Shared File Access

This module explains how to use Dynamic Access Control (DAC), Work Folders, Work place Join and how to plan and implement these technologies.

Lessons

  • Overview of Dynamic Access Control
  • Implementing DAC Components
  • Implementing DAC for Access Control
  • Implementing Access Denied Assistance
  • Implementing and Managing Work Folders
  • Implementing Workplace Join

Lab : Implementing Secure File Access

After completing this module, students will be able to:
  • Describe DAC.
  • Implement DAC components.
  • Implement DAC for access control.
  • Implement access-denied assistance.
  • Implement and manage Work Folders.
  • Implement Workplace Join.

Module 12: Monitoring, Managing, and Recovering AD DS

This module explains how to use tools that help monitor performance in real time, and how to record performance over time to spot potential problems by observing performance trends. This module also explains how to optimize and protect your directory service and related identity and access solutions so that if a service does fail, you can restart it as quickly as possible.

Lessons

  • Monitoring AD DS
  • Managing the AD DS Database
  • AD DS Backup and Recovery Options for AD DS and Other Identity and Access Solutions

Lab : Monitoring AD DSLab : Recovering Objects in AD DS

After completing this module, students will be able to:
  • Monitor AD DS.
  • Manage the AD DS database.
  • Recover objects from the AD DS database.

Module 13: Implementing Windows Azure Active Directory

This module explains the concepts and technologies in Windows Azure Active Directory and how to implement and integrate it within your organization

Lessons

  • Overview of Windows Azure AD
  • Managing Windows Azure AD Accounts

Lab : Implementing Windows Azure AD

After completing this module, students will be able to:
  • Describe Windows Azure AD.
  • Administer Azure AD.

Module 14: Implementing and Administering AD LDS

This module explains how to deploy and configure Active Directory Lightweight Directory Services (AD LDS)

Lessons

  • Overview of AD LDS
  • Deploying AD LDS
  • Configuring AD LDS Instances and Partitions
  • Configuring AD LDS Replication
  • Integrating AD LDS with AD DS

Lab : Implementing and Administering AD LDS

After completing this module, students will be able to:
  • Describe AD LDS.
  • Explain how to deploy AD LDS.
  • Explain how to configure AD LDS instances and partitions.
  • Explain how to configure AD LDS replication.

Prerequisites

Before attending this course, students must have:
  • Experience working with Active Directory Domain Services (AD DS)
  • Experience working in a Windows Server Infrastructure enterprise environment
  • Experience working with and troubleshooting core networking infrastructure technologies such as name resolution, IP Addressing, Domain Name System (DNS) and Dynamic Host Configuration Protocol (DHCP)
  • Experience working with Hyper-V and Server Virtualization concepts
  • An awareness and understanding of general security best practices
  • Experience working hands on with Windows client operating systems such as Windows Vista, Windows 7 or Windows 8

Course OD10972B:Administering the Web Server (IIS) Role of Windows Server

Choose how you want to learn: online or in a classroom 

 

Compare learning environments    

Classroom training
Learn more

Find a Microsoft Learning Partner     Find a classroom training partner
Anytime access     No
Anywhere access to recorded instructor     No
Microsoft official training content     Yes
In-depth training     Yes
Hands-on labs     Yes
SATV redemption     Yes
Ask instructor questions in person     Yes
Attend live class in person     Yes
Attend live class remotely     Yes
Time commitment     5 days

About this course

Audience(s): IT Professionals
Technology: Windows Server
Level: 300
This Revision: B
Delivery method:
Instructor-led (classroom)
Length: 2 days
Language(s): English
First published: 12 May 2016

Overview

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 web site
  • Configure and manage application pools
  • Create additional web sites
  • Configure web sites and application support
  • Secure web sites and applications
  • Secure web site data transmission
  • Manage certificates in the Centralized Certificate Store
  • Configure remote administration
  • Implement FTP
  • Monitor IIS
  • Backup and restore IIS
  • Build load-balanced web farms

Course details

Course Outline

Module 1: Understanding and Installing Internet Information Services

In this module, you will learn about the infrastructure prerequisites for using Microsoft Internet Information Services (IIS) 8.5. Students will also learn about the high-level architecture of IIS, and will learn to perform a basic installation and configuration of IIS.

Lessons

  • Understanding a Web Server infrastructure
  • Installing Internet Information Services

Lab : Installing Internet Information Services

After completing this module, students will be able to:
  • Describe the prerequisites for using IIS.
  • Describe the architecture of IIS.
  • Install IIS and configure basic security settings.

Module 2: Configuring The Default Website

In this module students will learn to plan and implement network requirements for a public website. Students will configure Domain Name Service (DNS) records to support access to both internal and public websites, and create virtual directories and application folders for additional website content.

Lessons

  • Examining the Default Website Using IIS Manager
  • Examining the Default IIS File Structure
  • Configuring DNS Records for a Website
  • Creating Folders, Virtual Directories, and Applications

Lab : Configuring the Default Website for Public Access

Lab : Creating Virtual Directories and Applications

After completing this module, students will be able to:
  • Plan and configure the DNS records and networking requirements that support website access.
  • Describe the default Microsoft Internet Information Services (IIS) folder structure for a website.
  • Create a webpage that verifies website functionality.
  • Install additional role services that support a web application.
  • Create folders, virtual directories, and applications that can contain additional website content.

Module 3: Configuring and Managing Application Pools

In this module students will learn the benefits to the application pool architecture. Students will create and configure application pools to support additional applications and configure application pool recycle settings. Students will perform recycle events and examine the event logs for recycle events.

Lessons

  • Defining the Application Pool Architecture
  • Creating and Managing Application Pools
  • Configuring Application Pool Recycling

Lab : Configuring and Managing Application Pools

Lab : Configuring Application Pool Recycling

After completing this module, students will be able to:
  • Describe the benefits of the application pool architecture.
  • Configure application pools to support web applications.
  • Configure application pool recycling.
  • Recycle application pools.
  • Monitor application pool recycling by using event logs.

Module 4: Creating Additional Websites

In this module students will learn how to examine and create new websites using unique bindings to avoid naming conflicts. Students will examine existing sites to determine and resolve binding conflicts then create new websites by using unique bindings.

Lessons

  • Understanding Configurations for Multiple Websites
  • Configuring Website Bindings
  • Creating and Starting Websites

Lab : Examining Existing Websites for Binding Conflicts

Lab : Creating New Websites

After completing this module, students will be able to:
  • Describe the basic configuration of a server that hosts multiple websites.
  • Configure website bindings.
  • Create and configure new websites.

Module 5: Configuring Website and Web Application Support

In this module students will learn to support additional application requirements including common configuration settings, platform support from the built-in web server, and include additional application support by using the Web Platform Installer.

Lessons

  • Configuring Common Features
  • Configuring Support for Web Applications

Lab : Configuring Common Features

Lab : Configuring Support for Web Applications

After completing this module, students will be able to:
  • Describe and configure common IIS features.
  • Add support for web applications.

Module 6: Securing Websites and Applications

In this module students will learn to secure internal and public websites for users and groups by using the built-in Windows and Basic authentication. Students will configure file system permissions for specific users and groups and secure a website using URL Authorization Rules.

Lessons

  • Understanding IIS Authentication and Authorization
  • Configuring Authentication and Authorization
  • Configuring URL Authorization Rules

Lab : Configuring Authentication and Access

Lab : Configuring URL Authorization Rules

After completing this module, students will be able to:
  • Describe access control methods that are used in IIS.
  • Configure authentication and authorization.
  • Configure URL authorization rules.

Module 7: Securing Website Data Transmission

In this module students will protect customer data using websites configured for SSL. Students will install and configure PKI certificates on a web server, create secured bindings, and verify that a website data transmissions are secured.

Lessons

  • Understanding Certificates and SSL
  • Creating and Managing Web Server Certificates
  • Configuring HTTPS Bindings

Lab : Creating and Managing Web Server Certificates

Lab : Adding a Certificate to a Website

After completing this module, students will be able to:
  • Describe the benefits and function of digital certificates and Secure Sockets Layer (SSL).
  • Create SSL certificates for a web server.
  • Configure HTTPS bindings that use certificates.

Module 8: Managing Certificates in the Centralized Certificate Store

In this module students will install and configure the IIS 8.5 Central Certificate Store to enable centralized and improved certificate management, Students will configure a website to use a secured binding with the Central Certificate Store.

Lessons

  • Understanding the Centralized Certificate Store
  • Installing and Configuring the Centralized Certificate Store

Lab : Installing and Configuring the Centralized Certificate Store

After completing this module, students will be able to:
  • Explain the purpose of the Centralized Certificate Store
  • Install and configure the Centralized Certificate Store

Module 9: Configuring Remote Administration

In this module students will configure secured remote management of web servers and websites. Create and configure permissions for site level administrators and developers, and verify web server and website management.

Lessons

  • Installing and Configuring the Management Service
  • Connecting to Remote Web Servers and Websites
  • Delegating Management Permissions

Lab : Installing and Configuring the Management Service

Lab : Connecting to Remote Web Servers and Websites

Lab : Delegating Management Permissions

After completing this module, students will be able to:
  • Install and configure the IIS management service.
  • Connect to remote web servers and websites.
  • Delegate management permissions.

Module 10: Implementing FTP

In this module students will learn configure a secured FTP site for users to store and retrieve files. Student will configure authentication, authorization and the FTP storage location. Students will retrieve and files using the native Windows FTP command.

Lessons

  • Planning for FTP
  • Implementing an FTP site
  • Uploading and Downloading by Using FTP

Lab : Installing and Configuring an FTP Site

After completing this module, students will be able to:
  • Describe the architecture and requirements of FTP.
  • Implement anonymous and authenticated FTP sites.
  • Upload and download files by using FTP.

Module 11: Monitoring IIS

In this module students will learn to monitor IIS log files and performance counters using Log Parser and PerfMon. Students will identify common issues related to performance and attacks recorded in the log files.

Lessons

  • Monitoring IIS Logs
  • Analyzing Performance Counters

Lab : Monitoring IIS Logs

Lab : Analyzing Performance Counters

After completing this module, students will be able to:
  • Monitor IIS log files.
  • Analyze IIS performance counters.

Module 12: Backing Up and Restoring IIS

In this module students will learn to backup and recover form a website or web server failure. Students will learn the importance of using high available techniques to avoid the recovery process.

Lessons

  • Understanding IIS Backup and Recovery Components
  • Backing Up and Recovering a Website

Lab : Backing Up and Recovering Configuration History

After completing this module, students will be able to:
  • Explain the components of IIS backup and recovery.
  • Back up and recover a website.

Module 13: Building Load-Balanced Web Farms

In this module students will learn to increase reliability and performance of website by creating a web farm. Students will improve the management and update capabilities of the websites by using shared content in both a network share and DFS-R. Student will improve web server and website management by using Shared Configurations.

Lessons

  • Understanding Load-Balancing Mechanisms
  • Building a Load-Balanced Web Farm by Using ARR
  • Sharing Content in a Web Farm by Using Shared Folders
  • Sharing Content in a Web Farm by Using DFS-R
  • Sharing IIS Configurations in a Web Farm

Lab : Building a Load-Balanced Web Farm by Using ARR

Lab : Sharing Content in a Web Farm by Using Shared Folders

Lab : Sharing Web Farm Content by Using DFS-R

Lab : Sharing IIS Configurations in a Web Farm

After completing this module, students will be able to:
  • List load-balancing mechanisms that can be used in a web farm.
  • Plan and deploy a load-balanced web farm that uses ARR.
  • Centralize the content for a web farm by using shared folders.
  • Centralize the content for a web farm by using Distributed File System-Replication (DFS-R).
  • Centralize the configuration of a web farm.

Prerequisites

In addition to their professional experience, students who attend this training should already have the following technical knowledge:
  • Experience with Windows networking technologies and implementation.
  • Experience with Windows Server administration, maintenance, and troubleshooting.
  • Experience with Windows Client administration, maintenance, and troubleshooting.

Course OD20411D:Administering Windows Server® 2012

Choose how you want to learn: online or in a classroom 

Compare learning environments    

Classroom training

Learn more

Find a Microsoft Learning Partner     Find a classroom training partner
Anytime access     No
Anywhere access to recorded instructor     No
Microsoft official training content     Yes
In-depth training     Yes
Hands-on labs     Yes
SATV redemption     Yes
Ask instructor questions in person     Yes
Attend live class in person     Yes
Attend live class remotely     Yes
Time commitment     5 days

About this course

Audience(s): IT Professionals
Technology: Windows Server
Level: 200
This Revision: D
Delivery method:
Online
Length: 5 days
Language(s): English
First published: 25 February 2016

Overview

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.

This course maps directly to and is the preferred choice for hands-on preparation for Microsoft Certified Solutions Associate (MCSA): Exam 411: Administering Windows Server 2012, which is the second of three exams required for MCSA: Windows Server 2012 credential.

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

Course details

Course Outline

Module 1: Configuring and Troubleshooting Domain Name System

This module explains how to configure and troubleshoot DNS, including DNS replication and caching.

Lessons

  • Configuring the DNS Server Role
  • Configuring DNS Zones
  • Configuring DNS Zone Transfers
  • Managing and Troubleshooting DNS

Lab : Configuring and Troubleshooting DNS

After completing this module, students will be able to:
  • Install and configure the DNS server role.
  • Create and configure DNS zones.
  • Configure DNS zone transfers.
  • Manage and troubleshoot DNS.

Module 2: Maintaining Active Directory Domain Services

This module explains how to implement virtualized domain controllers and read-only domain controller (RODCs). It also explains how to perform common AD DS administrative tasks
and manage the AD DS Database.

Lessons

  • Overview of AD DS
  • Implementing Virtualized Domain Controllers
  • Implementing RODCs
  • Administering AD DS
  • Managing the AD DS Database

Lab : Maintaining AD DS

After completing this module, students will be able to:
  • Implement virtualized domain controllers.
  • Implement RODCs.
  • Administer AD DS.
  • Manage the AD DS database

Module 3: Managing User and Service Accounts

This module explains how to create, configure and automate the creation of user accounts. It also explains how to configure account-related properties of user objects. It further explains how to create and administer Managed Service Accounts.

Lessons

  • Configuring Password Policy and User Account Lockout Settings
  • Configuring Managed Service Accounts

Lab : Managing User and Service Accounts

After completing this module, students will be able to:
  • Configure password policy and user account lockout settings.
  • Configure managed service accounts.

Module 4: Implementing a Group Policy Infrastructure

This module explains how to implement a GPO infrastructure. This also teaches how to perform common GPO management tasks, and manage GPOs by using Windows PowerShell. It also focuses on troubleshooting the application of GPOs.

Lessons

  • Introducing Group Policy
  • Implementing and Administering GPOs
  • Group Policy Scope and Group Policy Processing
  • Troubleshooting the Application of GPOs

Lab : Implementing a Group Policy Infrastructure

After completing this module, students will be able to:
  • Explain what Group Policy is.
  • Implement and administer Group Policy Objects (GPOs).
  • Manage Group Policy scope and Group Policy processing.
  • Troubleshoot the application of GPOs.

Module 5: Managing User Desktops with Group Policy

This module explains how you can use Group Policy Objects (GPOs) to implement desktop environments across your organization by using Administrative Templates, Folder Redirection, Group Policy preferences, and where applicable, use software deployment to install and update application programs. It is important to know how to use these various GPO features so that you can configure your users’ computer settings properly.

Lessons

  • Implementing Administrative Templates
  • Configuring Folder Redirection and Scripts
  • Configuring Group Policy Preferences
  • Managing Software with Group Policy   

Lab : Managing User Desktops with Group Policy

After completing this module, students will be able to:
  • Configure folder redirection and scripts by using GPOs.
  • Describe and implement Administrative Templates.
  • Configure GPO preferences.
  • Deploy software by using GPOs.

Module 6: Installing, Configuring, and Troubleshooting the Network Policy Server Role

This module explains how to install and configure NPS, RADIUS Clients and servers. It also describes NPS authentication methods. It describe NPS authentication methods and how to
monitor and troubleshoot NPS.

Lessons

  • Installing and Configuring a Network Policy Server
  • Configuring RADIUS Clients and Servers
  • NPS Authentication Methods
  • Monitoring and Troubleshooting a Network Policy Server

Lab : Installing and Configuring a Network Policy Server

After completing this module, students will be able to:
  • Install and configure a Network Policy Server (NPS).
  • Configure clients and servers with the Remote Authentication Dial-In User Service (RADIUS) protocol.
  • Explain NPS authentication methods.
  • Monitor and troubleshoot NPS.

Module 7: Implementing Network Access Protection

This module explains how to configure, monitor, and troubleshoot NAP. It also explains how NAP can help to protect your network and the various NAP enforcement processes.

Lessons

  • Overview of Network Access Protection
  • Overview of NAP Enforcement Processes
  • Configuring NAP
  • Configuring IPSec Enforcement for NAP
  • Monitoring and Troubleshooting NAP

Lab : Implementing Network Access Protection

After completing this module, students will be able to:
  • Describe how NAP can help to protect your network.
  • Describe the various NAP enforcement processes.
  • Configure NAP.
  • Monitor and troubleshoot NAP.

Module 8: Implementing Remote Access

In this module, you will learn how to implement and manage remote access in Windows Server 2012. You will also learn how to implement DirectAccess by using the Getting Started wizard, implement and manage an advanced DirectAccess infrastructure, and implement VPN.

Lessons

  • Overview of Remote Access
  • Implementing DirectAccess by Using the Getting Started Wizard
  • Implementing and Managing an Advanced DirectAccess Infrastructure
  • Implementing VPN
  • Implementing Web Application Proxy

Lab : Implementing DirectAccess by Using the Getting Started Wizard

Lab : Deploying an Advanced DirectAccess Solution

Lab : Implementing VPN

Lab : Implementing Web Application Proxy

After completing this module, students will be able to:
  • Install and manage the Remote Access role in Windows Server 2012 operating system.
  • Implement DirectAccess by using the Getting Started Wizard.
  • Implement and manage an advanced DirectAccess Infrastructure.
  • Implement VPN access.
  • Implement Web Application Proxy.

Module 9: Optimizing File Services

This module describes FSRM, configure quotas, file screening, and storage reports and implement classification management and file management tasks. It describes the components of the DFS. I also explains how to configure DFS namespaces and DFS replication.

Lessons

  • Overview of FSRM
  • Using FSRM to Manage Quotas, File Screens, and Storage Reports
  • Implementing Classification and File Management Tasks
  • Overview of DFS
  • Configuring DFS Namespaces
  • Configuring and Troubleshooting DFS Replication

Lab : Configuring Quotas and File Screening Using File Server Resource Manager

Lab : Implementing Distributed File System

After completing this module, students will be able to:
  • Describe the File Server Resource Manager (FSRM) in the Windows Server 2012 operating system.
  • Use FSRM to manage quotas, file screens, and storage reports.
  • Implement classification and file management tasks.
  • Describe Distributed File System (DFS).
  • Configure DFS namespaces.
  • Configure and troubleshoot DFS Replication.

Module 10: Configuring Encryption and Advanced Auditing

This module explains how to encrypt files using EFS and configure advanced auditing features.

Lessons

  • Encrypting Drives by Using BitLocker
  • Encrypting Files by Using EFS
  • Configuring Advanced Auditing

Lab : Configuring Encryption and Advanced Auditing

After completing this module, students will be able to:
  • Secure data by using BitLocker Drive Encryption.
  • Encrypt files by using Encrypting File System (EFS).
  • Configure advanced auditing.

Module 11: Deploying and Maintaining Server Images

This module explains how to create and manage server images by using Windows Deployment Services

Lessons

  • Overview of Windows Deployment Services
  • Managing Images
  • Implementing Deployment with Windows Deployment Services
  • Administering Windows Deployment Services

Lab : Using Windows Deployment Services to Deploy Windows Server 2012

After completing this module, students will be able to:
  • Describe the important features and functionality of Windows Deployment Services (Windows DS).
  • Manage images by using Windows Assessment and Deployment Kit (Windows ADK) Tools.
  • Configure Windows Deployment Services in Windows Server 2012.
  • Perform deployments with Windows Deployment Services.

Module 12: Implementing Update Management

This module explains how to use Windows Server Update Services (WSUS) to deploy updates to Windows servers and clients.

Lessons

  • Overview of WSUS
  • Deploying Updates with WSUS

Lab : Implementing Update Management

After completing this module, students will be able to:
  • Describe the role of WSUS.
  • Describe the WSUS update management process.
  • Deploy updates with WSUS.

Module 13: Monitoring Windows Server 2012

This module explains the monitoring tools available in Windows Server 2012. it also explains how to use Performance Monitor and monitor events.

Lessons

  • Monitoring Tools
  • Using Performance Monitor
  • Monitoring Event Logs

Lab : Monitoring Windows Server 2012

After completing this module, students will be able to:
  • Describe the monitoring tools for the Windows Server 2012 operating system.
  • Use Performance Monitor to view and analyze performance statistics of programs that are running on their servers.
  • Monitor event logs to view and interpret the recorded events.

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.

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

Course OD10962B:Advanced Automated Administration with Windows PowerShell®

Choose how you want to learn: online or in a classroom 

Compare learning environments    

Classroom training

Learn more

Find a Microsoft Learning Partner     Find a classroom training partner
Anytime access     No
Anywhere access to recorded instructor     No
Microsoft official training content     Yes
In-depth training     Yes
Hands-on labs     Yes
SATV redemption     Yes
Ask instructor questions in person     Yes
Attend live class in person     Yes
Attend live class remotely     Yes
Time commitment     3 days

About this course

Audience(s): IT Professionals
Technology: Windows Server
Level: 300
This Revision: B
Delivery method:
Online
Length: 2 days
Language(s): English
First published: 31 March 2016

Overview

About this course

Learn how to automate and streamline day to day management and administration tasks and functions in your Windows Server Infrastructure.
 
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

Course details

Course Outline

Module 1: Creating Advanced Functions

In this module students will learn how to parameterize a command into an advanced function. It is designed to teach several key principles in a single logical sequence, by using frequent hands-on exercises to reinforce new skills.

Lessons

  • Converting a Command into an Advanced Function
  • Creating a Script Module
  • Defining Parameter Attributes and Input Validation
  • Writing Functions that use Multiple Objects
  • Writing Functions that Accept Pipeline Input
  • Producing Complex Function Output
  • Documenting Functions by using Content-Based Help
  • Supporting -Whatif and -Confirm

Lab : Converting a Command into an Advanced Function

Lab : Creating a Script Module

Lab : Defining Parameter Attributes and Input Validation

Lab : Writing Functions that use Multiple Objects

Lab : Writing Functions that Accept Pipeline Input

Lab : Producing Complex Function Output

Lab : Documenting Functions by using Content-Based Help

Lab : Supporting -Whatif and -Confirm

After completing this module, students will be able to:
  • Parameterize a command and create an advanced function.
  • Convert a script and function into a script module.
  • Define parameter attributes and input validation for a function.
  • Enumerate objects by using scripting constructs.
  • Modify a function to accept pipeline input.
  • Produce complex pipeline output in a function.
  • Document a function by using comment-based Help.
  • Create functions that support –WhatIf and –Confirm.

Module 2: Using Cmdlets and Microsoft .NET Framework in Windows PowerShell

Windows PowerShell provides commands that accomplish many of the tasks that you will need in a production environment. Sometimes, a command is not available but the .NET Framework provides an alternate means of accomplishing a task. Because Windows PowerShell is built on the .NET Framework, it is able to access those alternate means. In this module, you will learn how to discover and run Windows PowerShell commands, and how to use .NET Framework components from inside Windows PowerShell. These two techniques will provide you with the most flexibility and capability for accomplishing tasks in a production environment.

Lessons

  • Running Windows PowerShell Commands
  • Using Microsoft .NET Framework in Windows PowerShell

Lab : Using .NET Framework in Windows PowerShell

After completing this module, students will be able to:
  • Discover Windows PowerShell commands by using the Help system.
  • Describe and use .NET Framework classes and instances in Windows PowerShell.

Module 3: Writing Controller Scripts

In this module, students will learn how to combine tools – advanced functions that perform a specific task – and a controller script that provides a user interface or automates a business process.

Lessons

  • Understanding Controller Scripts
  • Writing Controller Scripts that Show a User Interface
  • Writing Controller Scripts That Produce Reports

Lab : Writing Controller Scripts that Display a User Interface

Lab : Writing Controller Scripts That Produce HTML Reports

After completing this module, students will be able to:
  • Describe the difference between tools and controller scripts.
  • Write controller scripts that present a user interface.
  • Write controller scripts that automate a business process.

Module 4: Handling Script Errors

In this module, students will learn how to perform basic error handling in scripts. The focus will be about how to add error handling to existing tools, primarily as a time-saving mechanism (instead of having students write new tools). A side benefit of this approach is that it will help build the skills that you must have to analyze and reuse existing code written by someone else.
 

Lessons

  • Understanding Error Handling
  • Handling Errors in a Script

Lab : Handling Errors in a Script

After completing this module, students will be able to:
  • Describe the shell’s default error response mechanisms.
  • Add error handling code to existing tools.

Module 5: Using XML Data Files

In this module, students will learn how to read, manipulate, and write data in XML files. XML files provide a robust, yet straightforward way to store both flat and hierarchical data. XML files are more flexible than CSV, more accessible for small amounts of data than SQL Server, and easier to code against that Excel automation.

Lessons

  • Reading, Manipulating and Writing Data in XML

Lab : Reading, Manipulating and Writing Data in XML

After completing this module, students will be able to:
  • Read, manipulate, and write data in XML.

Module 6: Managing Server Configurations by Using Desired State Configuration

In this module, students will learn how to write Desired State Configuration (DSC) configuration files, deploy those files to servers, and monitor servers’ configurations.

Lessons

  • Understanding Desired State Configuration
  • Creating and Deploying a DSC Configuration

Lab : Creating and Deploying a DSC Configuration

After completing this module, students will be able to:
  • Describe the architecture and deployment models of DSC.
  • Write and deploy DSC configuration files.

Module 7: Analyzing and Debugging Scripts

In this module, students will learn how to use native Windows PowerShell features to analyze and debug existing scripts. These skills are also useful when students have to debug their own scripts.

Lessons

  • Debugging in Windows PowerShell
  • Analyzing and Debugging an Existing Script

Lab : Analyzing and Debugging an Existing Script

After completing this module, students will be able to:
  • Describe the debugging features of Windows PowerShell.
  • Analyze and debug an existing script.

Module 8: Understanding Windows Power Shell Workflow

In this module, students will learn about the features of the Windows Power Shell Workflow technology.

Lessons

  • Understanding Windows PowerShell Workflow
After completing this module, students will be able to:
  • Describe the Workflow feature of Windows PowerShell.

Prerequisites

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

Course OD10961B:Automating Administration with Windows PowerShell®

Choose how you want to learn: online or in a classroom 

Compare learning environments    

Classroom training

Learn more

Find a Microsoft Learning Partner     Find a classroom training partner
Anytime access     No
Anywhere access to recorded instructor     No
Microsoft official training content     Yes
In-depth training     Yes
Hands-on labs     Yes
SATV redemption     Yes
Ask instructor questions in person     Yes
Attend live class in person     Yes
Attend live class remotely     Yes
Time commitment     5 days

About this course

Audience(s): IT Professionals
Technology: Windows Server
Level: 300
This Revision: B
Length: 3 days
Language(s): English
First published: 12 January 2016

Overview

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

Course details

Course Outline

Module 1: Getting Started with Windows PowerShell

This module introduces students to Windows PowerShell, its purpose and history. The module will also cover the basics of using the shell, including the help system, command syntax, command discovery explaining the use of the two built-in host applications.

Lessons

  • Overview and Background
  • Finding and Learning Commands
  • Running Commands

Lab : Configuring Windows PowerShell

Lab : Finding and Running Basic Commands

After completing this module, students will be able to:
  • Open and configure Windows PowerShell
  • Discover, learn, and run Windows PowerShell commands
  • Run commands by using correct command and parameter syntax

Module 2: Working with the Pipeline

This module covers the Windows PowerShell pipeline along with a number of additional techniques and commands, including customizing command output, exporting and converting data, sorting objects, filtering objects, and enumerating objects allowing for the overall retrieval, manipulation and displaying of data.

Lessons

  • Understanding the Pipeline
  • Selecting, Sorting, and Measuring Objects
  • Converting, Exporting, and Importing Objects
  • Filtering Objects Out of the Pipeline
  • Enumerating Objects in the Pipeline

Lab : Using the Pipeline

Lab : Converting, Exporting, and Importing Objects

Lab : Filtering Objects

Lab : Enumerating Objects

After completing this module, students will be able to:
  • Describe the purpose of the Windows PowerShell pipeline 
  • Manipulate objects in the pipeline
  • Convert, export, and import objects
  • Filter objects out of the pipeline
  • Enumerate objects in the pipeline

Module 3: Understanding How the Pipeline Works

This module explains the underlying details of how Windows PowerShell passes objects from command to command within the pipeline. Having seen it in action in the previous module will now get to see some of the theory under the hood. The emphasis will be on two specific techniques used by the shell and students will learn to explain the pipeline operation, predict command behavior and allows them construct more useful, predictable commands.

Lessons

  • Passing Data in the Pipeline By Value
  • Passing Data in the Pipeline By Property Name

Lab : Working with Pipeline Parameter Binding

After completing this module, students will be able to:
  • Pass data by using the ByValue technique
  • Pass data by using the ByPropertyName technique

Module 4: Using PSProviders and PSDrives

This module explains the purpose and use of Windows PowerShell PSProviders and PSDrives, and shows students how to use these useful components for administrative tasks. Students will also learn to use the -item* commands to manipulate items within a PSDrive. 

Lessons

  • Using PSProviders
  • Using PSDrives

Lab : Using PSProviders and PSDrives

After completing this module, students will be able to:
    • Explain the purpose and use of PSProviders
    • Explain the purpose and use of PSDrives

Module 5: Formatting Output

This module demonstrates how to format command output and how to create custom output elements.Lessons

  • Using Basic Formatting
  • Using Advanced Formatting
  • Redirecting Formatted Output

Lab : Formatting Output

After completing this module, students will be able to:
  • Format command output by using basic formatting commands 
  • Format command output by using advanced formatting options
  • Redirect formatted output

Module 6: Querying Management Information by Using WMI and CIM

This module explains Windows Management Instrumentation (WMI) and Common Information Model (CIM), and shows students how to retrieve and in some cases modify management information about local and remote computers.

Lessons

  • Understanding WMI and CIM
  • Querying Data with WMI and CIM
  • Making Changes by Using WMI and CIM

Lab : Working with WMI and CIM

After completing this module, students will be able to:
  • Explain the differences between WMI and CIM
  • Query management information by using WMI and CIM
  • Invoke methods by using WMI and CIM

Module 7: Preparing for Scripting

This module prepares students for writing scripts with Windows PowerShell, covering the Windows PowerShell security model and the use of variables.

Lessons

  • Using Variables
  • Scripting Security

Lab : Working with Security in Windows PowerShell

After completing this module, students will be able to:
  • Create, use, and manage variables 
  • Configure shell scripting security

Module 8: Moving From a Command to Script to Module

This module shows students how to take a command that runs well in the console and turn it into a parameterized, reusable script, and how to evolve that script into a standalone script module. Students will learn the foundations needed to create their own reusable tools.

Lessons

  • Moving From Command to Script
  • Moving From Script to Function to Module
  • Implementing Basic Error Handling
  • Using Basic Scripting Constructs
  • Exploring Other Scripting Features

Lab : Moving From Command to Script

Lab : Moving From Script to Function to Module

Lab : Implementing Basic Error Handling

Lab : Creating an Advanced Function

After completing this module, students will be able to:
  • Move from Command to Script
  • Move from Script to Function to Module
  • Implement basic error handling
  • Implement basic scripting constructs
  • Explain additional advanced Windows PowerShell scripting features

Module 9: Administering Remote Computers

This module explains Windows PowerShell remoting, and shows students how to configure and use remoting to manage multiple remote computers.

Lessons

  • Using Basic Remoting
  • Using Advanced Remoting Techniques
  • Using Remoting Sessions

Lab : Using Basic Remoting

Lab : Using Remoting Sessions

After completing this module, students will be able to:
  • Describe remoting architecture and security, manually enable remoting, and use  remoting for one-to-one and one-to-many connections
  • Pass local variables to remote computers
  • Create and manage persistent remoting sessions, and use implicit remoting

Module 10: Putting it All Together

This module offers students an opportunity to use everything they have learned so far. Students will discover, learn, and run commands that perform a complex, real-world administrative task.

Lessons

  • Provisioning a New Server Core Instance

Lab : Provisioning a New Server Core Installation

After completing this module, students will be able to:
  • Plan your Windows PowerShell Script
  • Configure Server Core computers using Windows PowerShell

Module 11: Using Background Jobs and Scheduled Jobs

In this module students will learn to create and manage background jobs and scheduled jobs.

Lessons

  • Using Background Jobs
  • Using Scheduled Jobs

Lab : Using Background Jobs

Lab : Using Scheduled Jobs

After completing this module, students will be able to:
  • Create and manage Background Jobs
  • Create and manage Scheduled Jobs

Module 12: Using Profiles and Advanced PowerShell Techniques

This module covers a variety of additional advanced Windows PowerShell features and techniques including additional comparison operators, use of alternate credentials, creation of profile scripts, manipulation of strings and date objects.

Lessons

  • Using Advanced PowerShell Techniques
  • Creating Profile Scripts
  • Working With Alternative Credentials

Lab : Practicing Advanced Techniques

After completing this module, students will be able to:
  • Manipulate data and objects by using advanced techniques and operators 
  • Create and manage profile scripts
  • Connect to remote computers by using alternative credentials

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.

Course OD20345-1A:Administering Microsoft Exchange Server 2016

Choose how you want to learn: online or in a classroom 

Compare learning environments    

Classroom training

Learn more

Find a Microsoft Learning Partner     Find a classroom training partner
Anytime access     No
Anywhere access to recorded instructor     No
Microsoft official training content     Yes
In-depth training     Yes
Hands-on labs     Yes
SATV redemption     Yes
Ask instructor questions in person     Yes
Attend live class in person     Yes
Attend live class remotely     Yes
Time commitment     5 days

About this course

Audience(s): IT Professionals
Technology: Exchange
Level: 200
This Revision: A
Delivery method:
Classroom
Length: 2 days
Language(s): English
First published: 11 August 2016

Overview

About this course

This 5-day instructor-led 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 Exchange Management Shell to create and manage various recipient objects in Exchange Server 2016, and perform various tasks to automate Exchange management procedures.
  • Configure client connectivity to Exchange Server 2016, and manage Client Access services.
  • Implement and manage high availability.
  • Implement backup and disaster recovery for Exchange Server 2016.
  • Configure message transport options.
  • Configure message hygiene and security options.
  • Implement and manage Exchange Online deployments.
  • Monitor and troubleshoot Exchange Server 2016.
  • Secure and maintain Exchange Server 2016.

Course details

Course Outline

Module 1: Deploying Microsoft Exchange Server 2016

This module describes the key features and enhancements in Exchange Server 2016. The module also describes the deployment requirements and options for implementing Exchange Server 2016.

Lessons

  • Overview of Exchange Server 2016
  • Requirements and deployment options for Exchange Server 2016

Lab : Deploying Microsoft Exchange Server 2016

  • Evaluating requirements and prerequisites for an Exchange Server 2016 installation
  • Deploying Exchange Server 2016

After completing this module, students will be able to:

  • Describe the features and functionality of Exchange Server 2016.
  • Describe the requirements and deployment options for Exchange Server 2016.

 

Module 2: Managing Microsoft Exchange Server 2016 servers

This module describes the built-in management tools that you can use to manage maintain and maintain Exchange Server 2016. The module also explains the features and functionality of a Mailbox server role and procedures for configuring a Mailbox server.

Lessons

  • Exchange Server 2016 management
  • Overview of the Exchange 2016 Mailbox server
  • Configuring Mailbox servers

Lab : Configuring Mailbox servers

  • Creating and configuring mailbox databases

After completing this module, students will be able to:

  • Describe Microsoft Exchange Server 2016 management.
  • Describe the Exchange Server 2016 Mailbox server role.
  • Configure mailbox servers

Module 3: Managing recipient objects

This module describes the types of recipient objects in Exchange Server 2016, and explains how to manage these objects. The module also describes how to manage address lists and policies on the Mailbox server role.

Lessons

  • Exchange Server 2016 recipients
  • Managing Exchange Server recipients
  • Configuring address lists and policies

Lab : Managing Exchange Server recipients and public folders

  • Managing recipients
  • Managing public folder mailboxes

Lab : Managing Exchange Server email address lists and policies

  • Managing email-address policies
  • Managing address lists and address book policies

After completing this module, students will be able to:

  • Describe the different Microsoft Exchange Server 2016 recipients.
  • Manage Exchange Server 2016 recipients.
  • Configure address lists and policies.

Module 4: Managing Microsoft Exchange Server 2016 and recipient objects by using Exchange Management Shell

This module provides an overview of the Exchange Management Shell, and describes how to use it to manage Exchange Server 2016 configuration and recipient objects.

Lessons

  • Overview of the Exchange Management Shell
  • Managing Exchange Server 2016 by using Exchange Management Shell
  • Managing Exchange Server 2016 by using Exchange Management Shell scripts

Lab : Managing Exchange Server and recipient objects by using Exchange Management Shell

  • Using Exchange Management Shell to manage recipients
  • Using Exchange Management Shell to manage Exchange Server

After completing this module, students will be able to:

  • Explain the Exchange Management Shell cmdlets that you can use to configure and manage Microsoft Exchange Server 2016.
  • Manage Exchange Server and recipient objects by using the Exchange Management Shell.
  • Manage Exchange Server and recipient objects by using the Exchange Management Shell scripts.

Module 5: Implementing client connectivity

This module describes how to configure and manage Client Access Services in Exchange Server 2016. The module also explains the options for configuring client connectivity, Microsoft Outlook on the web, and mobile messaging.

Lessons

  • Configuring client access services in Exchange Server 2016
  • Managing client services
  • Client connectivity and publishing of Exchange Server 2016 services
  • Configuring Outlook on the web
  • Configuring mobile messaging on Exchange Server 2016

Lab : Deploying and configuring client access services on Exchange Server 2016

  • Configuring certificates for client access
  • Configuring client access options
  • Configuring custom MailTips

Lab : Deploying and configuring client access services on Exchange Server

  • Configuring Exchange Server 2016 for Outlook
  • Configuring Outlook on the web
  • Configuring Microsoft Exchange ActiveSync

After completing this module, students will be able to:

  • Configure client access services in Microsoft Exchange Server 2016.
  • Manage client services.
  • Describe client connectivity and publishing of Exchanger Server 2016 services.
  • Configure Microsoft Outlook on the web.
  • Configure mobile messaging on Exchange Server 2016.

Module 6: Module 6: Managing high availability in Exchange Server 2016

This module describes the high availability options built into Exchange Server 2016. The module also explains how to configure high availability for Mailbox databases and Client Access services.

Lessons

  • High availability on Exchange Server 2016
  • Configuring highly available mailbox databases
  • Configuring high availability of Client Access services.

Lab : Implementing DAGs

  • Creating and configuring a database availability group

Lab : Implementing and testing high availability

  • Deploying a high availability solution for client access services
  • Testing the high availability configuration

After completing this module, students will be able to:

  • Describe the high availability options in Exchange Server 2016.
  • Configure highly available mailbox databases. 
  • Configure highly available client access services.

Module 7: Implementing disaster recovery for Microsoft Exchange Server 2016

This module describes the backup and recovery options in Exchange Server 2016 and explains the factors you must consider when you use these options.

Lessons

  • Implementing Exchange Server 2016 backup
  • Implementing Exchange Server 2016 recovery

Lab : Backing up Exchange Server 2016

  • Backing up Exchange Server 2016

Lab : Implementing disaster recovery for Exchange Server 2016

  • Restoring Exchange Server 2016 data
  • Restore an Exchange Server DAG member (optional)

After completing this module, students will be able to:

  • Explain how to implement Microsoft Exchange Server 2016 backup.
  • Explain how to implement Exchange Server 2016 recovery.

Module 8: Configuring and managing message transport

This module provides an overview of message transport, and describes how to configure message transport. The module also describes how to configure transport rules and DLP policies to manage message transport.

Lessons

  • Overview of message transport
  • Configuring message transport
  • Managing transport rules

Lab : Configuring message transport

  • Configuring message transport
  • Troubleshooting message delivery
  • Configuring a disclaimer transport rule
  • Configuring a DLP policy for financial data

After completing this module, students will be able to:

  • Describe message transport.
  • Configure message transport.
  • Manage transport rules.

Module 9: Configuring antivirus, antispam, and malware protection

This module describes the key features and functionality of an Edge Transport server role in Exchange Server 2016. The module also explains how to configure message security by implementing an antivirus and antispam solution.

Lessons

  • Deploying and managing an Edge Transport server for message security
  • Implementing an antivirus solution for Exchange Server 2016
  • Implementing an antispam solution for Exchange Server 2016

Lab : Configuring message security

  • Configuring and testing EdgeSync
  • Configuring antivirus, antispam, and malware protection features on Exchange Server 2016

After completing this module, students will be able to:

  • Deploy and manage an Edge Transport server role for message security.
  • Implement an antivirus solution for Microsoft Exchange Server 2016.
  • Implement an antispam solution for Exchange Server 2016.

Module 10: Implementing and managing Microsoft Exchange Online deployments

This module describes the key features of Exchange Online and Office 365. The module also describes how to manage and migrate to Exchange Online.

Lessons

  • Overview of Exchange Online and Office 365
  • Managing Exchange Online
  • Implementing the migration to Exchange Online

Lab : Managing Exchange Online

  • Managing Exchange Online

After completing this module, students will be able to:

  • Provide an overview of Exchange Online and Office 365.
  • Manage Exchange Online.
  • Implement a migration to Exchange Online.

Module 11: Monitoring and troubleshooting Microsoft Exchange Server 2016

This module describes how to monitor and troubleshoot Exchange Server 2016. The module explains how to collect and analyze performance data for various Exchange Server recipients and objects. The module also describes how to troubleshoot database issues, connectivity issues, and performance issues.

Lessons

  • Monitoring Exchange Server 2016
  • Troubleshooting Exchange Server 2016

Lab : Monitoring and troubleshooting Exchange Server 2016

  • Monitoring Exchange Server
  • Troubleshooting database availability
  • Troubleshooting client access services

After completing this module, students will be able to:

  • Monitor Exchange Server 2016.
  • Troubleshoot Exchange Server 2016.

Module 12: Securing and maintaining Exchange Server 2016

This module describes how to maintain and update an Exchange Server organization. The module explains how to plan and configure administrative security and administrative auditing in Exchange Server 2016.

Lessons

  • Securing Exchange Server with role-based access control (RBAC)
  • Configuring audit logging on Exchange Server 2016
  • Maintaining Exchange Server 2016

Lab : Securing and maintaining Exchange Server 2016

  • Configuring Exchange Server permissions
  • Configuring audit logging
  • Maintaining updates on Exchange Server 2016.

After completing this module, students will be able to:

  • Configure RBAC on Microsoft Exchange Server 2016.
  • Configure options related to user and administrator audit logging.
  • Maintain and update Exchange Server 2016.

Prerequisites

Before attending this course, students must have:

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

Course OD20342B:Advanced Solutions of Microsoft Exchange Server 2013

er 2016

Choose how you want to learn: online or in a classroom 

Compare learning environments

 

 

Classroom training

Learn more

Find a Microsoft Learning Partner     Find a classroom training partner
Anytime access     No
Anywhere access to recorded instructor     No
Microsoft official training content     Yes
In-depth training     Yes
Hands-on labs     Yes
SATV redemption     Yes
Ask instructor questions in person     Yes
Attend live class in person     Yes
Attend live class remotely     Yes
Time commitment     5 days

About this course

Audience(s): IT Professionals
Technology: Exchange
Level: 300
This Revision: B
Delivery method:
Online
Length: 2 days
Language(s): English
First published: 12 May 2016

Overview

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.

Course details

Course Outline

Module 1: Designing and Implementing Site Resilience

This module explains how to design and implement site resilience for Exchange Server 2013.

Lessons

  • Site Resilience and High Availability in Exchange Server 2013
  • Planning a Site Resilient Implementation
  • Implementing Site Resilience

Lab : Designing and Implementing Site Resiliency

After completing this module, students will be able to design and implement site resilience for Exchange Server 2013.
 

Module 2: Planning Virtualization for Microsoft Exchange Server 2013

This module explains how to plan a virtualization strategy for Exchange Server 2013 roles.

Lessons

  • Planning a Hyper-V Deployment to Exchange Server 2013
  • Virtualizing Exchange Server 2013 Server Roles

Lab : Planning the Virtualization of Exchange Server Roles

After completing this module, students will be able to plan a virtualization strategy for Exchange Server 2013 roles.
 

Module 3: Overview of Exchange Server 2013 Unified Messaging

This module explains the basic concept of Unified Messaging in Exchange Server 2013.

Lessons

  • Overview of Telephony Technologies
  • Unified Messaging in Exchange Server 2013
  • Unified Messaging Components

Lab : Unified Messaging Overview

After completing this module, students will be able to explain the basic concept of Unified Messaging in Exchange Server 2013.
 

Module 4: Designing and Implementing Exchange Server 2013 Unified Messaging

This module explains how to design and implement Exchange Server 2013 Unified Messaging.

Lessons

  • Designing a Unified Messaging Deployment
  • Deploying and Configuring Unified Messaging Components
  • Designing and Implementing Exchange Server 2013 UM Integration with Lync Server 2013

Lab : Designing and Implementing Exchange Server 2013 Unified Messaging

After completing this module, students will be able to design and implement Exchange Server 2013 Unified Messaging.
 

Module 5: Designing and Implementing Message Transport Security

This module explains how to design and implement message transport security.

Lessons

  • Overview of Messaging Policy and Compliance Requirements
  • Designing and Implementing Transport Compliance
  • Designing and Implementing AD RMS Integration with Exchange Server 2013

Lab : Designing and Implementing Message Transport Security

After completing this module, students will be able to design and implement message transport security.

 

Module 6: Designing and Implementing Message Retention

This module explains how to design and implement message retention in Exchange Server 2013.

Lessons

  • Overview of Messaging Records Management and Archiving
  • Designing In-Place Archiving
  • Designing and Implementing Message Retention

Lab : Designing and Implementing Message Retention

After completing this module, students will be able to design and implement message retention in Exchange Server 2013.
 

Module 7: Designing and Implementing Messaging Compliance

This module explains how to design and implement messaging compliance.

Lessons

  • Designing and Implementing Data Loss Prevention
  • Designing and Implementing In-Place Hold
  • Designing and Implementing In-Place eDiscovery

Lab : Designing and Implementing Messaging Compliance

After completing this module, students will be able to design and implement messaging compliance.
 

Module 8: Designing and Implementing Administrative Security and Auditing

This module explains how to design and implement administrative security in an Exchange Server 2013 environment.

Lessons

  • Designing and Implementing Role-Based Access Control (RBAC)
  • Designing and Implementing Split Permissions
  • Planning and Implementing Audit Logging

Lab : Designing and Implementing Administrative Security and Auditing

After completing this module, students will be able to design and implement administrative security in an Exchange Server 2013 environment.
 

Module 9: Managing Exchange Server 2013 with Exchange Management Shell

This module explains how to use Windows PowerShell 3.0 to manage Exchange Server 2013.

Lessons

  • Overview of Windows PowerShell 3.0
  • Managing Exchange Server Recipients by Using the Exchange Management Shell
  • Using Windows PowerShell to Manage Exchange Server

Lab : Managing Microsoft Exchange Server 2013 by Using Exchange Management Shell

After completing this module, students will be able to use Windows PowerShell 3.0 to manage Exchange Server 2013.
 

Module 10: Designing and Implementing Integration with Microsoft Exchange Online

This module explains how to design and implement integration with Exchange Online.

Lessons

  • Planning for Exchange Online
  • Planning and Implementing the Migration to Exchange Online
  • Planning to Coexist with Exchange Online

Lab : Designing Integration with Exchange Online

After completing this module, students will be able to design and implement integration with Exchange Online.
 

Module 11: Designing and Implementing Messaging Coexistence

This module explains how to design and implement messaging coexistence.

Lessons

  • Designing and Implementing Federation
  • Designing Coexistence Between Exchange Server Organizations
  • Designing and Implementing Cross-Forest Mailbox Moves

Lab : Implementing Messaging Coexistence

After completing this module, students will be able to design and implement messaging coexistence.
 

Module 12: Designing and Implementing Exchange Server Upgrades

This module explains how to design and implement upgrades from previous Exchange Server versions.

Lessons

  • Planning the Upgrade from Previous Exchange Server Versions
  • Implementing the Upgrade from Previous Exchange Versions

Lab : Upgrading from Exchange Server 2010 to Exchange Server 2013

After completing this module, students will be able to design and implement upgrades from previous Exchange Server versions.

Prerequisites

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

 

  • Passed 70-341: Core Solutions of Microsoft Exchange Server 2013, or equivalent
  • Minimum of two years of experience working with Exchange Server
  • Minimum of six months of experience working with Exchange Server 2010 or 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
  • Minimum of two years of experience working with name resolution, including DNS
  • Experience working with certificates, including public key infrastructure (PKI) certificates
  • Experience working with Windows PowerShell

 

Students who attend this training can meet the prerequisites by attending the following courses, or by obtaining equivalent knowledge and skills:

 

  • Course 20341: Core Solutions of Microsoft Exchange Server 2013