T-SQL Data Manipulation Playbook

Focused View

Xavier Morera

2:54:00

78 View

1. Course Overview

1. Course Overview.mp4

01:41

2. Working with the T-SQL Data Manipulation Language

1. Version Check.mp4

00:15

2. Working with the T-SQL Data Manipulation Language.mp4

03:33

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

02:20

4. What Is the T-SQL Data Manipulation Language.mp4

01:25

5. The Database for This Training - StackOverflow or StackExchange.mp4

05:36

6. What You Need to Know About SELECT for DML.mp4

09:10

7. What You Need to Know About WHERE for DML.mp4

05:26

8. Takeaway.mp4

00:42

3. Adding Data Using T-SQL Statements

1. Adding Data Using T-SQL Statements.mp4

01:13

2. Adding New Records with the INSERT Statement.mp4

02:22

3. An Insert Statement with Columns and Values.mp4

04:08

4. An Insert Statement with All Values.mp4

02:05

5. An Insert Statement with NULL and DEFAULT.mp4

04:18

6. An Insert Statement with an Identity.mp4

03:29

7. An Insert Statement with Constraints.mp4

05:58

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

05:12

9. Takeaway.mp4

01:00

04. Modifying Data Using T-SQL Statements

01. Modifying Data Using T-SQL Statements.mp4

01:00

02. Modifying Records with the UPDATE Statement.mp4

02:31

03. Using UPDATE to Modify Data in One Row.mp4

02:12

04. Using UPDATE to Modify Data in Multiple Rows.mp4

02:04

05. Retrieving Number of Affected Rows with @@Rowcount.mp4

02:34

06. Modifying Data Using UPDATE with Constraints.mp4

03:44

07. UPDATE Using Variables.mp4

03:52

08. FROM and JOIN within an UPDATE.mp4

03:04

09. A Few More Details on UPDATE.mp4

01:54

10. Takeaway.mp4

01:20

5. Removing Data Using T-SQL Statements

1. Removing Data Using T-SQL Statements.mp4

01:07

2. Removing Records with the DELETE Statement.mp4

01:20

3. Removing a Specific Record with DELETE.mp4

02:20

4. Removing Multiple Records with DELETE.mp4

03:56

5. Deleting Data Using JOINs.mp4

02:58

6. Removing Data with Constraints and Cascade Deleting of Data.mp4

06:03

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

06:48

8. Takeaway.mp4

01:29

6. Maintaining Data Integrity with Transactions

1. Maintaining Data Integrity with Transactions.mp4

02:36

2. Transaction Properties.mp4

01:44

3. Understanding T-SQL Transactions.mp4

03:08

4. Creating Transactions Using BEGIN and COMMIT.mp4

08:04

5. Querying Data Locked in a Transaction with NOLOCK.mp4

03:11

6. Undoing Transactions Using ROLLBACK.mp4

03:02

7. Partially Undoing Transactions Using Savepoints.mp4

05:45

8. Distributed Transactions at a High Level.mp4

01:33

9. Takeaway.mp4

01:26

7. Using Advanced T-SQL Techniques

1. Using Advanced T-SQL Techniques.mp4

00:54

2. Using INSERT with Multiple Values.mp4

02:29

3. SELECT within an INSERT Statement.mp4

04:03

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

03:12

5. Retrieving Records on INSERT Using the OUTPUT Clause.mp4

05:32

6. Utilizing MERGE to Perform Operations on a Target Table.mp4

05:24

7. BULK INSERT Using a Format File.mp4

05:25

8. Takeaway.mp4

02:03

8. Final Takeaway

1. Final Takeaway.mp4

04:20

Description

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Database Programming

Microsoft SQL

Xavier Morera

Instructor's Courses

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 with complex enterprise software solutions, working with companies that range from startups to Microsoft. Xavier also worked as a worldwide v-trainer/evangelist for Microsoft.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.