Postgres Flashcards
What is PostgreSQL and what are some alternative relational databases?
PostgreSQL is an open source Relational Database Management System.
MySQL
Oracle by Oracle Corporation
Microsoft SQL Server
What are some advantages of learning a relational database?
They’re the most widely used type of database.
They support good guarantees about data integrity.
They can store and modify data in a way that makes corruption as unlikely as possible.
What is one way to see if PostgreSQL is running?
top
sudo service postgresql status
What is a database schema?
A schema defines how the data in a relational database should be organized.
What is a table?
A table is a list of rows each having the same set of attributes.
What is a row?
A single instance of a record within a table.
