The following is a summary of the blog posts grouped by topics.

#### Build Predictive Models

- How to build predictive models that win competitions.
- Build Predictive Models Using PL/SQL
- Oracle On The Fly Model- Clustering
- Build Best Direct Marketing Predictive Models
- Zip Code and Predictive Models
- More On Zip Code and Predictive Models - Variable of High Cardinality

#### Predictive Models vs Business Rules

- Predictive Modeling vs Intuitive Business Rules
- Comparison of Business Rules and Predictive Models
- A Real World Case Study: Business Rule vs Predictive Model

#### Predictive Model Variables

- Find the Most Important Variables In Predictive Models
- How to build predictive models that win competitions. (continued)
- Abraham Lincoln and Predictive Modeling Project
- Build Best Direct Marketing Predictive Models
- Recency, Frequency, Monetary (RFM) Analysis: Part 1
- Recency, Frequency, Monetary (RFM) Analysis: Part 2
- Recency, Frequency, Monetary (RFM) Analysis: Part 3
- Recency, Frequency, Monetary (RFM) Analysis: Part 4
- Recency, Frequency, Monetary (RFM) Analysis: Part 5. RFM Code

#### Import Text File Into Oracle

- Five Ways of Loading Text Files Into Oracle Database
- A Quick Way to Import Spreadsheet Into a Relational Database
- "Fix" a Text File that Is in Unix Format
- Add Line Number to Text File
- How to Change Delimiters of Text File
- Analyze Text Files in Real Time Using SQL Without Loading Them into Database
- Why Sometime It Is Not a Good Idea to Export Database Tables as Text Files?
- Calculate Histogram for a Text File
- How to Query a Text File In Oracle
- More On Oracle External Table

#### Unique Identifiers in Oracle

- Five Ways of Creating Unique Record Identifier For Oracle Tables
- How to Generate Globally Unique Identifier on the Fly

#### Recency Frequency Monetary

- Recency, Frequency, Monetary (RFM) Analysis: Part 1
- Recency, Frequency, Monetary (RFM) Analysis: Part 2
- Recency, Frequency, Monetary (RFM) Analysis: Part 3
- Recency, Frequency, Monetary (RFM) Analysis: Part 4
- Recency, Frequency, Monetary (RFM) Analysis: Part 5. RFM Code

#### Oracle Materialized View

- Take Advantage of Materialized View
- More On Oracle External Table
- Get the source code for Oracle database views and materialized view
- Refresh an Oracle Materialized View

#### Database Link to Oracle on Amazon

- Create Database Link to DB on Amazon EC2 Instance
- Compare Oracle Tables in Different Databases: Find an ETL Issue
- Why Sometime It Is Not a Good Idea to Export Database Tables as Text Files?

#### Calculate Percent Using SQL

- Three Ways of Calculating Percentage of Counts Using Oracle SQL
- Three Ways of Calculating Percentage of Quantity Using Oracle SQL

#### Calculate Cumulative Percent Using SQL

#### Find Score Cutoff Value Using SQL

#### Remove Duplicates Using SQL

#### Calculate Correlation Coefficients Using SQL

- Calculate correlation coefficient between two variables using SQL
- Calculate the Correlation Coefficient Using SQL
- Calculate correlation matrix using SQL
- Calculate correlation matrix using SQL (continued)

#### Oracle vs SQL Server

#### NULL Value

- Calculate Average Value - Watch Out NULL Values
- NULL Value and Logical Comparison
- NULL Value and Order By
- NULL Value and Arithmetic Operations

#### Logistic Regression

- Data preparation for building logistic regression models
- More on Data Preparation for Logistic Regression Models
- Categorical Variables in Logistic Regression

#### Random Sampling

- A random sampling method for medical claim audit
- Random Sampling using SQL
- More on random sampling in Oracle

#### Table Insert

- Insert Records Into an Oracle Table and Rollback
- Oracle Multiple Table Insert
- Oracle Direct Path Insert

#### Read Only Table

#### Clustering

- Build K-Means Clustering Models Using PL/SQL
- Oracle On The Fly Model- Clustering
- Impute Missing Values Using Clustering Algorithms

#### Ranking

#### Find Most Frequent

#### Median Value

#### Oracle Source Code

- More on Get Source Code for Oracle Database Objects
- Get the source code for Oracle database views and materialized view