postgres Flashcards
1
Q
What is PostgreSQL and what are some alternative relational databases?
A
relational database management system
MySQL, SQL Server (Microsoft), Oracle (Oracle)
2
Q
What are some advantages of learning a relational database?
A
very commonly used by developers, to better understand how they function and how we interact with them
3
Q
What is one way to see if PostgreSQL is running?
A
sudo service postgresql status, use top to see current processes, try something to see if you get an error
4
Q
What is a database schema?
A
framework of the structure for the database
5
Q
What is a table?
A
a list of rows, each with the same attributes
6
Q
What is a row?
A
an entry in a table
