top of page
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:
-
Find the IA instructors’ information from the JMU SIS website (https://www.jmu.edu/ia/people/index.shtml ) and IA Fall semester course information from MyMadison (https://mymadison.ps.jmu.edu ).
bottom of page