Skip to content

Instantly share code, notes, and snippets.

@rogerwschmidt

rogerwschmidt/IntroToPostgres.md

Last active July 24, 2017 20:35
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save rogerwschmidt/1f3bd7c513d56413fcfbd4a5b5560dbe to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save rogerwschmidt/1f3bd7c513d56413fcfbd4a5b5560dbe to your computer and use it in GitHub Desktop.
Download ZIP
Raw
IntroToPostgres.md

Introduction to Postgres Instructor Notes

Objectives

  • Explain the difference between data and information.
  • Explain what an entity is.
  • Diagram how a server-side web applications manage information.
  • Explain what a relational database system is.
  • Explain why a relational database system so useful.
  • Explain what SQL is.
  • Explain what PostgreSQL is.
  • Install PostgreSQL.
  • Start PostgreSQL.
  • Use the PostgreSQL command line tools to manage databases in a PostgreSQL cluster.
  • Use the PostgreSQL REPL to manage databases in a PostgreSQL cluster.

What is the difference between data and information?

Turn to your neighbor and explain what the difference between data and information is. Be prepared to share your answer.

What is an entity?

Write down what and entity is. Be prepared to share your answer.

How does a server-side web application manage informaton?

On your desks, diagram how a server-side web application manages information.

What is a relational database system?

Turn to your neighbor and explain what a relational database is. Be prepared to share your answer.

Why are relational database systems useful?

Turn to your neighbor and explain why relational databases systems are so useful. Be prepared to share your answer.

What is SQL?

Turn to your neighbor and explain what SQL is

What is PostgreSQL?

Turn to your neighbor and explain what PsorgreSQL is

Install PostgreSQL.

Do you have PostgresSQL installed?

Start PostgreSQL.

How do you use brew services to start|stop|restart PostgreSQL?

Use the PostgreSQL command line tools to manage databases in a PostgreSQL cluster.

  • What is the command to create a database using the command line?
  • What is the command to drop a database using the command line?

Use the PostgreSQL REPL to manage databases in a PostgreSQL cluster.

  • How do you connect to a database using psql?
  • How do you list all databases?
  • How you create a database using the Postgres RELP
  • How you connect to a database using the Postgres RELP
  • How you drop a database using the Postgres RELP
  • How do you quit the Postgres RELP
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment