Data Warehouse Testing | Lecture #20 | Data Warehouse Tutorial

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- https://youtube.com/playlist?list=PL6UwySlcwEYKxi-fQHLkVYDZrJcBawZA9A 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- https://youtube.com/playlist?list=PL6UwySlcwEYISVLQlYi3W6rGCIo9sJM0J PYTHON Full Course Playlist- https://youtube.com/playlist?list=PL6UwySlcwEYJgM4eUQOvR1KAWryFYcclq 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