Oracle Data Warehouse Basics

• the role of Business Intelligence (BI) and Oracle Data Warehousing today
• the terminology for Oracle Data Warehousing
• the different technologies for implementing Oracle Data Warehouses
• implementation and organisational issues related to data warehouse projects
• the different concepts for modelling data warehouses
• ETL processes for creating Oracle Data Warehouses
• identify administration and maintenance processes related to Oracle Data Warehouse projects
• Methods for updating warehouse data
• Concepts for warehouse metadata

1st unit - Business Intelligence and Data Warehousing under Oracle

• Business Intelligence and Data Warehousing
• Basics of Business Intelligence (BI)
• Data Warehouse and OLTP (Online Transaction Processing) - a comparison
• Business factors for data warehouses
• Business Intelligence and Data Warehousing solution from Oracle
• Management Information Systems and Decision Support Systems (DSS)

2. Unit -Defining Concepts and Terminology for Oracle Data Warehouses

• Common Oracle Data Warehouse Definitions
• Features and characteristics of Oracle Data Warehouses
• Components for designing and implementing Oracle Data Warehouses
• Components of an Oracle Data Warehouse
• Oracle Data Warehouses and Data Marts - Comparison
• Dependent and independent data marts
• Typical Data Warehouse Components
• Development methods for warehouses
• Process components of data warehouses and related objects

3. Unit -Planning and managing Oracle Data Warehouse projects

• Consider important financial issues
• Return on investment (ROI) and associated costs
• Ensure business support
• identify business and user requirements
• identify data access requirements
• Implementation requirements of Oracle Data Warehouses

4. Unit -Modelling Oracle Data Warehouses

• describe data structures of the data warehouse environment
• Oracle Data Warehouse database design phases
• define the business model
• define the dimensional model
• define the physical model
• Oracle Database Architecture - Benefits
• the data partitioning and indexing
• star query optimization
• parallelism, aggregate data and query rewrite

5. Unit -Creating Oracle Data Warehouses: Extracting Data

• the extraction, transformation and loading processes
• extract the data
• check different data sources
• identify extraction techniques and methods
• design the extraction processes
• manage the extraction metadata
• investigate potential problems with ETL and ensure ETL quality
• Investigate Oracle's ETL solution

6. Unit -Creating Oracle Data Warehouses: Transforming Data

• Define transformation
• Investigate possible staging models Data anomalies and transformation routines
• Various data quality issues
• Transformation techniques Manage transformation metadata
• design the transformation processes

7. Unit -Creating Oracle Data Warehouses: Loading Warehouse Data

• loading data into the warehouse
• data update models
• create the loading process
• the loading techniques
• the post-processing of loaded data
• check the data integrity

8. Unit - Updating Oracle Data Warehouse Data

• Acquire and apply modified data
• requirements for loading in batch mode
• Capturing changed data for updating
• Select method to capture changed data
• Change Data Capture and Update Mechanisms in Oracle
• Applying Changes to Data
• Limitations of methods to apply changes
• Delete and archive data. Selection criteria for ETL tools

9. Unit -Create Oracle Metadata Trail

• Oracle Data Warehouse Metadata - Definition
• the metadata types - DETAILS
• develop different metadata strategies
• the metadata management tools
• Common Oracle Warehouse Metadata

10. Unit - Managing and Maintaining Oracle Data Warehouses

• manage the transition to production
• implement a pilot version of the Data Warehouse
• the post-implementation support
• manage growth
• identify and resolve any performance issues with the data warehouse

Oracle Administration

We conduct this seminar online for you. You can book the training as a public seminar or as a company seminar. The practical exercises are carried out in our Remotelab and make up 40-50 percent of the seminar.

• Implementation guarantee - Implementation guarantee for two or more participants
• Mobile classrooms - the ideal complement for company seminars
• Free support - for questions after the seminar
• Delivery on account - no prepayment required
• Interview with the trainer / quality assurance - get to know and assess the trainer in advance
• Clarify seminar requirements - review your knowledge with the trainer
• Assistance with travel costs - we cover part of the costs of hotel accommodation
• Meals - all day cold / hot drinks and a full lunch in the restaurant
• Location of training centres - always centrally located and easily accessible
• Discount - we have attractive prices, take advantage of our additional discounts
• Remotelabs - rent our Remotelabs for your own seminars or as a complement to your company seminars