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.
1.7 (3 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
1,023 students enrolled
Instructed by Dave Merton Development / Databases
$19
$25
24% off
Take This Course
  • Lectures 20
  • Length 2 hours
  • Skill Level Intermediate Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 4/2014 English

Course Description

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
  • What are the 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.

    What am I going to get from this course?

    • 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.

    What is the target audience?

    • Any technical person who wants to have an increased understanding of the real world uses of production database development.
    • Any database developer who is ambitious, intelligent and lazy!

    What you get with this course?

    Not for you? No problem.
    30 day money back guarantee.

    Forever yours.
    Lifetime access.

    Learn on the go.
    Desktop, iOS and Android.

    Get rewarded.
    Certificate of completion.

    Curriculum

    Section 1: Temporary Tables
    * * SECTION DESCRIPTION * *
    Preview
    02:34
    Temp Table Example 1 - Persistence - TSQL and the Temp Database
    Preview
    10:01
    Temp Table Example 2 - Persistence and STORED PROCEDURES
    Preview
    05:10
    Temp Table Example 3 - Persistence - TSQL vs STORED PROCEDURES
    Preview
    08:53
    Temp Table Example 4 - Command Line TSQL
    06:09
    Temp Table Example 5 - Command Line TSQL with IF EXISTS and DROP TABLE
    09:33
    Temp Table Example 6 - Command Line TSQL with IDENTITY
    05:53
    Temp Table Example 7 - STORED PROCEDURE
    06:16
    Temp Table Example 8 - STORED PROCEDURE - IF EXISTS and DROP TABLE?
    10:39
    Temp Table Example 9 - Command Line TSQL vs STORED PROCEDURE
    06:08
    Temp Table Example 10 – TEMP TABLES vs REAL TABLES
    11:05
    SECTION 1 - REVIEW QUIZ
    10 questions
    Section 2: Table Variables
    * * SECTION DESCRIPTION * *
    01:39
    Table Variables Example 1 - No Persistence
    Preview
    03:04
    Table Variables Example 2 - Command Line TSQL
    03:47
    Table Variables Example 3 - Command Line SQL - No Need to DROP TABLE
    03:10
    Table Variables Example 4 - Command Line TSQL with IDENTITY
    03:35
    Table Variables Example 5 - STORED PROCEDURE
    03:26
    Table Variables Example 6 - STORED PROCEDURE - Multiple Tables
    06:23
    Table Variables Example 7 - USER DEFINED FUNCTION
    13:35
    Table Variables Example 8 - Table Variables vs Temp Tables - Command Line TSQL
    09:32
    SECTION 2 - REVIEW QUIZ
    7 questions

    Students Who Viewed This Course Also Viewed

    • Loading
    • Loading
    • Loading

    Instructor Biography

    Dave Merton, Senior SQL Server Database Developer

    Dave Merton is a software developer, troubleshooter, problem solver, software trainer, author and entrepreneur. He has been designing high end custom software for the last 20 years in direct mail, the pharmaceutical industry, oil companies and more.

    Over the last eight years Dave has been developing and modifying custom high end software for dozens of testing laboratories throughout the U.S. This specific software discipline is referred to as "LIMS" (Laboratory Information Management System) and can be very intensive during development and deployment. For LIMS development Dave has been using VB.Net & C Sharp for the front end; web, VB.Net and MS Access for custom reporting; and SQL Server for the back end. During this time Dave has personally built over nine separate LIMS and LIMS (LAB) related apps.

    In addition to software development Dave has personally instructed hundreds of individuals in programming. He has trained several persons in VB skills, one on one as well as given class room instruction to larger groups in the work place for both VB and SQL Server. Dave has also taught VB, Access and JavaScript in the New Milford public school system in the Adult Education program. Dave loves to teach.

    Send Dave an email, he would love to hear from you.

    Ready to start learning?
    Take This Course