SW402 IC342 Implementing the Database ServerName of Course: Implementing the Database Server, MS SQL Server (SW402/IC342)
Instructor: Tom Galasso
Phone: (914) 921-7242 (Days / Evenings)
E-mail: tgalasso@mobius.com
Class Location: McAuliffe Hall, 206
Class Hours: Tuesday, 6:30-9:30 p.m. including lab
Texts:
Spenik/Sledge, Microsoft SQL Server 2000 DBA SurvivalGuide ISBN:067232007X
Bowman/Emerson/Darnovsky, The Practical SQL Handbook
ISBN: 0-201-70309-2
Class Objectives:
1) The student will understand the basics of the Relational Database Model.
2) The student will learn Database Administration functions as appropriate for software developers.
3) The student will learn SQL DDL and DML.
4) The student will become familiar with entire implementation cycle of a client server application.
5) The student will design and implement a functional and (quasi-) useful relational database.
Session 1
1) Introduction / presentation of class objectives
2) What is a Database? (informal)
3) Where does the database fit in a software application
4) Database models from flat files to object-oriented
5) Definition of the Relational Model
6) Relational database concepts (tables, rows, etc.)
7) LAB - SQL Server utilities
Session 2
1) The database server - hardware
2) Connecting to a database
3) SQL Server database storage structure
4) Creating a database
5) SQL DDL
6) LAB - creating a data device, database, tables and indexes
Session 3
1) Designing a database
2) ER Modeling
3) Referential Integrity
4) Normalization
5) LAB - designing a simple database
Session 4
1) SQL DML
2) The Select Statement
3) LAB - Simple Select Statements
Session 5
1) The Select Statement, continued
2) Aggregates
3) Joins
4) LAB - More Select statements
Session 6
1) Unions
2) Views
3) Implementing referential integrity
4) LAB - Referential Integrity, Joins, and Views
Session 7
1) Subqueries
2) LAB - Subqueries
Session 8
Catch-up week
Review for Midterm
TAKE HOME Midterm Examination
Session 9
Midterm Examination Due
1) Review Midterm
2) The INSERT statement
3) The DELETE statement
4) The UPDATE statement
5) LAB - INSERT, DELETE, UPDATE
Session 10
1) Stored Procedures
2) System Stored Procedures
3) Triggers
4) LAB - Stored Procedures
Session 11
1) Basic query performance
2) Using Indexes
3) SHOWPLAN
4) Tweaking Queries
5) Performance Monitor
6) Signs of Trouble
7) Showing Statistics
8) LAB - Query performance
Session 12
1) Locking
2) Backup and Recovery
3) Database Consistency
4) Security
5) LAB - Database Administration
Session 13
Final Project ER Diagrams Due
1) Database Applications
2) PL/SQL - Embedded SQL
3) Attached Tables / Views
4) Wrap-up and Review for Final
5) LAB - Review for Final
Session 14
Catch-up session
Final project Optional turn in date (+5 points).
Session 15
Final Projects Due
Final Project Presentations
Final Grade:
Final Project 50%, Midterm 40%, Quizzes/Homework/Classwork 10% | 
