Data Management and Python Programming
In the new economy data will be an ever more important aspect of business. Firms are slowly reacting to more data available on consumer behavior and markets in general. Competence in programming skills is essential to extract information and knowledge from data.
Advances in our capability to generate and collect information are pushing us toward a business world centered around data. Databases are currently at the heart of modern organizations. This course covers the basic concepts of data management, database systems, and the use of databases in business applications.
The goals of this course are twofold:
i) to introduce learners to the basics aspects of Python programming with a special focus on data analysis
ii) to provide adequate technical detail related to capturing, cleaning, and accessing data, while emphasizing the organizational and implementation issues relevant in an organization environment.
The first part of the course introduces students to Python programming. Students will use the Python syntax to work with, among others, different data types, loops, and functions.
The second part of this course will teach students the principles of working with relational databases. They will learn the principles of good database design, as well as the practical aspects of retrieving data from such databases using SQL. Finally, they will know how to interface programs written in python with a database.
Learning outcome knowledge
- Understand basic concepts of Python programming.
- To gain basic knowledge in data analysis.
- Understand the principles of good database design;
- Gain an understanding of relational database management systems;
- Develop an understanding of Structured Query Language (SQL);
- Comprehend how database systems are used for strategic and operational decision making
- Home exam: 50%
- Home exam: 50%