Intermediate Database Management
Description: 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.
Learning Outcomes: Understand and implement advanced data modeling techniques to enforce data integrity within the model while designing the model around specific business processes and constraints. Learn advanced query methods and tools to allow for complex query results that are required for analyzing enterprise data sets. Understand methods and tools available for working with datasets from diverse sources and formats both internal and external to the organization’s data. Use current Oracle Database System to implement all of the above concepts including data structures, extending the model with additional available related data, querying, and analyzing the data within those sources.