- Course
T-SQL Data Manipulation Playbook
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.
Intermediate
- Course
T-SQL Data Manipulation Playbook
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.
Intermediate
Get started today
Access this course and other top-rated tech content with one of our business plans.
Try this course for free
Access this course and other top-rated tech content with one of our individual plans.
This course is included in the libraries shown below:
- Data
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.
T-SQL Data Manipulation Playbook
Intermediate
Table of contents
-
Version Check | 15s
-
Working with the T-SQL Data Manipulation Language | 3m 33s
-
Understanding and Differentiating the T-SQL Sub-languages | 2m 20s
-
What Is the T-SQL Data Manipulation Language? | 1m 25s
-
The Database for This Training: StackOverflow or StackExchange | 5m 36s
-
What You Need to Know About SELECT for DML | 9m 10s
-
What You Need to Know About WHERE for DML | 5m 26s
-
Takeaway | 42s
Xavier is very passionate about teaching, helping others understand Generative AI, ML, 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 being a Microsoft MVP.