1 of 32

CS50 for MBAs

SQL

2 of 32

database

3 of 32

data mart

4 of 32

data warehouse

5 of 32

data lake

6 of 32

data

7 of 32

spreadsheet

8 of 32

9 of 32

10 of 32

cs50.ly/youtunes

11 of 32

raw data

12 of 32

cs50.ly/favorites

13 of 32

14 of 32

flat-file databases

15 of 32

CSV

16 of 32

relational databases

17 of 32

C

R

U

D

​

18 of 32

CREATE

READ

UPDATE

DELETE

​

19 of 32

SQL

20 of 32

CREATE

READ

UPDATE

DELETE

​

21 of 32

CREATE, INSERT

SELECT

UPDATE

DELETE

...

22 of 32

SQLite

23 of 32

DB Browser for SQLite

sqlitebrowser.org

24 of 32

SELECT columns FROM table WHERE condition;

25 of 32

AVG

COUNT

DISTINCT

MAX

MIN

...

26 of 32

WHERE

LIKE

LIMIT

GROUP BY

ORDER BY

JOIN

...

27 of 32

UPDATE table SET column=value WHERE condition;

28 of 32

DELETE FROM table WHERE condition;

29 of 32

INSERT INTO table (column, ...) VALUES(value, ...);

30 of 32

Assignment 7

31 of 32

Office Hours

32 of 32

CS50 for MBAs

SQL