PostgreSQL

Question 1

What is PostgreSQL and what are some alternative relational databases?

Answer 1

PostgreSQL is a powerful, free, open source Relational Database Management System (RDBMS).
MySQL (also free), SQL Server by Microsoft, and Oracle by Oracle Corporation.

Question 2

What are some advantages of learning a relational database?

Answer 2

they support good guarantees about data integrity. They can store and modify data in a way that makes data corruption as unlikely as possible. This means that developers can set up their database to reject “bad” data and not worry about data being “half written”.
Easy to access the data and hard to corrupt.

Question 3

What is one way to see if PostgreSQL is running?

Answer 3

sudo service postgresql status

Question 4

What is a database schema?

Answer 4

A collection of tables is called a schema. A schema defines how the data in a relational database should be organized

Question 5

What is a table?

Answer 5

a list of rows each having the same set of attributes

Question 6

What is a row?

Answer 6

Collection of related data