PostgresQL intro and Database

Question 1

What is PostgreSQL and what are some alternative relational databases?

Answer 1

PostgreSQL is a powerful, free, open sourceRelational DatabaseManagement System (RDBMS).

Other popular relational databases include 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

Relational databases are arguably the most widely used kind of database. Many times when developers create a full stack developer, they are using a relational database.

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 oftablesis called aschema. Aschemadefines how the data in a relational database should be organized.

Question 5

What is a table?

Answer 5

A table is data that is in a list of rows where rows each have the same set of attributes.

Question 6

What is a row?

Answer 6

A single instance of record in that table

Question 7

What is RDBMS?

Answer 7

A relational database management system (RDBMSor just RDB) is a common type of database whose data is stored in tables