Member of the LearnItFirst.com Video Training Network	Related Video Training Sites: · SQL Server DBA Tutorials · Integration Services Training

Transact SQL Training Videos             * SQL Server DBA Tutorials * Integration Services Training * More Videobooks... Search My Account More Videobooks Sign in Home FREE Video Tutorials Subscriber Video Tutorials Subscriptions FAQs Our Other Sites About Us Because we have over 35 hours of TSQL training videos available to subscribers, we have arranged the videos on this page by category. Click the blue or orange links below to drill down for more details about a video/series. You may also click the white category names themselves. NOTE: You will need the TSCC codec installed to view our videos. -- Select Category -- 1 - The Development Environment - Tools, Code Generation, and More 2 - The Transact-SQL Language - An Introduction to Common Terms, Tools, and Techniques in TSQL 3 - Table Design - Datatypes, Constraints, IDENTITY Columns, Normalization, and More 4 - SELECT, INSERT, UPDATE and DELETE - Data Manipulation Language 5 - Aggregating Data Using DISTINCT, GROUP BY, HAVING, ROLLUP, CUBE and more 6 - JOINs and UNIONs - Working with Multiple Tables 7 - Commonly Used T-SQL Constructs: Datatypes, Type Conversion, Variables, System Functions and Views and more 8 - Index Design, Plan Guides, Execution Plans and Query Plans for SQL Server: Performance Tuning Your Queries 9 - Subqueries, Nested Queries, and Derived Tables in Transact SQL 10 - Server-Side Storage: Temp Tables, Table Variables, Cursors and More 11 - Stored Procedure Programming, Error Handling, and Passing Resultsets to the Client 12 - Views in SQL Server 13 - User-Defined Functions (UDFs) in SQL Server 14 - Dynamic Data Source Queries - How to Write Distributed Data Queries Using Linked Servers and more 15 - XML and SQL Server - FOR XML, SQLXML, MSXML, and More 16 - Design Patterns for Transact-SQL 17 - Misc Stuff That Just Doesn't Fit Anywhere Else Browse Videos By: Search for videos - By Keyword Search for Videos - By Tag Tag Cloud Staff Picks Ordered By Skill Level Videos You Have Not Downloaded Chapters orange = video series  blue = individual videos  Chapter 1 - The Development Environment - Tools, Code Generation, and More Video/Series Title Skill View / Download Series (2 videos) - How to Install and Configure the SQL Server 2005 and C# Sample Applica...   200 (Click for Videos) Series (4 videos) - An Introduction to the SQL Server Management Studio (SSMS)   200 (Click for Videos) Creating Database Diagrams in SQL Server Management Studio   200 Download How to Get the Most Out of SSMS: Understanding the Tabbed Environment   100 Download How to Upgrade The Documentation of SQL Server 2005 (Books Online)   100 Download Interactive Help and Books Online - Using Context-Sensitive Help (SQL Server 2000)   100 Download Query Analyzer - Beyond the Basics (SQL Server 2000)   200 Download Rapid Database Development Using Database Diagrams (SQL Server 2000)   100 Download Templates in SQL Server Management Studio - What They Are and How to Use Them   200 Download Chapter 2 - The Transact-SQL Language - An Introduction to Common Terms, Tools, and Techniques in TSQL Video/Series Title Skill View / Download Series (2 videos) - An Overview of the AdventureWorks Database   100 (Click for Videos) Series (3 videos) - An Introduction to Schemas in SQL Server 2005 and SQL Server 2008   300 (Click for Videos) An Overview of the AdventureWorksDW Database   200 Download An Overview of the Northwind Database   100 Download COLLATE and How Queries and Table Data Work with Case-Sensitive and Accent-Sensitive Data   300 Download Constraint Keys, Index Keys, Composite Keys, Natural keys, and Surrogate Keys   200 Download Database Diagrams - An Introduction   100 Download Model Database - An Overview of How to Use It and When to Use It (SQL Server 2005)   300 Download Pages, Extents, and Blocksizes - What They Are and How They Work   300 Download Resultsets, Recordsets, and the Client Server model (SQL Server 2000)   100 Download Scalar, System, Built-In and Niladic Functions - What They Are and How to Use Them (SQL Se...   200 Download SQL Server Internals - The Steps SQL Server Goes Through to Run a Command   200 Download SQL Standards - ISO, ANSI, and Transact-SQL's Implementation of the Various Standards   300 Download TempDb Database - An Overview of How it Works and When to Use It   300 Download Chapter 3 - Table Design - Datatypes, Constraints, IDENTITY Columns, Normalization, and More Video/Series Title Skill View / Download Series (10 videos) - Data Type Overview - Order of Precendence, Using CAST and CONVERT, an...   300 (Click for Videos) Series (2 videos) - A Lecture on Using IDENTITY Columns in Table Design and Surrogate Keys   100 (Click for Videos) Auto-Numbering Rows with IDENTITY Columns - How Identity Columns Work   200 Download Collations, Character Sets, Code Pages, and Sort Orders - How String Data Works in SQL Ser...   300 Download How to Return Identity Value for a Just-Inserted Row   200 Download Naming Conventions for SQL Server Tables Constraints and Indexes (SQL Server 2000)   200 Download Should I use a Check Constraint or a Foreign Key - Best Practices and Design (SQL Server 2...   300 Download Using Defaults to Avoid Using NULLs in Your Database (SQL Server 2000)   200 Download What Are Computed Columns (a.k.a. Derived Fields)? When Should I Use Them?   300 Download Why You Use SCOPE_IDENTITY() Instead of @@IDENTITY   300 Download Working with User Defined Data Types in the Enterprise Manager (SQL Server 2000)   200 Download Chapter 4 - SELECT, INSERT, UPDATE and DELETE - Data Manipulation Language Video/Series Title Skill View / Download Series (2 videos) - Using the OUTPUT Clause With the INSERT, UPDATE, and DELETE Statement   300 (Click for Videos) Series (4 videos) - An Overview of the INSERT Statement   100 (Click for Videos) Series (4 videos) - An Overview of the UPDATE Statement   200 (Click for Videos) Series (5 videos) - An Overview of the DELETE Statement   300 (Click for Videos) Series (7 videos) - A Lengthy Overview of the SELECT Statement   100 (Click for Videos) Aliasing in Queries - What It Is and How to Use It (SQL Server 2000)   100 Download How to Add In a Row Number Column That Numbers the Rows of Your Result Set   200 Download What Is Modulo? When Would I Use It?   300 Download Chapter 5 - Aggregating Data Using DISTINCT, GROUP BY, HAVING, ROLLUP, CUBE and more Video/Series Title Skill View / Download A Comparison of DISTINCT and GROUP BY: When to Use Each     200 Download The Basics of the HAVING Clause   300 Download When to Use HAVING Instead of WHERE - Aggregates, GROUP BY, and the HAVING Clause   300 Download Chapter 6 - JOINs and UNIONs - Working with Multiple Tables Video/Series Title Skill View / Download EXCEPT and INTERSECT - An Introduction to Syntax and Concepts   300 Download JOIN Syntaxes - Should You Use ANSI-89 or ANSI-92 Join Syntax?   300 Download JOINs - An Overview of the Five Types of JOINs (Cross, Outer, and Inner)   200 Download JOINs and UNIONs - How Do I Know When to Use a JOIN or a UNION?   300 Download UNION Queries - What They Are and How to Use Them (SQL Server 2000)   200 Download Chapter 7 - Commonly Used T-SQL Constructs: Datatypes, Type Conversion, Variables, System Functions and Views and more Video/Series Title Skill View / Download Series (5 videos) - Control-of-Flow Language in Transact-SQL   200 (Click for Videos) Series (6 videos) - Transact-SQL SET Commands - An Overview of the Most Commonly Used SET ...