postgres-intro Flashcards

1
Q

What is PostgreSQL and what are some alternative relational databases?

A

PostgreSQL is a powerful, open source object-relational database management system that uses and extends the SQL language combined with many features that safely store and scale the most complicated data workloads.
PostgreSQL is used as the primary data store or data warehouse for many web, mobile, geospatial, and analytics applications.

Oracle Database
MySQL
Microsoft SQL Server

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What are some advantages of learning a relational database?

A

. They can store and modify data in a way that makes data corruption as unlikely as possible. Relational databases are arguably the most widely used kind of database. If you are storing related data, then a relational database is probably a good first choice!

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What is one way to see if PostgreSQL is running?

A

sudo service postgresql status

How well did you know this?
1
Not at all
2
3
4
5
Perfectly