Selecting From Multiple Tables
How to write T-SQL SELECT statements using multiple tables and what are the differences between using Inner Joins, Left Outer Joins, Right Outer Joins, and Full Outer Joins.
Writing SQL
What is a Function?
What is a SQL Function and how to use a function in a T-SQL statement? We use the GetDate() and LEFT() functions as examples.
NULL Values and Aggregate Functions
How to work with NULL values in Aggregate Functions in a T-SQL statement. How to fix issues with NULL values with the AVG() and COUNT() functions.