Community Course

Working with Data using SQL Server 2008 R2 For Non-Database Administrators

50439BC (Class Pack)
Based on student feedback via 'Metrics that Matter'
Working with Data using SQL Server 2008 R2 For Non-Database Administrators
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 it’s 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.
Please contact your Learning Partner in order to take this course
Author: BlueBuffaloPress

Course Duration: 3 Days

SATV: Yes

About This Course

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 it’s 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.

Audience Profile

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.

At Course Completion

After completing this course, students will be able to:
  • Use SQL Server Management Studio (SSMS).
  • Use SSMS to generate queries.
  • Use the Object Browser.
  • Use the Template manager.
  • Customize the SSMS environment.
  • Run a trace in SQL Profiler.
  • Use the debugger with a query.
  • Work with SQL Server Integration Services to do a basic package for import/export.
  • Use the Database Tuning Advisor.
  • Read an Execution Plan.
  • Explain and perform single table queries.
  • Perform joins between tables.
  • Understand indexing and its impact.
  • Write code within the context of a transaction.
  • Utilize Try-Catch error handling.
  • Use Stored Procedures.
  • Explain the new language features.
  • Write a sub-query.
  • Use common table expressions.
  • Work with the XML datatype and the new methods.