Data Design and Visualization

Catalog description

This course introduces data design and management. Starting from the traditional relational data model and database fundamentals, the course offers a hands-on introduction to Structured Query Language (SQL) for defining, manipulating, accessing, and managing data, accompanied by the basics of data modeling including entity relationship modeling and diagrams. The course also offers an introduction to NoSQL and data warehousing approaches to handling Big Data. The course further touches upon how artificial intelligence is shaping the field, including query generation and database design from natural language questions. The course concludes with a comprehensive data warehousing project that gives each student the opportunity to integrate and apply the new knowledge and skills learned from this class. Previously BUAN 6510.