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).
|Time & Place:||Ref No. 29208: Monday, 7:00 - 9:45 PM, Dale Mabry Room Tech-461|
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.
|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:
|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.|
A=90-100, B=80-89, C=70-79, D=65-69, F=0-64
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)
Minor extras worth +5 points, minor omissions or poor design worth -5.
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.
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)
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.
Tell me and I'll listen.
|- Lakota Indian saying|
Learning is not a spectator sport!
|- Chickering & Gamson|
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|
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
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
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
Review, EXAM #1|
Project #3 Due: The chapter 3 Hands-on Assignments problems 2, 3, and 6-10.
Logical and physical storage structures.
Configuring and viewing storage use.
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
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
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
Understanding and managing indexes.|
Working with Integrity Constraints.
Readings: Chapters 9, 10
|11/8||League Of Innovation Conference on Information Technology — Self-study day|
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.
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
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
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
|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
Finally click on "
|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|