IDS CH5

What is SQL?

Language to give DB commands (like Minecraft commands)

Languages for DB?

C++, Java, PHP, Python, R

C++ vs Java?

C++ = fast, Java = easier, safer

PHP role?

Web server talks to DB, makes HTML

SQL history?

Made in 1970s, standard by 1986

SQL syntax?

Order matters, strict rules

4 SQL language groups?

DDL = define tables, DML = change data, DQL = read data, DCL = control users

DDL?

CREATE, ALTER, DROP tables

DDL use in DBs?

Relational = fixed, NoSQL = flexible

DML?

INSERT, UPDATE, DELETE data

WHERE clause?

Filters rows for action

DQL?

SELECT FROM WHERE (read data)

SELECT query?

Pick columns + rows to see

Wildcards + LIKE?

• = all, LIKE = pattern search

DCL?

GRANT, REVOKE, DENY user rights