This video is from our "SQL Server Programming (SQL Server 2005/2000): Transact SQL" course
Visit the course home page for full details (such as the videos in the course, free videos for the course, and more)

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

Skill level: 100 (Beginner)
Run Time: 8:57
Instructor: Scott Whigham

Description:

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

Download and watch this video

NOTE: You will need the TSCC codec installed to view video

Instructor
Related Videos
Related Courses
Other Videos in this Chapter

Scott Whigham

Scott Whigham is the founder of LearnItFirst.com, one of the web's most extensive video training libraries focusing on technical training. Scott is also an experienced consultant, trainer, and author with more than a decade of hands-on experience working with SQL Server databases, writing and debugging applications using Visual Studio, and performance tuning. Scott designed the architecture (websites, class libraries, and database) for the LearnItFirst.com websites and, most re... (Scott's full bio can be found here)

Video titleSkill

Constraint Keys, Index Keys, Composite Keys, Natural keys, and Surrogate Keys	200	Download
Subqueries, Nested Queries, and Derived Tables - An Introduction to Advanced SQL Constructs	300	Download
When to Use HAVING Instead of WHERE - Aggregates, GROUP BY, and the HAVING Clause	300	Download
JOINs - An Overview of the Five Types of JOINs (Cross, Outer, and Inner)	200	Download
JOINs and UNIONs - How Do I Know When to Use a JOIN or a UNION?	300	Download

CourseRun TimeSkill Level

148 - SQL Server 2000 Database Administration	200-500	20+ hrs
152 - SQL Server 2005 Database Administration	200-500	30+ hrs
157 - SQL Server 2008 Database Administration	200-500	45+ hrs
154 - SQL Server 2005 Reporting Services	200-500	17+ hrs
153 - SQL Server 2005 Integration Services	200-500	31+ hrs

Chapter 1: The Development Environment - Tools, Code Generation, and More

1	Creating Database Diagrams in SQL Server Management Studio
2	How to Upgrade The Documentation of SQL Server 2005 (Books Online)
3	Templates in SQL Server Management Studio - What They Are and How to Use Them
4	Interactive Help and Books Online - Using Context-Sensitive Help (SQL Server 2000)
	Rapid Database Development Using Database Diagrams (SQL Server 2000)
6	How to Get the Most Out of SSMS: Understanding the Tabbed Environment
7	Pt. 1 - An Introduction to SQL Server Management Studio (SSMS)
8	Pt. 2 - SQL Server Management Studio (SSMS) Functionality and Available Options (Including Writing Queries)
9	Pt. 3 - Changing Table Design and Properties; Using the Query Designer in SSMS
10	Pt. 4 - Viewing Reports; Configuring and Viewing the SQL Server and Windows Application Event Log
11	Pt. 1 - Installation and Configuration of the SQL Server 2005 Sample Applications for SQL, Reporting Services, C#, VB, and SSIS
12	Pt. 2 - More Samples and How to Get the Sample Applications to Compile Using an .snk File

NOTE: This video is part of our SQL Server Programming (SQL Server 2005/2000): Transact SQL course.
This video is from Chapter 1: The Development Environment - Tools, Code Generation, and More

Login

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

Description:

Scott Whigham