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

Instructor-Led Video Training for SQL Server 2000             * LearnDTS.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 20 hours of SQL Server 2000 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 2000 2 - Configuration: Services, Instances, Network Utilities, Network Libraries, Port Numbers and More 3 - Administration: Tools, Utilities and Common Tasks 4 - Working with SQL Server Databases: Creation, Management and Best Practices 5 - SQL Server Security 6 - SQL Server Architecture: System Databases, System Tables, and SQL Server Internals 7 - T-SQL Basics: Queries, Datatypes, Collations and Unicode, and more 8 - TSQL Programming: Stored Procedures, Variables, Functions and Triggers 9 - SQL Server Architecture: Indexes, Internals, and Query Plans 10 - Performance Tuning SQL Server - Profiler, Tracing and Performance Monitoring 11 - Backup, Recovery, Log Shipping and More - Disaster Recovery for SQL Server 2000 12 - Automating SQL Server 2000 with the SQL Server Agent, Jobs, Alerts and Scheduling 13 - How to Move and Copy Databases in SQL Server 2000 14 - Replication in SQL Server 2000 Browse Videos By: Staff Picks Tag Cloud Videos You Have Not Downloaded Ordered By Skill Level By Software Version/Edition Chapters orange = video series  blue = individual videos  Chapter 1 - Installing, Deploying, and Upgrading to SQL Server 2000 Video/Series Title Skill View / Download Series (2 videos) - Installing Service Pack 4 for SQL Server 2000   200 (Click for Videos) Series (5 videos) - In-Depth Discussion of SQL Server 2000 Installation   300 (Click for Videos) Install Named Instance and View Files and Folders   200 Download Installing SQL Server 2000 - Basic Overview   100 Download Reason to Install SP3 - Buffer Overflow Attack using OPENROWSET   500 Download Chapter 2 - Configuration: Services, Instances, Network Utilities, Network Libraries, Port Numbers and More Video/Series Title Skill View / Download How to Change the SQL Server TCP IP Port Number Using the Server Network Utility   500 Download Multiple Instances - Lecture on When They're Appropriate and Special Considerations   200 Download SQL Server's Services - MSSQLSERVER, SQLAGENT, MSDTC and more   200 Download Using Aliases and the Client Network Utility   300 Download Chapter 3 - Administration: Tools, Utilities and Common Tasks Video/Series Title Skill View / Download Series (3 videos) - Migrating Microsoft Access Tables to SQL Server Using DTS and SSIS   300 (Click for Videos) Series (5 videos) - How to Migrate From Microsoft Access to SQL Server   200 (Click for Videos) Building a Customized Microsoft Management Console (MMC) for Use with SQL Server   200 Download Database Diagrams - An Introduction     100 Download Enterprise Manager - Registering a server   100 Download How to Upgrade The Documentation of SQL Server 2000 (Books Online)   200 Download ODBC, DSNs, and UDLs - Creating Reusable Connection Information   200 Download OSQL - What It Is and How to Use It   200 Download Part 1 - An Overview of the Enterprise Manager for SQL Server 2000   100 Download Query Analyzer - Beyond the Basics (SQL Server 2000)   200 Download Chapter 4 - Working with SQL Server Databases: Creation, Management and Best Practices Video/Series Title Skill View / Download An Overview of the Database Files - Data Files (MDF), the Transaction Log (LDF) and Additi...     200 Download Creating Databases with the SQL Server Enterprise Manager   200 Download Creating Our First Database - Three Techniques   100 Download Database Compatibility Levels and sp_dbcmptlevel   300 Download Enterprise Manager - Put Table On Filegroup   400 Download How to Increase a Database's Size - Multiple Techniques for Increasing Data File and Trans...   300 Download How to Increase a Database's Size Using the SQL Server Enterprise Manager   200 Download Setting Database Options Using the Enterprise Manager - Setting the Database State Options   300 Download Shrinking Database Files and Removing Space from Your SQL Server Database (Using Enterpris...   300 Download Chapter 5 - SQL Server Security Video/Series Title Skill View / Download Series (2 videos) - Choosing the Right Authentication Mode and Network Libraries for Your ...   200 (Click for Videos) Series (2 videos) - Cross Database Ownership Chaining   300 (Click for Videos) Series (2 videos) - How to Change SQL Server Authentication Mode with a Discussion on Diff...   300 (Click for Videos) An Overview of the Fixed Server Roles for SQL Server 2000   300 Download Creating SQL Server Authentication Logins in the Enterprise Manager   200 Download Creating Windows Authentication Logins in the Enterprise Manager   200 Download Peculiarities of the Database Role ddl_admin   400 Download Schemas, Objects, and Ownership in SQL Server 2000   100 Download Some Dangerous Stored Procedures - xp_cmdshell, sp_OACreate, and sp_enum_dtspackages   400 Download SQL Server Authentication - SIDs, sysxlogins, syslogins and the Architecture of SQL Server...   300 Download Chapter 6 - SQL Server Architecture: System Databases, System Tables, and SQL Server Internals Video/Series Title Skill View / Download Master Database - An Overview of Some of the Common System Tables and Objects   300 Download Model Database - An Overview of How to Use It and When to Use It (SQL Server 2000)   200 Download MSDB Database - An Overview of Some of the Common System Tables and Objects   300 Download Chapter 7 - T-SQL Basics: Queries, Datatypes, Collations and Unicode, and more Video/Series Title Skill View / Download Series (4 videos) - Views in SQL Server - What They Are and When to Use Them   100 (Click for Videos) Aliasing in Queries - What It Is and How to Use It (SQL Server 2000)   100 Download 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 Creating and Altering Views in the Enterprise Manager (SQL Server 2000)   200 Download Creating Linked Servers to Microsoft Access (SQL Server 2000)   400 Download Customizing SQL Server with International Error Messages and How SQL Server 2000 Uses the ...   400 Download Defaults and Rules in SQL Server 2000 - What They Are, How to Use Them and Best Practices   300 Download Extended Properties in SQL Server 2000 - What They Are and How to Use Them to Generate You...   300 Download How to Return Identity Value for a Just-Inserted Row   200 Download Interactive Help and Books Online - Using Context-Sensitive Help (SQL Server 2000)   100 Download Linked Servers - How to Query Microsoft Excel Named Ranges and Worksheets (SQL Server 2000...   400 Download Rapid Database Development Using Database Diagrams (SQL Server 2000)   100 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 Stored Procedure Introduction: Definition, Usage, and Creating Stored Procedures Using the...   100 Download Using Linked Servers In Your SQL Server SELECT Statement (SQL Server 2000)   300 Download Views: Introduction, When and Where to Use, and Using the Create View Wizard   100 Download Working with User Defined Data Types in the Enterprise Manager (SQL Server 2000)   200 Download Chapter 8 - TSQL Programming: Stored Procedures, Variables, Functions and Triggers Video/Series Title Skill View / Download Series (5 videos) - Stored Procedures - An Introduction to Syntax, Concepts and Usage   200 (Click for Videos) Variables and Scoping - Local Variables and Batch Terminators   200 Download Why You Use SCOPE_IDENTITY() Instead of @@IDENTITY   300 Download Chapter 9 - SQL Server Architecture: Indexes, Internals, and Query Plans Video/Series Title Skill View / Download Constraint Keys, Index Keys, Composite Keys, Natural keys, and Surrogate Keys   200 Download Pages, Extents, and Blocksizes - What They Are and How They Work   300 Download Using the Create Index Wizard in the Enterprise Manager (SQL Server 2000)   200 Download Chapter 10 - Performance Tuning SQL Server - Profiler, Tracing and Performance Monitoring Video/Series Title Skill View / Download Series (4 videos) - Using Profiler in SQL Server 2000   300 (Click for Videos)