Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Meditation Personal Transformation Life Purpose Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Marketing Strategy Google Ads (AdWords) Certification Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Modeling Data Analysis Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Blogging Freelancing Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Development Database Design & Development SQL Server

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.
Rating: 3.5 out of 53.5 (11 ratings)
1,053 students
Created by Dave Merton
Last updated 6/2014
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

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

Course content

2 sections • 20 lectures • 2h 10m total length

  • Preview02:34
  • Preview10:01
  • Temp Table Example 2 - Persistence and STORED PROCEDURES
    05:10
  • Temp Table Example 3 - Persistence - TSQL vs STORED PROCEDURES
    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

  • Preview01:39
  • Preview03: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

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.

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
  • Who this course is for:

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

    Instructor

    Dave Merton
    Senior SQL Server Database Developer
    Dave Merton
    • 4.1 Instructor Rating
    • 144 Reviews
    • 4,734 Students
    • 3 Courses

    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.

    • Udemy for Business
    • Teach on Udemy
    • Get the app
    • About us
    • Contact us
    • Careers
    • Blog
    • Help and Support
    • Affiliate
    • Impressum Kontakt
    • Terms
    • Privacy policy
    • Cookie settings
    • Sitemap
    • Featured courses
    Udemy
    © 2021 Udemy, Inc.