Querying Microsoft SQL Server 2012

Course ID

16010

Course Description

Ace your preparation for Microsoft Certification Exam 70-461 with this training course. Maximize your performance on the exam by learning how to:
  • Create database objects
  • Work with data
  • Modify data
  • Troubleshoot and optimize queries

Prerequisites

None

Audience

This course is intended for SQL Server database administrators, system engineers, and developers with two or more years of experience, who are seeking to validate their skills and knowledge in writing queries.

Course Content

    Foundations of Querying
  • Before You Begin
  • Understanding the Foundations of T-SQL
  • Understanding Logical Query Processing
  • Case Scenarios
  • Suggested Practices
  • Answers

    Getting Started with the SELECT Statement
  • Using the FROM and SELECT Clauses
  • Working with Data Types and Built-in Functions
  • Case Scenarios
  • Suggested Practices
  • Answers

    Filtering and Sorting Data
  • Filtering Data with Predicates
  • Sorting Data
  • Filtering Data with TOP and OFFSET-FETCH
  • Case Scenarios
  • Suggested Practices
  • Answers

    Combining Sets
  • Using Joins
  • Using Subqueries, Table Expressions, and the APPLY Operator
  • Using Set Operators
  • Case Scenarios
  • Suggested Practices
  • Answers

    Grouping and Windowing
  • Writing Grouped Queries
  • Pivoting and Unpivoting Data
  • Using Window Functions
  • Case Scenarios
  • Suggested Practices
  • Answers

    Querying Full-Text Data
  • Creating Full-Text Catalogs and Indexes
  • Using the CONTAINS and FREETEXT Predicates
  • Using the Full-Text and Semantic Search Table-Valued Functions
  • Case Scenarios
  • Suggested Practices
  • Answers

    Querying and Managing XML Data
  • Returning Results As XML with FOR XML
  • Querying XML Data with XQuery
  • Using the XML Data Type
  • Case Scenarios
  • Suggested Practices
  • Answers

    Creating Tables and Enforcing Data Integrity
  • Creating and Altering Tables
  • Enforcing Data Integrity
  • Case Scenarios
  • Suggested Practices
  • Answers

    Designing and Creating Views, Inline Functions, and Synonyms
  • Designing and Implementing Views and Inline Functions
  • Using Synonyms
  • Case Scenarios
  • Suggested Practices
  • Answers

    Inserting, Updating, and Deleting Data
  • Before You Begin
  • Inserting Data
  • Updating Data
  • Deleting Data
  • Case Scenarios
  • Suggested Practices
  • Answers

    Other Data Modification Aspects
  • Using the Sequence Object and IDENTITY Column Property
  • Merging Data
  • Using the OUTPUT Option
  • Case Scenarios
  • Suggested Practices
  • Answers

    Implementing Transactions, Error Handling, and Dynamic SQL
  • Managing Transactions and Concurrency
  • Implementing Error Handling
  • Using Dynamic SQL
  • Case Scenarios
  • Suggested Practices
  • Answers

    Designing and Implementing T-SQL Routines
  • Designing and Implementing Stored Procedures
  • Implementing Triggers
  • Implementing User-Defined Functions
  • Case Scenarios
  • Suggested Practices
  • Answers

    Using Tools to Analyze Query Performance
  • Getting Started with Query Optimization
  • Using SET Session Options and Analyzing Query Plans
  • Using Dynamic Management Objects
  • Case Scenarios
  • Suggested Practices
  • Answers

    Implementing Indexes and Statistics
  • Implementing Indexes
  • Using Search Arguments
  • Understanding Statistics
  • Case Scenarios
  • Suggested Practices
  • Answers

    Understanding Cursors, Sets, and Temporary Tables
  • Evaluating the Use of Cursor/Iterative Solutions vs. Set-Based Solutions
  • Using Temporary Tables vs. Table Variables
  • Case Scenarios
  • Suggested Practices
  • Answers

    Understanding Further Optimization Aspects
  • Understanding Plan Iterators
  • Using Parameterized Queries and Batch Operations
  • Using Optimizer Hints and Plan Guides
  • Case Scenarios
  • Suggested Practices
  • Answers

For More Information

For training inquiries, call 850-308-1376

or email us at eramos@gbsi.com

Course Details

Duration - 5 days
Price - $3095.00 USD


(Discounts may apply. Call for more information.)

Course Actions

Schedule

Acceletrain Collaborative Learning Environment (formerly know as VILT) places industry certified and expert instructors, peers, learners and multi-media components into a "borderless classroom", and interactive learning environment that can span multiple physical locations. VILT combines the benefits of the traditional brick-and-mortar classroom with innovative learning techniques and the cost savings of internet-based training.