The most beautiful moments in life, you cannot plan. They come themselves. - Phil
Bosmans
Teaching
Databases
The course discusses the basic mechanisms applied in databases. Students are taught how to: design relational databases, create a database and database objects, use SQL language in data processing, manange transactions and data integrity.
Additionally, software useful in dealing with a database is presented. These are: MS Access for developing a database application, MySQL server and client tools as an example of a database server and JDBC/ORM interfaces. Furthermore, some post-relational mechanisms in the PostgreSQL system are also shown.
The aim of the course is to present software development methods, requirement analysis and management, using UML in a system model development and transformation into program code.
During the course, students are acquinted with agile software development and team members' roles and responsibilities. Students have the opportunity to work on projects using SCRUM methodology.
They learn such techniques as pair programming, test-driven development, continuous integration, refactoring and retrospective.
Students plan their schedule on the basis of product and sprint backlogs taking sprint planning meetings, daily scrum meetings, sprint reviews into account.
Hibernate (Java), Entity Framework (.NET) and Oracle TopLink ORMs are discussed during the course as well as the advantages and disadvantages of their usage. Taking part in classes, students have the possibility to apply ORMs’ mechanisms in practice. They solve problems related to data structures' design and their use in database querying, learning how to use HQL and LINQ.
