Voice Search
Voice Search

MCSA SQL Server 2012 (Live Labs Included)


Rated 9.3 out of 10 based on over 6784 reviews

Free course advice
Learn more about how we use your data

What is the MCSA SQL Server 2012 (Live Labs Included) course?

This course will allow you to develop the skills needed to become a fully qualified SQL Server 2012 Database Administrator.

By completing this course students will not only fully understand the concepts behind Microsoft SQL Server 2012, but also develop the skills needed to properly manage, maintain and manipulate a database in a real-world environment.

Available delivery methods for this course




Group booking

Group booking

Key features of the course

  • Delivery Method: Online
  • Tutor Support Available
  • Course Access: 12 months
  • Practice Labs Included
  • Study anytime, anywhere
  • 24/7 access
MCSA SQL Server 2012 (Live Labs Included)
£150 ex. VAT

Fully understand the concepts and develop the skills needed to manage, maintain and manipulate a database using Microsoft SQL Server 2012.

We offer monthly finance with 0% interest – view options on the checkout page. All prices inclusive of VAT

Is the MCSA SQL Server 2012 (Live Labs Included) online course right for me?

Are you looking to upgrade your skillset with an understanding of key server and database management fundamentals?

This Microsoft course will be best suited for you as well as administrators, system engineers and developers.

What job could I get with a MCSA SQL Server 2012 (Live Labs Included) qualification? ­­

Individuals who have studied the MCSA SQL server 2012 course have gone on to fulfil exciting career prospects in the following.

• Database Administrator
• Database Analyst
• SQL Developer

Why study MCSA SQL Server 2012 (Live Labs Included) Online Course with e-Careers?

Web-accessible course materials allow students to follow the course at their own pace, in their own time. The MCSA SQL Server 2012 course provides:

  • All the training and resources needed to prepare for the MCSA SQL Server 2012 exam.
  • Develop real-world skills to back up database theory.
  • Improve knowledge, skills and employment prospects with Microsoft-approved course materials.
  • Install, configure and maintain SQL Server 2012 for optimum performance and reliability.
  • Master the techniques required to query and manipulate data using T-SQL.
  • Construct, deploy and manage an advanced SQL Server 2012 data warehouse.

The MCSA SQL Server 2012 course is essential for IT professionals who want to improve their database management skills, or gain the knowledge and experience required to pass their MCSA exam.

What are the MCSA SQL Server 2012 (Live Labs Included) online course modules?

Microsoft 70-461: Querying SQL Server 2012

  • Getting Started with SQL Server 2012
  • Working with T-SQL
  • Writing SELECT Queries
  • Working with SQL Data Types
  • Sorting and Filtering Data
  • Querying Data from Multiple Tables
  • Modifying Data
  • Working with SQL Server Built-in Functions
  • Programming in T-SQL
  • Implementing Stored Procedures
  • Working with Subqueries and Table Expressions
  • Working with Set Operators, Conditional Operators, and Window Functions
  • Working with PIVOT, UNPIVOT, and Grouping Sets
  • Managing Error Handling and Transactions
  • Querying SQL Server System
  • Optimizing Query Performance

Microsoft 70-462: Administering SQL Server 2012 Databases

  • Identifying the SQL Server Platform
  • Deploying SQL Server
  • Configuring SQL Server
  • Managing Databases in SQL Server 2012
  • Managing SQL Server Security
  • Implementing Advanced Security Settings
  • Applying Encryption and Compression
  • Working with Indexes and Log Files
  • Working with Backup and Restore
  • Implementing High Availability
  • Optimizing Server Performance
  • Troubleshooting Issues and Recovering Databases
  • Performing Advanced Database Management Tasks

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

  • Introduction to Data Warehouse
  • Creating Dimensions and Changing Granularity of Dimensions
  • Creating Fact Tables and Column Store Indexes
  • Implementing Data Warehouse in SQL Server 2012
  • Working with Integration Services
  • Managing Control Flow
  • Working with Dynamic Variables
  • Implementing Data Flow
  • Managing Data Flow
  • Managing SSIS Package Execution
  • Debugging and Troubleshooting
  • Deploying Packages
  • Securing Packages and Databases
  • Working with MDS and Windows

MCSA SQL Server 2012 (Live Labs Included) Exams

Upon completion of this intensive hands-on course, students will be ready to sit the exams required to achieve the MCSA qualification.

By completing these three modules, students will have the knowledge and skills required to sit and pass the three associated exams required to earn the Microsoft MCSA SQL Server 2012 qualification.

What does the MCSA SQL Server 2012 (Live Labs Included) course cover?

The MCSA SQL Server 2012 qualification is built around three exams, and this course is tailored to help students understand the concepts and techniques required to pass them all.

Training begins with the fundamental techniques needed to access, manipulate and transform data stored in SQL Server 2012. You will master:

  • The Transact-SQL (T-SQL) language, and how to build efficient queries, stored procedures and views that return key information quickly.
  • How to combine datasets, rank results and extend tables programmatically.
  • Optimise T-SQL statements for the most efficient operation.
  • Extend reporting and data transfer capabilities using XML.

Moving on, the course will then introduce trainees to the technology behind Microsoft SQL Server 2012. By practicing deployment and configuration of the database server, students will:

  • Appreciate the correct way to install and use add-on components, instances and services.
  • Build systems for high availability environments using AlwaysOn, mirroring and replication to keep data online always.
  • How to protect information from loss using database backup, restore and disaster recovery (DR) techniques.
  • Securing database contents by configuring permissions, alerts, logins, roles and more.
  • Practical troubleshooting, maintenance and optimisation techniques will ensure that trainees can deliver performance and reliability improvements for real-world deployments.

The final section of the course allows students to go deeper with Microsoft SQL Server 2012 by learning about enterprise deployment scenarios, like the building of Business Intelligence (BI) solutions:

  • Advanced data management concepts like data cleansing techniques and Extract Transform Load (ETL) package development and scheduling will keep information accurate, and improve data management, transfer and synchronisation for enterprise-class system design.
  • How to automate and simplify database management by using SSIS to manage package execution, task execution and scripts.
  • How best to maintain server health by using auditing, logging and event handling to assess and troubleshoot potential problems.

We will do more than simply providing access to course material, we enhance your user experience by using practice labs. This allows students to develop their practical skills with access to dedicated live equipment.

We’re trusted by

Individuals, small businesses and large corporations who have used e-Careers since 2001. Here are some names you’ll recognise:

Saatchi & Saatchi
American Express

Do you know someone who’d love this course? Tell them about it...