In late 2018, I recorded a series of videos for APRESS publishing on how to write T-SQL Queries. (I have linked to the O’Reilly website below.) There are four titles in the series with each title about 45 minutes in length. The first is how to write a T-SQL SELECT statement including how to filter records using the WHERE clause. The second video looks at the built-in system functions within SQL Server, as well as, using the GROUP BY and HAVING statements. The third videos are focused on retrieving data from multiple tables using JOINs and UNION statements. While finally, the fourth video walks through Data Manipulation Language statements such as INSERT, UPDATE, and DELETE.

Writing a SELECT Statement

This video provides you with the knowledge to write SELECT statements to retrieve data from a SQL Server database. The video begins with an explanation of fields and records, followed by the anatomy of a SELECT statement. It continues with how to use a WHERE clause to filter specific records into the result set. Since a field can store various data types, the filter section shows how to work with those data types. Finally, there is coverage of how to sort and order a result set. 

Analyizing and Summarizing Data

The video begins with an introduction to basic functions to work with character data and NULL values. From there you’ll move on to functions dealing with conditional structures, NULL values, and formatting. You’ll also cover aggregate functions to average, count, and summarize data. Finally, this video discusses how to group result sets by a field using the GROUP BY clause, and how to filter those results after they have been grouped — using the HAVING clause.

Selecting Data from Multiple Tables

Segments in the video examine the major different join types, including inner joins, left and right outer joins, and full outer joins. You’ll also work with self joins and cross joins. Finally, the video goes through various union operations that you can also use to combine rows from two or more tables, but in a manner different from a join. Union operations covered in this video include the basic union, and intersection and exception operations. 

Inserting, Updating, and Deleting Records

This video course teaches how to go beyond writing SELECT statements and to manipulate data within your database tables. You’ll begin with an introduction to Data to Data Manipulation Language (DML) that covers the INSERT, UPDATE, and DELETE statements. You’ll use these three statements most often, and they are the next most common three to use following the SELECT statement that has been covered earlier in this series. Watching the video, you’ll learn how to use these three statements to insert new data into your database to tables, and to update data in place without having to bring it down to the client and push it back and forth network. You’ll also learn to delete data when it’s no longer needed.