Coding for Data Science and Data Management AA 2018-19 - Syllabus

Module in Coding for Data Science

  • PYTHON
    • Introduction to the language, environment, set up
    • Data structures 1: numeric, string
    • Control flow structures
    • Data structures 2: list, set, tuple, dict
    • Data Structures 3: collections, lambda, json
    • File I/O
    • Objects: introduction and basics
    • Numpy and linear algebra
    • Pandas 1: indexing and series
    • Pandas 2: dataframe
    • Pandas 3: graphics
  • R
    • Introduction and first steps
    • Data structures: vectors, array, data.frames, lists, environments
    • Loop and flow controls
    • Functions and object
    • Vectorized calculus and function vectorization
    • S3 and S4 object oriented programming
    • Parallelization and optimizztion
Textbook and teaching stuff
  • Online resources and lecture stuff that can be downloaded from the course website

Module in Data Management

  • Introduction to relational database. Information and data; database and database systems (DBMS); the relational model, integrity constraints, key definition, primary key constraints; foreign key constraints.
  • Database languages. Data definition languages; data manipulation languages; queries with the SQL language; simple queries, group queries with aggregate operators; queries with set operators; nested queries.
  • Introduction to NoSQL databases. Data models for NoSQL; CAP theorem (coherence, availability, tolerance); types of NoSQL; comparison against the relational model.
  • NoSQL database systems. The “document-oriented” data model; the MongoDB system; collection in MongoDB; collection queries in MongoDB; aggregation pipeline in MongoDB; the “column-family” data model; the Cassandra system; keyspace in Cassandra; keyspace queries in Cassandra; the CQL language.
Textbook and teaching stuff
  • Choose the preferred book between the following alternatives:
    • P. Atzeni, S. Ceri, S. Paraboschi, R. Torlone. Database Systems – Concepts, Languages and Architectures. Mc-Graw Hill, Available on-line at http://dbbook.dia.uniroma3.it.
    • R. Elmasri, S.B. Navathe. Fundamentals of Database Systems, 7th edition. Pearson, 2015.
  • Online resources and lecture stuff that can be downloaded from the course website
Latest news
RSS feed
The news on this website are up-to-date. Please, DO NOT send emails for information and date/time confirmations that are already published on these pages.

Technical site support is provided by the ISLab.