Course Details
Querying Microsoft SQL Server 2012 (70-461)

Course Description :

This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2012. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence.


Course Topics


o    Foundations of Querying

o    Getting Started with the SELECT Statement

o    Filtering and Sorting Data

o    Combining Sets

o    Grouping and Windowing

o    Querying Full-Text Data

o    Querying and Managing XML Data

o    Creating Tables and Enforcing Data Integrity

o    Designing and Creating Views, Inline Functions, and Synonyms

o    Inserting, Updating, and Deleting Data

o    Other Data Modification Aspects

o    Implementing Transactions, Error handling, and Dynamic SQL

o    Designing and Implementing T-SQL Routines

o    Using Tools to analyze Query performance

o    Implementing Indexes and Statistics

o    Understanding Cursors, Sets, and Temporary Tables

o    Understanding Further Optimization aspects

Enquiry Form

Phone No:


Home   |  Courses   |  Batch Info   |  Exam Dates   |  Contact Us  |
Copyright ©2013 Focus Training Services. All rights reserved