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; Javascript, DHTML and 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

Product Spotlight »

Add Instant Mentoring to any new subscription for only $50! Click below for more info.

Read More

Monthly Special - Our best values!! »

We always offer several special offers with savings from $50-$100 & more! Check out this month's special offers...

Read More

© 1999-2008 SK Max. All rights reserved.

General IT Web Design Microsoft Certs


Desktop Computing Business Skills Personal Skills


Combo Packages Business Videos

Articles

Features

Instant Mentoring

Benefits

FAQs

HTML

A+

Windows 2000

Excel 2000

Office 2000

More Courses

e-Learning Links

Student Feedback

Certification Info

Other Resources

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