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, Apache Cassandra, przykłady
- Architektura Aplikacji
- DDD, przykłady
- NHibernate, przykłady (z pakietami, ~30MB), przykłady (bez pakietów, ~1,5MB)
- Warstwa prezentacji, przykłady
Listy zadań
| Exercises | Title | Monday | Wednesday | Thursday |
| Lista 1 | T-SQL: basics | 14.10.2024 | 16.10.2024 | 17.10.2024 |
| Lista 2 | T-SQL: programming | 21.10.2024 | 23.10.2024 | 24.10.2024 |
| Lista 3 | Cursors and Triggers | 28.10.2024 | 30.10.2024 | 31.10.2024 |
| Lista 4 | Transactions and locks | 4.11.2024 | 6.11.2024 | 7.11.2024 |
| Lista 5 | Optimization | 18.11.2024 | 27.11.2024 | 21.11.2024 |
| Lista 6 | MongoDB | 25.11.2024 | 04.12.2024 | 28.11.2024 |
| Lista 7 | Neo4j and Cassandra | 02.12.2024 | 11.12.2024 | 05.12.2024 |
| Lista 8 | DDD Solution | 09.12.2024 | 18.12.2024 | 12.12.2024 |
| Lista 9 | NH | 16.12.2024 | 08.01.2024 | 19.12.2024 |
| Lista 10 | UI, FPS | 09.01.2024 | 15.01.2024 | 16.01.2024 |
| Lista 11 | Validation | 13.01.2024 | 22.01.2024 | 23.01.2024 |
| Lista 12 | API | 20.01.2024 | 29.01.2024 | 30.01.2024 |
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.
- Finally, please ensure you follow kodeks samodzielnego studiowania.
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 |