Intermediate Database Management
The ability to structure, manage, and analyze data is critical to any organization. Databases, being the core of every information system, are essential in supporting this ability. Therefore, knowing how to effectively use the information and learning new skills in designing database systems is an advantage and necessity today. In addition, with the accessibility and availability of data from multiple sources and in disparate formats, it is also important to become familiar with methods for integrating those external data sources with internal enterprise data.
This accelerated 6-unit course will address the theory and application of relational database technology. The course covers advanced data modeling (including entity relationships modeling and database normalization) as well as the structured query language (selected topics). Data integrity as well as utilizing metadata will also be addressed. In addition, the course will cover tools, technologies and methods to aid in working with heterogeneous and external data sets.
To provide students with an opportunity to apply the knowledge they learn from the lectures, readings and various assignments.