PostgresQL Flashcards
1
Q
What is one way to see if PostgreSQL is running?
A
sudo service postgresql status
2
Q
What are some advantages of learning a relational database?
A
many things are related to one another so it makes sense to have connected data in your database
3
Q
What is PostgreSQL and what are some alternative relational databases?
A
it is a relational database that puts data in a spreadsheet essentially;
some alternatives are mongodb, redis, neo4j
4
Q
What is a row?
A
a record in the spreadsheet
5
Q
What is a table?
A
a list of rows having the same set of attributes
6
Q
What is a database schema?
A
a collection of tables
