Free Transact SQL Video Tutorial: Pt. 1 - An Introduction to the UPDATE Statement and Modifying Data With Transact SQL

Pt. 1 - An Introduction to the UPDATE Statement and Modifying Data With Transact SQL - download

Scott Whigham masterfully surprises us once again with this brilliant part 1 video on the proper syntax for the 4 part video series on the Data Manipulation Language (DML) UPDATE STATEMENT. This video is a must have. This video not only demonstrates exactly how to utilize proper syntax and rules when working with the UPDATE statement but is filled with vast amounts of other data and knowledge such as the following:

• Working with Literal values and the updating based upon another table.
• What syntax is available whether this is standard or proprietary.
• Introduction to creating a database with SQL Server Management Studio
• Simplistic table creation (CREATE TABLE)
• Introduction to database backup
• Explaining errors with security privileges when backing up a database.
• Default database backup syntax and location on a local hard drive.
• Introduction and explanation of the SET NOCOUNT ON option.
• Creation and termination of an infinite WHILE LOOP
• Introduction and Explanation of the three SQL Language Classifications:
• Data Manipulation Language (DML): SELECT, INSERT, UPDATE, DELETE
• Data Definition Language (DDL): CREATE, ALTER, DROP (Manipulating Objects in the database)
• Permissions Based Data Control Language (DCL) GRANT, DENY, REVOKE
• Real world common error examples and how to properly prevent these errors.
• Proper syntax for the update statement.
• Proper formatting of your T-SQL Code and common mistakes when improperly formatting and executing your T-SQL Code.
• Introduction of the TOP statement, variable declarations and more.

This video is filled with the proper ways to perform a variety of actions within T-SQL.

NOTE: This video description was written by one of our members, Wayne Leiser. Thanks, Wayne!

---

• Source: http://www.LearnTransactSQL.com
• Category: SQL Server Videobooks
• Skill Level: 200 (Beginner - Intermediate)
• Length: 13:50 (9.16MB)
• Source Videobook Entry (Subscriber-only version)

---

To download this video, visit the Free Videos page, click "download" and enter the correct security code.

Note: You must have the TSCC codec installed to view this video

---

Keywords Associated with this video: UPDATE STATEMENT, UPDATE syntax, Data Manipulation Langauge, Data Definition Language, Data Control Langauge, DML, DDL, DCL, CRE