Data Base Concepts & Design

Catalog description

This course provides students with solid foundation in database management and design concepts and related skills. The course will explore database design techniques such as normalization and entity-relationship modeling, database modeling/design tools such as Microsoft Visio or MySQL Workbench and UML, database management concepts such as database performance optimization, transaction processing and concurrency control, indexing, elementary database security features, database implementation techniques using a RDBMS such as SQL Server Express and a host language to develop a GUI and provides connectivity to a database. Students will design and implement databases and use SQL to construct simple, nested and correlated queries, and inner and outer joins to retrieve and manipulate data.