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

Instructor-Led Video Training for SQL Server 2005             * LearnTransactSql.com * LearnSqlServer.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 32 hours of SQL Server 2005 DBA 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 to SQL Server 2005 2 - Getting Started with SQL Server 2005 Express Editions 3 - Configuration: Services, Instances, Network Utilities, Network Libraries, Port Numbers and More 4 - SQL Server 2005 Administration: Tools, Utilities and Common Tasks 5 - Working with SQL Server 2005 Databases: Creation, Management and Best Practices 6 - Security in SQL Server 2005 7 - SQL Server Architecture: System Databases, System Tables, and SQL Server Internals 8 - T-SQL Basics: Queries, Datatypes, Collations and Unicode, and more 9 - Transact-SQL Basics: Stored Procedures, Functions, Triggers and more 10 - Performance Tuning SQL Server - Profiler, Tracing and Performance Monitoring 11 - Disaster Recovery: Backup, Recovery, Log Shipping, Clustering and Database Mirroring 12 - Automating SQL Server 2005 with the SQL Server Agent, Jobs, Alerts and Scheduling 13 - SSIS: SQL Server Integration Services and SSIS Package Management 14 - XML and SQL Server - FOR XML, SQLXML, MSXML, and More 15 - Replication in SQL Server 2005 16 - Introduction to SQL Server Reporting Services 17 - 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 to SQL Server 2005 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   300 (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 Utilities, Network Libraries, Port Numbers 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) SQL Server 2005 Services and Service Accounts - What They Do and What's New   200 Download Chapter 4 - SQL Server 2005 Administration: Tools, Utilities and Common Tasks Video/Series Title Skill View / Download Building a Custom MMC for Use with SQL     100 Download Creating Database Diagrams in SQL Server Management Studio   200 Download How to Upgrade The Documentation of SQL Server 2005 (Books Online)   100 Download My Favorite SSMS Tweak (by Scott Whigham)   100 Download ODBC, OLE-DB, UDLs and the SQL Native Client - Connecting to SQL Server and Making Reusabl...   200 Download SQL DBA 101: How to Quickly Schedule a Backup Job   200 Download Templates in SQL Server Management Studio - What They Are and How to Use Them   200 Download Chapter 5 - Working with SQL Server 2005 Databases: 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) An Overview of the AdventureWorksDW Database   200 Download An Overview of the Northwind Database   100 Download Database Compatibility Levels and sp_dbcmptlevel   300 Download Chapter 6 - Security in SQL Server 2005 Video/Series Title Skill View / Download Series (5 videos) - How to Synchronize Logins Across Multiple Servers   400 (Click for Videos) Chapter 7 - SQL Server Architecture: System Databases, System Tables, and SQL Server Internals Video/Series Title Skill View / Download Series (5 videos) - Understanding SQL Server Page Structure: How Page Splits Affect Perfor...   500 (Click for Videos) How SQL Server 2005 Uses the Registry and Changes to the Registry   400 Download How SQL Server Logs Errors - The SQL Server Error Log and Configuration   300 Download How to Change the Master Database's File Locations   500 Download Model Database - An Overview of How to Use It and When to Use It (SQL Server 2005)   300 Download TempDb Database - An Overview of How it Works and When to Use It   300 Download Chapter 8 - T-SQL Basics: Queries, Datatypes, Collations and Unicode, and more Video/Series Title Skill View / Download Series (2 videos) - Common Table Expressions (CTEs) in SQL Server 2005   300 (Click for Videos) 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 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 Performance Tuning Query Tips That Everyone Should Know - Using DBCC and SET Commands   300 Download Scoping of SET Commands - Connections, Stored Procedures, Batches and Functions   200 Download SET Commands for Performance Tuning and Query Execution Statistics   300 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 9 - Transact-SQL Basics: Stored Procedures, Functions, Triggers and more Video/Series Title Skill View / Download Series (5 videos) - Stored Procedures - An Introduction to Syntax, Concepts and Usage   200 (Click for Videos) Chapter 10 - Performance Tuning SQL Server - Profiler, Tracing and Performance Monitoring Video/Series Title Skill View / Download Series (5 videos) - Using Profiler in SQL Server 2005   300 (Click for Videos) Chapter 11 - Disaster Recovery: Backup, Recovery, Log Shipping, Clustering and Database Mirroring Video/Series Title Skill View / Download Series (2 videos) - Failing Over and How Failover Works in a Clustered Environment   500 (Click for Videos) Series (2 videos) - Installing Service Packs In Your Clustered SQL Server Environment   500 (Click for Videos) Series (2 videos) - Introduction to SQL Server Clustering - Terms and Concepts   400 (Click for Videos) Series (4 videos) - Installing an Active/Passive SQL Server Cluster   500 (Click for Videos) Series (8 videos) - Log Shipping With SQL Server 2005   400 (Click for Videos) SQL Server 2005 Transaction Log Is Full - log_reuse_wait_desc and sys.databases Error   300 Download Chapter 12 - Automating SQL Server 2005 with the SQL Server Agent, Jobs, Alerts and Scheduling Video/Series Title Skill View / Download Series (4 videos) - Maintenance Plans in SQL Server 2005   100 (Click for Videos) Chapter 13 - SSIS: SQL Server Integration Services and SSIS Package Management Video/Series Title Skill View / Download Pt. 1- Introduction to SQL Server 2005's Integration Services   200 Download Pt. 2 - Creating Your First SSIS Packages (Integration Services Packages)   200 Download Pt. 3 - Introduction to SSIS Package Deployment   200 Download Pt. 4 - How to Schedule an SSIS Package (Introduction)   200 Download Chapter 14 - XML and SQL Server - FOR XML, SQLXML, MSXML, and More