Home > Courses > Databases > Development > SQL Server FAST TRACK - Temp Tables and Table Variables
   3.5  11 reviews on Udemy

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.
Course from Udemy
 1053 students enrolled
 en
By the end of this course you should have a very clear understanding of both temp tables and table variables. You should understand both how they are similar and how they are different. Most importantly you will be equipped to know which one to use in a specific situation.

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
    • SQL Server FAST TRACK - Temp Tables and Table Variables
    $ 34.99
    per course
    Also check at

    FAQs About "SQL Server FAST TRACK - Temp Tables and Table Variables"

    About

    Elektev is on a mission to organize educational content on the Internet and make it easily accessible. Elektev provides users with online course details, reviews and prices on courses aggregated from multiple online education providers.
    DISCLOSURE: This page may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

    CONTACT

    [email protected]

    SOCIAL NETWORK

    Copyright © Elektev
    Privacy Policy