Job Ready SQL

Index

SYMBOLS AND NUMERICS

• “ “, conditional statement, 110
• ‘‘, conditional statement, 155
• — script comment, 155, 203
• [ and ], optional clause, 176–177
• * (asterisk) shortcut
  • in COUNT, 273
  • select all shortcut, 201–202, 213

• % (percent), character matching, 208
• ( _ ) underscore, single character matching, 208
• [ ] square brackets, optional clause, 177
• 1NF. See first normal form (1NF)
• 2NF. See sec ond normal form (2NF)
• 3NF. See third normal form (3NF)

A

• abort, 328–329
• accessing data, 5–6
• ACID database
  • compliance, 9–10, 336
  • properties, 10–12
  • unexpected failures and data corruption, 10

• adding data
  • with column names, 177–178
  • multiple rows, 297–298
  • without columns identified, 177

• aggregate functions
  • counting with, 272–273
  • filtering in queries, 283

• aggregate values, 271
• aliases
  • self‐join, 243
  • uses for, 245–247

• aliasing, 239
• ALTER TABLE statement, 135–137, 163
• “An Overview of MySQL Database Indexing” (severalnines.com)
  • Ksiazek, Krzysztof, 336

• anomaly
  • delete anomaly, 21
  • update anomaly, 21

• applications, database storage for, 5
• applications, database use, 5–6
• applying CRUD, 171
• AS keyword, 211, 213–214, 238–239, 326
• ASC keyword, 255
• asterisk (*) shortcut
  • in COUNT, 273
  • select all shortcut, 201–202, 213

• atomicity
  • all‐or‐nothing rule, 10
  • of transaction, 329

• attributes
  • column definitions, 9
  • defined, 16
  • as fields, 59
  • order in index creation, 334
  • split across tables, 114

• audit. See transaction log
• audit trail. See transaction log
• auto‐incremented ...