IDS CH5

0.0(0)
studied byStudied by 0 people
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
Card Sorting

1/14

encourage image

There's no tags or description

Looks like no tags are added yet.

Study Analytics
Name
Mastery
Learn
Test
Matching
Spaced

No study sessions yet.

15 Terms

1
New cards

What is SQL?

Language to give DB commands (like Minecraft commands)

2
New cards

Languages for DB?

C++, Java, PHP, Python, R

3
New cards

C++ vs Java?

C++ = fast, Java = easier, safer

4
New cards

PHP role?

Web server talks to DB, makes HTML

5
New cards

SQL history?

Made in 1970s, standard by 1986

6
New cards

SQL syntax?

Order matters, strict rules

7
New cards

4 SQL language groups?

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

8
New cards

DDL?

CREATE, ALTER, DROP tables

9
New cards

DDL use in DBs?

Relational = fixed, NoSQL = flexible

10
New cards

DML?

INSERT, UPDATE, DELETE data

11
New cards

WHERE clause?

Filters rows for action

12
New cards

DQL?

SELECT FROM WHERE (read data)

13
New cards

SELECT query?

Pick columns + rows to see

14
New cards

Wildcards + LIKE?

  • = all, LIKE = pattern search
15
New cards

DCL?

GRANT, REVOKE, DENY user rights