- Course
- Data
Modify Data with T-SQL
In today’s data-driven world, the only constant is change. This course will teach you how to modify the data in your SQL Server databases by leveraging the T-SQL language to insert, update, and delete data in a consistent and safe way.
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.
Table of contents
About the author
Nikola has multi-year experience working with various flavors of data, predominantly with Microsoft BI stack. Started with SQL Server, then brushed himself with SSAS Multidimensional, SSIS, SSRS, Power BI, Azure, etc. Nikola is really curious by nature and always trying to learn something new.