This course provides a hands-on introduction to relational databases, covering fundamental aspects of database modeling and design. Emphasis is placed on data modeling and using the SQL language for creating, modifying and querying relational databases. The course employs a blended learning-by-doing approach, enabling all aspects of database use and database design to be practiced by students.

Course content

  • Introduction to database systems.
  • Relational database model.
  • Structured Query Language (SQL).
  • Database modelling and design.
  • Entity-relationship (ER) model.
  • Functional dependencies and normalization.
  • Indexes and performance optimization.
  • Transactions and concurrency control.
  • Database security and access control.
  • Python database application programming interface.


This is an excerpt from the complete course description for the course. If you are an active student at BI, you can find the complete course descriptions with information on eg. learning goals, learning process, curriculum and exam at portal.bi.no. We reserve the right to make changes to this description.