Databasteknik: Exercise 1 - Logging in into Mimer

This is an exercise. You don't have to show or hand in anything, but if you have any problems or questions, you are welcome to ask your teaching assistant.



You may wish to look at the following:


You can do these exercises by yourself or in groups of two.
  1. If you are doing this exercise on your own computer, download and install Mimer SQL from the Mimer Developer website
  2. If you are doing this exercise on your own computer, you can create a local database. But if you want to store your database on the Mimer server on the university's database server, you need to get a login name and a password from the teacher. Then use Mimer Administrator to tell Mimer that there is a remote database called dbk, which runs on a server called
    (There are some more details in Getting started with Mimer.)
  3. Connect to the Mimer database with the program Batch SQL (also called BSQL). If DbVisualizer is installed and works on your computer, it can be a friendlier alternative, but it doens't understand all SQL commands that Batch SQL does.
    (There are some more details in Getting started with Mimer.)
  4. Login using your login name and password.
  5. Try out some of the SQL commands from chapter 1 in the book. They can also be found in the chapter Introduktion till databaser och databashanterare in the web course. Does Mimer understand all the commands? Do you get any errors? Why?
    A tip: You can use the SQL command insert to insert new rows in a table:
    insert into kund values (7, 'Hjalmar', 'Vägen 7');
  6. Go to the Mimer web site,
  7. Find the right version of Mimer to download and install on your home computer! (Remember it, so you can actually do this later, if you have access to a computer at home.)
  8. Find the manual at the web page, and use the index to look up the word databank. What is a databank in Mimer?
  9. Are there any other Mimer tools installed on the computer? Which? What can you do with them?

Thomas Padron-McCarthy (, March 29, 2020