Ad-hoc/Bespoke Presentations

Owing to economic conditions, SLA obligations and the like, organisations are increasingly more pragmatic in their choice of IT training solutions. For example, IT management recognises, and we accept, that training vendors' 2-5 day course offerings include some topics, 20-35%, not specific to their near or short-term requirements.

Thus, some clients have opted for a more ad-hoc and bespoke course content. The table below summarises some increasingly requested 1-day sessions:

Category Commonly Requested Topics
Generic:
Multi-platform Similarities and differences:
  • Oracle vs.
  • SQL Server vs.
  • DB2 LUW vs.
  • DB2 z/OS
Business Intelligence/Data Warehousing:
Dimensional Modelling (Kimball's methodology)
  • Star schema vs. snowflake
  • Conformed dimensions
  • Slowly changing dimensions
  • Late arriving dimensions
  • ETL basics
ETL Fundamentals
  • Source-to-destination
MDX
  • Concepts & facilities
SQL Server 2005/2008:
Integration Services (SSIS)
  • Checkpoint restart
  • Fuzzy Lookup/Fuzzy Grouping
  • Script Task vs. Script Component
  • Package deployment
Analysis Services (SSAS)
  • UDM
  • Attribute relationships
  • Dimension design
  • Cube design
  • Cube processing
  • Aggregation design
Reporting Services (SSRS)
  • Query parameters vs. filters
  • Cached instance vs. snapshot
  • Report model design
  • Drilldown reports
  • Drill-through reports
Oracle 10g/11g:
Oracle Data Warehousing
  • External tables
  • Materialized views
  • Bitmap indexes
  • MERGE statement
  • Multi-INSERT statement
Oracle OLAP option
  • Concepts & facilities
Oracle Warehouse Builder (OWB)
  • Concepts & facilities
Oracle 11g
  • What's new (OLTP and data warehousing)
DB2 LUW V9:
DB2 LUW V9
  • Monitoring and tuning
DB2 LUW V9.5
  • What's new (OLTP and data warehousing)
Advanced SQL & Explain
  • Joins vs. subqueries, etc.
Visual Explain
  • Access Plan Graphs, etc.
DB2 z/OS:
Advanced SQL & Explain
  • Joins vs. subqueries, etc.
DB2 z/OS V9
  • Monitoring and tuning
DB2 z/OS V9
  • What's new (OLTP and data warehousing)
IBM DB2 Data Warehouse Edition:
DB2 Data Warehouse Edition
  • Concepts & facilities
  • InfoSphere Cube

This approach has proven to be a viable jumpstart in meeting some IT training needs. In short, you 'name' your topics, we 'frame' and deliver them at your site or ours. Please contact us to find our more about this practical and cost-effective option.

Training Topics

GENERAL

print  |  top of page