Difference between revisions of "A Quick Relational Database Tour"

From LMU BioDB 2017
Jump to: navigation, search
(Start writing up quick relational tour.)
(No difference)

Revision as of 04:50, 26 September 2017

This page gives you a tutorial-style walkthrough of a relational database, specifically PostgreSQL. The walkthrough assumes that you are at a Seaver 120 lab computer.

But first, a little leadoff cartoon: http://xkcd.com/327

Running PostgreSQL on the Lab Machines

  1. Login to the computer as usual
  2. Launch pgAdmin III
  3. The pgAdmin III window starts with a hierarchical view on the left that starts with three layers:
    • Server Groups
      • Servers (1)
        • PostgreSQL 9.6 (localhost:5432)
  4. Double-click on PostgreSQL 9.6 (localhost:5432) to connect to the database server
  5. The password to start the server will be given in class