T-SQL Data Manipulation Playbook
Querying is one of the most common operations when working with a database. But to query, you need data. This training covers how to insert, update, and delete data in your Microsoft SQL Server database using T-SQL Data Manipulation Language, or DML.
What you'll learn
In this course, T-SQL Data Manipulation Playbook, you’ll learn foundational knowledge required to add records, modify data, and remove records in your SQL Server database.
First, you’ll learn how to add data using the INSERT statement. Next, you’ll discover how to modify data using UPDATE, and how to remove data using the DELETE statement.
Moving on, you’ll explore how to maintain database integrity with transactions. Finally, you'll examine some more advanced T-SQL statements that are not that common, but can help you with your daily work.
When you’re finished with this course, you'll have the skills and knowledge of the T-SQL Data Manipulation Language needed to insert, update, and delete data in Microsoft SQL Server.
Table of contents
- Version Check 0m
- Working with the T-SQL Data Manipulation Language 4m
- Understanding and Differentiating the T-SQL Sub-languages 2m
- What Is the T-SQL Data Manipulation Language? 1m
- The Database for This Training: StackOverflow or StackExchange 6m
- What You Need to Know About SELECT for DML 9m
- What You Need to Know About WHERE for DML 5m
- Takeaway 1m
- Adding Data Using T-SQL Statements 1m
- Adding New Records with the INSERT Statement 2m
- An Insert Statement with Columns and Values 4m
- An Insert Statement with All Values 2m
- An Insert Statement with NULL and DEFAULT 4m
- An Insert Statement with an Identity 3m
- An Insert Statement with Constraints 6m
- Adding Multiple Records from a Data File with BULK INSERT 5m
- Takeaway 1m
- Modifying Data Using T-SQL Statements 1m
- Modifying Records with the UPDATE Statement 3m
- Using UPDATE to Modify Data in One Row 2m
- Using UPDATE to Modify Data in Multiple Rows 2m
- Retrieving Number of Affected Rows with @@Rowcount 3m
- Modifying Data Using UPDATE with Constraints 4m
- UPDATE Using Variables 4m
- FROM and JOIN within an UPDATE 3m
- A Few More Details on UPDATE 2m
- Takeaway 1m
- Removing Data Using T-SQL Statements 1m
- Removing Records with the DELETE Statement 1m
- Removing a Specific Record with DELETE 2m
- Removing Multiple Records with DELETE 4m
- Deleting Data Using JOINs 3m
- Removing Data with Constraints and Cascade Deleting of Data 6m
- Clearing Tables Using TRUNCATE and How It Differs from DELETE 7m
- Takeaway 1m
- Maintaining Data Integrity with Transactions 3m
- Transaction Properties 2m
- Understanding T-SQL Transactions 3m
- Creating Transactions Using BEGIN and COMMIT 8m
- Querying Data Locked in a Transaction with NOLOCK 3m
- Undoing Transactions Using ROLLBACK 3m
- Partially Undoing Transactions Using Savepoints 6m
- Distributed Transactions at a High Level 2m
- Takeaway 1m
- Using Advanced T-SQL Techniques 1m
- Using INSERT with Multiple Values 2m
- SELECT within an INSERT Statement 4m
- Using SELECT to Retrieve a Specific Field in an INSERT 3m
- Retrieving Records on INSERT Using the OUTPUT Clause 6m
- Utilizing MERGE to Perform Operations on a Target Table 5m
- BULK INSERT Using a Format File 5m
- Takeaway 2m
About the author
Xavier is very passionate about teaching, helping others understand search and Big Data. He is also an entrepreneur, project manager, technical author, trainer, and holds a few certifications with Cloudera, Microsoft, and the Scrum Alliance, along with being a Microsoft MVP. He has spent a great deal of his career working on cutting-edge projects with a primary focus on .NET, Solr, and Hadoop among a few other interesting technologies. Throughout multiple projects, he has acquired skills to deal... more