MCSA Package

What’s in the course package?

Microsoft Certified Solution Associate (MCSA): SQL Server 2012
70-461: Querying Microsoft SQL Server 2012

Creating Database Objects
Querying Basics and Modifying Data
Manipulate Data Using Operators and Functions
Creating Functions and Triggers
Creating Programming Objects and Optimizing Queries
Managing XML Data
Mentoring 70-461 Querying Microsoft SQL Server 2012
TestPrep 70-461 Querying Microsoft SQL Server 2012

70-462: Administering Microsoft SQL Server 2012 Databases

Installation and Upgrade
Instance Configuration and Database Creation
Managing Databases and Automating Tasks
Security Management
Managing Database Data
Managing Indexes, Full-Text Search and Partitions
Backing Up and Restoring Databases
Database Monitoring and Performance Tuning
Configuring High Availability
Mentoring 70-462 Administering Microsoft SQL Server 2012 Databases
TestPrep 70-462 Administering Microsoft SQL Server 2012 Databases

70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012

Design and Deployment
Create Basic Packages
ETL Solutions
Enhancing Packages
Custom Components
Implementing a Data Warehouse: Installing SSIS
Implementing a Data Warehouse: Troubleshooting
Implementing a Data Warehouse: DQS and MDS Solutions
Implementing a Data Warehouse with Microsoft SQL Server 2012
TestPrep 70-463 Implementing a Data Warehouse with Microsoft SQL Server 2012

Microsoft Certified Solutions Associate (MCSA): Windows Server 2012

70-410: Installing and Configuring Windows Server 2012

Mentoring 70-410 Installing and Configuring Windows Server 2012
TestPrep 70-410 Installing and Configuring Windows Server 2012
Installing and Configuring: Getting Started
Installing and Configuring: Storage Management
Installing and Configuring: Shares & Permissions
Installing and Configuring: Storage and Printing
Installing and Configuring: Hyper-V
Installing and Configuring: Virtualisation
Installing and Configuring: IPv4, CIDR, and IPv6
Installing and Configuring: DHCP Configuration
Installing and Configuring: DNS Configuration
Installing and Configuring: Active Directory
Installing and Configuring: AD Configuration
Installing and Configuring: AD Accounts & Groups
Installing and Configuring: Group Policies
Installing and Configuring: Security

70-411: Administering Windows Server 2012

Mentoring 70-411 Administering Windows Server 2012
TestPrep 70-411 Administering Windows Server 2012
Administering: WDS and Monitoring
Administering: WSUS
Administering: DFS and FSRM
Administering: BitLocker, EFS, and Auditing
Administering: DNS
Administering: RADIUS, NPS, and NAP
Administering: Service Accounts
Administering: WDC, FSMO and Virtual DC Cloning
Administering: RODC and Password Policies
Administering: Backup and Recovery
Administering: Policies and Templates
Administering: GPO Manipulation and Processing

70-412: Configuring Advanced Windows Server 2012 Services

Configuring Advanced Services: NLB & Clustering
Configuring Advanced Services: VM Clusters & DR
Configuring Advanced Services: Storage
Configuring Advanced Services: Forests & Domains
Configuring Advanced Services: File Management and DAC
Configuring Advanced Services: DHCP, DNS, & IPAM
Configuring Advanced Services: Site Replication
Configuring Advanced Services: PKI
Configuring Advanced Services: RMS & Federation
Mentoring 70-412 Configuring Advanced Windows Server 2012 Services
TestPrep 70-412 Configuring Advanced Windows Server 2012 Services

Microsoft Certified Solutions Associate (MCSA): Windows 8

70-687: Configuring Windows 8

Getting Started with Windows 8
Installation Components
User Accounts and Policies
Configuring User Applications
Accessing User Data
Sharing and Securing User Data
Devices and Disks
Networking Configuration and Security
Optimisation and Performance
System Management and Recovery
Mentoring 70-687 Configuring Windows 8.1
TestPrep 70-687 Configuring Windows 8

70-688: Managing and Maintaining Windows 8

Cloud Applications and Settings
Installation and Applications
Networking and Remote Access
Data Storage and Security
Hardware and Mobile Devices
Recovery and Endpoint Security
Windows Intune
Using MDOP
Mentoring 70-688 Supporting Windows 8.1
TestPrep 70-688 Supporting Windows 8.1

Facts:

Course Access Period: 3 months

Course Delivery: Online

Requirements: PC or MAC

Prospective Job Titles:

Average Salary*:

* As at June 2014. Source: ITjobswatch.com

Click here for a course brochure – MCSA Package