GET IN THE LEAD - get certified today! Experience the benefits of classroom learning - anytime, anywhere! QuickCert's expert instruction and multi-media courses are to get you certified - or your money back! Read why successful professionals choose QuickCert >

 

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

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 from QuickCert 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.

QuickCert creates the highest quality course curriculum possible, ensuring you receive the training and knowledge needed to succeed.  QuickCert is so certain this course meets and exceeds the exam objectives, we guarantee you will pass your exam!

Not sure what course is right for you?
Contact one of our Career Advisors at 888.840.2378 for assistance.

Your QuickCert Microsoft Exam 70-461: Querying Microsoft SQL Server 2012 Certification
Training Package Includes:

Delivery Format	Instructor Led Modules	Hardbook Supplement	Practice Exam Simulator	Exam Pass Guarantee
DVDs or online

Exam Pass Guarantee - Learn More

Free Product Upgrades

Toll Free Educational Support

Compatibility with:
98 | 2000 | ME | XP | 2003| Vista | Windows 7 | Windows 8

 

Hear What Our Customers Are Saying...

“I’m 100% satisfied with QuickCert’s training program. I love that it’s broken into manageable sections.   This is an all-inclusive training solution… they give you the manuals, the lectures broken into short segments, and practice tests that really mirror the actual tests I’ve taken. I plan to renew my membership!!”

— Karen S., Network Administrator, Calabasas, California

Questions?  Contact one of our Career Advisors at 888.840.2378 for assistance or email sales@quickcert.com.

Microsoft Exam 70-461: Querying Microsoft SQL Server 2012 Certification Training Course Curriculum:

Instructor Introduction
Course Outline

Module 1

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

Module 2

T-SQL Overview
T-SQL Elements
Batch Separators
Line Terminator
Variables
Control Flow
Expressions
Functions
Predicates and Operators
SELECT
Column Aliasing
SELECT Execution
Exam Scenarios
Module Review

Module 3

SELECT Statements
Basic SELECT Statement
Specifying Columns
Derived Columns
Aliasing Columns
Calculated Columns
Ordering Results
Returning Distinct Results
Exam Scenarios
Module Review

Module 4

Filtering
WHERE Syntax
BETWEEN
WHERE Syntax IN
Filtering NULL Values
LIKE
Data Type Comparison
Filtering Data with WHERE
TOP
OFFSET-FETCH
Exam Scenarios
Module Review

Module 5

Join and Set Operators
Using Joins
Categories of Joins
INNER JOIN
OUTER JOIN
JOIN Demo
Set Operators
Set Operators Demo
Exam Scenarios
Module Review

Module 6

Subqueries and Table Expressions
Subqueries
Self Contained Subquery
Correlated Subquery
Subquery Demo
EXISTS
Common Table Expressions
Temporary Tables
Table Variables
Table Demo
Exam Scenarios
Module Review

Module 7

System Functions
Scalar Functions
ROWSET
System Function Demo
Aggregate Functions
DISTINCT
Aggregation Demo
GROUP BY
HAVING
Conversion Functions
Exam Scenarios
Module Review

Module 8

T-SQL Programming
Logical Functions
IIF, CHOOSE and CASE
Logical Function Demo
Using Views
Stored Procedures
Functions
Triggers
Views Demo
TRY CATCH
Exam Scenarios
Module Review

Module 9

Transactions
Introduction to Transactions
INSERT and UPDATE
DELETE and TRUNCATE
Transactions Demo
Managing Transactions
XACT_ABORT
Managing Transactions Demo
Exam Scenarios
Module Review

Module 10

Query Performance
Indexing
Index Strategies
Indexes Demo
Execution Plans
Statistics IO
Execution Plans Demo
Exam Scenarios
Module Review
Program Review

Questions?  Contact one of our Career Advisors at 888.840.2378 for assistance or email sales@quickcert.com.

Free Demo