JWARE Proudly Presents: Pluralsight.net - SQL Server: Transact-SQL Basic Data Modification
Release Type: Bookware
Supplier: JWARE
Cracker: JWARE
Packer: JWARE
Protection: DRM
Publisher URL: http://www.pluralsight-training.net/
Publisher: Pluralsight-training
Publication date: 18/09/12
Release date: 24/10/12
Description:
If you need to modify data in a SQL Server database, then you need to know how to use the INSERT,
UPDATE and DELETE statements. This course starts by explaining how to find information about the
tables and columns you want to modify. It then explains the INSERT, UPDATE, and DELETE statements
in detail along with various methods for limiting the data being modified. Finally it moves beyond
the basic modification statements to more advanced topics like the MERGE statement, error handling
and more. More then thirty five demos help to give you a thorough understanding of how to perform
these essential operations, all using a freely-available demo environment that you're shown how to
set up and configure. This course is perfect for developers who need to modify data in SQL Server
databases, from complete beginners through to more experienced developers who can use some of the
modules as reference material. The information in the course applies to all versions from SQL Server
2005 onwards.