CIS-054C SQL Server 2005
Database Design & Implementation

Note: This course will be next offered in January, 2008

Course Summary:

Virtually every commercially viable C# development project today involves data which is stored in a database. The obvious reason for this is that almost every meaningful project involves significant quantities of data and by far the best repository for storing and accessing data is a relational database.

Microsoft, the world's largest software vendor, is only in third position in the relational database market but its flagship database product, MS SQL Server is a first rate product capable of equivalent performance to databases from industry leaders Oracle and IBM. Microsoft has a good overview of the features of SQL Server 2005 at its website. Microsoft also has a nice demo to allow a more detailed view of these features.

This course will provide a comprehensive survey of SQL Server 2005 with a view to the Microsoft Certification Exam 70-229. Knowledge of a programming language such as C# or Visual Basic.NET is not required although programmers may select from some alternative exercises which are programming oriented.

C# / .NET Market Penetration

Course Outline

Course Syllabus

Course Schedule:

This class will be offered online only running from January 7 to March 21.

Textbook:

Microsoft, SQL Server 2000 Database Design and Implementation , Second Edition 2003 ISBN: 0735619603
Please read the first two chapters prior to the first class.
Michael Otey Microsoft SQL Server 2005 New Features, McGraw-Hill First Edition 2005 ISBN: 0072227761

Required Software:

After the fourth Monday of our class you can get a copy of SQL Server 2005 Developer Edition from Foothill for only a small administrative fee ($5). In the meantime, our textbook comes with a 120 day evaluation copy of SQL Server 2000 and SQL Server 2005 Express Edition is a free download from the Microsoft website. For a detailed explanation of how to get a copy of the required software for this course, see the Classroom Lesson entitled "Purchasing and Installing SQL Server 2005".

Course Preview

Login Instructions: Coming Soon

Proceed to Foothill Registration

Instructions for Requesting Late Adds (Only Relevant Starting on the First Day of the Term)

  1. Go to FoothillGlobalAccess and click on Request to Add for my course (CIS-054C).
  2. Wait a little while for me to grant your add code (could be a few hours).
  3. Then go to here, login and enter the reg code.