Course Number: 95-703
Databases systems are central to most organizations’ information systems strategies. At any organizational level, users can expect to have frequent contact with database systems. Therefore, skill in using such systems – understanding their capabilities and limitations, knowing how to access data directly or through technical specialists, knowing how to effectively use the information such systems can provide, and skills in designing new systems and related applications – is a distinct advantage and necessity today. The Relational Database Management System (RDBMS) is one type of database systems that is most often used these days, and is the primary focus of this course.
1. Gain good understanding of relational data model in terms of data structure, data integrity, and data manipulation.
2. Create and understand conceptual database models utilizing entity-relationship modeling
3. Design data structures that will limit redundancy and enforce data integrity while conforming to organizational requirements utilizing normalization methodology
4. Understand the theory behind the relational data model as it applies to interactions with current database management systems
5. Read and interpret a given data model to query the database and transform the data into information using Structured Query Language
6. Implement a data model in a current relational database management system
7. Create reports, based on transactional data, including elements such as data groupings and summary values.