Tutorialspoint
Flash Weekend Sale | Use Coupon "WEEKEND" to get flat 10% OFF
Sale Ends In

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.

    • Brief about the Data warehouse
      4 Lectures
    • Business Intelligence
      4 Lectures
    • Data Warehouse Architectures
      8 Lectures
    • ODS - Operational Data Store
      4 Lectures
    • OLAP
      7 Lectures
    • Data Mart
      6 Lectures
    • Metadata
      6 Lectures
    • Data Modeling
      2 Lectures
    • Entity Relational Data Model
      14 Lectures
    • Dimensional Model
      21 Lectures
    • DWH Indexes
      4 Lectures
    • Data Integration and ETL
      3 Lectures
    • ETL Vs ELT
      3 Lectures
    • ETL - Extraction Transformation & Loading
      3 Lectures
    • Typical Roles In DWH Project
      13 Lectures
    • DW/BI/ETL Implementation Approach
      18 Lectures
  • 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 !

    What Will I Get ?

    • Brief about the Data Warehouse and how the concept came into existence
    • Business Intelligence Concepts
    • Data Warehouse Architectures
    • ODS - Operational Data Store
    • OLAP - Online Analytical Processing
    • Data Marts
    • Metadata
    • Data Modeling
    • Entity Relationship Model
    • Dimensional Model
    • Data Integration & ETL
    • ETL vs ELT
    • ETL - Extraction Transformation & Loading
    • Typical Roles in a Data Warehouse Project
    • DW/BI/ETL Implementation Approach

    Requirements

    • Basic understanding of the IT (Software) industry
    • Familiar with the basic concept of Database/RDBMS.
Data Warehouse Concepts: Basic to Advanced concepts
This Course Includes :

06:56:10 Duration

120 Lectures

Lifetime Access

30-Days Money Back Guarantee

Related Videos

Tutorialspoint