Head First SQL: Your Brain on SQL -- A Learner's GuideIs your data dragging you down? Are your tables all tangled up? Well we've got the tools to teach you just how to wrangle your databases into submission. Using the latest research in neurobiology, cognitive science, and learning theory to craft a multi-sensory SQL learning experience, Head First SQL has a visually rich format designed for the way your brain works, not a text-heavy approach that puts you to sleep. |
Contents
1 | |
To add data to your table youll use the INSERT statement | 34 |
data | 53 |
3 | 119 |
Why be normal? | 159 |
Atomic data | 168 |
Reasons to be normal | 174 |
Getting to NORMAL | 181 |
Outer joins and multiple matches | 425 |
How the new table fits in | 431 |
You can use a UNION | 437 |
Were done with joins time to move on to | 443 |
table of contents | 455 |
CHECKing the gender | 461 |
What your view is actually doing | 467 |
column1 column2 column3 | 468 |
Adding a PRIMARY KEY to an existing table | 192 |
ALTER | 197 |
advanced SELECT | 235 |
Sometimes your single table isnt big enough anymore | 281 |
interestsint_id interests Third normal form at last | 336 |
joins and multitable operations | 343 |
table of contents | 379 |
Subqueries | 386 |
A subquery construction walkthrough | 394 |
Choosing the best way to query | 400 |
Correlated subqueries | 408 |
New maneuvers | 417 |
View with CHECK OPTION | 475 |
What should have happened inside the ATM | 485 |
security | 493 |
Decide exactly what the user needs | 499 |
REVOKING a used GRANT OPTION | 505 |
Using your role | 512 |
Combining CREATE USER and GRANT | 519 |
table of contents | 525 |
mySQL installation | 543 |
All your new SQL tools | 551 |
559 | |