SQL Videos

Writing T-SQL Queries

I recorded this video for Apress publishing on Writing T-SQL Statements and is one of four in the series. This video provides you with the knowledge to write SELECT statements to retrieve data from SQL Server databases. The video begins with an explanation of fields and records, followed by the…

Selecting Data from Multiple Tables.

The third video in this series is on Selecting Data From Multiple Tables. You can extend your SELECT statements to retrieve data simultaneously from multiple tables in a SQL Server database by using join statements. We discuss Inner and Outer Joins and how they are fundamental to getting maximum value from…

T-SQL Data Manipulation

This video by John Deardurff will show you how to write DML (Data Manipulation Language) statements using INSERT, UPDATE, and DELETE keywords.