Projektowanie aplikacji z bazami danych
Design of an application processing data is multi-tier and requires components of different purposes. The goal is to present the appropriate design and implementation of this kind of application. During the classes we will proceed with a sequence of steps which will lead to understanding and creating of specific parts of the system and in the end we will get a complete and working application. More details are available at System Zapisów.
News
(none)
Presentations and examples
- Program
- Podstawy SQL Server
- TSQL: podstawy, przykłady
- TSQL: programowanie, przykłady
- Kursory, przykłady
- Wyzwalacze, przykłady
- Transakcje i blokady, przykłady
- Optymalizacja
- MongoDB, przykłady
- Neo4j
- Architektura aplikacji
- Domain-Driven Design, przykłady
- NHibernate, przykłady
Listy zadań
| Exercises | Title | Monday | Tuesday | Wednesday |
| Lista 1 | T-SQL: basics | 16.10.2023 | 17.10.2023 | 18.10.2023 |
| Lista 2 | T-SQL: programming | 23.10.2023 | 24.10.2023 | 25.10.2023 |
| Lista 3 | Cursors | 30.10.2023 | 31.10.2023 | 8.11.2023 |
| Lista 4 | Triggers | 6.11.2023 | 7.11.2023 | 22.11.2023 |
| Lista 5 | Transactions and locks | 13.11.2023 | 14.11.2023 | 29.11.2023 |
| Lista 6 | Optimization | 20.11.2023 | 21.11.2023 | 6.12.2023 |
| Lista 7 | MongoDB | 27.11.2023 | 28.11.2023 | 13.12.2023 |
| Lista 8 | Neo4j | 4.12.2023 | 5.12.2023 | 20.12.2023 |
| Lista 9 | DDD solution baseline | 11.12.2023 | 12.12.2023 | 3.01.2024 |
| Lista 10 | NHibernate | 18.12.2023 | 19.12.2023 | 10.01.2024 |
| Lista 11 | UI | 8.01.2024 | 9.01.2024 | 17.01.2024 |
| Lista 12 | Filtering, paging, sorting | 15.01.2024 | 16.01.2024 | 24.01.2024 |
| Lista 13 | Validation, API | 22.01.2024 | 23.01.2024 | 26.01.2023 |
Rules
- During each class only exercises with a specific due date should be presented (unless otherwise agreed with the lecturer).
The approach in case of delay should be also agreed with the respective lecturer. - At the beginning of each laboratory class, each student should declare which tasks he or she is ready to present (and by that collect the respective points)
- Exercise sets will be published till each Wednesday evening (occasionally might be Thursday evening)
- Solutions should be presented during the laboratory classes. Any other way (e.g. sending files over e-mail) only after the earlier agreement with the lecturer.
- Points collected during the semester will determine the final grade according to the below table.
Points tresholds table
| Points | Grade |
|---|---|
| 100%-90% | 5.0 |
| 90%-80% | 4.5 |
| 80%-60% | 4.0 |
| 60%-50% | 3.5 |
| 50%-40% | 3.0 |
| 40%-0% | 2.0 |