-
Course
- Data
SQL Server: Transact-SQL Basic Data Modification
Learn how to construct INSERT, UPDATE, and DELETE statements to modify data in SQL Server databases, applicable for developers from SQL Server 2005 onwards
What you'll learn
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.
Table of contents
- Module Introduction | 58s
- SQL Server 2012 Express with Tools | 1m 1s
- SQL Server 2012 Express Abridged Requirements | 1m 47s
- Demo: Checking Hardware and OS Specifications | 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) | 53s
- Demo: Using SSMS | 3m 26s
- SQL Server Data Tools (SSDT) | 1m 20s
- Demo: Installing SSDT | 2m 36s
- AdventureWorks Sample Database | 39s
- Demo: Attaching the AdventureWorks Sample Database | 5m 20s
- Basic Data Modification Query in SSMS and SSDT | 46s
- Demo: Execute a Data Modification Query in SSMS | 4m 11s
- Demo: Execute a Data Modification Query in SSDT | 4m 39s
About the author
Joe Sack is a Principal Program Manager in the SQL Server and Azure SQL Database product team at Microsoft, with a focus on query processing. With over 19 years of experience in the industry, Joe is an author and speaker, specializing in performance tuning and optimization.
More Courses by Joe