MOC 50439 Working with Data Using SQL Server 2008 R2 for the Non-database Administrator

    

Summary:
This instructor-led course provides students with the necessary knowledge to work with the data in SQL Server 2008R2. They will learn how to use the built in tools included with SQL Server to construct queries, do tuning, analyze a query and its performance, along with how to modify existing data, perform joins, create indexes, and work with XML. The new features are discussed and their impact is explained.

Duration:
3 Days/Lecture & Lab

Audience:
This course is intended for Power Users and IT Professionals that are called on occasionally to work with SQL Server in the retrieving, or modifying of data and need a good foundation to perform those functions. This would include those users that develop reports and need to create Data Sets that work efficiently.

Topics:

• The Toolsets
• Data Types and New T-SQL Language Features
• Single Table Queries
• Joining Multiple Tables
• Subqueries, Common Table Expressions and Ranking Functions
• Indexing
• Query Tuning
• Data Modification, Transactions and Error Processing
• Stored Procedures and Triggers
• XML

Prerequisites:
Before attending this course, students should have: -A working knowledge of databases but not necessarily SQL.

Last Update: June 19, 2013