Course Outline
Database Logic analysis and problems
- Where to find logic
- How to distinguish logic which should be migrated out of database and the logic which can stay
- Scalability issues
- Creating unit tests
Migration strategies analysis - pros and cons
- Flexibility vs speed
- Speed vs scalability
- Procedural Language to Service
- PL to PL
- Removing intermediate derived data (cash) and replacing with life logic
- OLTP vs Warehouse
Design of new logic adapter service
- Using traditional programming
- Using Rule Engines or other Logic Engines
- Unit Testing
- Performance and scalability issues
Changing Client Site
- ORM (Object-relations mapping) frameworks
- Using web-service output instead of a query or stored procedure
- Performance testing
- Profiling (finding bottlenecks and performing optimisation)
Requirements
Good understanding of SQL, database structure and fair understanding of procedural language (e.g. PL/SQL, SQL PL, etc...)
Testimonials (6)
Our group was not that big so every time we asked a question we received an extensive answer with examples. So everything was well explained and it can be noticed that trainer has a great knowledge.
Iwona - Universal-Investment-Gesellschaft mit beschränkter Haftung
Course - Access Intermediate
Organizacja i praktyczne podejście do tematy
Adam Cedrowicz - Unilever Poland Services sp. z o.o
Course - Access - podstawy
Ćwiczenia praktyczne z trenerem
Zuzanna Szcześniewska - Narodowy Fundusz Zdrowia
Course - Access - Data Base Designing
Szkolenie przeprowadzone gruntownie od zagadnień podstawowych po te bardzo zaawansowane. Trener przyjazny, chętnie udzielający odpowiedzi na zadawane pytania.
Anna Gerlich - UBS Business Solutions Poland Sp. z o.o.
Course - SQL in Microsoft Access
Training Room and quite location and all the stuff.
Abdullah Adelyar - USAID - Kabul Afghanistan
Course - Access VBA
perfect level of knowledge transfair