SQL

Question 1

What is PostgreSQL and what are some alternative relational databases?

Answer 1

• An open source Relational Database Management System

- My sql, oracle, sql server by microsoft

Question 2

What are some advantages of learning a relational database?

Answer 2

• Data corruption is less likely
• Most widely used type of database
• Problem domains can be modeled well
• Good for storing related data

Question 3

What is one way to see if PostgreSQL is running?

Answer 3

• sudo service postgresql status

- top command

Question 4

What is a database schema?

Answer 4

a collection of tables within an sql database that determines how data should be organized