Skip to content
My profile

Course

Database modeling and administration

Elective6 ECTSSemester 360 h teachingTaught in Croatian

Course description

The course description is available in Croatian only.

  • Tipovi baza podataka, ACID svojstva
  • Objekti
  • Tipovi podataka, SQL upiti ER model
  • Konceptualno, logičko i fizičko modeliranje, napredni sql upiti
  • Normalizacija baze podataka, indeksi
  • Pogledi, uskladištene procedure, okidači, skalarne, agregatne i tablične funkcije
  • Replikacija (Snapshot, Transactional, Peer to peer, Merge) SQL Server administracija (scheme, uloge, prava korisnika)
  • Izrada DB klijent aplikacija pomoću ADO komponenti
  • Konkuretnost u više-klijentskom okruženju
  • Nema nastave

When and where

The timetable and room occupancy are available after signing in with your TVZ account.

Sign in with TVZ account

Course announcements

Source: Digit (Moodle). Full announcements are available to students enrolled in the e-course.

Learning outcomes

  1. Install and configure database server.
  2. Create ER database model
  3. Perform dabatase normalization
  4. Create SQL quaries, procedures and triggers
  5. Create database schemas, users and roles
  6. Create database replication
  7. Create client application using ADO components

Course coordinators 1

Teaching staff 1

Exam dates

Exam dates for this academic year are not published yet. Last year's dates:

within 10 days within 30 days later past
Source: ISVU. Click a date to open Studomat and register; check it for changes too.