Microsoft Certifications

MS20532 – Developing Microsoft Azure Solutions

About this course

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

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

Audience Profile

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

At course completion

After completing this course, students will be able to:

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

About this course

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

Audience Profile

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

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

At course completion

After completing this course, students will be able to:

  • Describe Azure architecture components, including infrastructure, tools, and portals.
  • Implement and manage virtual networking within Azure and connect to on-premises environments.
  • Plan and create Azure virtual machines.
  • Configure, manage, and monitor Azure virtual machines to optimize availability and reliability.
  • Deploy and configure web apps and mobile apps.
  • Implement, manage, backup, and monitor storage solutions.
  • Plan and implement data services based on SQL Database to support applications.
  • Deploy, configure, monitor, and diagnose cloud services.
  • Create and manage Azure AD tenants, and configure application integration with Azure AD.
  • Integrate on-premises Windows AD with Azure AD.
  • Automate operations in Azure management by using automation.

 

MS10978 - Introduction to Azure™ for Developers

About this course

This course offers students the opportunity to take an existing ASP.NET MVC application and expand its functionality as part of moving it to Azure.  This course focuses on developing in Azure using Storage, Cloud Services, Service Bus, Active Directory, WebSites and SQL among other features.  This course also focuses on using the provided .NET SDKs, REST APIs, configuration and deployment options related to Azure.

Audience Profile

The developers targeted by this training are web application developers who have 6-12 months of web development experience using ASP.NET and C#.  Said developers are interested in deploying their ASP.NET applications to Azure, integrating the applications with the Azure services and using best practices to build a highly scalable application.

This course is intended for students who have the following experience:

  • 6-12 months experience developing ASP.NET Web applications using C#

At course completion

After completing this course, students will be able to:

  • Describe Azure and the capabilities that it provides to application developers.  Students will also be able to use the Management Portal to effectively navigate the Azure platform and their deployed applications.
  • Use the Management Portal to create, modify, scale and dispose of Azure services.  The students will also use alternative (PowerShell, REST) methods for managing Azure services.
  • Create and host a simple website using Azure Websites.  Students will learn how to monitor and manage the website using the Management Portal.
  • Build a modular web application and host it using Azure Cloud Service Web Roles.
  • Use Cloud Service Worker Roles to process data in the background.  Students will also be able to use Cloud Service Cache Roles to store data in the cache.
  • Use Azure SQL to store and retrieve data.
  • Store data in Azure Table Storage.
  • Store and access multimedia files in Azure using Blob Storage.
  • Use Azure Queue Storage to queue data for asynchronous processing.  Students will also learn how to use Azure Service Bus Queues for queuing data.
  • Use the Azure Service Bus Relay to connect on-premise services with client applications.
  • Use Azure Service Bus Notification Hubs to publish messages to client applications.
  • Use Azure Active Directory to implement security in a Cloud web application.
  • Deploy web applications to Azure by using WebDeploy and Service Packages.
  • Use Azure Mobile Services to provide a scalable and secure web service for mobile applications.
MS55065 - Microsoft Azure for IT Professionals

Who should attend

This course is intended for IT professionals looking to evaluate or deploy Microsoft Azure.

Class Prerequisites

Before attending this course, students should have:

  • Deep understanding of Virtualization technologies
  • Understanding of cloud computing
  • Prior experience with Hyper-V or other virtualization technologies
  • Previous storage configuration experience
  • Previous networking configuration experience

What You Will Learn

After completing this course, students will be able to:

  • Deploy Azure Virtual Machines
  • Deploy Azure Web Sites
  • Deploy Azure Cloud Services
  • Understand Azure Active Directory
  • Manage Azure Storage
  • Migrate on-premises Virtual Machines and VHDs to Microsoft Azure
  • Configure Virtual Networks
  • Configure cross-premises communication
  • Understand Azure SQL Database
  • Understand Azure Recovery
  • Understand the Windows Azure Pack
MS20415 - Implementing a Desktop Infrastructure

About this course

The course provides guidance on planning and deploying desktops by using several technologies such as User State Migration Tool (USMT),  Microsoft Deployment Toolkit (MDT), Virtual Desktop Infrastructure (VDI), and more. Additionally, the course describes how to protect desktops and monitor their health and performance.

Audience profile

The course is primarily intended for IT Professionals who manage the desktop environments for organizations, and want to specialize in Windows® 8 desktop deployments. These IT professionals typically work in complex computing environments of large to enterprise-sized organizations. In addition. the secondary audience for this course includes IT professionals who want to take the 70-415: Implementing an Enterprise Desktop and Device Infrastructure exam as a stand-alone, or as part of the requirement for the MCSE: Desktop Infrastructure certification.

At course completion

After completing this course, students will be able to:

  • Assess and determine desktop deployment options.
  • Plan an image management strategy.
  • Implement desktop security.
  • Capture and manage a desktop operating system image.
  • Plan and implement User State Migration.
  • Plan and deploy desktops by using the Microsoft Deployment Toolkit.
  • Plan and deploying desktops by using System Center 2012 Configuration Manager.
  • Plan and  implement a Remote Desktop Services infrastructure.
  • Manage user state virtualization for enterprise desktops.
  • Plan and implement an updates infrastructure to support enterprise desktops.
  • Protect enterprise desktops from malware and data loss.
  • Monitoring the performance and health of the desktop infrastructure.
MS20416 - Implementing Desktop Application Environments (MS20416)

About this course

This course, build the skills you need to design, deploy, and manage a physical and virtual Windows Server® 2012 application management infrastructure, and focus on using Microsoft System Center 2012 Service Pack 1 (SP1). You will also learn to design, deploy, and manage Windows® 8 Enterprise applications in a physical and virtual environment and in the cloud. This course is designed for experienced IT professionals who support medium to large enterprises, have previous experience working with operating systems running Windows Server, have their Windows 2012 Server certification (MCSA), and have taken course 20413: Designing and Implementing a Server Infrastructure or have equivalent skills.   Note: This course maps to the skills and knowledge measured by Microsoft Exam 70-416: Implementing Desktop Application Environments.

Audience profile

This course is intended for Information Technology professionals who are interested in specializing in Windows 8 application deployments and managing the application environments for large organizations. People attending this training could be support technicians or currently in deployment roles and are considering taking the next step in their career or enhancing their skills in the areas of planning and deploying Windows 8 desktops.

A secondary audience for this course is IT professionals who are looking to take one or both exams: 70‑415: Implementing an Enterprise Desktop and Device Infrastructure and 70‑416: Implementing Desktop Application Environments as a stand-alone, or as part of the requirement for the MCSE: Desktop Infrastructure certification.

At course completion

After completing this course, students will be able to:

  • Design an application distribution strategy that is appropriate for an organizational environment.
  • Diagnose and remediate application compatibility problems for desktop and presentation virtualization-based deployments.
  • Use Group Policy and Windows Intune™ to deploy applications to client devices.
  • Deploy applications centrally using System Center 2012 Configuration Manager SP1.
  • Configure self-service application deployment using System Center 2012 Configuration Manager SP1, System Center 2012 Service Manager SP1, and Windows Store apps.
  • Design and deploy Windows Server 2012 roles and features to support presentation virtualization.
  • Prepare, deploy and manage applications for Remote Desktop, RemoteApp, and Remote Desktop Web Access.
  • Design and deploy Windows Server 2012 roles and features to support application virtualization.
  • Virtualize and deploy applications by using App-V and System Center 2012 Configuration Manager SP1.
  • Plan and configure the appropriate infrastructure to streamline the deployment of software updates to applications, and plan and configure application security.
  • Plan and implement application upgrades, supersedence, and application coexistence.
  • Monitor the deployment, performance, and utilization of applications and determine whether current application hosting platforms are meeting business needs.
MS10748 - Planning and Deploying System Center 2012 Configuration Manager

About this course

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

 

This course also helps candidates prepare for Exam 70-243, MCTS: Administering and Deploying System Center 2012 Configuration Manager. Both Configuration Manager courses, 10747D and 10748C, or the equivalent knowledge and skills will be necessary to prepare for the exam.
NOTE: Windows Intune is used as part of the lab for this course, which may not be available in all countries. Please confirm with your Microsoft training provider that this cloud service is available in your area. Training Providers: please reference the course setup guide for more details.

Audience profile

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

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

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

At course completion

After completing this course, students will be able to:

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

About this course

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

 

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

 

This course uses Visual Studio 2012, running on Windows 8.

Audience profile

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

This course is intended for students who have the following experience:

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

This course is not intended for developers with three or more months of HTML5 coding experience.

 

Students choosing to attend this course without a developer background should pay special attention to the training prerequisites. Developers who have more than 5 years programming experience may find that portions of this training are fundamental in nature when presenting the syntax associated with certain programming tasks.

 

Individuals who are interested in taking exam 70-480: Programming in HTML5 with JavaScript and CSS3, can also attend this course.

At course completion

After completing this course, students will be able to:

  • Explain how to use Visual Studio 2012 to create and run a Web application.
  • Describe the new features of HTML5, and create and style HTML5 pages.
  • Add interactivity to an HTML5 page by using JavaScript.
  • Create HTML5 forms by using different input types, and validate user input by using HTML5 attributes and JavaScript code.
  • Send and receive data to and from a remote data source by using XMLHTTPRequest objects and jQuery AJAX operations.
  • Style HTML5 pages by using CSS3.
  • Create well-structured and easily-maintainable JavaScript code.
  • Use common HTML5 APIs in interactive Web applications.
  • Create Web applications that support offline operations.
  • Create HTML5 Web pages that can adapt to different devices and form factors.
  • Add advanced graphics to an HTML5 page by using Canvas elements, and by using and Scalable Vector Graphics.
  • Enhance the user experience by adding animations to an HTML5 page.
  • Use Web Sockets to send and receive data between a Web application and a server.
  • Improve the responsiveness of a Web application that performs long-running operations by using Web Worker processes.
MS20481 - Essentials of Developing Windows® Store Apps Using HTML5 and JavaScript

About this course

Audience profile

At course completion

After completing this course, students will be able to:

  • Describe the Windows 8 platform and features, and explore the basics of a Windows app interface.
  • Create the User Interface layout and structure.
  • Apply the MVVM pattern to application design.
  • Implement the AppBar and layout controls.
  • Use templates to create the UI.
  • Use data binding to present data in the UI.
  • Handle files and streams.
  • Design and implement Process Lifetime Management (PLM).
  • Handle navigation scenarios in a Windows Store app.
  • Implement Semantic Zoom.
  • Design and implement contracts such as Search, Share and Settings.
  • Implement tiles and toast notifications in a Windows Store app.
  • Respond to mouse, keyboard and touch events, including gestures.
  • Deploy a Windows Store app to the Windows Store or an enterprise store.
MS20482 - Advanced Windows® Store App Development Using HTML5 and JavaScript

About this course

This course will teach you advanced programming practices and techniques that will help you develop Windows Store apps. In this course, you will learn how design and develop Windows Store apps, as well as implement advanced features, such as using location information, streaming media to external devices, and integrating with online services. You will also learn how to use Microsoft Visual Studio 2013 and Expression Blend tools.

 

This course maps to the 70-482 exam.

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

Audience profile

This course is intended for professional developers who have one or more years of experience creating

applications for a production environment and who are comfortable programming in HTML5, JavaScript and CSS to create Windows Store apps.

At course completion

After completing this course, students will be able to:

  • Add animations and transitions in a Windows Store app to improve the user experience.
  • Localize the Windows Store app UI.
  • Brand the Windows Store app and improve the loading experience with a splash screen.
  • Use various storage mechanisms, choose a suitable caching strategy for their Windows Store app, and use advanced file access methods.
  • Create custom controls, extend templated controls, and create and consume WinMD components.
  • Implement the Print and Settings contracts and the Play To API.
  • Work with the Push Notification Service (WNS).
  • Capture media with the camera and microphone.
  • Create and consume background tasks.
  • Discover device capabilities, interact with devices, and act upon sensor data.
  • Implement Windows Store trial licensing and in-app purchasing and advertising.
  • Understand how to manage Windows authentication and web authentication in Windows Store apps.
  • Diagnose problems and monitor application behavior by using tracing and profiling tools and APIs.
MS20483 - Programming in C#

About this course

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

 

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

 

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

 

At the end of the course, students should leave the class with a solid knowledge of C# and how to use it to develop .NET Framework 4.5 applications.

 

This course uses Visual Studio 2012, running on Windows 8.

Audience profile

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

 

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

At course completion

After completing this course, students will be able to:

 

  • Describe the core syntax and features of C#.
  • Create and call methods, catch and handle exceptions, and describe the monitoring requirements of large-scale applications.
  • Implement the basic structure and essential elements of a typical desktop application.
  • Create classes, define and implement interfaces, and create and use generic collections.
  • Use inheritance to create a class hierarchy, extend a .NET Framework class, and create generic classes and methods.
  • Read and write data by using file input/output and streams, and serialize and deserialize data in different formats.
  • Create and use an entity data model for accessing a database and use LINQ to query and update data.
  • Use the types in the System.Net namespace and WCF Data Services to access and query remote data.
  • Build a graphical user interface by using XAML.
  • Improve the throughput and response time of applications by using tasks and asynchronous operations.
  • Integrate unmanaged libraries and dynamic components into a C# application.
  • Examine the metadata of types by using reflection, create and use custom attributes, generate code at runtime, and manage assembly versions.
  • Encrypt and decrypt data by using symmetric and asymmetric encryption.
MS20484 - Essentials of Developing Windows® Store Apps Using C#

About this course

In this course students will learn essential programming skills and techniques that are required to develop Windows Store apps. This includes a combination of both design and development skills, as well as ensuring that students are comfortable using and making the most of the Microsoft Visual Studio and Expression Blend tools.

 

This course maps to the 70-484 exam.

Audience profile

This course is intended for professional developers who have 1 to 2 years of experience creating client applications and who are comfortable programming in C# and have done some XAML-based programming.

At course completion

After completing this course, students will be able to:

  • Describe the Windows 8.1 platform and features, and explore the basics of a Windows app interface.
  • Create the User Interface layout and structure by using XAML.
  • Use data binding to present data in the UI.
  • Implement the AppBar and layout controls.
  • Handle files and streams.
  • Respond to application lifecycle events using Process Lifetime Management and the PLM extensibility points provided by the Visual Studio 2013 templates.
  • Use templates to create the UI.
  • Handle navigation scenarios in a Windows Store app.
  • Design and implement contracts such as Search, Share and Settings.
  • Implement tiles and toast notifications in a Windows Store app.
  • Respond to mouse, keyboard and touch events, including gestures.
  • Deploy a Windows Store app to the Windows Store or an enterprise store.
MS20485 - Advanced Windows® Store App Development Using C#

About this course

This course you will learn advanced programming practices and techniques that will help you develop Windows Store apps. In this course, you will learn how design and develop Windows Store apps, as well as implement advanced features, such as using location information, streaming media to external devices, and integrating with online services. You will also learn how to use Microsoft Visual Studio 2013 and Expression Blend tools.

This course maps to the 70-485 exam.

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

Audience profile

This course is intended for professional developers who have one or more years of experience creating applications for a production environment and who are comfortable programming in C# and XAML to create Windows Store apps.

At course completion

After completing this course, students will be able to:

  • Review basic Windows Store app concepts and how Windows Store apps integrate with the Windows 8.1 ecosystem.
  • Explore the built-in WinRT animation library and storyboards, and apply transitions and transformations.
  • Localize the Windows Store app UI and apply language-specific formatting to a multi-lingual app.
  • Create and present a successful splash screen, and differentiate your app with branding.
  • Use various storage mechanisms, choose a suitable caching strategy for their app, and use advanced file access methods.
  • Work with custom and template controls, and create and consume a WinRT component.
  • Print using the Printing API and explore the Play To API.
  • Explore the Push Notification Service (WNS), and work with push notifications.
  • Use the CameraCaptureUI API and the MediaCapture API.
  • Create and consume background tasks.
  • Discover sensors, test their availability, and handle sensor events and device availability, and enumerate devices and their capabilities and properties and use the capabilities.
MS20486 - Developing ASP.NET MVC 4 Web Applications

About this course

In this course, students will learn to develop advanced ASP.NET MVC applications using .NET Framework 4.5 tools and technologies. The focus will be on coding activities that enhance the performance and scalability of a web application. ASP.NET MVC will be introduced and compared with Web Forms so that students know when each should/could be used. This course will also prepare the students for the exam 70-486.

Audience profile

This course is intended for professional web developers who use Microsoft Visual Studio in an individual-based or team-based, small-sized to large development environment. Candidates for this course are interested in developing advanced web applications and want to manage the rendered HTML comprehensively. They want to create websites that separate the user interface, data access, and application logic.

At course completion

After completing this course, students will be able to:

  • Describe the Microsoft Web Technologies stack and select an appropriate technology to use to develop any given application.
  • Design the architecture and implementation of a web application that will meet a set of functional requirements, user interface requirements, and address business models.
  • Create MVC Models and write code that implements business logic within Model methods, properties, and events.
  • Add Controllers to an MVC Application to manage user interaction, update models, and select and return Views.
  • Create Views in an MVC application that display and edit data and interact with Models and Controllers.
  • Run unit tests and debugging tools against a web application in Visual Studio 2012 and configure an application for troubleshooting.
  • Develop a web application that uses the ASP.NET routing engine to present friendly URLs and a logical navigation hierarchy to users.
  • Implement a consistent look and feel, including corporate branding, across an entire MVC web application.
  • Use partial page updates and caching to reduce the network bandwidth used by an application and accelerate responses to user requests.
  • Write JavaScript code that runs on the client-side and utilizes the jQuery script library to optimize the responsiveness of an MVC web application.
  • Implement a complete membership system in an MVC 4 web application.
  • Build an MVC application that resists malicious attacks and persists information about users and preferences.
  • Describe how to write a Windows Azure web service and call it from and MVC application.
  • Describe what a Web API is and why developers might add a Web API to an application.
  • Modify the way browser requests are handled by an MVC application.
  • Describe how to package and deploy an ASP.NET MVC 4 web application from a development computer to a web server for staging or production.
MS20487 - Developing Windows Azure™ and Web Services

About this course

In this course, students will learn how to design and develop services that access local and remote data from various data sources. Students will also learn how to develop and deploy services to hybrid environments, including on-premises servers and Windows Azure. This course helps people prepare for exam 70-487.

Audience profile

This course is intended for both novice and experienced .NET developers who have a minimum of six months programming experience, and want to learn how to develop services and deploy them to hybrid environments.

At course completion

After completing this course, students will be able to:

  • Query and manipulate data with Entity Framework
  • Use ASP.NET Web API to create HTTP-based services and consume them from .NET and non-.NET clients
  • Extend ASP.NET Web API services using message handlers, model binders, action filters, and media type formatters
  • Create SOAP-based services with the Windows Communication Foundation (WCF) and consume them from .NET clients
  • Apply design principles to service contracts and extend WCF services using custom runtime components and behaviors
  • Secure WCF services using transport and message security
  • Use Windows Azure Service Bus for relayed messaging and brokered messaging using queues and topics
  • Host services on on-premises servers, and on various Windows Azure environments, such as Web Roles, Worker Roles, and Web Sites
  • Deploy services to both on-premises servers and Windows Azure
  • Store and access data in Windows Azure Storage, and configure storage access rights
  • Monitor and log services, both on-premises and in Windows Azure
  • Implement federated authentication by using ACS with ASP.NET Web API services
  • Create scalable, load-balanced services
MS55187 - Linux System Administration

About this course

This course is designed to provide students with the necessary skills and abilities to work as a professional Linux system administrator. The course covers how to administer, configure and upgrade Linux systems running one of the three major Linux distribution families: Red Hat, SUSE, Debian/Ubuntu, how to master the tools and concepts you’ll need to efficiently build and manage an enterprise Linux infrastructure. It also covers how to use state-of-the-art system administration techniques in real-life scenarios via practical labs. This course prepares the user for the Linux Foundation Certified System Administrator (LFCS) exam, which is also a required component of the MCSA: Linux on Azure Certification.

Audience profile

This course is intended for students with a basic knowledge of Linux and its most common utilities and text editors. For users with no prior experience we suggest the free ‘Introduction to Linux’ course available on edx.org

At course completion

After completing this course, students will be able to:

  • Perform essential Linux commands such as installation, searches and manipulating files.
  • Operate running Linux systems by managing the boot process, scheduling jobs, updating the system, monitoring system performance and managing security.
  • Manage users and groups by adding/deleting/modifying, configuring LDAP and PAM, modifying user processes and resources.
  • Ensure network performance via configuration, monitoring, tunnelling and routing of traffic.
  • Configure services such as DNS, shares, SSH and SELinux/AppArmor as well as servers for DHCP and HTTP.
  • Manage system storage by using partitions, logical volumes, phsyical volumes, ACLs, quotas and clustering.
MS80542 - Customization and Configuration in Microsoft Dynamics® CRM

About this course

This course describes the techniques required to customize Microsoft Dynamics CRM to meet the specialized needs of businesses. The topics covered include security; creation and configuration of entities; design of forms views and charts; auditing and solutions. The course describes each topic and how each topic relates to the other topics to produce a full configured, effective solution.

Audience profile

This training is intended for both novice and experienced customizers of Microsoft Dynamics CRM who are familiar with the end-user principles of the software. No programming skills are required, but a basic understanding of database principles will be an advantage.

At course completion

  • Design and implement strategies for the creation of Business Units and Security Roles
  • Configure Microsoft Dynamics CRM Users and Teams
  • Describe the principles of customizing the system
  • Create and configure fields for both custom and system entities
  • Create and configure custom entities, including standard and activity entities
  • Design, create and configure relationships between entities
  • Create and configure Views, Charts and Forms for both system and custom entities
  • Implement Field Security and Access Team Templates in Microsoft Dynamics CRM
  • Design, create and configure Solutions in Microsoft Dynamics CRM
  • Design, create and configure Business Rules and Business Process Flows to guide users through their work
MS80545 - Customer Service in Microsoft Dynamics CRM

About this course

This course focuses on how an organization can nurture customer satisfaction through automation of business processes within Microsoft Dynamics CRM 2013.  This course provides an insight into all of the powerful Customer Service and Service Scheduling functionality capabilities within Microsoft Dynamics CRM 2013.

 

Additionally, this course guides you through the process of working with your customers in Microsoft Dynamics CRM 2013, including: resolution of customer complaints and services issues cost effectively, and provides insight on managing  all related correspondence, documents, contacts and conversations. This course demonstrates the rich and relevant view of your customer that provides your team with actionable insights, including the use of knowledge management in a centralized knowledge base.

Audience profile

This course is intended for individuals that plan to implement, use, maintain, or support Microsoft Dynamics CRM 2013 in their organization. The training is intended for customer service representatives, service schedulers, administrators, office managers, CEOs, and consultants who want to gain foundational knowledge of the application functionality.

At course completion

After completing this course, students will be able to:

  • Identify the key set of terms, phrases and elements to effectively work with Customer Service Scenarios and Terminology
  • Recognize why cases are the fundamental record type in service management, and represent a single incident of service.
  • Use Queues to organize and store Activities and Cases that are waiting to be processed.
  • Effectively search the Knowledge Base to access a repository of informational articles used to assist customer service representatives in the resolution of cases.
  • Utilize Contract Management to specify the amount of support services a customer is entitled to.
  • Use reporting functionality to gain insight into trends, performance, and identifying opportunities and potential issues.
  • Practice Goal Management features to establish and track progress against target values for key performance indicators.
  • Use the Service scheduling functionality and how it is designed to assist organizations when providing services that require complex combinations of resources.
MS80546 - Sales Management in Microsoft Dynamics® CRM

About this course

This course introduces the capabilities of Sales Management in Microsoft Dynamics CRM 2013 that allow you to track and manage the sales process from potential to close. This course provides insight on sales process information, and introduces the tools available to analyze and report on sales information.

 

This course guides you through the tools that help make the internal processes simpler and easier so your sales force can focus on what is important—creating a differentiated experience for your customers.

Audience profile

This course is intended for individuals that plan to implement, use, maintain, or support Microsoft Dynamics CRM 2013 in their organization. The training is intended for sales representatives, administrators, office managers, CEOs, and consultants who want to learn the available sales features within Microsoft Dynamics CRM 2013.

At course completion

After completing this course, students will be able to:

  • Understand the context of Sales Management and review real-life sales scenarios
  • Identify how the various elements of the Microsoft Dynamics CRM 2013 Sales fit together
  • Review the basic terminology used throughout the application.
  • Review how the basic flow of sales activity in Microsoft Dynamics CRM begins with the entry of leads, and review ways to manage leads in Microsoft Dynamics CRM
  • Identify the role of leads, and when they can be used
  • Know the Lead to Opportunity process and the roles of these records.
  • Work with Sales Literature in Microsoft Dynamics CRM.
  • Explore the steps to create and maintain Competitors.
  • Identify the features and benefits of the product catalog.
  • Create and maintain unit groups for the product catalog.
  • Add products to the product catalog, and describe the use of kit products and substitute products.
  • Create price lists and configure as appropriate for different customers, marketing campaigns and special offers.
  • Set up different price lists for different types of customers and marketing campaigns
  • Utilize the tools to available within Microsoft Dynamics CRM to capture important sales information and uncover new business opportunities.
  • Identify how Goal Management enables organizations to manage and analyze performance.
  • Use the Sales Analysis tools that Microsoft Dynamics CRM provides analyze and report on sales-related information
MS80539 - Installation and Deployment in Microsoft Dynamics® CRM

About this course

This course provides individuals with the skills to install and deploy Microsoft Dynamics CRM 2013. The training material focuses on the components used within a Microsoft Dynamics CRM deployment, the hardware and software requirements needed to successfully deploy Microsoft Dynamics CRM, and the installation instructions for the primary Microsoft Dynamics CRM components: the Microsoft Dynamics CRM Server, the E-Mail Router, and Microsoft Dynamics CRM for Office Outlook. The course also covers upgrading from earlier versions,  configuring an Internet-facing Deployment and administration tasks.

Audience profile

This course is intended for implementation consultants, system integrators, or support professionals who need to install and deploy Microsoft Dynamics CRM 2013.

At course completion

After completing this course, students will be able to:

  • Describe the components that are required for a successful Microsoft Dynamics CRM implementation.
  • Identify the hardware and software requirements for components of a Microsoft Dynamics CRM implementation.
  • Install Microsoft Dynamics CRM Server.
  • Install Microsoft Dynamics CRM Reporting Extensions.
  • Install and configure the Microsoft Dynamics CRM E-mail Router.
  • Describe the deployment methods for installing Microsoft Dynamics CRM for Outlook.
  • Configure Claims-based authentication and Internet-facing deployment.
  • Upgrade to Microsoft Dynamics CRM 2013.
  • Manage Microsoft Dynamics CRM organizations using the Deployment Manager.
  • Describe the high availability options for Microsoft Dynamics CRM 2013.
MS20398 - Planning for and Managing Devices in the Enterprise

About this course

This course teaches IT professionals how to use the Enterprise Mobility Suite to manage devices, users, and data. In addition, this course teaches students how to use other technologies, such as Group Policy and other Windows Server–based technologies, to manage devices and secure data. Students will learn how to design and implement cloud-based and on-premises solutions for managing Windows-based, iOS, and Android devices, and they will learn how to provide secure and efficient access to data and applications.

Audience profile

This course is intended for IT professionals and consultants who plan, deploy, and manage devices and applications in medium to large organizations. A significant portion of this audience works in on-premises Active Directory Domain Services (AD DS) environments with both domain-joined and non-domain joined devices, for which they need to provide mobile device management and secure data access. Devices in such environments typically run Windows 10, Windows 10 Mobile, iOS, and Android. They plan to extend on-premises AD DS to the cloud and they need to learn how to plan and implement Enterprise Mobility Suite.

At course completion

After completing this course, students will be able to:

  • Use devices in the enterprise environment.
  • Implement and administer Microsoft Azure Active Directory (Azure AD).
  • Connect AD DS with Azure AD.
  • Manage devices in Microsoft Office 365.
  • Plan and implement Intune.
  • Use Intune to manage devices.
  • Plan and implement app support.
  • Use Intune to manage applications and Resource Access.
  • Plan and implement Microsoft Azure Rights Management (Azure RMS).
  • Plan and implement Remote Access.
  • Plan and implement Dynamic Access Control and auditing.
  • Plan and protect data.
  • Recover data and operating systems.
MS55021 - Configuring and Administering Hyper-V in Windows Server 2012

About this course

This course provides students with the knowledge and skills to configure and administer Hyper-V in Windows Server 2012. Students will learn the history of Virtualization as it pertains to Microsoft technologies. Students will learn the new features of Hyper-V in Windows Server 2012. After completing this course students will be able to install, configure, and administer Hyper-V in Windows Server 2012. Students will also be able to describe the High Availability features built into Hyper-V in Windows Server 2012.

Audience profile

This course is intended for Network Administrators who are responsible for virtualization in their environment specifically Hyper-V.

At course completion

After completing this course, students will be able to:

  • Describe Microsoft’s virtualization technologies.
  • Implement Hyper-V.
  • Design and Manage virtual machine storage solutions.
  • Design and Manage virtual networks.
  • Design the Hyper-V host architecture.
  • Design the virtual machine architecture.
  • Design a Windows Server 2012 Hyper-V Virtualization Infrastructure.
  • Describe and manage Hyper-V Snapshots
  • Describe Hyper-V host and virtual machine high availability.
  • Describe storage options for Virtual Machines.
  • Describe the different types of virtual hard disks.
  • Describe the Hyper-V integration services.
  • Describe Live Migration.
  • Understand Storage Migration.
  • Understand Virtual Machine Import.
MS55011 - The ITIL Foundation Certificate in IT Service Management

About this course

This course provides students with the knowledge of ITIL terminology, structure and basic concepts and comprehension of core principles of ITIL practices for service management required to sit for the for ITIL Foundation certificate in IT Service Management certification examination. Candidates for the ITIL Foundation certificate in IT service management have to complete all units and successfully pass the corresponding examination to achieve certification. The ITIL Foundation certificate in IT Service Management is not intended to enable the holders of the certificate to apply the ITIL practices for service management without further guidance.

Upon completion of the course, candidates may sit the optional ITIL Foundation examination leading to the ITIL Foundation Certificate in IT Service Management. Sixty (60) minutes (75 minutes and the use of a dictionary for those taking the examination in a language other than their first language) is allowed for the closed-book, supervised examination which may be online or paper-based. The examination is a multiple choice format that consists of forty (40) questions.

Audience profile

The target group of the ITIL Foundation certificate in IT Service Management is drawn from:

  • Individuals who require a basic understanding of the ITIL framework and how it may be used to enhance the quality of IT service management within an organization.
  • IT professionals that are working within an organization that has adopted and adapted ITIL who need to be informed about and thereafter contribute to an ongoing service improvement program.

 

This may include but is not limited to, IT professionals, business managers and business process owners.

At course completion

After successful completion of the education and examination components related to this certification, students can expect to gain knowledge and understanding in the following:

  • Service management as a practice (comprehension)
  • The ITIL service lifecycle (comprehension)
  • Generic concepts and definitions (awareness)
  • Key principles and models (comprehension)
  • Selected processes (awareness)
  • Selected functions (awareness)
  • Selected roles (awareness)
  • Technology and architecture (awareness)
  • Competence and training (awareness)
MS55062 - ITIL Foundation Certification Course

About this course

This course is intended for IT Managers and Practitioners. This course provides students with a practical understanding of the key concepts, principles, processes and functions that enables successful IT Service Management provision. It also prepares delegates for the ITIL Foundation Certificate Examination. The course is based on the ITIL best practice service lifecycle approach.  This course provides 21 contact hours.

Audience profile

This course is for IT Managers and Practitioners involved in the strategy, design, implementation, and on-going delivery of business-used IT services and for anyone who requires an insight into Service Management best practice.

At course completion

The course shares with students the skills and knowledge to understand how an integrated IT Service Management framework, based on ITIL best practice guidelines, can be adopted and adapted within their own organizations. It provides proven practical guidance on how to successfully introduce an integrated IT Service Management framework based on the ITIL best practice service lifecycle approach.

 

This course also helps students prepare for the ITIL Foundation Certificate in IT Service Management examination.  There will be reinforcement in the form of exercises throughout the course with the objective of instilling a deeper understanding of IT Service Management.

 

The focus of the course is to help students understand the value to the business provided by each phase of the Service Management Lifecycle as covered by the 5 core books:

  • Service Strategy
  • Service Design
  • Service Transition
  • Service Operation
  • Continual Service Improvement

 

There is particular importance placed on developing an underlying service culture within the IT organization. Topics covered include:

  • Introduction to Service Management
  • The importance of Service Management
  • Definition of a Service and Service Management
  • The need for a service culture
  • Service Management as a practice
  • The Service Lifecycle
MS55159 - The ITIL® Practitioner Certificate in IT Service Management

About this course

The purpose of the ITIL Practitioner course to help organizations and individuals develop and increase the value they obtain from using ITIL by offering additional practical guidance to adopt and adapt the framework to support the business. It is the next step after ITIL Foundation for professionals who have already learned the basics of IT Service Management (ITSM) and the business value of well-designed and delivered services.

Audience profile

The target audience of the ITIL Practitioner certificate in IT Service Management is IT professionals who must demonstrate the skills to apply ITIL concepts in their organization, ensuring maximum business value by delivering fit-for-purpose and fit-for-use services.

At course completion

After completing this course, students will be able to:

  • Using IT Service Management concepts that are important drivers of Continual Service Improvement.
  • Appling the ITSM guiding principles in a real-world context.
  • Appling the CSI approach to manage improvements in a given organizational context.
  • Using metrics and measurements to enable Continual Service Improvement.
  • Communicating effectively to enable Continual Service Improvement.
  • Appling organizational change management to support Continual Service Improvement.
MS55167A - Microsoft Excel 2016

About this course

This Advanced Microsoft Excel 2016 training class is designed for students to gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros.

Audience profile

Students who have intermediate skills with Microsoft Excel 2016 who want to learn more advanced skills or students who want to learn the topics covered in this course in the 2016 interface.

At course completion

After completing this course, students will be able to: Insert the course objectives in a bulleted list with periods. For example:

  • Create pivot tables and charts.
  • Learn to trace precedents and dependents.
  • Convert text and validate and consolidate data.
  • Collaborate with others by protecting worksheets and workbooks.
  • Create, use, edit, and manage macros.
  • Import and export data.
MS55179A - Microsoft Outlook 2016

About this course

This Microsoft Outlook training class builds on basic skills in Outlook and teaches students to work with some of the more advanced features of Outlook.

Audience profile

This course is intended for students who have basic skills with Microsoft Outlook 2016 who want to learn higher level skills or students who want to learn the topics covered in this course in the 2016 interface.

At course completion

After completing this course, students will be able to:

  • Work with tasks and notes.
  • Work with signatures and themes.
  • Manage the inbox including filtering, creating search folders, and archiving.
  • Work with multiple accounts.
MS55177A - Microsoft PowerPoint 2016

About this course

This Advanced Microsoft PowerPoint 2016 training class is for PowerPoint 2016 users who want to build upon their basic skills.

Audience profile

This course is intended for students who have basic skills with Microsoft PowerPoint 2016 who want to learn advanced-level skills or students who want to learn the topics covered in this course in the 2016 interface.

At course completion

After completing this course, students will be able to:

  • Create customized presentations with templates.
  • Add special effects.
  • Use the slide, notes, and handout masters.
  • Create, edit, and import charts.
  • Manage hyperlinks.
  • Create custom shows.
  • Secure and share presentations.
MS55174A - Microsoft Word 2016

About this course

Students in this Intermediate Word 2016 training class should already be able to create, edit, and print Word 2016 documents on Windows. In this Word 2016 class, students will learn advanced formatting, use Word 2016 drawing tools, create and manage tables, and work with column layouts.

Audience profile

This course is intended for students who have basic skills with Microsoft Word 2016 who want to learn intermediate-level skills or students who want to learn the topics covered in this course in the 2016 interface.

At course completion

After completing this course, students will be able to:

  • Learn to use Word 2016’s advanced editing tools.
  • Learn to work with images, including placing and sizing images, wrapping text around images, and using borders and effects.
  • Learn to adjust page orientation and layout.
  • Learn to work with columns.
  • Learn to work with page and section breaks.
  • Learn about document views, using the navigation pane, and viewing multiple windows.
MS20331 - Core Solutions of Microsoft® SharePoint® Server 2013

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.

At course completion

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.
MS20332 - Advanced Solutions of Microsoft® SharePoint® Server 2013

About this course

This five-day 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
MS20336 - Core Solutions of Microsoft® Lync® Server 2013

About this course

This instructor-led course teaches IT professionals how to plan, design, deploy, configure, and administer a Microsoft Lync Server 2013 solution.  The course emphasizes Lync Server 2013 Enterprise Unified Communications features with particular emphasis on coexisting with and migrating from legacy communication services. The labs in this course create a solution that includes IM and Presence, Conferencing, and Persistent Chat.  This course helps the student prepare for Exam 70-336.

Audience profile

This course is intended for IT consultants and telecommunications consulting professionals who design, plan, deploy, and maintain solutions for unified communications (UC). Candidates should be able to translate business requirements into technical architecture and design for a UC solution.

At course completion

After completing this course, students will be able to:

  • Describe the overall server and client Lync Server 2013 architecture.
  • Describe Lync 2013 features and user scenarios.
  • Describe the Lync Server deployment process.
  • Describe the components of a Lync Server 2013 Design.
  • Plan for Microsoft Solutions Framework for Lync 2013.
  • Plan Infrastructure Requirements for Lync Server 2013.
  • Use the Lync Server 2013 Planning Tool.
  • Use Topology Builder.
  • Plan for Site Topology.
  • Design a Site Topology.
  • Plan the Server Infrastructure.
  • Design Documentation Using Microsoft Office.
  • Use Lync Server 2013 management interfaces.
  • Configure Role-Based Access Control.
  • Prepare for client deployment.
  • Deploy and manage clients.
  • Prepare for device deployment.
  • Deploy and manage Internet Protocol (IP) phones.
  • Describe conferencing in Lync Server 2013.
  • Describe dial-in conferencing in Lync Server 2013.
  • Manage and administer dial-in conferencing in Lync Server 2013.
  • Describe the conferencing capabilities of Lync Server 2013.
  • Design audio and video for web conferencing.
  • Plan for instant message and presence Federation.
  • Design Edge services.
  • Describe the features and concepts for Persistent Chat in Lync Server 2013.
  • Design Lync Server 2013 to include Persistent Chat.
  • Deploy and configure Persistent chat in Lync Server 2013.
  • Describe the Archiving service.
  • Describe the Monitoring service.
  • Configure the Archiving and Monitoring services.
  • Describe and use the Lync Server 2013 troubleshooting tools.
  • Describe the required daily, weekly, and monthly maintenance tasks.
  • Describe the fundamental troubleshooting approach to Lync Server 2013 issues.
  • Use SIP commands and analyze SIP logs.
  • Describe high availability in Lync Server 2013.
  • Configure High Availability features in Lync Server 2013.
  • Plan for load balancing in Lync Server 2013.
  • Design load balancing in Lync Server 2013.
  • Describe the high availability options in Lync Server 2013.
  • Describe the tools for backing up and restoring Lync Server 2013 data.
  • Backup and restore critical Lync Server 2013 data.
  • Export and import critical Lync Server 2013 data.
  • Describe design considerations for branch site scenarios.
  • Describe the migration process.
  • Describe migration and coexistence topologies.
  • Plan for client and device migration.
  • Design a software deployment strategy for Lync 2013.
MS20337 - Enterprise Voice and Online Services with Microsoft® Lync® Server 2013

About this course

This course teaches how to design and configure enterprise voice in Microsoft Lync Server 2013 and Lync Online services. This course will provide you with the knowledge and skills to configure and manage a Lync Server 2013 on premises, Lync Online in the cloud or in a mixed deployment. In addition, it will provide the skills needed by IT or telephony consultants to deliver a Lync based enterprise voice solution. This course will teach you how to configure Lync Server 2013, as well as provide guidelines, best practices, and considerations that will help you optimize your enterprise voice deployment. This course helps the student prepare for Exam 70-337.

Audience profile

This course is intended for IT Consultants and Telecommunications consulting professionals with at least three months experience designing, planning, deploying, and maintaining solutions for unified communications (UC) with particular emphasis on enterprise voice over Internet protocol (VOIP). The student should be able to translate business requirements into technical architecture and design for a UC solution. The student should also have basic Windows Server 2012 navigation skills.

At course completion

After completing this course, students will be able to:

  • Design a resilient enterprise voice solution
  • Design and configure network services for Lync 2013
  • Configure Lync Server 2013 voice features
  • Implement emergency voice services
  • Plan and configure a Lync Online or hybrid solution
MS20341 - Core Solutions of Microsoft® Exchange Server 2013

About this course

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

Audience profile

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

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

At course completion

After completing this course, students will be able to:

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

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®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.
MS20347 - Enabling & Managing Office 365

About this course

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

Audience profile

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

This course also is intended as preparation material for IT professionals who are looking to take the exams 70-346: Managing Office 365 Identities and Requirements and 70-347: Enabling Office 365 Services to obtain the MCSA: Office 365 certification.

At course completion

After completing this course, students will be able to:

  • Plan an Office 365 deployment, configure the Office 365 tenant, and plan a pilot deployment.
  • Manage Office 365 users, groups, and licenses, and configure delegated administration.
  • Plan and configure client connectivity to Office 365.
  • Plan and configure directory synchronization between Azure AD and on-premises AD DS.
  • Plan and implement the deployment of Office 365 ProPlus.
  • Plan and manage Exchange Online recipients and permissions.
  • Plan and configure Exchange Online services.
  • Plan and implement the Skype for Business Online deployment.
  • Plan and configure SharePoint Online.
  • Plan and configure an Office 365 collaboration solution that includes Yammer Enterprise, OneDrive for Business, and Office 365 groups.
  • Plan and configure the integration between Office 365 and Azure RMS, and configure compliance features in Office 365.
  • Monitor and review Office 365 services, and troubleshoot Office 365 issues.
  • Plan and implement identity federation between on-premises AD DS and Azure AD.
MS55154 - Office 365 for the End User

About this course

This 1 day course is designed for information workers who are using or will use Office 365. This course will provide students with the knowledge and skills to efficiently use Office 365 on a day-to-day basis. The course is designed with real world scenarios in mind. Students will learn how to use Outlook Online, Skype for Business, OneDrive for Business, SharePoint Online, and OneNote. At the end of this course students will be able to effectively navigate Office 365 and make use of all of the features of Office 365.

Audience profile

This course is intended for anyone who is using or will use Office 365. The course is also intended for decision makers who are trying to understand the features and benefits of Office 365 and how it can increase employee productivity.

At course completion

After completing this course, students will be able to:

  • Understand Office 365
  • Navigate Office 365
  • Use Outlook Online
  • Use Skype for Business
  • Use SharePoint Online
  • Understand OneDrive for Business
  • Manage Outlook features, contacts, groups, distribution groups, and calendars
  • Use SharePoint Online to collaborate with others, manage documents and site navigation
  • Use Skype for Business to collaborate with internal and external contacts
  • Create, organize, and manage OneNote notebooks
MS55103 - Creating and Sharing Interactive Dashboards with PowerPivot, Powerview and SharePoint Server

About this course

In this course students will learn how to create and share interactive dashboards using Excel PowerPivot, Power View and SharePoint. Students will walk through the development of a dashboard project with the steps, concepts, formulas, and functions that are used explained in detail.

Audience profile

This course is targeted at Business Intelligence developers and Power Users that are currently, or are in process of, developing Excel dashboards.

At course completion

After completing this course, students will be able to:

  • Understand how to develop multiple dashboards.
  • Understand how to change deployed dashboards.
  • Understand how to provide interactive help for dashboards.
  • Understand how to monitor dashboard utilization.
  • Understand how to control dashboard updates.
  • Understand how to import data.
  • Understand how to relate data.
  • Understand how to enrich data.
  • Understand how to use time calculations.
  • Source data.
  • Understand tabular data.
  • Understand visual data.
  • Understand linked tables.
  • Create a dashboard.
  • Understand how to add drillthrough.
  • Understand visualizations in Power View.
  • Add interactivity.
  • Understand how to deploy to SharePoint.
  • Understand automatic data refresh.
  • Share using SharePoint Excel Services.
MS55162 - Creating and Deploying in Minutes No-Code Predictive Analytics Using Azure Machine Learning

About this course

This course is designed to introduce the participant to the exciting world of predictive analytics built using drag-and-drop with Microsoft Azure Machine Learning Studio, all without coding from your desktop, using your browser.

Audience profile

The course is targeted towards business analysts, business intelligence developers, and managers interesting in exploring the world of predictive analytics for use as a competitive tool.

At course completion

After completing this course, students will be able to:

  • Understand what machine learning is.
  • Understand the differences between supervised and unsupervised methods.
  • Understand the analytics spectrum.
  • Understand the development methodology.
  • Understand and utilize the Azure Machine Learning Studio interface.
  • Understand and utilize tools for cleaning.
  • Understand the differences between text files and binary files.
  • Understand structures of data.
  • Understand and utilize steps for data cleaning.
  • Understand and utilize feature selection.
  • Understand feature engineering.
  • Understand and utilize regression.
  • Understand and utilize classification.
  • Understand and utilize clustering.
  • Understand anomaly detection.
  • Understand and utilize the Azure Machine Learning Cheat Sheet.
  • Understand and utilize visualizations.
  • Understand data acquisition.
  • Understand data preparation.
  • Understand feature selection.
  • Understand and utilize Train Data.
  • Understand cross validation and comparing regressions.
  • Evaluate solutions and learn from examples.
  • Understand and utilize regression algorithms.
  • Understand and utilize classification algorithms.
  • Understand and utilize clustering algorithms.
  • Understand utilize joined datasets.
  • Understand and utilize Power BI.
MS55054 - Mastering Microsoft Project 2013

About this course

This three-day, instructor-led course is intended for individuals who are interested in expanding their knowledge base and technical skills about Microsoft Project. The course begins with the basic concepts and leads students through all the functions they’ll need to plan and manage a small to medium-size project, including how to level resources and capture both cost and schedule progress.

This course will also help students prepare for Microsoft Project 2013 Exam 74-343 Managing Projects with Microsoft Project 2013.

Audience profile

This course is intended for both novice and experienced project managers, managers, schedulers, and other project stake holders who need to incorporate the discipline of project management with Microsoft Project 2013.

At course completion

After completing this course, students will be able to:

  • Understand the discipline of project management as it applies to using Microsoft Project 2013.
  • Create a Work Breakdown Structure.
  • Identify Task Types & Relationships.
  • Define Resources within Project.
  • Make Work Package Estimates.
  • Create an Initial Schedule.
  • Create a Resource Leveled Schedule.
  • Create Projects from templates, Excel files.
  • Create Global templates.
  • Create formulas and graphical indicators.
  • The steps to record a macro.
  • Format Output and Print Reports.
  • Integrate Multiple Projects.
  • Set up a Project with a Calendar, Start date, and scheduling method.
  • Understand Manually Schedule vs. Auto Schedule.
  • Manage multiple projects.
  • Be able to create a master project list with shared resources.
MS55181 - Microsoft Project 2016: Digging Deeper

About this course

This Intermediate Microsoft Project 2016: Digging Deeper class takes an in-depth approach to key features of Project 2016 including task entry and linking, resource and resource management, and examining and updating projects. You will learn to efficiently manage projects, create master projects and sub-projects, create and customize visual reports, work with resource pools, and learn about costing.

Audience profile

This course is intended for students who want to start with the basics and learn how to use Microsoft Project 2016.

At course completion

After completing this course, students will be able to:

  • Work with the advanced formatting features of the Gantt chart and network diagrams.
  • Create master projects and subprojects in Project 2016.
  • Create customized project reports.
  • Work with resource pools.
MS55107 - Managing Projects with Project Server 2013

About this course

This two-day instructor-led course is intended for project team member or project managers who build an easy-to-maintain and reusable work schedule for team members and partners. Managing task status and evaluate the work schedule in terms of time, man-hours, tasks, budgets on demand. Also would like to improve effective project team communication and collaboration.

Audience profile

This course is intended for both novice and experienced project team members or project managers who will be managing a team or will be involved in project management tasks.

At course completion

After completing this course, students will be able to:

  • Create a project plan with MS Project and publish to MS Project Server 2013/Project Server Online
  • Managing project task
  • Managing project tasks resources
  • Reporting status
  • Generating project reports
MS55115 - Planning, Deploying and Managing Microsoft Project Server 2013

About this course

The goal of this three-day instructor-led course is to provide students with the knowledge and skills necessary to effectively plan, deploy and administer Microsoft Project Server 2013.

Audience profile

This course is intended for Administrators, Systems Engineers, PMO Managers, Project Managers, Consultants and other people responsible for the deployment and management of a Microsoft Project and Portfolio Management (PPM) Solution using Project Server 2013.

At course completion

  • Plan a Microsoft PPM Deployment
  • Configure SQL Server for SharePoint/Project Server 2013
  • Deploy SharePoint and Project Server 2013
  • Install and configure Project Server client software
  • Create enterprise custom fields
  • Configure and manage views and security
  • Configure and manage time and task management settings
  • Customize project sites
  • Import projects and resources
  • Work with Project Server Administration Tool
  • Back and Restore Project Server 2013
MS55118 - Creating Report with SAP Crystal Reports for Developer with Visual Studio

About this course

This two-day instructor-led course is intended for application developers who are interested in developing client side reports in Visual Studio 2013. In this course, students learn how to install and configure SAP Crystal Reports using Visual Studio 2013. Students then learn how to author a report and integrate with applications developed with Visual Studio 2013.

Audience profile

This course is intended for both programmers who have experience in developing applications with Visual Studio 2013.

At course completion

After completing this course, students will be able to:

  • Install SAP Crystal Reports for developer for Visual Studio 2013
  • Create report with Visual Studio 2013
  • Integrate report with applications developed with Visual Studio 2013
  • Integrate report wth different kind of data source
MS20488 - Developing Microsoft SharePoint® Server 2013 Core Solutions

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.
MS20489 - Developing Microsoft® SharePoint® Server 2013 Advanced Solutions

About this course

This course provides SharePoint developers the information needed to implement SharePoint solutions using Enterprise Search, Managed Metadata Service (MMS), Business Connectivity Services (BCS), Enterprise Content Management (ECM), Web Content Management (WCM), Social Computing features and SharePoint Apps.

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. The course is ideally suited to SharePoint developers who have gained some experience with SharePoint 2013 and who are looking to build on their existing skills.

At course completion

After completing this course, students will be able to:

  • Describe the apps for SharePoint development platform.
  • Use the client-side object models and the REST API to communicate with SharePoint.
  • Configure security for apps for SharePoint.
  • Optimize the performance of apps for SharePoint.
  • Explain the capabilities and applications of managed metadata in SharePoint 2013.
  • Automate the creation and configuration of managed metadata term sets.
  • Interact with managed metadata term sets and fields from client-side and server-side code.
  • Describe the SharePoint 2013 Search Architecture.
  • Build simple and advanced KQL Queries.
  • Describe the SharePoint Search Index.
  • Describe and work with crawled and managed properties.
  • Describe the levels and security of the SharePoint Search Schema.
  • Create various types of result sources
  • Create basic and complex query transforms
  • Configure query rule conditions and actions to target query intent
  • Create and modify result types
  • Create and modify display templates
  • Utilize display templates with various search web parts
  • Add managed properties as refiners with counts
  • Utilize entity extraction in your crawls
  • Extend content processing with Content Enrichment
  • Describe how to utilize the Publishing API to access publishing settings and content.
  • Describe how to use and customize page content controls in publishing sites.
  • Configure website structure and navigation.
  • Describe the difference between structured and metadata navigation.
  • Utilize basic publishing features of SharePoint.
  • Use the new cross-site publishing features of SharePoint 2013.
  • Configure and implement variations for multilingual sites.
  • Configure search engine optimization settings.
  • Add SEO Properties to publishing pages and Managed Navigation terms.
  • Configure caching to improve site rendering performance.
  • Optimize site assets and resources to maximize performance.
  • Describe the key components of Business Connectivity Services in SharePoint Server 2013.
  • Create and configure BDC models by using SharePoint Designer.
  • Create and configure BDC models by using Visual Studio 2012.
  • Describe BCS Connector Framework scenarios.
  • Design and Develop BCS Connector stereotyped operations.
  • Design and Configure BDC model security.
  • Optimize Search Connector crawl performance.
  • Use Visual Studio to build BDC Models for Search.
  • Deploy BDC Search connectors.
  • Debug and troubleshoot your search connectors.
  • Design and deploy BDC event subscriber methods.
  • Describe how to format event notification messages.
  • Configure alerts and event receivers on external lists.
  • Explain how user profile data is used in SharePoint.
  • Describe the options and restrictions for accessing user profile data.
  • Use client-side code to access and server-side code to access and update user profile data.
  • Configure and manage user profile properties.
  • Describe how to identify, diagnose, and remove bugs in SharePoint apps during development.
  • Describe how to record information about issues that arise in deployed SharePoint apps.
  • Describe how developers optimize the performance of SharePoint apps by implementing best practices, measuring performance, and load testing.
MS55014 - Upgrading Your Development Skills to SharePoint 2013

About this course

This course will teach you all the new development changes that were made to SharePoint 2013 including .NET 4.0, Visual Studio 2012, Mobility, Workflow 4.0, OData, OAuth, Claims Authentication, SharePoint AppStore and the new Service Applications (Machine Translation and PowerPoint Automation).

Audience profile

This course is intended for anyone interested in getting an introductory look at the new development features of SharePoint 2013.

At course completion

After completing this course, students will be able to:

  • Describe Object Model changes, Mobility Features, OData, OAuth and Translation Services. Work with Visual Studio 2012 SharePoint Templates and build SharePoint 2013 AppStore Apps.
MS55028 - SharePoint 2013 Power User

About this course

This SharePoint 2013 Power User training class is designed for individuals who need to learn the fundamentals of managing SharePoint sites.

Audience profile

This course is intended for new and existing users of SharePoint.

At course completion

After completing this course, students will be able to:

 

  • Create custom workflows using SharePoint Designer 2013.
  • Learn to use Content Approval settings and Workflow.
  • Learn to use Term stores and managed Metadata.
  • Learn to use the Document ID Service.
  • Learn SharePoint Server Publishing Infrastructure.
  • Learn to create and use Document Sets.
  • Learn to route documents with Content Organizer.
  • Learn to use Metadata Navigation.
  • Learn to create external content types with Business Connectivity Services.
  • Learn to use Information Management Policies.
MS55031 - SharePoint 2013 End User

About this course

This SharePoint 2013 End User class is for end users working in a SharePoint 2013 environment. The course teaches SharePoint basics such as working with lists and libraries as well as basic page customizations.

Audience profile

This course is intended for new and existing users of SharePoint.

At course completion

After completing this course, students will be able to:

  • Learn to navigate a SharePoint 2013 Team Site.
  • Learn to create SharePoint lists.
  • Learn to customize SharePoint lists.
  • Learn to create SharePoint libraries.
  • Learn to manage library document versions.
  • Learn to create SharePoint list and library views.
  • Learn to create sub sites using various SharePoint templates.
  • Learn to create and edit Web page content.
  • Learn to create InfoPath Forms and Form libraries.
  • Learn to create Site columns and content types.
  • Learn to integrate Office applications with SharePoint 2013.
  • Learn to manage basic permissions of SharePoint 2013 resources.
MS55033 - SharePoint 2013 Site Collection and Site Administration

About this course

This course is intended for power users, who are tasked with working within the SharePoint 2013 environment. This course will provide a deeper, narrowly-focused training on the important and popular skills needed to be an administrator for SharePoint site collections and sites. SharePoint deployment or farm administration skills and tasks, which are required for IT professionals to manage SharePoint 2013, are available in separate Microsoft Official Courseware.

Audience profile

This course is intended for SharePoint site collection administrators, site administrators and power users who are tasked with working within the SharePoint environment.

At course completion

After completing this course, students will be able to:

  • Design and implement a company portal structure using SharePoint 2013 objects including sites, libraries, lists and pages
  • Explain the role of security and permissions throughout SharePoint 2013
  • Implement guidelines for consistency in building a company portal to aid in the day-to-day administration of content in SharePoint 2013
  • Enhance the design of and content on a company portal using SharePoint 2013 themes and web parts
  • Explain the importance of governance for the planning and managing future growth of the SharePoint 2013 implementation
  • Identify options to integrate data from other systems as well as preserve existing data
  • Explain the role of social networking in SharePoint 2013 and its impact on collaboration
MS55035 - Microsoft SharePoint Server 2013 for the Site Owner/Power User

About this course

This two day class is designed for information workers or power users who serve as SharePoint Site Owners or Site Collection Administrators. Students should take this course if they need to know how to manage the team collaboration, document management and social features of Microsoft SharePoint 2013. This class is an excellent prerequisite for IT Professionals who work as SharePoint Server Administrators attending 20331: Core Solutions of Microsoft SharePoint Server 2013.  This class can be delivered using Site Collections on an in-house server, virtual machines or Office 365.

Audience profile

This course is intended for

  • SharePoint Site Owners
  • SharePoint Site Collection Administrators
  • SharePoint Administrators and Developers

At course completion

After completing this course, students will be able to:

  • Manage Sites and Site Collections
  • Add users and groups and manage site, list, folder and item security
  • Add and configure web parts
  • Configure site options including theme, title, description and icon
  • Configure site navigation
  • View site activity reports
  • Customize lists and libraries
  • Work with Site Columns and Site Content Types
  • Configure Check out/in, Content Approval and Versioning
  • Create and modify pages and web part pages
MS55049 - PowerPivot, Power View and SharePoint 2013 Business Intelligence Center for Analysts

About this course

This two-day instructor-led course concentrates on PowerPivot and Power View in Excel 2013. The attendees will learn how to surface the workbooks and visualizations using the Business Intelligence Center in SharePoint 2013.

As far as possible each of the modules is stand-alone allowing for customization of the course for those audiences that may not have an interest in a certain service.

Audience profile

This course is intended for analysts, business intelligence (BI) developers and IT professionals that will be involved with the design, development, and maintenance of Excel workbooks utilizing PowerPivot and Power View 2013 to be surfaced on SharePoint.

At course completion

After completing this course, students will be able to:

  • Use PowerPivot 2013 in Excel.
  • Work with DAX.
  • Create Power View visualizations.
  • Understand data models.
  • Save to SharePoint.
  • Surface on SharePoint.
  • Work with the SharePoint Business Intelligence Center.
  • Create dedicated apps in SharePoint for PowerPivot and Power View.
  • Use PowerPivot within Excel to import a table from SQL Server.
  • Use PowerPivot within Excel to import a table from SQL Server Analysis Services.
  • Hide columns they don’t want reflected in the resulting PivotTable.
  • View the relationships existing within the imported tables from SQL Server and then import an additional table and configure a relationship between it and the existing.
  • Create a PivotTable within an existing worksheet.
  • Navigate and successfully use Power View.
  • Create a table.
  • Create a chart.
  • Save and share their work.
  • Create a BI semantic model.
  • Explore the options and settings available within the new SharePoint 2013 Central Administration and Excel Services.
  • Access and review the Secure Store.
  • Create a new web application and business intelligence site while exploring the features of both.
MS55063 - Advanced SharePoint 2013 Business Intelligence

About this course

This course How to use SharePoint as your platform for Business Intelligence.  Journey through the SharePoint Business Intelligence Center, Excel Services, Reporting Services, Analysis Service, Performance Point and PowerPivot to implement your BI Strategies and enable your decision makers to see data in new and dynamic ways!  Also included are Power* features like PowerView, PowerQuery, PowerMap and PowerBI. You will also be exposed to Big Data topics such as Hadoop, HDInsight and StreamInsight.  This course will take you down a path of building a BI environment from scratch to full interactive dashboards using the Microsoft BI Stack.

Audience profile

This course is intended for Sr. Business Intelligence Architects and Consultants, Sr. Business Analysts, anyone responsible for implementing BI with SharePoint.

At course completion

The 2013 refresh of the popular 2010 BI course!  This course explores the new design of the Business Intelligence Center, changes in Excel Services and Office Web Apps, Business Connectivity Services and OData, Visio Services, Access Services 2013, PowerPivot, PowerBI, PowerView, PowerQuery and Power Maps, PerformancePoint and Bing Maps via the GeoLocation field.

MS55066 - PowerShell for SharePoint Administrators

About this course

This course provides students with the knowledge and skills needed to use PowerShell to administer SharePoint Servers. Students will learn how to manage day-to-day and automated tasks carried out by SharePoint Administrators.

Audience profile

This course is intended for SharePoint administrators who work in a Windows network environment. At least one year of experience managing SharePoint servers and using PowerShell is recommended.

At course completion

After completing this course, students will be able to:

  • Configure SharePoint Servers using PowerShell
  • Manage SharePoint Server Administration with PowerShell
  • Manage SharePoint Server Maintenance with PowerShell
MS55072 - Visualizing Data with SharePoint 2013, Report Builder, PowerPivot & PowerView

About this course

What do we mean by no code? It is a matter of perspective. In today’s world the successful software vendor needs to develop software that is easily customizable by casual users. In the realm of business intelligence that means offering a variety of tools to different types of users that, depending on their experience, they can utilize to rapidly create the visualization of data that suits their needs. Microsoft has produced a great array of such tools that target different users. These tools are various Wizards, Dialog Boxes, Forms, Web Pages Designers and so forth. In this course we utilize the built in tools and do not write a single line of code!

No Code visualization means using the data structures that exist already to get the job done. You don’t have the time or maybe the inclination to learn how to code but you need answers. I.T., if you haven’t already noticed, is always working through a backlog but your business situation is dynamic and rapidly changing and will not wait for any backlog. In this course you will learn how to get those answers without submitting a request and waiting.

Audience profile

The target audience of this course is for Business Analysts, Report Designers, Team Leads, SharePoint Administrators, Business Intelligence Developers and Project Managers that will be tasked with the implementation, support, management or training needed to rapidly empower the users to take advantage of the exploding world of Data V.

At course completion

Why this course may be for you:

You have the infrastructure but getting reports generated out of I.T. just takes too long.

Lack of insight into what has happened is hampering your ability to move forward.

You need or want to use the web browser as your source of information so that it is as accessible as the internet.

You want to take advantage of the SharePoint deployment to manage the data connections, report objects, dashboards KPI’s etc.

You need to rapidly prototype reports for changing conditions

You want to move from textual reports to graphical reporting.

You are tasked with implementing Six Sigma type reports using Visio Data Driven objects

Your organization wants to implement analysis based on automatically updating data

You need to implement a “Single Source of The Truth” structure.

You need to understand the effectiveness of the reports and dashboards.

You need an understanding of the tools that are available and how to determine which is the target audience for those tools.

You need to implement actionable dashboards to allow line managers to rapidly take action.

MS55095 - SharePoint 2010 and 2013 Auditing and Site Content Administration using PowerShell

About this course

This course is designed for SharePoint 2010 and 2013 server administrators and auditors who need to query just about anything in SharePoint. The class handout is effectively a cheat sheet with over 175 PowerShell scripts plus the general patterns to create your own scripts. These scripts cover:

  • using the SharePoint Management Shell and the ISE
  • general tips for counting, reformatting and exporting results;
  • understand and drilling up and down the SharePoint object model
  • getting lists / inventories of servers, services web applications, sites, webs, lists, libraries, items, fields, content types, users and much more
  • finding lists by template type, content type and types of content
  • finding files by user, content type, file extension, checked out status, size and age
  • finding inactive sites
  • finding and changing SharePoint Designer settings and finding and resetting customized pages
  • inventorying and managing features
  • deleting and recycling files and list items
  • inventorying users and user permissions and finding out “who can access what”
  • creating sites, lists and libraries
  • uploading and downloading files
  • and much more…

Audience profile

  • SharePoint server administrators.
  • SharePoint auditors.
  • Also valuable for SharePoint developers.

At course completion

After completing this course, students will be able to:

  • Use PowerShell to query just about anything inside of SharePoint.
  • Understand the core SharePoint object model and object hierarchy as seen from PowerShell.
  • Format PowerShell output in to reports.
  • Manage resources to limit the impact on production servers.
  • Create and delete Site Collections, subsites, lists, libraries and content.

 

MS55158 - SharePoint 2013 Business Intelligence

About this course

This course covers the services and features in SharePoint that offer support for Business Intelligence scenarios.

Audience profile

This course is intended for information workers and business intelligence analysists who have a minimum of three months experience using SharePoint sites, lists, and libraries and have basic Web navigation skills.

At course completion

After completing this course, students will be able to:

  • Learn to configure SharePoint sites for business intelligence
  • Learn to configure and use SharePoint Excel Services
  • Learn to configure and use SharePoint Visio Services
  • Learn to configure and use the PowerPivot add-on for SharePoint
  • Learn to configure and use Power View in SharePoint
  • Lean to configure and use the PowerPivot add-on for SharePoint
  • Learn to configure and use the Reporting Services add-on for SharePoint
  • Learn to configure and use PerformancePoint in SharePoint
  • Learn the basics of Power BI and how it fits with SharePoint
MS55071 - Microsoft Software Asset Manager

About this course

This course is intended for IT professionals who are interested in expanding their knowledge about managing their Microsoft Licenses (Assets) in a more efficient way while ensuring their compliance. The course is designed to help students shape their IT processes to enable efficient and secure usage and deployment of Microsoft Software in compliance with Microsoft Licensing Terms and Conditions. Students gather a profound understanding of Microsoft Licensing Rights, learn how to train their employees and IT personnel to adhere to the relevant Terms and Conditions and  generate awareness of compliance issues throughout their IT infrastructure. Additionally, the course introduces core Microsoft technologies which can support your Software Asset Management (MAP Toolkit). This course helps System Administrators, System Architects and IT Managers decide on how to effectively license their complex IT infrastructures, how to properly deploy Microsoft software and to keep on top of their licensing situation at all times.

Audience profile

This course is intended for IT administrators, IT managers and IT responsibles with either basic or more proficient knowledge of Microsoft Software Licensing who are responsible directly or indirectly for deployment of Software on either clients or complex server infrastructures including virtualized environments.

At course completion

After completing this course, students will be able to:

  • Ensure transparency of deployment of software in their IT
  • Create or adjust IT-processes to help ensure transparency and compliance
  • Manage their Microsoft Licenses in a more efficient way
  • Handle relevant Microsoft tools for Software Asset Management (MAP Toolkit, SCCM,…)
MS20409B - Server Virtualization with Windows Server Hyper-V® and System Center

About this course

This five day course will provide you with the knowledge and skills required to design and implement Microsoft Server Virtualization solutions using Hyper-V and System Center.

Audience profile

This course is intended for IT professionals who are responsible for designing, implementing, managing, and maintaining a virtualization infrastructure or are interested in learning about current Microsoft Virtualization technologies. The secondary audience for this course includes IT decision makers who will determine which virtualization product to implement in their data centers.

At course completion

After completing this course, students will be able to:

  • Evaluate an organization’s virtualization requirements and plan for server virtualization.
  • Install and configure the Hyper-V server role.
  • Create virtual machines, create and manage virtual hard disks and work with snapshots.
  • Create and configure virtual machine networks in a Hyper-V environment.
  • Implement virtual machine movement and Hyper-V Replica.
  • Provide high availability for Hyper-V environment by implementing failover clustering.
  • Manage virtual environment by using System Center 2012 R2 Virtual Machine Manager.
  • Manage networking and storage infrastructure in Virtual Machine Manager.
  • Configure and manage Virtual Machine Manager library and library objects.
  • Create and manage virtual machines by using Virtual Machine Manager.
  • Create and manage clouds by using System Center 2012 R2 Virtual Machine Manager.
  • Create and manage services in System Center 2012 R2 Virtual Machine Manager.
  • Protect virtualization infrastructure by using Windows Server Backup and Data Protection Manager.
MS20694 - Virtualizing Enterprise Desktops and Apps

About this course

This hands-on training course is designed to teach you the breadth of Microsoft virtual desktop technology, and the course will compare and contrast the various technologies with use cases and best practices. This course builds your skills in Microsoft Application Virtualization (App-V) Service Pack 2 (SP2), Microsoft User Experience Virtualization (UE-V), and Virtual Desktop Infrastructure (VDI) as part of Windows Server 2012 R2. Throughout this course, you will learn how to manage, monitor, support, and troubleshoot various Windows-based desktop virtualization solutions.

Audience profile

This course is intended for the IT administrators, and implementers, of large and midsized organizations who want to understand and get hands on experience with the latest Microsoft desktop and application virtualization technologies and how to plan, implement, and manage virtual infrastructure solutions based on these technologies.

At course completion

After completing this course, students will be able to:

  • Describe desktop and application virtualization.
  • Plan and implement user state virtualization.
  • Plan and implement App-V.
  • Plan and deploy App-V clients.
  • Manage and administer application virtualization.
  • Understand application sequencing.
  • Configure client Hyper-V.
  • Plan and deploy session-based desktops.
  • Publish and configure RemoteApp programs.
  • Plan pooled personal desktops.
  • Plan and implement pooled and personal desktops.
  • Implement Remote Access.
  • Understand health monitoring of VDI infrastructure.
MS40390 - Microsoft Azure for AWS Experts

About this course

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

Audience profile

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

At course completion

After completing this course, students will have a working understanding of:
• Implementing and managing Virtual Machines and Storage
• Implementing and managing Azure Virtual Networking
• Implementing and managing Azure Resource Manager and Resource Groups
• Implementing and managing Azure Active Directory
• Comparing Microsoft Azure and AWS features and services
• Azure AD fundamentals

Students will work their way through the online labs to become familiar with:
• Creating a Linux Azure Virtual Machine
• Configuring Linux Azure Virtual Machine Storage
• Creating a Microsoft Azure Virtual Machine
• Attaching additional storage using the Portal
• Managing Azure Storage
• Configuring User Defined Routes
• Configuring Azure VNet Peering
• Deploying a Geo-Redundant Solution with Traffic Manager
• Automating Workloads with a Template
• Working with Azure cross-platform command line tools

MS50466 - Windows® Azure™ Solutions with Microsoft® Visual Studio® 2010

About this course

This class is an introduction to cloud computing and specifically Microsoft’s public cloud offering in Windows Azure. Windows Azure has been described by Microsoft as an operating system for “the cloud”. In this class, you explore this cloud operating system and learn how to write, deploy and monitor .NET applications in Azure.

Audience profile

This class is designed for .NET developers with Web application experience that are exploring developing new applications or porting existing applications to Windows Azure.

At course completion

After completing this course, students will be able to:

  • Understand cloud computing in its various forms and how Windows Azure fits in the cloud computing space.
  • Learn why organizations want to run applications in the Azure cloud.
  • Understand the architecture of Azure.
  • Explore the Azure SDK and development environment (Compute and Storage Emulators).
  • See how to develop applications for Azure and how that varies from “normal” .NET application development.
  • Write and deploy an ASP.NET Web application (Web Role) to Azure.
  • Learn how to create and deploy background computational applications (Worker Role) in Azure.
  • Explore Azure Storage capability to include table, queue and blob storage.
  • Examine SQL Azure, the relational database in the cloud.
  • Study how SQL Azure differs from Azure Storage.
MS10977 - Updating Your SQL Server Skills to Microsoft® SQL Server® 2014

About this course

This five-day instructor-led course teaches students how to use the enhancements and new features that have been added to SQL Server and the Microsoft data platform since the release of SQL Server 2008. The course focuses on teaching individuals how to use SQL Server 2014 product features and other Microsoft data platform components.

Audience profile

The primary audience for this course is database and business intelligence (BI) professionals who are familiar with SQL Server 2008 and want to update their skills to SQL Server 2014, and become familiar with related Microsoft data technologies.

At course completion

After completing this course, students will be able to:

  • Describe key features and capabilities of SQL Server 2014.
  • Leverage new and enhanced features to develop database in SQL Server 2014.
  • Use in-memory database capabilities in SQL Server 2014.
  • Manage SQL Server 2014 by using dynamic management views and PowerShell.
  • Implement security in SQL Server 2014.
  • Implement high-availability and data recovery techniques in SQL Server 2014.
  • Use SQL Server 2014 Integration Services.
  • Use SQL Server 2014 Data Quality Services.
  • Use SQL Server 2014 Master Data Services.
  • Manage SQL Server 2012 Agent and Jobs.
  • Implement a tabular data model in SQL Server 2014 Analysis Services.
  • Implement a Self-Service BI solution with Microsoft Excel 2013.
  • Describe key elements of cloud solutions for data.
  • Implement a database in Microsoft Azure SQL Database.
  • Implement a SQL Server database in a Microsoft Azure virtual machine.
  • Implement a Big Data solution with Microsoft Azure HDInsight and the Microsoft Azure Marketplace.
MS10980 - SQL Server Performance Tuning and Optimization

About this course

This course is designed to give the right amount of Internals knowledge and wealth of practical tuning & optimization techniques that you can put into production. The 5 day class offers a comprehensive coverage of SQL Server architecture, indexing and statistics strategies, optimize transaction log operations, tempdb and data file configuration, transactions and isolation levels, and locking and blocking. The course also teaches how to create baselines and benchmark SQL Server performance, how to analyze workload and figure out where performance problems are, and how to fix them. The course has a special focus on SQL Server I/O, CPU usage, memory usage, query plans, statement execution, parameter sniffing and procedural code, deadlocking, plan cache, wait and latch statistics, Extended Events, DMVs and PerfMon.

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

  • Describe the SQL Server architecture.
  • Describe and monitor SQL Server scheduling.
  • Analyze wait statistics.
  • Describe core IO concepts.
  • Describe Storage Area Networks and it’s components.
  • Test storage performance using SQLIO utility.
  • Describe Database structures.
  • Describe Data File Internals and best practices.
  • Describe TempDB Internals and best practices.
  • Describe Concurrency and Transactions.
  • Describe SQL Server Locking Architecture.
  • Describe Extended Events core concepts.
  • Implement Extended Events.
  • Monitor and trace SQL Server performance data.
  • Baseline and benchmark SQL Server Performance.
  • Identify and diagnose CPU performance issues.
  • Identify and diagnose Memory performance issues.
  • Identify and diagnose IO performance issues.
  • Identify and diagnose TempDB performance issues.
  • Identify and diagnose Concurrency performance issues.
  • Describe Optimizer Internals.
  • Analyze, identify and fix Query Plan issues.
  • Identify and minimize index fragmentation.
  • Specify correct index column order.
  • Identify and create missing indexes.
  • Tune slow running queries.
MS10985 - Introduction to SQL Databases

About this course

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

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
MS10986 - Updating Your Skills to SQL Server 2016

About this course

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

Audience profile

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

At course completion

After completing this course, students will be able to:

  • Describe key capabilities and components of SQL Server 2016
  • Describe new and enhanced features in SQL Server performance
  • Describes new and enhanced features in SQL Server security
  • Describe what’s new in SQL Server Availability and Scalability
  • Describe new and enhanced features in reporting and PowerBI in SQL Server 2016
  • Describe new and enhanced data access features
  • Describe new and enhanced features in SQL Server OLAP
  • Describe new SQL Server cloud functionality
MS10987 - Performance Tuning and Optimizing SQL Databases

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.
MS10988 - Managing SQL Business Intelligence Operations

About this course

This course is aimed at database professionals who manage Business Intelligence (BI) operations. This course looks at various options that provide the ability of business users to analyze data and share their findings, starting with managed BI data sources and expanding to personal and external/public data sources.

Audience profile

The primary audience for this course are business intelligence professionals.

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 the key capabilities of SQL Server BI in a SharePoint environment
  • Describe common Analysis Services operational tasks
  • Describe PowerPivot for SharePoint server
  • Describe Power Query
  • Describe Windows Azure HDInsight

 

MS10989 - Analyzing Data with Power BI

About this course

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

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

MS10990 - Analyzing Data with SQL Server Reporting Services

About this course

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

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

MS20461 - Querying Microsoft SQL Server® 2014

About this course

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

This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2014. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. The main purpose of the course is to prepare people for the exam “70-461: Writing Queries Using Microsoft® SQL Server® 2014 Transact-SQL.” This exam will be the underlying exam for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. As such, the primary target audience for this course is: Database Administrators, Database Developers and BI professionals..

Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.

Audience profile

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

At course completion

After completing this course, students will be able to:

  • Describe the basic architecture and concepts of Microsoft SQL Server 2014.
  • Understand the similarities and differences between Transact-SQL and other computer languages.
  • Write SELECT queries
  • Query multiple tables
  • Sort and filter data
  • Describe the use of data types in SQL Server
  • Modify data using Transact-SQL
  • Use built-in functions
  • Group and aggregate data
  • Use subqueries
  • Use table expressions
  • Use set operators
  • Use window ranking, offset and aggregate functions
  • Implement pivoting and grouping sets
  • Execute stored procedures
  • Program with T-SQL
  • Implement error handling
  • Implement transactions
MS20462 - Administering Microsoft® SQL Server® 2014 Databases

About this course

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

Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.

Audience profile

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

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

At course completion

After completing this course, students will be able to:

  • Describe core database administration tasks and tools.
  • Install and configure SQL Server 2014.
  • Configure SQL Server databases and storage.
  • Plan and implement a backup strategy.
  • Restore databases from backups.
  • Import and export data. Monitor SQL Server.
  • Trace SQL Server activity.
  • Manage SQL Server security.
  • Audit data access and encrypt data.
  • Perform ongoing database maintenance.
  • Automate SQL Server maintenance with SQL Server Agent Jobs.
  • Configure Database Mail, alerts and notifications.
MS20463 - Implementing a Data Warehouse with Microsoft® SQL Server® 2014

About this course

This course describes how to implement a data warehouse platform to support a BI solution. Students will learn how to create a data warehouse with Microsoft® SQL Server® 2014, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.

Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.

Audience profile

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

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

At course completion

After completing this course, students will be able to:

  • Describe data warehouse concepts and architecture considerations.
  • Select an appropriate hardware platform for a data warehouse.
  • Design and implement a data warehouse.
  • Implement Data Flow in an SSIS Package.
  • Implement Control Flow in an SSIS Package.
  • Debug and Troubleshoot SSIS packages.
  • Implement an ETL solution that supports incremental data extraction.
  • Implement an ETL solution that supports incremental data loading.
  • Implement data cleansing by using Microsoft Data Quality Services.
  • Implement Master Data Services to enforce data integrity.
  • Extend SSIS with custom scripts and components.
  • Deploy and Configure SSIS packages.
  • Describe how BI solutions can consume data from the data warehouse.
MS20464 - Developing Microsoft SQL Server 2014 Databases

About this course

This 5-day instructor-led course introduces SQL Server 2014 and describes logical table design, indexing and query plans. It also focusses on the creation of database objects including views, stored procedures, along with parameters, and functions. Other common aspects of procedure coding, such as indexes, concurrency, error handling, and triggers are also covered in this course. Also this course helps you prepare for the Exam 70-464.

Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.

Audience profile

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

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

At course completion

After completing this course, students will be able 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.
  • Determine appropriate data types to be used when designing tables, convert data between data types, and create alias data types.
  • Be aware of good design practices regarding SQL Server tables and be able to create tables using T-SQL. (Note: partitioned tables are not covered).
  • Implement PRIMARY KEY, FOREIGN KEY, DEFAULT, CHECK and UNIQUE constraints, and investigate cascading FOREIGN KEY constraints.
  • Determine appropriate single column and composite indexes strategies.
  • Create tables as heaps and tables with clustered indexes. Also consider the design of a table and suggest an appropriate structure.
  • Read and interpret details of common elements from execution plans.
  • Design effective non-clustered indexes.
  • Design and implement views
  • Design and implement stored procedures.
  • Work with table types, table valued parameters and use the MERGE statement to create stored procedures that update data warehouses.
  • Design and implement functions, both scalar and table-valued. (Also describe where they can lead to performance issues).
  • Perform basic investigation of a deadlock situation and learn how transaction isolation levels affect application concurrency.
  • Use both traditional T-SQL error handling code and structured exception handling.
  • Design and implement DML triggers
  • Learn appropriate uses for SQL CLR integration and implement an existing .NET assembly within SQL Server.
  • Store XML data and schemas in SQL Server.
  • Perform basic queries on XML data in SQL Server.
MS20465 - Designing a Data Solution with Microsoft® SQL Server®

About this course

This course is on planning and implementing enterprise database infrastructure solutions by using SQL Server 2014 and other Microsoft technologies. It describes how to consolidate SQL Server workloads and how to plan and implement high availability and disaster recovery solutions.

Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.

Audience profile

This course is intended for database professionals who need who plan, implement, and manage database solutions. Primary responsibilities include:

  • Planning and implementing database infrastructure.
  • Planning and implementing consolidation strategies.
  • Planning and implementing high availability solutions.
  • Planning and implementing disaster recovery solutions.

At course completion

After completing this course, students will be able to:

  • Assess an existing enterprise environment.
  • Plan and implement Policy-Based Management.
  • Describe the considerations for consolidating workloads with SQL Server 2014.
  • Describe considerations for including SQL Server 2014 in a private cloud.
MS20466 - Implementing Data Models and Reports with SQL Server 2014

About this course

This course is on creating managed enterprise BI solutions. It describes how to implement multidimensional and tabular data models, deliver reports with Microsoft® SQL Server® Reporting Services, create dashboards with Microsoft SharePoint Server PerformancePoint Services, and discover business insights by using data mining.

Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.

Audience profile

This course is intended for database professionals who need to fulfill a Business Intelligence Developer role to create analysis and reporting solutions. Primary responsibilities include:

  • Implementing analytical data models, such as OLAP cubes.
  • Implementing reports, and managing report delivery.
  • Creating business performance dashboards.
  • Supporting data mining and predictive analysis.

At course completion

After completing this course, students will be able to:

  • Describe the components, architecture, and nature of a BI solution.
  • Create a multidimensional database with Analysis Services.
  • Implement dimensions in a cube.
  • Implement measures and measure groups in a cube.
  • Use MDX Syntax.
  • Customize a cube.
  • Implement a Tabular Data Model in SQL Server Analysis Services.
  • Use DAX to enhance a tabular model.
  • Create reports with Reporting Services.
  • Enhance reports with charts and parameters.
  • Manage report execution and delivery.
  • Implement a dashboard in SharePoint Server with PerformancePoint Services.
  • Use Data Mining for Predictive Analysis.
MS20467 - Designing Business Intelligence Solutions with Microsoft SQL Server 2014

About this course

This training course teaches database and business intelligence (BI) professionals how to plan and design a BI solution that is based on Microsoft SQL Server 2014 and other Microsoft BI technologies.

Audience profile

This course is not designed for students who are new to SQL Server 2014 BI technologies; it is targeted at BI professionals with experience of implementing solutions with SQL Server database Engine, SQL Server Integration Services, SQL Server Analysis Services, and SQL Server Reporting Services.

At course completion

After completing this course, students will be able to:

  • Plan a BI solution.
  • Plan SQL Server BI infrastructure.
  • Design a data warehouse.
  • Design an extract, transform and load (ETL) solution.
  • Design analytical data models.
  • Plan a BI delivery solution.
  • Design a Reporting Services solution.
  • Design a Microsoft Excel-based reporting solution.
  • Plan a SharePoint Server BI solution.
  • Monitor and optimize a BI solution.
  • Operate a BI solution.
MS20761 - Querying Data with Transact-SQL

About this course

This course is to give students a good understanding of the Transact-SQL language which is used by all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. As such, the primary target audience for this course is: Database Administrators, Database Developers and BI professionals.

The course will very likely be well attended by SQL power users who aren’t necessarily database-focused; namely, report writers, business analysts and client application developers.

Audience profile

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

At course completion

After completing this course, students will be able to:

  • Describe the basic architecture and concepts of Microsoft SQL Server 2016.
  • Understand the similarities and differences between Transact-SQL and other computer languages.
  • Write SELECT queries
  • Query multiple tables
  • Sort and filter data
  • Describe the use of data types in SQL Server
  • Modify data using Transact-SQL
  • Use built-in functions
  • Group and aggregate data
  • Use subqueries
  • Use table expressions
  • Use set operators
  • Use window ranking, offset and aggregate functions
  • Implement pivoting and grouping sets
  • Execute stored procedures
  • Program with T-SQL
  • Implement error handling
  • Implement transactions
MS20762 - Developing SQL Databases

About this course

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

Audience profile

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

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

At course completion

After completing this course, students will be able to:

  • Design and Implement Tables.
  • Describe advanced table designs
  • Ensure Data Integrity through Constraints.
  • Describe indexes, including 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.
MS20764 - Administering a SQL Database Infrastructure

About this course

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

Audience profile

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

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

At course completion

After completing this course, students will be able to:

  • Authenticate and authorize users
  • Assign server and database roles
  • Authorize users to access resources
  • Protect data with encryption and auditing
  • Describe recovery models and backup strategies
  • Backup SQL Server databases
  • Restore SQL Server databases
  • Automate database management
  • Configure security for the SQL Server agent
  • Manage alerts and notifications
  • Managing SQL Server using PowerShell
  • Trace access to SQL Server
  • Monitor a SQL Server infrastructure
  • Troubleshoot a SQL Server infrastructure
  • Import and export data
MS20765 - Provisioning SQL Databases

About this course

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

Audience profile

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

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

At course completion

After completing this course, students will be able to:

  • Provision a Database Server
  • Upgrade SQL Server
  • Configure SQL Server
  • Manage Databases and Files (shared)
MS20767 - Implementing a SQL Data Warehouse

About this course

This course describes how to implement a data warehouse platform to support a BI solution. Students will learn how to create a data warehouse with Microsoft® SQL Server® 2016 and with Azure SQL Data Warehouse, to implement ETL with SQL Server Integration Services, and to validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.

Audience profile

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

At course completion

After completing this course, students will be able to:

  • Describe the key elements of a data warehousing solution
  • Describe the main hardware considerations for building a data warehouse
  • Implement a logical design for a data warehouse
  • Implement a physical design for a data warehouse
  • Create columnstore indexes
  • Implementing an Azure SQL Data Warehouse
  • Describe the key features of SSIS
  • Implement a data flow by using SSIS
  • Implement control flow by using tasks and precedence constraints
  • Create dynamic packages that include variables and parameters
  • Debug SSIS packages
  • Describe the considerations for implement an ETL solution
  • Implement Data Quality Services
  • Implement a Master Data Services model
  • Describe how you can use custom components to extend SSIS
  • Deploy SSIS projects
  • Describe BI and common BI scenarios
MS20768 - Developing SQL Data Models

About this course

This course is aimed at database professionals who fulfil a Business Intelligence (BI) developer role. This course looks at implementing multidimensional databases by using SQL Server Analysis Services (SSAS), and at creating tabular semantic data models for analysis with SSAS.

Audience profile

The primary audience for this course are database professionals who need to fulfil BI Developer role to create enterprise BI solutions.  Primary responsibilities will include:

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

The secondary audiences for this course are ‘power’ information workers/data analysts.

At course completion

After completing this course, students will be able to:

  • Describe the components, architecture, and nature of a BI solution
  • Create a multidimensional database with analysis services
  • Implement dimensions in a cube
  • Implement measures and measure groups in a cube
  • Use MDX syntax
  • Customize a cube
  • Implement a tabular database
  • Use DAX to query a tabular model
  • Use data mining for predictive analysis
MS40008 - Updating your Database Skills to Microsoft® SQL Server® 2012

About this course

This course provides existing SQL Server database professionals with the knowledge and skills to use new and enhanced capabilities in SQL Server 2012.

Audience profile

This course is intended for database professionals with experience of using SQL Server 2008 R2.

At course completion

After completing this course, students will be able to:

  • Describe key new and enhanced features in SQL Server 2012.
  • Install SQL Server 2012.
  • Use enhanced tools and PowerShell support to manage SQL Server 2012.
  • Use enhanced Transact-SQL and storage capabilities to develop SQL Server 2012 databases.
  • Use new and enhanced performance capabilities to optimize a SQL Server 2012 database.
  • Use new availability and data recovery technologies to provide high availability.
  • Use new and enhanced security capabilities in SQL Server 2012.
  • Use SQL Azure.
  • Describe new Business Intelligence (BI) capabilities in SQL Server 2012.
MS40009 - Updating your Business Intelligence Skills to Microsoft® SQL Server® 2012

About this course

This course provides existing SQL Server Business Intelligence (BI) professionals with the knowledge and skills to use new and enhanced BI capabilities in SQL Server 2012.

Audience profile

This course is intended for BI professionals with experience of using SQL Server 2008 R2.

At course completion

After completing this course, students will be able to:

  • Describe key new and enhanced features for BI in SQL Server 2012.
  • Use new and enhanced features in SQL Server Integration Services.
  • Manage data quality by using SQL Server Data Quality Services.
  • Manage master data by using new and enhanced features of SQL Server Master Data Services.
  • Use new and enhanced features of SQL Server Reporting Services.
  • Create tabular data models with PowerPivot and DAX.
  • Implement a tabular data model in SQL Server Analysis Services.
  • Use Power View to create interactive data visualizations.
  • Integrate Microsoft cloud technologies into a BI solution.
MS50592 - Advanced SQL Azure

About this course

This course is an in-depth look at SQL Azure, the database cloud offering in Windows Azure. Learn the basics around server and database provisioning, valid Azure TSQL, and how security is implemented and managed. Advanced topics include partitioning with sharding, database design optimization, backup and synchronization via Synchronization Framework and Azure Data Sync and migrating various database scenarios to SQL Azure.

Audience profile

IT Pros that want to learn to maintain SQL Azure databases and architects that want to learn to leverage SQL Azure in their applications.

At course completion

After completing this course, students will be able to:

Learn to design high performance cloud based data storage solutions using SQL Azure. Topics include security, programming, maintaining, optimizing, migrating and synchronizing with SQL Azure. SQL Azure Reporting is also explored.

MS50596 - Dashboards for Monitoring, Analyzing and Managing

About this course

This course is designed to empower the students to effectively design web-based dashboards by utilizing the three main tools for dashboard building in the Microsoft tool set. Report Builder 3.0 from SQL Reporting Services, Dashboard Designer from PerformancePoint Services and SharePoint Designer. In using each of these tools you gain the best of breed to combine features and develop dashboards that are highly effective for monitoring, analyzing and managing your business.

Audience profile

The goal of creating effective dashboards is a collaborative team effort. This course is targeted at that team.

  • The Project Manager to gain an understanding of best practices, follow a design methodology and gain an understanding of ineffective dashboard designs.
  • The Business Managers so they can understand the input that they will need to provide to the project team and what they should expect back from these dashboards.
  • IT as they manage the infrastructure.
  • Report Builders’ so their designs can be effectively presented to the report consumer.
  • Business Intelligence/SQL Personnel as it is their data that is displayed and analyzed.

This course utilizes the tools in such a manner that we do not expect the students to have developer level skills.

At course completion

After completing this course, students will be able to:

  • Utilize the dashboard development methodology
  • Optimize visual design of dashboards
  • Structure dashboards hierarchies
  • Understand the basics of data visualizations
  • List the thirteen crucial errors in dashboard design
  • Implement user menus in scorecards
  • Understand how to connect into multiple data sources
  • Gain familiarity with the definitions of common Business Intelligence terms
  • Learn the methodology for connecting into and displaying near-real-time data
  • Create parameterized reports
  • Create sub reports
  • Create map based reports
  • Use the Decomposition Tree in PerformancePoint Services
  • Connect together SharePoint components into PerformancePoint components
  • Use report parts as a library
  • Know when to use Report Builder, Dashboard Designer and SharePoint Designer
  • Use and understand Report Builder 3.0
  • Use and understand Dashboard Designer from PerformancePoint Services
  • Use and understand SharePoint Designer for working with dashboards
  • Utilize Excel Services to share Excel workbooks
  • Design and implement KPIs
  • Understand the scoring methodologies used with indicators to change visual displays
  • Be able to develop proper filters for easy end-user click to detail on dashboards
  • Group scorecards into dashboards and link them together
  • Modify the web page hosting the dashboards for branding
  • Implement master pages in dashboards for consistency with company standards.
  • Develop multiple-valued KPIs. For example this year actual and target and last year actual and target at the same relative point in time
  • Implement time intelligence features to query such as Year-To-Date, Last 6 Months etc.
  • Develop filters for scorecards
  • Understand the implications of where a filter is applied
  • Create effective graphs
  • Create visual reports
  • Create effective gauges
  • Utilize sparklines in reports
  • Understand how to secure dashboards
  • Use dynamic hierarchies in dashboards
  • Implement user menus in dashboards
  • Create monitoring dashboards
  • Create analytical dashboards
  • Create management dashboards
MS55005 - Microsoft Report Builder 3.0 with SQL 2008R2, SQL 2012, and SQL 2014

About this course

This course provides students with the necessary knowledge to develop reports using Microsoft Report Builder 3.0. The training environment includes SQL 2008R2, SQL 2012, and SQL 2014 Standard and Enterprise, so that the students can utilize Report Builder 3.0 and generate reports from multiple sources to investigate the different features of each release.

The course covers the Report Builder 3.0 wizards, basics of report design, intermediate reports with report parameters, a detailed section exploring report expressions and how to properly configure them, filters, report visualizations including graphs, charts, images, and gauges, advanced reporting including the utilization of maps, interactive reports, Report Parts, subreports, subscriptions, and exporting options.

Audience profile

This course is intended for power users, developers, and IT professionals that will be involved with the design, development, and maintenance of reports created with Report Builder 3.0.

At course completion

After completing this course, students will be able to:

  • Plan the reports.
  • Use Report Builder 3.0 and understand the parts of the interface.
  • Launch Report Builder 3.0 from multiple sources.
  • Understand management options.
  • Create embedded data sources and datasets.
  • Create shared data sources and datasets.
  • Create shared data sources and datasets.
  • Understand and utilize the Table or Matrix Wizard.
  • Understand and utilize the Chart Wizard.
  • Understand and utilize the Map Wizard.
  • Understand and utilize lists.
  • Understand and utilize tables.
  • Understand and utilize matrices.
  • Understand and utilize data regions.
  • Understand and utilize parameters.
  • Understand and utilize expressions.
  • Understand and utilize report parts.
  • Understand and utilize formatting options.
  • Understand visualization options.
  • Understand and utilize charts.
  • Understand and utilize sparklines.
  • Understand and utilize gauges.
  • Understand and utilize maps.
  • Understand filtering, grouping, and sorting.
  • Understand and utilize dynamic headers and footers.
  • Understand and utilize report templates.
  • Understand and utilize HTML and texboxes.
  • Understand and utilize lists as containers.
  • Understand and utilize subreports.
  • Understand report subscription options.
  • Understand security.
MS55069 - PowerShell for SQL Server Administrators

About this course

This course provides candidates with the knowledge and skills needed to use PowerShell and SMO components for SQL Server administration on SQL Server 2016, 2014 or 2012. Students will learn how to manage day-to-day and scheduled maintenance tasks. The main focus will be administration of the database engine, but optional material & exercises on Analysis Services (SSAS) and Integration Services (SSIS) are also included.

If all the optional lab exercises are included, the class may need to be taught in three days instead of two.

Audience profile

This course is intended for SQL Server administrators who work in a Windows network environment. At least one year of experience administering SQL Servers and using PowerShell is recommended.

At course completion

After completing this course, students will be able to:

  • Install and Configure SQL Server and all its components using PowerShell
  • Manage day-to-day SQL Server Administration with PowerShell
  • Maintain the SQL Server environment using PowerShell scripting and programming options
MS55073 - Master Data Services, Data Quality Services with SQL 2012-2014 and Excel

About this course

Studies show that data decays at about 2% a month all organizations need to work from reliable information while ensuring that the integrity of information and consistency of data is constant across different applications. Microsoft SQL Server 2012-2014 Master Data Services is a powerful feature designed to help an organization create a structure and hierarchy for data, so that data collected and used across multiple departments, silos and databases is standardized and aligned. This ensures that different databases are interoperable. When combined with Data Quality Services and Excel a complete end to end system is available.

Audience profile

This course is intended for SQL Professionals, Business Intelligence Developers, Data Analysts and Data Stewards and Project Managers that need to learn how to utilize Master Data Services.

At course completion

After completing this course, students will be able to:

  • Have a basic understanding of the concepts behind master data management.
  • Configure Master Data Services.
  • Create models and entities.
  • Add attributes including domain-based attributes.
  • Add a member via the web interface.
  • Reverse a transaction.
  • Create and configure attribute groups.
  • Create and configure derived hierarchies.
  • Create and configure collections.
  • Create a leaf member with T-SQL.
  • Delete a member with the web interface and examine results in SSMS.
  • View errors in batch files.
  • Load leaf members with SQL Server Integration Services and flat files.
  • Create and configure versions.
  • Navigate the business rules interface.
  • Create a business rule.
  • Populate a value based on another value.
  • Explore and fix validation issues.
  • Set up security in MDS.
  • Create and configure a subscription view.
  • Create a connection to an MDS database using Excel.
  • Publish data to an MDS database using Excel.
  • Filter data using Excel.
  • Save a query to Excel.
  • Create an entity from data in Excel.
  • Create a new knowledge base.
  • Create a DQS Quality Cleansing Project.
MS55096 - Securing Data on Microsoft SQL Server 2012

About this course

This course is to provide students with the database and SQL server security knowledge and skills necessary to secure database servers.

Audience profile

This course is intended for Database Developers, Security Professionals, Database Administrators and other people that need to secure database servers.

At course completion

After completing this course, students will be able to:

  • Understand concepts of security and privacy
  • Recognize the difference between security and privacy
  • Make security steps during installation
  • Take necessary steps after installation
  • Get full understanding of authentication and authorization
  • Implement sever and database side security
  • Understand how SQL Server can protect data
  • Understand basic cryptography
  • Understand SQL Server encryption model
  • Implement symmetric encryption
  • Improve your auditing skills
  • Use SQL Server Auditing feature
  • Collect digital evidence in your environment
  • Go beyond SQL Server to protect your data assets
MS55119 - SQL Server 2012 Reporting Services

About this course

This course is intended for information workers and database professionals who are interested in expanding their knowledge about SQL Server 2012 Reporting Services. During this course, attendees will learn how to Report Designer in SSDT and Report Builder, work with solutions and projects, design basic reports, enhance reports with formatting and images, effectively group and summarize data, work with parameterized reports, incorporate charts and custom maps, and work with drill-through reports, and manage reports.

Audience profile

This course is intended for information workers and database professionals who have a general familiarity with databases prior to the class. Working knowledge of Microsoft SQL Server or Microsoft Office applications is beneficial.

At course completion

  • Work with solutions and projects.
  • Design basic reports.
  • Work with table, matrix, and list report items.
  • Enhance reports with formatting and images.
  • Effectively group and summarize data.
  • Work with parameterized reports.
  • Incorporate charts and custom maps.
  • Work with drill-through reports.
  • Manage reports.
  • Utilize Report Builder.
MS55120 - Quick Microsoft SQL Server 2012-2014 Integration Services

About this course

This course is intended for those that are new to SQL Server Integration Services or are interested in learning the features available. This course uses an instructor-led topic explanation, instructor performing detailed demonstrations, then the student performing exercises to duplicate what the instructor demonstrated. This style of training is a combination of traditional classroom training and mentored learning. Additionally, videos of the demonstrations performed by the course author are included with the course as a take-away. The course completes with additional scenario-based labs to reinforce the course content.

Audience profile

This course is intended for IT Professionals.

At course completion

After completing this course, students will be able to:

  • Understand packages.
  • Manage with Control Flow.
  • Move data with Data Flow.
  • Understand variables.
  • Understand parameters.
  • Utilize the Import/Export Wizard.
  • Work in the Explore window.
  • Create SQL Server Integration Services packages.
  • Utilize Connection Managers.
  • Code the Script Task.
  • Utilize Looping and Sequence Tasks.
  • Utilize Data Preparation Tasks.
  • Load data with the Analysis Services Tasks.
  • Use the Workflow Tasks.
  • Manage SQL with the SQL Tasks.
  • Administration of SQL using the SQL Management Objects Tasks.
  • Optimize sources for extraction.
  • Use Destinations and understand choices.
  • Examine the Transformation and other Tasks (about 25 of them).
  • Create dynamic packages.
  • Utilize SQL Server Integration Services data typing.
  • Define and use variables and parameters.
  • Use expressions in packages.
  • Utilize sequences in a container.
  • Utilize container loops.
  • Perform joins with the Lookup Transformation.
  • Perform joins with the Merge Transformation.
  • Examine the SSIS engine.
  • Use the best practices.
  • Design to troubleshoot: using Precedence Constraints.
  • Work with advanced logging and reporting.
  • Handle errors.
  • Understand how to choose the Script Task or Script Component.
  • Work with XML.
  • Use package hierarchies: Parent Child.
  • Understand deployment strategies.
  • Understand how to use what they’ve learned in real-world scenarios.
MS55123 - Writing Reports with Report Builder and SSRS Level 1

About this course

In this course, students will continue their learning on the foundations of report writing with Microsoft® SQL Server® Report Builder and SSRS. The focus will be on report writing by connecting to a database and manipulating the data for presentation including: creating table and matrix reports, formatting reports, grouping report data, creating simple and complex expressions, displaying aggregated data, sorting and filtering data, charting data, and preparing reports for printing and exporting. Report Builder 3.0 is available for Microsoft® SQL Server® versions 2014, 2012, and 2008 R2.

Audience profile

The primary audience for this course are persons who are new to reporting with Microsoft® SQL Server® Report Builder and SSRS, persons who are transitioning from another reporting software application, and persons who are existing Report Builder and SSRS report authors.

The secondary audience for this course are persons who are using Report Designer (SSRS).

Course participants may be business analysts, programmer analysts, data analysts, database administrators, or IT professionals and may or may not have experience with Microsoft® SQL Server® Report Builder and SSRS, programming (Visual Basic), and/or Transact-Structured Query Language (T-SQL) experience.

At course completion

After completing this course, students will be able to:

  • Navigate the Report Builder Environment
  • Create table reports
  • Format reports
  • Create basic and complex expressions
  • Group report data
  • Create matrix reports.
  • Sort and filter data.
  • Summarize data with charts.
  • Print and export reports.
MS55124 - Quick Microsoft SQL Server 2012 Reporting Services

About this course

This fast-paced course is intended for IT professionals who are interested in quickly learning how to use the Reporting Services development tools to create reports. This course also covers how to use the Reporting Services management and administrative tools to manage a Reporting Services solution.

Audience profile

This course is intended for SQL professionals, Microsoft Reporting Services administrators and report developers, and business intelligence professionals.

At course completion

  • Understand version changes of SSRS from 2008-2012.
  • Understand Reporting Services installation and architecture.
  • Understand and utilize Reporting Services tools.
  • Understand and utilize Wizards.
  • Create and configure data sources.
  • Create and configure datasets.
  • Understand security in connections.
  • Create and configure Tables.
  • Create and configure Matrices.
  • Create and configure Lists.
  • Understand and utilize Report Items.
  • Understand and utilize Report Parts.
  • Understand and utilize Charts.
  • Understand and utilize Gauges.
  • Understand Dashboards.
  • Understand and utilize Maps.
  • Understand and utilize Data Bars.
  • Understand and utilize Sparklines.
  • Understand Key Performance Indicators.
  • Understand and utilize Expressions.
  • Understand and utilize Functions.
  • Understand and utilize Interactivity.
  • Understand and utilize Parameters.
  • Understand and utilize Conditional Formatting.
  • Understand Templates.
  • Understand and utilize Subreports.
  • Deploy reports.
  • Secure and manage content.
  • Understand and utilize Caching.
  • Understand and utilize Snapshots.
  • Understand and utilize Report History.
  • Understand how to complete other administrative tasks.
MS55125 - Quick Microsoft SQL Server 2012 Analysis Services

About this course

This fast-paced course is intended for IT professionals who are interested in quickly learning how to utilize an Analysis Services multidimensional or tabular solution. This course also discusses how to use the Analysis Services development tools to create both multidimensional and tabular projects, and follows with explanations on how to use the management and administrative tools to manage both Analysis Services solutions.

Audience profile

This course is intended for SQL professionals, Microsoft Analysis Services cube and report developers, and business intelligence professionals.

At course completion

After completing this course, students will be able to:

  • Understand common Analysis Services solutions.
  • Understand version changes of SSAS from 2008-2014.
  • Understand Analysis Services installation and architecture.
  • Understand how to choose the right model.
  • Understand the Analysis Services tools available.
  • Understand the multidimensional model.
  • Utilize data sources and data source views.
  • Create a cube.
  • Understand and utilize dimensions.
  • Understand and utilize attributes.
  • Understand and utilize relationships.
  • Understand and utilize hierarchies.
  • Understand and utilize measures and measure groups.
  • Understand and utilize calculated members.
  • Understand and utilize perspectives.
  • Understand and utilize translations.
  • Browse perspectives and translations.
  • Understand and utilize deployment options.
  • Understand and utilize processing strategies.
  • Understand and utilize security.
  • Deploy a multidimensional model.
  • Understand the tabular model.
  • Create a tabular project.
  • Analyze the data using Microsoft Excel.
  • Create and configure calculated measures and calculated fields.
  • Backup and Restore.
MS55128 - Writing Reports with Report Builder and SSRS Level 2

About this course

In this course, students will continue their learning on the foundations of report writing with Microsoft® SQL Server® Report Builder and SSRS. The focus will be on report creation by connecting to a database and manipulating the data for presentation including: creating parameter reports, creating list reports, adding complex expressions to reports, adding images and subreports to reports, adding drilldown and drillthrough functionality, and adding sparklines, data bars, and indicators to reports. Report Builder 3.0 is available for Microsoft® SQL Server® versions 2014, 2012, and 2008 R2.

Audience profile

The primary audience for this course are persons who are new to reporting with Microsoft® SQL Server® Report Builder and SSRS, persons who are transitioning from another reporting software application, and persons who are existing Report Builder and SSRS report authors.

The secondary audience for this course are persons who are using Report Designer (SSRS).

Course participants may be business analysts, programmer analysts, data analysts, database administrators, or IT professionals and may or may not have experience with Microsoft® SQL Server® Report Builder and SSRS, programming (Visual Basic), and/or Transact-Structured Query Language (T-SQL) experience.

At course completion

After completing this course, students will be able to:

  • Create parameter reports.
  • Create list reports.
  • Format reports with complex expressions.
  • Add images and subreports.
  • Add drilldown and drillthrough functionality.
  • Add sparklines, data bars, and indicators.
MS55144 - SQL Server 2014 Performance Tuning and Optimization

About this course

This course is designed to give the right amount of Internals knowledge, and wealth of practical tuning and optimization techniques, that you can put into production. The course offers a comprehensive coverage of SQL Server architecture, indexing and statistics strategies, optimize transaction log operations, tempdb and data file configuration, transactions and isolation levels, and locking and blocking. The course also teaches how to create baselines and benchmark SQL Server performance, how to analyze workload and figure out where performance problems are, and how to fix them. Coverage of in-memory tables and stored procedures along with an introduction to this exciting new technology is included.

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:

  • Understand and utilize the new cardinality estimator.
  • Understand and utilize memory-optimized tables.
  • Understand performance.
  • Understand and utilize startup stored procedures.
  • Understand database structures.
  • Understand and utilize Instant File Initialization.
  • Understand how SQL stored data.
  • Understand how SQL locates data.
  • Understand temporary table internals.
  • Understand and utilize the new cardinality estimator.
  • Understand and utilize memory-optimized tables.
  • Understand performance.
  • Understand and utilize startup stored procedures.
  • Understand database structures.
  • Understand and utilize Instant File Initialization.
  • Understand how SQL stored data.
  • Understand how SQL locates data.
  • Understand temporary table internals.
  • Understand and utilize table valued parameters.
  • Understand concurrency.
  • Understand and utilize transactions.
  • Understand isolation levels.
  • Understand and utilize SQL Server locking architecture.
  • Understand SQL and Storage Area Networks (SAN).
  • Understand and utilize SQL on virtual machines.
  • Understand SQLIO Utility and its uses.
  • Understand and utilize partitioned tables and indexes.
  • Understand and utilize the Resource Governor.
  • Understand and utilize Activity Monitor.
  • Understand Live Query Statistics.
  • Understand how to monitor SQL using Transact-SQL.
  • Understand and utilize performance DMVs.
  • Understand indexes and their importance.
  • Understand index types.
  • Create and alter indexes.
  • Understand and utilize index metadata.
  • Understand and utilize Database Tuning Advisor.
  • Understand and utilize Index Data Management Objects.
  • Understand fragmentation of indexes and utilize page splits.
  • Understand index storage strategies.
  • Understand and utilize indexed views.
  • Understand monitoring indexes.
  • Understand index best practices.
  • Understand and utilize statistics objects.
  • Understand and utilize histogram.
  • Understand and utilize new vs old cardinality estimator.
  • Understand and utilize incremental statistics.
  • Understand and utilize computed columns.
  • Understand and utilize filtered statistics.
  • Understand and utilize ascending keys.
  • Understand and utilize statistics maintenance plan.
  • Understand architecture.
  • Understand and utilize tables and indexes.
  • Understand and utilize the hash index.
  • Understand and utilize natively compiled stored procedures.
  • Understand restrictions.
  • Understand and utilize the Analyze Migrate Report tool.
  • Understand and utilize in-memory data management views.
  • Understand and utilize the SQL Trace Default template.
  • Understand and utilize the SQL Profiler Tuning template.
  • Create and utilize a template for slow running queries.
  • Understand and identify long running queries.
  • Use Profiler to detect deadlocks.
  • Use Profiler to detect a blocked process.
  • Understand and utilize query hints.
  • Create and test a plan guide.
  • Allow SQL Profiler to help create a plan.
  • Understand and utilize plan freezing.
MS10964 - Cloud & Datacenter Monitoring with System Center Operations Manager

About this course

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

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

Audience profile

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

At course completion

After completing this course, students will be able to:

  • Plan for the deployment of System Center 2012 R2 Operations Manager including:
    • Defining hardware and software requirements.
    • Describing security considerations.
    • Architect a highly available System Center and Microsoft SQL Server platform utilizing Microsoft SQL Server AlwaysOn.
    • Planning for migration and upgrade scenarios to System Center 2012 R2 Operations Manager.
  • Customize the Operations Console with User Roles.
  • Perform different methods of Agent deployment with System Center 2012 R2 Operations Manager.
  • Implement key Management Pack concepts and elements including Management Packs Templates.
  • Configure Notifications, Reporting, and Service Level Tracking in System Center 2012 R2 Operations Manager.
  • Configure the following:
    • Audit Collection Services.
    • Agentless Exception Monitoring.
    • Operations Manager SharePoint Web Part in System Center 2012 R2 Operations Manager.
  • Configure Application Performance Monitoring and Network Device monitoring in System Center 2012 R2 Operations Manager.
  • Configure dashboards and widgets in System Center 2012 R2 Operations Manager.
  • Describe how to use new cloud-based features including System Center Global Service Monitor and System Center Advisor.
  • Configure integration between System Center 2012 R2 Operations Manager and other System Center 2012 R2 components.
  • Troubleshoot an Operations Manager Management Group.
  • Perform disaster recovery in System Center 2012 R2 Operations Manager.
MS10747 - Administering System Center 2012 Configuration Manager

About this course

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

 

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

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

Audience profile

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

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

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

At course completion

After completing this course, students will be able to:

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