Data Mining using SQL


You are here: [Data Mining using SQL Syllabus]

Printable Version

Data Mining using SQL: Course Syllabus Summer 2018

Currently no courses scheduled for this term.

Class 1

  • Introduction to Data Mining
  • SQL Fundamentals
  • SQL Queries

Class 2

  • Exploring Data
    • Numeric Values
    • String Values
    • Exploring Values across Columns
    • Summarizing Column Values

Class 3

  • Basic Statistical Concepts
    • Types of Variables
    • Null Hypothesis
    • Confidence vs. Probability
    • Variance/Standard Deviation
    • Normal Distribution
  • Qualifying Data using Statistics
    • How Different is Different
    • Qualifying Counts
    • Qualifying Ratios
    • Chi-Square Test

Class 4

  • Analyzing Geographic Data
    • Location, Location, Location
    • Census Demographics
    • Geographic Hierarchies
    • Mapping in Excel

Class 5

  • Analyzing Temporal Data
  • Customer Survivor Analysis
  • Data Mining Models