Scroll to top button

MCSA/MCSE - Querying Microsoft SQL Server 2012/2014

ISBN : 9781644590348

Start your prep for the Microsoft MCSA 70-461 certification exam with the MCSA/MCSE - Querying Microsoft SQL Server 2012/2014 course and lab. Lab delivers a hands-on experience replacing expensive physical labs. The course and lab completely cover the MCSA 70-461 exam objectives and provide an understanding on topics such as creating database objects; working and modifying data; troubleshooting and optimizing queries and transactions, and more.

The Querying Microsoft SQL Server 2012 exam is a part of the MCSA SQL Server 2012 certification. The MCSA 70-461 exam is a required part of the certification. The MCSA 70-461 exam validates expertise in creating and altering tables using T-SQL syntax, querying and managing XML data, modifying data by using INSERT, UPDATE and DELETE commands, and so on.

Glossary of terms
Pre Assessment Questions
Post Assessment Questions
Performance lab
Learn the real world skills using LiveLab.
Exam related FAQs
What are the prerequisites for this exam? There are no technical prerequisites for this certification.
What is the exam registration fee? USD 165
Where do I take the exam?

The 70-461 is administered by Prometric and Pearson VUE at testing centers worldwide.

  • For Pearson VUE: Click here to find a testing center near you.
  • For Prometric: Click here to find a testing center near you.
How many questions are asked in the exam? The exam contains 40-60 questions.
What is the duration of the exam? 120 minutes
What is the passing score? 700
What is the exam's retake policy?

In the event that you fail your first attempt at passing the 70-461 examination, Microsoft's retake policy is:

  • If a candidate fails in first attempt, he need to wait for 24 hours to retake the exam.
  • If he fails in second, third, and subsequent attempts, he need to wait for 14 days before re-scheduling the exam.
  • If you have already passed the exam, it cannot be taken again.
What is the validity of the certification? The Microsoft's MCSA/MCSE SQL Server 2012 does not expire. The certification holder is certified for life unless the vendor changes its policy. Click here for more information.
Where can I find more information about this exam? To know more about the 70-461-v2, click here.
Which certification covers this exam?
What are the career opportunities after passing this exam?

The Microsoft's MCSA/MCSE SQL Server 2012 certified professional has several career opportunities open up to them, including:

  • Systems Analysts
  • Systems Engineers
  • Desktop Technicians
  • Help Desk Technicians
  • Systems Administrators
  • Technical Support Engineers
  • About SQL Server 2012/2014
  • About Transact-SQL (T-SQL)
  • Creating Tables
  • Modifying Existing Tables
  • Understanding Indexes
  • Understanding Views
  • Summary
  • Creating and Modifying Constraints
  • Understanding Triggers
  • Modifying Triggers
  • Summary
  • Using SELECT Statements
  • Implementing Subqueries
  • Implementing Data Types
  • Implementing Aggregate Queries
  • Managing XML Data
  • Summary
  • Understanding Stored Procedures
  • Using DML Statements
  • Combining Datasets
  • Working with Functions
  • Summary
  • Tuning and Optimizing Queries
  • Managing Transactions
  • Evaluating Operations
  • Implementing Error Handling
  • Summary
  • Installing Microsoft SQL Server 2014 Management Studio
  • Connecting to the Server
  • 70-461 Exam Objectives

Hands on Activities (Labs)

  • Creating a Table
  • Adding a New Column in a Table
  • Deleting a Column from a Table
  • Deleting a table
  • Modifying a column in a table
  • Creating a Clustered Index
  • Creating a Non-Clustered Index
  • Deleting an Index
  • Creating a Filtered Index
  • Creating an Indexed View
  • Creating a View
  • Creating Primary Key Constraints
  • Creating Foreign Key Constraints
  • Creating a Unique Constraint
  • Dropping a Constraint
  • Create a DML Trigger
  • Creating a DDL Trigger
  • Using INSTEAD OF Trigger
  • Using Logical Operators
  • Using the SELECT statement
  • Retrieving Specific Columns
  • Using Calculated Columns
  • Limiting Rows
  • Using the LIKE Operator
  • Using the BETWEEN Clause
  • Using PIVOT Operator
  • Use Appropriate Data Types
  • Using Subqueries
  • Using Analytic Functions
  • Work with Ranking Functions
  • Using XML Data Type
  • Creating a Stored Procedure
  • Adding New Data
  • Updating a Record in a Table
  • Removing a Record from the Table
  • Combining Data Sets
  • Using User-Defined Functions
  • Displaying Estimated Execution Plan
  • Using DECLARE and SET statement
  • Evaluating Operations
  • Implementing Error Handling

Customer Testimonials

Christian Udeochu
The 70-461 exam study guide covers all the objectives of 70-461 exam and includes topics such as creating database objects; working and modifying data; troubleshooting and optimizing queries and transactions. I strongly recommend taking this training as it exposes you to even more information than needed to succeed in a data related position.