postgres-intro

Question 1

What is postgreSQL and what are some alternative relational databases?

Answer 1

An open source and free relational database. Uses SQL as the querying language. Alternatives include: MySQL (also free), SQL server by microsoft, and oracle by oracle corp.

Question 2

What are some advantages of learning a relational database?

Answer 2

Good for storing related data. Support good guarantees about data integrity. Makes corruption of data least likely. Relational databases are very flexible and forgiving.

Question 3

What is one way to see if PostgreSQL is running?

Answer 3

‘top’ command in your dev-env or use ‘sudo service postgresql status’ ‘sudo’ means super user do