Course: Microsoft Courses

What is MCSA: Office 365?

Demonstrate your skills in transitioning to and administering cloud-hosted business applications with Office 365.

Earning an MCSA: Office 365 certification qualifies you for a position as a software as a service (SaaS) administrator or cloud applications administrator focused on managing Office 365 business productivity products like Exchange, SharePoint and Lync.

Key Areas

There are two areas that are covered in the Office 365:

  • Intuitive and rewarding online training resources

    • Optional Training: 70-346
    • Required Training: 70-346
  • Official Microsoft Exams

    • Optional Training: 70-346
    • Required Training: 70-347

Who should take this exam?

This exam is designed for IT professionals who take part in evaluating, planning, deploying and operating the Office 365 services, including its dependencies, requirements and supporting technologies. They should have experience with the Office 365 Admin Centre and an understanding of Exchange Online, Lync Online, SharePoint Online, Office 365 ProPlus and Azure Active Directory. This includes experience with service descriptions, configuration options, and integrating services with existing identity management and on-premises infrastructure to support the business requirements of an organisation.

Training Solution Breakdown:

  • Intuitive and rewarding online training resources
  • Official Microsoft Exams
  • Comprehensive Freephone or email support
  • 24/7 access to training materials
  • Study anytime, anywhere in a world for a flexible learning experience
  • Full mock examinations to fully prepare you for any final exam
  • 12 months (one year) unrestricted access
  • Access to online or classroom training options
  • Progress reviews & comprehensive assessments to ensure efficient understanding of course content
  • Career advice and CV support once training has been completed
Exam 70-346

This exam measures your ability to accomplish the technical tasks listed below. The percentages indicate the relative weight of each major topic area in the exam. The higher the percentage, the more questions you are likely to see on that content area in the exam.

*Please note that the questions may test on, but will not be limited to, the topics described in the bulleted text.

Provision Office 365 (15-20%)

Provision Tenants

  • Configure the tenant name, tenant region, global administrator; manage tenant subscriptions; and manage the licensing model

Add and configure custom domains

  • Specify domain name, confirm ownership, specify domain purpose, and move ownership of DNS to Office 365

Plan a pilot

  • Designate pilot users, identify workloads that don’t require migration, run the Office 365 on-ramp readiness tool, create a test plan or use case, and connect existing email accounts for pilot users, service descriptions

For more information, contact one of our course advisors

Plan and implement networking and security in Office 365 (15-20%)

Configure DNS records for services


  • Creating DNS records for Exchange, Lync and SharePoint

Enable client connectivity to Office 365


  • Configure proxy server to allow anonymous access to Office 365 URLs, configure firewalls for
    outbound port access to Office 365, recommend bandwidth, Internet connectivity for clients,
    and deploy desktop setup for previous versions of Office clients

Administer rights management (RM)


  • Activate rights management, Office integration with rights management, assign roles for
    Microsoft Azure Active Directory RM and enable recovery of protected document

Manage administrator roles in Office 365


  • Permission model, create or revoke assignment of administrative roles or the administrative model,
    determine and assign global administrator, billing administrator and user administrator, delegated
    administrator, and control password resets

For more information, contact one of our course advisors

Manage cloud identities (15-20%)

Configure password management

  • Expiry policy, password complexity, password resets and Administration Centre

Manage user and security groups

  • Bulk import, Azure Active Directory Graph API, soft delete, Administration Centre and multi-factor authentication

Manage cloud identities with Windows PowerShell

  • Configure passwords to never expire, bulk update of user properties, bulk user creation, Azure Active Directory cmdlets, bulk user licence management and hard delete users

For more information, contact one of our course advisors

Implement and manage identities by using DirSync (15-20%)

Prepare on-premises Active Directory for DirSync

  • Plan for non-routable domain names, clean up existing objects, plan for filtering Active Directory, and support for multiple forests

Set up DirSync [WAAD sync tool]

  • Soft match filtering and identify synchronised attributes, password sync, and installation requirements

Manage Active Directory users and groups with DirSync in place

  • Delete, create, modify, and schedule and force synchronisation

For more information, contact one of our course advisors

Implement and manage federated identities (single sign-on [SSO]) (15-20%)

Plan requirements for Active Directory Federation Services (AD FS)

  • Namespaces and certificates, plan AD FS internal topologies and dependencies, plan AD FS proxy topologies, network requirements, multi-factor authentication, and access filtering using claims rules

Install and manage AD FS servers

  • Create AD FS service accounts, configure farm or stand-alone settings, add additional servers, convert from standard to federated domain, and manage certificate life cycle

Install and manage AD FS proxy servers

  • Set up perimeter network name resolution, install required Windows roles and features, set up certificates, configure AD FS proxy settings, and set custom proxy forms login page

For more information, contact one of our course advisors

Monitor and troubleshoot Office 365 availability and usage (15-20%)

Analyse reports

  • Service reports, mail protection reports, auditing log and portal email hygiene reports

Monitor service health

  • RSS feed, service health dashboard (including awareness of planned maintenance, service updates and historical data), Office 365 Management Pack for System Centre Operations Manager, and Windows PowerShell cmdlets

Isolate service interruption

  • Create a service request, Microsoft Remote Connectivity Analyser (RCA), Microsoft Online Services Diagnostics and Logging (MOSDAL) support toolkit, Transport Reliability IP Probe (TRIPP), Microsoft Connectivity Analyser tool, and hybrid free/busy troubleshooter

For more information, contact one of our course advisors

Exam 70-347

This exam measures your ability to accomplish the technical tasks listed below. The percentages indicate the relative weight of each major topic area in the exam. The higher the percentage, the more questions you are likely to see on that content area in the exam.

*Please note that the questions may test on, but will not be limited to, the topics described in the bulleted text.

Manage clients and end-user devices (20-25%)

Manage user-driven client deployments

  • Restrict self-provisioning of Office 365 ProPlus, Windows Store Apps and Mobile Apps, activation/revoke activation, and Office for Mac

Manage IT deployments of Office 365 ProPlus

  • Manage deployment, manage streaming updates, use the Office deployment tool and customise deployment

Set up telemetry and reporting

  • Enable telemetry through Group Policy, set up telemetry service, report user issues and deploy agent

Plan for Office clients

  • Outlook, Lync client, Office on Demand, Office Web Apps, and click-to-run versus MSI

For more information, contact one of our course advisors

Provision SharePoint Online site collections (20-25%)

Configure external user sharing

  • Configure the tenant name, tenant region, global administrator; manage tenant subscriptions; and manage the licensing model

Create SharePoint site collection

  • Set SharePoint Online site collection administrator, set resource quota and warning level, configure public website, set storage quota for site collection, and configure name and URL of site collection

Plan a collaboration solution

  • Yammer versus newsfeeds, co authoring, Project Online, access files across multiple client devices (for example, migrate files to OneDrive for Business), Excel services, Visio services, App Store and the need for enterprise eDiscovery

For more information, contact one of our course advisors

Configure Exchange Online and Lync Online for end users (20-25%)

Configure additional email addresses for users

  • Change style/reply to address, bulk add/remove for new domain, manage secondary email aliases and SIP addresses

Create and manage external contacts, resources and groups

  • Create and manage resource mailboxes, create shared mailboxes, create external contacts, assign additional email address to contacts, create and manage distribution lists and members, and delegate permissions

Configure personal archive policies

  • Enable personal archives for mailboxes, create custom retention policy, create retention tags, apply retention policy to mailboxes, and review and modify default retention policy

Configure Lync end-user communication settings

  • Turn off non-archived features for compliance, configure presence, available services, and configure per-user external communication

For more information, contact one of our course advisors

Plan for Exchange Online and Lync Online (20-25%)

Manage anti-malware and anti-spam policies

  • Release quarantine, configure SPAM confidence level, configure white and black lists, and configure notifications

Recommend a mailbox migration strategy

  • Staged, cutover, hybrid and IMAP

Plan for Exchange Online

  • Plan client requirements for archive, manage eDiscovery, enable Legal hold, configure OWA access, and configure ActiveSync

Manage Lync global external communications settings

  • Enable external access, manage domains, manage public IM connectivity, customise meeting invitations, and disable push notification service

For more information, contact one of our course advisors

What is an MCSA Qualification?

An MCSA (Microsoft Certified Solutions Associate) is a qualification that certifies that the holder has a good intermediate knowledge within a chosen sector of IT, whether this be SQL, Windows Server or Windows 7 & 8. An MCSA is the ideal way to climb the career ladder and work your way to a position that gives you advanced skills; this qualification will also unlock a number of options for future personal development, as there are a number of ways to push forward to higher qualifications.

Microsoft offer MCSA qualifications in a number of specialities, meaning candidates can gain a qualification that is relevant to their skills and interests. An MCSA can relate to Windows Server 2008 & 2012, SQL Server 2012 & 2014 and both Windows 7 and Windows 8 – the scope of this qualification means that it transcends other IT qualifications and allows delegates to excel in a specific field with a broad and widely recognised certification.

Training Solution Breakdown:

  • Intuitive and rewarding online training resources
  • Official Microsoft Exams
  • Comprehensive Freephone or email support
  • 24/7 access to training materials
  • Study anytime, anywhere in a world for a flexible learning experience
  • Full mock examinations to fully prepare you for any final exam
  • 12 months (one year) unrestricted access
  • Access to online or classroom training options
  • Progress reviews & comprehensive assessments to ensure efficient understanding of course content
  • Career advice and CV support once training has been completed
MCSA Breakdown

Click below to expand the areas and see more information:

MCSA: Windows Server 2012
  • Installing and Configuring Windows Server 2012 - Exam: 410
  • Administering Windows Server 2012 - Exam: 411
  • Configuring Advanced Windows Server 2012 Services - Exam: 412

For more information, contact one of our course advisors

MCSA: Windows Server 2008
  • Windows Server 2008 Active Directory, Configuring - Exam: 640
  • Windows Server 2008 Network Infrastructure, Configuring - Exam: 642
  • Windows Server 2008, Server Administrator - Exam: 646

For more information, contact one of our course advisors

MCSA: Windows 8
  • Configuring Windows 8.1 - Exam: 687
  • Supporting Windows 8.1 - Exam: 688

For more information, contact one of our course advisors

MCSA: Windows 7
  • Windows 7, Configuring - Exam: 680
  • Windows 7, Enterprise Desktop Support Technician - Exam: 685

For more information, contact one of our course advisors

MCSA: SQL Server 2012
  • Querying Microsoft SQL Server 2012 - Exam: 461
  • Administering Microsoft SQL Server 2012 Databases - Exam: 462
  • Implementing a Data Warehouse with Microsoft SQL Server 2012 - Exam: 463

For more information, contact one of our course advisors

MCSA: SQL Server 2008
  • Querying Microsoft SQL Server 2012 - Exam: 461
  • Administering Microsoft SQL Server 2012 Databases - Exam: 462
  • Implementing a Data Warehouse with Microsoft SQL Server 2012 - Exam: 463

For more information, contact one of our course advisors

MCSA: Office 365
  • Managing Office 365 Identities and Requirements - Exam: 346
  • Enabling Office 365 Services - Exam: 347

For more information, contact one of our course advisors

Job Role

Due to the all-encompassing nature of an MCSA the specific job roles that a certified candidate will qualify for varies depending on their chosen speciality, generally though those that hold an MCSA qualification will earn an average of £34,000.

Some of the most common job roles for those that hold an MCSA qualification are:

  • Analyst
  • Support Engineer
  • Infrastructure Engineer
  • 3rd Line Support Technician
  • Consultant
  • Systems Administrator

For more information, contact one of our course advisors

New MCSA Framework

Please bare in mind that a new MCSA Framework for Programming has been released as of February 2017.

For more information, contact one of our course advisors

What is an MCSE Qualification?

An MCSE (Microsoft Certified Solutions Expert) is the final step in a delegate’s development process, being a step further than an MCSA the MCSE certification is an expert level qualification that certifies that a candidate is a master in their chosen field. Much like its prerequisite the MCSE has a broad spectrum of subject areas and specialities, meaning that you can fine tune your skillset to apply to a niche area of the huge sector that is IT. This qualification will stand you apart from most other candidates when applying for a job and will line you up for that big promotion at your current employer.

Microsoft offer MCSE qualifications in a number of specialities and will allow you to advance to the final level within a particular field of IT. Delegates can achieve an MCSE in SQL, Windows Server, SharePoint, Lync Server, Exchange Server, Private Cloud and Desktop Infrastructure. The scope of the MCSE means that any area that you progress upon will ensure you excel within your chosen speciality and become a bona fide expert within the IT industry.

Training Solution Breakdown:

  • Intuitive and rewarding online training resources
  • Official Microsoft Exams
  • Comprehensive Freephone or email support
  • 24/7 access to training materials
  • Study anytime, anywhere in a world for a flexible learning experience
  • Full mock examinations to fully prepare you for any final exam
  • 12 months (one year) unrestricted access
  • Access to online or classroom training options
  • Progress reviews & comprehensive assessments to ensure efficient understanding of course content
  • Career advice and CV support once training has been completed
MCSE Breakdown

Click below to expand the areas and see more information:

MCSE: Server Infrastructure
  • Installing and Configuring Windows Server 2012 - Exam: 410
  • Administering Windows Server 2012 - Exam: 411
  • Configuring Advanced Windows Server 2012 Services - Exam: 412
  • After successfully completing steps 1 -3, you'll earn a Microsoft Certified Solutions Associate (MCSA): Windows Server 2012 certification.
  • Designing and Implementing a Server Infrastructure - Exam: 413
  • Implementing an Advanced Server Infrastructure - Exam: 414

For more information, contact one of our course advisors

MCSE: Desktop Infrastructure
  • Installing and Configuring Windows Server 2012 - Exam: 410
  • Administering Windows Server 2012 - Exam: 411
  • Configuring Advanced Windows Server 2012 Services - Exam: 412
  • After successfully completing steps 1 -3, you'll earn a Microsoft Certified Solutions Associate (MCSA): Windows Server 2012 certification.
  • Implementing a Desktop Infrastructure - Exam: 415
  • Implementing Desktop Application Environments - Exam: 416

For more information, contact one of our course advisors

MCSE: Private Cloud certification
  • Installing and Configuring Windows Server 2012 - Exam: 410
  • Administering Windows Server 2012 - Exam: 411
  • Configuring Advanced Windows Server 2012 Services - Exam: 412
  • After successfully completing steps 1 -3, you'll earn a Microsoft Certified Solutions Associate (MCSA): Windows Server 2012 certification.
  • Monitoring and Operating a Private Cloud with System Center 2012 - Exam: 246
  • Configuring and Deploying a Private Cloud with System Center 2012 - Exam: 247

For more information, contact one of our course advisors

MCSE: Enterprise Devices and Apps
  • Configuring Windows 8.1 - Exam: 687
  • Supporting Windows 8.1 - Exam: 688
  • After successfully completing steps 1 and 2, you'll earn a Microsoft Certified Solutions Associate (MCSA): Windows 8 certification.
  • Deploying Windows Devices and Enterprise Apps - Exam: 695
  • Managing Enterprise Devices and Apps - Exam: 696

For more information, contact one of our course advisors

MCSE: Data Platform
  • Querying Microsoft SQL Server 2012 - Exam: 461
  • Administering Microsoft SQL Server 2012 Databases - Exam: 462
  • Implementing a Data Warehouse with Microsoft SQL Server 2012 - Exam: 463
  • After successfully completing steps 1-3, you'll earn a Microsoft Certified Solutions Associate (MCSA): SQL Server 2012 certification.
  • Developing Microsoft SQL Server Databases - Exam: 464
  • Designing Solutions for SQL Server - Exam: 465

For more information, contact one of our course advisors

MCSE: Business Intelligence
  • Querying Microsoft SQL Server 2012 - Exam: 461
  • Administering Microsoft SQL Server 2012 Databases - Exam: 462
  • Implementing a Data Warehouse with Microsoft SQL Server 2012 - Exam: 463
  • After successfully completing steps 1-3, you'll earn a Microsoft Certified Solutions Associate (MCSA): SQL Server 2012 certification.
  • Implementing Data Models and Reports with Microsoft SQL Server - Exam: 466
  • Designing Business Intelligence Solutions with Microsoft SQL Server - Exam: 467

For more information, contact one of our course advisors

MCSE: Messaging
  • Managing Office 365 Identities and Requirements - Exam: 346
  • Enabling Office 365 Services - Exam: 347
  • After successfully completing steps 1 and 2, you'll earn a Microsoft Certified Solutions Associate (MCSA): Office 365 certification.

  • Core Solutions of Microsoft Exchange Server 2013 - Exam: 341
  • Advanced Solutions of Microsoft Exchange Server 2013 - Exam: 342

For more information, contact one of our course advisors

MCSE: Communication
  • Managing Office 365 Identities and Requirements - Exam: 346
  • Enabling Office 365 Services - Exam: 347
  • After successfully completing steps 1 and 2, you'll earn a Microsoft Certified Solutions Associate (MCSA): Office 365 certification.

  • Core Solutions of Microsoft Lync Server 2013 - Exam: 336
  • Enterprise Voice & Online Services with Microsoft Lync Server 2013 - Exam: 337

For more information, contact one of our course advisors

MCSE: SharePoint
  • Managing Office 365 Identities and Requirements - Exam: 346
  • Enabling Office 365 Services - Exam: 347
  • After successfully completing steps 1 and 2, you'll earn a Microsoft Certified Solutions Associate (MCSA): Office 365 certification.

  • Core Solutions of Microsoft SharePoint Server 2013 - Exam: 331
  • Advanced Solutions of Microsoft SharePoint Server 2013 - Exam: 332

For more information, contact one of our course advisors

Job Role

Due to the varied nature of an MCSE the specific job roles that a certified candidate will qualify for varies depending on their chosen speciality, generally though those that hold an MCSE qualification will earn an average of £40,000.

Some of the most common job roles for those that hold an MCSE qualification are:

  • Support Engineer
  • Analyst
  • Consultant
  • Infrastructure Engineer
  • 3rd Line Support Technician
  • Systems Administrator
  • Architect

For more information, contact one of our course advisors

What is Desktop Support Training?

Desktop Support is one of the most common terms when talking about 1st/2nd/3rd line support technicians and encompasses a number of troubleshooting and support methodologies that will allow learners to appropriately configure and support business-wide users that are using Windows 7 and 8 Operating Systems. Desktop Support Training will give you the skills, knowledge and knowhow to excel in a support based role and is an ideal way to learn the base information that will allow you to grow in the IT sector.

A desktop support specialist usually provides help and advice to users of computer software and hardware. A desktop support specialist may work within a company’s information technology department or as a member of the help desk staff at a computer support company. They may also work with individual personal users or as an independent contractor.

An MCSA in Windows 7 or Windows 8.1 validates your ability to identify and resolve the cause of desktop application, network, and security issues. An MCSA in this area validates your ability to support and maintain systems and mobile devices that run Windows 7 & Windows 8.1.

Areas of Expertise

There are 2 levels of qualifications you can receive in Desktop Support, namely;

  • Introductory – Microsoft Technical Associate (MTA)
  • Intermediate – Microsoft Certified Solutions Associate (MCSA)

Training Solution Breakdown:

  • Intuitive and rewarding online training resources
  • Official Microsoft Exams
  • Comprehensive Freephone or email support
  • 24/7 access to training materials
  • Study anytime, anywhere in a world for a flexible learning experience
  • Full mock examinations to fully prepare you for any final exam
  • 12 months (one year) unrestricted access
  • Access to online or classroom training options
  • Progress reviews & comprehensive assessments to ensure efficient understanding of course content
  • Career advice and CV support once training has been completed
Desktop Support Breakdown

Click below to expand the areas and see more information:

MCSA: Windows 7
  • Windows 7, Configuring - Exam: 680
  • Windows 7, Enterprise Desktop Support Technician - Exam: 685

For more information, contact one of our course advisors

MCSA: Windows 8
  • Configuring Windows 8.1 - Exam: 687
  • Supporting Windows 8.1 - Exam: 688

For more information, contact one of our course advisors

MCSA: Windows 10
  • MCSA: Windows 10: 70-697

For more information, contact one of our course advisors

MTA
  • Mobility and Devices Fundamentals: 98-368

For more information, contact one of our course advisors

Job Role

Desktop Support roles are plentiful within the IT industry and those that possess an MCSA in an area of Desktop Support earn an average of £28,500 (Source: IT Jobs Watch March 2015)

The roles that a Desktop Support specialist can fulfil are as follows:

  • Desktop Support Technician
  • IT Manager
  • IT Support Specialist
  • Desktop Support Analyst

For more information, contact one of our course advisors

About Excel Training

This Microsoft Excel training package teaches users how to confidently approach Microsoft Excel, enabling proficiency in the program through an easy to digest online learning format. Nine modules are broken up into manageable topics that cover the basic, intermediate and advanced functions of Excel; this includes essentials such as formatting content, presenting data or modifying page setups.

Each module is followed with an online test, to ensure you picked up the topics in each module. Friendly and helpful tutors will ensure that you will always have a point of contact should you get stuck on any particular topic. With 18-months unlimited access to course content users can comfortably learn at their own pace, allowing a stress-free learning experience. This can be a stepping stone for a MOS certification and builds towards official Microsoft exams.

Training Solution Breakdown:

  • Intuitive and rewarding online training resources
  • Nine comprehensive modules, with online testing.
  • Introductory, intermediate and advanced levels of Excel, teaching you how to use the Microsoft software in a business environment. This includes sections on PivotTables and VLookup
  • Knowledge to increase productivity and create high quality Excel workbooks and spreadsheets
  • Business standard skills in Microsoft Excel
  • 18 months unlimited access to course content
  • Tutor and technical support available via a local US phone number and email
  • Completion certificate, which will show employers that you are proficient with Excel
  • Study anytime, anywhere in a world for a flexible learning experience
Excel 2013 Breakdown

Click below to expand the areas and see more information:

Create and manage worksheets and workbooks
  • Create worksheets and workbooks
    • Creating new blank workbooks; creating new workbooks using templates; importing files; opening non-native files directly in Excel; adding worksheets to existing workbooks; copying and moving worksheets
  • Navigate through worksheets and workbooks
    • Searching for data within a workbook; inserting hyperlinks; changing worksheet order; using Go To; using Name Box
  • Format worksheets and workbooks
    • Changing worksheet tab colour; modifying page setup; inserting and deleting columns and rows; changing workbook themes; adjusting row height and column width; inserting watermarks; inserting headers and footers; setting data validation
  • Customise options and views for worksheets and workbooks
    • Hiding worksheets; hiding columns and rows; customising the Quick Access toolbar; customising the Ribbon; managing macro security; changing workbook views; recording simple macros; adding values to workbook properties; using zoom; displaying formulas; freezing panes; assigning shortcut keys; splitting the window
  • Configure worksheets and workbooks to print or save
    • Setting a print area; saving workbooks in alternate file formats; printing individual worksheets; setting print scaling; repeating headers and footers; maintaining backward compatibility; configuring workbooks to print; saving files to remote locations

For more information, contact one of our course advisors

Create cells and ranges
  • Insert data in cells and ranges
    • Appending data to worksheets; finding and replacing data; copying and pasting data; using AutoFill tool; expanding data across columns; inserting and deleting cells
  • Format cells and ranges
    • Merging cells; modifying cell alignment and indentation; changing font and font styles; using Format Painter; wrapping text within cells; applying Number format; applying highlighting; applying cell styles; changing text to WordArt
  • Order and group cells and ranges
    • Applying conditional formatting;inserting sparklines; transposing columns and rows; creating named ranges; creating outline; collapsinggroups of data in outlines; inserting subtotals

For more information, contact one of our course advisors

Create tables
  • Create a table
    • Moving between tables and ranges; adding and removing cells within tables; defining titles
  • Modify a table
    • Applying styles to tables; banding rows and columns; inserting total rows; removing styles from tables
  • Filtering and sort a table
    • Filtering records; sorting data on multiple columns; changing sort order; removing duplicates

For more information, contact one of our course advisors

Apply formulas and functions
  • Utilise cell ranges and references in formulas and functions
    • Utilising references (relative, mixed, absolute); defining order of operations; referencing cell ranges in formulas
  • Summarise data with functions
    • Utilising the SUM function; utilising the MIN and MAX functions; utilising the COUNT function; utilising the AVERAGE function
  • Utilise conditional logic in functions
    • Utilising the SUMIF function; utilising the AVERAGEIF function; utilising the COUNTIF function
  • Format and modify text with functions
    • Utilising the RIGHT, LEFT and MID functions; utilising the TRIM function; utilising the UPPER and LOWER functions; utilising the CONCATENATE function

For more information, contact one of our course advisors

Create charts and objects
  • Create a chart
    • Creating charts and graphs; adding additional data series; switching between rows and columns in source data; using Quick Analysis
  • Format a chart
    • Adding legends; resizing charts and graphs; modifying chart and graph parameters; applying chart layouts and styles; positioning charts and graphs
  • Insert and format an object
    • Inserting text boxes; inserting SmartArt; inserting images; adding borders to objects; adding styles and effects to objects; changing object colours; modifying object properties; positioning objects

For more information, contact one of our course advisors

Excel Package Offer

Click below to expand the areas and see more information:

Excel 2013 & Excel Expert 2013
  • If you are looking to purchase the Excel 2013 and the Excel expert 2013
  • Click the buy button below to purchase our Excel package
  • Buy Now£349.98 + VAT

For more information, contact one of our course advisors

What is MOS Training?

Microsoft Office is a suite of products developed by Microsoft that includes Microsoft Word, Excel, Access, Publisher, PowerPoint, Outlook and SharePoint. Each programme serves a different purpose and is compatible with other programmes included in the package. The suite of programmes is compatible with both the Windows and Macintosh operating system and is the most common form of software used in the western world.

Take your understanding of Microsoft Office to the next level – excel in your understanding, knowledge and marketable skillset within one of the most in demand software suite in the working world.

Whether you are a low level data entry clerk or a high powered CEO our MOS training programme is essential for anyone hoping to survive in an office environment. The MOS builds from a foundation level and will develop all learners to becoming advanced Office users.

Microsoft offer varying levels of expertise with their powerful Office suite and learners can gain qualifications as a Microsoft Office Specialist, Microsoft Office Specialist Expert, or a Microsoft Office Specialist Master.

Training Solution Breakdown:

  • Intuitive and rewarding online training resources
  • Official Microsoft Exams
  • Comprehensive Freephone or email support
  • 24/7 access to training materials
  • Study anytime, anywhere in a world for a flexible learning experience
  • Full mock examinations to fully prepare you for any final exam
  • 12 months (one year) unrestricted access
  • Access to online or classroom training options
  • Progress reviews & comprehensive assessments to ensure efficient understanding of course content
  • Career advice and CV support once training has been completed
MOS Breakdown

Click below to expand the areas and see more information:

Microsoft Office Specialist: Microsoft Office 2013

Office 2013 combines cloud and web technologies to extend the way you create and consume information and introduces a new cloud app model for you to build secure and flexible apps—all discoverable from the familiar Office interface.

  • MOS: Microsoft Office Word 2013 - Exam: 418
  • MOS: Microsoft Office Excel 2013 - Exam: 420
  • MOS: Microsoft Office PowerPoint 2013 - Exam: 422
  • MOS: Microsoft Office Outlook 2013 - Exam: 423
  • MOS: Microsoft Office Access 2013 - Exam: 424
  • MOS: Microsoft SharePoint 2013 - Exam: 419
  • MOS: Microsoft Office OneNote 2013 (Introductory module available) - Exam: 421

For more information, contact one of our course advisors

Microsoft Office Specialist: Microsoft Office 2010
  • MOS: Word 2010 - Exam: 418
  • MOS: Excel 2010 - Exam: 420
  • MOS: PowerPoint 2010 - Exam: 422
  • MOS: Outlook 2010 - Exam: 423
  • MOS: Access 2010 - Exam: 424
  • MOS: SharePoint 2010 - Exam: 419
  • MOS: OneNote 2010 - Exam: 421

For more information, contact one of our course advisors

Job Role

Having MOS training on your CV will unlock a large number of career opportunities within office environments, with those holding a MOS certification earning an average of £29,000 (Source: IT Jobs Watch March 2015.)

The roles that you will be qualified for are as follows:

  • Office Administrator
  • Business Administrator
  • Personal Assistant
  • Receptionist
  • Office Clerk

For more information, contact one of our course advisors

What is MOS Expert Training?

Microsoft Office is a suite of products developed by Microsoft that includes Microsoft Word, Excel, Access, Publisher, PowerPoint, Outlook and SharePoint. Each programme serves a different purpose and is compatible with other programmes included in the package. The suite of programmes is compatible with both the Windows and Macintosh operating system and is the most common form of software used in the western world.

Take your understanding of Microsoft Office to the next level – excel in your understanding, knowledge and marketable skillset within one of the most in demand software suite in the working world.

Whether you are a low level data entry clerk or a high powered CEO our MOS training programme is essential for anyone hoping to survive in an office environment. The MOS builds from a foundation level and will develop all learners to becoming advanced Office users.

Microsoft offer varying levels of expertise with their powerful Office suite and learners can gain qualifications as a Microsoft Office Specialist, Microsoft Office Specialist Expert, or a Microsoft Office Specialist Master.

Training Solution Breakdown:

  • Intuitive and rewarding online training resources
  • Official Microsoft Exams
  • Comprehensive Freephone or email support
  • 24/7 access to training materials
  • Study anytime, anywhere in a world for a flexible learning experience
  • Full mock examinations to fully prepare you for any final exam
  • 12 months (one year) unrestricted access
  • Access to online or classroom training options
  • Progress reviews & comprehensive assessments to ensure efficient understanding of course content
  • Career advice and CV support once training has been completed
MOS Extra Breakdown

Click below to expand the areas and see more information:

Microsoft Excel 2013
  • Introduction to Microsoft Excel
  • Working with Worksheets and Workbooks
  • Formatting Options in Excel
  • Navigation through Workbooks
  • Tables, Sparklines and Conditional Formatting
  • Using Formulas in Excel 2013
  • Using Charts in Excel 2013
  • Insert and Manage Objects in Excel 2013
  • Modifying the Page Setup. Printing Workbooks and Recording Macros
  • Pivot Tables and VLookup

For more information, contact one of our course advisors

Microsoft Word 2013
  • How to create Documents
  • How to Customise Word 2013
  • How to format documents in Word 2013
  • How to format documents and modify the page setup
  • Using Tables in Word
  • Formatting Documents in Word 2013
  • Working with images, macros and themes

For more information, contact one of our course advisors

Microsoft Access 2013
  • Create and Manage a Database
  • Built Tables
  • Create Queries
  • Working with Forms
  • Working with Reports

For more information, contact one of our course advisors

Microsoft PowerPoint 2013
  • Create & Manage Presentations
  • Built Tables
  • Create Queries
  • Working with Forms
  • Working with Reports

For more information, contact one of our course advisors

Microsoft Outlook 2013
  • Introduction to Microsoft Outlook 2013
  • Formatting Messages
  • Managing Messages
  • Formatting Messages, Managing Attachments, and Configuring Automatic Replies
  • Scheduling & Managing Appointments
  • Creating Meetings & Managing Availability
  • Tasks, Notes, Journal, and Contacts
  • Contact Groups, Multiple Accounts, and Printing

For more information, contact one of our course advisors

Microsoft SharePoint 2013
  • Introducing SharePoint
  • Lists, Libraries and Alerts
  • Mobile Sites and Document Management
  • Versioning and Workflows
  • Documents, Document Sets and Announcements
  • Manage SharePoint Sites
  • Content in SharePoint
  • Content & Access in SharePoint
  • Participate In User Communities

For more information, contact one of our course advisors

Microsoft OneNote 2013
  • Introduction to OneNote
  • Getting To Know OneNote
  • Inserting Content To OneNote
  • Sharing Notebooks
  • Top Tips For OneNote

For more information, contact one of our course advisors

What is MOS Expert Training?

Microsoft Office is a suite of products developed by Microsoft that includes Microsoft Word, Excel, Access, Publisher, PowerPoint, Outlook and SharePoint. Each programme serves a different purpose and is compatible with other programmes included in the package. The suite of programmes is compatible with both the Windows and Macintosh operating system and is the most common form of software used in the western world.

Take your understanding of Microsoft Office to the next level – excel in your understanding, knowledge and marketable skillset within one of the most in demand software suite in the working world.

Whether you are a low level data entry clerk or a high powered CEO our MOS training programme is essential for anyone hoping to survive in an office environment. The MOS builds from a foundation level and will develop all learners to becoming advanced Office users.

Microsoft offer varying levels of expertise with their powerful Office suite and learners can gain qualifications as a Microsoft Office Specialist, Microsoft Office Specialist Expert, or a Microsoft Office Specialist Master.

Training Solution Breakdown:

  • Intuitive and rewarding online training resources
  • Official Microsoft Exams
  • Comprehensive Freephone or email support
  • 24/7 access to training materials
  • Study anytime, anywhere in a world for a flexible learning experience
  • Full mock examinations to fully prepare you for any final exam
  • 12 months (one year) unrestricted access
  • Access to online or classroom training options
  • Progress reviews & comprehensive assessments to ensure efficient understanding of course content
  • Career advice and CV support once training has been completed
MOS Expert Breakdown

Click below to expand the areas and see more information:

Microsoft Office 2013 Expert Certification

Office 2013 combines cloud and web technologies to extend the way you create and consume information, and introduces a new cloud app model for you to build secure and flexible apps—all discoverable from the familiar Office interface.
To earn a Microsoft Office 2013 Expert certification, you must pass both of the MOS Expert required exams listed:

  • MOS: Microsoft Office Word Expert (2013) - Exam: 425 & 426
  • MOS: Microsoft Office Excel Expert (2013) - Exam: 427 & 428

For more information, contact one of our course advisors

Microsoft Office 2010 Expert Certification

To earn the Microsoft Office 2010 Expert certification, you must pass one of the following MOS Expert exams:

  • MOS: Microsoft Office Word Expert (2013) - Exam: 887
  • MOS: Microsoft Office Excel Expert (2013) - Exam: 888

For more information, contact one of our course advisors

Job Role

Having MOS training on your CV will unlock a large number of career opportunities within office environments, with those holding a MOS certification earning an average of £29,000 (Source: IT Jobs Watch March 2015)

The roles that you will be qualified for are as follows:

  • Office Administrator
  • Business Administrator
  • Personal Assistant
  • Receptionist
  • Office Clerk

For more information, contact one of our course advisors

What is an Microsoft Server Training?

A server is a system (software and suitable computer hardware) that responds to requests across a computer network to provide, or help to provide, a network service. Servers can be run on a dedicated computer, which is also often referred to as “the server”, but many networked computers are capable of hosting servers. In many cases, a computer can provide several services and have several servers running simultaneously.

This training specifically shows you on how to operate, configure and maintain a Windows Server and will give you the knowledge to be in control of a complex, business-wide systems. Earning an MCSA or MCSE qualification in Windows Server will underline your knowledge and skills in navigating servers and will highlight to potential employers that you are ready to hit the ground running in a large scale business and manage networks across the company.

Achieving a qualification in Windows Server will ensure that your personal development is placing you on a path that ensures that you can grow into a specific job role and can become an expert in a niche area of IT.

Areas of Expertise

There are 3 levels of qualifications that you can receive in Windows Server, namely:

  • Introductory – Introductory Pack (MTA)
  • Intermediate – Microsoft Certified Solutions Associate (MCSA)
  • Advanced – Microsoft Certified Solutions Expert (MCSE)

Training Solution Breakdown:

  • Intuitive and rewarding online training resources
  • Official Microsoft Exams
  • Comprehensive Freephone or email support
  • 24/7 access to training materials
  • Study anytime, anywhere in a world for a flexible learning experience
  • Full mock examinations to fully prepare you for any final exam
  • 12 months (one year) unrestricted access
  • Access to online or classroom training options
  • Progress reviews & comprehensive assessments to ensure efficient understanding of course content
  • Career advice and CV support once training has been completed
Windows Server Breakdown

Click below to expand the areas and see more information:

MCSA: Windows Server 2012
  • Installing and Configuring Windows Server 2012 - Exam: 70-410
  • Administering Windows Server 2012 - Exam: 70-411
  • Configuring Advanced Windows Server 2012 Services - Exam: 70-412
  • Designing and Implementing a Server Infrastructure - Exam: 70-413
  • Implementing an Advanced Server Infrastructure - Exam: 70-414

For more information, contact one of our course advisors

MCSA: Windows Server 2016
  • Installation, Storage, and Compute with Windows Server 2016 - Exam: 70-740
  • Networking with Windows Server 2016 - Exam: 70-741
  • Identity with Windows Server 2016 - Exam: 70-742

For more information, contact one of our course advisors

Job Role

Achieving a qualification in Server will unlock a number of doors within a variety of Server Administration roles, with salaries of those holding a certification in Server earning an average of £30,018. (Figures sourced from Payscale dated December 2014)

Some of the most common job roles for those that hold an MCSA qualification are:

  • Analyst
  • Support Engineer
  • Infrastructure Engineer
  • 3rd Line Support Technician
  • Consultant
  • Systems Administrator

For more information, contact one of our course advisors

What is an MTA Qualification?

An MTA (Microsoft Technical Associate) is a new entry level qualification from Microsoft that allows those new to the IT industry to get into the sector from the level of a complete beginner. If you have an interest, but lack understanding, of buzzwords like Windows Operating System, Windows Server, SQL, Databases or programming then an MTA certification is the best way for you to get your foot in the door and boost your base knowledge of technical subjects.

Whatever area of IT that you are looking to grow into an MTA can unlock the door and will ensure that employers and colleagues know that you have the fundamental skills to excel in a relevant position in the IT industry. Those who strive to complete an MTA may have some experience using computers as an end user but do not know how to delve further into the technical aspects of computing.

Take the first steps on the path to becoming a technical specialist by completing an MTA certification, which will give you the building blocks to complete more advanced qualifications like an MCSA or an MCSE.

Training Solution Breakdown:

  • Intuitive and rewarding online training resources
  • Official Microsoft Exams
  • Comprehensive Freephone or email support
  • 24/7 access to training materials
  • Study anytime, anywhere in a world for a flexible learning experience
  • Full mock examinations to fully prepare you for any final exam
  • 12 months (one year) unrestricted access
  • Access to online or classroom training options
  • Progress reviews & comprehensive assessments to ensure efficient understanding of course content
  • Career advice and CV support once training has been completed
MTA Breakdown

Click below to expand the areas and see more information:

IT Infrastructure

MTA IT Infrastructure track. For those intending to build a career in desktop or server infrastructure or private cloud computing:

  • Windows Server Administration Fundamentals - Exam: 365
  • Networking Fundamentals - Exam: 366
  • Security Fundamentals - Exam: 367

For more information, contact one of our course advisors

Database

MTA Database track. For those intending to build a career in data platform administration or business intelligence:

  • Database Fundamentals - Exam: 364

For more information, contact one of our course advisors

Developer

MTA Developer track. For those intending to build a career as a software developer, this track helps prepare you for hands-on product training and MCSD certification. Start with MTA Software Development Fundamentals and then select the additional topics in this track to help you meet your career development goals:

  • Software Development Fundamentals - Exam: 361
  • HTML5 App Development Fundamentals - Exam: 375
  • Software Testing Fundamentals - Exam: 379

For more information, contact one of our course advisors

Job Role

Due to the variety available via an MTA the specific job roles that a certified candidate will qualify for varies depending on their chosen speciality, generally though those that hold an MTA qualification will earn an average of £20,000.

With an MTA certification on your CV you will be qualified for an entry level position in one of the following fields:

  • Mobile Application Developer
  • IT Security Specialist
  • Database Administrator
  • Network Administrator
  • Help Desk Technician
  • Video Game Designer
  • Website Developer
  • Software Engineer
  • Systems Analyst

For more information, contact one of our course advisors

Microsoft Official Courses On-Demand

Microsoft Official Courses On-Demand (MOC On-Demand) blend video, text, Official hands-on labs, and knowledge checks to help you build your Microsoft technology skills—on your own schedule, at your own pace, and in your own place. No need to spend time and money traveling to a classroom location or adhering to classroom hours—with a computer and an Internet connection, your Microsoft Official Courses On-Demand come to you, anytime.

Offered exclusively by Microsoft Learning Partners, Microsoft Official Courses On-Demand are created by the premier technical and instructional experts in Microsoft technologies: Microsoft Certified Trainers (MCTs) and subject matter experts. Microsoft Learning Partners are the only ones in the market authorized to deliver Microsoft Official Courses. With Microsoft-authored, high-quality, accurate content, successfully completing a MOC On-Demand gives you solid credentials as you grow your IT skills—and your career.

Direct-from-the-source content that includes hands-on training—which increases skill proficiency—combined with anytime, anywhere learning, makes Microsoft Official Courses On-Demand an ideal solution for busy, time-constrained professionals.

Take a look at the video below to explore more about MOC On-Demand

How to take a MOC On-Demand

Microsoft Official Courses On-Demand are offered exclusively by Microsoft Learning Partners, the only ones in the market that provide authorized training using Microsoft Official Courses.

Find a MOC On-Demand through a Microsoft Learning Partner like ourselves.

After you purchase your course from a Microsoft Learning Partner, you receive a confirmation email with a redeemable course code, details, and instructions.

To redeem the course code and get started with a MOC On-Demand, sign in to your training dashboard, where you will find your MOC On-Demand progress and purchases.

Note MOC On-Demand is currently available only in English.

Training Solution Breakdown

  • Anywhere access to recorded instructor
  • Microsoft official training content
  • In-depth training
  • Official hands-on labs
  • SATV redemption
MOC On-Demand Training Available

Click below to expand the areas and see more information:

Installing and Configuring Windows 10 (OD20697)

About This Course

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

Audience Profile

This course is intended for IT professionals who administer and support Windows 10 desktops, devices, users, and associated network and security resources. Students who seek certification in the 70-697 Windows 10 Configuring exam will also benefit from this course. This course is also intended to provide skills for Enterprise Desktop/Device Support Technicians (EDSTs) who provide Tier 2 support to users who run Windows 10 desktops and devices within a Windows domain environment in medium to large enterprise organizations.

At Course Completion

After completing this course, students will be able to:

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

For more information, contact one of our course advisors

Introduction to SQL Databases (OD10985)

About This Course

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

Audience Profile

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

At Course Completion

After completing this course, students will be able to:

  • Describe key database concepts in the context of SQL Server 2016
  • Describe database languages used in SQL Server 2016
  • Describe data modelling techniques
  • Describe normalization and denormalization techniques
  • Describe relationship types and effects in database design
  • Describe the effects of database design on performance
  • Describe commonly used database objects

For more information, contact one of our course advisors

Supporting and Troubleshooting Windows 10 (OD10982)

About This Course

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

Audience Profile

The primary audience for this course is the Enterprise Desktop Support Technician (EDST), who provides Tier 2 support to users running Windows 10 personal computers (PCs) and devices in medium to large enterprise organizations, within a Windows domain environment. EDSTs focus on a broad range of technical issues for Windows operating systems (OSs),devices, cloud services, applications, networking, and hardware support. In the overarching scenario, if an Enterprise offers the service,the EDST is asked to support it.

The key responsibilities include resolving technical issues pertaining to Windows 10 installation and migration, activation, performance, profiles, settings; and device synchronization.Some other key responsibilities include local and remote network access; access to applications, access to data and printers; authentication, Endpoint security and policy; and data recovery.

The secondary audience for this course are IT professionals who administer and support Windows 10 desktops, devices, users, and associated network and security resources.Students who seek certification in the 70-697, Windows 10 Configuring exam will also benefit from this course.

At Course Completion

After completing this course, students will be able to:

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

For more information, contact one of our course advisors

Updating Your Skills to SQL Server 2016 (OD10986)

About This Course

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

Audience Profile

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

At Course Completion

After completing this course, students will be able to:

  • Describe key capabilities and components of SQL Server 2016
  • Describe new and enhanced features in SQL Server performance
  • Describes new and enhanced features in SQL Server security
  • Describe what’s new in SQL Server Availability and Scalability
  • Describe new and enhanced features in reporting and PowerBI in SQL Server 2016
  • Troubleshoot client configuration failures and GPO application issues.
  • Describe new and enhanced data access features
  • Describe new and enhanced features in SQL Server OLAP
  • Describe new SQL Server cloud functionality

For more information, contact one of our course advisors

Deploying Windows Desktops and Enterprise Applications (OD20695)

About This Course

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

Audience Profile

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

At Course Completion

After completing this course, students will be able to:

  • Assess the network environment to support operating system and application deployment tasks.
  • Identify the most appropriate operating system deploymenet stratengy abased upon organisational requirements.
  • Assess application compatability issues and identify mitigation solutions to ensure that applications function successfully after an operating system deployment.
  • Describe and configure strategies to migrate user state during operating system deployments.
  • Determine the most appropriate image management strategy to support operating system and application deployments.
  • Describe and use the tools provided in the Windows ADK to prepare for and support automated deployment strategies.
  • Identify solutions to support PXE-initiated and multicase soltuions when performing operating system deployment tasks.
  • Configure an operating system deployment stratefy by using the MDT.
  • Configure an operating system deployment strategy using Configuration Manager.
  • Integrate the MDT with Configuration Manager to support operating system deployment procedures.
  • Implement volume licence activation and configuration settings for client computers.
  • Customise and deploy Microsoft Office 2016 to an enterprise network environment and describe how to use the Windows ICD.

For more information, contact one of our course advisors

Administering System Center Configuration Manager and Intune (OD20696)

About This Course

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

Audience Profile

This course is for experienced information technology (IT) professionals, typically described as Enterprise Desktop Administrators (EDAs). EDAs deploy, manage, and maintain PCs, devices, and applications across medium, large, and enterprise organizations. A significant portion of this audience uses, or intends to use, the latest release of Configuration Manager and Intune to manage and deploy PCs, devices, and applications. By using Configuration Manager with Intune, EDAs also can support either domain-joined or non-domain-joined Bring Your Own Device (BYOD) scenarios, mobile-device management, and secure data access on common operating-system platforms, such as Windows, Windows Phone, Apple iOS, and Android.

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

At Course Completion

After completing this course, students will be able to:

  • Describe the features Configuration Manager and Intune include, and explain how you can use these features to manage PCs and mobile devices in an enterprise environment.
  • Prepare a management infrastructure, including configuring boundaries, boundary groups, and resource discovery, and integrating mobile-device management with Microsoft Exchange Server.
  • Deploy and manage the Configuration Manager client.
  • Configure, manage, and monitor hardware and software inventory, and use Asset Intelligence and software metering.
  • Identify and configure the most appropriate method to distribute and manage content used for deployments.
  • Distribute, deploy, and monitor applications for managed users and systems.
  • Maintain software updates for PCs that Configuration Manager manages.
  • Use Configuration Manager to implement Endpoint Protection.
  • Manage configuration items, baselines, and profiles to assess and configure compliance settings and data access for users and devices.
  • Configure an operating-system deployment strategy by using Configuration Manager.
  • Manage mobile devices by using Configuration Manager and Intune.
  • Manage and maintain a Configuration Manager site.

For more information, contact one of our course advisors

Administering The Web Server (IIS) Role of Windows Server (OD10972)

About This Course

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

Audience Profile

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

At Course Completion

After completing this course, students will be able to:

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

For more information, contact one of our course advisors

Fundamentals of a Windows Server Infrastructure (OD10967)

About This Course

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

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

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

Audience Profile

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

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

At Course Completion

After completing this course, students will be able to:

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

Prerequisites

Before attending this course, students must have:

  • Basic knowledge/experience with Windows Server 2012.

For more information, contact one of our course advisors

Installing and Configuring Windows Server (OD20410)

About This Course

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

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

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

Audience Profile

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

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

At Course Completion

After completing this course, students will be able to:

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

Prerequisites

Before attending this course, students must have:

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

For more information, contact one of our course advisors

Administering Windows Server 2012 (OD20411)


About This Course

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

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

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


Audience Profile

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

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


At Course Completion

After completing this course, students will be able to:

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


Prerequisites

Before attending this course, students must have:

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

For more information, contact one of our course advisors

Configuring Advanced Windows Server 2012 Services (OD20412)


About This Course

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

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


Audience Profile

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

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


At Course Completion

After completing this course, students will be able to:

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


Prerequisites

Before attending this course, students must have:

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

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

For more information, contact one of our course advisors

Designing and Implementing a Server Infrastructure (OD20413)


About This Course

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

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

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


Audience Profile

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


At Course Completion

After completing this course, students will be able to:

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


Prerequisites

Before attending this course, students must have:

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

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

For more information, contact one of our course advisors

Developing Microsoft Azure Solutions (OD20532)


About This Course

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

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


Audience Profile

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

At Course Completion

After completing this course, students will be able to:

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


Prerequisites

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

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

For more information, contact one of our course advisors

Windows Server® 2016 First Look Clinic (OD40389)


About This Course

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

Audience Profile

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


Prerequisites

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

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

For more information, contact one of our course advisors

Upgrading Your Skills to MCSA Windows Server 2012 (OD20417)


About This Course

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

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

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


Audience Profile

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

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


At Course Completion

After completing this course, students will be able to:

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


Prerequisites

Before attending this course, students must have:

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

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

For more information, contact one of our course advisors

Upgrading Your Skills to MCSA: Windows Server 2016 (OD20743)


About This Course

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

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


Audience Profile

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

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


At Course Completion

After completing this course, students will be able to:

  • Install and configure Windows Server 2016.
  • Describe storage in Windows Server 2016.
  • Implement directory services.
  • Implement Active Directory Federation Services (AD FS).
  • Describe networking.
  • Implement Hyper-V.
  • Configure advanced networking features.
  • Implement software-defined networking.
  • Implement remote access.
  • Deploy and manage Windows and Hyper-V containers.
  • Implement failover clustering.
  • Implement failover clustering by using virtual machines.


Prerequisites

Before attending this course, students must have:

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

For more information, contact one of our course advisors

Automating Administration with Windows PowerShell (OD10961)


About This Course

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

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

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

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


Audience Profile

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

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


At Course Completion

After completing this course, students will be able to:

  • Understand the basic concepts behind Windows PowerShell
  • Work with the Pipeline
  • Understand How the Pipeline Works
  • Use PSProviders and PSDrives
  • Format Output
  • Use WMI and CIM
  • Prepare for Scripting
  • Moving From a Command to a Script to a Module
  • Administer Remote Computers
  • Put the various Windows PowerShell components together
  • Use Background Jobs and Scheduled Jobs
  • Use Advanced PowerShell Techniques and Profiles


Prerequisites

Before attending this course, students must have:

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

For more information, contact one of our course advisors

Automating Administration with Windows PowerShell (OD10961)


About This Course

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

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


Audience Profile

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

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


At Course Completion

After completing this course, students will be able to:

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


Prerequisites

Before attending this course, students must have:

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

For more information, contact one of our course advisors

Advanced Automated Administration with Windows PowerShell (OD10962)


About This Course

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


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

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

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

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


Audience Profile

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

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


At Course Completion

After completing this course, students will be able to:

  • Create Advanced Functions
  • Use Cmdlets and Microsoft .NET Framework in Windows PowerShell
  • Write Controller Scripts
  • Handle Script Errors
  • Use XML Data Files
  • Manage Server Configurations by Using Desired State Configuration
  • Analyze and Debugging Scripts
  • Understand Windows PowerShell Workflow


Prerequisites

Before attending this course, students must have:

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

For more information, contact one of our course advisors

Cloud & Datacenter Monitoring with System Center Operations Manager (OD10964)


About This Course

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

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


Audience Profile

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


At Course Completion

After completing this course, students will be able to:

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

Configure the following:

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

For more information, contact one of our course advisors

Active Directory Services with Windows Server(OD10969)


About This Course

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


Audience Profile

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

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


At Course Completion

After completing this course, students will be able to:

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


Prerequisites

Before attending this course, students must have:

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

For more information, contact one of our course advisors

Querying Microsoft SQL Server 2014 (OD20461)


About This Course

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

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


Audience Profile

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


At Course Completion

After completing this course, students will be able to:

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


Prerequisites

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

For more information, contact one of our course advisors

Administering Microsoft SQL Server 2014 Databases (OD20462)


About This Course

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


Audience Profile

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


At Course Completion

After completing this course, students will be able to:

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


Prerequisites

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

For more information, contact one of our course advisors

Implementing a Data Warehouse with Microsoft SQL Server 2014 (OD20463)


About This Course

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

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


Audience Profile

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

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


At Course Completion

After completing this course, students will be able to:

  • Describe data warehouse concepts and architecture considerations.
  • Select an appropriate hardware platform for a data warehouse.
  • Implement Data Flow in an SSIS package.
  • Implement Control Flow in an SSIS package.
  • Debug and troubleshoot SSIS package.
  • Implement an ETL solution that supports incremental data extraction.
  • Implement an ETL solution that supports incremental data loading.
  • Implement data cleansing by using Microsoft Data Quality Services.
  • Implement Master Data Services to enfore data integrity.
  • Extend SSIS with custom scripts and components.
  • Deploy and configure SSIS packages.
  • Describe how DI solutions can consume data from the data warehouse.


Prerequisites

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

For more information, contact one of our course advisors

Implementing Microsoft Azure Infrastructure Solutions (OD20533)


About This Course

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

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

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

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


Audience Profile

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

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


At Course Completion

After completing this course, students will be able to:

  • Describe data warehouse concepts and architecture considerations.
  • Select an appropriate hardware platform for a data warehouse.
  • Implement Data Flow in an SSIS package.
  • Implement Control Flow in an SSIS package.
  • Debug and troubleshoot SSIS package.
  • Implement an ETL solution that supports incremental data extraction.
  • Implement an ETL solution that supports incremental data loading.
  • Implement data cleansing by using Microsoft Data Quality Services.
  • Implement Master Data Services to enfore data integrity.
  • Extend SSIS with custom scripts and components.
  • Deploy and configure SSIS packages.
  • Describe how DI solutions can consume data from the data warehouse.


Prerequisites

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

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

For more information, contact one of our course advisors

Installing and Configuring Windows 10 (OD20697-1)


About This Course

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


Audience Profile

This course is intended for IT professionals who administer and support Windows 10 desktops, devices, users, and associated network and security resources. Students who seek certification in the 70-697 Windows 10 Configuring exam will also benefit from this course. This course is also intended to provide skills for Enterprise Desktop/Device Support Technicians (EDSTs) who provide Tier 2 support to users who run Windows 10 desktops and devices within a Windows domain
environment in medium to large enterprise organizations.


At Course Completion

After completing this course, students will be able to:

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


Prerequisites

Before attending this course, students must have:

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

For more information, contact one of our course advisors

Querying Data with Transact-SQL (OD20761)


About This Course

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


Audience Profile

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


At Course Completion

After completing this course, students will be able to:

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

For more information, contact one of our course advisors

Developing SQL Databases (OD20762)


About This Course

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


Audience Profile

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

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


At Course Completion

After completing this course, students will be able to:

  • Design and implement tables
  • Describe advanced table designs
  • Ensure data integrity through constraints
  • Describe indexes; including optimised and columnstore indexes
  • Design and implement views
  • Design and implement stored procedures
  • Design and implement user defined functions
  • Respond to data manipulation using triggers
  • Design and implement in-memory tables
  • Implement managed code in SQL Server
  • Store and query XML data.
  • Work with spatial data
  • Store and query blobs and text documents

For more information, contact one of our course advisors

Programming in HTML5 with JavaScript and CSS3 (OD20480)


About This Course

This course provides an introduction to HTML5, CSS3, and JavaScript. This course helps students gain basic HTML5/CSS3/JavaScript programming skills. This course is an entry point into both the Web application and Windows Store apps training paths. The course focuses on using HTML5/CSS3/JavaScript to implement programming logic, define and use variables, perform looping and branching, develop user interfaces, capture and validate user input, store data, and create well-structured application. The lab scenarios in this course are selected to support and demonstrate the structure of various application scenarios. They are intended to focus on the principles and coding components/structures that are used to establish an HTML5 software application.


Audience Profile

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

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

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


At Course Completion

After completing this course, students will be able to:

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


Prerequisites

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

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

For more information, contact one of our course advisors

Programming in C# (OD20483)


About This Course

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

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

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

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


Audience Profile

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

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


At Course Completion

After completing this course, students will be able to:

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


Prerequisites

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

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

For more information, contact one of our course advisors

Introduction to Web Development with Microsoft Visual Studio 2010 (OD10267)


About This Course

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


Audience Profile

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


At Course Completion

After completing this course, students will be able to:

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


Prerequisites

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

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

For more information, contact one of our course advisors

Administering System Center 2012 Configuration Manager (OD10747)


About This Course

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


Audience Profile

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

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


At Course Completion

After completing this course, students will be able to:

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


Prerequisites

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

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

For more information, contact one of our course advisors

Planning and Deploying System Center 2012 Configuration Manager (OD10748)


About This Course

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

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

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


Audience Profile

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

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

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

After completing this course, students will be able to:

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

For more information, contact one of our course advisors

IT Service Management with System Center Service Manager (OD10965)


About This Course

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

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


Audience Profile

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


At Course Completion

After completing this course, students will be able to:

  • Describe Service Manager 2012 R2.
  • Install Service Manager 2012 R2.
  • Describe Service Manager usage cases.
  • Configure base settings in Service Manager 2012 R2.
  • Configure Incident and Problem Management.
  • Configure Activity, Change, and Release Management.
  • Configure and Manage Service Requests.
  • Automate business processes with Service Manager and Orchestrator.
  • Configure Service Level Management.
  • Customize The Self-Service Portal.
  • Use Reports and Analyze Data in Service Manager.
  • Perform advanced troubleshooting and disaster recovery in Service Manager.
  • Customize Service Manager Forms.

For more information, contact one of our course advisors

Microsoft Azure for AWS Experts (OD40390)


About This Course

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


Audience Profile

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


At Course Completion

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

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

For more information, contact one of our course advisors

Microsoft Azure Fundamentals (OD10979)


About This Course

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

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


Audience Profile

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

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


At Course Completion

After completing this course, students will be able to:

  • Describe cloud computing, Azure, and Azure subscriptions.
  • Describe and create Azure Web Apps.
  • Create and configure VMs in Microsoft Azure.
  • Create an Azure virtual network.
  • Describe Azure storage.
  • Describe and deploy databases in Azure.
  • Describe Azure AD.

For more information, contact one of our course advisors

Networking with Windows Server 2016 (OD20741)


About This Course

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


Audience Profile

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

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

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


At Course Completion

After completing this course, students will be able to:

  • Plan and implement an IPv4 network.
  • Implement Dynamic Host Configuration Protocol (DHCP). Implement IPv6.
  • Implement Domain Name System (DNS).
  • Implement and manage IP address management (IPAM).
  • Plan for remote access.
  • Implement DirectAccess.
  • Implement virtual private networks (VPNs).
  • Implement networking for branch offices.
  • Configure advanced networking features.
  • Implement Software Defined Networking.

For more information, contact one of our course advisors

Performance Tuning and Optimizing SQL Databases (OD10987)


About This Course

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


Audience Profile

The primary audience for this course is individuals who administer and maintain SQL Server databases and are responsible for optimal performance of SQL Server instances that they manage. These individuals also write queries against data and need to ensure optimal execution performance of the workloads.

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


At Course Completion

After completing this course, students will be able to:

  • Describe the high level architectural overview of SQL Server and its various components.
  • Describe the SQL Server execution model, waits and queues.
  • Describe core I/O concepts, Storage Area Networks and performance testing.
  • Describe architectural concepts and best practices related to data files for user databases and TempDB.
  • Describe architectural concepts and best practices related to Concurrency, Transactions, Isolation Levels and Locking.
  • Describe architectural concepts of the Optimizer and how to identify and fix query plan issues.
  • Describe architectural concepts, troubleshooting scenarios and best practices related to Plan Cache.
  • Describe architectural concepts, troubleshooting strategy and usage scenarios for Extended Events.
  • Explain data collection strategy and techniques to analyze collected data.
  • Understand techniques to identify and diagnose bottlenecks to improve overall performance.

For more information, contact one of our course advisors

Core Solutions of Microsoft SharePoint Server 2013 (OD20331)


About This Course

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

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


Audience Profile

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

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

The minimally qualified candidate typically:

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

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

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


At Course Completion

After completing this course, students will be able to:

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


Prerequisites

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

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

For more information, contact one of our course advisors

Developing Microsoft SharePoint Server 2013 Core Solutions (OD20488)


About This Course

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


Audience Profile

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

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

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


At Course Completion

After completing this course, students will be able to:

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


Prerequisites

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

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

For more information, contact one of our course advisors

Advanced Solutions of Microsoft SharePoint Server 2013 (OD20332)


About This Course

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


Audience Profile

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

The training addresses three audiences:

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


At Course Completion

After completing this course, students will be able to:

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


Prerequisites

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

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

For more information, contact one of our course advisors

Analyzing Data with Power BI (OD10989)


About This Course

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

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


Audience Profile

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

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


At Course Completion

After completing this course, students will be able to:

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


Prerequisites

This course requires that you meet the following prerequisites:

  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Basic knowledge of data warehouse schema topology (including star and snowflake schemas).
  • Some exposure to basic programming concepts (such as looping and branching).
  • An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.
  • Familiarity with Microsoft Office applications – particularly Excel.

For more information, contact one of our course advisors

Analyzing Data with Power BI (OD20778A)


About This Course

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


Audience Profile

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


At Course Completion

After completing this course, students will be able to:

  • Perform Power BI desktop data transformation
  • Describe Power BI desktop modelling
  • Create a Power BI desktop visualization
  • Implement the Power BI service
  • Describe how to connect to Excel data
  • Describe how to collaborate with Power BI data
  • Connect directly to data stores
  • Describe the Power BI developer API
  • Describe the Power BI mobile app

For more information, contact one of our course advisors

Analyzing Data with SQL Server Reporting Services (OD10990)


About This Course

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


Audience Profile

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

The secondary audiences for this course are power information workers.


At Course Completion

After completing this course, students will be able to:

  • Describe key features of data modeling within business intelligence
  • Describe various report services data sources and how these are configured
  • Create reports with report designer and/or report designer
  • Configure reports with report designer and/or report builder
  • Create SQL Server mobile reports


Prerequisites

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

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

For more information, contact one of our course advisors

Core Solutions of Skype For Business 2015 (OD20334)


About This Course

This course teaches IT professionals how to plan, deploy, configure, and administer a Skype for Business 2015 solution. Students will learn how to deploy a multi-site and highly available Skype for Business infrastructure that supports instant messaging, conferencing, persistent chat, archiving, and monitoring. Students will also learn how to manage, maintain, and troubleshoot issues in the infrastructure. This course focuses primarily on the on-premises deployment of Skype for Business, but does include information on how to integrate the on-premises deployment with Skype for Business Online as well as how to migrate from previous versions of Lync Server. This course helps the student prepare for Exam 70-334.


Audience Profile

This course is intended for IT professionals who are responsible for the Skype for Business deployment in their organizations. Experience with previous versions of Lync Server is beneficial but not required to take this course. Students should be proficient with Active Directory Domain Services, data networks, and telecommunications
standards and components that support the configuration of Skype for Business. Students should also be familiar with Exchange Server and Office 365.

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


At Course Completion

After completing this course, students will be able to:

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

For more information, contact one of our course advisors

Core Solutions of Microsoft Exchange Server 2013 (OD20341)


About This Course

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


Audience Profile

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

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


At Course Completion

After completing this course, students will be able to:

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


Prerequisites

Before attending this course, students must have:

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

For more information, contact one of our course advisors

Advanced Solutions of Microsoft Exchange Server 2013 (OD20342)


About This Course

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


Audience Profile

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

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


At Course Completion

After completing this course, students will be able to:

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


Prerequisites

Before attending this course, students must have:

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

For more information, contact one of our course advisors

Administering Microsoft Exchange Server 2016 (OD20345-1AC)


About This Course

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


Audience Profile

This course is primarily intended for people aspiring to become enterprise-level messaging administrators for Exchange Server 2016. IT generalists and help-desk professionals who want to learn about Exchange Server 2016 might also take this course. Students taking this course are expected to have at least two years of experience working in the IT field—typically in the areas of Windows Server administration, network administration, help desk, or system administration. They are not expected to have experience with previous Exchange Server versions.

The secondary audience for this course includes IT professionals who take this course as preparation material for exam 70-345: Designing and Deploying Microsoft Exchange Server 2016, or as part of the requirement for the MCSE: Microsoft Exchange Server 2016 certification.


At Course Completion

After completing this course, students will be able to:

  • Perform deployment and basic management of Exchange Server 2016.
  • Manage Exchange Server 2016.
  • Create and manage various recipient objects in Exchange Server 2016.
  • Use the Exchange Management Shell to create and manager various recipient objects in Exchange Server 2016 and perform various tasks to automate Exchange management procedures.
  • Configure client connectivity to Exchange Server 2016, and manage Client Access services.
  • Implement and manage high availability.
  • Implement backup and disaster recovery for Exchange Server 2016.
  • Configure message transport options.
  • Implement and manage Exchange Online deployments.
  • Monitor and troubleshoot Exchange Server 2016.
  • Secure and maintain Exchange Server 2016.


Prerequisites

Before attending this course, students must have:

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

For more information, contact one of our course advisors

Designing and Deploying Microsoft Exchange Server 2016 (OD20345-2AC)


About This Course

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


Audience Profile

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

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


At Course Completion

After completing this course, students will be able to:

  • Plan for Exchange Server deployments.
  • Plan and deploy Exchange Server 2016 Mailbox services.
  • Plan and deploy message transport.
  • Plan and deploy client access.
  • Design and implement high availability.
  • Maintain Exchange Server 2016.
  • Design messaging security.
  • Design and implement message retention.
  • Design messaging compliance.
  • Design and implement messaging coexistence.
  • Upgrade to Exchange Server 2016.
  • Plan a hybrid Exchange Server deployment.


Prerequisites

Before attending this course, students must have:

  • A+ certification or equivalent knowledge.
  • Network+ certification or equivalent knowledge.
  • Completed Course 2028A, Basic Administration of Microsoft Windows 2000, or have equivalent knowledge of administrative tasks.

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

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

For more information, contact one of our course advisors

Customer Demo Course: Installing and Configuring Windows 10 – Module 1 (OD99998)


About This Course

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

For more information, contact one of our course advisors

Demo Course: Supporting and TroubleShooting Windows 10 – Module 8 (OD99996)
Demo Course: Using Microsoft Official Course On-Demand (OD99999)


About This Course

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


Audience Profile

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

For more information, contact one of our course advisors

What is the MTA Mobility and Devices Fundamentals?

MTA Mobility and Devices Fundamentals (98-368) is designed to prepare students to learn to accomplish the technical tasks required to pass exam 98-368. Students will gain an understanding of device configurations, security, cloud services, data access, and management. This exam is one step forward in earning a Microsoft Certified Solutions Associate (MCSA) certification.

Students who are beginning studies in technology need a strong foundation in the basics before moving on to more advanced technology courses and certification programs. The Microsoft Technology Associate (MTA) is a new and innovative certification track designed to provide a pathway for future success in technology courses and careers. The MTA program curriculum helps instructors teach and validate fundamental technology concepts and provides students with a foundation for their careers as well as the confidence they need to succeed in advanced studies. Through the use of MOAC MTA titles you can help ensure your students future success in and out of the classroom. Students will learn to configure and secure Windows devices, access and manage data (including cloud storage), learn basics of Microsoft cloud services (including Microsoft Azure and Microsoft Intune), and learn about enterprise mobility including Bring Your Own Device policies.

Training Solution Breakdown

  • Intuitive and rewarding online training resources
  • Official Microsoft Exams
  • Comprehensive Freephone or email support
  • 24/7 access to training materials
  • Study anytime, anywhere in a world for a flexible learning experience
  • Full mock examinations to fully prepare you for any final exam
  • 12 months (one year) unrestricted access
  • Access to online or classroom training options
  • Progress reviews & comprehensive assessments to ensure efficient understanding of course content
  • Career advice and CV support once training has been completed
Mobility and Devices Course Breakdown

Click below to expand the areas and see more information:

Understand device configurations (20-25%)

Configure device options

  • Describe Microsoft account, configure Control Panel, configure system options

Configure desktop settings

  • Configure the Start menu, profiles, display settings, shortcuts, and group configurations and capabilities

Configure drive encryption

  • Configure BitLocker, prepare for file encryption

Configure updates

  • Describe Windows Update, describe app updates, describe device system updates

For more information, contact one of our course advisors

Understand data access and management (20-25%)

Describe cloud storage services

  • Describe OneDrive, Microsoft Azure storage, OneNote, Outlook and Office 365

Describe local storage

  • Describe storage spaces and storage pools

Describe file systems

  • Describe FAT, FAT32, NTFS and Resilient File System Overview (ReFS)

Describe file and print sharing

  • Describe NTFS and share permissions, HomeGroup, print drivers and effective permissions; create public, basic and advanced shares; map drives

Describe data encryption

  • Describe encrypting file system (EFS); describe how EFS-encrypted folders impact moving and copying files; describe BitLocker To Go, virtual private network (VPN), public key and private key; certificate services; and SSL

For more information, contact one of our course advisors

Understand device security (20-25%)

Describe the differences between the Internet, an intranet and an extranet

  • Describe uses of private networks, public networks, firewalls and clouds

Describe user authentication

  • Describe Multifactor authentication, describe smart cards, describe Windows Rights Management Services, describe biometrics and password procedures

Describe permissions

  • Configure file and share permissions; describe the behaviour when moving or copying files from one location to another; describe basic and advanced permissions; describe taking ownership, delegating and resultant permissions

Describe malware

  • Describe computer viruses, Trojan horses, spyware and adware; describe antivirus and antimalware strategies

For more information, contact one of our course advisors

Understand cloud services(20-25%)

Describe the types of cloud services

  • Describe productivity services, storage services, communications services and search services

Describe Microsoft Intune

  • Describe Microsoft Intune capabilities, describe selective wipe, describe location settings

Describe Microsoft Azure

  • Describe virtual machines; describe Azure services; describe disaster recovery, high availability, redundancy and fault tolerance

For more information, contact one of our course advisors

Understand enterprise mobility (20-25%)

Describe identity services

  • Describe Windows Server Active Directory and Azure Active Directory, Microsoft Account and federation services

Describe business data access

  • Describe Company Portal, describe Work Folders, describe Azure RemoteApp

Describe Bring Your Own Device (BYOD)

  • Describe device-centric to people-centric IT, describe desktop virtualisation, describe Dynamic Access Control policies, describe Windows Rights Management

For more information, contact one of our course advisors

Job Role

Due to the variety available via an MTA the specific job roles that a certified candidate will qualify for varies depending on their chosen speciality, generally though those that hold an MTA qualification will earn an average of £20,000.

With an MTA certification on your CV you will be qualified for an entry level position in one of the following fields:

  • Mobile Application Developer
  • IT Security Specialist
  • Database Administrator
  • Network Administrator
  • Help Desk Technician
  • Video Game Designer
  • Website Developer
  • Software Engineer
  • Systems Analyst

For more information, contact one of our course advisors

What is an MCSD Qualification?

Programming is a process that begins with the conception of a new programme and runs all the way through to the final release of an .exe file; programmers identify computer problems or needs and go through the creation process to release a final application to meet a consumer or business demands. The purpose of programming is to find a sequence of instructions that will automate a specific task or solve a given problem by writing these instructions in to source code. This source code is written in one or more programming languages (such as C++, C#, Java, Python, Smalltalk, JavaScript, etc.)

A qualification in programming is ideal for those with a meticulous eye and a keen interest in problem solving, those with the correct characteristics will be able to thrive in a popular and demanding sector that can be both lucrative and exciting. Earning a Microsoft qualification in programming will allow you to highlight your skills as a programmer and will underline your adept abilities with a variety of core programming languages.

Areas of Expertise


  • Introductory – Introductory Pack (MTA): Available for a number of languages, from software and game
    development to web and HTML development.

  • Advanced – Microsoft Certified Solutions Developer (MCSD): Available in a number of languages and
    variants, mainly Windows Store Apps and Web Applications.

Training Solution Breakdown:

  • Intuitive and rewarding online training resources
  • Official Microsoft Exams
  • Comprehensive Freephone or email support
  • 24/7 access to training materials
  • Study anytime, anywhere in a world for a flexible learning experience
  • Full mock examinations to fully prepare you for any final exam
  • 12 months (one year) unrestricted access
  • Access to online or classroom training options
  • Progress reviews & comprehensive assessments to ensure efficient understanding of course content
  • Career advice and CV support once training has been completed
MCSD Breakdown

Click below to expand the areas and see more information:

MCSD: Windows Store Apps
  • Programming in HTML5 with JavaScript and CSS3 - Exam: 70-480
  • Essentials of Developing Windows Store Apps Using HTML5 and JavaScript - Exam: 70-481
  • Advanced Windows Store App Development Using HTML5 and JavaScript - Exam: 70-482

Get your MCSD: Windows Store Apps Using C#

  • Programming in C# - Exam: 70-483
  • Essentials of Developing Windows Store Apps Using C# - Exam: 70-484
  • Advanced Windows Store App Development Using C# - Exam: 70-485

For more information, contact one of our course advisors

MCSD: Web Applications
  • Programming in HTML5 with JavaScript and CSS3 - Exam: 70-480
  • Developing ASP.NET MVC Web Applications - Exam: 70-486
  • Developing Microsoft Azure and Web Services - Exam: 70-487

For more information, contact one of our course advisors

MCSD: SharePoint Applications
  • Programming in HTML5 with JavaScript and CSS3 - Exam: 70-480
  • Developing ASP.NET MVC Web Applications - Exam: 70-486
  • Developing Microsoft SharePoint Server 2013 Core Solutions - Exam: 70-488
  • Developing Microsoft SharePoint Server 2013 Advanced Solutions - Exam: 70-489

For more information, contact one of our course advisors

MCSD: Azure Solutions Architect
  • Developing Microsoft Azure Solutions - Exam: 70-532
  • Implementing Microsoft Azure Infrastructure Solutions - Exam: 70-533
  • Architecting Microsoft Azure Solutions - Exam: 70-534

For more information, contact one of our course advisors

MCSD: Application Lifecycle Management
  • Administering Microsoft Visual Studio Team Foundation Server - Exam: 70-496
  • Software Testing with Visual Studio - Exam: 70-497
  • Delivering Continuous Value with Visual Studio Application Lifecycle Management - Exam: 70-498

For more information, contact one of our course advisors

Job Role

Earning an MCSD qualification will ensure that you qualify for a number of lucrative positions within programming, with MCSD certified employees earning an average of £52,200.

The jobs that you will be qualified for are as follows:

  • Developer
  • .NET Developer
  • Consultant
  • C# Developer
  • Software Developer
  • Architect

For more information, contact one of our course advisors

What is SQL Training?

SQL is a powerful special purpose programming language that works to ensure a number of the modern technologies that we rely on today run consistently and smoothly. This language type is designed to manage data held in a RDBMS (Relational Database Management System). Being a relational database engine was SQL’s original purpose but it has since grown to include a number of new database technologies, such as Relational Data Stream Management System (RDSMS).

In reality more people work with SQL Server in their day to day tasks than anyone probably realises. Many web sites and core business applications are supported by SQL Server. Typically SQL Server based applications are designed, built, maintained and enhanced by DBAs, Developers, Data Modellers, Network Admins, System Admins, Storage Admins, etc.

Want to get behind the programs? Develop the core root data that applications and websites rely on? This training will get you the fundamentals and knowhow to get into a database-focused career and will open up a number of lucrative career options.

Areas of Expertise

There are 3 levels of qualifications you can receive in SQL, namely:

  • Introductory – Introductory Pack (MTA)
  • Intermediate – Microsoft Certified Solutions Associate (MCSA)
  • Advanced – Microsoft Certified Solutions Expert (MCSE)

Training Solution Breakdown:

  • Intuitive and rewarding online training resources
  • Official Microsoft Exams
  • Comprehensive Freephone or email support
  • 24/7 access to training materials
  • Study anytime, anywhere in a world for a flexible learning experience
  • Full mock examinations to fully prepare you for any final exam
  • 12 months (one year) unrestricted access
  • Access to online or classroom training options
  • Progress reviews & comprehensive assessments to ensure efficient understanding of course content
  • Career advice and CV support once training has been completed
SQL Breakdown

Click below to expand the areas and see more information:

MCSA: SQL Server 2012
  • Querying Microsoft SQL Server 2012 - Exam: 461
  • Administering Microsoft SQL Server 2012 Databases - Exam: 462
  • Implementing a Data Warehouse with Microsoft SQL Server 2012 - Exam: 463

For more information, contact one of our course advisors

MCSA: SQL Server 2008
  • Querying Microsoft SQL Server 2012 - Exam: 461
  • Administering Microsoft SQL Server 2012 Databases - Exam: 462
  • Implementing a Data Warehouse with Microsoft SQL Server 2012 - Exam: 463

For more information, contact one of our course advisors

MCSE: Data Platform
  • Developing Microsoft SQL Server Databases - Exam: 464
  • Designing Solutions for SQL Server - Exam: 465

For more information, contact one of our course advisors

MCSE: Business Intelligence
  • Implementing Data Models and Reports with Microsoft SQL Server - Exam: 466
  • Designing Business Intelligence Solutions with Microsoft SQL Server - Exam: 467

For more information, contact one of our course advisors

Job Role

Achieving a qualification in SQL will unlock a number of doors within a variety of database roles, with salaries of those holding a certification in SQL Server earning between £26,569 and £48,834. (Figures sourced from Payscale dated March 2015.)

The roles that an SQL specialist can fulfil are as follows:

  • Developer
  • Analyst
  • Database Administrator
  • .NET Developer
  • Business Analyst

For more information, contact one of our course advisors

© 2017 titanium.training Privacy Terms