Topic outline

  • Course Textbook (Required Reading):

    Jeffrey D. Ullman and Jennifer Widom. A First Course in Database Systems, Third Edition, Pearson Education Limited 2014.

    Most relevant chapters for this course are from 1st to 8th. Specific details can be found on Weekly Schedule.

    Aalto University Library has an e-book, using the Proquest platform, which can be read by at most 10 students simultaneously. The textbook is required reading and we plan to follow the book chapters each week, so please read the sections assigned in advance. To access it choose Aalto University as the institution via "Shibboleth login".

    Note: Students are reminded that after using the "Read online" functionality, it is best to leave that screen e.g. via the "more" link under the book information on the left, so as to free the copy for the next reader - just closing the tab might make others wait out a timeout period.

    If you do not need more than 26 pages on any particular day, avoid requesting a "Full download" (which basically means 7-days loan with the help of an external reader software - good for temporary offline use), open the book in the Online reader and use the "Print PDF" button (little printer image) to extract the desired pages as PDF. A PDF obtained that way will NOT expire in 7 days, in contrary to the "Full download". Then leaving the reader (as told above) allows others to access the copy of the book.

    Additional Reading:
    Badia, Antonio. SQL for Data Science - Data Cleaning, Wrangling and Analytics with Relational Databases, Springer International Publishing 2020.