What you'll learn

Business data isn't a static snapshot--it's a living, breathing stream of information. Effective decision-making relies on the principle that data is never static, but rather needs to be continuously updated and refined. In this course, Modify Data with T-SQL, you’ll gain the ability to insert, update, and delete data in a secure and consistent way to keep your SQL Server databases up to date. First, you’ll explore various options for inserting new records in the database.

Next, you’ll discover how to update existing data in a table in both simple and more complex scenarios, as well as how to remove the data from the table by using DELETE and TRUNCATE commands.

Finally, you’ll learn how to leverage the OUTPUT clause and encapsulate modification logic within the T-SQL transaction to ensure safe and consistent data modification.

When you’re finished with this course, you’ll have the skills and knowledge of various T-SQL data modification techniques and concepts that will enable you to insert, update, and delete data in a safe and consistent way.