In this tutorial we are going to discuss all about what is Data Warehouse Testing, how to perform testing in data warehousing correctly and efficiently along with three basic levels of testing performed on a data warehouse −
Unit testing
Integration testing
System testing
We have also learned Test Schedule, Testing Backup Recovery, Testing Operational Environment, Testing the Database, Testing the Application and Logistic of the Test in brief.
In the last lecture, we have covered 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
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_testing
Негізгі бет Data Warehouse Testing | Lecture #20 | Data Warehouse Tutorial
Пікірлер: 4