Wise courses

...analytic and OLAP SQL queries? Objectives: Upon completion of this course, the participant should be conversant with terms and concepts as these relate...

...Platform: Multi-platform: DB2 for z/OS, DB2 for Linux/UNIX/Windows, Oracle, SQL Server, etc. Audience: Data warehouse and BI developers, data warehouse architects and...

...analytic and OLAP SQL queries? Objectives: Upon completion of this course, the participant should be able to design a data warehouse using both star and snowflake schemas...

...Upon completion of this presentation, the participant should be able to exploit SQL Server 2008 new and enhanced BI features per the 'Core Topics' in the detailed outline...

...and implement these options to meet a variety of extract, transform and load solutions in BI and non-BI environments. Suitable for: Business intelligence...

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

...Performance and tuning Performance measurement Partitioned tables (in data warehouses) Partition maintenance ETL planning and development Objectives...

...as these relate to alternatives for partitioning keys, filegroups, schemas, functions, etc. Format: Lecture and hands-on...

...Prerequisites: DTS 2000, SQL Server 2000 or equivalent knowledge. Summary: This presentation gives a high-level summary of SQL Server 2005's...

...Summarise SSAS good practices and performance techniques Etc. Format: Hands-on (about...

...such as tables, matrices and charts Add expressions to reports Add parameters to reports Manage and secure reports Etc. This scenario-based presentation...

...Data mart design and load Business Intelligence Development Studio (BIDS) SQL Server Management Studio Building dimension tables Building fact tables Developing...

...Prerequisites: Completion of our course Data Warehouse Terms, Concepts & Architecture or equivalent knowledge. Summary: After presenting entity relationship...

...Summary: After reviewing Dimensional Modelling fundamentals, this course focuses on tuning the Oracle DB engine and DW application interfaces with especial emphasis...

...Upon completion of this course, the participant should be able to translate logical DW design specifications into an Oracle physical design model...

...it relates to all DBMSs (DB2, MS SQL Server, Sybase, etc.) we elaborate on Oracle's ETL offering: Change Data Capture SQL*Loader Data Pump External tables...

...Summary: This dimensional modelling techniques course is designed to answer questions, such as the following: What is data warehousing? What is a data mart?...

...and Tera-byte table considerations Partitioning and parallelism I/O design High performance DB/DBM configuration parameters How to exploit the DB2 optimizer...

...databases in general. Additionally, the course participant should be qualified to select and tune queries to exploit the MDC and MQT implementations. Audience...

...Summary: Designed mainly for the IT developer, this presentation discusses, among others, the following SQL Server 2005 new features and enhancements...