postgres-intro Flashcards
What is PostgreSQL and what are some alternative relational databases?
PostgreSQL is an open-source relational database management system that is used to manage and store data in a structured manner. Alternatives to PostgreSQL include: MySQL, MariaDB, Microsoft SQL Server, Oracle Database, and Amazon Relational Database Service (RDS).
What are some advantages of learning a relational database?
Scalability: Relational databases can easily handle large amounts of data and can be easily scaled to meet growing demands.
Data Integrity: Relational databases enforce rules and constraints on data, helping to maintain the accuracy and integrity of stored data.
Query Ability: Relational databases use a declarative query language (SQL) which allows for powerful querying and analysis of stored data.
Flexibility: Relational databases allow for the creation of complex relationships between data, making them well-suited for a variety of use cases.
Wide Adoption: Relational databases are widely used in industry and are a critical component of many businesses, making them a valuable technology to learn for job market.
What is one way to see if PostgreSQL is running?
service postgresql status or systemctl status postgresql
