MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

SQL Server: Temporary Objects

Course Summary

Learn how to use temporary tables and table variables correctly, for developers and DBAs from SQL Server 2005 onward


  • +

    Course Syllabus

    Course Introduction
    - 3m 36s

    —Course Introduction 0m 54s
    —Why use Temporary Objects? 0m 55s
    —Why A Course on Temporary Objects? 1m 5s
    —Course Structure 0m 41s
    Temporary Tables
    - 28m 15s

    —Module Introduction 0m 38s
    —Demo: Creating A Temporary Table 1m 41s
    —Demo: SELECT ... INTO A Temporary Table 1m 45s
    —Demo: Exploring Temporary Table Scope and Lifecycle 1m 31s
    —Demo: Viewing Temporary Table Metadata 1m 44s
    —Demo: Temporary Table Definition Modifications 1m 48s
    —Demo: Temporary Table Data Types 1m 33s
    —Demo: Temporary Tables and Dynamic SQL 1m 32s
    —Demo: Local vs. Global Temporary Tables 1m 58s
    —Demo: Temporary Tables in Modules 3m 53s
    —Demo: Temporary Tables and Collation Considerations 2m 7s
    —Demo: Temporary Tables and Constraints 1m 7s
    —Demo: Temporary Tables and Indexes 1m 2s
    —Demo: Temporary Tables and IDENTITY columns 1m 21s
    —Demo: Temporary Tables and Transactions 1m 20s
    —Demo: Temporary Tables and Statistics 3m 7s
    Table Variables
    - 25m 58s
    Tempdb and Temporary Objects Planning
    - 11m 16s


Course Fee:
USD 29

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under Data & Information Management Community

Attended this course?

Back to Top

 
Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url