Data Mining Module 1: Introduction

Lecture 1.1 Intro to Data Mining

Lecture 1.2 Intro to Relational Database

Lecture 1.3 Intro to PostgreSQL and Index

Lecture 1.4 Primary Key and Foreign Key

Lab 1: Create an RDS Instance on AWS Academy

Objectives:

  • To learn how to create a PostgreSQL database instance on AWS

Data:

  • None

Lab1 (Optional): Create Tables in PostgreSQL

Objectives:

  • To learn to create/edit tables in PostgreSQL

  • Get familiar with the basic constraints in PostgreSQL

Data: