MCSA/MCSE - Querying Microsoft SQL Server 2012/2014

Gain hands-on expertise in Microsoft 70-461 certification exam by MCSA/MCSE - Querying Microsoft SQL Server 2012 course and live-lab. The live-lab is a real computer equipment, networked together, and conveniently accessible over the Internet using virtualization. The course and live-lab cover all the objectives of Microsoft 70-461 exam and include topics such as creating database objects; working and modifying data; troubleshooting and optimizing queries and transactions.

Here's what you will get

The Querying Microsoft SQL Server 2012 exam is a part of MCSA SQL Server 2012 certification. The 70-461 exam is a required part of the certification. This exam covers 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. You have to pass Administering Microsoft SQL Server 2012 Databases and Implementing a Data Warehouse with SQL Server 2012 exams along with MCSA/MCSE Querying Microsoft SQL Server 2012 exam to achieve MCSA SQL Server 2012 certification.

Lessons
Lessons
8+
Quizzes
50+
Flashcards
50+
Glossary of terms
50+
Test prep
Pre-assessment Questions
50+
Full Length Tests
2+
Post-Assessment Questions
50+
Lab
Performance lab
Learn the real world skills using Live Labs.
43+
Exam 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, '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.
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
  • Helpdesk Technicians
  • Systems Administrators
  • Technical Support Engineers

Here's what you will learn

  • 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
  • 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 SET STATISTICS IO
  • Using DECLARE and SET statement
  • Using BEGIN, COMMIT, and ROLLBACK TRANSACTION statements
  • Evaluating Operations
  • Implementing Error Handling
70-461-v2_pro 70-461-v2_pro
70-461-v2
MCSA/MCSE - Querying Microsoft SQL Server 2012/2014
ISBN : 9781644590348
Rating :
(16)