Winter Semester 2010/11
Winter Semester 2011/12
Winter Semester 2012/13
Winter Semester 2013/14
Winter Semester 2014/15
Database and Data Warehouse Systems 2 TS1A711260
Course content:
Students are supposed to prepare projects and implementation of databases. They put into practice modelling and define of data and constraints, verify connectivity, integrity and safety of data, programming and implementation of databases. Students execute forming and processing of data, queries, subqueries and views, make use of functions, routines, triggers and transactions on testing data.
Learning outcomes:
Knowledge of databases and data languages problems, ability to implementation, process and make use databases.
(in Polish) Rodzaj przedmiotu
(in Polish) Założenia (prorekwizyty)
Course coordinators
Bibliography
a) basic references:
Connolly T., Begg C.: Systemy baz danych :praktyczne metody projektowania, implementacji i zarządzania.T.1 i 2. RM, Warszawa,2004.
Riordan R.: Projektowanie systemów relacyjnych baz danych. RM, Warszawa, 2000.
Date C. Darwen H.: SQL: omówienie standardu języka. WNT,Warszawa, 2000.
b) supplementary references:
Garcia-Molina H. Ullman J. Widom J.: Database systems : the complete book. Upper Saddle River : Prentice-Hall, 2002.