Elements of the SELECT StatementThe FROM ClauseThe WHERE ClauseThe GROUP BY ClauseThe HAVING ClauseThe SELECT ClauseThe ORDER BY ClauseThe TOP and OFFSET-FETCH FiltersThe TOP FilterThe OFFSET-FETCH FilterA Quick Look at Window FunctionsPredicates and OperatorsCASE ExpressionsNULL MarksAll-at-Once OperationsWorking with Character DataData TypesCollationOperators and FunctionsString Concatenation (Plus Sign [+] Operator and CONCAT
Function)The SUBSTRING FunctionThe LEFT and RIGHT FunctionsThe LEN and DATALENGTH FunctionsThe CHARINDEX FunctionThe PATINDEX FunctionThe REPLACE FunctionThe REPLICATE FunctionThe STUFF FunctionThe UPPER and LOWER FunctionsThe RTRIM and LTRIM FunctionsThe FORMAT FunctionThe LIKE PredicateThe % (Percent) WildcardThe _ (Underscore) WildcardThe [<List of Characters>] WildcardThe [<Character>-<Character>] WildcardThe [^Character List or Range>] WildcardThe ESCAPE CharacterWorking with Date and Time DataDate and Time Data TypesLiteralsWorking with Date and Time SeparatelyFiltering Date RangesDate and Time FunctionsCurrent Date and TimeThe CAST, CONVERT, and PARSE Functions and Their TRY_
CounterpartsThe SWITCHOFFSET FunctionThe TODATETIMEOFFSET FunctionThe DATEADD FunctionThe DATEDIFF FunctionThe DATEPART FunctionThe YEAR, MONTH, and DAY FunctionsThe DATENAME FunctionThe ISDATE FunctionThe FROMPARTS FunctionsThe EOMONTH FunctionQuerying MetadataCatalog ViewsInformation Schema ViewsSystem Stored Procedures and FunctionsConclusionExercises12345678Solutions12345678
