PostgreSQL and pgAdmin
Learning Objectives
- Create a relational database using pgAdmin
- Execute an SQL query using pgAdmin
How to Complete this Lesson
Complete the following learning activities: (2.5–3 hours total)
-
Install the PostgreSQL and pgAdmin using the instructions to create a virtual machine (VM) and install software in that VM (30–60 minutes)
Complete this activity prior to class! Class time should not be used to install software although it can be used to troubleshoot installation issues.
- Complete the PostgreSQL tutorial (in class) (60 minutes)
- Work on the ER diagram for the project
(60 minutes)
- Use a modeling tool to create a professional version of the ER diagram