Competence in management and use of organizational and external databases is a skill needed by all business people and critical to management information systems effectiveness, especially in the new era of "big data". This course teaches the development and accessing of internal and external information resources. Topics include: ensuring the availability of appropriate data; interrelating and applying data to typical business problems; normalized database design; protecting and managing information resources; scalability; and compatibility issues.
- Knows the basic principles, organizational models, and business uses of computer databases.
- Knows and can apply various techniques to address data integrity, security, privacy and other management issues. Can assess and communicate these issues from a managerial perspective.
- Understands data base design from a user and requirements definition perspective.
- Understands data extraction using tools such as Structured Query Language (SQL) and can apply these tools to solve business problems, including accessing and combining internal and external data resources.