Databases

• Uvod, primarni i strani ključevi, dizajn baze
• Tipovi podataka, model
• Osnovne DDL i DML naredbe
• String, datumske i agregatne funkcije, NULL vrijednosti
• Kartezijev produkt, prirodno spajanje
• Join
• Aliasi
• Group by, having
• Podupiti
• Ključevi, indeksi, full text indeksi
• Optimizacija upita
• Izrada i vraćanje sigurnosne kopije baze podataka
• Rad s drugim bazama i alatima
• Normalizacija
• Ponavljanje za završni ispit

1. ability to build a database model
2. ability to design normalized database
3. ability to create basic SQL queries
4. ability to construct SQL queries with data filtering
5. ability to control embedded SQL functions
6. ability to connect multiple data tables using SQL queries
7. ability to sort and group data retrieved by a query
8. ability to compare an outer SQL query with an inner SQL query
9. ability to organize and optimize the database using indexes

Required reading

• Kramberger, T.; Duk, S.; Kovačević, R.: Baze podataka, TVZ, Zagreb, 2018, ISBN: 978-953-7048-70-9
  Abraham Silberschatz: DATABASE SYSTEM CONCEPTS SIXTH EDITION, 2011
  Radovan, M.: Baza podataka, Informator, Zagreb, 1993.

Further reading

• Tkalac, S.: Relacijski model podataka, Informator, Zagreb, 1988.
  Ullman, D.,J.: Database and Knowledge – base Systems, Computer Science Press, 1999.
  Date, C.J.: An Introduction to Database Systems, Addison-Wesley publishing Company, New York. 1994.