postgreSQL Flashcards

1
Q

What is PostgreSQL and what are some alternative relational databases?

A

PostgreSQL is a relational database management system. Alternatives: MySQL, SQL Server, and Oracle

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

Having applications quickly retrieve or store complex data in an organized fashion. Data corruption is unlikely.

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
4
Q

What is a database schema?

A

A collection of tables

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

What is a table?

A

Collection of data items

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

What is a row?

A

A data item

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

What is SQL and how is it different from languages like JavaScript?

A

It’s the primary way of interacting with relational databases. SQL is a declarative language which means the programmer describes the results they want and the programming environment gets them.

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

How do you retrieve specific columns from a database table?

A

SELECT

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

How do you filter rows based on some specific criteria?

A

where

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

What are the benefits of formatting your SQL?

A

Consistent style and readability

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

What are four comparison operators that can be used in a where clause?

A

= != < >

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

How do you limit the number of rows returned in a result set?

A

LIMIT

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

How do you retrieve all columns from a database table?

A

*

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

How do you control the sort order of a result set?

A

order by desc/asc

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

How do you add a row to a SQL table?

A

INSERT

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

What is a tuple?

A

(A list of values)

17
Q

How do you add multiple rows to a SQL table at once?

A

tuples separated by commas

18
Q

How do you get back the row being inserted into a table without a separate select statement?

A

returning *;

19
Q

How do you update rows in a database table?

A

UPDATE

20
Q

Why is it important to include a where clause in your update statements?

A

To select what to update/delete

21
Q

How do you delete rows from a database table?

A

DELETE

22
Q

How do you accidentally delete all rows from a table?

A

By not using where

23
Q

What is a foreign key?

A

Key that references another table

24
Q

How do you join two SQL tables?

A

join or inner join

25
Q

How do you temporarily rename columns or tables in a SQL statement?

A

something as somethingElse