Head First SQL

by Beighley, Lynn

• ISBN13: 9780596526849
• ISBN10: 0596526849
• Format: Paperback
• Copyright: 2007-08-01
• Publisher: Oreilly & Associates Inc

Summary

Is 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.

Author Biography

Lynn Beighley is a fiction writer stuck in a technical book writer's body. Upon discovering that technical book writing actually paid real money, she learned to accept and enjoy it.

After going back to school to get a Masters in Computer Science, she worked for the acronyms NRL and LANL. Then she discovered Flash, and wrote her first bestseller.

A victim of bad timing, she moved to Silicon Valley just before the great crash. She spent several years working for Yahoo! and writing other books and training courses. Finally giving in to her creative writing bent, she moved to the New York area to get an MFA in Creative Writing.

Her Head First-style thesis was delivered to a packed room of professors and fellow students. It was extremely well received, and she finished her degree, finished Head First SQL, and can't wait to begin her next book.

Lynn loves traveling, cooking, and making up elaborate background stories about complete strangers. She's a little scared of clowns.

Table of Contents

Data and tables : a place for everything	p. 1
The SELECT statement : gifted data retrieval	p. 53
DELETE and UPDATE : a change will do you good	p. 119
Smart table design : why be normal?	p. 159
ALTER : rewriting the past	p. 197
Advanced SELECT : seeing your data with new eyes	p. 235
Multi-table database design : outgrowing your table	p. 281
Joins and multi-table operations : can't we all just get along?	p. 343
Subqueries : queries within queries	p. 379
Outer joins, self joins, and unions : new maneuvers	p. 417
Constrains, views, and transactions : too many cooks spoil the database	p. 455
Security : protecting your assets	p. 493
Table of Contents provided by Blackwell. All Rights Reserved.