About the course
A Data Warehouse has the potential to revolutionise your business. Increased
profitability, customer retention, and market penetration are all possible
applications of an effective Data warehouse implementation … but
first of all you have to build it.
The approach, method and design techniques required to build a Data Warehouse
differ significantly from those required to build a database to support
on-line transaction processing.
This practical course introduces the delegate to all the necessary terminology,
architectures, approaches, skills, tools, techniques, and infrastructure
required to design and implement a successful Data Warehouse solution.
This is largely achieved by guiding the delegate through an easy to understand,
incremental, and iterative process, and also through a series of practical
exercises.
In this course, students study the issues involved in planning, designing,
building, populating, and maintaining a successful data warehouse. Students
learn the reasons why data warehousing is a compelling decision support
solution in today's business climate. They examine the Oracle approach
to a successful data warehouse implementation using a proven methodology.
During the course, students examine Oracle warehouse technology.
Being based on the Oracle RDBMS, the extensive practical element of this
course reflects the urgency for real, usable skills, that developers must
have in the real world. The numerous exercises and demonstrations - using
technology from the world's leading business intelligence software vendor
- make this course far more useful than one which is non-vendor specific.
The product “tasters” in the course, for example a BusinessObjects
overview, add to the richness of the experience and illustrate, using
market leading products, how end-to-end ETL can be performed. The intention
is that not only will you have specific Oracle data warehousing skills
at the end of the course, but also a complete overview of the elements
of data warehousing and associated activities.
If you are an Oracle version 8 site, you may well be looking over the
fence at Oracle 9i and deciding whether to move forwards, based on the
new features offered. This course may help you, as the new 9i data warehousing
features are discussed.
You will acquire these hands-on skills on the course:-
- design, implement, utilise, maintain, and administer the Data Warehouse
- build models using the dimensional (star schema) modelling technique
extract data
- transform, condition, and cleanse the data
- populate the Data Warehouse using a variety of mechanisms
- query, drill-down, and report the data
- understand the role of Oracle’s extract tools such as OLAP and
data mining
- understand the importance of metadata and issues surrounding its integration
- assess your organisation's readiness to embark on a Data Warehousing
project
Who should attend
Developers, software engineers, database administrators, data analysts,
system analysts or application designers who will be involved in designing,
building or maintaining a Data Warehouse.
Please note that the training is also suitable for delegates from Oracle
version 8 sites as well.
Prerequisites
Delegates require a basic understanding of IT and how business systems
use IT; this would be gained by at least a year's experience in IT or
business systems development.
It is assumed that delegates attending this course will already have had
some exposure to Relational Databases and Database Modelling in an Oracle
environment. Systems/Application programming experience would be an advantage.
Database modelling skills can be acquired on Concentrika’s SSADM
analysis and design courses. You will be familiar with Oracle SQL and
SQL*PLUS. The course is technical and hands-on in nature, within an Oracle
RDBMS environment.
All the prerequisites for the training can be successfully met by attendance
on appropriate courses from Concentrika.
(Please phone us for guidance if you are uncertain about meeting the prerequisites,
or if you require further advice before deciding to attend).
Duration
4 days |
