MCSA Windows Server 2016 Exam 70-740, 70-741, 70-742 Certification Training Course on 2 DVDs

Courses : 3 (MCSA Windows Server 2016 Exam 70-740, 70-741, 70-742)
Overall duration : 20 Hours
Video Lessons : 264
DVDs : 2

Installation, Storage, and Compute with Windows Server 2016 - Exam 70-740 Certification Training 
Preparing for the Microsoft Certified Solutions Associate (MCSA) 70-740 Certification Exam

Duration: 8 hours 53 minutes

Ready to earn your MCSA certification for Windows Server 2016? This is part one of a three part series, and in this video you'll learn how to pass Microsoft exam 70-740, the first of three exams you must pass to earn the MCSA Windows Server 2016 certification. This course covers information regarding the installation, storage, and compute features and functionality available in Windows Server 2016 - all of the material covered in the 70-740 exam.
Take in everything you need to know to pass Microsoft exam 70-740
Get one step closer to earning your MCSA Windows Server 2016 certification
Discover how to install the operating system; and how to choose and deploy configuration levels
Learn the distinctions between server with desktop experience, server core, and nano server
Understand how to install and manage Hyper-V
Explore new storage capabilities like storage basis direct and storage rep
Learn about virtualization and containers
Become comfortable with the skill sets required to use Windows Server 2016

Networking with Windows Server 2016 - Exam 70-741 Certification Training 
Preparing for the Microsoft Certified Solutions Associate (MCSA) 70-741 Certification Exam

Release Date: August 2017
Duration: 5 hours 10 minutes

The Microsoft 70-741 exam is one of three tests that must be passed to earn the MCSA 2016 certification. This course provides instruction on the networking knowledge you need to pass the 70-741. While this is a MCSA test preparation course, it's also useful for anyone wanting a better understanding of the networking capabilities of Windows Server 2016. Topics include IPv4, IPv6, DNS, DHCP, IPAM, network virtualization, remote connectivity technologies, and branch office network solutions. Each topic starts with an overview of the technology before moving on to how it can be deployed and used. The course is designed for IT administrators, operators, or architects with basic knowledge of Windows Server 2016 setup and administration

Gain the network knowledge needed to pass the Microsoft 70-741 exam
Get closer to the goal of becoming a Microsoft Certified Solutions Associate
Master the ability to use and configure IPv4 and IPv6
Learn how software defined networking functions and how it's used in Windows Server 2016
Understand how to design solutions for branch office networking
Discover how to manage IP services with IP address management

Windows Server 70-742 Identity with Windows Server 2016 Exam 70-742 Certification Training 
Preparing for the Microsoft Certified Solutions Associate (MCSA) 70-742 Certification Exam
Duration: 6 hours 03 minutes

This course examines the key identity technologies in Windows Server 2016, including Active Directory, Group Policy, Certificate Services, Federation, and Rights Management. Identity is the cornerstone of security, and this course provides the key skills to architect and implement identity using Windows Server 2016. We explore the technologies and how solutions can be architected and managed. By the end of this course, you'll be able to take advantage of all the key identity technologies in Windows Server 2016 and be one step closer to the Windows Server 2016 MCSA.

Learn to architect an Active Directory solution
How to protect data using Azure Information Protection
How to deploy configuration using Group Policy
How to utilize internal certificate services
Provides critical skills as part of MCSA Windows Server 2016 preparation
Enables management of Active Directory and Group Policy

Buy This Course DVD Now @

​

                                

Identity with Windows Server 2016 MCSA Exam 70-742 Certification Video Training Course DVD

Duration : 6 Hours

Table of Contents

Introduction
Welcome to the Course 00:00:35

Active Directory Domain Services
Active Directory Overview 00:09:19
Understanding Forests and Trees 00:04:21
Installing Active Directory Domain Services 00:04:37
Creating a new Domain in a new Forest 00:05:17
Adding and removing Domain Controllers 00:04:26
Installing a DC on Server Core 00:02:51
Installing a DC from Media  00:05:06
Domain Trust Types and Advanced Trust Configuration 00:08:08
Multi-Forest Environment Management 00:01:51
Domain and Forest Levels 00:05:41
Global Catalogs 00:06:54
Using Read-Only Domain Controllers 00:07:37
Understanding Flexible Single Master Operations (FSMO) Roles 00:05:46
Managing FSMO Roles 00:04:53
Configure UPN Suffixes 00:02:28

Domain Controller and Site Management
Upgrading Domain Controllers 00:01:50
Upgrading Domains 00:08:24
Active Directory Site Introduction 00:07:16
Creating Active Directory Sites and Site Links 00:08:41
View DNS Service Records 00:05:13
Configure DNS Site Coverage 00:02:19
Domain Controllers in Azure 00:04:08
Move Domain Controllers Between Sites 00:01:53
Domain Controller Cloning 00:04:11
NTDS Management and Metadata Cleanup 00:08:03
Backing Up Active Directory 00:04:07
Performing Active Directory Restoration 00:03:11
Using Active Directory Snapshots 00:05:37

Active Directory Object Management
Active Directory Object Types 00:04:04
Creating Active Directory Users 00:04:36
Creating Active Directory Computers and Joining a Domain 00:04:54
Managing User and Computer Objects with Graphical Tools 00:02:45
Managing User and Computer Objects with PowerShell 00:07:55
Using Organizational Units 00:08:25
Active Directory Group Types 00:02:39
Managing Active Directory Groups 00:06:42
Managing Active Directory Groups with Group Policy 00:02:39
Using Virtual Accounts 00:01:22
Using the Active Direcotry Recycle Bin 00:03:11
Privileged Access Management Overview 00:02:53

Active Directory Policies
Active Directory Policies 00:02:32
Managed Service Accounts and Group Managed Service Accounts 00:05:28
Configure Kerberos Constrained Delegation 00:03:44
Manage Service Principal Names 00:03:37
Configure Password Policy Settings 00:04:49
Use Password Settings Objects 00:04:46
Configure Account Policies 00:02:02

Group Policy
Group Policy 00:13:48
Using Group Policy WMI Filters  00:02:43
Implementing Group Policy Preferences and Item-Level Targeting 00:03:12
Configuring Group Policy Slow Link Processing Options  00:03:04
Creating Custom Administrative Templates  00:01:53
Convert ADM Files to ADMX Files 00:00:35
Configure Software Installation, Folder Redirection and Scripts 00:04:07
Configure Group Policy Caching  00:02:22
Forcing Group Policy update 00:03:29
Backing up and restoring GPOs 00:02:12
Delegate Group Policy Management 00:01:56
Troubleshooting Group Policy Applications and Common Causes of Problems  00:04:42
Using Advanced Group Policy Management (AGPM) 00:03:20

Active Directory Certificate Services
Overview of Public Key Infrastructure (PKI) 00:12:52
Installing ADCS 00:09:07
Configuring Enterprise Certificate Authority (CA) 00:08:29
Implementing Automatic Certificate Deployment and Renewal 00:01:56
Implementing Key Archival and Recovery Processes 00:04:05
Designing Separation of Roles with ADCS 00:02:10

Active Directory Federation Services
The need for ADFS and how it works 00:06:39
Installing ADFS 00:04:43
Configuring ADFS 00:03:59
Integrating ADFS with Cloud Services 00:02:20
Integration with Azure Active Directory 00:02:42
Updating Certificates with Azure AD Connect 00:01:45

Web Application Proxy
WAP Overview 00:06:02
Deploying WAP 00:03:01
Publish Apps with WAP 00:01:59
Publish Remote Desktop Gateway with WAP 00:04:32
Active Directory Rights Management Services
Ways to Protect Data 00:03:09
Active Directory RMS and Azure RMS 00:05:17
Using Microsoft Rights Management Connector and RMS 00:06:02

Conclusion
Wrap Up and Thank You 00:00:40

Buy This Course DVD Now @

​

    

Networking with Windows Server 2016 - MCSA Exam 70-741 Certification Video Training Course DVD

Duration: 5 hours 10 minutes

Table of Contents

Chapter: Introduction
Welcome To The Course
Chapter: IPv4 And IPv6
IP Overview
IPv4 Addresses And MAC Address
IPv4 Address Structure
Classes Of IPv4 Addresses
IPv4 Traffic Routing With Subnets And Gateways
Special Types Of IPv4 Address
Customizing Routing Of IP
Configuring IP Addresses
Tools To Manage IP
IPv6 Overview
IPv6 Addresses
IPv6 Protocol Translation
IPv6 Interface ID Explained
Chapter: DHCP
Overview Of DHCP
Deploying DHCP
Using DHCP Reservations
Enabling DHCP High Availability
Configuring DHCP Options
Managing DHCP
Chapter: DNS
Overview Of DNS
Installing DNS
Types Of DNS Zone And Replication
Types Of DNS Resource Records
Configuring Global Names DNS Zone
Configuring DNS Zone Delegation
Deploying DNSSEC
Using DNS Policies
Configuring DNS Server Properties
Chapter: IP Address Management
Overview And Goals Of IPAM
IPAM Installation
Using RBAC With IPAM
Chapter: Network Access
Overview Of Remote Access Requirements
Web Application Proxy Overview
Deploying Web Application Proxy
Using Network Policy Server
VPN Overview
Installing VPN Server
Using Connection Manager Administration Kit
Overview Of DirectAccess
Installing DirectAccess
Chapter: Software Defined Networking
SDN Overview
SDNv1 With Windows Server 2012 And 2012 R2
SDNv2 In Windows Server 2016
Utilizing The SLB
Deploying SDNv2
Network Security Groups Overview
Chapter: Advanced Network Functions
Overview And Deploying NIC Teaming
Deploying Switch Embedded Teaming
Using Network Acceleration Technologies
Using SMB
Chapter: DFS And BranchCache
DFS Review
Understanding DFS-R
Deploying DFS-R
BranchCache Overview
Implementing BranchCache
Chapter: Conclusion
Wrap Up And Thank You

Buy This Course DVD Now @

​

   

Querying Data with Transact-SQL - Certification Exam 70-761 Video Training Course DVD

Querying Data with Transact-SQL - Exam 70-761 Certification Training Course

Prepare to take the Microsoft 70-761 exam and work towards your MCSA: SQL 2016 Database Development Certification

Duration: 6 hours 47 minutes

Chapter: Introduction
 Welcome To The Course 
Course Overview 
Understanding Transact-SQL 
SQL Server 2016 Certifications 
Examples And Code 

Chapter: Understanding Databases
What Is A Database? 08m 7s
Database Structure And Purpose
Database Terminology
Understanding Data Types
Statement Types

Chapter: Getting And Installing SQL Server 2016
 SQL Server 2016 Editions
Getting SQL Server 2016
Installing SQL Server 2016
Installing SQL Server Management Studio
Attaching The Sample Database

Chapter: Basic Select Statements
 Basic Select Structure
Using The Where Clause
Column Aliasing
Using Distinct
Ordering Results
T-SQL Concatenation
Multipart Naming

Chapter: Advanced Select Statements
Like And In
Union
Intersect And Except
Paging Results
Understanding Case Expressions Part - 1
Understanding Case Expressions Part - 2
Using Pivot Part - 1
Using Pivot Part - 2

Chapter: Querying Multiple Tables
 Database Structure
Table Relationships
Using The Join Statement
Table Aliasing
Join Types
Join Types Examples

Chapter: Grouping Data
 Using Built-In Functions
Understanding Group By
Understanding Having
Understanding Grouping Sets
Using The Graphical Query Tool

Chapter: Modifying Data
 Inserting Data
Insert Demo
Insert Select
Select Into
Updating Data
Update Demo
Deleting Data
Delete Demo

Chapter: Programming Objects With T-SQL
 Understanding Stored Procs
Stored Procedure Demo
Using Input Parameters
Using Output Parameters
Understanding Table Variables
Understanding CTEs Part - 1
Understanding CTEs Part - 2
Understanding Masking
Masking Demo

Chapter: User-Defined Functions
 Function Basics
Understanding Scalar Functions
Table-Valued Functions

Chapter: Understanding Subqueries
 Subquery Basics
Scalar Subqueries
Multi-Valued Subqueries
Correlated Subqueries
Chapter: Conclusion

Wrap Up

Buy This Course DVD Now @

​

 

Developing SQL Databases MCSA Certification Exam 70-762 Video Training Course DVD

Developing SQL Databases - Exam 70-762 Certification

Prepare to Take the Microsoft 70-762 Exam and Work Towards Your MCSA: SQL 2016 Database Development Certification

Duration: 8 hours 39 minutes

Chapter: Introduction
Welcome To The Course
Course Overview
Microsoft's SQL Server
SQL Server 2016 Certifications
Examples And Code

Chapter: SQL Server Basics
SQL Server Platform
SQL Server Editions
Understanding Databases
Database Structures
Transact-SQL

Chapter: Getting And Installing SQL Server 2016
 Getting SQL Server 2016
Installing SQL Server 2016
Installing SQL Server Management Studio
Attaching The Sample Database
Verifying The Installation

Chapter: Table Design And Implementation
 Creating The Database
Database Options
Understanding Tables
SQL Server Data Types
Choosing A Data Type
What Is Normalization?
Understanding Relationships
Schemas
Table Design Basics
Creating Tables Using T-SQL
Creating Tables Graphically
Using Identity Columns Part - 1
Using Identity Columns Part - 2
Altering Tables Part - 1
Altering Tables Part - 2

Chapter: Advanced Table Design
 Understanding Data Integrity
Constraints
Primary And Foreign Keys
Adding Constraints Part - 1
Adding Constraints Part - 2
Understanding Filegroups
Table Partitions
Temporal Tables
Working With Temporal Tables Part - 1
Working With Temporal Tables Part - 2
In-Memory Tables Part - 1
In-Memory Tables Part - 2
Generating Scripts

Chapter: Indexes
 Index Basics
Clustered Or Nonclustered Part - 1
Clustered Or Nonclustered Part - 2
Covered Indexes
Creating Indexes
Columnstore Indexes
Managing Indexes
Rebuilding And Reorganizing

Chapter: Views
View Basics
Creating A View
Updateable Views
Indexed Views

Chapter: Transactions
 Understanding Transactions Part - 1
Understanding Transactions Part - 2
Transaction Log
Using Explicit Transactions
Savepoints Part - 1
Savepoints Part - 2

Chapter: Stored Procedures
Stored Procedure Basics
Creating Stored Procedures
Using Input Parameters
Using Output Parameters
Table-Valued Parameters Part - 1
Table-Valued Parameters Part - 2
Return Status Part - 1
Return Status Part - 2
Natively Compiled Stored Procs

Chapter: Triggers
 Understanding Triggers
Instead Of Triggers
After Triggers
Inserted And Deleted Tables

Chapter: User-Defined Functions
Understanding Functions
Scalar Functions
Table-Valued Functions

Chapter: Conclusion
 Wrap Up

Buy This Course DVD Now @

​