Simple play icon Course
Skills

T-SQL Data Manipulation Playbook

by Xavier Morera

Querying is one of the most common operations when working with a database. But to query, you need data. This training covers how to insert, update, and delete data in your Microsoft SQL Server database using T-SQL Data Manipulation Language, or DML.

What you'll learn

In this course, T-SQL Data Manipulation Playbook, you’ll learn foundational knowledge required to add records, modify data, and remove records in your SQL Server database.

First, you’ll learn how to add data using the INSERT statement. Next, you’ll discover how to modify data using UPDATE, and how to remove data using the DELETE statement.

Moving on, you’ll explore how to maintain database integrity with transactions. Finally, you'll examine some more advanced T-SQL statements that are not that common, but can help you with your daily work.

When you’re finished with this course, you'll have the skills and knowledge of the T-SQL Data Manipulation Language needed to insert, update, and delete data in Microsoft SQL Server.

Table of contents

Course Overview
1min
Final Takeaway
4mins

About the author

Xavier has a two passions. He loves the challenge of learning about complex topics and then sharing this newfound knowledge with others. The topics he is currently focused on are AI, ML, Generative AI, Search and Big Data. He is also an entrepreneur, project manager, technical author, trainer, and holds a few certifications with Cloudera, Microsoft, and the Scrum Alliance, along with having been awarted Microsoft MVP. He has spent a great deal of his career working on cutting-edge projects.... more

Ready to upskill? Get started