CTS 2441
Oracle Database Administration Fundamentals I

View Weekly Course Schedule 

View Course Resources.

              Other interesting links:

View Oracle DBA certification and Oracle's exam objectives.
Visit Oracle Technology Network for news, downloads, technical articles, and more.
View Oracle9i Reference documentation (including on-line books).

Syllabus

Fall 2004

 

Time & Place: Ref No. 29208: Monday, 7:00 - 9:45 PM, Dale Mabry Room Tech-461
Instructor: Name:  Wayne Pollock
E-mail:  Internet: ,
Office & Phone:  Tech-404, 253-7213.
DM Office Hours:  Mon., Wed. 5:00-6:55; Thurs. 5:45-6:55;
Brandon Office Hours:  Tue., Thurs. 12:15-1:15 (Room: BTEC-216);
On-line Office Hours:  Wed., Fri. 11:00-12:30;  or by appointment.
Instant Messenger ID (Yahoo Messenger):  waynepollocklive
Homepage URL:  http://www.hccfl.edu/pollock/
          Yahoo Messenger on-line status - click to chat or leave a message
Texts: McCullough-Dieter, Carol, Oracle9i Database Administrator: Implementation and Administration, ©2003 Course Technology (Thomson).  ISBN: 0-619-15900-6
Description: "Students learn how to design, create, and maintain an Oracle database.  Architectural components and globalization are introduced."
Objectives: "After completing this course, the student will be able to:

  1. Use globalization support features
  2. Start up and shut down an Oracle instance and database
  3. Manage users, privileges, and resources
  4. Manage tablespaces, segments, extents, and blocks
  5. Manage Oracle database files
  6. Create an operational database"
Prerequisite: COP 2740, or Permission of the Instructor.  Students enrolled in a degree or college credit certificate program must complete all prerequisites.
Facilities: Assignments can be performed on the Dale Mabry campus Oracle computers, which can be accessed from the classroom or from some computers the open computer lab.  You will need your own floppy disks, writing materials, and Scantron forms.
Grading:
Projects: 35%
Homework Assignments: 15%
3 equally weighted closed-book exams     50%
Classroom participation: +5%

A=90-100,   B=80-89,   C=70-79,   D=65-69,   F=0-64
(Or you can elect to "audit" the class during the add/drop period.)

Policies:
  • No make up exams will be offered without the prior approval of the instructor.
  • Exams will be closed book and closed note multiple choice exams.  While the exams are non-cumulative, each does build upon knowledge acquired earlier.  Exams are based upon material presented in class and from assigned readings.
  • Regular attendance is imperative for the successful completion of this class.  All phones, pagers, and beepers must be turned off during class time, except with prior permission of the instructor.  No food or drink is permitted in HCC classrooms.  Attendance will be taken within 5 minutes of the start of class; after 4 absences and/or lateness, the student will lose 2 points off the final grade for each occurrence.
    If you miss a class you are still responsible for the material covered in that class.  All students should exchange contact informaion (name, email address, phone number) with at least one other student in the class.  If you must miss a class, you should then contact that student and request they take class notes for you.
  • Credit for class participation includes attendance, preparedness, and adding to class discussions by asking questions and participating in discussions.  Playing computer games, surfing the internet, or working on other assignments for this or other classes during class time will lose you credit. 
  • Additional time outside of class will be required to complete the material.  For typical students an average of between 8 and 12 hours each week outside of class are required for preparation, practice, and projects.
  • Students are expected to prepare for each class by completing all reading assignments, reviewing examples and model solutions provided, and practicing outside of class.  This is important — you can't learn a skill such as Oracle administration only by attending class and reading books.  You must practice several hours a few days each week!  If you won't have enough time available, consider auditing the course.
  • Students are expected to check the class website regularly.  Any syllabus changes, class cancellations, and project assignments are posted to the website.  Also note that project due dates are not shown in the week-by-week schedule; check the links at the top of the web page for these.
  • Working together on individual assignments is considered as cheating!  Cheating will result in an automatic F (zero) for the project for all parties.  Note that some projects may be group projects, where each member of a small group works together on a project.  It is also ok to ask a fellow student for class notes (in the event you miss a class) or for help in understanding the text or material given to the class (e.g., examples on the class website).
  • You must abide by the HCC Acceptable Use Policy (AUP) for computers and services.  In particular, you must not run network scanners, or attempt to obtain administrator (“root”) privileges or otherwise disrupt HCC computers and services.  In some explicitly stated circumstances, some parts of the AUP may not apply.  If in any doubt, ask!
  • You must follow the academic honesty policy for HCC.  A second cheating offence will result in an "F" for the course, and your name will be turned over to the Dean for further handling.  I take these matters very seriously.  You have been warned!
Projects:

Projects will be assigned at various times.  You will have sufficient time to complete the projects.  Although there may be in-class group exercises you must work individually on the projects, typically outside of regular class hours except when a project is designated as a group project.  You may work together in small groups on group projects, provided the names of all who worked together are listed.  Each student must still submit their own copy of the assignment.

Projects are graded on the following scale:

A = 95% (Excellent: Good design with good comments, style, and extras)
B = 85% (Good: Good design, some comments, readable style, and it works)
C = 75% (Acceptable: Project objectives are met or are close to being met)
D = 65% (Unacceptable)
E = 10-64% (Variable credit: At least you tried)
F = 0% (Didn't hand in the project)

Minor extras worth +5 points, minor omissions or poor design worth -5.

Homework:

Homework assignments are assigned from the end of chapter exercises in the text.  The due dates are shown in the weekly schedule below.  You will have plenty of time to complete the assignments.  You may work together in small groups for the homework assignments, provided the names of all who worked together are listed.  Each student must still submit their own copy.

Homework questions are intended to focus your studying of the readings and to stimulate class questions and discussion.  It is not intended that students can answer all the questions assigned, but you must show you have thought about the questions in order to earn an "A+" grade.

Submitting Assignments:

Assignments (except when noted) can be submitted by email to .  Please use a subject such as "Oracle DBA I Homework Assignment #1" so I can tell which emails are submitted work.  Send only one assignment per email message.  Email your assignments by copy-and-paste into your mail program.  Please do not send as attachments (except when saubmitting documents with graphics, such as for some case study questions).  If possible, use the "text" and not the "HTML" mode of your email program. 

Late assignments generally will not be accepted.  An assignment is late if not turned in by the start of class on the day it is due.  Late assignments will be accepted up to one week late only if you obtain the instructor's permission prior to the due date of the assignment, or for a documented serious medical reason.  All late assignments will lose at least one letter grade penalty regardless of the reason for the delay.  Projects and quizzes later than one week will receive a grade of F (0), however if you have a very good reason your instructor may allow additional time.

In the event a student submits more than once for the same assignment, I will ignore all but the last one received up to the deadline.  Assignments submitted after the deadline will not count toward your grade without the prior express approval of your instructor.

If you have an email problem you may turn in a printout instead.  Be sure your name is clearly written on the top of any pages turned in.  Please staple multiple pages together (at the upper left).

Classes Begin: Wednesday 8/25/04 (First scheduled class is Monday 8/30/04)
Add-Drop Ends: Tuesday 8/31/04
Last Day to Withdraw:  Monday, 11/1/04
Classes End: Monday 12/13/04
(Last regularly scheduled class: Monday 12/13/04)
No Class on: Monday 9/6/04 (Labor day),
Friday 10/22/04 (All-college day),
Thursday 11/11/04 (Veterans' day),
Thursday 11/25/04 - Saturday 11/27/04 (Thanksgiving holiday)
Additional days
I'm not available:

Monday 11/8/04 - Wednesday 11/10/04 (LOI - CIT conference)

Request For Accommodation

If, to participate in this course, you require an accommodation due to a physical disability or learning impairment, you must contact the Office of Services to Students with Disabilities, Dale Mabry campus: Student Services Building (DSTU) Room 204, voice phone: (813) 259–6035,  TTD: (813) 253-7035,  FAX: (813) 253-7336.  Brandon campus: voice phone: (813) 253-7914.

Quotes:         Tell me and I'll listen.
Show me and I'll understand.
Involve me and I'll learn.
    - Lakota Indian saying
        Learning is not a spectator sport!     - Chickering & Gamson


Course schedule for CTS 2441

Dates Topics
8/30 Course introduction, professional societies, certification.  DBA Job titles and descriptions, salaries, ethics and politics.  Basic procedures (removable disks), HCC network login (using HawkNet/WebAdvisor for passwords, grades).  Open Lab procedures and hours.
Types of DBAs.  Common DBA tasks.  Overview of Oracle (instances, ...), Oracle installation, OFA naming standards.
Begin Install Project (through Registering for a key).
Readings:  Chapter 1
9/6 Labor Day   —   No classes
9/13 Hurricane Closed HCC   —   No classes
9/13
9/20
Complete Install Project.
Oracle Connection modes.  Service names.  Configuring Oracle Net.  Oracle memory architecture (SVA, PGA).  Background processes of the instance. Using the Enterprise Manager, other tools.
Homework #1 Due:  Chapter 1 Exam Review Questions 1-10, plus the case project (page 26).
Homework #2 Due:  Chapter 2 Exam Review Questions 1-12;
Readings:  Chapter 2
9/20
9/27
Creating a database.  Starting and stopping a database.
Homework #3 Due:  Chapter 3 Exam Review Questions 1, 2, 3, 6, and 7.
Readings:  Chapter 3
9/27
10/4
Using Data dictionary views.  Understanding and creating control files.
Understanding and manage the redo log files.  Using other diagnostic files.
Homework #4-5 Due:  Chapter 4 Exam Review Questions 1-10, Chapter 5 Exam Review Questions 1, 3, 4, 6, 7, 8, and 10.
Project #2 Due:  The chapter 2 Hands-on Assignments steps (a) - (g), problems 1 - 4.
Readings:  Chapters 4, 5
10/4
10/11
Review, EXAM #1
Project #3 Due:  The chapter 3 Hands-on Assignments problems 2, 3, and 6-10.
10/11 Logical and physical storage structures.  Configuring and viewing storage use.  Creating tablespaces.  Undo data management.
Homework #6 (optional) Due:  Chapter 6 Exam Review Questions 1 - 8.
Project #4 (optional) Due:  The chapter 6 Hands-on Assignments problems 2, 3, 7, and 9.
Readings:  Chapter 6
10/18 Table types and Advanced Table types.
Homework #7 (optional) Due:  Chapter 7 Exam Review Questions 1 - 7.
Project #5 (optional) Due:  The chapter 7 Hands-on Assignments problems 1, 4, 5, and 6.
Readings:  Chapter 7
10/25 Table Management.
Homework #8 (optional) Due:  Chapter 8 Exam Review Questions 1, 2, 3, 4, and 7.
Project #6 (optional) Due:  The chapter 8 Hands-on Assignments problems 3, 4, 6, and 8.
Readings:  Chapter 8
11/1 Understanding and managing indexes.
Working with Integrity Constraints.
Readings:  Chapters 9, 10
11/8 League Of Innovation Conference on Information Technology   —   Self-study day
11/15 Review, EXAM #2

Homework #9 Due:  Chapter 9 Exam Review Questions 1, 3, 4, 6, 8, 9, 10, and 12.
Project #7 Due:  The chapter 9 Hands-on Assignments problems 1, 2, 6, 7, and 10.  Also the chapter 9 Case Project.
Homework #10 Due:  Chapter 10 Exam Review Questions 2, 3, 5, 8, and 10.
Project #8 Due:  The chapter 10 Hands-on Assignments problems 1 - 13.
11/22 Managing users and resources (and profiles).
Managing system and object (database) privileges.
Homework #11-12 Due:  Chapter 11 Exam Review Questions 1, 2, 3, 4, 5, 7, and 10, chapter 12 Exam Review Questions 1, 2, 3, 5, 7, and 8.
Project #9-10 Due:  The chapter 11 Hands-on Assignments problems 1, 2, 3, 6, 7, and 8, The chapter 12 Hands-on Assignments problems 2, 4, 5, 7, and 10.
Readings:  Chapters 11, 12
11/29 Using roles.
Homework #13 Due:  Chapter 13 Exam Review Questions 2, 3, 4, 7, and 10.
Project #11 Due:  The chapter 13 Hands-on Assignments problems 1, 4, 5, 7, and 10.
Readings:  Chapter 13
12/6 Globalization Support (Internationalization, or I18N).
Homework #14 Due:  Chapter 14 Exam Review Questions 1, 2, 3, 4, 7, and 8.
Project #12 Due:  The chapter 14 Hands-on Assignments problems 1, 2, 3, and 7.
Readings:  Chapter 14
12/13 Review, Exam #3

 




Class name: CTS 2441 (Oracle DB Administration Fund. I)  Day: Monday  Time: 7:00 PM

Student Information Sheet

Student Name: ___________________________

Student ID: _____________________________

Phone (optional):  ______________________

Email (optional):  ______________________



Student Certification Statement

I have read and understand all of the information contained in the syllabus,
and agree to abide by the conditions of this course, especially the following
areas  (initial each area):

		_____  Test Policy

		_____  Honesty Policy

		_____  Attendance Policy

		_____  Grading Policy

		_____  Class Conduct

					_________________________________
						Student Signature



 

Resources
DBA Titles A list of the different types (roles) of a DBA     DBA Common Tasks Some of the many tasks a DBA may perform
Oracle reference documentation Chose "Database" from the Product Center section on the left.  Next click on "Documentation" under Services, then the "Database" option that appears in the drop-down list.  Finally click on "View Library".
Oracle Concepts Oracle basic concepts and terms     Oracle Tools A list of some Oracle 9i DBA tools
System Privileges A table of System privileges and pre-defined roles     Security Policies Some of the questions to ask when developing a security policy
Oracle DBA Views A list of commonly used views for managing and monitoring a database     Google search for Scripts Many of these pages contain ready-to-run Oracle Performance Tuning SQL scripts
Model Solutions to Assigned Projects
Project 1 TBA