MAS - The Computer Workshop Inc - GS02F0069X

All Course Descriptions can be found at www.tcworkshop.com

Revised June 2020

The Computer Workshop, Inc Technical and Business User Training Your Link to the Future _________________________________________________________

GENERAL SERVICES ADMINISTRATION

Federal Supply Service Authorized Federal Supply Schedule Price List

On-line access to contract ordering information, terms and conditions, up-to-date pricing, and the option to create an electronic delivery order are available through GSA Advantage! a menu-driven database system. The

INTERNET address GSA Advantage! is: GSAAdvantage.gov.

Schedule Title: Multiple Award Schedule FSC Class/Product code:

Special Item Number MAS 61130- Professional Development Training Services: Multiple Award, Federal Supply Schedule 874, Instructor Led Training & Web Based Training, Course Development and Test Administration.

Contract Number: GS-02F-0069X For more information on ordering from Federal Supply Schedules click on the FSS Schedules button at www.fss.gsa.gov.

Contract period: Jan 24, 2016 – Jan 23, 2023

Contractor's Name, address, phone and internet address:

The Computer Workshop, Inc.

5200 Upper Metro Place, Suite 140 Dublin, OH 43017 Toll-Free Phone: 800-639-3535 Columbus OH Area Phone: 614-798-9505 Columbus OH Fax: 614-798-9535

Federal Tax ID: 31-1312415

Email: Training@tcworkshop.com

Web: www.tcworkshop.com

Business Size: Small, Woman Owned Business

Customer Information:

1a. Table of awarded special item number(s) with appropriate cross-reference to item descriptions and awarded price(s).

• Special Item Number MAS Category 61130 -Training Services PCS: 61130

Multiple Award, Federal Supply http://www.tcworkshop.com/ http://www.fss.gsa.gov/ mailto:Training@tcworkshop.com http://www.tcworkshop.com/

Schedule 874, Instructor Led Training & Web Based Training, Course Development and Test

Administration.

1b. Identification of the lowest priced model number and lowest unit price for that model for each special item number awarded in the contract. This price is the Government price based on a unit of one, exclusive of any quantity/dollar volume, prompt payment, or any other concession affecting price. Those contracts that have unit prices based on the geographic location of the customer, should show the range of the lowest price, and cite the areas to which the prices apply. Keyboarding (Typing) Level 1 for Windows, $88.29

1c. Hourly Rates: N/A.

2. Maximum order: $1,000,000.00

3. Minimum order: $100.00

4. Geographic coverage (delivery area): Public classes are delivered in Dublin Ohio. On-Site group classes are delivered at the Client site anywhere in the United States.

5. Point(s) of production: Dublin, Ohio (Franklin County)

6. Discount from list prices or statement of net price: 1% - 57%

7. Quantity discounts. None

8. Prompt payment terms. None

9.a Notification that Government purchase cards are accepted at or below the micro-purchase threshold. Yes, we accept Government purchase cards at or below the micro-purchase threshold.

9.b Notification whether Government purchase cards are accepted or not accepted above the micro-purchase threshold. Yes, we accept Government purchase cards above the micro-purchase threshold.

10. Foreign items (list items by country of origin). N/A

11.a Time of delivery: The Contractor will deliver classes as negotiated with the ordering agencies

11.b Expedited Delivery: All Training is available for expedited delivery.

11.c - Overnight and 2-day delivery: N/A

11.d – Urgent Requirements: N/A

12. F.O.B. point(s): Destination

13a. Ordering address(es).

5200 Upper Metro Place, Suite 140 Dublin, Ohio 43017

13b. Ordering procedures: For supplies and services, the ordering procedures, information on Blanket Purchase Agreements (BPA's) are found in Federal Acquisition Regulation (FAR) 8.405-3.

General Procedures are:

1) Client requests training/outline

2) TCW send outline with options for class dates

3) Client requests Instructor Bio/Resume

4) TCW sends Bio/Resume

5) Client schedules class after reviewing Bio/Resume

6) Client attends class

7) TCW invoices client

8) Contractor Bills TCW or we use a staff instructor.

14. Payment address(es).

5200 Upper Metro Place, Suite 140 Dublin, OH 43017 Attn: Kim McFarland

15. Warranty provision. N/A

16. Export packing charges, if applicable. N/A

17. Terms and conditions of Government purchase card acceptance (any thresholds above the micro-purchase level). We accept the terms and conditions of Government purchase card acceptance.

18. Terms and conditions of rental, maintenance, and repair (if applicable). N/A

19. Terms and conditions of installation (if applicable). N/A

20. Terms and conditions of repair parts indicating date of parts price lists and any discounts from list prices (if applicable). N/A

20a. -- Terms and conditions for any other services (if applicable). N/A

21.-- List of service and distribution points (if applicable).

22.-- List of participating dealers (if applicable). N/A

23.-- Preventive maintenance (if applicable). N/A

24a. Special attributes such as environmental attributes (e.g., recycled content, energy efficiency, and/or reduced pollutants). N/A

24b. If applicable, indicate that Section 508 compliance information is available on Electronic and Information Technology (EIT) supplies and services and show where full details can be found (e.g. contractor's website or other location.) The EIT standards can be found at: www.Section508.gov/. N/A

25. Data Universal Number System (DUNS) number. 195816822

26. Notification regarding registration in Central Contractor Registration (CCR) database.

The Computer Workshop is registered in CCR with the following data:

Company Name: COMPUTER WORKSHOP INC, THE

DUNS: 195816822

The Computer Workshop, Inc. is your expert resource for

“training and business solutions”.

Why purchase training and services from TCW?

• Over 32 years’ experience delivering high quality solutions to our clients!

• Have helped over 200,000 students increase their productivity by using 75% or more of their software features.

Average person uses 10% - 15% of the capability of their software and wastes an average of 2 hours a day getting the job done, but not the most efficient way!

• Have over 1,000 courses - Technical and Business Application (end-user) training, Project Management and

Business Analysis courses, Professional Development seminars, Programming and Web Design, Graphics (both

Windows and Macintosh), and more. Check our web site for more information.

• Expert Trainers - consistently get high scores on evaluations - 98.9% satisfaction rate!

• Partnerships with industry giants to bring the best in the country to Columbus Ohio, Cleveland Ohio, Atlanta, Georgia and client locations throughout the US.!

• Customized training solutions and effective rollouts of new versions of the software. We publish many of our own course materials - so getting the right content for your group is a breeze!

• College Credits - .5 college credits for each day of training for any course taken at TCW is available for added tuition costs.

• Facility Rentals at an affordable price - including video conferencing!

• Start increasing your productivity and profit today! Call one of our Education Specialists to complete your training project.

• At each regional training facility, we offer a free continental breakfast. If you would like to have us set up a continental breakfast at your site during your training, see your Account Executive!

Cleveland

Our Services Training The Computer Workshop, Inc. provides training in the following areas:

http://www.section508.gov/

Business Applications

Technical Skills

Professional Development

Project Management & Business Analysis

We have trained over 200,000 students. We offer courses on all major software programs in all versions plus we have a wide network of Partners to provide training in specialty areas as well as degree programs through OCU.

We offer a variety of training options to fit your needs:

Public

Closed Group Classes

Private Instruction or Consulting

Instructor-Assisted (open lab)

Try out our ‘traveling computer labs’ complete with network capabilities we can provide training at any location.

Virtual Classes Most of our classes can be attended in a virtual environment. This is different from taking a traditional on-line class, in that you will see and hear from our instructor in a live virtual environment. We typically use the Microsoft Teams platform but can use the client’s platform if necessary. Other platforms may include Adobe, Go-to-meeting, Zoom. This is a good alternative when you don’t have the facilities or enough attendees to have the class at your location, and you don’t want to take the class by yourself in an on-line environment. You will be able to communicate directly with the instructor and do your labs and participate as class attendees that are at one of our training facilities.

On-Line Training Do you find yourself needing features explained at the most inopportune times? The Computer Workshop, Inc offers

Web-based delivery of material that supplements our informative instructor led courses. Call one of our Education

Specialists today for more information!

Curriculum/Course Materials The staff at The Computer Workshop, Inc. designs curriculum in-house which gives us the ability to modify, update and custom design a course when needed. Our course materials are designed for effective use in class as well as reference material after class. Our manuals include step-by-step exercises that can be reviewed using the after-class practice CD.

Learning Management System (LMS) The LMS system manages your entire learning process–including e-learning modules for all your processes, pre- and post-training evaluations, reporting and tracking of training. Blending the LMS with our classroom training, will provide your organization a heads up on the competition. The LMS also can be a repository of information that only deals with your organization.

Programming and Database Solutions The Computer Workshop offers End-to-End solutions! We can offer Business Process Consulting, Application

Development, Database Administration, Software Quality Assurance, Software Product Development and Systems

Integration. Our experience includes developing products, designing solutions, and providing services to our clients’ business!

Web Site and Graphic Design If you are not doing at least some part of your business over the Web, you’re missing out on opportunities. The Computer

Workshop, Inc. can design or upgrade your web site to bring more business your way. Our Desktop Publishing Division will design a variety of professional design products for your company.

About our Trainers/Consultants The Computer Workshop employs both full-time instructors and consultants. This gives us the ability to control standard classes while giving our clients the opportunity to learn from the consultants that specialize in a specific subject or service.

All instructors are experienced computer users and trainers and required to be certified in their respective areas. Each full-time instructor has passed the TCW Train the Trainer course. This rigorous course ensures that each instructor is qualified to train or consult at any of our locations or at your location. On a scale of 1 to 5 with 5 being the highest rating, instructors consistently receive 4.8 or higher!

In addition to teaching at The Computer Workshop, Inc, they have taught at establishments such as OSU, Columbus State

Community College, Jordan College (Michigan) and Lakeland Community College. All instructors have taught in large classroom situations and have also worked one-on-one with clients.

Instructor meetings are held on a regular basis to discuss training issues to constantly update the instructors on new techniques, trends and to share client concerns.

Advantages of The Computer Workshop, Inc Hands-On Training

Our instructors explain a concept and then help the clients complete an exercise pertaining to that concept. Because our class sizes are kept small, each client receives personal attention in understanding the concepts.

Each Student:

• Uses a computer during a class

• Has a student manual to use during class, as well as to use as an after-class reference

• Has Course exercise files for after-class practice

Course Content Sheets

Our Education Specialist/Account Executive work closely with clients to make the perfect fit between course content and client needs. Course content sheets are used to place clients in the proper levels of learning. The course content sheets list all topics covered and have check lists for the client to complete to indicate whether they know, don’t know or need a refresher for that topic.

Individual Attention

Our individualized attention that our instructors give clients before, during and after class, is among the best in the industry.

All clients receive personal attention by:

• Our class size is kept small, and an Assistant Instructor is used if the class size merits

• Instructors’ ability to quickly acknowledge clients’ levels of expertise and problem areas

• Instructors’ ability to relate to real-life examples that pertain to the clients’ use of the software

Reputation/Quality Control

We have been told many times that our training is among the “best in the industry”! We try very hard to live up to that reputation! No company is 100%, but we are very conscientious about the quality of training given.

To ensure continued quality, The Computer Workshop, Inc. responds to client’s suggestions and comments in a timely manner. The course evaluations provide immediate feedback. All evaluations are read, suggestions for improvement are considered and timely action is taken when appropriate.

Our instructors are also required to complete a course evaluation, during and after class. The instructors’ evaluations cover issues such as equipment concerns, proper placement of clients, presentation of curriculum, flow of class and any suggestions for course improvement.

Quality checks are done on a regular basis and suggestions made by our clients are then presented to the Training

Manager to implement in their training department.

Telephone Support

The Computer Workshop, Inc has an unlimited phone support policy. Any student that has taken a class has the privilege of calling with questions regarding any class taken.

Free Refresher Course

A student can retake any class within a year of the original class. This gives students who do not use a software feature immediately a second chance and is just one of the many added benefits our students enjoy. We encourage students to practice what was covered in class when they return to their office. In the busy corporate world this is not always possible, therefore, the retake class becomes a benefit. Students may also come to a self-paced, Instructor-Assisted class at no additional charge to review the course materials and to solve problems.

Training Platforms

We are very diverse in the resources available and provide training on the following platforms (list not all inclusive):

• Windows – all supported versions through Windows 2019

• Linux

• Unix

• Strategic partnerships that bring diversity to our offerings, brand, and topics:

o Microsoft o IBM o Adobe o CompTIA o Unix o PeopleSoft o Cognos o ArcGIS o AutoCAD o AWS o BLOCKCHAIN o EC Council o Kony o Scrum Alliance

Microsoft Office Specialist (MOS) Testing Center

The Computer Workshop, Inc. is proud to be an Authorized Testing Center for the Microsoft Certification programs. We were one of the first training centers in the central Ohio area to recognize that a certification for business user is valuable to not only individuals, but also companies, government agencies, and educational institutions.

What is Microsoft Office Specialist?

Microsoft’s premier certification for desktop applications are Microsoft Office Specialist (Also was MCAS - Microsoft

Certified Application Specialist from 2004 to 2010) - the globally recognized standard for demonstrating desktop skills with the Microsoft Office suite of business productivity applications. Certification provides Microsoft Office and

Microsoft Project users with the ability to put their training and skills to the test. By encouraging individuals to develop advanced skills with Microsoft’s leading business desktop software, the program helps fill the demand for qualified knowledgeable workers in the modern workplace. At the same time, it helps satisfy an organization’s need for assessment of employee skills.

Industry Approvals

• ITPRP– The Independent Third-Party Review Panel - last review completed on May 31, 2005 with no mandatory recommendations.

• WIA– We offer approved courses via the WIA program for Columbus and Cleveland. Others recognizing this status is

Cleveland 1-stop Career Centers, United Labor Agency and Ohio Rehabilitation Services.

• DBE and FBE– We are a Female-owned Business Enterprise which qualifies us as a DBE for ODOT and UCP; an

FBE for COTA, City of Cleveland, and City of Columbus.

TCW Training Alliance Members We have several Training Alliances set up with our software vendors. Being part of an alliance gives The Computer

Workshop, Inc the leading edge on new products and extra support that we can pass onto our clients!

• Microsoft Certified Partner–Being a partner allows us to use Microsoft Official Curriculum in our classrooms.

Another benefit is that with Microsoft help, we can keep abreast of new products and information. This way we can inform our clients of the latest new technology that is available.

• EC-Council Accredited Training Center–The International Council of Electronic Commerce Consultants (EC-

Council) is a member supported professional organization. The purpose of the EC-Council is to support and enhance the role of individuals and organizations who design, create, manage or market e-Business solutions. In partnering with EC-Council, we offer to our clients a valuable course, Ethical Hacking and Countermeasures.

• CompTIA Authorized Training Provider – CompTIA is the voice of the world’s information technology (IT) industry. As a non-profit trade association, we advance the global interests of IT professionals and IT channel organizations and enable them to be more successful with industry-leading IT certifications and IT business credentials, IT education, resources and the ability to connect with like-minded, leading IT industry experts.

• CIW Authorized Training Provider– CIW is an information technology job curriculum and certification for the knowledge economy; designed to help career changers enter the IT industry and experienced and vendor-certified professionals build on existing IT skills. For more information, see our website at www.tcworkshop.com or www.ciwcertified.com.

• Certified Business Professional - CBP is an international industry credential that validates and develops the business professional.

• Authorized VUE Testing Center - We not only teach the technical courses, but also are a testing center for any tests given by Pearson VUE. We also are a testing center for the Microsoft Office Specialist certifications.

Products and Services Price List Code 61130

Please visit our website at www.tcworkshop.com to view a detailed outline for each individual course or call 800-639-3535 to have a Course Content Sheet emailed to you.

Course Title

Description GSA Price with IFF

10553 - Fundamentals of XAML and Microsoft Expression Blend

This 3-day course covers core and essential XAML skills. The learner will gain valuable experience developing

XAML code in both Visual Studio

2010 and Expression Blend 4.

The course teaches the beginner and intermediate tasks that enable the learner to build the foundational skills required to develop professional

Silverlight 4 and WPF applications

$1,491.15

(for the Web, Windows desktops, and

Windows Phone 7 devices). The course will include hands-on labs that comprise approximately 50% of the classroom time and enable the student to learn the essential XAML programming tasks that are the building blocks of real-world applications.

After completing this course, students will be able to:

* Describe XAML-based applications and the tools they can use to build them.

* Create vector graphics with both

Expression Blend 4 and Expression

Design 4.

* Create a Silverlight application and a user interface by using various layout controls and other controls from the toolbox.

* Work with key parts and logic of a

Silverlight application, such as hosting controls, App events, and InitParams.

* Create XAML objects programmatically.

* Work with Resources, Styles, Control Templates, and Behaviors.

* Implement Transforms, Animations, and Visual States in

XAML-based applications.

* Prototype applications by using

SketchFlow.

10554 - Developing Rich Internet

Applications Using Microsoft

Silverlight 4

This course covers intermediate and advanced topics required to develop professional Silverlight 4 applications that can be deployed to the Web, Windows desktops, and Windows

Phone 7 devices. The course will

$2,287.08 include hands-on labs that comprise approximately 50% of the classroom time and enable the student to learn

Silverlight 4 programming within a variety of real-world scenarios.

After Completing this course, students

* Build data-driven Silverlight applications

* Create advanced user interfaces

* Implement advanced media techniques in Silverlight

* Work with Silverlight Media

Framework

* Access hardware in Silverlight applications

* Create application that can be

Globalized & Localized

* Implement Network

Communications

* Deploy Silverlight applications

* Understand the basics of developing Silverlight applications for

Windows Phone 7

* Implement advanced Silverlight techniques for Windows Phone 7

Development

10802 - Microsoft® Enterprise

Search for IT Professionals

This three-day course prepares IT

Professionals to administer enterprise search solutions using Microsoft

SharePoint Server 2010 and Microsoft

FAST Search Server 2010 for

SharePoint. All aspects of administration are covered including search topologies, search sites, content crawling, federation, monitoring, and search reporting.

Audience Profile

This course is intended for IT

$1,699.95

Professionals responsible for administering the search features of

SharePoint Server 2010 and FAST

Search Server 2010 for SharePoint.

10958 - Programming

Fundamentals of Web

Applications

This five-day instructor-led course provides the knowledge and skills to develop web applications by using

Microsoft Visual Studio and

WebMatrix 2.

The course introduces the Microsoft web stack and shows how to use

WebMatrix 2 to develop web applications. The course will help students understand how start with basic web development concepts, and how to use existing applications from the Application Gallery. The course will describe basic web development, including CSS, plug-ins, scripting, basic data access, and application hosting. The course will also describe how to use Windows Azure for application hosting, and how to move beyond WebMatrix 2 into Visual

Studio. Audience Profile

This course is intended for web developers who are beginners and have some knowledge of HTML.

These web developers create sites for a range of different customer and companies, often by observing and re-purposing existing HTML pages, styles, and scripts. They work primarily with static webpages and in-line formatting. They do not often work in a team and use an ISV to host most of their customers’ sites.

Typically, these web developers:

· Create a website for a small company or voluntary organization.

· Add multiple static webpages to a

$2,987.29 website.

10961 - Automating

Administration with Windows

PowerShell®

This five-day course provides students with the fundamental knowledge and skills to use Windows

PowerShell 3.0 for administering and automating administration of

Windows based servers. It focuses on primary Windows PowerShell command-line features and techniques and will provide prerequisite skills supporting many different Microsoft products. This includes Windows Server, Windows

Client, Exchange Server, SharePoint

Server, SQL Server, System Center, and more. In keeping with that goal, this course will not focus on any one of those products, although Windows

Server (which is the common platform for all of those) will serve as the example for the techniques being taught.

In this five day course you will learn to execute and monitor scripts more efficiently through more robust session connectivity, workflow capabilities, improved job scheduling, and Windows PowerShell Web

Access. Learn Windows PowerShell with greater ease through improved cmdlet discovery and simplified, consistent syntax across all cmdlets.

Write Windows PowerShell scripts quicker and more intuitively through the new Integrated Scripting

Environment (ISE) that enables script sharing, which connects IT pros to a larger Windows PowerShell user community. Learn all this and more in this five-day Microsoft Official Course in Windows PowerShell v3.0

$2,483.54

Professionals already experienced in general Windows Server and

Windows Client administration or already experienced in administering and supporting Application servers and services including Exchange, SharePoint, SQL etc. It is broadly intended for students who want to use

Windows PowerShell to automate administrative tasks from the command line, using any Microsoft or independent software vendor (ISV) product that supports Windows

PowerShell manageability.

This course is not intended to be a scripting or programming course and includes only basic coverage of scripting and programming topics.

Students are not expected to have prior scripting or programming experience, and are not expected to have prior Windows PowerShell experience

10964 - Cloud & Datacenter

Monitoring with System Center

Operations Manager

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.

$2,488.58

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

o Integration with System Center

Advisor.

o Integration with Team Foundation

Server.

o IntelliTrace.

o Managing Windows Azure.

10965 - IT Service Management with System Center Service

Manager

This four-day course will provide students with the key knowledge required to deploy and configure

System Center 2012 SP1 Service

Manager. Using hands-on labs, students will learn the following:

· Where Service Manager sits within the System Center 2012 SP1 product.

· What business and technical needs

Service Manager is designed to meet

· How Service Manager aligns itself to

ITIL and MOF.

· How to architect and implement a

System Center 2012 SP1 Service

Manager deployment.

· How to upgrade an existing Service

Manager 2010 environment to System

Center 2012 SP1.

· How to customize System Center

2012 SP1 Service Manager to be in line with corporate standards.

· How to configure Incident and

Problem Management.

· How to configure Activity, Change and Release Management.

· How to configure Service Requests.

· How to configure Service Level

Management.

· How to customize the Self-Service

Portal.

· How to configure Reporting and

Analysis.

· How to configure compliance with the Process Pack for IT GRC

$2,078.77

10967 - Fundamentals of a

Windows Server® Infrastructure

Learn about the Fundamental building blocks that go into building a

$2,362.64

Windows Server infrastructure with

Windows Server 2012. This course covers the basic skills and knowledge that are required in order to build a

Windows Server Infrastructure. It covers networking architecture and topologies, security considerations and best practices as well as basic

Windows Server administration skills and technologies such as Windows

Server 2012 Installation, configuration, maintenance and performance. Within that it will also cover specific areas such as Active Directory Domain

Services (AD DS), Domain Name

Services (DNS), Storage and many others. This course is designed to provide foundational level knowledge needed to prepare students to start a career or cross train in Microsoft

Windows Server technologies.

10969 - Active Directory Services with Windows Server

Get Hands on instruction and practice administering Active Directory technologies in Windows Server 2012 and Windows Server 2012 R2 in this 5-day Microsoft Official Course. You will learn the skills you need to better manage and protect data access and information, simplify deployment and management of your identity infrastructure, and provide more secure access to data. You will learn how to configure some of the key features in Active Directory such as

Active Directory Domain Services

(AD DS), Group Policy, Dynamic

Access Control (DAC), Work Folders, Work Place Join, Certificate Services, Rights Management Services (RMS), Federation Services, as well as integrating your on premise

$2,362.64 environment with cloud based technologies such as Windows Azure

Active Directory. As part of the learning experience, you will perform hands-on exercises in a virtual lab environment.

10982 - Supporting and

Troubleshooting Windows 10

IT Professionals taking Exam 70-697 would benefit from this course. After completing this course, students will be able to:

Describe the processes involved in planning and using a troubleshooting methodology for Windows 10.

Troubleshoot startup issues and operating system services on a

Windows 10 PC.

Resolve issues related to hardware devices and device drivers.

Troubleshoot Windows 10 PCs remotely.

Troubleshoot issues related to network connectivity.

Troubleshoot client configuration failures and GPO application issues.

Troubleshoot issues related to user settings.

Troubleshoot remote connectivity issues.

Resolve issues related to accessing resources from computers that are domain-joined.

Resolve issues related to accessing resources from computers that are not domain-joined.

Troubleshoot issues related to application installation and operation.

Recover a PC running Windows 10.

$2,488.58

10985 - Introduction to SQL

Databases

This three-day instructor-led course is aimed at people looking to move into a database professional role or whose job role is expanding to encompass

$1,491.15 database elements. The course describes fundamental database concepts including database types, database languages, and database designs.

10986 - Updating Your Skills to

SQL Server 2016

This three-day instructor-led 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. Additional this course is for existing SQL Server 2014 MCSAs who want to prepare for the Upgrade exam for SQL Server 2016 certification.

$1,390.40

10987 - Performance Tuning and

Optimizing SQL Databases

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

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

$1,989.86

SQL Server databases.

10988 - Managing SQL Business

Intelligence Operations

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

are business intelligence professionals.

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

$1,491.15

10990 - Analyzing Data with

SQL Server Reporting Services

This five-day instructor-led course teaches students how to implement a

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

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.

$1,491.15

20334 - Core Solutions of Skype for Business 2015

This course provides students with the knowledge and skills that are required to plan, deploy, configure, and administer a Skype for Business

2015 solution. Students will learn how to deploy a multi-site and highly available Skype for Business infrastructure that supports instant messaging, conferencing, Persistent

Chat, archiving, and monitoring.

Students will also learn how to manage and maintain the infrastructure and how to troubleshoot issues that might arise.

This course focuses primarily on an on-premises Skype for Business deployment, but it does include information on how to integrate an on-premises deployment with Skype for Business Online and how to migrate from previous versions of

Lync Server. This course helps students prepare for Exam 70-334.

is information technology (IT) professionals who are responsible for the Skype for Business 2015 deployment in their organizations.

Experience with previous versions of

Lync Server is beneficial but not required to take this course. Students should be proficient with Active

Directory Domain Services (AD DS), data networks, and telecommunications standards and components that support the configuration of Skype for Business.

Students should also be familiar with

Microsoft Exchange Server and

Microsoft Office 365.

The secondary audience for this course includes IT professionals who are planning to take the exam 70-334:

Core Solutions of Skype for Business

2015 as a stand-alone exam or as part of the requirement for the Microsoft

Certified Solutions Expert (MCSE):

Communications certification exam.

20335 - Lync Network Readiness

Assessment

This is a 3-day instructor Led Training

(ILT) Course that targets the needs of professionals with data networking experience who take part in the planning, design, and deployment of the Lync Unified Communications solution in the enterprise. This course focuses on four key areas: 1) implementation methodology, including defining methodology phases, identifying phase deliverables, and preparing for traffic simulation; 2) analyzing the network environment, including review of WAN topology, Wi-Fi infrastructure, Quality of Server approaches, and media flow scenarios, analyzing the network for optimal performance, and monitoring and managing networks; 3) performing usage modeling, including modeling

RTC traffic media flows and Lync traffic per location, calculating traffic volume by using the Lync bandwidth calculator, and analyzing how predicted traffic impacts a network;

and 4) analyzing customer data and measurements, including policies collected from the Discovery phase and historical data usage, planning simulation traffic, analyzing results from traffic simulation, and formulating recommendations. This course maps to exam 74-335: Network

Readiness and Assessment for Lync.

$1,790.38

20339-1 - Planning and

Administering SharePoint 2016

This five-day course will provide you with the knowledge and skills to plan and administer a Microsoft SharePoint

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

SharePoint 2016 IT Pro certification.

The course is targeted at experienced

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

Students typically have more than one year of hands-on experience* with planning and maintaining SharePoint and two years’ experience with other core technologies on which SharePoint depends, including Windows Server

2012 R2 or later, Internet Information

Services (IIS), Microsoft SQL Server

2014 or later, Active Directory Domain

Services (AD DS), and networking infrastructure services.

The minimally qualified candidate typically:

· Is an IT professional who plans, implements, and maintains a multi-server deployment of SharePoint 2016.

· Has a working knowledge of, and preferably hands-on experience, with

SharePoint Online.

· Has broad familiarity with

SharePoint workloads.

· Has experience with business continuity management, including data backup, restoration, and high availability.

· Has experience with authentication and security technologies.

· Has experience with Windows

PowerShell.

* The hands-on experience or job experience should be from a solutions-based role where the candidate has worked on multiple solutions in the

SharePoint space that includes document management, content management, and search.

20339-2 - Advanced

Technologies of SharePoint 2016

This five-day course will teach you how to plan, configure, and manage the advanced features in a SharePoint

2016 environment. The special areas of focus for this course include implementing high availability, disaster recovery, service application architecture, and Microsoft Business

Connectivity Services. This course also focuses on social computing features, productivity, and collaboration platforms and features. Students also will learn about business intelligence solutions, Enterprise Content

Management, web content management infrastructure, solutions, and apps. This course also covers how to develop and implement a governance plan, and how to perform an upgrade or a migration to

SharePoint 2016. This is the second in a sequence of two courses for IT

Professionals and is aligned with the

SharePoint 2016 IT Pro certification.

The course is targeted at experienced

IT Professionals who are interested in learning how to install, configure, deploy, and manage SharePoint 2016 installations either in a data center or in the cloud.

Students typically should have more than four years of hands-on experience* planning and maintaining

SharePoint Server and other core technologies upon which SharePoint depends, including Windows Server

2012 R2 or later, Internet Information

Services (IIS), Microsoft SQL Server

2014 R2 or later, Active Directory

Domain Services (AD DS), and networking infrastructure services.

Students should have completed

Course 20339-1A: Planning and

Administering Microsoft SharePoint

2016, or have gained equivalent knowledge and experience before taking this course.

The minimally qualified candidate typically:

· Has a working knowledge of, and preferably hands-on experience, with

Microsoft SharePoint Online.

· Has broad familiarity with

SharePoint Server workloads.

· Has experience with business continuity management, including data backup, restoration, and high availability.

· Has experience with authentication and security technologies.

· Has experience with Windows

PowerShell.

* The hands-on experience or job experience should be from a solutions-based role where the candidate has worked on multiple solutions in the

SharePoint Server space that includes document management, content management, and search.

20345-1 - Administering

Microsoft Exchange Server 2016

This 5-day instructor-led course teaches IT professionals how to administer and support Exchange

Server 2016. Students will learn how to install Exchange Server 2016, and how to configure and manage an

Exchange Server environment. The course covers how to manage mail recipients and public folders, including how to perform bulk operations using Exchange

Management Shell. Students also will learn how to manage client connectivity, message transport and hygiene, how to implement and manage highly available Exchange

Server deployments, and how to implement back up and disaster recovery solutions. The course also teaches students how to maintain and monitor an Exchange Server 2016 deployment. In addition, students will learn how to administer Exchange

Online in an Office 365 deployment.

This course is primarily intended for people aspiring to become enterprise-level messaging administrators for

Exchange Server 2016. IT generalists and help-desk professionals who want to learn about Exchange Server 2016 might also take this course. Students taking this course are expected to have at least two years of experience working in the IT field—typically in the areas of Windows Server administration, network administration, help desk, or system administration. They are not expected to have experience with previous

Exchange Server versions.

The secondary audience for this course includes IT professionals who take this course as preparation material for exam 70-345: Designing and Deploying Microsoft Exchange

Server 2016, or as part of the requirement for the MCSE: Microsoft

Exchange Server 2016 certification.

20345-2 - Designing and

Deploying Microsoft Exchange

Server 2016

This course provides experienced

Exchange Server administrators with the knowledge to design and implement an Exchange Server 2016 messaging environment. Students will learn how to design and configure advanced components in an Exchange

Server 2016 deployment such as site resiliency, advanced security, compliance, archiving, and discovery solutions. In addition, students will learn about coexistence with other

Exchange organizations or Exchange

Online, and migration from previous versions of Exchange Server. The course will provide guidelines, best practices, and considerations that will help students optimize their Exchange

Server deployment.

professionals who are experienced messaging administrators, messaging architects, or consultants. This course is designed for professionals in an enterprise environment who are responsible for designing and deploying Exchange Server 2016 solutions, including environments that contain previous versions of

Exchange Server or Exchange Online.

Students are expected to have experience with Exchange Server 2016 or previous versions of Exchange

Server.

This course is also intended as preparation material for IT professionals who are looking to take the 70-345: Designing and Deploying

Microsoft Exchange Server 2016 exam as part of the requirement for the

MCSE: Microsoft Exchange Server

2016 certification.

20347 - Enabling and Managing

Office 365

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.

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.

20409 - Server Virtualization with Windows Server Hyper-V and System Center

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.

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

$2,896.61 product to implement in their data centers.

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.

20461 - Querying Microsoft SQL

Server 2014

This 5-day instructor led 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. This course helps people prepare for exam 70-461.

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.

$2,362.64

20462 - Administering Microsoft

SQL Server 2014 Databases

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

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.

$2,362.64

20463 - Implementing a Data

Warehouse with Microsoft SQL

Server 2014

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

$2,362.89

Integration Services, and validate and cleanse data with SQL Server Data

Quality Services and SQL Server

Master Data Services.

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.

20464 - Developing Microsoft

SQL Server 2014 Databases

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.

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.

$2,362.64

20480 - Programming in HTML

5 with JavaScript and CSS3

This course introduces 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 applications.

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 principals and coding components/structures that are used to establish an HTML5 software application.

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

20481 - Essentials of Developing

Windows Store Apps using

HTML5 and JavaScript

In this course students will learn essential…