Udemy Learn Data Warehousing From Scratch- From Solution Architect Udemy
Price: AED 73

    Course details

    ***25-OCT-2016***

    Added Hadoop Distributions Comparison sheet to let you choose the right Hadoop distribution based on several Parameters.

    *****

    Do you want to master in Data warehousing, keen to become an expert ? Me being worked on several Data Warehousing implementation projects in last 12 years here in UK. I will give you the grain of what's needed to implement a successful Data Warehouse project.

    We've heard it all, big data and the intelligence to understand these chunks of data. Most persons have to start from scratch or meet mid-way to become an expert in business Intelligence domain.

    Course is meant for someone who wants to understand fundamentals of DW and various architectural pieces around it and eventually become a part of big data revolution.

    This course is built to get you the grain of the subject and give you what is essential for newbie to eventually become an expert at the end of the course. Come and Join the journey!!

    Course Highlights Introduction

    • Business Challenge?
    • Need for Business Intelligence
    • Define Data warehouse
    • Industry UsingData warehousing
    • Typical BI environment

    Data Warehousing Concepts

    • OLTP ,OLAP
    • ODS, Data Marts
    • ETL
    • Facts, Dimensions, SCD
    • Surrogate Keys, Factless-Fact

    Two Major school of thoughts

    • Are they at war ?
    • Understand myth
    • Case Studies
    • Ralph Kimball
      • How to design
      • Start Schema, Snow Flake
      • Bus Architecture
      • Sample Data Models
    • Bill Inmon
      • How to design
      • 3rd Normal Form
      • CIF Architecture
      • Sample Data Models

    Data Warehouse Appliances

    • Teradata
    • Netezza
    • Exadata

    Big Data

    • What's the Buzz word
    • What are 4 V's
    • Understand Big Data in BI terms
    • Major Player
    • What is Hadoop
    • Hadoop in DW world
    • Example - Architecture

    NoSQl

    • What it is
    • SQL VS NoSQL
    • Types of NoSQL DB's
    • Major BI Vendors

    Wish you all the very best!

    Updated on 21 January, 2015

    Database Management Related Questions

    Courses you can instantly connect with... Do an online course on Database Management starting now. See all courses