This course covers all facets of Data Warehousing concepts, with lecture content and lab environment validated against the latest release of Oracle Database (19c).
The course covers the following topics:
Objectives
- Assess Data Warehousing and Business Intelligence requirements
- Create Analytic Views in SQL Developer
- Assess Business Modeling tasks
- Assess Logical and Dimensional Modeling tasks
- Assess Extraction, Transformation, and Loading tasks
Topics
- Evolution of information management systems and data warehousing
- Need for machine learning, artificial intelligence, and big data in future data analytics
- Data warehouse concepts and terminology
- Multidimensional model concepts and create analytic views
- Explain the business, logical, dimensional, and physical data warehousing models
- Importance of extraction, transformation, and loading in data warehousing systems
Other Trainings
Database
91 Training Set
