You are in Home > Information Technology > Databases > UDB Universal Database >

This hands-on course focuses on tuning advanced SQL via DB2 Explain facilities in terms of the following DB2 UDB features: - Isolation levels - Locking and concurrency - Join optimisation - Sequen... more information | send enquiry

Tel 0800 136010 www.aqt.co.uk for training courses info more information | send enquiry

This course focuses on the scope and limits of basic SQL operations such as: - DB2 SQL interface options (e.g., Command Line Processor, Command Center) - Overview of Data Definition Language (DDL): ... more information | send enquiry

Target Audience This training course is aimed at the DB2 Applications Programmer, already familiar with DB2 running in an OS/390 environment, who requires an in-depth knowledge of the key tasks invol... more information | send enquiry

The course will provide delegates with the skills to code complex applications using embedded SQL commands to access data stored in DB2 databases. Hands-on workshops are used to provide delegates with... more information | send enquiry

This course focuses on the scope and limits of SQL operations such as: - Overview of Data Definition Language (DDL) - Data Manipulation Language (DML) - Predicates - NULL considerations - INNER J... more information | send enquiry

DURATION: 3 days AUDIENCE: System Administrators and Database Administrators PREREQUISITES: Successful completion of our course 'Concepts and Facilities' or equivalent knowledge or experience. SUM... more information | send enquiry

AUDIENCE: Aspiring DB2 UDB for Windows/UNIX System Administrators, Data Administrators and Application Developers PREREQUISITES: Minimum of six (6) months experience in any IT environment. SUMMARY:... more information | send enquiry

SUMMARY: This course focuses on the scope and limits of basic SQL operations such as: - DB2 SQL interface options (e.g., iSeries Navigator) - Overview of Data Definition Language (DDL): Create/Alter... more information | send enquiry

Target Audience: This course provides the applications programmer with an in-depth knowledge of the DB2 development process. It is aimed at programmers who need to code or support DB2 application pro... more information | send enquiry

Target Audience This course provides the delegate with an overview of the DB2 development process. It is aimed at those who need to understand the concepts and capabilities of DB2 at a high level. ... more information | send enquiry

SUMMARY: This presentation summarises the DB2 UDB for OS/400 architecture, objects, SQL programming facilities, SQL data definition facilities and the like. This course is a prerequisite to the more e... more information | send enquiry

Target Audience This course provides the applications programmer with an in-depth knowledge of the construction and installation of DB2 Stored Procedures, written in a choice of languages. If necessa... more information | send enquiry

SUMMARY: This course places particular emphasis on the monitoring, performance and tuning of the DB2 for OS/390 and z/OS subsystem. This includes: - The DB2 workload assessment - Response times and ... more information | send enquiry

SUMMARY: This workshop-oriented presentation discusses how to combine the IT specialist's knowledge of SQL, indexes and related statistics in the use of Visual Explain to optimise resource-intensive q... more information | send enquiry

PREREQUISITES: Completion of our course 'DB2 SQL Essentials' or equivalent knowledge. SUMMARY: Among the topics covered in this course are: - Creating triggers - INSERT, UPDATE and DELETE triggers... more information | send enquiry

PREREQUISITES: Completion of our course 'DB2 SQL Essentials' or equivalent knowledge. SUMMARY: Among the topics covered in this course are: - Visual Explain concepts & operators - Creating Explain... more information | send enquiry

AUDIENCE: Application Developers, Programmers, System Programmers, Database Administrators and System Administrators. PREREQUISITES: A working knowledge of SQL predicate types, I/O types and SQL state... more information | send enquiry

Target Audience This training course is aimed at the Database Administrator, already familiar with DB2 running in an OS/390 environment, who requires an in-depth knowledge of the key tasks normally p... more information | send enquiry

SUMMARY: This DB2 UDB V8.1 'update' course discusses virtually all changes and enhancements as these apply to V8.1.0 through V8.1.x, FixPaks 1 – 8. The presentation is organised under headings akin to... more information | send enquiry

Tel 0800 136010 www.aqt.co.uk for training courses info more information | send enquiry