Fundamentals of Data Warehousing

Displaying courses for United States [Change]

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
United States
This skill has an average salary of
US$102,217
and is mentioned in
0.79%
of job ads in this area.
Oracle Database
United States
This skill has an average salary of
US$99,577
and is mentioned in
3.11%
of job ads in this area.
Database
United States
This skill has an average salary of
US$77,598
and is mentioned in
11.87%
of job ads in this area.
Database design
United States
This skill has an average salary of
US$99,946
and is mentioned in
0.45%
of job ads in this area.