#### In-Class Exercise #1: Identifying entities and attributes

#### In-Class Exercise #2: ER modeling

#### In-Class Exercise #3: Creating schemas

**In-Class Exercise #4: Pen and paper query exercise**

#### In-Class Exercise #5: Working with SQL, part 1 (SQL Out)

(exercise | solution | movie rental schema)

#### In-Class Exercise #6: Working with SQL, part 2 (SQL In)

#### In-Class Exercise #7: ETL using Tableau Prep

(exercise – solution on last page)

#### In-Class Exercise #8: Working with semi-structured data

#### In-Class Exercise #9: Descriptive statistics review

#### In-Class Exercise #10: Getting familiar with R/RStudio

(exercise | TestScript.r | Descriptives.r | NBA14Salaries.csv | USBalanceOfTrade.xlsx)

**In-Class Exercise #11: Chi-squared statistics**

**In-Class Exercise #12: Decision trees in R**

(exercise | dTree.r | OrganicsPurchase.csv)

**In-Class Exercise #13: Clustering in R**

(exercise | Clustering.R | Census2000.csv)

**In-Class Exercise #14: Computing confidence, support, and lift**

**In-Class Exercise #15: Association rule mining in R**

(exercise | aRules.r | Bank.csv)

**In-Class Exercise #16: Data Visualization using Tableau**

(exercise | EditedNYCParkingData.csv)