Cart Subtotal: $0.00

Welcome Student!

Microsoft 70-461: Querying SQL Server 2012

Click on image to zoom

Be the first to review this product

SKU# 174032

Availability: In stock

$399.00

$99.00

Secure shopping trustmarks

Quick Overview

Microsoft 70-461: Querying SQL Server 2012

QuickCert Exam Pass Guarantee

QuickCert’s online IT training programs are guaranteed to get you certified – or we will pay for your make-up exam. Our quality online IT courseware, packed with instruction, exercises, practice exams and test simulators will ensure you pass the exam. Learn more.

Course Description

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.

    Syllabus

    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

    Instructor Bio

    David Dye

    Reviews
    Write Your Own Review

    You're reviewing: Microsoft 70-461: Querying SQL Server 2012

    •  
      1 star
      2 stars
      3 stars
      4 stars
      5 stars
      Price
      Value
      Quality

    * Required Fields

    Free Demo