Topics

• PIVOT / UNPIVOT
• Stored routines (procedures and functions)
• String operations
• Indexes and Keys
• PREPARE Statements
• ALTER TABLE
• Using Variables
• Ranking Functions

Examples

• Simple PIVOT & UNPIVOT (T-SQL)
• PREPARE, EXECUTE and DEALLOCATE PREPARE Statements
• Drop index
• Changing storage engine; rebuild table; change file_per_table
• Stored procedure with IN, OUT, INOUT parameters
• Row Number and Group By using variables in Select Statement