DEPARTMENT OF COMPUTER STUDIES AND ADVANCED
TECHNOLOGY
Course
Syllabus: ITSE2456 Oracle Database
Administration I
Section/Synonym Number
Office Telephone: 512-223-3184
Office: PSO-02J
Office Hours: Defined each semester
E-mail: rsmith@austincc.edu
Class
Meetings:
Defined in the semester catalogue
Course Description: Fundamentals
of the tasks and functions required of a database administrator. While Oracle is the Primary Database Management
System utilized, the concepts and procedures presented in this course are
typical for any Database Management System Server.
Pre-requisite: ITSE1345 or Department Approval
Approved Course Text: Set by taskforce
By Jonathan Gennick, Carol McCullough-Dieter, & Gerrit-Jan
Linker
IDG Books Worldwide
ISBN 0-7645-4623-6
Oracle 9i DBA Handbook
By Kevin Loney Oracle Press/Osbourne
ISBN 0-07-219374-3
Instructional Methodology: The course will have both
lab and lecture. The student will be
required to do assigned readings
from the text and handouts
as well as scheduled team labs
to reinforce the material
covered in class. Scheduled tests
will be used to assess the
progress of the student toward
achievement of the course
objectives.
Course Rationale: This course is designed to teach student the architecture (logical and Physical) structure of the Oracle Database Management System. As each student is required to have a working knowledge of the Relational Database Model as well as SQL and PL/SQL programming skills, this course focuses on the administration of a DBMS including creation, management, maintenance, and operation of a database management system.
This course is part of the Computer Information Technology Database Certificate plan. Completion of this course and the prerequisite courses further prepares the student for a position as an entry level Database Programmer and also acts as preparation for Oracle Certification Test 3.
Course Objectives/ Learning
Outcomes:
Establish and in depth understanding of
Database Administration using the DBMS
Interfaces.
SVRMGR,
OEM tools, Command Line interface and SQL*Plus.
Apply
the Relational Database Model to understand the Logical and Physical aspects
of the DBMS architecture.
Understand the functions of the
Oracle Database Server and Oracle Database Client.
Create,
maintain and manipulate an Oracle Database.
Understand
and apply the Data Dictionary.
Understand
and apply database statistics in relation to performance and integrity of the
database.
Create
and understand the application of user rolls, privileges, and the security of
the
database.
Discuss
and understand the concepts of Backup and Recovery Procedures.
Grade Policy: Grade will be based both on
concepts and practical application.
Grade Scale:
90% - 100% A
80% - 89%
B
70% - 79%
C
60% - 69%
D
0% - 59% F
Exams 60 %
Lab
Assignments 35 %
Daily
5 %
(Attendance,
assignments, etc.)
Classroom conduct.
A.
Food and drinks are not allowed in the classroom.
B.
Cellular phones and pagers should be turned off or placed in vibrate
mode while in class.
Lab Assignments
A student is expected to complete his or her own
projects and tests. Students are
responsible for observing the policy on academic integrity described in the Current
ACC Student Handbook, under Student Discipline Policy, Section
C.
Acts prohibited by the college for which discipline may be administered include scholastic dishonesty, including but not limited to cheating on an exam or quiz, plagiarizing, and unauthorized collaboration with another in preparing outside work. Academic work submitted by students shall be the result of their own thought, research or self-expression. Academic work is defined as, but not limited to tests, quizzes, whether taken electronically or on paper; projects, either individual or group; classroom presentations, and homework.
(Penalty for violation of academic policy must be
specified)----Examples
A student may receive a temporary grade of I
(Incomplete) at the end of the semester only if ALL of the following
conditions are satisfied:
1. The student is unable to
complete the course during the semester due to circumstances beyond their
control.
2. The student must have earned
at least half of the grade points needed for a C by the end of the semester.
3. The request for the grade
must be made in person at the instructors office and necessary documents
completed.
4. To remove an I, the
student must complete the course by two weeks before the end of the following
semester. Failure to do so will result
in the grade automatically reverting to an F.
Freedom of Expression Policy:
It is expected that faculty and students will
respect the views of others when expressed in classroom discussions.
Attendance / Withdrawal Policy:
Students are expected to attend classes and will be
held responsible for all material covered in class. Regular attendance helps ensure satisfactory
progress towards completion of the course.
It is the students responsibility to complete a Withdrawal Form in the
Admissions Office if they wish to withdraw from this class. The instructor may withdraw students from
this class if their absences exceed 10% of the total number of class meetings. The last date to withdraw for this semester
is defined in the semester catalogue. It is not the responsibility of the
instructor to withdraw the students from their class even though the instructor
has the prerogative to do so under the above listed circumstances.
Students with Disabilities Policy:
Each ACC campus offers
support services for students with documented physical or psychological
disabilities. Students with disabilities
must request reasonable accommodations through the Office for Students with
Disabilities on the campus where they expect to take the majority of their
classes. Students are encouraged to make
this request three weeks before the start of the semester. (Refer to the Current ACC Student Handbook)
Testing Center Policy (Open Campus Sections Only)
Course topics:
Database Management System
Concepts
The Oracle Architecture
Hardware Configurations
(Client/Server)
Logical and Physical
Database structures
Managing Tablespaces and data files
Managing the Database
Development Cycle
Managing Rollback
Segments
Database Security and
Auditing
Managing tables and
indexes
Database Tuning for
performance
Application and SQL
Optimization
Backup and Recovery
Procedures
Configuring Net 8
Communications
Database Management System
applications
Starting up a new
production database
Administering Control
Files and Redo Logs
Managing Tablespaces and Data Files (Database Objects)
Storage Structures
Tables, Indexes, and
Constraints
Managing Rollback
Segments
Managing Users (Rolls
and Privileges)
Monitoring a Database -
Performance
Tuning a Database
Performance
The Oracle 9i Interface
SCANS
ITEMS COMPETENCIES:
|
CODE |
DESCRIPTION |
ITSE2356
LEVEL |
|
F1 |
|
2 |
|
F3 |
ARITHEMETIC:
Performs basic computations; uses basic numerical concepts such as whole numbers, etc. |
2 |
|
F4 |
MATHEMATICS:
Approaches practical problems by choosing appropriately from a variety of
mathematical techniques. |
2 |
|
F5 |
LISTENING:
Receives, Attends to, interprets, and responds to verbal messages and other
cues. |
2 |
|
F7 |
CREATIVE
THINKING: Generates new ideas |
2 |
|
F8 |
DECISION
MAKING: Specifies goals and constraints, generates alternatives, considers
risks, and evaluates and chooses best. |
2 |
|
F9 |
PROBLEM
SOLVING: Recognizes problems and devises and implements plan of action |
2 |
|
F10 |
SEEING
THINGS IN THE MINDS EYE: Organizes and processes symbols, pictures, graphs,
objects, and other information. |
2 |
|
F12 |
REASONING:
Discovers a rule or principle underlying the relationship between two or more
objects and applies it when |
2 |
|
F13 |
RESPONSIBILITY:
Exerts a high level of effort and perseveres toward goal attainment |
2 |
|
F15 |
SOCIABILITY:
Demonstrates understanding, friendliness, adaptability, empathy, and
politeness in group settings. |
2 |
|
F16 |
SELF-MANAGEMENT:
Assesses self accurately, sets personal goals, monitors progress, and
exhibits self-control. |
2 |
|
C7 |
Interprets
and communicates information |
2 |
|
C8 |
Uses
computers to process information |
2 |
|
C9 |
Participates
as a members of a team: Contributes to group effort |
2 |
|
C13 |
NEGOTIATES:
Works toward agreements involving exchange of resources; resolves divergent
interests |
2 |
|
C16 |
MONITORS
AND CORRECTS PERFORMANCE: Distinguishes trends, predicts impacts on system
operations, diagnoses system performance, and corrects malfunctions. |
2 |
|
C19 |
APPLIES
TECHNOLOGY TO TASK: Understands overall intent and proper procedures for
setup and operation of equipment. |
2 |
|
Week of |
Bible Chapter |
9i DBA Handbook |
Topic |
Lab. Schedule |
|
|
1, 2 |
1 |
Oracle
Architecture |
Lab1
start Lab1
end |
|
|
3, 7 |
|
Oracle
Architecture DBA
tools SVRMGRL and OEM |
Lab2
start |
|
|
|
2 |
Hardware
Configurations Creating
a Database |
Lab2
end Lab3
start |
|
|
3, 6 |
|
Logical
Database Layouts Managing
the Control file and Redo Log groups |
Lab3
end Lab4
start |
|
|
6 |
4 |
Physical
Database Layouts Managing
Tablespaces and Datafiles |
Lab4
end Lab5
start |
|
|
|
|
Review
and Exam #1 |
Lab5
end Lab6
start |
|
|
6 |
5 |
Managing
the Development Process Storage
Structures |
Lab6
end Lab7
start |
|
|
|
7 |
Managing
Rollback segments |
Lab7
end Lab8
start |
|
|
11 |
10 |
Database
Security and Auditing Managing
Users and Privileges |
Lab8
end Lab9
start |
|
|
13,14 |
6,9 |
Monitoring
Databases Managing
Tables and indexes |
Lab9
end Lab10
start |
|
|
|
|
Review
and Exam #2 |
Lab10
end Lab11
start |
|
|
19,20 |
8 |
Database
Tuning |
Lab11
end Lab12
start |
|
|
18 |
|
Application
& SQL Optimization |
Lab12
end Lab13
start |
|
|
21,22 |
11,12 |
Backup
and Recovery Procedures |
Lab13
end Lab14
start |
|
|
5 |
|
Configuring
Net 8 |
Lab14
end Lab15
start |
|
|
|
|
Review
and Exam #3 |
Lab15
end |
Lab
Assignments:
2.
Preparing to Create a Database and Database Startup
3.
Generating the Production Database
4.
Administering your Database
5.
Administering the Control Files and Redo Logs
6.
Managing Tablespaces and Data Files
7.
Storage Structures
8.
Tables, Indexes and Constraints
9.
Rollback Segments
10.
Managing Users
11.
Monitoring the Database
12.
Tuning the Database
13.
Oracle 9i interface
14.
Oracle 8i Backup and Recovery
15.
Oracle 9i Backup and Recovery