University of Helsinki Department of Computer Science, ©Harri Laine

Topics

This course is intended as a first year course in Computer Science. It assumes basic knowledge on programming (in Java), WWW and HTML. The 'Database design' part at the end of the course assumes knowledge about UML class diagrams (taught in the course Introduction to Appication Analysis and Design).

The course covers basic concepts of relational databases: structure and use of the database, SQL database language and principles of programming database applications (in Java).

• What is a database
  Elmasri&Navathe: Ch 1
• Data models
  Elmasri&Navathe: Ch 2.1, pages 23-27
• Database system
  Elmasri&Navathe: Ch 2.2 -2.6, pages 27-39
• The relational model of data
  • domain
  • relation
  • key
  • foreign key
  • referential integriy
  
  Elmasri&Navathe: Ch 7.1-7.2, pages 195-208
• Relational algebra
  Elmasri&Navathe: Ch 7.4, pages 211-224 (division excluded), 7.5.3, 7.6, 7.7 pages 228-235
• SQL
  • SQL data definition
    Elmasri&Navath: Ch 8.1 pages 243-251
  • SQL queries, the basics
    Elmasri&Navathe: Ch 8.2, pages 251-261
  • SQL queries, additional features
    Elmasri&Navathe: Ch 8.3, pages 261-275.
  • SQL views
  • SQL data manipulation
    Elmasri&Navathe: Ch 8.4-8.5, pages 275-282
• Database applications
  • Concepts
  • Java database programming - JDBC
    Harri Laine: Database programming
  • WWW- database applications
    Elmasri&Navathe: Ch 27.1
• Introduction to database design
  Elmasri&Navathe: Ch 14.1

SQL practicing is carried out with the automated SQLTrainer practice environment.