Home » Course Catalog » Online Training Course Objectives and Outline
SQL Server 2000 Database Design MCSE 70-229 Series: Database Objects
Product Code: sql202 Time: 2.0 hour(s) CEUs: Available

Summary:

This course shows users how to create and alter tables, define data types, and ensure integrity by implementing constraints.

Objectives:

  • Create and alter database objects
  • Create and alter tables
  • Design and create constraints
  • Alter database objects to support replication


Topics:

  • Creating and altering database objects
  • Tables and data types
  • Creating tables
  • Modifying and deleting tables
  • System-supplied data types
  • User-defined data types
  • Designing attribute integrity
  • Cascading referential integrity/disabling constraints
  • Replication and data types
  • Generating column values
  • Creating DEFAULT and RULE objects

Technical Requirements:

P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Cookies enabled; Sound card with speakers or headphones strongly recommended.



Return To Top

Training Courses | e-Learning Edge | Training Course Certifications | Training Course Sign-up
Student Center | Learning Resources | Free Courses | Privacy Policy | Contact e-Learning Center

Hot Topics
IT Courses
MS Certs
Web Design
MS Office
Programming
Business
Networking
VS .NET
Personal
Full Catalog

Christian Website

Member of the Better Business Bureau Better Business Bureau
Member since 2002
Subscribe today as a member to our I.T. department and capitalize on free courses and 20% discount on our laptop computers.

Combo Packs... »

Save even more when you sign up for a combination package. Our BEST values EVER!

Read More

© 1599-2009 SK Max. All rights reserved.

General IT Web Design Microsoft Certs


Desktop Computing Business Skills Personal Skills


Combo Packages Business Videos

Articles

Features

Benefits

FAQs

e-Learning Links

e-Learning Forum

Certification Info

Other Resources

Home PageContact InformationSearch the Site
HomeOur Course Cataloge-Learning EdgeStudent Centere-ResourcesCorporate Information