SQL Server FAST TRACK - Temp Tables and Table Variables
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
- Preview02:34
- Preview10:01
- 05:10Temp Table Example 2 - Persistence and STORED PROCEDURES
- 08:53Temp Table Example 3 - Persistence - TSQL vs STORED PROCEDURES
- 06:09Temp Table Example 4 - Command Line TSQL
- 09:33Temp Table Example 5 - Command Line TSQL with IF EXISTS and DROP TABLE
- 05:53Temp Table Example 6 - Command Line TSQL with IDENTITY
- 06:16Temp Table Example 7 - STORED PROCEDURE
- 10:39Temp Table Example 8 - STORED PROCEDURE - IF EXISTS and DROP TABLE?
- 06:08Temp Table Example 9 - Command Line TSQL vs STORED PROCEDURE
- 11:05Temp Table Example 10 – TEMP TABLES vs REAL TABLES
- 10 questionsSECTION 1 - REVIEW QUIZ
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
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 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.