EduXchange.NL

Data management for data analytics

JBI050

Over deze cursus

After this course, students will be able to

  • understand the basics of conceptual data modeling in the Entity Relationship model and UML, and translating a natural language specification of a conceptual model into a relational database schema;
  • understand the relational database model;
  • understand and create advanced SQL and Datalog queries for retrieving relevant data, potentially spanning multiple database tables and involving recursion and aggregation of data;
  • will acquire the ability to design, based on a problem description in a variety of application domains, a database suited to solve this problem; and,
  • will be able to quickly master and make practical use of contemporary frameworks and technologies for relational data management.

Leerresultaten

The focus of the course is on practical problem-solving in an application domain. Students will gain practical experience developing the ability to design effective databases based on a solid understanding of the underlying principles. By design, hands-on practical assignment(s) using contemporary frameworks and technologies are a central component of the course. The following topics will be covered:

  • Data modeling: conceptual modeling in the ER model and UML; logical data modeling in the relational database model; optimization of logical models, basics of normalization.
  • Querying databases: SQL basic queries, aggregation; Datalog basic queries, recursion.

Voorkennis

Je moet voldoen aan de volgende eisen

  • Ingeschreven voor een andere opleiding dan
  • HBO-TOP Applied Physics, Schakelprogramma, Voltijd
  • Geen van onderstaande cursussen mag zijn behaald
  • Datamodelling and Databases (2ID50)

Bronnen

  • “Database System Concepts”, Sixth Edition. Silberschatz, Korth and Sudarshan, 2011 (ISBN 978-0-07-352332-3). Weekly readings will be posted on Canvas.

Aanvullende informatie

  • Studiepunten
    ECTS 5
  • Niveau
    bachelor
Als er nog iets onduidelijk is, kijk even naar de FAQ van TU Eindhoven.

Aanbod

  • Startdatum

    3 februari 2025

    • Einddatum
      6 april 2025
    • Periode *
      Blok 3
    • Locatie
      Eindhoven
    • Voertaal
      Engels
    • Inschrijven tussen
      15 nov, 00:00 - 5 jan 2025
    Inschrijving open
Dit aanbod is voor studenten van Utrecht University