Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
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...)
7 Hours
Testimonials (3)
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
Training Room and quite location and all the stuff.
Abdullah Adelyar - USAID - Kabul Afghanistan
Course - Access VBA
perfect level of knowledge transfair