merger merger

Welcome to your new course portal!

On October 15th, hotcourses.com moved to findcourses.co.uk - which means you can now find all your favourite courses right here. Don't worry - you can still do all the things that you could do before.

All you need to do is search.

Show findcourses.co.uk as: Mobile

MCSA SQL Server 2012 (Microsoft Certified Solutions Associate including Exam Vouchers)

ITonlinelearning Ltd
Course summary
1 year
775 GBP
English
Distance
Next available date: Start anytime! - Distance
e-learning / Online / Distance

MCSA SQL Server 2012 (Microsoft Certified Solutions Associate including Exam Vouchers)

MCSA SQL Server 2012 (Microsoft Certified Solutions Associate including Exam Vouchers)

MCSA SQL Server 2012 (Microsoft Certified Solutions Associate including Exam Vouchers)

Includes all 3 Microsoft exam vouchers

Get the in-demand MCSA SQL Server 2012 Certification (SQL 2012) on your CV.

Who is the MCSA suited to?

The MCSA SQL Server 2012 study package is suited to IT professionals who want to benefit by having the latest SQL 2012 skills and be at the forefront of new technologies.

Choose this certification is you want to validate and learn the primary foundational skills needed to Install, Configure and Administer a Microsoft SQL Server 2012 environment.

Try the training for free

You can try the courses first with a free trial to make sure the MCSA is suited to your current experience level. You can explore the courses and get an exact idea of how the training is delivered.

Description

The MCSA consists of the following 3 exam courses:

  • Microsoft 70-461: Querying SQL Server 2012
  • Microsoft 70-462: Administering SQL Server 2012 Databases
  • Microsoft 70-463: Implementing a Data Warehouse with SQL Server 2012

Once you have completed all 3 exams, you will have earned the Microsoft Certified Solutions Associate (MCSA): SQL Server 2012 certification.

Get Practical Experience

As a bolt-on option, we offer Live Labs so you can practice on real live servers, routers and switches from wherever you are studying. You have unlimited access to the Labs for 1 year and can practice freely or follow set exercises that mirror the exam courses. Live Labs are highly effective and offer a cheaper alternative to setting up your own test environment.

Need Help?

Our friendly Advisors can answer any questions you have.

Career path

  • IT Support
  • IT Manager
  • Helpdesk Analyst
  • Server Administrator
  • Server Manager
  • Network Administrator
  • Network Engineer

Suitability - Who should attend?

The study package can be tailored to meet your exact study requirements and prepare you with lower level courses.

Please contact the course advisors at Itonlinelearning to find out if this programme is suitable for you.

Training Course Content

Microsoft Exam 70-461: Querying Microsoft SQL Server 2012

Instructor Introduction
Course Outline
Module 1: Introduction to SQL Server 2012
Module 2: T-SQL Overview
Module 3: SELECT Statements
Module 4: Filtering
Module 5: Join and Set Operators
Module 6: Subqueries and Table Expressions
Module 7: System Functions
Module 8: T-SQL Programming
Module 9: Transactions
Module 10: Query Performance

Microsoft Exam 70-462: Administering Microsoft SQL Server 2012 Databases

Instructor Introduction
Course Outline
Module 1: Introduction to SQL Server 2012
Module 2: Installing SQL Server
Module 3: Backup and Restore a Database
Module 4: Tracing Access to SQL Server
Module 5: Importing and Exporting Data
Module 6: SQL Server Security
Module 7: Automating SQL Server
Module 8: Monitoring SQL Server
Module 9: Maintaining SQL Server
Module 10: Troubleshooting SQL Server

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

Instructor Introduction
Course Outline
Module 1: Introduction to Data Warehousing
Module 2: Designing a Data Warehouse
Module 3: ETL with SSIS
Module 4: SSIS Control Flow
Module 5: Troubleshooting Packages
Module 6: Advanced Packages
Module 7: Data Quality Services
Module 8: Master Data Services
Module 9: Deployment and Security

Expenses

The total cost of this training course is £775 per user. Flexible monthly payment plans are available.

Multi-user Training Packages

This online course can be integrated into your professional training plan. ITonlinelearning can provide you with a tailored learning solution, that can be customised to meet each team member’s requirements. Choosing a multi-user training package, you can get significant discounts for 5+ users and even further discounts for 10+ users – and an excellent return on your investment.

Provider: ITonlinelearning Ltd

ITonlinelearning Ltd is a distance e-learning training provider that offers Project Managers and IT Professionals high-level self-study training and certification products at affordable prices. With their easy interest-free monthly payments option, the financial strain of investing in your education is...


Read more and show all courses with this provider

Customer Outreach Award

customer-outreach-badge-2019

We believe that it should be easy for you to find and compare training courses. 

Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.

Contact information for ITonlinelearning Ltd

ITonlinelearning Ltd

Suite 7, The Oast, Sittingbourne
ME10 4HE Kent

 Show phone number

Reviews by course attendees

Arnie Wright
(5)
Liz and the team at ITonlinelearning have provided excellent customer service. Liz has enthusiastically supported my through my studies. One exam behind me with 2 more to go. I have recommended you to my Manager and the rest of the team.
Reviews
Course rating
(5.0)
Based on 1 reviews
U.K. L&D Report: 2019 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in findcourses.co.uk's second annual U.K. L&D Report!

uk-ld-report-2019

Learn more