postgres-intro

Question 1

What is PostgreSQL and what are some alternative relational databases?

Answer 1

a RDBMS (relational database management system) MySQL, Oracle, SQLite, Microsoft SQL server

Question 2

What are some advantages of learning a relational database?

Answer 2

data accuracy, easy to access, data integrity

Question 3

What is one way to see if PostgreSQL is running?

Answer 3

sudo service postgresql status

Question 4

What is a database schema?

Answer 4

a collection of tables that defines how the data in a relational database should be organized.

Question 5

What is a table?

Answer 5

A table is a list of rows each having the same set of attributes.

Question 6

What is a row?

Answer 6

the data in the table