After establishing a definition of online system in general, this course focuses on CICS TS concepts & Facilities: = As a transaction manager = Inter-product communication = Inter-product interfaces =... more information   send enquiry

This DW terminologies and concepts course addresses the following topics: - What is data warehousing? - What is a data mart? - What are the data modelling options? - What are the terms and concept... more information   send enquiry

SUMMARY: After briefly reviewing DW and BI terms and concepts, the lecturer will develop an understanding of how to use the statistics, analytic and OLAP features in a BI environment. The main feature... more information   send enquiry

This data modelling techniques course is designed to answer questions, such as the following: - What is data warehousing? - What is a data mart? - What are the data modelling options? - What are t... more information   send enquiry

SUMMARY: This course focuses on the use of IBM's Multidimensional Clustering (MDC) and the summary tables (e.g., Materialized Query Tables (MQT) to design and implement data warehouse and other massiv... more information   send enquiry

After presenting entity relationship (ER) and dimensional modelling (DM) as competing alternatives, the presentation will focus on the use of DM techniques when developing and implementing a very larg... more information   send enquiry

After reviewing the usage and the scope and limits of SQL operations such as: - INNER JOINs - OUTER JOINs - UNIONs - CASE expressions - Subqueries - Subselects - Table expressions - Row expres... more information   send enquiry

SUMMARY: Designed mainly for the DBA, this course focuses on the best practices, techniques, tips and guidelines for optimal database design and performance. Topics given rigorous treatment include: ... more information   send enquiry

SUMMARY: This 'hands-on' DB2 UDB programming workshop for OS/390 & z/OS details both: - Interactive SQL and - Embedded SQL Therefore, after discussing relational terms and concepts, the delegates a... 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

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

SUMMARY: This course is designed mainly for DB2 Production DBAs in particular and DB2 DBAs in general. It imparts the necessary knowledge to monitor and tune areas that have a medium-to-high impact on... 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 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

SUMMARY: This presentation focuses on advanced SQL, data access primitives and index options with a view to reducing SQL query elapsed times. OBJECTIVES: Upon completion of this presentation, the de... 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

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

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

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

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

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 workshop-based course focuses on how to eploit the following DB2 facilities in the management of DB2 data: - IMPORT - EXPORT - LOAD - REORG - RUNSTATS - db2look - Database backup... more information   send enquiry

SUMMARY: After discussing general relational database terms and concepts, this hands-on course develops, for the delegates, a working knowledge of DB2 for LUW in terms of: - Planning - Implementatio... more information   send enquiry

PREREQUISITES: Familiarity with DB2 UDB V7.2 from a developer's perspective SUMMARY: This course discusses application SQL and related enhancements, as these relate to DB2 UDB V8.1 (FixPaks 1 – 6) an... 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

PREREQUISITES: An awareness of DB2 8.1.x architecture and facilities; this knowledge may have been acquired through experience, relevant 'What's New' publication or attending our 'DB2 UDB V8.1 Update/... 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

This course features the hands-on approach to resolving problems common to DB2 UDB for UNIX/Windows. In particular the course focuses on how to meet the threefold goals of problem determination: - De... more information   send enquiry

PREREQUISITES: Completion of our course 'Concepts & Facilities' or equivalent knowledge. SUMMARY: This course is designed to assist DB2 UDB system administrators in monitoring and tuning the DB2 for ... more information   send enquiry

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

This hands-on course focuses on using the IBM DB2 UDB Development Center and Command Line Processor (CLP) to develop SQL procedures (SQL PL). For more information visit www.wiselimited.com more information   send enquiry

The chief aim of this course is to establish a working knowledge of DB2 V8's new features and enhancements, as they fall under the following headings: - How DB2 exploits z/OS - Scalability - Availa... more information   send enquiry

This presentation aims at developing a clear understanding of DB2 V8's SQL and programming enhancements in terms of: - z/OS concepts - DB2 V8 exploitation of z/OS - Interactive and static SQL - Ap... more information   send enquiry

This presentation elaborates on Oracle's 10g new features and enhancements as these should be of interest to Oracle technicians. Each 10g new feature and enhancement is compared, where useful, with it... more information   send enquiry

This course focuses on best practices and performance issues as these relate to Oracle SQL and PL/SQL. To this end, the Oracle EXPLAIN PLAN and related monitoring tools are central. As the EXPLAIN PLA... more information   send enquiry

This course discusses all of the Oracle index options: - B*tree - Bitmap - Hash - Partitioned - Index clustered table - Etc. in the following contexts: - Structure and organisation - How to c... more information   send enquiry