Course Date | Start Time | End Time | Time Zone | Location | Days | Price | |
---|---|---|---|---|---|---|---|
Call for In Class or Live Virtual Dates | 2 | $2,700 USD | Purchase |
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