| Course Date | Start Time | End Time | Time Zone | Location | Days | Price | |
|---|---|---|---|---|---|---|---|
| Call for In Class or Live Virtual Dates | 3 | $3,600 USD | Purchase |
Oracle Database 19c: Data Warehousing Techniques
This course covers all facets of Data Warehousing Techniques, with lecture content and lab environment validated against the latest release of Oracle Database (19c).
Duration: 3 Days
Audience
- Data Analysts
- Data Architects
- Database Administrators
Learning Objectives
- Connect to ODI Master and work repositories
- Define the topology for source and target data warehouse systems
- Set up an ODI project
- Create ODI Models and reverse engineer
- Check data quality in the model
- Create an ODI mapping with simple transformations
- Create an ODI mapping with complex transformations
- Load data from a single data source
- Load data from multiple data sources
Topics
- Data Warehousing Concepts
- Data Extraction, Transformation, Loading, and Data Refresh Techniques
- Database Sizing, Storage, and Security Considerations
- Summary Management and Implement Materialized Views
- Metadata Management
- Data Warehouse Implementation Considerations
