PostgresSQL

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). It is often cited as the most advanced open source database of its kind and is well-liked by the developer community for its robust feature set, standards compliance, and reliability.
mySQL, SQLite

Question 2

What are some advantages of learning a relational database?

Answer 2

• If you are storing related data, then a relational database is probably a good first choice.
• A quality of many relational databases is that they support good guarantees about data integrity.
• Relational databases are arguably the most widely used kind of database. And knowing the SQL language is a very portable skill given that there are so many relational databases driven by almost the same language.

Question 3

What is one way to see if PostgreSQL is running?

Answer 3

Run “sudo service postgresql status” in the terminal

Question 4

What is the difference between pgweb and postgresql?

Answer 4

pgweb is the GUI version of postgres.

Question 5

What is a database schema?

Answer 5

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

Defines the structure of the database.

Question 6

What is a table?

Answer 6

Relational databases store data in relations, commonly referred to as tables. A table is a list of rows each having the same set of attributes. For example, all students in a “students” table could have “firstName”, “lastName”, and “dateOfBirth” attributes. Attributes are commonly referred to as columns.

Question 7

What is a row?

Answer 7

A set of attributes within a table.
For example, all students in a “students” table could have “firstName”, “lastName”, and “dateOfBirth” attributes.

Each row in a table is a single record of data