Member of the LearnItFirst.com Video Training Network Related Video Training Sites: · SQL Server DBA Tutorials · Integration Services Training
   
Transact SQL
                        Training Videos

An Overview of the AdventureWorks Database (Video Series)

Video Image 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:


Miscellaneous Bits & Pieces:
Security Tip: Do not allow applications to issue SELECT,INSERT,UPDATE, or DELETE statements to your database. Instead create a set of stored procedures and require that your applications use these "interfaces" into your database
Helpful Keyboard Shortcuts: "ALT" + "F4" closes the application or, if no applications are open, prompts you to shutdown/log off
Keyboard Shortcut for SQL Server Management Studio: CTRL+L shows the estimated execution plan

Other Websites We Offer
LearnIntegrationServices.com
Don't Forget!
Become a Guru
 
   
 
About Us Video Playback Subscriptions More Video Training More
 
© Copyright 2004-2008 LearnItFirst.com LLC. All rights reserved. All trademarks remain the property of their respective owners. This site is not affiliated in any way with the Microsoft Corporation. Refer a Friend and Get a Free Subscription!
 
11/20/2008 5:51:15 PM