Learning Outcomes
Information systems are fundamental in business and industrial applications. Flight bookings, online shopping, large enterprise resource planning and production control systems are just a few examples. Driving modern economy and science today are individuals with competences in efficient data management and deep data analysis, whose contributions lead to new insights and facilitate decision-making. Upon completion of this course, students will have: (i) mastered basic concepts in information management and relational database management systems (RDBMS), (ii) learned how to develop information models, and (iii) grasped how to formulate queries in relational algebra and express these in SQL. They will be able to describe a data warehouse, compare it to transaction systems, and decide which requirements are essential for a given application profile. Furthermore, they will learn about data analytics using classification & clustering algorithms and apply them to a database using SQL and Java.
Content
1. Architecture of Information Systems
2. Relational Data Model
3. Relational Algebra
4. Query Language SQL
5. Transaction Systems
6. Declarative Procedures and Query Optimization
7. Data Warehousing
8. Data Base Management vs Data Streams Management
9. Introduction to Data Science
10. Algorithms for Data Analytics: Classification & Clustering algorithms