Microsoft 70-461: Querying SQL Server 2012

This course is intended for SQL Server database administrators, implementers, system engineers, and developers. This new SQL 2012 course is focused on anyone interested in the validation of your skills and knowledge with writing queries.

Request a quote Review training schedules

Learn more about the course below.

TRAINING SCHEDULES

Microsoft 70-461: Querying SQL Server 2012 Training program course overview

This course provides the knowledge and understanding for some of these important job functions:

  • Apply built-in scalar functions
  • Apply ranking functions
  • Combine datasets
  • Creates and alters
  • Design T-SQL stored procedures, views
  • Implementing aggregate queries, error handling, sequence generation and data types
  • Manage transactions
  • Modify data by using INSERT, UPDATE, DELETE and MERGE statements
  • Optimizing queries
  • Query data using SELECT statements and Managing XML data
  • OUTPUT clause to return data

This learning course provides the knowledge for the 70-461 Exam on Queries on Microsoft SQL Server 2012:

  • Create Database Objects
  • Create and alter tables using T-SQL syntax (simple statements).
  • Create and alter views (simple statements).
  • Design views.
  • Create and modify constraints (simple statements).
  • Create and alter DML triggers.
  • Work with Data
  • Query data by using SELECT statements.
  • Implement sub-queries.
  • Implement data types.
  • Implement aggregate queries.
  • Query and manage XML data.
  • Modify Data
  • Create and alter stored procedures (simple statements).
  • Modify data by using INSERT, UPDATE, and DELETE statements.
  • Combine datasets.
  • Work with functions.
  • Troubleshoot & Optimize
  • Optimize queries.
  • Manage transactions.
  • Evaluate the use of row-based operations vs. set-based operations.
  • Implement error handling.
  • We create the highest quality course curriculum possible, ensuring you receive the training and knowledge needed to succeed.

The registration process

Once you have completed our simplified enrolment process, you’ll receive an email confirmation with your payment receipt in your registered email ID. Yoau can then access the entire content of the online student portal immediately by logging in to your account on our site. Should you require any assistance please reach out to us via email (support@greycampus.com) or via our online chat system.

The course curriculum

The curriculum for this Microsoft 70-461: Querying SQL Server 2012 training incorporates all updates The following is a list of broad topics covered

  • Course Introduction Part1 (1:25)
  • Course Introduction Part2 (0:40)
  • Course Modules (1:54)
  • Introduction to SQL Server 2012
  • SQL Instances
  • Editions and Licensing
  • SQL Server Objects
  • System Databases
  • SQL Server Data Tools
  • Object Explorer
  • Object Scripting
  • Template Explorer
  • Query Tabs
  • Projects and Solutions
  • Customizing SSDT
  • Debugging T-SQL
  • SQLCMD
  • Exam Scenarios
  • Module Review
  • T-SQL Overview
  • T-SQL Elements
  • Batch Separators
  • Line Terminator
  • Variables Part
  • Control Flow Part
  • Expressions Part
  • Functions Part
  • Predicates and Operators
  • SELECT
  • Column Aliasing
  • SELECT Execution
  • Exam Scenarios
  • Module Review
  • SELECT Statements
  • Basic SELECT Statement
  • Specifying Columns
  • Derived Columns
  • Aliasing Columns
  • Calculated Columns
  • Ordering Results Part1
  • Ordering Results Part2
  • Ordering Results Part3
  • Ordering Results Part4
  • Returning Distinct Results Part1
  • Returning Distinct Results Part2
  • Exam Scenarios
  • Module Review
  • Filtering Part1
  • Filtering Part2
  • WHERE Syntax Part1
  • WHERE Syntax Part2
  • BETWEEN
  • WHERE Syntax IN
  • Filtering NULL Values
  • LIKE
  • Data Type Comparison
  • Filtering Data with WHERE Part1
  • Filtering Data with WHERE Part2
  • Filtering Data with WHERE Part3
  • TOP Part1
  • TOP Part2
  • OFFSET-FETCH Part1
  • OFFSET-FETCH Part2
  • Exam Scenarios
  • Module Review
  • Join and Set Operators
  • Using Joins Part1
  • Using Joins Part2
  • Categories of Joins
  • INNER JOIN
  • OUTER JOIN
  • JOIN Demo
  • Set Operators Part1
  • Set Operators Part2
  • Set Operators Part3
  • Set Operators Part4
  • Set Operators Demo
  • Exam Scenarios
  • Module Review
  • Subqueries and Table Expressions
  • Subqueries Part2
  • Self Contained Subquery
  • Correlated Subquery
  • Subquery Demo
  • EXISTS Part1
  • EXISTS Part2
  • EXISTS Part3
  • Common Table Expressions Part1
  • Common Table Expressions Part2
  • Temporary Tables
  • Table Variables
  • Table Demo
  • Exam Scenarios
  • Module Review
  • System Functions Part1
  • System Functions Part2
  • Scalar Functions
  • ROWSET
  • System Function Demo
  • Aggregate Functions Part1
  • Aggregate Functions Part2
  • DISTINCT
  • Aggregation Demo
  • GROUP BY Part1
  • GROUP BY Part2
  • HAVING Part1
  • HAVING Part2
  • Conversion Functions Part1
  • Conversion Functions Part2
  • Conversion Functions Part3
  • Conversion Functions Part4
  • Exam Scenarios
  • Module Review
  • T-SQL Programming
  • Logical Functions Part1
  • Logical Functions Part2
  • IIF, CHOOSE and CASE
  • Logical Function Demo Using Views
  • Stored Procedures
  • Functions
  • Triggers
  • Views Demo
  • TRY CATCH
  • Exam Scenarios
  • Module Review
  • Transactions
  • Introduction to Transactions
  • INSERT and UPDATE
  • DELETE and TRUNCATE
  • Transactions Demo
  • Managing Transactions
  • XACT_ABORT
  • Managing Transactions Demo
  • Exam Scenarios
  • Module Review
  • Query Performance
  • Indexing
  • Index Strategies
  • Indexes Demo
  • Execution Plans
  • Statistics IO
  • Execution Plans Demo
  • Exam Scenarios
  • Module Review
  • Program Review