Email Us   Phone : 503-259-0312   
  Home    |    Instructor-led Training    |    Online Training     


Contact Us   -   Why Choose Wintrac   -   Clients    

Courses
ADA
Adobe
Agile
AJAX
Android
Apache
AutoCAD
Big Data
BlockChain
Business Analysis
Business Intelligence
Business Objects
Business Skills
C/C++/Go programming
Cisco
Citrix
Cloud Computing
COBOL
Cognos
ColdFusion
COM/COM+
CompTIA
CORBA
CRM
Crystal Reports
Data Science
Datawarehousing
DB2
Desktop Application Software
DevOps
DNS
Embedded Systems
Google Web Toolkit (GWT)
IPhone
ITIL
Java
JBoss
LDAP
Leadership Development
Lotus
Machine learning/AI
Macintosh
Mainframe programming
Microsoft technologies
Mobile
MultiMedia and design
.NET
NetApp
Networking
New Manager Development
Object oriented analysis and design
OpenVMS
Oracle
Oracle VM
Perl
PHP
PostgreSQL
PowerBuilder
Professional Soft Skills Workshops
Project Management
Rational
Ruby
Sales Performance
SAP
SAS
Security
SharePoint
SOA
Software quality and tools
SQL Server
Sybase
Symantec
Telecommunications
Teradata
Tivoli
Tomcat
Unix/Linux/Solaris/AIX/
HP-UX
Visual Basic
Visual Foxpro
VMware
Web Development
WebLogic
WebSphere
Websphere MQ (MQSeries)
Windows programming
XML
XML Web Services
Other
Introduction to DataBase Mining and Data Warehousing
Datawarehousing Training Overview

This course provides the students with skills necessary to understand and evaluate various available technologies in the area of Database Mining and Warehousing. It compares and contrasts various available techniques available for database mining, the algorithms behind each one, and which applications each is best suited for.

Datawarehousing Training Prerequisites

At least some experience with any relational database management systems.

Datawarehousing Training Course duration

2 Days

Datawarehousing Training Objectives

More specifically, this course will enable the students to:

  • Understand the concepts in Data Mining and Data Warehousing.
  • Understand Industry specific terms and abbreviations in use.
  • Understand the various techniques/algorithms used in Data Mining.
  • Compare and contrast the available products and tools.
  • Assess the requirements for building a data mart/warehouse.
  • Understand OLAP, multidimensional databases, and data organization for analytical processing.
  • Learn from the success and failure examples from prior applications of this technology in the industry.
  • Learn about the research directions in this field, and the resources to keep their knowledge up to date.
Datawarehousing Training Course outline

  1. Introduction and Overview
    • Current Trends in marketplace
    • The Need for Data Mining
    • Terminology: Data Marts, Warehouses, and Information Warehouses
      OLTP, OLAP, and Data Mining.
    • Types of Warehouses
    • Multi-dimensional databases
    • Success Stories
    • Horror Stories

  2. Developing the Warehouse
    • Different Organizations/Schemas
      • Star Schema
      • Snowflake Schema
    • Modeling (ER and EER) and Normalization
    • Data Transformation/Cleansing
    • Size Considerations
    • Hardware Estimation

  3. Challenges and Issues
    • Factors to Consider
      • Correctness
      • Scalability
      • Optimization
      • Usability
    • Storage Management
      • Using Read Only Tablespaces
    • Hardware Optimization
    • Query Optimization
      • BitMapped Indexes
      • Database Snapshots
      • Partition Views
    • Meta Data Management
    • Invalidation/Refresh of generated aggregates.

  4. Data Mining: Perspectives
    • The AI view
    • The Statistics View
    • The Database View

  5. OLAP and Data Mining: Comparison
    • The Role of OLAP
    • (MD) OLAP and ROLAP: ViewPoints
    • Differences between OLAP and DataMining

  6. Techniques for Data Mining
    • Neural Nets
    • Classification Trees
    • Regression Analysis
    • Rule Induction

  7. Rule Induction: In depth Overview
    • Market Basket Analysis
    • Generalized Association Rules

  8. Post Processing + Applications
    • Typicality/Atypicality
    • Distinguishing Segments
    • Predicting Missing Values

  9. What's Available:
    • Data Warehousing Tools
    • Data Mining Tools
    • Middleware Tools
    • Magazines, Webzines and Journals
    • Conferences and Papers Published
    • Other Resources on the Web

 
About us
Contact us
Careers at Wintrac
Our Clients
Why Wintrac


Register for a free training CD-ROM drawing
Refer a client or instructor and earn $$$


Wintrac Inc.
16523 SW McGwire Ct.
Beaverton OR 97007
 
? Wintrac, Inc. All rights reserved.                                                                               Site Map   |   Terms of Use   |   Privacy Policy