Database Tutorial


Connecting to Server

  • Use openssh client (Start → All Programs → OpenSSH)

  • Enter your group passwd when prompted

Connecting to Database

  • username = group1/group2
  • database_name = group1/group2
  • Enter your group passwd when prompted

Postgres Commands

SQL Cheat Sheet

  • List all accessible databases

  • List all the tables in current DB

  • Quit

SQL Commands

  • Create Table

  • Insert a row

  • Update table contents

  • List contents of table

  • Delete Rows