Microsoft Certified Solutions Associate(MCSA) Microsoft SQL Server 2012/2014


comp name

Microsoft's SQL Server is playing a major role in DB World, MS SQL Server Certification will qualify you for a position as Database Developer and or Database Administrator. You will earn a skills in the areas of querying, administering and implementing Data warehouse with MS SQL Server by completing the certifications.

To Earn MCSA SQL Server 2012/2014 Certification, Candidates should pass the below three exams.



Exam 70-461 : Querying Microsoft SQL Server 2012/2014


Exam Details

Required Exam(s) 70-461
Durations 120 Minutes (40 - 60 Questions)
Question Types Multiple choice, drag and drop, Fill in the blanks and simulation types.
Exam Fees Each Exam Rs.4800(Approx)
Exam Policy Click here to read the Exam policies.
Recommended Training Querying Microsoft SQL Server 2012/2014

Exam Pattern

Below are the exam objectives of Exam 70-461 : Querying Microsoft SQL Server 2012/2014

This exam will measure your skills and knowledge in the following areas and you must score necessary % in all areas.

1.0 Create database objects (20–25%)
  • 1.1 Create and alter tables using T-SQL syntax (simple statements)
  • 1.2 Create and alter views (simple statements)
  • 1.3 Design views
  • 1.4 Create and modify constraints (simple statements)
  • 1.5 Create and alter DML triggers
2.0 Work with data (25–30%)
  • 2.1 Query data by using SELECT statements
  • 2.2 Implement sub-queries
  • 2.3 Implement data types
  • 2.4 Implement aggregate queries
  • 2.5 Query and manage XML data
3.0 Modify data (20–25%)
  • 3.1 Create and alter stored procedures (simple statements)
  • 3.2 Modify data by using INSERT, UPDATE and DELETE statements
  • 3.3 Combine datasets
  • 3.4 Work with functions
4.0 Troubleshoot and optimise (25–30%)
  • 4.1 Optimise queries
  • 4.2 Manage transactions
  • 4.3 Evaluate the use of row-based operations vs. set-based operations
  • 4.4 Implement error handling

Books to Prepare

Below are the recommended books for preparing Exam 70-461 : Querying Microsoft SQL Server 2012/2014

SQl Cover Image

Book Name : (Exam 70-461) Querying Microsoft SQL Server 2012 (MCSA)

Author Name : Dejan Sarka, Itzik Ben-Gan, Ron Talmage

Publisher : Microsoft Press

Topics Covered in this book:

  • Chapter 1 : Foundations of Querying
  • Chapter 2 : Getting Started with the SELECT Statement
  • Chapter 3 : Filtering and Sorting Data
  • Chapter 4 : Combining Sets
  • Chapter 5 : Grouping and Windowing
  • Chapter 6 : Querying Full-Text Data
  • Chapter 7 : Querying and Managing XML Data
  • Chapter 8 : Creating Tables and Enforcing Data Integrity
  • Chapter 9 : Designing and Creating Views, Inline Functions, and Synonyms
  • Chapter 10 : Inserting, Updating, and Deleting Data
  • Chapter 11 : Other Data Modification Aspects
  • Chapter 12 : Implementing Transactions, Error Handling, and Dynamic SQL
  • Chapter 13 : Designing and Implementing T-SQL Routines
  • Chapter 14 : Using Tools to Analyze Query Performance
  • Chapter 15 : Implementing Indexes and Statistics
  • Chapter 16 : Understanding Cursors, Sets, and Temporary Tables
  • Chapter 17 : Understanding Further Optimization Aspects

Softwares for Practice

You can practice your exams by using below tools

Software Name : Microsoft SQL Server

License : Evaluation

Click here for trail download


If you want to practice the topics coverd in the books by sample DB, download the TSQL2012.sql script and install and start SQL Management studio and run the script.After completion of the script, database TSQL2012 will be listed there and you can pratice with that. Click Below link to download TSQL2012.sql script.

Click here to download the script

Also You can pratice some basics with Microsoft's free Sql server Editions.

Software : MS SQL Server 2012 Express Edition and Management Studio

License : Free

Click here to download the free copy of SQL server Express Editions




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


Exam Details

Required Exam(s) 70-462
Durations 120 Minutes (40 - 60 Questions)
Question Types Multiple choice, drag and drop, Fill in the blanks and simulation types.
Exam Fees Each Exam Rs.4800(Approx)
Exam Policy Click here to read the Exam policies.
Recommended Training Administering Microsoft SQL Server 2012/2014 Databases

Exam Pattern

Below are the exam objectives of Exam 70-462 : Administering Microsoft SQL Server 2012/2014 Databases
Install and configure (20–25%)
  • Plan installation
  • Install SQL Server and related services
  • Implement a migration strategy
  • Configure additional SQL Server components
  • Manage SQL Server Agent
Maintain instances and databases (15–20%)
  • Manage and configure databases
  • Configure SQL Server instances
  • Implement a SQL Server clustered instance
  • Manage SQL Server instances
Optimize and troubleshoot (15–20%)
  • Identify and resolve concurrency problems
  • Collect and analyze troubleshooting data
  • Audit SQL Server instances
Manage data (20–25%)
  • Configure and maintain a back-up strategy
  • Restore databases
  • Implement and maintain indexes
  • Import and export data
Implement security (15–20%)
  • Manage logins and server roles
  • Manage database security
  • Manage users and database roles
  • Troubleshoot security
Implement high availability (5–10%)
  • Implement AlwaysOn
  • Implement replication

Books to Prepare

Below are the recommended books for preparing Exam 70-462 : Administering Microsoft SQL Server 2012/2014 Databases

Mcsa win 12 Cover Image

Book Name : (Exam 70-462) Administering Microsoft SQL Server 2012 Databases (MCSA)

Author Name : Orin Thomas, Peter Ward, Bob Taylor

Publisher : Microsoft Press

Topics Covered in this book:

  • Chapter 1 Planning and Installing SQL Server 2012
  • Chapter 2 Configuring and Managing SQL Server Instances
  • Chapter 3 Configuring SQL Server 2012 Components
  • Chapter 4 Migrating, Importing, and Exporting
  • Chapter 5 SQL Server Logins, Roles, and Users
  • Chapter 6 Securing SQL Server 2012
  • Chapter 7 Mirroring and Replication
  • Chapter 8 Clustering and AlwaysOn
  • Chapter 9 Troubleshooting SQL Server 2012
  • Chapter 10 Indexes and Concurrency
  • Chapter 11 SQL Server Agent, Backup, and Restore
  • Chapter 12 Code Case Studies

Softwares for Practice

You can practice your exams by using below tools

Software Name : Microsoft SQL Server

License : Evaluation

Click here for trail download


If you want to practice the topics coverd in the books by sample DB, download the TSQL2012.sql script and install and start SQL Management studio and run the script.After completion of the script, database TSQL2012 will be listed there and you can pratice with that. Click Below link to download TSQL2012.sql script.

Click here to download the script

Also You can pratice some basics with Microsoft's free Sql server Editions.

Software : MS SQL Server 2012 Express Edition and Management Studio

License : Free

Click here to download the free copy of SQL server Express Editions




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


Exam Details

Required Exam(s) 70-463
Durations 120 Minutes (40 - 60 Questions)
Question Types Multiple choice, drag and drop, Fill in the blanks and simulation types.
Exam Fees Each Exam Rs.4800(Approx)
Exam Policy Click here to read the Exam policies.
Recommended Training Implementing a Data Warehouse with Microsoft SQL Server 2012/2014

Exam Pattern

Below are the exam objectives of Exam 70-463 : Implementing a Data Warehouse with Microsoft SQL Server 2012/2014

In this exam you will be tested on following areas and you have to score necessary % in all areas.

1.0 Design and implement a data warehouse (10–15%)
  • 1.1 Design and implement dimensions
  • 1.2 Design and implement fact tables
2.0 Extract and transform data (20–25%)
  • 2.1 Define connection managers
  • 2.2 Design data flow
  • 2.3 Implement data flow
  • 2.4 Manage SSIS package execution
  • Implement script tasks in SSIS
3.0 Load data (25–30%)
  • 3.1 Troubleshoot data integration issues
  • 3.2 Install and maintain SSIS components
  • 3.3 Implement auditing, logging and event handling
  • 3.4 Deploy SSIS solutions
  • 3.5 Configure SSIS security settings
4.0 Configure and deploy SSIS solutions (20–25%)
  • 4.1 Configure and maintain a backup strategy
  • 4.2 Restore databases
  • 4.3 Implement and maintain indexes
  • 4.4 Import and export data
5.0 Build data quality solutions (15–20%)
  • 5.1 Install and maintain data quality services
  • 5.2 Implement master data management solutions
  • 5.3 Create a data quality project to clean data

Books to Prepare

Below are the recommended books for preparing Exam 70-463 : Implementing a Data Warehouse with Microsoft SQL Server 2012/2014

Mcsa win 12 Cover Image

Book Name : Training Kit (Exam 70-463): Implementing a Data Warehouse with Microsoft SQL Server 2012

Author Name : Dejan Sarka, Matija Lah, Grega Jerkic

Publisher : Microsoft Press

Topics Covered in this book:

  • Chapter 1 Data Warehouse Logical Design
  • Chapter 2 Implementing a Data Warehouse
  • Chapter 3 Creating SSIS Packages
  • Chapter 4 Designing and Implementing Control Flow
  • Chapter 5 Designing and Implementing Data Flow
  • Chapter 6 Enhancing Control Flow
  • Chapter 7 Enhancing Data Flow
  • Chapter 8 Creating a Robust and Restartable Package
  • Chapter 9 Implementing Dynamic Packages
  • Chapter 10 Auditing and Logging
  • Chapter 11 Installing SSIS and Deploying Packages
  • Chapter 12 Executing and Securing Packages
  • Chapter 13 Troubleshooting and Performance Tuning
  • Chapter 14 Installing and Maintaining Data Quality Services
  • Chapter 15 Implementing Master Data Services
  • Chapter 16 Managing Master Data
  • Chapter 17 Creating a Data Quality Project to Clean Data
  • Chapter 18 SSIS and Data Mining
  • Chapter 19 Implementing Custom Code in SSIS Packages
  • Chapter 20 Identity Mapping and De-Duplicating

Softwares for Practice

You can practice your exams by using below tools

Software Name : Microsoft SQL Server

License : Evaluation

Click here for trail download


If you want to practice the topics coverd in the books by sample DB, download the TSQL2012.sql script and install and start SQL Management studio and run the script.After completion of the script, database TSQL2012 will be listed there and you can pratice with that. Click Below link to download TSQL2012.sql script.

Click here to download the script

Also You can pratice some basics with Microsoft's free Sql server Editions.

Software : MS SQL Server 2012 Express Edition and Management Studio

License : Free

Click here to download the free copy of SQL server Express Editions