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

seeders: 7
leechers: 9
updated:

Download Fast Safe Anonymous
movies, software, shows...

Files

[ FreeCourseWeb.com ] Udemy - Transact-SQL 2016 - 2019 - Insert, Update, and Delete Data
  • Get Bonus Downloads Here.url (0.2 KB)
  • ~Get Your Files Here ! 1. Introduction
    • 1. Getting ready House-keeping chores.mp4 (127.7 MB)
    • 1. Getting ready House-keeping chores.srt (9.5 KB)
    • 1.1 AcotexDB.sql (1.2 MB)
    • 1.2 S1_Exercise1.xlsm (387.5 KB)
    • 10. Lesson Review.html (0.2 KB)
    • 2. Introduction Inserting. Updating, and Deleting Data.mp4 (3.2 MB)
    • 2. Introduction Inserting. Updating, and Deleting Data.srt (1.0 KB)
    • 3. Inserting Data.mp4 (3.8 MB)
    • 3. Inserting Data.srt (1.3 KB)
    • 4. Sample Data.mp4 (27.4 MB)
    • 4. Sample Data.srt (4.1 KB)
    • 5. How to insert data with INSERT VALUES.mp4 (69.6 MB)
    • 5. How to insert data with INSERT VALUES.srt (18.7 KB)
    • 6. Using the INSERT SELECT statement.mp4 (64.0 MB)
    • 6. Using the INSERT SELECT statement.srt (11.2 KB)
    • 7. Use INSERT EXEC to insert the result set(s) returned by a stored procedure.mp4 (39.5 MB)
    • 7. Use INSERT EXEC to insert the result set(s) returned by a stored procedure.srt (7.1 KB)
    • 8. Using the SELECT INTO statement to populate a table.mp4 (79.0 MB)
    • 8. Using the SELECT INTO statement to populate a table.srt (17.7 KB)
    • 9. Lesson Summary.mp4 (8.1 MB)
    • 9. Lesson Summary.srt (2.0 KB)
    2. Updating Data
    • 1. Introduction and Sample Data.mp4 (23.9 MB)
    • 1. Introduction and Sample Data.srt (4.5 KB)
    • 1.1 S2_Exercise1.xlsm (396.8 KB)
    • 2. Using the UPDATE statement.mp4 (105.1 MB)
    • 2. Using the UPDATE statement.srt (13.2 KB)
    • 3. UPDATE based on join.mp4 (100.7 MB)
    • 3. UPDATE based on join.srt (17.4 KB)
    • 4. Nondeterministic UPDATE.mp4 (93.6 MB)
    • 4. Nondeterministic UPDATE.srt (14.6 KB)
    • 5. UPDATE and Table Expression.mp4 (47.4 MB)
    • 5. UPDATE and Table Expression.srt (9.4 KB)
    • 6. UPDATE Based on a Variable.mp4 (24.8 MB)
    • 6. UPDATE Based on a Variable.srt (5.3 KB)
    • 7. UPDATE All-at-Once.mp4 (22.7 MB)
    • 7. UPDATE All-at-Once.srt (6.8 KB)
    • 8. Lesson Review.html (0.2 KB)
    3. Deleting Data
    • 1. Introduction and sample data.mp4 (124.1 MB)
    • 1. Introduction and sample data.srt (28.6 KB)
    • 1.1 S3_Exercise1.xlsm (404.3 KB)
    • 2. Lesson Review.html (0.2 KB)
    • Bonus Resources.txt (0.3 KB)

Description

Transact-SQL 2016/2019: Insert, Update, and Delete Data



MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 17 lectures (2h 38m) | Size: 794.2 MB
Specialist T-SQL coding for data modification: INSERT, UPDATE, and DELETE
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

Requirements
To be able to perform the hands-on exercises, you need an instance of SQL Server 2016 or 2019 and SQL Server Management Studio (SSMS)
You need some experience writing Transact-SQL code
You need to install the sample database AcotexDB
You should have an understanding of filtering and sorting data
An understanding of creating tables and enforcing data integrity

Description
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:



Download torrent
967 MB
seeders:7
leechers:9
Udemy - Transact-SQL 2016 - 2019 - Insert, Update, and Delete Data


Trackers

tracker name
udp://tracker.torrent.eu.org:451/announce
udp://tracker.tiny-vps.com:6969/announce
http://tracker.foreverpirates.co:80/announce
udp://tracker.cyberia.is:6969/announce
udp://exodus.desync.com:6969/announce
udp://explodie.org:6969/announce
udp://tracker.opentrackr.org:1337/announce
udp://9.rarbg.to:2780/announce
udp://tracker.internetwarriors.net:1337/announce
udp://ipv4.tracker.harry.lu:80/announce
udp://open.stealth.si:80/announce
udp://9.rarbg.to:2900/announce
udp://9.rarbg.me:2720/announce
udp://opentor.org:2710/announce
µTorrent compatible trackers list

Download torrent
967 MB
seeders:7
leechers:9
Udemy - Transact-SQL 2016 - 2019 - Insert, Update, and Delete Data


Torrent hash: 9238A25365D98B95D4901054A4DB4D0706AB287C