Data warehouse Concepts

Through this course you will understand the basic-to-advanced concepts related to data warehousing. This course explains all the necessary concepts of data warehousing. Also ?process of DW testing, its importance and levels of testing.

Each student in our Live Online classes receives a comprehensive set of materials, including course notes and all the class examples.
  • Batch size up to 1 to 3.
  • Access to the trainer any time for any questions and follow-ups.
  • Online in-person training.
  • Every session is followed by practical assignments.
  • Numerous assignments carefully designed on every topic by our professional trainers.
  • Guidance from experienced and professional people in software industry.
  • Assignments evaluation, feedbacks and encouragements to develop in better way.
  • Focus on hands-on training by students during sessions.

Prerequisites


Need to be familiar with basic RDBMS concepts with skills to write queries. Knowing SQL and T-SQL would be an added advantage.


Syllabus


Duration: Min 20 hours of classroom training.
Min 25 assignments.

Data Warehouse
  • What is a Data Warehouse?
  • Why do we need a data warehouse?
  • Data Warehouse Definition
  • Data Warehouse Features
  • Data Warehouse Features
  • What are the components of a Data warehouse?
  • What is the difference between OLTP and a Data Warehouse?
Data Warehousing Concepts
  • Dimensional Data Model
  • Conceptual Data Model
  • Logical Data Model
  • Physical Data Model
  • Relational Data Model
  • Multi-Dimensional Data Model
Dimensional Data Model
  • dimensional data modeling terms
  • What is the need for Data Modeling
  • Star Schema
  • Snowflake Schema
  • Data warehouse Appliances
Data Warehouse Designing
  • Requirement Gathering
  • Physical Environment Setup
  • Data Modeling
  • ETL
  • OLAP Cube Design
  • Front End Development
  • Report Development
  • Performance Tuning
  • Query Optimization
  • Quality Assurance
Data Extraction, Transformation and Loading
  • ETL Overview
  • Extraction
  • Transformation
  • Loading
  • ETL Tools
  • Data Integration
Business Intelligence Software
  • General Considerations
  • Database/Hardware
  • ETL Tools
  • OLAP Tools
  • Reporting Tools
  • Open Source Business Intelligence Tools
Data Marts
  • What is a Data Mart?
  • Modeling a Data Mart
Data Warehouse Testing
  • Resources involved in Data Warehouse Testing
  • Categories of Data Warehouse Testing
  • Testing Process of a Data Warehouse
  • ETL Testing Techniques
  • Difference between Database Testing and Data Warehouse Testing
Through this course you will learn to gain a deeper knowledge and understanding of the Data Warehouse