• My account
  • Cart
English courses / EUR

MCSA: Administering Microsoft SQL 2012 (Exam 70-462)

Regular Price: 558€

Special Price: 333€

  • 2 students have purchased
  • Express
My Training Academy
Potters Bar
Maple House High Street, Potters Bar Hertfordshire United Kingdom, EN6 5BS EN6 5BS See in Google maps
OUR MISSION: Our mission is to help you learn the skills you need to reach your full potential. WHO WE ARE: We are one of the fastest growing online training providers. We offer engaging, effective and flexible online training solutions to both individuals and businesses. We develop courses that help individuals to prepare for and complete their certification exams with ease. Our unique, flexible approach to learning means you don’t have to put your life on hold to get certified. You can study full time and part time, from home and work and on the move; online and on mobile devices. We provide world class education developed by highly skilled and experienced instructors. Our courses are upgraded regularly to ensure our learners are up-to-date with the latest industry requirements and best practices. WHAT WE BELIEVE We believe technology has paved the way for individuals and businesses all over the world to tap into high quality learning at their fingertips.


  • Advanced online learning platform
  • Make your own study schedule and take advantage of online tutoring hours
  • Obtain a certified diploma once you finish the course.


Employers worldwide are searching for IT professionals with validated skills. With a Microsoft certification in hand, you'll certainly stand out from the crowd. Microsoft SQL Server 2012 is the one of the latest versions of Microsoft SQL Server, the extremely popular and widely used database system in the world. My Training Academy's Administering Microsoft SQL Server 2012 Databases course introduces you to building and using databases in this platform.

The course provides students with the technical skills required to perform installation, maintenance, and configuration tasks in Microsoft SQL Server 2012. It also teaches them how to set up database systems, make sure the systems operate efficiently, and regularly store, back up, and secure data from unauthorized access. This course will help current and aspiring data professionals to prepare for exam 70-462, known as Administering Microsoft SQL Server 2012 Databases. Once certified, you'll be qualified for jobs such as Database Developer and Database Analyst, earning an average salary of about £42,500.00 per year.

The great thing about our MCSA: Administering Microsoft SQL 2012 Course is that you are in charge of your start and finish date, with no deadline pressures!

We train our students to the very best standards, offering expert instructor-led training via our state of the art eLearning platform.

By achieving the MCSA: Administering Microsoft SQL 2012 certification, you will create more career opportunities and be better positioned when applying for work.

Enrol today and prepare for a future you deserve.WHY STUDY WITH MY TRAINING ACADEMY?

Flexible training- study anytime, anywhere and from any device.
Expert Instructor-Led TrainingÐ our courses are delivered by the finest instructors with a minimum of 15 years real-world experience and are subject matter experts in their field, which is why we have a 97.4% pass rate.
Visual Demonstrations &...

Module 1
Introduction to SQL Server 2012
SQL Instances
Editions and Licensing
SQL Server Objects
System Databases
SQL Server Data Tools
Object Explorer
Object Scripting
Template Explorer
Query Tabs
Projects and Solutions
Customizing SSDT
Debugging T-SQL
Exam Scenarios
Module ReviewModule 2
T-SQL Overview
T-SQL Elements
Batch Separators
Line Terminator
Control Flow
Predicates and Operators
Column Aliasing
SELECT Execution
Exam Scenarios
Module ReviewModule 3
SELECT Statements
Basic SELECT Statement
Specifying Columns
Derived Columns
Aliasing Columns
Calculated Columns
Ordering Results
Returning Distinct Results
Exam Scenarios
Module ReviewModule 4
WHERE Syntax
Filtering NULL Values
Data Type Comparison
Filtering Data with WHERE
Exam Scenarios
Module ReviewModule 5
Join and Set Operators
Using Joins
Categories of Joins
Set Operators
Set Operators Demo
Exam Scenarios
Module ReviewModule 6
Subqueries and Table Expressions
Self-Contained Subquery
Correlated Subquery
Subquery Demo
Common Table Expressions
Temporary Tables
Table Variables
Table Demo
Exam Scenarios
Module ReviewENTRY REQUIREMENTSThe MCSA: Administering Microsoft SQL 2012 Course is intended for SQL Administrators who administer and maintain SQL Server databases are best suited for this certification training. Other responsibilities include setting up database systems, making sure those systems operate efficiently, and regularly storing, backing up, and securing data from unauthorized access.MULTI-USER TRAINING PACKAGESThis online course can be integrated in your professional training plan. M.T.A. 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.


Thanks to this offer, valid exclusively for one person, you will obtain a MCSA: Administering Microsoft SQL 2012 (Exam 70-462) Online Course.

How to register

By buying the course in Emagister Express, you will obtain an access coupon. We will send you the codes and keys to the coupon. Send the coupon code and the key to info@mytrainingacademy.org.uk. The training provider will then give you access to the course.

This course has not been reviewed yet
Hi! According to your location, we have changed your payment currency to EUR.
You can change to other currency by using the option on the header.