Data Warehouse Concepts: Basic to Advanced concepts

Data Warehouse Concepts: Learn the in BI/Data Warehouse/BIG DATA Concepts from scratch and become an expert.

What you'll learn

In this course, you would be learning all the concepts and terminologies related to the Datawarehouse , such as the OLTP, OLAP, Dimensions, Facts and much more, along with other concepts related to it such as what is meant by Start Schema, Snow flake Schema, other options available and their differences.
It also explains how the data is managed with in the Data Warehouse and explains the process of reading and writing data onto the Warehouse. Later in the course you would also learn the basics of Data Modelling and how to start with it logically and physically. You would also learn all the concepts related to Facts, Dimensions, Aggregations and commonly used techniques of ETL.
Upon completion of this course, you would have a clear idea about, all the concepts related to the Data Warehouse, that should be sufficient to help you start off with the next step of becoming an ETL developer or Administering the Data warehouse environment with the help of various tools.
All the Best and Happy Learning !

Requirements

Basic understanding of the IT (Software) industry
Familiar with the basic concept of Database/RDBMS.

Description

In this course, you will learn all the concepts and terminologies related to the Data Warehouse , such as the OLTP, OLAP, Dimensions, Facts and much more, along with other concepts related to it such as what is meant by Start Schema, Snow flake Schema, other options available and their differences. It also explains how the data is managed with in the Data Warehouse and explains the process of reading and writing data onto the Warehouse. Later in the course you would also learn the basics of Data Modelling and how to start with it logically and physically. You would also learn all the concepts related to Facts, Dimensions, Aggregations and commonly used techniques of ETL. Upon completion of this course, you would have a clear idea about, all the concepts related to the Data Warehouse, that should be sufficient to help you start off with the next step of becoming an ETL developer or Administering the Data warehouse environment with the help of various tools. All the Best and Happy Learning !

Who this course is for:

This Course is intended for freshers who are new to the Data Warehouse world, Application/ETL developers, Mainframe develoeprs, database administrators, system administrators, and database application developers who design, maintain, and use data warehouses.
Recent graduates looking to get a job in the IT Industry
Finance professionals wanting to learn about Data Warehouses for reporting and analysis purposes, businesses looking to update and improve on data storage, analysis, and reporting processes.