FE 512 Database Engineering

The course provides an introduction to SQL databases and NoSQL databases as available to the Hanlon Financial Systems Lab. At the end of the course the students will be familiar with all the lab resources as well as a working knowledge on how to use them. The students will receive hands on instructions about setting up and working with databases. Most of the software will be introduced using case studies or demonstrations, followed by a lecture of related fundamental knowledge. The course covers SQL (MySQL, WinSQL, PosgreSQL), NoSQL (IBM DB2, OneTick) and database managers Aqua. The course will cover accessing databases using API, SQLConnect and Access methods for DB2.

Credits

3

Prerequisite

Graduate Student or At Least Junior

Distribution

School of Business

Typically Offered Periods

Fall Semester Spring Semester