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.
Course info
Level
Intermediate
Updated
Sep 27, 2019
Duration
2h 54m
Table of contents
Course Overview
Working with the T-SQL Data Manipulation Language
Adding Data Using T-SQL Statements
Modifying Data Using T-SQL Statements
Removing Data Using T-SQL Statements
Maintaining Data Integrity with Transactions
Using Advanced T-SQL Techniques
Final Takeaway
Description
Course info
Level
Intermediate
Updated
Sep 27, 2019
Duration
2h 54m
Description

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.

About the author
About the author

Xavier is very passionate about teaching, helping others understand 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.

More from the author
Programming Python Using an IDE
Intermediate
2h 0m
Jun 26, 2019
More courses by Xavier Morera
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hi everyone. My name is Xavier Morera, and welcome to my course, T-SQL Data Manipulation Playbook. Knowing how to manipulate data using T-SQL statements is one of the most basic skills required to work with a Microsoft SQL Server database. Just think about it. Querying data might be very common, but you will get nowhere without knowing how to insert, update, and delete records. And that's why we're here. Some of the major topics that we will cover include understanding the statements from T-SQL's data manipulation language, or DML, about how to add data using INSERT be one record at a time or bulk INSERT, how to modify data with UDPATE, then how to remove data from the database using DELETE and TRUNCATE, how to create and work with transactions, which are integral part of T- SQL or Transact-SQL, and finally, some other related and more advanced topics, which include OUPUT, MERGE, and using DML statements with sub queries. By the end of this course, you will know and understand how to add, modify, and delete data using T-SQL statements. Before beginning the course, you should be familiar with the basics of Microsoft SQL Server and working knowledge of SQL. I hope you'll join me on this journey to learn how to work with data using T-SQL's data manipulation language in the T-SQL Data Manipulation Playbook, at Pluralsight.