MCSA Package

Course Brochure Pic - MCSA Server 2012

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