Wise courses

...What is a data mart? What are the data modelling options? What are the terms and concepts specific to data warehousing and OLAP design? What are common statistics...

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

...What are the data modelling options? What is Extract, Transform and Load (ETL)? What are the terms and concepts specific to data warehousing and OLAP design?...

...Integration Services (SSIS) SQL Server 2008 Analysis Services (SSAS) SQL Server 2008 Reporting Services (SSRS) To assist understanding, example scenarios...

...Beginner-to-intermediate Audience: Business intelligence and data warehouse developers, ETL architects, DBAs and system administrators. Prerequisites...

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

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

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

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

...Upon completion of this presentation, the delegate should be competent to: Identify and manage report data Create reports using tools such as Report Wizard...

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

...(Decision Support) environment. Suitable for: DW architects and DBAs. DW architects and DBAs. Currency: 10g & 11g Audience: DW architects and...

...10g & 11g Audience: Database administrators, system administrators and developers. Prerequisites: Completion of our course Oracle Data Warehouse Design or equivalent knowledge...

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

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

...the participant should be able to design a data warehouse using both star and snowflake schemas. And the delegate should understand the implication of such terms as cubes...

...optimise and implement large-scale data warehouses to meet a variety of BI (Business Intelligence). Format: Lecture and hands-on...

...Objectives: Upon completion of this course, the participant should be competent to use MDC and MQT disciplines to design data warehouses in particular...

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