Head First SQL: Your Brain on SQL -- A Learner's Guide

( 7 )

Overview

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

See more details below
Paperback
$35.31
BN.com price
(Save 29%)$49.99 List Price

Pick Up In Store

Reserve and pick up in 60 minutes at your local store

Other sellers (Paperback)
  • All (22) from $13.40   
  • New (11) from $25.73   
  • Used (11) from $13.40   
Head First SQL: Your Brain on SQL -- A Learner's Guide

Available on NOOK devices and apps  
  • NOOK Devices
  • Samsung Galaxy Tab 4 NOOK 7.0
  • Samsung Galaxy Tab 4 NOOK 10.1
  • NOOK HD Tablet
  • NOOK HD+ Tablet
  • NOOK eReaders
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac
  • NOOK for Web

Want a NOOK? Explore Now

NOOK Book (eBook)
$24.99
BN.com price
(Save 41%)$42.99 List Price

Overview

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!

Read More Show Less

Product Details

  • ISBN-13: 9780596526849
  • Publisher: O'Reilly Media, Incorporated
  • Publication date: 8/15/2007
  • Series: Head First Series
  • Edition number: 1
  • Pages: 610
  • Sales rank: 280,523
  • Product dimensions: 8.08 (w) x 9.32 (h) x 1.23 (d)

Meet the Author

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.

Read More Show Less

Table of Contents

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

Read More Show Less

Customer Reviews

Average Rating 4.5
( 7 )
Rating Distribution

5 Star

(6)

4 Star

(0)

3 Star

(0)

2 Star

(1)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing all of 7 Customer Reviews
  • Posted February 21, 2010

    more from this reviewer

    Approachable SQL training

    I was looking for a good exposure to SQL programming and it's uses as most Marketing Jobs now ask if you know anything about SQL.

    What surprised me was the layout of this book and the very friendly layout. I can easily see this book as the standard text for a high school, or college intro to SQL course!

    I have already bought the PHP & MySQL book from Head First and will probably keep adding other volumes to my reference desk.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted November 10, 2007

    Jan Brady, smallmouth bass and Mr. Hobo ?

    I like developing programs, making computers do cool things: Especially things that humans find boring, repetitive or difficult to accomplish without error. However, I have never quite found the time to really delve into SQL. Why should I? SQL is boring. Right? You cannot make it say 'Hello World.' I knew how to write your basic SELECT statement after all: Using SELECT in ADO code is pretty much all you need. Right? Turns out that learning SQL can be made engaging. And fun'?'. I mean, a database including Jan Brady, smallmouth bass and Mr. Hobo the clown can only be... thought provoking, to say the least! Yet, by the end of 'Head First SQL,' you have a very solid understanding of the language, and realize how powerful SQL actually is. This book also teaches relational database theory, in a thorough, but very interesting way. You begin making tables haphazardly, and then use these incorrect tables to learn advanced SELECT techniques, such as using SUBSTRING commands to fill new, normalized tables. As I contemplate returning to school to either pursue a Masters in Computer Science or merely get a few MS certifications, the Head First books seem to be great introductions to unfamiliar or half-remembered territory. The Head First approach is unique, visual, interactive, very goofy 'think 'Electric Company' for adults', and ultimately very effective. Unlike the infamous Dummies books, these books use shenanigans to actually teach you the underlying concepts in a very memorable way. This book is a solid investment for anyone wanting to learn 'and actually understand' SQL and databases in general.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted September 17, 2007

    SQL made fun and CLEAR

    I've tried to learn SQL many times, but other books are so dry that I catch myself falling asleep. This one is actually interesting! It's got tons of graphics that actually help you see what's going on, instead of page after page of text like the others have. A picture really is worth a thousand boring words. More than worth them. One of the best things about the book is it gets into the WHY you should design your tables a certain way. I'd heard of Normal form before, but now I actually understand it. Great book. If you need to learn SQL, buy it. It's worth it. Although if you need a reference, buy something else.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted December 12, 2008

    No text was provided for this review.

  • Anonymous

    Posted October 16, 2008

    No text was provided for this review.

  • Anonymous

    Posted May 11, 2009

    No text was provided for this review.

  • Anonymous

    Posted November 16, 2008

    No text was provided for this review.

Sort by: Showing all of 7 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)