CPIT 345

Course Name

Course Code

Database Administration

CPIT 345

Prerequisite

Credit Units

CPIT 240

Theory

Practice

Training

Credit

3

1

0

3

Course Description

This course covers a wide range of subjects in Database Administration. The students will have a hands-on training about installation, configuration, administration, performance, security, backup and recovery, and enterprise services of databases.

Course Contents

Using a wildly used DBMS as a platform for training

§ Database architecture and structure

§ Schemas objects

§ Partitioned tables and indexes

§ Built-in data types

§ Data integrity and constraints

§ Database security

§ Database manipulation

§ Redo/undo log

§ Tablespace manipulation

§ Data files & tempfiles

§ Table and index manipulation

§ Backup & recovery

§ Enterprise tools, services, and connectivity

§ Database loading and unloading

§ Locking & concurrency

Course Outcomes

Upon finishing this course, the student should:

§ Understand the internal architecture and structure of a widely used database systems.

§ Be able to professionally manipulate database objects (tables, indexes, data files, and logs).

§ Have the skills to configure and apply data integrity rules and constraints.

§ Be able to set-up and perform back-up and recovery procedures.

§ Understand and mange locking and concurrency mechanisms

§ Be able to set-up, configure, and utilize the network services of a database.

References

• C. S. Mullins, "Database Administration: The Complete Guide to Practices and Procedures", Addison-Wesley, 2002, ISBN 0201741296.

• M. V. Mannino, "Database Design, Application Development, and Administration", 3rd Ed., McGraw-Hill, 2005, ISBN 0072942207.

• Alapati, "Expert Oracle9i Database Administration", 2003, ISBN 1590590228.