BUAI 470
Data Management with SQL
This course introduces students to the design, querying, and management of relational databases using SQL. Students will gain hands-on experience creating, manipulating, and retrieving data from databases, with a focus on applications in business analytics. Topics include relational model fundamentals, SQL queries, joins, aggregations, subqueries, views, data cleaning, and basic database design. Practical exercises and a final project will reinforce learning through direct application to real business analytics problems.
Topics
- relational model fundamentals
- SQL queries
- joins
- aggregations
- subqueries
- views
- data cleaning
- and basic database design
Topics explicitly listed in official catalogue description
Sources
- Course catalogue ↗2026-2027