This course is preparation for the 70-463 exam and 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 2012, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.

 

 

This course prep for the 70-466 exam and focuses on creating managed enterprise BI solutions. It describes how to implement multidimensional and tabular data models, deliver reports with Microsoft SQL Server Reporting Services, create dashboards with Microsoft SharePoint Server PerformancePoint Services, and discover business insights by using data mining.

 

 

This exam is intended for business intelligence (BI) architects, who are responsible for the overall design of a BI infrastructure and how it relates to other data systems in use.

 

 

Installation, Storage and Compute is the first of a series of courses and exams designed to achieve the MCSA certification in Windows Server 2016. We will cover installation of Windows Server through standard manual means and image based installations discussing various requirements and different versions. In addition we will cover the multiple administrative tools that are available. Windows Server 2016 supports several types of storage and introduces new features and enhancements to features such as Storage Spaces and Data Deduplication. We will also discuss the connections of Windows Server 2016 physical and virtual machines to iSCSI and Fibre Channel SANs. Hyper-V , the virtualization platform in Windows Server 2016, has undergone various changes and enhancements such as PowerShell Direct, Nested Virtualization, and Shielded virtualization which will be discussed along with general configuration and management of virtual machines. We will also cover a new style of virtualization possible in Windows Server 2016 known as Containers. We will consider and configure various types high availability and disaster recovery that are available in Windows. In addition we will discuss the importance of patch management and monitoring and the various tools that are available in order to ensure the ongoing efficiency of Windows Server 2016.
Instructor - Patrick Loner

 

 

Networking with Windows Server 2016 is the 2nd course in the MCSA certification for Windows Server 2016. This course will cover all the major aspects of a network running this operating system. From planning and implementing IPv4 and IPv6 addressing schemes, troubleshooting client and server connectivity to name resolution with the Domain Name System and assignment of IP addresses using Dynamic Host Configuration Protocol. This course also covers various types of remote access capabilities that are supported in Windows SErver 2016 such as Virtual Private Networks, the Web Application Proxy and the DirectAccess alternative to remote access. We will also cover options that are available to optimize branch office scenarios such as BranchCache, Read Only Domain Controllers, and the Distributed File System. Additionally we will cover advanced networking features which are new and improved in Windows Server 2016.
Instructor: Patrick Loner

 

 

Identity in Windows Server 2016 is the 3rd course towards the MCSA 2016 certification. This course covers Active Directory Domain services the primary identity management platform for Windows Networks. Learn how to deploy domain controllers, manage various Active Directory objects, secure your network and manage it centrally using Group Policy. You will also learn how to connect your internal Active Directory to cloud based solutions such as Office 365 and Azure AD along with the establishment of complex AD DS internal infrastructures.
Instructor - Patrick Loner

 

 

This course covers the following topics in order to prepare for the exam: Install and configure servers. Configure server roles and features. Configure Hyper-V. Deploy and configure core network services. Install and administer Active Directory. Create and manage Group Policy. **NOTE: this course includes the Server 2012 R2 updates for the most recent exam.

 

 

This course covers the following topics in order to prepare for the exam: Deploy, manage, and maintain servers, Configure File and Print Services, Configure network services and access, Configure a Network Policy Server (NPS) infrastructure. Configure and manage Active Directory. Configure and manage Group Policy. **NOTE: this course includes the Server 2012 R2 updates for the most recent exam.

 

 

This course covers the following topics in order to prepare for the exam: configure and manage high availability, configure file and storage solutions, implement business continuity and disaster recovery, configure Network Services, configure the Active Directory infrastructure, and configure Identity and Access Solutions. **NOTE: this course includes the Server 2012 R2 updates for the most recent exam.

 

 

This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2012 and is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. This course is preparation for exam 70-461.

 

 

This course is preparation for the 70-462 Exam. The lectures provide students with the knowledge and skills to maintain a Microsoft SQL Server 2012 database and focuses on teaching individuals how to use SQL Server 2012 product features and tools related to maintaining a database.

 

 

This course is preparation for the 70-464 exam and introduces SQL Server 2012 and describes logical table design, indexing and query plans. It also focusses on the creation of database objects including views, stored procedures, along with parameters, and functions. Other common aspects of procedure coding, such as indexes, concurrency, error handling, and triggers are also covered in this course.

 

 

This course is on planning and implementing enterprise database infrastructure solutions by using SQL Server 2012 and other Microsoft technologies. It describes how to consolidate SQL Server workloads, work with both on-premises and Microsoft Azure cloud-based solutions, and how to plan and implement high availability and disaster recovery solutions.

 

 

Preparation for Microsoft Certification Exam 70-764. By the end of this course, you will be able to administer a Microsoft SQL 2016 server. This course is intended for IT professionals responsible for installing and maintaining a Microsoft SQL Server environment.
Instructor: Chrys Thorsen

 

 

This course prepares you for Microsoft Certification Exam 70-765. By the end of this course, you will be able to provision databases on Microsoft SQL Server 2016 and Microsoft Azure. This course is intended for IT professionals responsible for installing and maintaining a Microsoft SQL Server environment.
Instructor: Chrys Thorsen

 

 

This course is preparation for the 70-432 exam. This exam covers the following topics: Installing and configuring SQL Server 2008, Maintaining SQL Server instances, Managing SQL Server security, Maintaining a SQL Server database, Performing data management tasks, Monitoring and troubleshooting SQL Server, Optimizing SQL Server performance, Implementing high availability.

 

 

This course is preparation for the 70-448 exam. This exam covers the following topics: Implementing an SSIS solution, Configuring, deploying, and maintaining SSIS, Implementing an SSAS solution, Configuring, deploying, and maintaining SSAS, Implementing an SSRS solution, Configuring, deploying, and maintaining SSRS.

 

 

This course provides training for the features of Microsoft Office 365. "Office 365" refers to subscription plans that include access to Office applications plus other productivity services that are enabled over the Internet (cloud services), such as Lync web conferencing and Exchange Online hosted email for business, and additional online storage with OneDrive. Many Office 365 plans also include the desktop version of the latest Office applications, which users can install across multiple computers and devices.

 

 

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 Center and an understanding of Exchange Online, Lync Online, SharePoint Online, Office 365 ProPlus, and Microsoft 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 organization. Instructor - Rafiq Wayani

 

 

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. Instructor - Patrick Loner

 

 

Microsoft Access is now much more than a way to create desktop databases. It’s an easy to use tool for quickly creating browser based database applications that help you run your business. Your data is automatically stored in a SQL database, so it’s more secure and scalable than ever, and you can easily share your applications with colleagues. This course will guide you through the basics of relational database design and through the creation of database objects. You will learn how to use forms, query tables and reports to manage data. You will understand the interface, customization and creation editing of the many objects available within the Microsoft Access application. This course is divided in to three separate levels being Basic Microsoft Access, Intermediate Microsoft Access and Advanced Microsoft Access. Instructor - Josh Schofer

 

 

Microsoft Excel is the standard spreadsheet application for both personal and business use, so staying on top of the latest version is very important for anyone considering career advancement. Regardless of your level of understanding, you will benefit from this Microsoft Excel 2016 training course because it covers basic, intermediate and advanced competency levels. Our Microsoft Excel 2016 training course will help arm you with the knowledge to use it more effectively whether you are using it at home or in the workplace. Understand how to manipulate data within a spreadsheet, validate and present information using the built in structure and functions of Microsoft Excel. Instructor - Josh Schofer

 

 

Microsoft Outlook is by far one of the most popular email applications used by millions of professionals and students all over the world. Microsoft Outlook 2016 provides better organization, search capabilities, communication and social networking features. With this Microsoft Outlook 2016 training course, you will learn the four major components of outlook including contacts, email, calendars and tasks. This course will also touch on the OneNote application that provides a cross platform and cross application note taking tool. This course covers all the bases including Basic Outlook 2016, Intermediate Outlook 2016 and Advanced Outlook 2016. Instructor - Josh Schofer

 

 

Take your PowerPoint presentations to the next level with our Microsoft PowerPoint 2016 online training course! Whether you are a beginner or have experience and want to sharpen your skills, this online course will help you create professional quality presentations that will grab your audience’s attention and keep them interested from start to finish. This course is separated in to three main sections covering Basic PowerPoint, Intermediate PowerPoint and Advanced PowerPoint lessons, which will provide an in depth review of the presentation software included in the Office 2016 suite of applications. Learn to navigate the interface effectively, insert a range of objects and how to create engaging presentations that will wow viewers. Topics will include design, customization and presentation of information using Microsoft PowerPoint 2016. Instructor - Josh Schofer

 

 

Microsoft Word 2016 is a very popular word processing program that can be used for both personal and business purposes. While already feature rich and critical for productivity, Microsoft continues to improve and enhance their software with each new release like the latest Microsoft Word 2016. In this course, you will develop and improve your Microsoft Word skills, so that you are able to maximize this industry standard word processing system. This online training course will cover Basic Word 2016, Intermediate Word 2016 and Advanced Word 2016. Instructor - Josh Schofer

 

 

This course helps you learn how to use the features of Microsoft Access 2013. Access 2013 databases can help you store and track just about any kind of information, such as inventory, contacts, or business processes.

 

 

This course trains you how to use the features of Microsoft Excel 2013. Excel 2013 is an incredibly powerful tool for getting meaning out of vast amounts of data. But it also works really well for simple calculations and tracking almost any kind of information. The key for unlocking all that potential is the grid of cells. Cells can contain numbers, text or formulas. You put data in your cells and group them in rows and columns. That allows you to add up your data, sort and filter it, put it in tables, and build great-looking charts.

 

 

This course trains you how to use the features of Microsoft Outlook 2013. Microsoft Outlook 2013 organizes your emails, calendars, contacts, tasks, and to-do lists, all in one place. It all starts with your email account. From there you can start working with emails, turning them into tasks or appointments, and storing the people you interact with in your contacts, so you never have to remember an email address or phone number.

 

 

This course provides training for the features of Microsoft Office`s PowerPoint 2013. PowerPoint 2013 is a visual and graphical application, primarily used for creating presentations. With PowerPoint, you can create, view, and present slide shows that combine text, shapes, pictures, graphs, animation, charts, videos, and much more.

 

 

This course provides training for the features of Microsoft Office`s Word 2013. Microsoft Word 2013 is a word-processing program, designed to help you create professional-quality documents. With the finest document-formatting tools, Word helps you organize and write your documents more efficiently. Word also includes powerful editing and revising tools so that you can collaborate with others easily.

 

 

This course covers basic, intermediate, and advanced features of Microsoft Office`s Access 2010 software. Access 2010 is a database application design and deployment tool that you can use to keep track of important information. You can keep your data on your computer, or you can publish to the Web — so others can use your database with a web browser.

 

 

This course is training for basic, intermediate, and advanced features of Microsoft Office`s Excel 2010. Excel is a spreadsheet program in the Microsoft Office system. You can use Excel to create and format workbooks (a collection of spreadsheets) in order to analyze data and make more informed business decisions. Specifically, you can use Excel to track data, build models for analyzing data, write formulas to perform calculations on that data, pivot the data in numerous ways, and present data in a variety of professional looking charts.

 

 

This course provides training for basic, intermediate, and advanced features of Microsoft Office`s Outlook 2010. Microsoft Outlook 2010 offers premium business and personal e-mail management tools to more than 500 million Microsoft Office users worldwide. With the release of Outlook 2010, you get a richer set of experiences to meet your communication needs at work, home, and school.

 

 

This course provides training for basic, intermediate, and advanced features of Microsoft Office`s Word 2010. Microsoft Word 2010 is a word-processing program, designed to help you create professional-quality documents. With the finest document-formatting tools, Word helps you organize and write your documents more efficiently. Word also includes powerful editing and revising tools so that you can collaborate with others easily.

 

 

This course provides training for basic, intermediate, and advanced features of Microsoft Office`s PowerPoint 2010. PowerPoint 2010 is a visual and graphical application, primarily used for creating presentations. With PowerPoint, you can create, view, and present slide shows that combine text, shapes, pictures, graphs, animation, charts, videos, and much more.

 

 

This course will provide you with the knowledge and skills to configure and manage a Microsoft SharePoint Server 2013 environment and 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 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.

 

 

Instructor - Patrick Loner

 

 

Instructor - Patrick Loner

 

 

This course will help students prepare for Developing Microsoft Azure and Web Services certification. The 70-487 Certification is intended for developers with 3 to 5 years experience in web services development and a minimum of one year in Web API and Azure Solutions experience. Instructor - Rafiq Wayani

 

 

This course in particular provides the training that can help you prepare for the Microsoft Specialist Exam 70-409: Server Virtualization with Windows Server Hyper-V and System Center. The Microsoft certification path, exam, and course can will prove your ability to deploy and manage a Microsoft Server Virtualization infrastructure in an enterprise environment. You also find out how to configure, manage, and maintain Windows Server 2012 R2 Hyper-V and System Center 2012 R2 Virtual Machine Manager, including networking and storage services. Plus, you learn how to configure key Microsoft Server virtualization features, such as Generation 2 Virtual Machines, Replication Extension, Online Export, Cross-Version Live Migration, Online VHDX Resizing, and Live Migration Performance tuning, in addition to Dynamic Virtual Switch Load Balancing and virtual Receive Side Scaling (vRSS).

 

 

Prepare for Microsoft Exam 70-246 and help demonstrate your real-world mastery of monitoring and operating a private cloud based on Microsoft System Center 2012 R2. Designed for experienced IT professionals ready to advance their status, focuses on the critical-thinking and decision-making acumen needed for success at the MCSE level. Focus on the expertise measured by these objectives: Configure data center process automation Deploy resource monitoring Monitor resources Configure and maintain service management Manage configuration and protection Candidates for this exam have Windows Server, System Center 2012, security, high-availability, fault tolerance, and networking experience in an enterprise environment. Candidates should also have basic Microsoft SQL Server, Windows PowerShell knowledge, and application configuration experience.

 

 

"Prepare for Microsoft Exam 70-247—and help demonstrate your real-world mastery configuring and deploying a private cloud using Microsoft System Center 2012 R2. Designed for experienced IT professionals ready to advance their status, focuses on the critical-thinking and decision-making acumen needed for success at the MCSE level. Focus on the expertise measured by these objectives: Design and deploy System Center Configure System Center infrastructure Configure the fabric Configure System Center integration Configure and deploy virtual machines and services"

 

 

This course is designed to help you learn the basics of navigating the new Windows 10 operating system so that you can be effective and efficient while at work or play. Topics covered include: using file explorer, operating the new Microsoft Edge, using applications, managing and maintaining accounts. Instructor - Patrick Loner

 

 

This course will prepare you for the 70-697 exam from Microsoft. The 70-697 exam validates a candidate’s fundamental knowledge and skills for building solid identities, protection of content (data loss protection), mobile device management policy, virtualization with Hyper-V, application management using the Company Portal and the Windows Store. Candidates will be evaluated on Windows 10 security and integrated Azure features.

In this course you will update your skills in the following areas:
- Manage identity in Windows 10
- Plan Windows 10 desktop and device deployment
- Plan and implement a Microsoft 365 solution
- Configure Windows 10 networking
- Configure Windows 10 storage
- Manage data access and protection
- Manage remote access
- Manage apps
- Manage updates and recovery

This course is intended for Windows device support technicians or Windows Device System Administrators who are responsible for building solid identities, protection of content (data loss protection), mobile device management policy, virtualization with Hyper-V, and application management using the Company Portal or the Microsoft Store. You should already have experience with Windows desktop administration, maintenance, troubleshooting, Windows 10 security, and integrated Azure features. You should also have a basic understanding of Windows networking technologies, Active Directory, and Microsoft Intune.

Note: This course builds on the previous Windows 10 course. It assumes you have already completed the original 70-697 course. You must take both courses to prepare for the exam.

Instructors - Patrick Loner & Chrys Thorsen

 

 

This course is preparation for the Microsoft 70-687 Configuring Windows 8 certification exam. Candidates for this exam are students seeking to be IT professionals who configure or support Windows 8 computers, devices, users, and associated network and security resources. The networks with which these professionals typically work are configured as domain-based or peer-to-peer environments with access to the Internet and cloud services. The IT professional could be a consultant, a full-time desktop support technician, or an IT generalist who administers Windows 8 based computers and devices as a portion of their broader technical responsibilities. Instructor - Patrick Loner

 

 

This course is preparation for the Microsoft 70-688 Exam which is designed for "IT professionals who configure or support Windows 8 computers, devices, users, and associated network and security resources. The networks with which these professionals typically work are configured as domain-based or peer-to-peer environments with access to the Internet and cloud services. The IT professional could be a consultant, a full-time desktop support technician, or an IT generalist who administers Windows 8 based computers and devices as a portion of their broader technical responsibilities."

 

 

This course enables students to learn how to plan and deploy Windows 7 desktops in large organizations . They will also learn how to design, configure, and manage the Windows 7 client environment. Instructor - Patrick Loner

 

 

This course covers the following topics in order to prepare for the exam: Identifying cause of and resolving desktop application issues. Identifying cause of and resolving networking issues. Managing and maintaining systems that run Windows 7 client. Supporting mobile users. Identifying cause of and resolving security issues.

 

 

This course enables students to learn how to plan and deploy Windows 7 desktops in large organizations . They will also learn how to design, configure, and manage the Windows 7 client environment.

 

 

Candidates for this exam are IT consultants and telecommunications consulting professionals who design, plan, deploy, and maintain solutions for unified communications (UC). Candidates should be able to translate business requirements into technical architecture and design for a UC solution. Candidates should have a minimum of two years of experience with Microsoft Lync technologies and be familiar with supported migration scenarios. Candidates should be proficient in deploying Lync Server solutions for end users, endpoint devices, telephony, audio/video and web conferences, security, and high availability. Candidates should also know how to monitor and troubleshoot Lync Server using Microsoft tools. The minimally qualified candidate typically should have experience making decisions concerning the design, implementation, and maintenance of the following: central and branch office sites, standard and enterprise edition deployment, high availability and disaster recovery, remote access\external access, enterprise voice, Unified Messaging, conferencing, Persistent Chat, data compliance, client endpoints, and, migration from previous versions of Lync. This course is a core requirement for the MCSE certification.

 

 

Candidates for this exam are IT consultants and telecommunications consulting professionals who design, plan, deploy, and maintain solutions for unified communications (UC). Candidates should be able to translate business requirements into technical architecture and design for a UC solution. Candidates should have a minimum of two years of experience with Microsoft Lync technologies and be familiar with supported migration scenarios. Candidates should be proficient in deploying Lync Server 2013 solutions for end users, endpoint devices, telephony, audio/video and web conferences, security, and high availability. Candidates should also know how to monitor and troubleshoot Lync Server 2013 using Microsoft tools. In addition, candidates should be proficient with Active Directory Domain Services, data networks, and telecommunications standards and components that support the configuration of Lync Server 2013. Candidates should be familiar with the requirements for integrating Lync Server 2013 with Microsoft Exchange Server and Office 365. This course is a core requirement for the MCSE certification.

 

 

This course is preparation for the 70-642 exam and provides students with the knowledge and skills to configure and troubleshoot Windows Server 2008 and Windows Server 2008 R2 Sp1 Network Infrastructures. It will cover networking technologies most commonly used with Windows Server 2008 and Windows Server 2008 R2 Sp1 such as DNS, DHCP, IPv4 and IPv6 network addressing, Network Policy server and Network Access Protection and configuring secure network access. It also covers fault tolerant storage technologies, Network Storage and routing and remote access, monitoring and compliance updates as well as other relevant technologies

 

 

This course is preparation for the 70-646 and is intended for IT Professionals who are interested in the knowledge and skills necessary to plan and implement a Windows Server 2008 and Windows Server 2008 R2 environment. It incorporates both the planning of the server infrastructure and key aspects of the implementation, management and maintenance of Active Directory and Network Infrastructure. It is the primary training resource for Exam 70-646 preparation (MCITP: Server Administrator certification). It covers the most important job tasks for Server Administrators who are responsible for the planning, operations, and day-to-day maintenance of Windows Server 2008 and Windows Server 2008 R2 servers in the enterprise.

 

 

This course covers the following topics in order to prepare for the exam: Plan and deploy a server infrastructure. Design and implement network infrastructure services. Design and implement network access services. Design and implement an Active Directory infrastructure (logical). Design and implement an Active Directory infrastructure (physical).

 

 

This course covers the following topics in order to prepare for the exam: Manage and maintain a server infrastructure. Plan and implement a highly available enterprise infrastructure. Plan and implement a server virtualization infrastructure. Design and implement identity and access solutions.

 

 

This course prepares you to master the following subjects in order to prepare you for the 70-243 exam: to design and plan System Center Configuration Manager infrastructure, manage Operating System Deployment (OSD), deploy applications and software updates, manage compliance settings, manage sites, manage clients, manage inventory, manage reports, and manage queries.

 

 

This course covers the following topics in order to prepare for the exam: Plan, install, configure, and manage transport, Install, configure, and manage the mailbox role, Plan, install, configure, and manage client access, Design and manage an Exchange infrastructure.

 

 

This course covers the following topics in order to prepare for the exam: Configure, manage, and migrate Unified Messaging. Design, configure, and manage site resiliency. Design, configure, and manage advanced security. Configure and manage compliance, archiving, and discovery solutions. Implement and manage coexistence, hybrid scenarios, migration, and federation.

 

 

This course is preparation for the 70-640 exam. This exam covers the following topics: Configuring Domain Name System (DNS) for Active Directory, Configuring the Active Directory infrastructure, Configuring Active Directory roles and services, Creating and maintaining Active Directory objects, Maintaining the Active Directory environment, Configuring Active Directory Certificate Services.