Wise courses

...months of IT developer and/or technical experience. Summary: This DW terminologies and concepts course addresses the following topics: What is data warehousing?...

...Upon completion of this presentation, the participant should be able to code efficient SQL queries to meet both single and multidimensional business requirements...

...understand the implication of such terms as cubes, dimensions, attributes, joins, hierarchies, measures, etc. Suitable for: Would-be data warehouse architects...

...Suitable for: Data architects, data integrators, ETL technicians, OLAP and reporting analysts. Data architects, data integrators, ETL technicians...

...the participant should be able to use the SQL Server 2005 toolset to deploy a broad range of SSIS requirements per the 'Core Topics' in the detailed outline...

...ETL solutions. Suitable for: SQL Server 2005/2008 developers in particular and DBAs in general. SQL Server 2005/2008 developers in particular and DBAs in general...

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

...the delegate should be competent to: Design and implement partitioned tables and indexes Maintain partitioned tables and indexes Understand good practices...

...Upon completion of this presentation, delegate should be conversant with the 'Core Topics' in the detailed outline. Suitable for: Data architects...

...business intelligence/data warehouse specialists, DBAs and SQL Server administrators. Level: Beginner-to-intermediate Audience: Data architects...

...details how to use SQL Server 2005 Reporting Services (SSRS) to design a robust reporting solution to support a BI solution...

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

...Objectives: Upon completion of this course, the participant should be able to monitor and tune large data warehouses in a BI (Business Intelligence)...

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

...etc.) The ETL process Performance and good practices...

...DW administrators, DBAs, data architects, DW PL/SQL developers. DW administrators, DBAs, data architects, DW PL/SQL developers. Currency: 10g & 11g Audience...

...simplified manageability and optimal performance What are common statistics, analytic and OLAP SQL queries? Objectives: Upon completion of this course...

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

...IT developers, database administrators or anyone responsible for a data warehouse or related discipline. Prerequisites: Completion of our course DB2...

...Suitable for: Developers and DBAs. Developers and DBAs. Audience: Developers and DBAs. Prerequisites: At least six (6) months SQL Server application developer experience...