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

Any questions?
Check out the FAQs

Still have unanswered questions and need to get in touch?

Contact Us Now

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

$279.99

Buy Now

Related Courses

All Courses
We use cookies for improving site experience and analytics. Learn More