|
|
|
 |
|
|
|
|
|
|
| CSCI 679: Topics in Database Systems |
 |
 |
|
|
|
|
Prerequisites:The prerequisite is either CSCI 470 or CSCI 570 or equivalent or experience with relational databases, including design, transactions, concurrency and SQL.
Catalog Description: This course will cover the Oracle architectural components, getting started with the oracle server, managing an oracle instance, creating a database, creating data dictionary views and standard packages, maintaining the control file, maintaining redo log files, managing tablespaces and data files, Oracle storage structures and relationships, managing rollback segments, managing tables, managing indexes, maintaining data integrity, loading data, reorganizing data, managing password security and resources, managing users, managing privileges, managing roles, and using National Language Support in Oracle. We will cover all 20 lessons in the Oracle Course Manuals and complete the bulk of the lab exercises from these manuals.
Course Objectives:
The objectives are for the student to:
- become proficient with the Oracle Architectural Components
- create well-designed Oracle databases and manage Oracle instances
- maintain all the components of an Oracle database and create redundancy in the database to be able run the database efficiently and wisely with a minimum of downtime
- place constraints on the data in their databases to ensure integrity of the data
- be able to load and reorganize data efficiently in the database
- be able to understand all security aspects of a database and effectively configure and manage security
- be able to successfully pass the Oracle Certified Professional Exam in Oracle Architecture and Administration
Course Outcomes:
Students shall be able to:
- design databases that are efficient, with redundant components to ensure a minimum of downtime or recovery efforts
- create and manage efficient, high functioning databases
- load data efficiently and accurately
- reorganize a database should storage structures become inefficient
- use V$ performance views to diagnose and correct database problems
- create and maintain an effective security subsystem for their databases
Class/Laboratory schedule:
One hundred minutes a week activity
Accreditation Category Content:
This course embodies a significant portion of (a) Problem Analysis and (b) Solutions Design |
|
|
|
|
| Topic |
Percentage |
Hours |
| |
|
|
| Systems Management |
20% |
9 |
| Architecture |
20% |
9 |
| Database Design |
30% |
14 |
| Security |
20% |
9 |
|
|
|
|
|
Relationship of Course to Program Objectives:
This course supports the achievement of the following program objectives:
All students will be able to analyze and solve computing problems related to databases and operating systems issues related to databases, or problems in related areas, and to continually upgrade their knowledge and skills. |
|
|
|
|
|
|
|
|
CSU, Chico:
Home | Admissions | Bookstore | Catalog | Schedule | Library | Help
This page and its contents © 2003 College of Engineering, Computer Science, & Construction
Management
California State University, Chico |
College of Engineering, Computer
Science, & Construction Management
California State University, Chico
Chico, CA 95929-0003
530-898-5963
webmaster@ecst.csuchico.edu |
|
|
