Course not currently available
Database Logic Migration Training Course
Course
Online
Description
-
Type
Course
-
Methodology
Online
When migrating databases there are common ways of dealing with logic put either in SQL queries specific to the database or database procedural language (e.g. PL/SQL). This course covers techniques and strategies of making migration smooth. Also it deals with possible performance and scalability problems.
This course is usually deliver with following databases: DB2, Oracle, MySQL, MariaDB, SQL Server, etc... but can be tailored to a specific migration project.
About this course
Good understanding of SQL, database structure and fair understanding of procedural language (e.g. PL/SQL, SQL PL, etc...)
Reviews
Subjects
- Testing
- Server
- Database
- SQL
- PL/SQL
- Database training
- DB2
- Logic
- Project
- Programming
Course programme
- 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
- 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
- Using traditional programming
- Using Rule Engines or other Logic Engines
- Unit Testing
- Performance and scalability issues
- ORM (Object-relations mapping) frameworks
- Using web-service output instead of a query or stored procedure
- Performance testing
- Profiling (finding bottlenecks and performing optimisation)
Additional information
Database Logic Migration Training Course