You may add more courses here,
your list will be saved.

Home Online Courses SQL Server SQL Server FAST TRACK - Temp Tables and Table Variables
Udemy SQL Server FAST TRACK - Temp Tables and Table Variables Udemy
Visit Website

SQL Server FAST TRACK - Temp Tables and Table Variables

Udemy

Add to wishlist
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
    View more similar courses
    Courses you can instantly connect with... Do an online course on SQL Server starting now. See all courses
    See all similar courses