ATARMAxxing · QCE Digital Solutions revision notes
SQL for data exchange solutions: CREATE, ALTER, INSERT, UPDATE, SELECT, GROUP BY, HAVING, sub-selections and inner joins
SQL
What this note covers
- SQL scope and the sample tables
- Defining and changing structure: CREATE, ALTER, DROP
- Adding and changing rows: INSERT and UPDATE
- Querying: SELECT, WHERE and ORDER BY
- Grouping: GROUP BY and HAVING
- Joining and nesting: INNER JOIN and sub-selections
6 sections · 11 key terms & formulas · 6 common mistakes
Included in the QCE Digital Solutions Mastery Pack
20 full-length practice exams with worked solutions, 20 revision notes, 64 practice questions and 200 flashcards.
Unlock Digital Solutions — $20
Preview a sample note and question free on the QCE Digital Solutions hub →