Duration
1 day
Course Outline
A data warehouse is a database that collects and stores a large amount of data from a diverse range of sources to allow analysis and provide insights.
This Data Warehouse training course will introduce delegates to the fundamental concepts of data warehousing, including architecture, modelling, delivery and system processes. Delegates will learn about the different terminology related to data warehousing, metadata concepts, schemas, and security.
Who should attend?
Anybody wishing to gain good knowledge of data warehousing. This course is best suited for:
- Recent Graduates
- IT Professionals who wish to learn about data storage and data warehousing modelling
- Finance professionals
Prerequisites
There are no formal prerequisites for this course. However, an understanding of basic database concepts would be beneficial.
Outline
Introduction to Data Warehouse
- What is Data Warehousing?
- Features of Data Warehouse
- Types of Data Warehouse
- Components of Data Warehouse
- Use of Data Warehouse
- Advantages and Disadvantages
- Data Warehouse Tools
- Data Warehouse Applications
- Integrating Heterogeneous Databases
Terminologies
- Metadata
- Metadata Repository
- Data Cube
- Data Mart
- Virtual Warehouse
Dimensions and Facts
Modelling
- ER Diagram
Delivery Process
- Delivery Method
- IT Strategy
- Education and Prototyping
- Technical Blueprint
System Processes
- Process Flow in Data Warehouse
- Extract and Load Process
- Clean and Transform Process
- Backup and Archive the Data
Data Warehouse Architecture
- Three-Tier Data Warehouse Architecture
- Data Warehouse Models
- Load, Warehouse, and Query Manager
Data Warehouse OLAP
- Types of OLAP Servers
- OLAP Operations
- OLAP vs OLTP
Relational and Multidimensional OLAP
Data Warehouse Schemas
- Star Schema
- Snowflake Schema
- Fact Constellation Schema
- Schema Definition
Horizontal and Vertical Partitioning
Metadata Concepts
- Metadata Categories
- Role of Metadata
- Metadata Repository
Introduction to Data Marting
System and Process Managers
Security and Backup
- Security Requirements
- User Access
- Impact of Security on Design
- Hardware and Software Backup
Tuning and Testing
Programme scope, delivery arrangements and suitability are confirmed during enquiry.