ISM 6217: Database Administration
University of South Florida
Course Information:
Syllabus
Textbook
Sample Midterms
Sample Finals
Class Grades @ myUSF
Honor Code

Software Downloads:
Oracle 10g Exp Ed
SQL Server 2005 Exp Ed
MySQL 5.0
Aqua Data Studio 4.7
Microsoft Visio 2003
USF MSDNAA Page

Resources/Docs:
Oracle 10g Docs
Using Aqua Data Studio
SQL Tutorial

Professor:
Dr. Anol Bhattacherjee
ISDS Department
USF College of Business Administration
Tampa, FL 33620-7800
Tel: 813.974.6760
Professor's E-Mail: abhatt @ coba.usf.edu

Class Schedule:

Week 01 (Aug 28): Course Introduction & Relational Database Concepts

Readings: Syllabus, Text Chapters 1, 4

Handouts: Slides

Week 02 (Sept 4): Introduction to Oracle (PAB 103 Computer Lab)

Readings: Oracle 10g Getting Started Guide

Download and Install: Oracle 10g Express Edition

Week 03 (Sept 11): Conceptual Data Modeling (PAB 110)

Readings: Text Chapter 3

Handouts: Slides

Week 04 (Sept 18): Logical Database Design (PAB 110)

Readings: Text Chapters 6, 7

Handouts: Slides

Due: Assignment 1

Week 05 (Sept 25): Physical Database Design (PAB 107)

Readings: Text: Chapter 8

Handouts: Slides, Sample Midterms

Due: Assignment 2

Week 06 (Oct 2): Midterms & SQL (PAB 103)

Midterms covers materials from Weeks 1 through 4.

Due: Assignment 3

Week 07 (Oct 9): SQL (PAB 103)

Readings: Text Chapter 9

Handouts: Slides, SQL Handout

Week 08 (Oct 16): Advanced SQL (PAB 103)

Handouts: Slides

Week 09 (Oct 23): Database Administration (PAB 103)

Readings: Text Chapter 11

Handouts: Slides
Due: Assignment 4

Week 10 (Oct 30): Transaction Processing (PAB 110)

Readings: Text Chapter 12

Handouts: Slides

Week 11 (Nov 6): Data Warehousing (PAB 110)

Readings: Text Chapter 14

Handouts: Slides

Due: Assignment 5

Handouts: Sample Finals

Week 12 (Nov 13): Finals Exam (PAB 110)

Exam covers materials from Weeks 5 through 11.




The schedule above is subject to change. Any and all changes will be announced in class.
Page maintained by Anol Bhattacherjee, who can be reached at ABhatt @ coba.usf.edu.
Copyright © 2006 Anol Bhattacherjee. All rights reserved.