Oracle Database 19c: Data Warehousing Concepts

DesTech
Remote
Schedule

Partner
Remote
Schedule

Course DateStart TimeEnd TimeTime ZoneLocationDaysPrice
Call for In Class or Live Virtual Dates2$2,700 USDPurchase


O19: DWCON

Oracle Database 19c: Data Warehousing Concepts

This course covers all facets of Data Warehousing concepts, with lecture content and lab environment validated against the latest release of Oracle Database (19c).

Duration: 2 Days

Audience

  • Data Analysts
  • Data Warehouse Engineers
  • Database Administrators

Learning Objectives

  • Assess Data Warehousing and Business Intelligence requirements
  • Create analytic views in SQL Developer
  • Assess business modelling tasks
  • Assess logical and dimensional modelling tasks
  • Assess extraction, transformation, and loading tasks

Topics

  • Evolution of Information Management and Data Warehousing
  • Need for Machine Learning, Artificial Intelligence, and Big Data in Future Data Analytics
  • Data Warehouse and Multidimensional Model Concepts and Terminology
  • Create Analytic Views
  • About Business, Logical, Dimensional, and Physical Data Warehousing Models
  • Importance of Extraction, Transformation, and Loading Data in Data Warehousing Systems
  • Data Warehousing Platforms and Tools
Right Menu IconMENU