CS 3540

Database Administration – Preliminary

Spring Semester 2010

Instructor

Rob Hilton

Office: TE110J
Phone: 626-6086
Email: cs.rbhilton@gmail.com
Web:  http://rbhilton.com/wsucs/

Office Hours

Tues & Thurs 9:30am - 11:20am, Thur 1:30 - 2:30 pm, or by appointment

Classroom

TE109F (North Lab)

Days

Monday and Wednesday

Time

9:30am - 11:20am

Texts

 Required: Database Administration, by Craig Mullins, Addison Wesley, 2002
( ISBN: 0-201-74129-6 )
Optional: Oracle Database 10g DBA Handbook, by Loney & Bryla, Osborne 2005,
(ISBN: 0-07-223145-9)
Internet Resources and other Handouts

Goal

Students will learn the role of the Database Administrator in managing an organization's most valuable asset - its data. Students will gain an understanding of DBMS architecture, database layout, database development, data fragmentation, rollback segments, database tuning, database security, backup and recovery, database networking, and distributed databases. Students will gain practical experience in working with current database management systems such as Oracle, SQL Server and Postgres. Prerequisite: CS 2550.

Class

Class will consist of a mix of lecture, discussion and lab work related to the responsibilities and activities of the Database Administrator. Questions and comments during class time are encouraged. Database concepts will be illustrated in class using a notebook computer and overhead projector.
It is expected that students will have read the covered chapters prior to the class on the topic. The instructor will ask questions of the students to ensure that learning is taking place.
Students will also learn how to install, administer, backup, recover and tune databases through assigned exercises in the CS computer lab.

Reading Assignments and Discussions

Students will complete reading assignment questions and then participate in classroom discussion on those questions. There will be approximately 14 reading assignments.

Exams

One final exam will be given.

Projects

There will be approximately 12 lab assignments related to database installation and administration during the semester. There may also be one group project.

Accommodations for disabilities

Any student requiring accommodations or services due to a disability must contact Services for Students with Disabilities (SSD) in room 181 of the Student Service Center. SSD can also arrange to provide course materials (including this syllabus) in alternative formats if necessary.

Grading

The final grade will be given based on point accumulated through reading assignments, discussions, exams and lab work.
Standard grading will apply: 90+ A; 80-89 B; 70-79 C; 60-69 D; 59 and below E

Policies

Exams can only be taken on the day given unless arrangements are made to take them ahead of time. Exams may not be taken after the scheduled date. Labs may be turned in up to one week late for reduced credit. Participation and research credit may not be made up.

Class Schedule & Study Guide 

Week of

Topic

Chapters

Jan 4

What is a DBA?
 Database Fundamentals, DBMS Vendors

Chapter 1
Appendix 1 and 2

Jan 11

Creating the Database Environment
Database Modeling and Normalization

Chapter 2
Chapter 3

Jan 18

Database Design
Application Design
Holiday– Jan 18th

Chapter 4
Chapter 5

Jan 25

Database Reviews

Database Change Management

Chapter 6
Chapter 7

Feb 1

Data Availability

Performance Management

Chapter 8
Chapter 9

Feb 8

System Performance
Database Performance

Chapter 10
Chapter 11

Feb 15

Application Performance
Holiday– Feb 15th

Chapter 12

Feb 22

Data Integrity

Database Security

Chapter 13
Chapter 14

Mar 1

Database Backup and Recovery

Chapter 15

Mar 8

Disaster Planning

Data Storage and Management
Spring Break March 15th - 21st

Chapter 16
Chapter 17

Mar 22

Data Movement and Distribution
Data Warehouse Administration

Chapter 18
Chapter 19

Mar 29

Data Movement and Distribution
Data Warehouse Administration

Chapter 20
Chapter 21

Apr 5

Database Connectivity

Metadata Management

Chapter 22
Chapter 23

Apr 12

Research Presentations

Presentations

Final Exam
TBA