Database Implementation and Administration
CIT 47900/ 3 Cr.
(Class 2, Lab 2; or Class 3). 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.
- Available Online: No
- Credit by Exam: No
- Laptop Required: Yes
- Oracle SQL Plus
Course Outcomes(What are these?)
- Install, configure, and administer an Oracle 10g database (CIT i, l)
- Create, configure and manage database structures including tablespaces, control files, indexes, tables, and users (CIT i, j)
- Administer database recovery, backup, and concurrency controls (CIT j, k)
CIT Student Outcomes(What are these?)
(i) An ability to use current techniques, skills, and tools necessary for computing practice.
(j) An ability to use and apply current technical concepts and practices in the core information technologies
(k) An ability to identify and analyze user needs and take them into account in the selection, creation, evaluation and administration of computer-based systems.
(l) An ability to effectively integrate IT-based solutions into the user environment.
- 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
Principles of Undergraduate Learning (PULs)
3. Integration and Application of Knowledge
4. Intellectual Depth, Breadth, and Adaptiveness