Subject: Database programming
Course: Database programming
ECTS credits: 6
Language: Croatian
Duration: 1 semester
Status: elective
Method of teaching: 2 lecture hour + 2 hour of practical class
Prerequisite: n/a
Assessment: practical and oral exam
 
Course description:
Basics concepts of database design. SQL server. SQL queries. Tables and creating  relationships between tables. Indexes, views, stored procedures, triggers. Object models ADO and ADO.net. Data driven controls. Cursors. Database programming using ADO and ADO.net objects. Locking. Concurrence. Database locking levels and mechanisms. Mutual exclusion. Application locking. Replication. Database security.
During the semester students are expected to do project based practical work.

Course objectives:
The objective of this course is for students to get acquainted with procedures of database design. By working on concrete problems, students will acquire proficiency in different programming skills in database design. To achieve this objective, students will have opportunity of using some of the available SQL servers and visual programming tools.

Quality check and success of the course: Quality check and success of the course will be done by combining internal and external evaluation. Internal evaluation will be done by teachers and students using survey method at the end of semester. The external evaluation will be done by colleagues attending the course, by monitoring and assessment of the course.

Reading list:
1. Radovan, M.: Baza podataka, Informator, Zagreb, 1993.
2. Date, C. J.: An Introduction to Database Systems, Addison-Wesley publishing Company, New York. 1994.
3. Gunderloy M., J. Joreden: SQL server 2000, Sybex Inc., 2000.
4. Dobson R.: Programing SQL server 2000, Miscrosoft Press, 2002.