Postgres

Question 1

What is PostgreSQL and what are some alternative relational databases?

Answer 1

powerful, free, open source Relational Database Management System , MySQL, SQL Server, Oracle

Question 2

What are some advantages of learning a relational database?

Answer 2

data integrity, storing related data,web developers work with a relational database at least a little bit during their career.

Question 3

What is one way to see if PostgreSQL is running?

Answer 3

sudo service postgresql status , top

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

(relations) stored data that is related to each other, list of rows each having the same set of attributes. Attributes are commonly referred to as columns

Question 6

What is a row?

Answer 6

a single structured data item in a table, represents a set of related data