Microsoft 70-461: Querying SQL Server 2012

4k learners

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.

  • 1-year e-learning access

  • Course completion certificate

  • 100% money-back guarantee

Online Self Learning $49 ($69) Enroll Now
Live Online Training -- Get Quote
Traditional Classroom -- Get Quote

Group Training

Looking for a personalized training for a group (3 or more participants) at your preferred location?
Contact us

Course Overview

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.

Course Outline

Course Introduction Part1
Course Introduction Part2
Course Modules
Introduction to SQL Server 2012 Part1
Introduction to SQL Server 2012 Part2
Introduction to SQL Server 2012 Part3
SQL Instances Part1
SQL Instances Part2
SQL Instances Part3
Editions and Licensing Part1
Editions and Licensing Part2
SQL Server Objects
System Databases
SQL Server Data Tools
Object Explorer Part1
Object Explorer Part2
Object Scripting Part1
Object Scripting Part2
Template Explorer Part1
Template Explorer Part2
Query Tabs Part1
Query Tabs Part2
Projects and Solutions Part1
Projects and Solutions Part2
Customizing SSDT Part1
Customizing SSDT Part2
Debugging T-SQL Part1
Debugging T-SQL Part2
SQLCMD Part1
SQLCMD Part2
Exam Scenarios
Module Review
T-SQL Overview Part1
T-SQL Overview Part2
T-SQL Overview Part3
T-SQL Elements Part1
T-SQL Elements Part2
Batch Separators Part1
Batch Separators Part2
Line Terminator Part1
Line Terminator Part2
Variables Part1
Variables Part2
Control Flow Part1
Control Flow Part2
Expressions Part1
Expressions Part2
Functions Part1
Functions Part2
Predicates and Operators Part1
Predicates and Operators Part2
Predicates and Operators Part3
SELECT Part1
SELECT Part2
SELECT Part3
Column Aliasing Part1
Column Aliasing Part2
SELECT Execution Part1
SELECT Execution Part2
Exam Scenarios
Module Review
SELECT Statements Part1
SELECT Statements Part2
Basic SELECT Statement Part1
Basic SELECT Statement Part2
Specifying Columns Part1
Specifying Columns Part2
Derived Columns Part1
Derived Columns Part2
Aliasing Columns Part1
Aliasing Columns Part2
Calculated Columns Part1
Calculated Columns Part2
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 Part1
Subqueries Part2
Self Contained Subquery
Correlated Subquery
Subquery Demo
EXISTS Part1
EXISTS Part2
EXISTS Part3
Common Table Expressions Part2
Common Table Expressions Part1
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 Part1
Logical Function Demo Part2
Using Views Part1
Using Views Part2
Stored Procedures
Functions
Triggers
Views Demo Part1
Views Demo Part2
Views Demo Part3
TRY CATCH Part1
TRY CATCH Part2
Exam Scenarios
Module Review
Transactions
Introduction to Transactions Part1
Introduction to Transactions Part2
INSERT and UPDATE
DELETE and TRUNCATE
Transactions Demo Part1
Transactions Demo Part2
Transactions Demo Part3
Managing Transactions Part1
Managing Transactions Part2
XACT_ABORT
Managing Transactions Demo Part1
Managing Transactions Demo Part2
Exam Scenarios
Module Review
Query Performance
Indexing Part1
Indexing Part2
Indexing Part3
Index Strategies
Indexes Demo Part1
Indexes Demo Part2
Execution Plans part1
Execution Plans Part2
Statistics IO
Execution Plans Demo part1
Execution Plans Demo part2
Exam Scenarios
Module Review
Program Review

CALL

Call us

CHAT

Live chat

CONTACT

Contact us
500 +

Expert Instructors

100 +

PROFESSIONAL Courses

150000 +

Professionals Trained

Got queries?

Acknowledgements