Databases:

• Introduction:-
  Database Environment.
  Database Development Process.

• Modeling Data in the Organization:-
  Enhanced E-R Model and Business Rules.



• Logical Database Design and the Relational Model:-
  Physical Database Design and Performance.
  The Software Engineering Process and Relational Databases.

• SQL:-
  Advanced SQL.
  Getting Started with SQL in Access.
  Beginning SQL Commands in Access.

• Client/Server Database Environment:-
  Internet Database Environment.
  Data Warehousing.
  Creating and Populating Tables.

• SQL Joins:-
  SQL Functions.

• SQL Query Development and Derived Structures:-
  SQL Set Operations

• SQL Joins versus Subqueries:-
  SQL Aggregation and GROUP BY.

• SQL Correlated Subqueries:-
  SQL Indexes and Constraints on Tables.

• Data and Database Administration:-
  Distributed Databases.

• Object-Oriented Data Modeling:-
  Object-Oriented Database Development.

Oracle Warehouse Builder Syllabus

Installation, Concepts, and Setup

1. Oracle Warehouse Builder Concepts and Overview
2. Installing Warehouse Builder (lesson, demo, and lab)
1. Describe components
2. Creating a Design Repository
3. Navigation
3. Capturing Data Source Definitions
1. Defining Source Metadata
2. Defining Staging Metadata
3. Mention Data Rules and Mapping (covered in detail later)
4. Data Profiling
4. Introduction to Dimensional Modeling
1. Defining a relational dimension model
2. Slowly Changing Dimensions
5. Overview of Extract, Transform, and Load (ETL)

 Usage in Production Environments

1. Designing Data Objects
2. Designing Process Flows
3. Introduction to Data Mapping
1. Using the Mapping Editor
4. OWB Editors
1. Object Editor
2. Table Editor
3. Dimension Editor
4. Expert Editor
5. Loading Data
1. Flat File Loading
2. Partition Exchange Loading
3. Query Loading
6. Deploying Warehouse Builder in Production Environments

Advanced Concepts

1. Transferring Metadata from OWB to Discoverer and Oracle OLAP
2. Managing Oracle Warehouse Builder
3. OLAP Modeling Concepts
4. OWB Scripting
1. Creating Experts
5. Identify and Manage Source Changes
6. Manage and Upgrade Warehouse Structures