Article info
  • Views: 0
  • Author: rukensai
  • Date: 19-11-2021, 21:54
19-11-2021, 21:54

Transact-SQL 2016 – 2019 – Insert, Update, and Delete Data | Udemy

Category: Tutorials / Programming


Transact-SQL 2016 – 2019 – Insert, Update, and Delete Data | Udemy

Transact-SQL 2016 – 2019 – Insert, Update, and Delete Data | Udemy | 966.95 MB

What you’ll 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
Use a query result to create and populate a table by using the SELECT INTO statement
Use the UPDATE statement to modify rows in a table
Update data by using joins
Describe the circumstances in which you get nondeterministic updates
Update data through table expressions such as Common Table Expression (CTE) or subqueries
Update data by using variables
Describe the implications of the all-at-once property of SQL on updates
Use the DELETE and TRUNCATE statements to delete rows from a table
Use a DELETE statement based on joins
Use a DELETE statement based on table expressions such as CTE and subquery

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)

Download link:

Links are Interchangeable - Single Extraction - Premium is support resumable
Dear visitor, you are browsing our website as Guest.
We strongly recommend you to register and login to view hidden contents.

Navigation

^