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...

...Platform: Multi-platform: DB2 for z/OS, DB2 UDB for Linux/UNIX/Windows, Oracle, SQL Server, Sybase, etc. Audience: Would-be data warehouse architects...

...Conversancy with data warehousing in general and SQL Server 2000 and/or SQL Server 2005 BI solutions (e.g., DTS, SSIS) in particular. Summary...

...2005 Integration Services (SSIS) topics: Creating and managing SSIS packages Connecting to, querying and transforming disparate data sources Scripting...

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

...Upon completion of this course, the delegate should be competent to develop, deploy, tune and source a diverse mix of complex SSIS package solutions...

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

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

...Objectives: Upon completion of this presentation, the delegate should be competent to: Build and deploy Analysis Services projects Use Data Sources/Data...

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

...Designed to emphasise SQL Server 2005's features specific to business intelligence (BI) and data warehousing (DW), this scenario and hands-on presentation details the following...

...involving at least five dimensions and one-or-more star schemas. Thus hands-on exercises include: Design and creation of dimensions Design and creation...

...Upon completion of this course, the participant should understand Oracle DB and application tuning options and how they may be used to optimise data warehousing performance...

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

...Upon completion of this presentation, the participant should understand the ETL phase of the data warehouse development life cycle. Suitable...

...understand the implication of such terms as cubes, dimensions, attributes, joins, hierarchies, measures, etc. Suitable for: IT developers, database administrators...

...database administrators and system administrators. Platform: DB2 for LUW Audience: DB2 BI and data warehouse developers, database administrators and system administrators...

...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...