Datawarehousing Concepts:
Topics Covered:1 .What is and OLTP?2. What is Data Warehouse?3. OLTP Vs Data Warehouse?4. Why do you need Data Warehouse?5 .How do you build Data Warehouse?6. Data Warehousing Technology7. Definitions and descriptions8.Data Warehouse Architecture9. Introduction to BI tools10. Introduction to ETL tools11. Data Warehouse – Infrastructure12. Top Down Vs Bottom Up Approach13. Data Warehouse Vs Data Marts14. Standalone Data Marts15. Enterprise Data Warehouse16. Operational Data Store (ODS)17. Front end architectures—OLAP, ROLAP, MOLAP, HOLAP18. What is Data Modeling?19. Relational Data Modeling Vs Dimensional Data Modeling?20. Physical Vs Logical Modeling?21. Reverse Engineering Vs Forward Engineering?22. Physical Database Design23. Star Schema Vs Snow Flake Schema24. Facts & Dimensions25. Type 1, Type 2 and Type 3 Slowly Changing Dimension updates26. Surrogate key Concept.27. Data Staging28. Basic ETL Techniques