postgres intro and database Flashcards
What is PostgreSQL and what are some alternative relational databases?
PostgreSQL is an open source object-relational database management system
Oracle DB, SQLite, DynamoDB, ACID, SQL
What are some advantages of learning a relational database?
Relational databases are widely used and are deployed in a high number of devices and applications.
Web developers work with a relational database at least a little bit during their career
What is the one way to see if PostgreSQL is running?
The command - sudo service postgresql status
You can send it a command and see if it fails
The command - top
What is a database schema?
A collection of tables.
It 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
Also known as relation
What is a row?
A row contains relational data with attributes, referred to as columns
A single structure data item in a table
