This training course is designed for those who have an understanding of relational databases and wish to understand the techniques behind building a database for reporting purposes.

The Reporting Database Design training courses are run by consultants with extensive practical experience to provide you with the foundation required to build your own reporting / analytical databases.

Objectives

Delegates attending this course will be able to:

• Understand the concepts and use of a reporting database / data warehouse
• Utilise the appropriate design techniques
• Plan the project

Topics covered

• In the presentations and labs the delegate will gain experience of:
• Compare and contrast analytical and reporting databases
• ETL (Extract, Transform, Load)
• Recognise dimensions, members and hierarchies amongst database attributes
• Define star and snowflake schemas
• Cope with slowly changing dimensions
• Plan the build and implementation

Who should attend?

• This course is designed for reporting database builders

Pre-requisites

• A high level understanding of relational databases

Booking

• Click here for schedules, prices and offers