Skip to main content
MyCourses MyCourses
  • Schools
    School of Arts, Design, and Architecture (ARTS) School of Business (BIZ) School of Chemical Engineering (CHEM) –sGuides for students (CHEM) – Instructions for report writing (CHEM) School of Electrical Engineering (ELEC) School of Engineering (ENG) School of Science (SCI) Language Centre Open University Library Aalto university pedagogical training program UNI (exams) Sandbox
  • Service Links
    MyCourses - MyCourses instructions for Teachers - MyCourses instructions for Students - Teacher book your online session with a specialist - Digital tools for teaching - Personal data protection instructions for teachers - Workspace for thesis supervision Sisu Student guide Courses.aalto.fi Library Services - Resourcesguides - Imagoa / Open science and images IT Services Campus maps - Search spaces and see opening hours Restaurants in Otaniemi ASU Aalto Student Union Aalto Marketplace
  • ALLWELL?
    Study Skills Guidance and support for students Starting Point of Wellbeing About AllWell? study well-being questionnaire
  •   ‎(en)‎
      ‎(en)‎   ‎(fi)‎   ‎(sv)‎
  • Toggle Search menu
  • Hi guest! (Log in)

close

Can not find the course?
try also:

  • Sisu
  • Courses.aalto.fi

CS-A1153 - Databases, 20.04.2021-25.05.2021

This course space end date is set to 25.05.2021 Search Courses: CS-A1153

  1. Home
  2. Courses
  3. School of Science
  4. department of...
  5. cs-a1153 - da...
  6. Sections
  7. Weekly Schedule
 
Syllabus
 

Weekly Schedule

  • Weekly Schedule

    Weekly Schedule


    Week 1 (April 20–25)
    Recommended readings: U & W: 1.1-1.2, 2.1-2.2, 2.4, 6.1-6.3
    Tue 20 April
    16:15-18:00 Lecture (PDF slides)
    Model:
    Introduction to Databases and Relational Models (Prof. Nitin Sawhney)
    Theory: Introduction to Relational Algebra (Prof. Barbara Keller)
    Application: Introduction to SQL (Sami El-Mahgary)
    Wed 20 April
    10:15-12:00 Exercise session (Long and Etna)
    Thr 20 April
    10:15-12:00 Exercise session (Binh and Trang)
    Fri 20 April
    10:15-12:00 Exercise session (Sophie and Etna)
    Week 2 (April 26 – May 2) 
    Recommended r eadings: 4.7, 3.1-3.2, 2.3, 7.1-7.4, 8.1-8.2
    Mon 26 April
    18:00 Homework 1 deadline at 18:00 
    Tue 27 April
    16:15-18:00 Lecture (PDF slides)
    Model:
    UML Modeling & Relational Diagrams - Part I (Prof. Nitin Sawhney)
    Theory: Functional Dependencies & Normal Forms I (Prof. Barbara Keller)
    Application: Defining SQL Tables, Integrity Constraints and Views (Sami El-Mahgary)
    Wed 28 April
    10:15-12:00 Exercise session (Long and Etna)
    Thr 29 April
    10:15-12:00 Exercise session (Binh and Trang)
    Fri 30 April
    10:15-12:00 Exercise session (Sophie and Etna)
    Week 3 (May 3–9)
    Recommended r eadings: 4.8, 3.3-3.6, 6.4.3-6.4.7
    Mon 3 May
    18:00 Homework 2 deadline at 18:00
    Tue 4 May
    16:15-18:00 Lecture (PDF slides)
    Model:
    UML Modeling & Relational Diagrams - Part II (Prof. Nitin Sawhney)
    Theory: Functional Dependencies & Normal Forms II (Prof. Barbara Keller)
    Application: Advanced SQL and Aggregation (Sami El-Mahgary)
    Wed 5 May
    10:15-12:00 Exercise session (Long and Etna)
    Thr 6 May
    10:15-12:00 Exercise session (Binh and Trang)
    Fri 7 May
    10:15-12:00
    14:15-16:00
    Exercise session (Sophie and Etna)
    Exercise session (Binh and Trang)
    Week 4 (May 10–16)
    Recommended r eadings: U & W: 1.2.4, 6.6, 7.5, 8.1-8.4
    Mon 10 May
    18:00 Homework 3 deadline at 18:00 (extended)
    Project Part 1 deadline at 18:00 (extended)
    Tue 11 May
    16:15-18:00 Lecture (PDF slides)
    Views and Indexes
     (Prof. Nitin Sawhney)
    Transactions (Prof. Barbara Keller)
    Triggers (Prof. Nitin Sawhney)
    Wed 12 May
    10:15-12:00 Exercise session (Long and Etna)
    Wed 12 May
    18:00 Homework 3 deadline at 18:00 
    Project Part 1 deadline at 18:00

    Thr 13 May
    10:15-12:00 Exercise session (Binh and Trang) (Moved to Friday 14:15 - 16:00)
    Fri 14 May
    10:15-12:00 Exercise session (Sophie and Etna)
    Week 5 (May 17–23) 
    Recommended r eadings: A. Badia: 1.5, 3.3.2, 3.3.3, 3.4.1, 6.2.2.
    Tue 18 May
    16:15-18:00 Lecture (PDF slides)
    SQLite in Python
    (Sami El-Mahgary)

    Data Analysis using SQL Queries (Sami El-Mahgary)

    Wed 19 May
    10:15-12:00 Exercise session (Long and Etna)
    Wed 19 May
    18:00 Homework 4 deadline at 18:00 
    Thr 20 May
    10:15-12:00 Exercise session (Binh and Trang)
    Fri 21 May
    10:15-12:00 Exercise session (Sophie and Etna)
    Week 6 (May 24–30) 
    Tue 25 May
    16:15-18:00 Lecture
    Course Wrap-up
    Project Presentations & Discussion
    Wed 26 May
    10:15-12:00 Exercise session (Long and Etna)
    Wed 26 May
    18:00 Homework 5 deadline at 18:00
    Project Part 2 deadline at 18:00
    Thr 27 May
    10:15-12:00 Exercise session (Binh and Trang)
    Fri 28 May
    10:15-12:00 Exercise session (Sophie and Etna)
    Week 7 (May 31 – June 6)
    Wed 2 June
    10:15-12:00 Additional Exercise Session (Long, Sophie, and Etna)
    Fri 4 June
    18:00 Project Part 3 Deadline at 18:00
    Week 8 (June 7 – June 13)
    Mon 7 June
    18:00 Project Part 3 Deadline at 18:00
    Fri 11 June
    18:00 Project Deliverable Package Deadline at 11:00
     
     

    Course home

    Course home

    Next section

    Lectures and Video Recordings►
    Skip Upcoming events
    Upcoming events
    Loading
    Site event MyCourses maintenance, service out of use
    Monday, 12 June, 10:00 » 17:00

    Go to calendar...
    • CS-A1153 - Databases, 20.04.2021-25.05.2021
    • Sections
    • Databases for Data Science
    • Weekly Schedule
    • Lectures and Video Recordings
    • Study Materials
    • Home
    • Calendar
    • Learner Metrics

    Aalto logo

    Tuki / Support
    Opiskelijoille / Students
    • MyCourses instructions for students
    • email: mycourses(at)aalto.fi
    Opettajille / Teachers
    • MyCourses help
    • MyTeaching Support form
    Palvelusta
    • MyCourses rekisteriseloste
    • Tietosuojailmoitus
    • Palvelukuvaus
    • Saavutettavuusseloste
    About service
    • MyCourses protection of privacy
    • Privacy notice
    • Service description
    • Accessibility summary
    Service
    • MyCourses registerbeskrivining
    • Dataskyddsmeddelande
    • Beskrivining av tjänsten
    • Sammanfattning av tillgängligheten
    
    Hi guest! (Log in)
    • Schools
      • School of Arts, Design, and Architecture (ARTS)
      • School of Business (BIZ)
      • School of Chemical Engineering (CHEM)
      • –sGuides for students (CHEM)
      • – Instructions for report writing (CHEM)
      • School of Electrical Engineering (ELEC)
      • School of Engineering (ENG)
      • School of Science (SCI)
      • Language Centre
      • Open University
      • Library
      • Aalto university pedagogical training program
      • UNI (exams)
      • Sandbox
    • Service Links
      • MyCourses
      • - MyCourses instructions for Teachers
      • - MyCourses instructions for Students
      • - Teacher book your online session with a specialist
      • - Digital tools for teaching
      • - Personal data protection instructions for teachers
      • - Workspace for thesis supervision
      • Sisu
      • Student guide
      • Courses.aalto.fi
      • Library Services
      • - Resourcesguides
      • - Imagoa / Open science and images
      • IT Services
      • Campus maps
      • - Search spaces and see opening hours
      • Restaurants in Otaniemi
      • ASU Aalto Student Union
      • Aalto Marketplace
    • ALLWELL?
      • Study Skills
      • Guidance and support for students
      • Starting Point of Wellbeing
      • About AllWell? study well-being questionnaire
    •   ‎(en)‎
      •   ‎(en)‎
      •   ‎(fi)‎
      •   ‎(sv)‎