Data Mining using SQL
You are here: [Data Mining using SQL Syllabus]
Printable Version

Data Mining using SQL: Course Syllabus Fall 2019

Class 1: Saturday, October 12, 2019
  • Introduction to Data Mining
  • SQL Fundamentals
  • SQL Queries
Homework 1 Due Date/Time: Friday, October 18, 2019 (Noon)

Class 2: Saturday, October 19, 2019
  • Quiz 1(closed book)
  • Exploring Data
    • Numeric Values
    • String Values
    • Exploring Values across Columns
    • Summarizing Column Values
Homework 2 Due Date/Time: Friday, October 25, 2019 (Noon)

Class 3: Saturday, October 26, 2019
  • Quiz 2(closed book)
  • 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
Homework 3 Due Date/Time: Friday, November 01, 2019 (Noon)

Class 4: Saturday, November 02, 2019
  • Quiz 3(closed book)
  • Analyzing Geographic Data
    • Location, Location, Location
    • Census Demographics
    • Geographic Hierarchies
    • Mapping in Excel
Homework 4 Due Date/Time: Friday, November 15, 2019 (Noon)

Final Take-Home Exam Due Date/Time: Saturday, November 16, 2019 (before Class)
Class 5: Saturday, November 16, 2019
  • Quiz 4(closed book)
  • Analyzing Temporal Data
  • Customer Survivor Analysis
  • Data Mining Models
Grading:
Best 3 out of 4 Quizzes
Best 3 out of 4 Homework assignments
Weighting of Grades:
Quizzes: 50%
Homework 25%
Take-Home Final 25%