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

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

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

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

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

...Suitable for: SQL Server 2005/2008 DBAs (and SSIS developers). SQL Server 2005/2008 DBAs (and SSIS developers). Level:AdvancedAudience:SQL Server 2005...

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

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

...business intelligence/data warehouse specialists, DBAs and SQL Server 2005 administrators. Prerequisites: Completion of our course Data Warehousing Fundamentals...

...reports Manage and secure reports Etc. Suitable for: Data architects, business intelligence/data warehouse specialists, developers and analysts. Data architects...

...dimensions Hierarchies ETL via SQL Server 2005 Integration Services (SSIS) Security SQL Server 2005 Analysis Services (SSAS) Performance and good practices...

...and dimensional modelling (DM) as competing alternatives, the presentation will focus on the use of DM techniques when developing and implementing a very large data warehouse...

...Star schema design Indexes Materialized views Partitioning DB parameters Objectives: Upon completion of this course, the participant should understand...

...and in turn, create the necessary scripts (e.g., DDL) to install a large scale partitioned DW, using, amongst other things, bitmap indexes. Suitable...

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

...or anyone responsible for a data warehouse or related discipline. IT developers, database administrators or anyone responsible for a data warehouse or related discipline...

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

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

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