Learn how the T-SQL data manipulation language (DML) can help you control the information inside your SQL Server database.

Do you work with SQL Server? Interested in learning more about the T-SQL language? Then you’re in the right place! We’re excited to introduce our new online course: How to Insert, Update, or Delete Data in MS SQL Server.

In this course, you’ll learn about the data manipulation language (DML) statements in T-SQL. These allow you to add or erase any data as needed, as well as modify data in T-SQL code.

The course consists of 79 interactive exercises with instructions. We’ll start off by explaining the basic data manipulation operations in SQL Server: INSERT, UPDATE, and DELETE. Then, you’ll be smoothly introduced to more advanced data manipulation operations, such as returning rows from INSERT, UPDATE, and DELETE with an OUTPUT clause.

Next, you’ll discover how a database can automatically fill certain values and learn how you can use auto-filling features in T-SQL. You’ll also learn how you can refer to other tables in INSERT, UPDATE, and DELETE operations in MS SQL Server.

As usual, at the end of the course, you’ll be challenged with a summary quiz that’ll help you review and consolidate everything you’ve learned.

If you’ve completed our SQL Basics or SQL Basics in MS SQL Server online course, or have equivalent knowledge, then you’re ready to complete this latest addition to our growing catalog of SQL courses.

Upskill yourself with Vertabelo Academy today! And remember: Education is the one thing that lasts a lifetime.