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.
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.
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.
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.