Course description

Data Management and Python Programming

Introduction

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.

 

Course content

This courses introduces the students to Python programming. Students will use the Python syntax to work with, among others, different data types, loops, and functions.

A second component of this course is to learn the principles of working with relational databases. Students 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

First part

  • Understand basic concepts of Python programming.
  • To gain basic knowledge in data analysis.

Second part

  • 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

 

Exam organisation

  • Home exam: 50%
  • Home exam: 50%