Formal course description
Outline of the course
The course on "Databases in Finance" aims to acquaint students with the basic principles of databases and database management systems (DBMS), which are necessary for every student of finance. Аlong with clarifying the formal definitions of the basic concepts, students get acquainted with a wide range of languages and operators for working with DBMS. The scope of the studied DBMS includes Oracle and Microsoft tools. On the other hand, the course provides students with basic practical skills for working with languages for manipulating relational databases. The course is conducted in English.
Preliminary requirements
Basic course in mathematics, statistics, course in information technology and systems.
Expected outcomes
Upon completion of the course, students will gain basic practical skills for working with DBMS, specific to each business application. Thanks to the practical exercises, students will gain practical knowledge of working with the language for manipulating relational databases and business applications in practice.
Bibliography
Basic
1. Elmasri R., S. Navathe, Fundamentals of Database Systems, 6th Edition, 2010
2. Hoffer J., R. Venkataraman, H. Topi, Modern Database Management, 10th Edition, 2010
3. Oracle Essentials: Oracle Database 11g (Osborne ORACLE Press Series), 2009
4. Loney K., Oracle Database 11g The Complete Reference, Osborne Oracle Press, 2008
5. Alexander M., R. Kusleika, Access 2016 Bible, 1st Edition, Wiley Publisher, 2015
6. C. J. Date. An Introduction to Database Systems. 8th ed., Addison-Wesley, 2003
7. Laudon, K., J. Laudon. Management Information Systems Managing the Digital Firms. 15th ed., Prentice Hall - Pearson, 2018
8. Beitler B., Microsoft Access: Now to Build Access Database Queries, Microsoft Press, 2017
Additional
1. Garcia-Molina H., J.U, J.W. Database Systems. Prentice Hall, 2009
2. Marvin R., AI Databases: What They Are and Why Your Business Should Care, PC Magazine, Oct.2017