Microsoft SQL Server 2000 Database Design- Data Modeling, Database Creation

computer training tutorials Computer Training

Course List
Value Packages
Site Map
Microsoft Certification
Free Training

Online Training Series:
SQL Server 2000 Training

> SQL Server 2000 Database Design MCSE 70-229 > Data Modeling and Database Creation

This SQL Server 2000 Database Design MCSE 70-229 Training Course on Data Modeling and Database Creation is part of a 9 course, 21 hour online training series. This complete online training series can be purchased for only $59.95.



Length: 4 Hour

Summary:
This online tutorial provides students with an overview of data modeling with an emphasis on relational database systems, and shows users how to implement a logical design by creating a database in SQL Server 2000.

Objectives:
After completing this course, students will be able to:

  • Gather database requirements
  • Build a logical data model
  • Create and alter databases, files, and filegroups
  • View and change database properties and options
Outline:
  • Data modeling
  • Logical design
  • Components of the logical model
  • Entity relationships
  • Normalization
  • Data integrity and constraints
  • Physical design considerations
  • The SQL Server 2000 software
  • System files and tables
  • Database files and filegroups
  • Creating a database
  • Altering a database
  • Other database modifications
  • Useful functions and stored procedures
Features:
  • Exercises that allow users to practice the application
  • A file containing the text of the exercises
  • Activities that allow users to apply course concepts in an interactive questioning environment
  • Online computer glossary
  • Online skill assessment testing
Applicability:

This course is for anyone preparing for Microsoft Exam 70-229: "Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition."

Prerequisites: None

Technical Requirements: (Minimum)
  • Computer: 200MHz Pentium with 32MB Ram. 640 x 480 256-color video
  • Operating System: Windows 95, 98, NT, ME, 2000, or XP.
  • Minimum Connection Speed: 28.8k.
  • Browser: Internet Explorer 5.0 or higher required.
  • Authorware and Macromedia Flash player recommended but not required.
  • JavaScript must be enabled.
  • Netscape and AOL browsers not supported.

Need help or have questions about SQL Server 2000 Database Design MCSE 70-229? How about 24x7 access worldwide to our instructors! Now you can get answers from real experts within minutes via our online chat service. For just $40.00 additional you add our Instant Mentoring service and get your SQL Server 2000 Database Design MCSE 70-229 training courses questions quickly answered anytime from anywhere.

You might also be interested in our Microsoft Certifications Package which includes all of our SQL Server 2000 Database Design MCSE 70-229 courses plus over 800 hours of additional courses.

Retake any or all of our computer training as often as you want. Our online tutorials allow you to learn anywhere, anytime from any computer with internet access. All courses allow for 1 year unlimited access (1 user), includes a variety of features and all courses qualify for Continuing Education Units - CEU credit..
continuing education unit CEU credit

StaffKit is a worldwide leader in providing computer training, online tutorials and career education. StaffKit has satisifed customers in over 30 countries.

online training
Back to SQL Server 2000 Database Design MCSE 70-229 Training

About Us
News
Contact Us
Features
Certification

Reviews:

With only an Internet browser and a dial-up connection you can access over 4,000 hours of courseware, anytime, anywhere, for one full year.
MidWest Technology Journal

"If you are looking to get certification this is a must have resource."
TheTechMag.com

Read more customer reviews about our e-learning training tutorials.

e-learning tutorial