Whoops! Something went wrong.

Click here to refresh the page
18 Downloads

SQL Server Table Design

SQL Server Table Design
Resource Type
Product Rating
File Type

Word Document File

Be sure that you have an application to open this file type before downloading and/or purchasing.

365 KB|17 pages
Share
Product Description
Objectives:
• Constraints
• Normalization
• Opening SQL Server 2008
• System Databases
• SQL Server Database Structure
• Database Files
• File Groups
• Creating a Database
• Moving Databases
• Detaching Databases
• Attaching a Database
• Designing Tables
• Data Types
• Column Properties
• Dropping Tables
• Creating a Table with a Computed Column
• Adding a Computed Column to an existing Table
• Sparse Columns
• Creating Tables with Primary Keys
• Adding a Primary Key to an existing Table
• Creating a Table with an UNIQUE constraint
• Creating a Table with a CHECK constraint
• Adding a CHECK constraint to an existing table
• Default Constraints
• Foreign Keys
• Database Diagrams
Total Pages
17 pages
Answer Key
N/A
Teaching Duration
1 hour
Report this Resource
Loading...
FREE
Digital Download
avatar

Jason Sim

0 Followers
Follow
More products from Jason Sim
Product Thumbnail
Product Thumbnail
Product Thumbnail
Product Thumbnail
Product Thumbnail
FREE
Digital Download
Teachers Pay Teachers

Teachers Pay Teachers is an online marketplace where teachers buy and sell original educational materials.

Learn More

Keep in Touch!

Sign up