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.

1. Course Overview

1. Course Overview

2. Working with the T-SQL Data Manipulation Language

1. Version Check

2. Working with the T-SQL Data Manipulation Language

3. Understanding and Differentiating the T-SQL Sub-languages

4. What Is the T-SQL Data Manipulation Language

5. The Database for This Training - StackOverflow or StackExchange

6. What You Need to Know About SELECT for DML

7. What You Need to Know About WHERE for DML

8. Takeaway

3. Adding Data Using T-SQL Statements

1. Adding Data Using T-SQL Statements

2. Adding New Records with the INSERT Statement

3. An Insert Statement with Columns and Values

4. An Insert Statement with All Values

5. An Insert Statement with NULL and DEFAULT

6. An Insert Statement with an Identity

7. An Insert Statement with Constraints

8. Adding Multiple Records from a Data File with BULK INSERT

9. Takeaway

04. Modifying Data Using T-SQL Statements

01. Modifying Data Using T-SQL Statements

02. Modifying Records with the UPDATE Statement

03. Using UPDATE to Modify Data in One Row

04. Using UPDATE to Modify Data in Multiple Rows

05. Retrieving Number of Affected Rows with @@Rowcount

06. Modifying Data Using UPDATE with Constraints

07. UPDATE Using Variables

08. FROM and JOIN within an UPDATE

09. A Few More Details on UPDATE

10. Takeaway

5. Removing Data Using T-SQL Statements

1. Removing Data Using T-SQL Statements

2. Removing Records with the DELETE Statement

3. Removing a Specific Record with DELETE

4. Removing Multiple Records with DELETE

5. Deleting Data Using JOINs

6. Removing Data with Constraints and Cascade Deleting of Data

7. Clearing Tables Using TRUNCATE and How It Differs from DELETE

8. Takeaway

6. Maintaining Data Integrity with Transactions

1. Maintaining Data Integrity with Transactions

2. Transaction Properties

3. Understanding T-SQL Transactions

4. Creating Transactions Using BEGIN and COMMIT

5. Querying Data Locked in a Transaction with NOLOCK

6. Undoing Transactions Using ROLLBACK

7. Partially Undoing Transactions Using Savepoints

8. Distributed Transactions at a High Level

9. Takeaway

7. Using Advanced T-SQL Techniques

1. Using Advanced T-SQL Techniques

2. Using INSERT with Multiple Values

3. SELECT within an INSERT Statement

4. Using SELECT to Retrieve a Specific Field in an INSERT

5. Retrieving Records on INSERT Using the OUTPUT Clause

6. Utilizing MERGE to Perform Operations on a Target Table

7. BULK INSERT Using a Format File

8. Takeaway

8. Final Takeaway

1. Final Takeaway

45,900 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: PluralSight