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

...Prerequisites: Completion of our course Data Warehouse Terms, Concepts & Architecture or equivalent knowledge. Summary: After briefly reviewing DW and BI terms and concepts...

...understand the implication of such terms as cubes, dimensions, attributes, joins, hierarchies, measures, etc. Suitable for: 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...

...At least six (6) months experience with SQL Server 7.0 or 2000 DTS. Summary: This presentation provides detailed treatment of the following SQL Server...

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

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

...Database architects, developers and administrators of OLTP and/or data warehouse solutions. Audience:Database administrators, system administrators,business...

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

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

...business intelligence/data warehouse specialists, developers and analysts. Upon completion of this presentation, the delegate should be competent...

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

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

...this course elaborates on the essential physical design and phases of an Oracle data warehouse (DW). Particular emphasis is placed on the following...

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

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

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

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