SQL Server: Transact-SQL Basic Data Modification
Pluralsight
Course Summary
Learn how to construct INSERT, UPDATE, and DELETE statements to modify data in SQL Server databases, applicable for developers from SQL Server 2005 onwards
-
+
Course 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.
-
+
Course Syllabus
Introduction- 3m 9s
—Introduction 1m 51s
—Course Structure 1m 18sSetting Up a Transact-SQL Learning Environment- 38m 3s
—Module Introduction 0m 58s
—SQL Server 2012 Express with Tools 1m 1s
—SQL Server 2012 Express Abridged Requirements 1m 47s
—Demo: Checking Hardware and OS Specifications 0m 59s
—Demo: Checking .NET 3.5 SP1 Prerequisites 1m 55s
—Demo: Installing SQL Server 2012 Express with Tools 7m 33s
—SQL Server Management Studio (SSMS) 0m 53s
—Demo: Using SSMS 3m 26s
—SQL Server Data Tools (SSDT) 1m 20s
—Demo: Installing SSDT 2m 36s
—AdventureWorks Sample Database 0m 39s
—Demo: Attaching the AdventureWorks Sample Database 5m 20s
—Basic Data Modification Query in SSMS and SSDT 0m 46s
—Demo: Execute a Data Modification Query in SSMS 4m 11s
—Demo: Execute a Data Modification Query in SSDT 4m 39sExploring Table Metadata- 19m 14sInserting Data- 28m 46sUpdating Data- 17m 52sDeleting Data- 10m 36sBeyond the Basics- 35m 18s