Wise Ltd IT Training & Consulting

Since 1996 Wise Ltd has been providing IT training and consulting services throughout the UK, Europe and beyond. All of our courses are instructor-led by highly experienced and dedicated IT training professionals. We are constantly expanding and updating our course syllabus to incorporate new and emerging technologies. Public courses are held at our training rooms at Gatwick; any of our courses are also available on-site at your premises.

Featured Courses:

• Data Warehousing Fundamentals
  Dates: 7-9 May '08
  Price: £1,025+VAT per delegate
• SQL Server 2005 Analysis Services (SSAS)
  Dates: 14-16 May '08
  Price: £1,295+VAT per delegate

Course fees include a detailed student handout and a light lunch each day.

New Courses for 2008:

SQL Server 2008 is due for release in the third quarter; discover the new features:

• SQL Server 2008 New Data Warehousing/Business Intelligence Features

Our DB2 V9 courses on mainframe and distributed platforms are now available:

• DB2 UDB V9 Transition: DBAs
• DB2 V9 for z/OS: V9 Update (DBA)
• DB2 V9 for z/OS: V8 & V9 Update (Developer)
• DB2 for z/OS Fundamentals
• Visual Explain (VE) for DB2 z/OS & SQL Tuning

Course Outline Quick Links

Select a Course -- CICS CICS Concepts & Facilities CICS Application Programming & Design Workshop CICS Advanced Application Programming & Design Workshop CICS Application Design: Optimising Performance DB2-CICS Interface -- Data Warehousing: Data Warehousing (DW) Terms, Concepts & Architecture Data Warehousing – Advanced SQL Queries & Performance Data Warehousing Fundamentals DB2 Data Warehouse Fundamentals Data Warehouse Performance & Tuning Workshop Data Warehousing – MDCs & MQTs Demystified Oracle Data Warehouse Design Oracle Physical Data Warehouse Design Oracle Data Warehousing: ETL Specifically Advanced Oracle PL/SQL (and SQL) for Data Warehousing ETL -- DB2 UDB for iSeries: DB2 UDB for iSeries Concepts & Facilities DB2 SQL Essentials DB2 Advanced SQL Workshop DB2 Visual Explain Workshop DB2 SQL Stored Procedures & Triggers DB2 Embedded SQL Concepts DB2 Data Management & Utilities -- DB2 UDB for Linux/UNIX/Windows: DB2 UDB V9 Transition: DBAs DB2 UDB V8.2 New Features DB2 UDB V8.1 & V8.2 Update for Developers DB2 UDB Concepts & Facilities DB2 UDB Fundamentals DB2 SQL Essentials DB2 Visual Explain Workshop Advanced SQL via DB2 Explain DB2 Stored Procedures (SQL PL) DB2 Triggers DB2 UDB Database Administration DB2 UDB System & Database Debugging DB2 UDB System Performance & Tuning DB2 UDB Database Performance & Tuning DB2 for z/OS vs. DB2 UDB for LUW Oracle vs. DB2 UDB for LUW: Similarities & Differences Oracle to DB2 UDB for LUW Transition Fundamentals SQL Server to DB2 UDB for LUW Transition Fundamentals -- DB2 for z/OS: DB2 V9 for z/OS: V9 Update (DBA) DB2 V9 for z/OS: V8 & V9 Update (Developer) DB2 V8 for z/OS: V8 Update (DBA) DB2 V8 for z/OS: V8 Update (Developer) DB2 for z/OS Fundamentals DB2 Subsystem Performance & Tuning DB2 Application Programming Workshop DB2 SQL Essentials Advanced SQL via DB2 EXPLAIN Visual Explain (VE) for DB2 z/OS & SQL Tuning Exploiting the DB2 Optimizer DB2 Batch Design for Performance DB2 Locking & Concurrency for Developers DB2 Locking & Concurrency for DBAs DB2 Locking & Concurrency in a Data Sharing Environment DB2 Performance & Tuning for Production DBAs DB2 Database Administration & Performance Tuning the DB2 Pools Large Partitioned Table Space Design & Performance DB2-CICS Interface DB2 for z/OS vs. DB2 UDB for LUW -- ORACLE: Oracle 10g Releases 1 & 2 New Features & Performance Oracle Database Administration Fundamentals PL/SQL Application Programming Workshop Advanced PL/SQL & Performance Workshop Oracle Indexes Demystified Oracle Advanced SQL via EXPLAIN PLAN Oracle vs. DB2 UDB for LUW: Similarities & Differences -- SQL Server: SQL Server 2008 New Data Warehousing/Business Intelligence Features SQL Server: SQL Fundamentals SQL Server 2005 New Features - DBA's Perspective SQL Server 2005 New Features for Developers SQL Server 2005 Partitioned Tables & Indexes SQL Server 2005 - Snapshot Isolation SQL Server 2005 Integration Services (SSIS) Fundamentals Advanced SQL Server 2005 Integration Services (SSIS) Data Warehouse & Business Intelligence New SQL Server 2005 Features SQL Server 2005 Analysis Services (SSAS) SQL Server 2005 Reporting Services (SSRS) Data Warehouse Development for SQL Server 2005 -- Web Development: HTML/XHTML Effective Web Design -- Microsoft Office: Introduction to Access Advanced Access Excel Level 1: Beginner Excel Level 2: Intermediate Excel Level 3: Advanced Outlook Level 1: Beginner Outlook Level 2: Advanced PowerPoint Word Level 1: Beginner Word Level 2: Intermediate Word Level 3: Advanced