An Overview of the AdventureWorks Database - Video Series Video Category: Database Creation, Management and Best Practices 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:

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 Helpful Keyboard Shortcuts: "Windows key" + "M" + "Shift" restores all minimized windows Keyboard Shortcut for SQL Server Management Studio: F8 brings up the always-useful Object Explorer