Thursday 8 January 2009
 
Training Pages
Member Login Forgotten Password? 
User name
Password
Remember me Login »
<<Back

 

Courses from Wise Ltd
 
CICS TS Concepts & Facilities
  
Wise Ltd - 2 days - Introductory - Public - £650 (includes materials, lunch, refreshments)
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
Data Warehousing Terms , Concepts & Architecture
  
Wise Ltd - 1 day - Introductory - Public - £350 (includes materials, lunch, refreshments)
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
Data Warehousing: Adv. SQL Queries & Performance
  
Wise Ltd - 2 days - Advanced - Public - £650 (includes materials, lunch, refreshments)
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
Data Warehousing: Data Warehouse Fundamentals
  
Wise Ltd - 3 days - Introductory - Public - £975 (includes materials, lunch, refreshments)
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
Data Warehousing: MDCs & MQTs Demystified
Wise Ltd - 3-5 days - Advanced - Public & In-House - £900
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
Data Warehousing: Oracle Data Warehouse Design
  
Wise Ltd - 5 days - Intermediate - Public - £1475 (includes materials, lunch, refreshments)
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
DB2 for z/OS & OS/390: Advanced SQL via DB2 EXPLAIN
Wise Ltd - 3-5 days - Advanced - In-House
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
DB2 for z/OS & OS/390: Database Administration & Performance
Wise Ltd - 3-5 days - All difficulty levels - In-House
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
DB2 for z/OS & OS/390: DB2 Application Programming Workshop
Wise Ltd - 3-5 days - All difficulty levels - In-House
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
DB2 for z/OS & OS/390: DB2 SQL Essentials
Wise Ltd - 3-5 days - Introductory - In-House
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
DB2 for z/OS & OS/390: Exploiting the Optimizer
Wise Ltd - 1 day - Advanced - Public & In-House - £300
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
DB2 for z/OS & OS/390: Performance & Tuning for Production DBAs
Wise Ltd - 3-5 days - All difficulty levels - In-House
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
DB2 for z/OS & OS/390: Subsystem Performance & Tuning
Wise Ltd - 3-5 days - Advanced - Public & In-House - £1100
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
DB2 UDB for iSeries (OS/400 & AS/400): Concepts & Facilities
Wise Ltd - 1 day - Introductory - Public & In-House - £300
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
DB2 UDB for iSeries (OS/400 & AS/400): DB2 Advanced SQL Workshop
Wise Ltd - 2 days - Advanced - In-House
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
DB2 UDB for iSeries (OS/400 & AS/400): DB2 SQL Essentials
Wise Ltd - 2 days - All difficulty levels - In-House
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
DB2 UDB for iSeries (OS/400 & AS/400): DB2 Visual Explain Workshop
Wise Ltd - 1 day - All difficulty levels - In-House
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
DB2 UDB for Linux/UNIX/Windows: Database Performance & Tuning
Wise Ltd - 3-5 days - Advanced - Public & In-House - £900
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
DB2 UDB For Linux/UNIX/Windows: DB2 SQL Essentials
Wise Ltd - 2 days - Introductory - Public & In-House - £600
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
DB2 UDB For Linux/UNIX/Windows: DB2 Triggers
Wise Ltd - 1 day - All difficulty levels - Public & In-House - £300
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
DB2 UDB for Linux/UNIX/Windows: DB2 UDB Concepts & Facilities
Wise Ltd - 1 day - Introductory - Public & In-House - £300
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
DB2 UDB for Linux/UNIX/Windows: DB2 UDB Database Administration
Wise Ltd - 3-5 days - Intermediate - Public & In-House - £1100
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
DB2 UDB for Linux/UNIX/Windows: DB2 UDB Fundamentals
Wise Ltd - 3-5 days - Introductory - Public & In-House - £900
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
DB2 UDB for Linux/UNIX/Windows: DB2 UDB V8.1 & V8.2 'Stinger' Update for Developers
Wise Ltd - 2 days - All difficulty levels - Public & In-House - £600
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
DB2 UDB for Linux/UNIX/Windows: DB2 UDB V8.1 Update/Transition, including Performance
Wise Ltd - 2 days - All difficulty levels - Public & In-House - £600
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
DB2 UDB for Linux/UNIX/Windows: DB2 UDB V8.2 'Stinger' New Features
Wise Ltd - 2 days - All difficulty levels - Public & In-House - £600
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
DB2 UDB For Linux/UNIX/Windows: DB2 Visual Explain Workshop
Wise Ltd - 1 day - All difficulty levels - Public & In-House - £300
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
DB2 UDB for Linux/UNIX/Windows: System & Database Debugging
Wise Ltd - 3-5 days - Advanced - Public & In-House - £1100
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
DB2 UDB for Linux/UNIX/Windows: System Performance & Tuning
Wise Ltd - 2 days - Advanced - Public & In-House - £600
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
DB2 UDB For LUW: Advanced SQL via DB2 EXPLAIN
  
Wise Ltd - 3 days - Advanced - Public - £975 (includes materials, lunch, refreshments)
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
DB2 UDB for LUW: SQL Stored Procedures (SQL PL)
  
Wise Ltd - 3 days - All difficulty levels - Public - £975 (includes materials, lunch, refreshments)
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
DB2 V8 for z/OS: V8 Update (DBA)
Wise Ltd - 2 days - All difficulty levels - Public & In-House - £600
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
DB2 V8 for z/OS: V8 Update (Developers)
Wise Ltd - 2 days - All difficulty levels - Public & In-House - £600
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
Oracle 10g New Features & Performance
Wise Ltd - 2 days - All difficulty levels - Public & In-House - £600
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
Oracle Advanced SQL via EXPLAIN PLAN
  
Wise Ltd - 4 days - All difficulty levels - Public - £1200 (includes materials, lunch, refreshments)
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
Oracle Indexes Demystified
  
Wise Ltd - 1 day - All difficulty levels - Public - £350 (includes materials, lunch, refreshments)
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
Back to Top
© Training Pages, 2002-2007. Site use subject to our Terms and Conditions and Privacy Policy.
Training Pages is a division of Ecube Limited. Registered office 1.23 Plaza 535, Kings Road, London SW10 0SZ. Company Number: 3839310. VAT Registration No. 75908879.