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:
- MCSA
- Systems Administrator
- 2nd Line Support Technician
Average Salary*:
* As at June 2014. Source: ITjobswatch.com
Click here for a course brochure – MCSA Package