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

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

$279.99

Buy Now

Related Courses

All Course