This course develops applied knowledge in four main areas. First, students will analyze real-world situations and design high fidelity data models, which are schematic drawings that define how data elements are conceptually interconnected. Second, students will convert data models into practical relational databases, which are digital containers that hold data and preserve the various data interrelationships. Third, students will access and query structured relational databases, unlocking and converting data into useable knowledge. Fourth, students will get a practical introduction to tools for managing and utilizing unstructured large-scale databases. In this course students will:
- Analyze real-world situations and learn how to design high fidelity graphical data models to explicitly reveal underlying interrelationships between data elements.
- Convert data models into practical database structures, using relational database software tools such as MySQL and phpMyAdmin.
- Query structured relational databases, using Structured Query Language (SQL) and Business Intelligence (BI) tools.
- Explore unstructured “big data” datasets, using frameworks, concepts and tools such as Hadoop, NoSQL, MongoDB, Tableau and Python.