Database Implementation and Administration

CIT 47900/ 3 Cr.

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

Prerequisites/Co-requisites:

CIT 30400

Software

• Oracle SQL Plus

Instruction Goal

• Review basic database concepts and theories
• Installation of MySQL database and client 
• MySQL design - modeling, data types, tables, views, indexes, stored routines 
• MySQL database management -security, monitoring, data dictionary, server logs, partitioning
• MySQL storage engines 
• Learn to backup and recover

Outcomes

Course Outcomes(What are these?)

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

CIT Student Outcomes(What are these?)

(2) Design, implement, and evaluate a computing-based solution to meet a given set of  computing requirements in the context of the program’s discipline. 

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