Databases are at the heart of all information systems that are nowadays omnipresent in our everyday life (work, organization, web, etc.). The aim of this course is to study the principles of relational and semi-structured database programming that are the foundation of any application in the various information systems. It also discusses the implementation aspects of database systems such as concurrency control or query optimization.
Introduction (relational models, schems, SQL, semi-structured models, XML) Data models (entitty/relationship, relational, object) relational languages (relational algebre, SQL, Datalog) SQL Programming (PL/SQL, Embeded SQL) Database systems and application Web (JDBC, PHP) XML-WPath-Wquery-Xslt transactions and concurrency control Query optimisation Integrity constraints Olap and Data-mining
40% written test, 60% assignments of practical work