Detailed information
| Duration: | 5 Days |
|---|---|
| Price: | £1,750 (GBP plus VAT) |
| Type: | Training |
| Method: | In a classroom |
| Prepares for: | Upon completion of this course, the participant should be able to monitor and tune large data warehouses in a BI (Business Intelligence) or DS (Decision Support) environment. |
| Geared towards: | DW architects and DBAs. |
| Requirements: | Completion of our course Data Warehouse Terms, Concepts & Architecture or equivalent knowledge. |
Do you need further information?
Contact the person in charge , free and at no obligation, for information on how to enroll, enrollment limit/availability and more.
Course program
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 coach the participants from logical through physical design of a data warehouse involving at least five dimensions and one-or-more star schemas.
Thus hands-on exercises include:
Design and creation of dimensions
Design and creation of star schemas
Design and creation of hierarchies
Design and creation of indexes
Design and creation of integrity constraints
Extract, Transform and Load (ETL) options
Parallelism
Design and create materialized views (summary tables)
Throughout the foregoing, best practices and performance issues are discussed.
Thus hands-on exercises include:
Design and creation of dimensions
Design and creation of star schemas
Design and creation of hierarchies
Design and creation of indexes
Design and creation of integrity constraints
Extract, Transform and Load (ETL) options
Parallelism
Design and create materialized views (summary tables)
Throughout the foregoing, best practices and performance issues are discussed.
Do you need clarification regarding the course program?
Contact the person in charge , free and at no obligation, for information on how to enroll, enrollment limit/availability and more.
Course location
- Regus Centre, First Point, Buckingham Gate, London Gatwick Airport, Gatwick RH6 0NT - RH6 0NTGreater London (England)
Wise Ltd.
IT training company specialising in database and data warehousing training on SQL Server, Oracle and DB2 platforms. Public courses take place at London Gatwick. Onsite training available throughout the UK and Europe.
