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
Explore how NULL values affect aggregate functions and learn how to handle them effectively in your SQL queries.