Midlands Technical College
Information Systems Technology Syllabus
|
COURSE DESCRIPTION: This course will provide a comprehensive foundation in Relational Database Administration. A current commercially available database product will be used for class projects.
STUDENT COMPETENCIES: Upon successful completion of this course the student will be able to:
1. Understand Oracle Architectural Components
2. Use Administration Tools
3. Manage an Oracle Instance
4. Create a Database
5. Create Data Dictionary Views and Standard Packages
6. Maintain the Control File
7. Maintain Redo Log Files
8. Manage Tablespaces and Data Files
9. Understand Storage Structure and Relationships
10.Manage Rollback Segments
11.Manage Temporary Segments
12.Manage Tables
13.Manage Indexes
14.Maintain Data Integrity
15.Use Clusters and Index-Organized Tables
16.Load and Reorganize Data
17.Manage Users
18.Manage Profiles
19.Manage Privileges
20.Manage Roles
21.Audit a database
22.Use National Language Support
Achievement of these competencies will be measured by a combination of methods which may include class behavior, graded homework assignments and projects, and performance on quizzes and examinations - please see instructor addendum for details.
GRADING SCALE:
| A | 94 - 100 |
| B | 87 - 93 |
| C | 78 - 86 |
| F | 0 - 77 |
All projects must be turned in on or before the due date for that program or project. No projects will be accepted after the due dates.
No incomplete grades will be given.
Any deviation from this policy must be authorized by the Department Head.
ACADEMIC INTEGRITY: Academic integrity questions should be resolved by consulting the Student Code as documented in the Midlands Technical College Student Handbook. All issues of academic dishonesty will be referred to the director of Campus Life.
ATTENDANCE POLICY: It is essential that you attend class in order to receive a passing grade. If you must miss class then please let the instructor know in advance, if possible. If you miss more than 4 classes for a class that meets 2 times a week, or 6 classes for a class that meets 3 times a week, then the instructor may withdraw you from the class.
|
SPECIAL ACCOMMODATIONS: If you would like to request academic accommodations due to a disability, please contact a counselor in the Disability Resource Center, 822-3510 and 738-7678. TTY telephone (Airport 822-3401, Beltline 738-7800).
CAMPUS EMERGENCY PROTOCOL: Students and employees are asked to report safety concerns or suspicious activities to Campus Security at 7199(on campus), or 738-7199 (cell phone and off campus). In the event of an emergency, student and employee protocol is to immediately call Campus Security or local 911. If an emergency occurs, employees and students may seek additional information and instructions via MTC Information Centers, email, college Intranet, the MTC website, campus voice mail and loud speakers. |
The College may be closed because of inclement weather. This news should be available on the website at www.midlandstech.edu, at the main phone number at 738-1400, and announced on WIS-TV and radio. Please check frequently in changeable weather for closings and re-openings. If the College closing or reopening means that you will have at least 30 minutes of a class, you should come to class. Please do not call the IST Department office or the President’s office with closure questions.