Transcender^TM eLearning Course ::

Modifying Data in Microsoft SQL Server 2005

Product Features

These self-paced, comprehensive e-Learning courses offered by Transcender will teach you everything you need to know to achieve your Microsoft credentials, ensuring a strong foundation for your career in the IT industry.

Description:
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.

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

Hardware and Software Required:
System Requirements View system requirements for all Element K courses.

Duration:
This curriculum offers approximately 2 hours of instruction.