Southern Polytechnic State University Information Technology Department IT 6733 Database Administration Spring 2013 W 6:00-7:15 pm Course Syllabus

siberiaskeinData Management

Nov 20, 2013 (3 years and 6 months ago)

269 views

Southern Polytechnic State University

Information Technology Department

IT 6733


Database Administration

Spring

201
3

W

6:00
-
7:15 pm

Course Syllabus

Instructor:
Svetlana Peltsverger

Phone:
(678) 915
-
4285


Email:
speltsve@spsu.edu

Office: Atrium Building J387

Web:

http://cse.spsu.edu/speltsve/

Office Hours: see
http://cse.spsu.edu/speltsve/


Catalog Description

Prerequisite:

IT510
1

This course covers data administration and management, backup/recovery, security, access
control, performance monitoring and tuning, data warehousing, data mining, online analytical
processing, centralized versus distributed environments, client se
rver and world
-
wide
-
web
database integration.

Course Outcomes

Students who complete this course successfully will be able to

1.

Describe tasks commonly performed by DBAs.

2.

Analyze performance characteristics of a DB system and justify necessary changes.

3.

Write
programs to perform maintenance and user support operations.

4.

Explain the concept of database security and backup/recovery

T
extbook

There is no textbook assigned. All readings are
assigned in weekly modules
. I require that you
read the relevant
papers and t
utorials

each week as a way to prepare you for
assigned lab/quiz
.
Knowledge of the readings will reduce the time it takes you to
finish lab assignments
.

If
you can't live without a textbook, then
I recommend:



Database Administration: The Complete Guide to
Practices and Procedures
, Craig S.
Mullins. Addison
-
Wesley ISBN: 0
-
201
-
74129
-
6.



Peter Rob and Carlos Coronel, Database Systems: Design, Implementation, and
Management
, Seventh Edition, Thomson Course Technology, 2007, ISBN 1
-
4188
-
3593
-
5.

Required Reading



Standards of Academic Conduct
http://www.spsu.edu/orientation/academicstandards.pdf




An Example of Proper Writing
http
://www.spsu.edu/orientation/researchpaper.pdf




Honor Code
http://spsu.edu/honorcode/



About the Course

There are 13 content modules in this course


one for each week. Last two weeks will be
dedicated to
the
group project
implementation and
deployment. Week ends
Tuesday

at
11:59pm
. All
module assignments

are due at
11:59 pm on
Tuesday
.

Content Modules

Each module contains:

1.

Assigned reading.

2.

Online content.

3.

Assigned hands
-
on exercises.

4.

Discussion topic OR
quiz.

5.

Apply your knowledge section.

For each content module you should:

1.

Read the on
-
line content and the assigned sections from the text.
You have to run
all code examples from the module.

2.

Post questions, corrections, or comments about the content in the

discussion area
designated for the module.

3.

Do assigned hands
-
on activities. Use the discussion area, or email to the instructor
or classmates, to ask for help with any exercises that give you difficulty.

4.

Read and respond to the assigned discussion topic
. All discussions must be
completed by
11:59pm on
Tuesday
. Do not wait until the last minute to start, you
will cause difficulties to your classmates and also have 30% penalty for starting
later than
24 hours before the deadline.

Each person should give th
eir opinion about
assigned question (at least two paragraphs and references if applicable) and
AT
LEAST TWO

posts to comment on the work of your classmates.

Discussion grading criteria
:

a.

Preparation 20%
-

read material and post on time.

b.

Information 20%
-

a
ccurate information supported by external references.

c.

Analysis 40%
-

highlights significant issues without overgeneralizing.

d.

Interaction 20%
-

responses to peer's posts and where appropriate challenges
other posts.

e.

Penalty


30% for starting
later than 24
hours before the deadline.

f.

Bonus


15% for moderating the discussion.

5.

Do assigned lab. The Lab is due at
11:59 PM on
Tuesday
.

Throughout the course, you should log in regularly to check for announcements and email. The
course Calendar in D2L contains all
important dates. Any changes of dates will be publicized
by post in discussion area and/or email.

Grading Policy

Your grade will be based upon:

Proctored Test

2
5

Take home test

25

Labs Reports,
Quizzes
& Discussions

5
0

Your grading scale will be as
follows:

Score ≥ 90

A

Score ≥ 80 & Score < 90

B

Score ≥ 70 & Score < 80

C

Score ≥
㘰…⁓co牥 <‷
0

a

pc潲o‼
S
0

c


Course Calendar

(
subject to change
)

Module

Topic

Assigned
discussions
and/or lab
reports and/or
quizzes are due

0

Module 0 Orientation

Friday
, January 1
1

1

Module 1 SQL Review

Tue., January 2
2

2

Module 2 Introduction to SQL Procedures & Functions

Tue.,
January
29

3

Module 3 Advanced SQL Procedures & Functions

Tue., February
5

4

Module 4 Overview of Database Administration

Tue., February
12

5

Module 5 Database Environment

Tue., February
19

6

Module 6 Database and Application Design

Tue.,
February 2
6

7

Module 7 Data Availability and Change Management

Tue., March 1
2

8

Module 8 Performance Management


Tue., March
19


TEST

1


10

Module
9

Database Security

Tue., March 2
6

11

Module 1
0

Database Backup and Recovery

Tue., April
2

12

Module 11 Data Warehouse

Tue., April
9

13

Module 1
2

Data Dictionaries

Tue., April 1
6


TEST 2

Wed, April 2
4

Important Dates



Classes Begin
-

January
7



Students Must Log Into Course to Confirm Attendance
-

January
7



Drop/Add
-

January
7
-
1
0



Last day to withdraw


February 2
6



Proctored Exam
-

Wednesday
,
April
2
4

6:00
-
7:15 pm in J
-
260
Contact me

Contact me

1.

D2L Email or
speltsve@spsu.edu

(checked every day)

2.

Use the Discussion tool for the course in

D2L (checked at least twice a week)
.

3.

Use the Chat tool in
My D2L
.

4.

Use Wimba Live Classroom or

D2L Chat

5.

Call me (678) 915
-
4285

6.

Stop by

my office during office hours or schedule an appointment.

Academic conduct

Cooperation and exchange of ideas with other students are encouraged. However, you are
responsible for your own work. Examples of cooperation that are

OK: talking with someone
about approaches to the assignment, discussing a particular problem that you are having.
Examples of cooperation that are not OK: taking someone else's assignment and modifying it,
examining someone else's solution in detail. Any
cases involving suspected academic
dishonesty result in a grade of zero for the assignment. This penalty applies to all students
involved.

All your
assignments

must be clearly different from those turned in
or published by others
and
represent a unique and

special effort on your part.

Remember that
plagiarism

is

unethical and
unprofessional
.

SPSU has an Honor Code and a new procedure relating to when academic misconduct is
alleged. All students should be aware of them. Information about the Honor Code and

the
misconduct procedure may be found at
http://spsu.edu/honorcode/
.

Any behavior creating a negative impression must be avoided. Do not forget that people have
different sense of humor. It is very important to m
aintain professional environment in our
virtual classroom.

No “extra credit” work will be given to improve one’s grade.
Copies of your class work and
test will be kept for record.

Home and Lab Assignments and Discussions

All Assignments will be posted on
D2L
http://www.spsu.edu/d2l/

Weekly reports

are due at
11:59 pm on
Tuesday
. If for some reason you have not been able to submit assignment by
deadline, then you have 24 hours to submit your work with a 20% penalty
(quizzes cannot be
submitted later). No reports will be accepted after that.

All work turned in for this class must meet the style and submission guidelines
http://cse.sp
su.edu/speltsve/files/style_and_submission_guide_d2l.pdf

Work that does not meet
the style and submission criteria will not be graded.


Every effort will be made to return your graded assignments to you within one week
.

Scoring rubric will be provided for
each assignment.

Attendance

Policy

Students must log into D2L courses by 11:59pm of the day classes begin to confirm their
attendance. If you fail to log into your courses by 11:59pm

of the day classes begin, or fail to
complete course activities within a two
-
week period at any time during the semester, the
instructor will consider your lack of activity as an indication of your intention not to continue
in the course. Failure to parti
cipate without officially withdrawing from the course will result
in a grade of F.

Be sure to submit all assigned work on time. If you are not able to participate in assigned class
activities, contact your instructor immediately.

Attendance and participat
ion in class are expected. If you have any problems with attendance
(or something else), contact me
BEFORE

they become a problem.

If you must miss an exam due to illness you must e
-
mail or call me
before

the scheduled time
and perhaps something can be arra
nged to avoid a zero for this exam. Failure to notify me prior
to the scheduled time will produce an automatic zero for the exam.
No makeup test except for
emergencies with proof ( e.g. doctor’s slip)

Preparation of work for this course

You have to run al
l

code examples from the module

before you attempt to complete assigned
lab. All assignments must be submitted through D2L before the corresponding deadline.

Email Communication and Announcements

To communicate with you through e
-
mail I will use D2L e
-
ma
il and your SPSU
yourlogin@spsu.edu
e
-
mail (
yourlogin
@spsu.edu)
. You must periodically check SPSU e
-
mail account for messages and to insure that new messages can be received. Be sure that your
mailbox is not full. A
ny changes of dates and announcements will be publicized by post in
discussion area on D2L and/or email.

Students with disabilities

Students with disabilities who believe that they may need accommodations in this class are
encouraged to contact the counse
lor working with disabilities at (678) 915
-
7244 as soon as
possible the better to ensure that such accommodations are implemented in a timely fashion.