Skip to main content
IT 553 Database Design, Management and Administration
This course gives students hands-on practice and experience in database design and administration along with the fundamental concepts and techniques involved. Topics covered include the entity-relationship model, relational database theory, file structure, indexing and hashing, query processing, crash recovery, concurrency control/transaction processing security and integrity. Creation of tables, views, synonyms and indexes are examined in detail. The use of SQL is considered and highlighted with the help of examples, and used to build the underlining database of an application. Topics include Introduction to RDMS; Database Creation and Modification; SQL; Event Programming; Multiple Module Applications; Database Architecture; Hardware Configuration and Consideration; Database Layouts; Database Management; Managing Rollback Segments; Database Tuning; Database Security and Auditing; Backup and Recovery Procedures.
SU Credits : 3.000
ECTS Credit : 6.000
Prerequisite : -
Corequisite : -