Modifying Data in Microsoft® SQL Server„¢ 2005 (4331)


In this course, you modify data in tables using Transact-SQL (T-SQL) in Microsoft SQL Server 2005. You insert, delete, and update single or multiple rows of data in the tables. You use statements such as INSERT, DELETE, UPDATE, INSERT…SELECT, SELECT INTO, and TRUNCATE TABLE statements.

In addition, you examine implicit and explicit transactions, the importance of transaction isolation levels, and how to manage transactions.

This course also helps prepare you for certification exam 70-431.

ATTENTION: Depending on your subscription, the Virtual Labs (vLabs) for this course may not be available. If the Virtual Labs do not launch when you click the launch button, contact your company Training Administrator for more information about your subscription.



  • Explain how SQL Server implements transactions.
  • Insert data into tables.
  • Delete data from tables.
  • Update data in tables.


User Reviews

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

Course Info

  • Code: EL-MDMS2005
  • Duration: 2 hours
  • Price: Call for price

Next Step

Enquire Now
Tell a Friend