Oracle Database 19c: Data Warehousing Concepts LVC

Cui îi este dedicat cursul?

Data Analyst, Database Administrator

Cunoștințe și abilități inițiale

-

Prezentarea cursului

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:

• 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

Ce subiecte abordează cursul

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

Ce abilități se dobândesc în urmă cursului

• -