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 [Autogenerated] Hi, everyone. My name is Surya Merida and welcome to my course he sequel. Data manipulation playbook. Knowing how to manipulate data using the sequel statements is one of the most basic skills required toe work with a market of sequel server database. Just think about it. Wearing data may 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 peace equals data manipulation language or D m l howto at data using insert Beat one record at a time or ball insert help to modify data with updates. Then how to remove data from the database using delete and tricky. How to create and work with transactions, which are an integral part of peace, equal or transact Sequel. And finally, some other related and more advanced topics, which include output, merge and using the M L statements with sub Berries. By the end of this course, you will know and understand how toe add, modify and delete data using T sequel statements before beginning the course. You should be familiar with the basics of Microsoft sequel server and working knowledge of sequel I hope you'll join me on this journey to learn howto work with data using T Sequel State of Manipulation, Language in the Peace, Equal Data Manipulation Playbook at plural site.