Introduction to Database Management

Utbildningsfakta

Kod: 5DV202

This course covers the concepts and tools necessary to use database systems. This starts with introducing the relational and semi-structured models of data and then delving into the classic relational query languages (tuple calculus and relational algebra), normalization theory and entity-relationship modeling. This is followed by an in-depth coverage of SQL including its use in a server environment. The last part of the course covers semi-structured data models using XML and accessed via XPath/XQuery. The course consists of two parts: **Part 1, principles, 4.5 credits:** This part covers the following topics: the relational model of data; the use of SQL, as both a stand-alone language and its use in applications with C, Java or Python as the host language, to express queries and updates as well as to declare schemata; the relational algebra and calculus; Entity Relationship-based schema design; and the normalization of relational schemata. The semi-structured data model as represented in XML and accessed in XPath/XQuery. **Part 2, practice, 3 credits.** In the practice part some of the theories and techniques discussed in the principles part are put into practice. This consists of a series of mandatory practical assignments.

Behörighet

At least 90 ECTS, including 60 ECTS Computing Science, or at least 120 ECTS within a study programme. At least 7.5 ECTS programming; 7.5 ECTS data structures and algorithms; either (a) 22.5 ECTS mathematics or (b) 7.5 ECTS discrete mathematics and 7.5 ECTS logics. Proficiency in English equivalent to the level required for basic eligibility for higher studies.

Utbildningstillfällen

Varje tillfälle har egna datum och villkor. Avslutade tillfällen behålls som historik och innebär inte att en ny ansökan är öppen.

• Introduction to Database Management

  Umeå University

  Startdatum: 18 januari 2027

  Slutdatum: 24 mars 2027

  Studietakt: 50 %