Query Transact-SQL (T-SQL) 2016/2019: For data modification

Query Transact-SQL (T-SQL) 2016/2019: For data modification

This course is narrowly focused on a specific portion of Transact-SQL. The course covers data modification topics namely INSERT, UPDATE, and DELETE by using different T-SQL statements. It discusses many scenarios of data modification including from stored procedure result set(s), joins, subqueries, nondeterministic updates (and how to handle them), UPDATE based on a variable, table expressions, as well as the concept of UPDATE All-at-Once. The course is fully hands-on using a supplied sample database. For your convenience and smooth learning experience, a custom user interface has been provided for you to execute all your SQL codes outside of SQL Server Management Studio (SSMS)

To receive the full benefit from this course you must meet the following requirements:

• You must have some working experience with T-SQL

• A familiarity with SSMS is an advantage but not strictly required (you can write and execute your SQL codes exclusively in the custom interface)

• Must have access to a SQL Server instance (2016/2019)

• Have some understanding of filtering and sorting data

• An understanding of creating tables and enforcing data integrity through T-SQL

Every lesson of the course comes with quizzes that test your understanding of the topics. At the end of each section you test your knowledge with review questions (answers are provided). We also provide two Case Scenarios that test your understanding of the topics covered in the whole course.

Master the skills of SQL Server Transact-SQL (T-SQL) for data modification (INSERT, UPDATE, DELETE). Become an Expert

Url: View Details

What you will learn

• Insert single and multiple rows into a table by using the INSERT VALUES statement
• Insert the result of a query into a table by using the INSERT SELECT statement
• Insert the result of a stored procedure or a dynamic batch into a table by using the INSERT EXEC statement

Rating: 5

Level: Intermediate Level

Duration: 2.5 hours

Instructor: Samuel Osei-Tutu