Alignment

Credits: 
5
Hours: 
60
Area: 
Big Data Technology
Teachers: 
Pellungrini Roberto
Prencipe Giuseppe
Monreale Anna
Academic Year: 
2023-2024
Description: 

The module has the aim to align the students' competences in computer science and in basic analytics, especially in data bases, and Python programming for data science. Starting form a theoretical introduction to the basics of programming and relational database modelling the course will be focused on pratical lectures for learning to query and modelling databases and to solving problems by writing Python programs in both static and dynimic environments. This module is based on hands-on work

Notions: 
  • Lesson 1
    • Introduction to Python: data types, variables
  • Lesson 2
    • Functions, environments of functions variables, input-output, Conditional Statements, Loops
  • Lesson 3
    • Strings, tuples, lists, dictionaries 
  • Lesson 4
    • File Access, debugging, environment management
  • Lesson 5
    • Object oriented programming 
  • Lesson 6
    • Numpy  & Pandas
Technics and tools: 
  • SQL 
  • Microsoft SQL Server
  • Python
  • Numpy
  • Pandas

 

Case studies and datasets: 

 

    Competences: 

    At the end of the course the student will be able to 

    • Model and query a database
    • Approach a problem with an adequate problem solving strategy
    • Implement simple Python programs

    Partners