The overall goal is that, after following this course, you will understand the professional terminology, and be able to design, implement and use a DBMS to manage large quantities of data. Basically, data management concerns how to store, modify and query data, as well as how to delete data, when using a DBMS.
We will use book Head First SQL by Lynn Beighley as the textbook. The lectures will roughly follow the chapters in that book.The book is avaiable at the local bookstore.
There will be 11 lectures in total, each in a form of mixing/interweaving usual lecturing and quiz/exercises. In addition, there will be a self-study session on a single topic. Please remember to bring your laptops to the classroom for quiz/exercises. We will use MySQL as the default RDBMS for lecturing and exercises. You're supposed to install it on your laptop for the course. (If you use another RDBMS, we don't promise to offer full service due to the number of students.)
The final exam will be an openbook written exam with questions on the contents covered in the lectures. It is highly recommended that you read the book, do the exercises, and try out SQL commands during the entire semester, in order to get you well prepared for the exam.
Note: Please bring your textbook and laptop with you to ALL lectures unless stated otherwise.
- Secretary: Vinzent Dahl
- Secretary: Williwaw Leth
- Secretary: Simohamed Mølgaard
- Secretary: Zanib Pedersen
- Teacher: Larysa Nikolajsen