Photo Gallery

MS SQL tutorial covering the use of the IIF statement.
MS SQL tutorial covering the IF ELSE statements
SQL Server Crash course | Microsoft SQL Server Tutorial | From Absolute Beginners to Advanced
MS SQL tutorial covering working with multiple databases. Including schema introduction and USE.
MS SQL tutorial covering an introduction to inner joins
MS SQL tutorial covering where clause using LIKE, NOT LIKE, wildcard (%) and BETWEEN.
MS SQL tutorial covering outer joins (left, right, full)
MS SQL tutorial covering CONCAT,  CAST and concatenating with +.
MS SQL tutorial covering the use of the case statement.
MS SQL tutorial covering views. Why use them. How to create them.
MS SQL tutorial covering inner joins
MS SQL tutorial covering a closer look at table and column aliases.