Microsoft

Querying Microsoft SQL Server 2012/2014 (70-461)

(70-461-v2) / ISBN : 978-1-64459-034-8
Lessons
Lab
TestPrep
AI Tutor (Add-on)
104 Reviews
Get A Free Trial

Skills You’ll Get

The Querying Microsoft SQL Server 70-461 exam is a part of the MCSA SQL Server 2012 certification. The MCSA SQL Server 70-461 exam validates a candidate's 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. The MCSA 70-461is intended for SQL Server database administrators, system engineers, and developers with two or more years of experience.
Download Course Outline

1

Introduction

  • About SQL Server 2012/2014
  • About Transact-SQL (T-SQL)
2

Managing Tables and Views

  • Creating Tables
  • Modifying Existing Tables
  • Understanding Indexes
  • Understanding Views
  • Partitioning Tables and Indexes
  • Summary
3

Creating Constraints and Triggers

  • Creating and Modifying Constraints
  • Understanding Triggers
  • Modifying Triggers
  • Summary
4

Working with Data

  • Using SELECT Statements
  • Implementing Subqueries
  • Implementing Data Types
  • Implementing Aggregate Queries
  • Managing XML Data
  • Summary
5

Modifying Data

  • Understanding Stored Procedures
  • Using DML Statements
  • Combining Datasets
  • Working with Functions
  • Summary
6

Troubleshooting and Optimizing Queries

  • Tuning and Optimizing Queries
  • Managing Transactions
  • Evaluating Operations
  • Implementing Error Handling
  • Summary
A

Appendix A

  • Installing Microsoft SQL Server 2014 Management Studio
  • Connecting to the Server
B

Appendix B

  • 70-461 Exam Objectives

1

Managing Tables and Views

  • 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
2

Creating Constraints and Triggers

  • Creating a Primary Key Constraint
  • Creating a Foreign Key Constraint
  • Creating a Unique Constraint
  • Dropping a Constraint
  • Creating a DML Trigger
  • Creating a DDL Trigger
  • Using INSTEAD OF Trigger
3

Working with Data

  • Using Logical Operators
  • Using the SELECT statement
  • Retrieving Specific Columns
  • Using Calculated Columns
  • Limiting Rows
  • Using the LIKE Operator
  • Using the BETWEEN Clause
  • Using the PIVOT Operator
  • Using Appropriate Data Types
  • Using Subqueries
  • Using the Analytic Function
  • Working with Ranking Functions
  • Using the XML Data Type
4

Modifying Data

  • 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
5

Troubleshooting and Optimizing Queries

  • Displaying the Estimated Execution Plan
  • Using SET STATISTICS IO
  • Using the DECLARE and SET statements
  • Using the BEGIN, COMMIT, and ROLLBACK TRANSACTION Statements
  • Evaluating Operations
  • Implementing Error Handling

Why Do Learners Love This Course?

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.

Christian Udeochu
Christian Udeochu
Cloud Data Architect

Any questions?
Check out the FAQs

Still have unanswered questions and need to get in touch?

Contact Us Now

There are no technical prerequisites for this certification.

USD 165

Pearson VUE

The exam contains 40-60 questions.

120 minutes

The passing score varies from exam to exam and is provided on the score report.

General Microsoft Certification exam retake policy

  • If a candidate does not achieve a passing score on an exam the first time, the candidate must wait 24 hours before retaking the exam. At that time, candidates can log onto their certification dashboard and reschedule the exam themselves.
  • If a candidate does not achieve a passing score the second time, the candidate must wait at least 14 days before retaking the exam a third time.
  • A 14-day waiting period is also imposed between the third and fourth attempts and fourth and fifth attempts.
  • A candidate may not take a given exam any more than five times per year (12 months). This 12-month period starts from the first attempt. The candidate is eligible to retake the exam 12 months from the date of their first attempt.
  • To take a given exam more than five times per year or to have the time between attempts waived, a candidate must have experienced one of the errors listed below and request an exception from Microsoft. Requests should be sent to mlsecure@microsoft.com. These requests must include the following information:
    • Candidate ID
    • First/Last Name
    • Email associated with your Candidate ID
    • Exam Registration ID
    • Exam Number
    • Description of error
    • Pearson VUE case number

Exam retake exceptions will be granted for the following reasons:

  • Failure due to lab crash
  • Failure due to Internet connectivity issues
  • Failure due to equipment failure

For life

Know more about the 70-461

Related Courses

All Course