MSDA 6334 Database Management for Data Analytics
Database Management for Data Analytics provides students with the knowledge required to perform efficient data analysis with the power of databases like SQL and MongoDB. The course begins with an overview of data types, data structures, working with tables, and writing queries to assemble, transform, and assess data. Students will learn how to create and use databases to prep data, perform descriptive analyses, and to conduct more advanced statistical techniques. Students will also learn database scanning methods, how to write functions, how to create triggers, and how to work with dates, times, and locations. Finally, how to copy data to and from a database will be covered, making it possible for the analyst to quickly transition from a relational database to statistical processing software packages for more robust data analyses.
Offered
Summer, Fall, Spring