SQL PARTITION BY Clause overview

SQL AS keyword overview and examples

SQL IF Statement introduction and overview

Overview of the T-SQL If Exists statement in a SQL Server database

IF-THEN logic in SELECT and WHERE with CASE expressions in Oracle SQL

Query Optimization in SQL Server for beginners

Query optimization techniques in SQL Server: the basics

SQL Server Query Optimization with Database Engine Tuning Advisor