Member of the LearnItFirst.com Video Training Network	Related Video Training Sites: · LearnIntegrationServices.com · LearnTransactSql.com

Instructor-Led Video Training for SQL Server             * LearnIntegrationServices.com * LearnTransactSql.com * More Videobooks... Search My Account Log in More Videos Home FREE Video Tutorials Subscriber Video Tutorials Subscriptions FAQs Our Other Sites About Us Because we have over 42 hours of SQL Server 2005 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 - Installing, Deploying, and Upgrading SQL Server 2 - Getting Started with SQL Server 2005 Express Editions 3 - Configuration: Services, Instances, Network Libraries, and More 4 - Tools, Utilities and Common Tasks for Managing SQL Server 5 - Database Creation, Management and Best Practices 6 - Transact-SQL Basics: Queries, Stored Procedures, Functions and more 7 - Monitoring and Performance Tuning SQL Server 8 - Architecture: System Databases, System Tables, and SQL Server Internals 9 - Security for SQL Server: Logins, Users, Roles and More 10 - Disaster Recovery: Backup, Recovery, Clustering, Mirroring, Log Shipping 11 - Automating SQL Server: SQL Server Agent, Jobs, Email, Alerts and Scheduling 12 - Introduction to SQL Server Reporting Services 13 - SSIS: SQL Server Integration Services and SSIS Package Management 14 - Replication in SQL Server 15 - XML and SQL Server - FOR XML, SQLXML, MSXML, and More 16 - Miscellaneous - Topics That Do Not Fit Anywhere Else! Browse Videos By: Staff Picks Tag Cloud Videos You Have Not Downloaded Ordered By Skill Level By Software Version/Edition New Videos Chapters orange = video series  blue = individual videos  Chapter 1 - Installing, Deploying, and Upgrading SQL Server Video/Series Title Skill View / Download Series (2 videos) - Looking at a Default Installation of SQL Server 2005   200 (Click for Videos) Series (4 videos) - Running The SQL Server 2005 Upgrade Advisor   200 (Click for Videos) Series (5 videos) - Installing SQL Server 2005 SP2: A Look at the Installation and New Fea...   100 (Click for Videos) Series (7 videos) - Installing SQL Server 2005 for the First Time (SQL Server 2005 Setup)   200 (Click for Videos) Chapter 2 - Getting Started with SQL Server 2005 Express Editions Video/Series Title Skill View / Download Series (4 videos) - Installing SQL Server Express Edition on Windows Vista   200 (Click for Videos) Series (5 videos) - SQL Server Express Editions - Installation and Management   200 (Click for Videos) Migrating From Express Edition to SQL Server Enterprise/Standard/et al   200 Download What Are the Express Editions?   100 Download Chapter 3 - Configuration: Services, Instances, Network Libraries, and More Video/Series Title Skill View / Download Series (6 videos) - Network Libraries, TCP/IP Ports and Configuring SQL Server for Remote ...   400 (Click for Videos) Multiple Instances - Lecture on When They're Appropriate and Special Considerations   200 Download SQL Server 2005 Services and Service Accounts - What They Do and What's New   200 Download Chapter 4 - Tools, Utilities and Common Tasks for Managing SQL Server Video/Series Title Skill View / Download Building a Custom MMC for Use with SQL     100 Download Building a Customized Microsoft Management Console (MMC) for Use with SQL Server   200 Download Creating Database Diagrams in SQL Server Management Studio   200 Download Database Diagrams - An Introduction   100 Download How to Upgrade The Documentation of SQL Server 2005 (Books Online)   100 Download My Favorite SSMS Tweak (by Scott Whigham)   100 Download ODBC, DSNs, and UDLs - Creating Reusable Connection Information   200 Download ODBC, OLE-DB, UDLs and the SQL Native Client - Connecting to SQL Server and Making Reusabl...   200 Download Templates in SQL Server Management Studio - What They Are and How to Use Them   200 Download Chapter 5 - Database Creation, Management and Best Practices Video/Series Title Skill View / Download Series (2 videos) - An Overview of the AdventureWorks Database   100 (Click for Videos) Series (5 videos) - How to Move and Copy Databases to a New Server/Instance   300 (Click for Videos) Series (5 videos) - How to Synchronize Logins Across Multiple Servers   400 (Click for Videos) An Overview of the AdventureWorksDW Database   200 Download An Overview of the Database Files - Data Files (MDF), the Transaction Log (LDF) and Additi...   200 Download An Overview of the Northwind Database   100 Download Database Compatibility Levels and sp_dbcmptlevel   300 Download Chapter 6 - Transact-SQL Basics: Queries, Stored Procedures, Functions and more Video/Series Title Skill View / Download Series (2 videos) - Common Table Expressions (CTEs) in SQL Server 2005   300 (Click for Videos) Series (2 videos) - Using Output Parameters in Your SQL Server Stored Procedures   300 (Click for Videos) Series (3 videos) - Return Values and SQL Server Stored Procedures   200 (Click for Videos) Series (4 videos) - Views in SQL Server - What They Are and When to Use Them   100 (Click for Videos) Series (5 videos) - Stored Procedures - An Introduction to Syntax, Concepts and Usage   200 (Click for Videos) Series (6 videos) - Introduction to DML Triggers : AFTER and INSTEAD OF   300 (Click for Videos) Auto-Numbering Rows with IDENTITY Columns - How Identity Columns Work   200 Download COLLATE and How Queries and Table Data Work with Case-Sensitive and Accent-Sensitive Data   300 Download Collations, Character Sets, Code Pages, and Sort Orders - How String Data Works in SQL Ser...   300 Download Constraint Keys, Index Keys, Composite Keys, Natural keys, and Surrogate Keys   200 Download Design Patterns and SQL Programming - How You Can Use Patterns to Simplify Your Life   200 Download EXCEPT and INTERSECT - An Introduction to Syntax and Concepts   300 Download How to Return Identity Value for a Just-Inserted Row   200 Download JOINs and UNIONs - How Do I Know When to Use a JOIN or a UNION?   300 Download Overview of SET Commands in Transact-SQL - What They Are, Syntax, and How to Use Them   200 Download Result sets, Recordsets, and the Client Server model   100 Download Scalar, System, Built-In and Niladic Functions - What They Are and How to Use Them   200 Download Scoping of SET Commands - Connections, Stored Procedures, Batches and Functions   200 Download TOP Operator: What's New and Why Life Is much Easier Today   200 Download Using the PIVOT Operator - An introduction to PIVOT Tables and Crosstab Queries with PIVOT   300 Download Using the UNPIVOT Operator to Normalize Denormalized Tables and Datasets   300 Download Variables - Understanding the Difference Between Using SET and SELECT to Assign Values   200 Download Variables and Scoping - Local Variables and Batch Terminators   200 Download When to Use HAVING Instead of WHERE - Aggregates, GROUP BY, and the HAVING Clause   300 Download Why You Use SCOPE_IDENTITY() Instead of @@IDENTITY   300 Download Chapter 7 - Monitoring and Performance Tuning SQL Server Video/Series Title Skill View / Download Series (4 videos) - Using Dynamic Management Views (DMVs) to Monitor Blocking and Transact...   400 (Click for Videos) Series (5 videos) - Using Profiler in SQL Server 2005   200 (Click for Videos) Performance Tuning Query Tips That Everyone Should Know - Using DBCC and SET Commands   300 Download SET Commands for Performance Tuning and Query Execution Statistics   300 Download Chapter 8 - Architecture: System Databases, System Tables, and SQL Server Internals Video/Series Title Skill View / Download Series (3 videos) - A Deeper Look at Pages and Extents Using SQL Internals Viewer   500 (Click for Videos) Series (5 videos) - Understanding SQL Server Page Structure: How Page Splits Affect Perfor...   500 (Click for Videos)