An Overview of the AdventureWorks Database - Video Series Video Category: The Transact-SQL Language - An Introduction to Common Terms, Tools, and Techniques in TSQL Skill Level: 100 (Beginner) Versions/Editions Covered: SQL Server 2005 AdventureWorks is a very important database in SQL Server 2005 because it (a) is designed to show you how to (correctly) use many of the new features in SQL Server 2005 (as befits a sample database from Microsoft), and (b) it is used in most of the examples in the Books Online, and (c) because so many people use AdventureWorks in their demos! This video series walks you through the AdventureWorks architecture and tries to make sense of it all. AdventureWorks can be intimidating for someone new to SQL Server 2005 but, after watching this series of videos, you'll have a much stronger knowledge of the design and decisions in AdventureWorks.

Videos in this Series:

Title Skill Length Download Part 1 - An Overview of the AdventureWorks Database   100 17 mins. Download Part 2 - An Overview of the AdventureWorks Database - Database Diagrams and DDL ...   200 12 mins. Download

< Return to list of all videos

Miscellaneous Bits & Pieces:

Keyboard Shortcut for SQL Server Management Studio: F4 displays the properties window Want to see something cool? Run SELECT cacheobjtype, objtype, pagesused, sql FROM master.dbo.syscacheobjects ORDER BY pagesused DESC You can disable the "sa" account by setting your SQL Server security mode to Windows Authentication Only. You will still have an "sa" account but it will not be able to log in to your SQL Server