SQL Server 2005 Database Design & Implementation Syllabus



Prerequisites:
Some familiarity with any programming language and the Microsoft Windows operating systems.
Internet access and an Email account.

Instructor:
Steve Hoyle
Email: spookinet@comcast.net
NOTE: Always put CIS-054C in the Subject Box of your Email.

Weekly Minimum Workload:
Four hours lecture
Four hours computer time

Required Software:
Windows 2000/XP/Vista
File compression software (i.e., PKZip or WinZip)

Required Textbooks:
Mastering SQL Server 2005, Mike Gunderloy, Joseph Jorden & David Tschanz, 1st Edition 2006 ISBN: 0782143806
Microsoft, SQL Server 2000 Database Design and Implementation , Second Edition 2003 ISBN: 0735619603

Lecture Notes Available From:
Course web site (you will need to be a registered student in the class to get access to a required User ID and password)

Supplies:
Several 3 1/2" high density floppy diskettes, Zip disks or a flash drive for saving your work if you plan to do any work in the Foothill computer labs.

Exams:
Quizzes, Midterm and Final covering texts and lectures. All exams will be online and open book.

Lab:
Internet students will not be expected to come to Foothill College for this course. You are, however, welcome to use the Foothill Computer Center facilities or the tutorial center.

Course Requirements:

Grading:
Your final grade will be determined by performance on the following course requirements using a point system:

A = 90-100, B = 80-89, C = 70-79, D = 60-69

The instructor reserves the right to distribute final grades more favorably to students than the preceding distribution.

Pass/NoPass Option: You are registered for a letter grade unless you complete a Pass/No Pass form with the Registrar by the end of the second week of the quarter. Instructors are not notified that a student has changed to Pass/No Pass status, and must assign a letter grade to all students. With the Pass/Fail option a grade of A, B, or C translates to a Pass grade; a D or F grade results in a No Pass grade.

Drops: It is the responsibility of the student to drop or withdraw from the course if necessary. You should notify the instructor and follow the procedures to drop or withdraw indicated at the Foothill website. Please see the class schedule for more information on drop dates, etc.

Honor Policy: Foothill College expects the highest standards of honesty from all students. Any student who exhibits behavior which, in the judgment of the instructor, indicates dishonesty on an examination or assignment, including those electronically produced, or who aids in the dishonesty of another student, shall receive no credit for that work. Incidents of dishonesty may result in a grade of “F” for the quarter and will be reported to the Dean of Student Affairs. You are expected to work alone for assignments and exams. When in doubt ask the instructor.

Weekly Lectures, Reading Assignments, Lab/Homework and Final Project



Session: 1 (Jan 7)
Topics: Introduction to Microsoft SQL Server 2005
Reading: Lesson One Class Lectures & Gunderloy pp. 1-46 (Chapters 1-2).
Optional Reading: SQL Server 2000 Text pp. 3-44 (Chapter 1).

Session: 2 (Jan 14)
Topics: Overview of SQL Server, Database Design & Normalization
Reading: Lesson Two Class Lectures & Gunderloy pp. 47-100 (Chapters 3-4).
Optional Reading: SQL Server 2000 Text pp. 95-136 (Chapter 3).

Quiz #1 Jan 18 - 22 (Covers Lessons 1 & 2).

Session: 3 (Jan 21)
Topics: T-SQL Overview & Basics
Reading: Lesson Three Class Lectures & Gunderloy pp. 101-140 (Chapter 5).
Optional Reading: SQL Server 2000 Text pp. 45-94 (Chapter 2).

Lab/Homework #1 due Jan 28.

Session: 4 (Jan 28)
Topics: Select Queries
Reading: Lesson Four Class Lectures & Gunderloy pp. 141-176 (Chapter 6).

Quiz #2 Feb 1 - 5 (Covers Lessons 3 & 4).

Session: 5 (Feb 4)
Topics: Action Queries & Advanced T-SQL
Reading: Lesson Five Class Lectures & Gunderloy pp. 177-234 (Chapters 7 & 8).
Optional Reading: SQL Server 2000 Text pp. 169-227 (Chapters 5 & 6).

Session: 6 (Feb 11)
Topics: Using SQL Server Management Studio
Reading: Lesson Six Class Lectures & Gunderloy pp. 235-288 (Chapter 9).
Optional Reading: SQL Server 2000 Text pp. 229-266 (Chapter 7).

Midterm Exam Feb 15 - 19 (Covers Lessons 1 - 6)

Session: 7 (Feb 18)
Topics: SQL Server Databases & Tables
Reading: Lesson Seven Class Lectures & Gunderloy pp.289-344 (Chapters 10 & 11).
Optional Reading: SQL Server 2000 Text pp. 137-168 (Chapter 4).

Lab/Homework #2 due Feb 25.

Session: 8 (Feb 25)
Topics: Implementing Indexes
Reading: Lesson Ten Class Lectures & Gunderloy pp. 345-364 (Chapter 12).
Optional Reading: SQL Server 2000 Text pp. 367-392 (Chapter 11).

Quiz #3 Feb 29 - Mar 4 (Covers Lessons 7 - 8).

Session: 9 (Mar 3)
Topics: Implementing Views
Reading: Lesson Eight Class Lectures & Gunderloy pp. 365-392 (Chapter 13).
Optional Reading: SQL Server 2000 Text pp. 341-365 (Chapter 10).

Session: 10 (Aug 2)
Topics: Implementing Stored Procedures
Reading: Lesson Nine Class Lectures & Gunderloy pp. 393-414 (Chapter 14).
Optional Reading: SQL Server 2000 Text pp. 267-309 (Chapter 8).

Lab/Homework #3 due Mar 17.

Session: 11 (Mar 10)
Topics: Implementing Triggers
Reading: Lesson Eleven Class Lectures & Gunderloy pp. 415-442 (Chapter 15).
Optional Reading: SQL Server 2000 Text pp. 311-339 (Chapter 9).

Extra Credit Lab/Homework due Mar 17.

Session: 12 (Mar 17)
Topics: Bonus (Optional) Lesson: Designing and Administering SQL Server 2005 Security
Reading: Bonus Lesson Class Lectures & Gunderloy pp. 533-568 (Chapter 18).
Optional Reading: SQL Server 2000 Text pp. 431-465 (Chapter 13).

*** Reminder - FINAL EXAM, Mar 24 - 27 (Covers the Entire Course) ***