Member of the LearnItFirst.com Video Training Network Related Video Training Sites: · LearnDTS.com · LearnTransactSql.com
     
Email
Password
Register
LearnSqlServer2000.com LearnSqlServer2000.com
Watch our FREE SQL Server 2000 Video Tutorials

These free videos are just randomly chosen videos from our huge online library of SQL Server 2000 video tutorials and these are exactly the same videos you will get if you become a subscriber.
Want to get an email whenever we add new free videos?

Subscribe to our newsletter by creating a new account
FREE VIDEO #1: Database Diagrams - An Introduction
Watch Free Video

Author: Scott Whigham

Chapter: Administration: Tools, Utilities and Common Tasks
All experienced SQL developers and administrators recognize that being able to "see" your database gives you great confidence in the queries you write. It helps speed up development, ensure correct queries, and remove guesswork from the development cycle (well, as much as possible). This video shows you how you can create your own visual diagrams for your SQL Server database. These diagrams can be generated and viewed in the Enterprise Manager and can even be printed over multiple pages (which you will tape together and hang on your wall) for easier visualization. If you struggle with JOINs, subqueries, or foreign keys and relationships, then you'll enjoy this video on creating ERDs (Entity Relationship Diagrams) in SQL Server
Skill level: 100 (Beginner)
Length (MM:SS): 9:15
File size: 5.29MB
Link to Subscriber-Only Version: here
Watch Free Video


FREE VIDEO #2: An Overview of the Database Files - Data Files (MDF), the Transaction Log (LDF) and Additional Data Files (NDF)
Watch Free Video

Author: Scott Whigham

Chapter: Working with SQL Server Databases: Creation, Management and Best Practices
All SQL Server developers and administrators should have an excellent understanding of the file architecture for SQL databases. This video helps you learn about the different file types, their usage in SQL Server, and when and where to use the .NDF files (additional data files)
Skill level: 200 (Beginner - Intermediate)
Length (MM:SS): 4:53
File size: 3.26MB
Link to Subscriber-Only Version: here
Watch Free Video




View a list of videos available to Subscribers >> Subscribe here
AddThis Social Bookmark Button
     
Home | About Us | Advertising | Contact Us | Privacy | System Requirements | Terms and Conditions | Testimonials | Blogs | Site Map Refer a Friend and Get a Free Subscription!
© Copyright 2004-2007 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.
5/13/2008 5:11:38 AM