Wise courses

...Upon completion of this course, the participant should be conversant with terms and concepts as these relate to a data warehouse using both star and snowflake schemas...

...Suitable for: Data warehouse and BI developers, data warehouse architects and DBAs. Data warehouse and BI developers, data warehouse architects and...

...IT developers, database administrators or anyone responsible for a data warehouse or related discipline. Would-be data warehouse architects...

...2008 new and enhanced BI features per the 'Core Topics' in the detailed outline. Format: Lecture and hands-on...

...Business Intelligence and data warehousing considerations Event handling SSIS problem determination And the like. Objectives: Upon completion of this presentation...

...this course is accordingly dedicated. After discussing advanced features of the SSIS control and data flow engines, delegates will be taught how to design...

...spans both SSIS developer and DBA tasks), this scenario-oriented presentation concentrates on the more esoteric features of SSIS: Deployment internals...

...partitioning Design sliding window scenarios Optimise query performance. Suitable for: Database architects, developers and administrators of OLTP and/or data warehouse solutions...

...DBAs and SQL Server 2005 administrators. Level: Executive Audience: Data architects, business intelligence/data warehouse specialists, DBAs and SQL Server 2005 administrators...

...performance techniques Etc. Suitable for: Data architects, business intelligence/data warehouse specialists, DBAs and SQL Server administrators. Data architects...

...Upon completion of this presentation, the delegate should be competent to: Identify and manage report data Create reports using tools such as Report Wizard...

...Upon completion of this course, the delegate should understand how to deal with BI/DW design issues as they relate to SQL Server 2005/2008. Suitable...

...Using real-world business scenarios, SALES, for example, the instructor will coach the participants from logical through physical design of a data warehouse...

...Oracle DB and application tuning options and how they may be used to optimise data warehousing performance...

...DW partitioning Index options (e.g., bitmaps) Integrity and constraints Materialized views (summary tables) DW objects (dimensions, hierarchies...

...Transportable tables SQL MERGE Table Functions Etc. Objectives: Upon completion of this presentation, the participant should understand the ETL phase...

...Upon completion of this course, the participant should be able to design a data warehouse using both star and snowflake schemas. And the delegate should...

...how to optimise data warehouse design in both non-partitioned and partitioned environments. Topics central to this presentation include:...

...Warehouse Fundamentals or equivalent knowledge. Summary: This course focuses on the use of IBM's Multidimensional Clustering (MDC) and the summary tables (e...

...Upon completion of this presentation, the delegate should be conversant with SQL Server 2005's new features and enhancements per the 'Core Topics' in the detailed outline...