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.
To be admitted to the course, 60 ECTS credits in Computing Science or two years of completed studies are required, in both cases including the courses (or equivalent): 1) Either CS2: Algorithms and problemsolving (5DV169) or Data Structures and Algorithms (5DV149/5DV150) and 2) CS4: Logic for computer science (5DV163) or 5DV102 Fundations of Logic and Model Theory or Mathematics courses comprising of 22.5 ECTS-credits. 3) Proficiency in English equivalent to Swedish upper Secondary course English A/5. Where the language of instruction is Swedish, applicants must prove proficiency in Swedish to the level required for basic eligibility for higher studies.