Rapid Database Development Using Database Diagrams (SQL Server 2000) - view details
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
- Source: http://www.learnitfirst.com/Course/148/Video/431/Rapid-Database-Development-Using-Database-Diagrams.aspx
- Course: http://www.learnitfirst.com/Course/148/SQL-Server-2000-DBA.aspx
- Skill Level: 100 (Beginner)
- Length: 8:57 (5.36MB)
- Full Details
To download this video, log in then then visit the video's detail page and click "download".
Keywords for this video: hide columns, meta data, rad tool, rdd tool, beginner, beginning, for beginners, introduction, step by step
This video comes from the SQL Server 2000 DBA online training course, SQL Server 2000 Database Administration. And be sure to check out even more MSSQL Server 2000 training videos.
