2024/2025 Autumn Semester
Course Coordinators:
- Romas Baronas, Prof., Dr. (HP)
- Elita Pakalnickienė, Partn. Prof., Dr.
Contains SQL exercises covering base database concepts:
- uzd1.sql - Basic SQL queries and SELECT statements
- uzd2.sql - Data manipulation (INSERT, UPDATE, DELETE)
- uzd3.sql - JOIN operations and multi-table queries
- uzd4.sql - Aggregate functions and GROUP BY
- uzd5.sql - Subqueries and advanced operations
These exercises correspond to topics covered in the DBVS.pdf course materials.
The teatras/ directory contains a database design for opera and ballet theater:
Java Client Application:
- Database connectivity using JDBC
- CRUD operations for theater database
- Query interface for retrieving information