Find training courses on Training and Courses.com
> UK

Wise Ltd training courses

2 training courses found

Data Warehousing Fundamentals
Audience aimed at: Corporate training only

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 and OLAP design How to plan and implement a data warehouse with high availability, simplified manageability and optimal performance What are common statistics, analytic and OLAP SQL queries 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 understand the implication of such terms as cubes, dimensions, attributes, joins, hierarchies, measures, etc.

  • Study level: Beginner
  • Duration of training: 3 days
  • Study mode: Full time
Data Warehousing Terms, Concepts & Architecture
Audience aimed at: Corporate training only

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 queries? Upon completion of this course, the participant should be conversant with terms and concepts as these relate to a data warehouse using both star and snowflake schemas. And the delegate should understand the implication of such terms as cubes, dimensions, attributes, joins, hierarchies, measures, etc.

  • Study level: Beginner
  • Duration of training: 1 day
  • Study mode: Full time