ฝัง
- เผยแพร่เมื่อ 30 มิ.ย. 2024
- In this tutorial we are going to discuss all about Data Warehouse Tuning. what is Tuning, why it is essential in Data Warehousing and their different categories.
We have also covered-
Difficulties in Data Warehouse Tuning
Performance Assessment
Data Load Tuning
Integrity Checks
Tuning Queries-
Fixed queries
Ad hoc queries
In the last lecture, we have covered Data Warehouse Backup and Recovery strategies, their importance and different categories such as-
* Hardware Backup
1. Tape Technology (Tape media, Standalone tape drives, Tape stackers, Tape silos)
2. Disk Backups ( Disk-to-disk backups, Mirror breaking)
* Software Backups and Criteria for Choosing Software Packages
Data Warehouse full course playlist- • 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- • SQL Full Course
PYTHON Full Course Playlist- • Python Full Course
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 #data_warehouse_tuning
