IT, ICT and Computing courses in Greater London

The data warehouse continues to be one of the most organisationally complex and technically interesting projects in Information Technology. We believe the market today requires professionals to be multi talented and strategically positioned for the growth in data warehousing and dimensional...it, ict and computing coursesin greater london

This DW terminologies and concepts course addresses the following topics: What is data warehousing? 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, analytic and OLAP SQL...it, ict and computing coursesin greater london

This dimensional modelling techniques course is designed to answer questions, such as the following: What is data warehousing? What is a data mart? What are the data modelling options? What is Extract, Transform and Load (ETL)? What are the terms and concepts specific to data warehousing...it, ict and computing coursesin greater london

After presenting entity relationship (ER) 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. Using real-world business scenarios, SALES, for example, the instructor will...it, ict and computing coursesin greater london

After reviewing Business Intelligence (BI) terms and concepts, including dimensional modelling, data warehousing (DW), data marts, OLTP vs. OLAP, this hands-on course focuses on the more useful and challenging features of SSIS as they relate to BI/DW solutions in general and...it, ict and computing coursesin greater london

As SSIS is mainly an Extract, Transform and Load (ETL) tool and since ETL has been accepted as being between 70-80% of the data warehouse maintenance challenge, this course is accordingly dedicated. After discussing advanced features of the SSIS control and...it, ict and computing coursesin greater london

Designed mainly for SQL Server DBAs (and SSIS developers whose job description spans both SSIS developer and DBA tasks), this scenario-oriented presentation concentrates on the more esoteric features of SSIS: Deployment internals Runtime engine Data Flow engine Execution trees Parallelism Source and destination adapters Advanced transformations (synchronous vs....it, ict and computing coursesin greater london

This scenario-based presentation details how to use the Business Intelligence Development Studio (BIDS) to develop and deploy Analysis Services projects and to use the SQL Server Management Studio to manage the databases derived from these projects. it, ict and computing coursesin greater london

This course emphasises improving the quality of the end-user experience by equipping the technical support team (developers, DBAs, etc.) with the requisite SSAS skills to design, implement, monitor and tune: Dimension attributes Analysis Services query (MDX) performance Processing performance Aggregations performance Indexes Partitioning Etc. it, ict and computing coursesin greater london

This course is designed for OLAP (cube) developers and administrators and SQL Server Reporting Services (SSRS) developers. Emphasis is placed on using MDX queries and scripts to: Return data to client applications from OLAP cubes Format query results Perform cube design tasks, such as...it, ict and computing coursesin greater london

This presentation begins by introducing the tools, techniques and concepts required to exploit SQL Server’s data mining facilities. Then it progresses to include some of the more detailed topics, such as: Data mining projects Use of BIDS and SSMS in the project development...it, ict and computing coursesin greater london

This scenario-based presentation details how to use SQL Server 2008 Reporting Services (SSRS) to design a robust reporting solution to support a BI solution. it, ict and computing coursesin greater london

This scenario-based presentation details how to use SQL Server 2005 Reporting Services (SSRS) to design a robust reporting solution to support a BI solution. it, ict and computing coursesin greater london

Please note this is a 3.5 day course. Assuming a working knowledge of the above 'Prerequisites', the delegate should be prepared to delve into some of the more esoteric and advanced SSRS features to support a wide variety of reporting scenarios, including: Harnessing...it, ict and computing coursesin greater london

This hands-on course is aimed at business intelligence power users and end users who want to develop reports with report models built by administrators. The course details how to use SQL Server 2008 Reporting Services' Report Builder 1.0 and 2.0 tools...it, ict and computing coursesin greater london

This hands-on course is aimed at business intelligence power users and end users who want to develop reports with report models built by administrators. The course details how to use SQL Server 2005 Reporting Services' Report Builder tool to design and...it, ict and computing coursesin greater london

After reviewing Dimensional Modelling fundamentals, this course focuses on tuning the Oracle DB engine and DW application interfaces with especial emphasis on: Star schema design Indexes Materialized views Partitioning DB parameters it, ict and computing coursesin greater london

This course focuses on the extract, transform and load (ETL) phase of the data warehouse (DW) development life cycle. After discussing ETL as it relates to all DBMSs (DB2, MS SQL Server, Sybase, etc.) we elaborate on Oracle's ETL offering: Change Data...it, ict and computing coursesin greater london

This presentation and hands-on workshop emphasises how to optimise data warehouse design in both non-partitioned and partitioned environments. Topics central to this presentation include: Giga- and Tera-byte table considerations Partitioning and parallelism I/O design High performance DB/DBM configuration parameters How to exploit the DB2 optimizer Materialized Views/Materialized Query...it, ict and computing coursesin greater london

This course focuses on tuning advanced SQL via DB2 Explain facilities in terms of the following DB2 for LUW features: Isolation levels Locking and concurrency Join optimisation Sequence and identity columns Common Table Expressions Recursive queries Grouping sets Materialized Query tables (MQTs) Index design and usage SARGable vs. non-SARGable predicates Elapsed, CPU...it, ict and computing coursesin greater london