Partitioning in Data Warehouse | Lecture #12 | Data Warehouse Tutorial



In this tutorial we are going to discuss all about Partitioning in Data Warehousing. Why Partitioning is necessary while designing data warehouse and their major types such as-
1. Horizontal Partitioning
2. Vertical Partitioning
and their sub types with some simple examples in brief.

In the last lecture, we have covered what is Schemas in Data Warehouse along with its different types such as Star Schema, Snowflake Schema, Fact Constellation Schema (Galaxy Schema) with their architecture, advantages and disadvantages.Data Warehouse full course playlist-

data warehouse is collection of organizational data used to help an organization to make important decisions and improve business.

We will be covering all the Data Warehouse concepts with easy to understand tutorials which will help you master conceptual knowledge of Data Warehousing.

But first, you should be aware of Structured Query Language (SQL) which we have already covered. Please find the link for FULL COURSE OF SQL.

SQL Full Course Playlist-

PYTHON Full Course Playlist-

Description

AmpCode provides you e-learning platform with a mission of making education accessible to every student. AmpCode will provide you tutorials, full courses of some of the best technologies in the world today.By subscribing to this channel, you will never miss out on high quality videos on trending topics in the areas of Big Data & Hadoop, DevOps, Machine Learning, Artificial Intelligence, Angular, Data Science, Apache Spark, Python, Selenium, Tableau, AWS , Digital Marketing and many more.

#data_warehouse #data_warehouse_tutorial #data_warehouse_architecture#database #sql #data_analytics #data_science #partitioning

source

Avatar of AmpCode

By AmpCode

Leave a Reply

Your email address will not be published.

Captcha loading...