Free Transact SQL Video Tutorial: Rapid Database Development Using Database Diagrams (SQL Server 2000)

Rapid Database Development Using Database Diagrams (SQL Server 2000) - download

This video tutorial shows you how to use the Enterprise Manager's Database Diagrams to create tables and manage constraints. Instead of having to manually create tables in the Enterprise Manager with the New Table dialog, you can use the Database Diagrams to do proof of concept and rapid database development (similar to rapid application development).

Highlights from this video:

• Customizing the Database Diagrams to include/exclude columns/metadata
• Adding Existing Tables to Layout
• Using the Save Change Script Option
• Explanations of what the asterisks mean in the Database Diagrams
• Create Foreign Keys Using the Drag-and-Drop features of the Database Diagrams

• Category: SQL Server Videobooks
• Skill Level: 100 (Beginner)
• Length: 8:57 (5.36MB)
• Source Videobook Entry (Subscriber-only version)

---

To download this video, visit the Free Videos page, click "download" and enter the correct security code.

Note: You must have the TSCC codec installed to view this video