JSON Recursive queries OOP principles Multithreaded applications development Aggregate functions SQL Server data retrieval SQL Server data selection Transaction isolation levels Query and stored procedures optimization Identifying problematic procedures System objects functions XML Data storage in databases Understanding of locking types and transaction isolation levels System objects tables System objects views Query optimization methods Standard libraries High-load large databases Delphi syntax Types of blocks and physical operations Identifying problem areas in execution plans Correlating blocks in plans with executed query code Intricacies of multithreaded programming Call stack Understanding sequence of actions in the call stack Stored procedures Relational DBMS principles VCL Capabilities of SQL Server Profiler MS SQL Server syntax T-SQL User Defined Functions (UDF) Delphi XE 10 or above SQL Server Profiler Indexes Nuances of different types of indexes Execution plans Debugging programs MS SQL Server 2016 and above Locking types Error handling Understanding others' code Classes for multithreading Analytical functions System objects procedures Overall structure of queries and stored procedures Delphi 2009 or later Delphi development environment Databases via ADO Internals of Delphi

VCL technology SQL queries for MS SQL Server ADO technology client applications in Delphi optimizing business processes implementing business processes

group functions in Oracle Borland Delphi PL/SQL for Oracle optimizing queries OOP in Oracle Raize VCL interfaces collections in Oracle big data FastReport interfaces packages in Oracle analytical functions in Oracle SQL for Oracle version control system SVN DevExpress VCL interfaces standard components interfaces objects in Oracle UML diagrams ER diagrams optimizing procedural code stored logic elements in Oracle ODAC components interfaces Embarcadero Delphi development environment

UML diagrams optimizing queries optimizing procedural code analytical functions in Oracle development and maintenance of interfaces using DevExpress VCL components version control system SVN big data group functions in Oracle Oracle with PL/SQL stored logic in Oracle collections in Oracle objects in Oracle Oracle with SQL ER diagrams development and maintenance of interfaces using standard components development and maintenance of interfaces using ODAC