Microsoft SATVs Are Expiring —Take Full Advantage and Act Now!

closeClose

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

  • Tuition USD $2,066 List Price $2,295 GSA  $1,734.26
  • Reviews star_rate star_rate star_rate star_rate star_half 2368 Ratings
  • Course Code 50439
  • Duration 3 days
  • Available Formats Classroom

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.

Skills Gained


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.

Who Can Benefit


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.

Prerequisites


Before attending this course, students should have:

  • A working knowledge of databases but not necessarily SQL.

How do I get a Microsoft exam voucher?

Pearson Vue Exam vouchers can be requested and ordered with your course purchase or can be ordered separately by clicking here.

  • Vouchers are non-refundable and non-returnable. Vouchers expire 12 months from the date they are issued unless otherwise specified in the terms and conditions.
  • Voucher expiration dates cannot be extended. The exam must be taken by the expiration date printed on the voucher.

Do Microsoft courses come with post lab access?

Most Microsoft official courses will include post-lab access ranging from 30 to 180 calendar days after instructor led course delivery. A lab training key in class will be provided that can be leveraged to continue connecting to a remote lab environment for the individual course attendee.

Does the course schedule include a Lunchbreak?

Lunch is normally an hour-long after 3-3.5 hours of the class day.

What languages are used to deliver training?

Microsoft courses are conducted in English unless otherwise specified.

Very Helpful when trying to get me answers to questions and get access to classes. Very prompt and helpful. Thank you.

Very clear and concise course. It was worth attending to me and provided useful information I will use going forward.

Great facility with good selection of drinks and small snacks. Equipment also worked flawlessly.

La experiencia fue muy buena, le doy la mayoría del merito al instructor, resulto excelente y muy apegado a la realidad.

The instructor really took his time and made sure I was able to understand the concepts.

0 options available

There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links above. We can also contact you when the course is scheduled in your area.

Contact Us 1-800-803-3948
Contact Us
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward