SQL Flashcards

1
Q

What is PostgreSQL and what are some alternative relational databases?

A

It is a relation database management system . other relational databases include MySQL, SQL Server by Microsoft, 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

portable skill, and used everywhere

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

top command,

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

in terms of relational databases, a table is known as a relation which stores data in rows and attributes(columns)

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

What is a row?

A

a row is an instance of a record in that table, that has a set of attributes

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

Structured Query Language: it is declarative vs imperative like JavaScript.

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 “columnName”

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 “column” (=,, !=) ‘criteria’

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

readabililty

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 clause

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

select *

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 “criteria” (desc)

- ascending by default

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 into “table” (‘column’(s))

values (‘value’(s))

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

groups in parenthesis separated by commas

18
Q

How to 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 “table”
set “column” = ‘value’
where “value” = ‘value’

20
Q

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

A

without where, it would update all values in that column

21
Q

How do you delete rows from a database table?

A

delete from “tableName”

where “column” = ‘value’

22
Q

How do you accidentally delete all rows from a table?

A

delete from “tableName”

without specifying where

23
Q

What is a foreign key?

A

a column that links the values from one table to another

24
Q

How do you join two SQL tables?

A

join keyword
select *
from “table”
join “table2” using (“foreignKey”);

25
Q

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

A

(for columns) : select “table”.”column” as “name”

(for tables) : from “table” as “name”

26
Q

What are some examples of aggregate functions?

A

count(), sum(), avg()

27
Q

What is the purpose of a group by clause?

A

used to separate different rows into groups