Overview

In this course, students will describe the fundamentals of data warehousing.

Objectives

Upon successful completion of this course, students will be able to: -
  • identify the fundamental concepts of databases and familiarize yourself with Oracle 11g interface elements.
  • create a preliminary database design.
  • apply normalization techniques to a database.
  • use the SQL commands in the Oracle 11g interface and execute simple queries.
  • work with the PL/SQL commands to manipulate data.
  • manage databases.
  • administer a database.

Audience

Target students can be persons who have a technical background in using a desktop computer database and who wish to acquire competency in Oracle systems terminology and usage so as to pursue a career as an Oracle technical professional. Students can also be IT systems managers or administrators who will be working within an Oracle-based enterprise IT department and need to interact in a productive manner with Oracle technical professionals.

Syllabus

Understanding a Data Warehouse

  • Introduction to Data Warehousing
  • Types of Databases
  • OLTP and OLAP

Understanding Enterprise Data

  • Data Sources for a Data Warehouse
  • Characteristics of DWH Data

Data Warehouse Design

  • Data Warehouse Design & Modeling
  • Dimensional Model Schemas

Understanding the Data Warehousing Lifecycle

  • Data Integration
  • Extracting, Transforming and Loading of Data
  • Data Storage and Presentation Layer
  • Data Warehouse Tools

Business Value of Data Warehousing

  • Applications of Data Warehousing
  • Data Mining

Training provider

Teaching mode:
Online - Self paced
Classroom - Instructor Led
Duration: 1 day
Gooroo has partnered with the global leaders in IT training to give you access to quality training, personalised to you, targeted at increasing your job opportunities and salary.

Our pricing

We do not display pricing as Gooroo members qualify for special discounts not available elsewhere. You must enquire through Gooroo to get this benefit.

New courses are happening all the time

Our partner's expert training consultant will provide you with the times and all the details you need. Enquire today.

Top skills covered in this course

Data warehouse
Worldwide
This skill has an average salary of
US$95,320
and is mentioned in
0.72%
of job ads.
Oracle Database
Worldwide
This skill has an average salary of
US$92,493
and is mentioned in
2.56%
of job ads.
Database
Worldwide
This skill has an average salary of
US$75,545
and is mentioned in
10.42%
of job ads.
Database design
Worldwide
This skill has an average salary of
US$93,222
and is mentioned in
0.42%
of job ads.