Code: 
D73528
Duration: 
2 Day(s)
Price: 
990

Overview

In this course, students review the basic concepts of data mining and learn how leverage the predictive analytical power of the Oracle Database Data Mining option by using Oracle Data Miner 11g Release 2. The Oracle Data Miner GUI is an extension to Oracle SQL Developer 3.0 that enables data analysts to work directly with data inside the database.The Data Miner GUI provides intuitive tools that help you to explore the data graphically, build and evaluate multiple data mining models, apply Oracle Data Mining models to new data, and deploy Oracle Data Mining's predictions and insights throughout the enterprise. Oracle Data Miner's SQL APIs automatically mine Oracle data and deploy results in real-time. Because the data, models, and results remain in the Oracle Database, data movement is eliminated, security is maximized and information latency is minimized

Audience

  • Application Developers
  • Business Analysts
  • Data Warehouse Analyst
  • Database Administrators

Skills Gained

  • Explain basic data mining concepts and describe the benefits of predictive analysis
  • Understand primary data mining tasks, and describe the key steps of a data mining process
  • Use the Oracle Data Miner to build,evaluate, and apply multiple data mining models
  • Use Oracle Data Mining's predictions and insights to address many kinds of business problems, including: Predict individual behavior, Predict values, Find co-occurring events
  • Learn how to deploy data mining results for real-time access by end-users

Prerequisites

  • A working knowledge of: The SQL language and Oracle Database design and administration

Course Specifics

Course Outline

Introduction

  • Course Objectives
  • Suggested Course Pre-requisites
  • Suggested Course Schedule
  • Class Sample Schemas
  • Practice and Solutions Structure
  • Review location of additional resources (including ODM and SQL Developer documentation and online resources)

Overviewing Data Mining Concepts

  • What is Data Mining?
  • Why use Data Mining?
  • Examples of Data Mining Applications
  • Supervised Versus Unsupervised Learning
  • Supported Data Mining Algorithms and Uses

Understanding the Data Mining Process

  • Common Tasks in the Data Mining Process

Introducing Oracle Data Miner 11g Release 2

  • Data mining with Oracle Database
  • Introducing the SQL Developer interface
  • Setting up Oracle Data Miner
  • Accessing the Data Miner GUI
  • Identifying Data Miner interface components
  • Examining Data Miner Nodes
  • Previewing Data Miner Workflows

Using Classification Models

  • Reviewing Classification Models
  • Adding a Data Source to the Workflow
  • Using the Data Source Wizard
  • Creating Classification Models
  • Building the Models
  • Examining Class Build Tabs
  • Comparing the Models
  • Selecting and Examining a Model

Using Regression Models

  • Reviewing Regression Models
  • Adding a Data Source to the Workflow
  • Using the Data Source Wizard
  • Performing Data Transformations
  • Creating Regression Models
  • Building the Models
  • Comparing the Models
  • Selecting a Model

Performing Market Basket Analysis

  • What is Market Basket Analysis?
  • Reviewing Association Rules
  • Creating a New Workflow
  • Adding a Data Source to th Workflow
  • Creating an Association Rules Model
  • Defining Association Rules
  • Building the Model
  • Examining Test Results

Using Clustering Models

  • Describing Algorithms used for Clustering Models
  • Adding Data Sources to the Workflow
  • Exploring Data for Patterns
  • Defining and Building Clustering Models
  • Comparing Model Results
  • Selecting and Applying a Model
  • Defining Output Format
  • Examining Cluster Results

Performing Anomaly Detection

  • Reviewing the Model and Algorithm used for Anomaly Detection
  • Adding Data Sources to the Workflow
  • Creating the Model
  • Building the Model
  • Examining Test Results
  • Applying the Model
  • Evaluating Results

Deploying Data Mining Results

  • Requirements for deployment
  • Deployment Tasks
  • Examining Deployment Options

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

Scheduled Dates

  • Location
    Cost
    Duration
    Start Date
     
London (Central)
  • TBA
    0
    2
    18 May 15
  • London (Greater)
    • TBA
      0
      2
      18 May 15
    • Manchester (Greater)
      • TBA
        0
        2
        01 Jun 15
      • Edinburgh
        • TBA
          0
          2
          01 Jun 15
        • Glasgow
          • TBA
            0
            2
            29 Jun 15
          • Aberdeenshire
            • TBA
              0
              2
              20 Apr 15
            • Bristol
              • TBA
                0
                2
                23 Mar 15
              • Buckinghamshire
                • TBA
                  0
                  2
                  20 Apr 15
                • Cambridgeshire
                  • TBA
                    0
                    2
                    11 May 15
                  • County Antrim
                    • TBA
                      0
                      2
                      20 Jul 15
                    • Devon
                      • TBA
                        0
                        2
                        27 Jul 15
                      • Dorset
                        • TBA
                          0
                          2
                          30 Mar 15
                        • Essex
                          • TBA
                            0
                            2
                            30 Mar 15
                          • Glamorgan (South)
                            • TBA
                              0
                              2
                              04 May 15
                            • Gloucestershire
                              • TBA
                                0
                                2
                                13 Jul 15
                              • Greater London
                                • TBA
                                  0
                                  2
                                  01 Jun 15
                                • Hampshire
                                  • TBA
                                    0
                                    2
                                    30 Mar 15
                                  • Hertfordshire
                                    • TBA
                                      0
                                      2
                                      25 May 15
                                    • Kent
                                      • TBA
                                        0
                                        2
                                        22 Jun 15
                                      • Leicestershire
                                        • TBA
                                          0
                                          2
                                          03 Aug 15
                                        • Manchester
                                          • TBA
                                            0
                                            2
                                            18 May 15
                                          • Midlands (West)
                                            • TBA
                                              0
                                              2
                                              06 Apr 15
                                            • Northamptonshire
                                              • TBA
                                                0
                                                2
                                                23 Mar 15
                                              • Northumberland
                                                • TBA
                                                  0
                                                  2
                                                  06 Jul 15
                                                • Nottinghamshire
                                                  • TBA
                                                    0
                                                    2
                                                    03 Aug 15
                                                  • Oxfordshire
                                                    • TBA
                                                      0
                                                      2
                                                      13 Apr 15
                                                    • Somerset
                                                      • TBA
                                                        0
                                                        2
                                                        08 Jun 15
                                                      • Suffolk
                                                        • TBA
                                                          0
                                                          2
                                                          08 Jun 15
                                                        • Surrey
                                                          • TBA
                                                            0
                                                            2
                                                            08 Jun 15
                                                          • Sussex (East)
                                                            • TBA
                                                              0
                                                              2
                                                              01 Jun 15
                                                            • Sussex (West)
                                                              • TBA
                                                                0
                                                                2
                                                                11 May 15
                                                              • Warwickshire
                                                                • TBA
                                                                  0
                                                                  2
                                                                  03 Aug 15
                                                                • Worcestershire
                                                                  • TBA
                                                                    0
                                                                    2
                                                                    08 Jun 15
                                                                  • Online
                                                                    • TBA
                                                                      0
                                                                      2
                                                                      04 May 15
                                                                    • Virtual Class
                                                                      • Virtual Class
                                                                        990
                                                                        2
                                                                        06 Apr 15
                                                                      • Virtual Class
                                                                        1230
                                                                        2
                                                                        06 Apr 15

Quick Links