Udemy SQL Server FAST TRACK - Temp Tables and Table Variables Udemy
Price: USD 25

    Course details

    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
  • Updated on 27 December, 2017
    Courses you can instantly connect with... Do an online course on SQL Server starting now. See all courses

    Rate this page