Working with Data for the Non-DBA


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, analyse 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.


After completing this course, students will gain the skills to:

  • use SQL Server Management Studio (SSMS)
  • use SSMS to generate queries
  • use the Object Browser
  • use the Template manager
  • customise 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
  • utilise 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.

On-site training?

If you need training for three or more people, ask us about training at your site. You can enjoy the convenience of reduced travel cost and time, as well as a familiar environment for your staff. Additionally, we can customise the course for your business needs.

User Reviews

Not yet rated. You will need to follow this course before you can write a review.

Course Info

Next Step

Enquire Now
Tell a Friend
Email Course Outline