SQL Server Basics SELECT ORDER BY OFFSET FETCH SELECT TOP SELECT DISTINCT WHERE Joins GROUP BY GROUPING SETS Subquery EXISTS ANY ALL UNION INTERSECT EXCEPT INSERT INSERT Multiple Rows INSERT INTO SELECT UPDATE UPDATE JOIN DELETE MERGE PIVOT Transaction

SQL Server Views Creating Views Listing Views Renaming Views Getting View Information Removing Views Creating Indexed Views

SQL Server Indexes Clustered indexes Create nonclustered indexes Rename indexes Disable indexes Enable indexes Unique indexes Drop indexes Indexes with included columns Filtered indexes Indexes on computed columns

SQL Server Stored Procedures basic Parameters Variables Output Parameters BEGIN…END IF ELSE WHILE BREAK CONTINUE Cursor TRY CATCH RAISERROR THROW Dynamic SQL

SQL Server User-defined Functions scalar functions Table variables Table-valued functions Removing

SQL Server Triggers Creating a trigger Creating an INSTEAD OF trigger Creating a DDL trigger Disabling triggers Enabling triggers Viewing the definition of a trigger Listing all triggers in SQL Server Removing triggers

SQL Server System Functions Aggregate Functions Date Functions String Functions Window Functions