SQL Server 2008 R2: Running Queries and Manipulating Data

This course is included in our On-demand training solution.


SQL Server 2008 R2 includes the SQL Server Management Studio which allows access to SQL Server databases and enables you to access database data. This data can be retrieved and modified through the use of Transact-SQL within the Query Edit window of the Management Studio tool. Using Transact-SQL you can select data from a database’s tables and filter the results to include only the data that you require. Transact-SQL statements also allow you to update, change, and remove data from tables. This course identifies the basic T-SQL statements that can be used to retrieve and modify data within SQL Server databases. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft exam: 70-433 TS: Microsoft SQL Server 2008, Database Development. Passing this exam will earn the learner Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Database Development certification.

Target Audience

IT professionals who have jobs in which database administration is their main area of responsibility, or who work in environments in which databases are central to their job roles. These job roles include • IT generalists who work in environments in which SQL Server 2008 R2 is part of an overall solution • IT professionals who manage systems that run SQL Server 2008 R2 • IT professionals who work with third-party applications that are built on SQL Server 2008 R2 • Developers who build applications that use SQL Server 2008 R2


The prerequisites for the exam are that candidates should have one to two years of experience using Microsoft SQL Server 2008, SQL Server 2008 R2, or two to three years of experience using a previous version of SQL Server.

Expected Duration

90 min.

Course Objectives

Using SELECT and Joins

  • recognize how to use SELECT to retrieve data
  • recognize how to use joins to retrieve data

  • recognize how to use INSERT to input data
  • recognize how to use UPDATE to change existing data
  • recognize how to use DELETE to remove data
  • Using MERGE, OUTPUT, and Subqueries

  • recognize how to use MERGE to perform multiple operations
  • recognize how to use OUTPUT to generate output
  • recognize how to use subqueries
  • Performing Queries and Manipulating Data