Plan Szkolenia
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)
Wymagania
Good understanding of SQL, database structure and fair understanding of procedural language (e.g. PL/SQL, SQL PL, etc...)
Opinie uczestników (5)
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
Szkolenie - Access Intermediate
Organizacja i praktyczne podejście do tematy
Adam Cedrowicz - Unilever Poland Services sp. z o.o
Szkolenie - Access - podstawy
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.
Szkolenie - SQL in Microsoft Access
Training Room and quite location and all the stuff.
Abdullah Adelyar - USAID - Kabul Afghanistan
Szkolenie - Access VBA
perfect level of knowledge transfair