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 (4)
Los ejemplos claros que presentó el instructor
José Ernesto Cruz Pineda - Datavision digital
Course - SAP ASE for Database Administrators
The situation was atypical because an intensive training for developers was to be conducted with non-developers. Lukasz took up this challenge with empathy and a lot of humour. Through his intelligent and flexible manner, he was able to ensure that a concrete learning gain was achieved for everyone. I enjoyed this very much and would gladly take a seminar with Lukasz again.
Christoph - Honda Bank GmbH
Course - MERN Fullstack Development
Simplifying operational tasks.
Kesh - Vodacom
Course - MongoDB for Administrators
Tamil was excellent at explaining even the difficult topics in a way that I understood them straight away. The presentation and delivery were both clear and methodical, and the teacher passionate about the subject.