Info
Foto sezione
Logo Bocconi

Course 2021-2022 a.y.

20591 - COMPUTER PROGRAMMING AND DATABASE SYSTEMS

DSBA
Department of Decision Sciences

Course taught in English

Go to class group/s: 23

DSBA (8 credits - I sem. - OB  |  SECS-S/01)
Course Director:
CARLO LUCIBELLO

Classes: 23 (I sem.)
Instructors:
Class 23: CARLO LUCIBELLO


Lezioni della classe erogate in presenza

Mission & Content Summary
MISSION

Scope of the course is to provide the students with a wide range of skills and knowledge in computation and data management/analysis, which are extensively used throughout the whole education program. While not strictly mandatory, some previous exposure to computer programming (and in particular to the Python language) is highly recommended for this course.

CONTENT SUMMARY
  • Fast and furious introduction to Python.
  • Advanced programming techniques.
  • The Numpy scientific library.
  • Data manipulation with Pandas.
  • Relational databases (SQLite).
  • Non-relational databases (MongoDB).
  • Cloud computing on the The Google Cloud Platform.
  • Parallel and distributed computation (MapReduce).
  • Large scale data analysis with PySpark.

Intended Learning Outcomes (ILO)
KNOWLEDGE AND UNDERSTANDING
At the end of the course student will be able to...
  • Describe fundamental programming strategies and the functioning principles of database systems.
APPLYING KNOWLEDGE AND UNDERSTANDING
At the end of the course student will be able to...
  • Read/write advanced Python codes.
  • Master object-oriented programming.
  • Develop codes for algorithmic problem solving.
  • Handle large scale databases.

Teaching methods
  • Face-to-face lectures
  • Online lectures
  • Exercises (exercises, database, software etc.)
DETAILS

Exercises consist in programming assignments to be done in class under the supervision of the Instructor and  the Teaching Assistants.


Assessment methods
  Continuous assessment Partial exams General exam
  • Written individual exam (traditional/online)
  •     x
    ATTENDING AND NOT ATTENDING STUDENTS
    • The written exam consists of programming exercises to be performed in the computer room.
      The programming exercises aim to assess the understanding of fundamental programming strategies and the knowledge of database systems.

    Teaching materials
    ATTENDING AND NOT ATTENDING STUDENTS

    The textbooks are communicated prior to the start of the course. Handouts of each lecture and sample codes are provided.

    Last change 22/10/2021 12:37