postgres Flashcards
1
Q
What is PostgreSQL and what are some alternative relational databases?
A
PostgreSQL is a relational database management system. Open source database. altervatives: MySQL, SQL Server by Microsoft, Oracle
2
Q
What are some advantages of learning a relational database?
A
Guarantees data integrity.
This means that developers can set up their database to reject “bad” data and not worry about data being “half written”.
widely used and very powerful
3
Q
What is one way to see if PostgreSQL is running?
A
command line
sudo service postgresql status
4
Q
What is a database schema?
A
A collection of tables
5
Q
What is a table?
A
6
Q
What is a row?
A
A composite type represents the structure of a row or record; it is essentially just a list of field names and their data types.
