
Head First SQL
Your Brain on SQL -- A Learner's Guide
Lynn Beighley(Author)
O'Reilly (Publisher)
1st Edition
Published on 2. October 2007
Book
607 pages
978-0-596-52684-9 (ISBN)
Article exhausted; check for reprint
Description
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.
Maybe you've written some simple SQL queries to interact with databases. But now you want more, you want to really dig into those databases and work with your data. Head First SQL will show you the fundamentals of SQL and how to really take advantage of it. We'll take you on a journey through the language, from basic INSERT statements and SELECT queries to hardcore database manipulation with indices, joins, and transactions. We all know "Data is Power" - but we'll show you how to have "Power over your Data". Expect to have fun, expect to learn, and expect to be querying, normalizing, and joining your data like a pro by the time you're finished reading!
More details
Language
English
Place of publication
Sebastopol
United States
Target group
Professional and scholarly
Product notice
Unsewn / adhesive bound
Dimensions
Height: 235 mm
Width: 205 mm
Thickness: 35 mm
Weight
1118 gr
ISBN-13
978-0-596-52684-9 (9780596526849)
Schweitzer Classification
Other editions
New editions

Book
approx. 06/2026
2nd Edition
O'Reilly
€69.50
Not yet published
Additional editions

E-Book
08/2007
1st Edition
O'Reilly
€44.99
Available for download

E-Book
08/2007
O'Reilly
€42.49
Available for download
Person
Lynn Beighley is a freelance web programmer and designer who began working on her Masters in Computer Science while working at the Naval Research Laboratory. On the side, she created and ran a number of web sites for fun, which led to her to open a company and write a series of Flash, Dreamweaver, and Photoshop books and training CDs. She's worked at Los Alamos National Labs, Palm and Yahoo! Inc. While at Yahoo! she worked on dynamic Flash advertisements on the front page.
Content
- Advance Praise for Head First SQL
- Praise for other Head First books
- Praise for the Head First Approach
- Author of Head First SQL
- How to use this Book: Intro
- Chapter 1: Data and Tables: A place for everything
- Chapter 2: The SELECT Statement: Gifted data retrieval
- Chapter 3: DELETE and UPDATE: A change will do you good
- Chapter 4: Smart Table Design: Why be normal?
- Chapter 5: Alter: Rewriting the Past
- Chapter 6: Advanced Select: Seeing your data with new eyes
- Chapter 7: Multi-Table Database Design: Outgrowing your table
- Chapter 8: Joins and Multi-Table Operations: Can't we all just get along?
- Chapter 9: Subqueries: Queries within queries
- Chapter 10: Outer Joins, Self-Joins, and Unions: New maneuvers
- Chapter 11: Constraints, Views, and Transactions: Too many cooks spoil the database
- Chapter 12: Security: Protecting your assets
- Leftovers: The Top Ten Topics (we didn't cover)
- MySQL Installation: Try it out for yourself
- Tools Roundup: All your new SQL tools