Course Details

Focus Training Services provides Program on Querying Microsoft SQL Server. This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2012. The course topics are:

• Foundations of Querying
• Getting Started with the SELECT Statement
• Filtering and Sorting Data
• Combining Sets
• Grouping and Windowing
• Querying Full-Text Data
• Querying and Managing XML Data
• Creating Tables and Enforcing Data Integrity
• Designing and Creating Views, Inline Functions, and Synonyms
• Inserting, Updating, and Deleting Data
• Other Data Modification Aspects
• Implementing Transactions, Error handling, and Dynamic SQL
• Designing and Implementing T-SQL Routines
• Using Tools to analyze Query performance
• Implementing Indexes and Statistics
• Understanding Cursors, Sets, and Temporary Tables
• Understanding Further Optimization aspects