Prerequisites

CIT 21400
CIT 28600

Offered

Spring

Software

Oracle SQL Plus

Credit By Exam

No

Coordinator

E. Fernandez

What you will learn

Description

Extends knowledge of database concepts.  Topics include physical database design, client/server implementation and database administration.  Given a logical database design, students develop physical database structures and implement a database application. Students carry out database design, construction administration, and programming activities using client/server technology.

Textbook

Powell, McCullough-Dieter, Oracle 10g Database Administrator: Implementation and Administration, Course Technology/Cengage, 2007, ISBN 9781418836658

Rajan, Oracle 10g Database Administrator II: Backup/Recovery and Network Admin, Course Technology/Cengage, 2006, ISBN 9781418836641

Course Outcomes

• Install, configure, and administer an Oracle 10g database (CIT 9)
• Create, configure and manage database structures including tablespaces, control files, indexes, tables, and users (CIT 3, 9)
• Administer database recovery, backup, and concurrency controls (CIT 9)

CIT Program Outcomes (What are these?)

3. Plan, design, implement, and evaluate IT-based projects and systems to meet desired needs.

9. Use current technical concepts, techniques and practices in the information technologies within the student"s area of expertise.

Principles of Undergraduate Learning (What are Principles of Undergraduate Learning?)

3. Integration and Application of Knowledge

4. Intellectual Depth, Breadth, and Adaptiveness

Topics

• Oracle Architecture
• Database Administrator Tools
• Creating a Database and the Oracle Instance
• Data Dictionary Views
• Basic Storage Concepts and Settings
• Database Queries
• Table Management
• Data Integrity Constraints and Index Management
• Data Management
• Security Management
• Performance Monitoring
• Proactive Maintenance
• Backup and Recovery

Assessment

• Midterm Exam
• Final Exam
• Homework Assignments
• Lab Assignments
• Quizzes