Skip to content
UdemySQLPaid courseAll LevelsCertificate

Learn Data Warehousing From Scratch- From Solution Architect (Udemy.com)

Real life data warehouse guide from the industry expert. Succeed in BI|DataWarehouse|Data Model|BIGDATA.

Created by: Asif Raza

Last updated October 2016

icon
What you will learn

  • Design and Build Data Warehouse
  • In depth understanding of DW Architecture
  • What is DWA
  • How can you transition yourself to BIGDATA

How it compares

Against the other 388 rated Udemy courses in SQL on CourseDuck:

  • Rating3.9 out of 5higher than 3% of them
  • Reviews762#170 of 389 by number of reviews
  • Length2 hoursshorter than 85% of them
  • Last updatedOctober 2016earlier than 92% of them

icon
Course Description

*****

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 IntelligenceDefine Data warehouseIndustry UsingData warehousingTypical BI environment

Data Warehousing Concepts

OLTP ,OLAPODS, Data MartsETLFacts, Dimensions, SCDSurrogate Keys, Factless-Fact

Two Major school of thoughts

Are they at war ?
Understand mythCase Studies

Ralph Kimball How to design Start Schema, Snow FlakeBus ArchitectureSample Data ModelsBill Inmon How to design 3rd Normal FormCIF ArchitectureSample Data Models

Data Warehouse Appliances

TeradataNetezzaExadata

Big Data

What's the Buzz wordWhat are 4 V'sUnderstand Big Data in BI termsMajor Player What is HadoopHadoop in DW worldExample - Architecture

NoSQl

What it isSQL VS NoSQL Types of NoSQL DB's

Major BI Vendors

Wish you all the very best!
Who this course is for:
Anyone who wants to get into data world can be benefited from this course.
MarketersStartup folksAspiring Data AnalystsDataBase DevelopersRecent College GradsJob-seekersBI folks

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

placeholder

I am Solution Architect with around15years of experience in IT industry specialising in BI and DWH domain including several greenfield projects implementation. I'm a passionate and experienced Solution architect and here to help you get going.
Determination and focus has landed me to heights with pretty neat people. I strongly believe knowledge increases by sharing. Hence, I have invested my knowledge and expertise to build up this training course for the wider community. People undergoing my training always have a delightful learning experience. I hope you make the most of this course.
Good Luck!

icon
More SQL courses

$94.99

$16.99

$12.99

$13.99

$10.99

$34.99

icon
Reviews

3.9

762 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

By Stu D on 12/20/2020

For someone who is looking at a good overall course on DWH, before choosing to go for ETL, SQL and BI, I found this very useful!

By Daniel Almeida on 9/6/2020

Sim, era o que esperava.

By Steven Hurst on 9/4/2020

Great course, very informative.

By Musarrat Zamir on 8/15/2020

Just the right amount of information

By Mark Jones on 6/3/2020

It was a crash course overview. Served a purpose, but not enough to do much practical.

By Yossi Tefera on 5/16/2020

A GREAT CONTENT. NEED SOME WORK ON THE LECTURE SIDE WHICH SEEMS ONLY READING.

By Jimmie Powell on 5/13/2020

The course author has done an excellent job on the introduction of the topic. His high-level explanation of topics were layer with just enough detail and examples to make the subject matter very clear to me.

By Sergio Tosti on 4/21/2020

The subtitles are generated automatically, but the teacher is not native speaker so they are inaccurate. Follow the lessons is not so simple

By Suresh Pattabhiraman on 3/10/2020

very nicely laid out. sometimes it lacks depth, but overall very good coverage and useful

By Israel Ramrez Ariza on 3/5/2020

Hast el momento vamos bien, creo que sera deseable dar un poco ms de detalle en los conceptos clave y las definiciones de conceptos complemtnarios (p.e. ETL, Data Integration, etc.).

By Justin Rojas on 2/12/2020

Could elaborate a little more instead of just streaming through it. Very hard to understand and also does not fully explain he just expects you to know it.

By Mani JV on 2/3/2020

Exercise on Case study could be given and evaluated as part of the course. This will give clear picture whether the candidate really understood the course or just skipped for completion.

Showing 12 of 169 reviews

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 78 / 100