Modify data with T-SQL

Data Analyst
Data Engineer
Data Scientist
Database Administrator
Solution Architect
Technology Manager
SQL Database
SQL Server
SQL Managed Instance
SQL Server on Virtual Machines
SQL Server on Azure Virtual Machines

Learn how to use Transact-SQL to insert, update, and delete data in a database.

Learning objectives

After completing this module, you will be able to:

  • Insert data into a table
  • Generate automatic values
  • Update data in a table
  • Delete data from a table
  • Merge data based on multiple tables


Before starting this module, you should have experience of using Transact-SQL SELECT queries to retrieve data from tables in a database.