Font size
WorksheetsFinTech 07-1 SQL
Total questions: 10
Worksheet time: 5mins
What were the objectives for SQL day 1?
Install PostgreSQL and pgAdmin.
Combine data from multiple tables using joins
Load CSV files into a database
Run queries in python
Define SQL data types, primary keys, and unique values
What acronym represents the four basic functions of persistent data storage?
CRUD
SQL
ACID
SaaS
Which steps did we take in pgAdmin?
Create new database
Query a table
Create new table
Export a table
Delete a table
Which are valid SQL commands?
SELECT
WHERE
FROM
REMOVE
UPDATE
What is the character that means all after SELECT in SQL?
(a)
Which are valid data types in SQL?
VARCHAR()
INT
CHAR()
STR()
FLOAT
Which are valid joins in SQL?
CROSS JOIN
FULL INNER JOIN
FULL OUTER JOIN
LEFT JOIN
Analogy - PRIMARY KEY : SQL table :: ______ : pandas dataframe
Header
Index
Column
Row
How was SQL day 1 for you?
Any suggestions for improvement?
