MGTA 464. SQL and ETL (2–4 units)
Link to catalog page: https://catalog.ucsd.edu/courses/MGT.html#mgta464
Description
Most organizations store transaction data (e.g., sales, purchases, production, etc.) in relational databases. These databases are of central importance in most business analytics projects. To access and analyze this data, knowledge of SQL (structured query language), one of the most sought-after skills by recruiters, is needed. In this course, students will learn how to write SQL statements to extract and transform data. Students will be introduced to ETL (extract, transform, and load) concepts. Prerequisites: restricted to MS in business analytics students.
Prerequisite courses
MGTA 464 has no prerequisite courses.
Successor courses
No courses have MGTA 464 as a prerequisite.