Data Mining Module 3: Structured Query Language

Lecture 3.1 Intro to SQL

Lecture 3.2 Filter Data in SQL

Lecture 3.3 Join Tables in SQL

Lecture 3.4 Group Data in SQL

Lecture 3.5 Modify Data in SQL

Lecture 3.6 Create Index and View in SQL

Lab 3: Query and Modify Data with SQL

Objectives:

  • Use SQL to query and modify data in a relational database

Data:

  • The tables created from lab2