Database Design and Management

Catalog description

The abilities to design, implement, and maintain an enterprise database are beneficial skills for computer science professionals. This course involves the study of database management systems, database architecture, design, queries, applications, administration and implementation. At least half of the course involves extensive database design with ERDs, normalization, DDL and DML SQL queries, and the use of SQL advanced queries for data analysis. The remainder of the course examines concurrency management, transaction processing, query optimization, security, database recovery, distributed databases, PHP, and XML. Projects are assigned to provide hands-on experience with the SQL language, a relational database management software package, and various ETL (Extract-Transform-Load) techniques for large data sets.