SQL Server FAST TRACK - Temp Tables and Table Variables

This is an in depth course about programming with TEMP TABLES and TABLE VARIABLES in SQL Server. It assumes that the student has at least a rudimentary understanding of database concepts and architecture and gets right into the meat of the subject. Temp tables and table variables can solve a lot of the trickier challenges faced by developers so you need to become expert with them. This course will get cover all of the following: TEMP TABLES Temp Tables and the Temp Database (tempdb) Persistence Persistence in STORED PROCEDURES Persistence - TSQL vs STORED PROCEDURES Command Line TSQL examples IDENTITY column usage STORED PROCEDURE usage Command Line TSQL vs STORED PROCEDURE TEMP TABLES vs REAL TABLES TABLE VARIABLES No Persistence Command Line TSQL examples IDENTITY column usage STORED PROCEDURE usage USER DEFINED FUNCTION usage Table Variables vs Temp Tables: How they are similar and how they differ Benefits and drawbacks to each type

Requirements The student should have a basic understanding of databases. It would also be beneficial to have SQL Server installed on the student's computer.