New Course: SQL Server: Transact-SQL Basic Data Modification

As Paul recently announced, the entire SQLskills team will be rolling out SQL Server content across several subjects on Pluralsight.com.

My latest course, “SQL Server: Transact-SQL Basic Data Modification”, which is the companion to “SQL Server: Transact-SQL Basic Data Retrieval”, was just published today by Pluralsight.com.

The course description is as follows:

“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.”

I’ll continue doing other T-SQL courses in the future for various levels, starting with the beginner level content as I’ve been doing. My next Pluralsight course will be on a different subject related to SQL Server performance, but I’ll hold off on describing it for now.

0 thoughts on “New Course: SQL Server: Transact-SQL Basic Data Modification”

David Ludwig says:

October 8, 2012 at 4:05 am

In the SQL Server: Transact-SQL Basic Data Retrieval course it uses SQL 2012. I already have SQL 2008R2 installed. Can that be used to take the course instead of 2012?

Comments are closed.

Other articles

New Course: “SQL Server: Common Query Tuning Problems and Solutions – Part 2″

Today, Pluralsight published my latest course, “SQL Server: Common Query Tuning Problems and Solutions – Part 2“. Part two is 2 hours and 17 minutes long

New Course: “SQL Server: Common Query Tuning Problems and Solutions – Part 1”

Pluralsight published my latest course, “SQL Server: Common Query Tuning Problems and Solutions – Part 1“. Part 1 is 2 hours and 31 minutes and

SQLIntersection Post-Conference Session

I am really happy to announce that Kimberly Tripp and I will be delivering a post-conference in November’s SQLIntersection conference at the MGM Grand. The

Optimizing Your Query Plans with the SQL Server 2014 Cardinality Estimator

I’ve been working on writing a new Microsoft white paper since January covering the main changes made in the SQL Server 2014 Cardinality Estimator, and

Finding Timeout-Prone Code with max_elapsed_time

Consider a scenario where your application timeout setting is 30 seconds and you’ve been asked to proactively start tuning workloads that are at risk of

Deck from “Practical SQL Server Cardinality Estimation”

I uploaded the deck from my session for SQLSaturday #287 Madison 2014 and you can download it here. It was an excellent event! Great organizers,

Imagine feeling confident enough to handle whatever your database throws at you.

With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.