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.
Author Name: Xavier Morera
Author Description:
Xavier Morera is driven by one passion: taking on the challenge of understanding complex topics and sharing that knowledge with others. He’s currently focused on the transformative fields of AI, machine learning, generative AI, search, and big data. As an entrepreneur, project manager, technical author, and trainer, Xavier brings a diverse set of skills and deep expertise to every project he takes on. He holds multiple certifications with Cloudera, Microsoft, and the Scrum Alliance and has been… more

Table of Contents

• Course Overview
  1min
• Working with the T-SQL Data Manipulation Language
  28mins
• Adding Data Using T-SQL Statements
  29mins
• Modifying Data Using T-SQL Statements
  24mins
• Removing Data Using T-SQL Statements
  26mins
• Maintaining Data Integrity with Transactions
  30mins
• Using Advanced T-SQL Techniques
  29mins
• Final Takeaway
  4mins