SQL Server FAST TRACK - Temp Tables and Table Variables

Get up to speed quickly with TEMP TABLES and TABLE VARIABLES. Learn how they work and when to use which table type.

0 0
SQL Server FAST TRACK - Temp Tables and Table Variables
SQL Server FAST TRACK - Temp Tables and Table Variables

SQL Server FAST TRACK - Temp Tables and Table Variables udemy course

Get up to speed quickly with TEMP TABLES and TABLE VARIABLES. Learn how they work and when to use which table type.

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

    • Tags: