CertAchiever

Instructor-led live online classes

Weekday Classes | Weekend Classes |

Data Warehousing Training

$160

Data Warehousing Training

A Self-Paced course designed to give you a head start into Data warehousing and train you on different concepts of Data warehousing along with the implementations of these concepts.

Training Features

Instructor-led Sessions

Both Weekdays and Weekend batches are available.

Real-Life Case Studies

During the sessions you will be working on the case studies provided by the trainer.

Lifetime Access

You will get the life time access of training material including videos & study guides..

Assignments

Each class will be followed by practical assignments to practice the concepts covered in class

24 x 7 Expert Support

We have a lifetime 24x7 online support team to resolve all your technical queries,through a ticket based tracking system..

Certification

Towards the end of the course, you will be awarded with Training competition certification based on you performance.

Course Curriculum

Learning Objectives

-Discussing about the basic concepts of a data warehouse and why it is needed. Difference between an operational system and an analytical system Datamarts. Approaches to build a data warehouse

Topics Covered

What is a data warehouse? - Definition and explanation of the four terms - subject oriented, integrated, non volatile and time variant, Need for a data warehouse, Difference between a database and a data warehouse. OLTP and OLAP?, Datamart - The smaller cousin of the data warehouse, ODS - Operational Data Store - Definition and explanation of 4 terms, Subject oriented, Integrated, Current, Volatile, Detailed, Benefits of ODS, Design approach - Top down approach, bottom up approach, Federated

Learning Objectives

Learning what a dimension and a fact is, the different types of dimensions and facts. Reporting concept of Hierarchy.

Topics Covered

Dimensions and facts - What are dimensions and facts?, Types of dimensions - emphasis on SCD 1,2,3 implementations , Types of facts, What are hierarchies - Types of Hierarchies

Learning Objectives

Organizing data in multiple tables. Understanding normalization and its different forms. Learning what is a schema and the different types of schemas along with meta data.

Topics Covered

Normalization, Schemas - What is a schema. Types - Star, Snowflake, Galaxy, Significant role of meta data

Learning Objectives

Understanding principles of requirement gathering to build a warehouse and dimensional modeling.

Topics Covered

Requirement gathering, Principles of dimensional modelling, Modeling - ER diagrams

Learning Objectives

Understanding where will the data come from and how will the data come and Populating the warehouse. Learning concepts of Extracting data, Transforming data and Loading the data into different tables.

Topics Covered

Concept - Architectural components - like Source, Staging, Atomic, Dimension Transformation - Data Validation, Data Accuracy, Data Type Conversion, Business Rule Application Data Loading techniques.

Learning Objectives

Implementing a data warehouse Project.

Topics Covered

Discuss a project, its problem statement, probable solutions, and implement one solution.

FAQ's

You will never miss a lecture at CertAchiever! You can choose either of the two options:

View the recorded session of the class available in your LMS.

·You can attend the missed session, in any other live batch."

We have limited number of participants in a live session to maintain the Quality Standards. So, unfortunately participation in a live class without enrollment is not possible. However, you can go through the sample class recording and it would give you a clear insight about how are the classes conducted, quality of instructors and the level of interaction in the class.

You can give us a CALL at +918882136965 (IN) OR email at admin@certachiever.com

Certification

Once your training will complete, you will be awarded with training completion certification from the Trainer.

$160

Data Warehousing Training

Instructor-led Sessions

Real-Life Case Studies

Lifetime Access

Assignments

24 x 7 Expert Support

Certification

Course Curriculum

Introduction to Data Warehouse

Dimension and Fact

Normalization and Schemas

Modeling

ETL in Detail

Project

FAQ's

What if I Miss a Class

Can I attend a Demo Session before enrollment

What if I have some more queries??

Certification

Training Certification Process