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

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

Head First SQL: Your Brain on SQL -- A Learner's Guide
List Price: $44.99
Our Price: $24.98
You Save: $20.01 (44%)
Availability: Usually ships in 1-2 business days
Buy Used: from $19.06 (click here)
Category: Book
See more book details and other editions


or

Book Summary Information

Author: Lynn Beighley
Edition: Paperback
Audio: English (Unknown); English (Original Language); English (Published)
Published: 2007-09-01
ISBN: 0596526849
Number of pages: 608
Publisher: O'Reilly Media

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

Book Review: Head First SQL in the Classroom
Summary: 5 Stars

Before I talk about Head First SQL, let me tell you about other database books I have used in the classroom. I teach an enterprise databases sequence (DBs I and II) at a tribal college in Montana. On the course evaluations for this sequence, students have a common complaint: "Liked the class. Hated the book.", "The book was painful to read.", "Please get a different book!"

Each year my colleagues and I are on the watch for a better, more engaging database book. We have tried three books over the past five years, but the difference between those books is like the difference between shades of grey. In the classroom, most of my time is spent mediating the daunting abstractness of those books or breaking down huge lumps of difficult technical material written in plodding and pedantic prose. This year a spot of color showed up: Head First SQL!

I discovered Head First SQL too late to use it as the primary text for my Fall quarter DBs class, but I liked it so much, I added it as an optional textbook for the quarter and told my students it would be the main textbook for the Winter quarter. I did so because the energy of the class was waning rapidly, and the book I had originally chosen was not helping. I needed to add some excitement to homework and lectures. Within two days of using Head First SQL, the classroom became a far more engaging environment.

I compiled this list for anyone interested in learning databases and SQL, especially anyone who teaches it.

Eleven Things I like about Head First SQL:

1. The book starts where my students start. The first questions my students have are questions of relevance: Why do I want to know this? What have I done before that's like this? What will this material add to my career and my life? Head First SQL starts by ushering the student through those questions: What is a database? Who cares about databases? What will a database do for me?

2. My students are able to read SQL, think SQL, and write SQL after the first chapter. Head First SQL starts students on the command-line, the same command-line professional database administrators use during 80-95% of their workday. My students start out with good command-line habits like using a DESCRIBE statement to view database structure and columns before writing a SELECT statement that references those columns.

3. The book invites my students to make mistakes and anticipates the most common mistakes I see students make. On quizzes, students who've dug into the book don't make those mistakes again.

4. The book's sequence of topics fits the way I teach and the way my students learn: queries come before design and theory. Head First SQL does not set out to be a comprehensive database design book, but it does an excellent job of immersing the learner in the critical thinking that goes into database design and table design strategy. I applaud Lynn Beighley and the Head First Team. They have laid an excellent foundation for the learner to smoothly transition into abstract database design concepts such as normalization, primary and foreign keys, entity-relationship diagrams (ERDs), and E.F. Codd's 12 principles of relational design.

5. Students don't read the book. They work the book. They play the book. They do the book.

6. Like Socrates, Head First SQL pushes my class and I to ask deeper questions about data, information, table design, normalization. Three different times during fall quarter, we had substantive arguments about which data types to use for certain columns. To hear my students using critical thinking and applying it to table design strategy is rewarding.

7. Like a guide, an outfitter, a trusted companion, HF SQL walks beside the student. The books I have used before talk down to students, talk over their heads, or just plain pontificate.

8. Theater in a database classroom? Yes. My students and I act out things like "Confessions of a NULL" -- fun, mysterious, memorable -- a great way to turn an abstract concept into a concrete and palpable one.

9. At conferences, committee meetings, training seminars, my colleagues and I talk about student engagement and the new "three Rs": rigor, relationships, and relevance. Using Head First SQL in my classroom changed my class noticeably, and I attribute that change to Head First's focus on those three Rs. My students started showing up early for class, spent more time in the lab outside of class, and performed far better on quizzes.

10. My quizzes and tests consist of sample tables and data. The open-ended questions on those tests ask students to write SQL to solve problems--a daunting task but the best way to assess whether students really "get" the concepts. In the past, students scores have ranged from 10% to 87%. A score of 92% was rare. A score of 95% almost unattainable. With Head First SQL, that range increased to between 70% and 98%. If that's not proof of Head First SQL's effectiveness, I don't know what is.

11. You will laugh your [body part here] off! And be warned: no matter what body part you substitute into the brackets, you will laugh several other body parts off as well.

I highly recommend this book to anyone teaching or learning SQL, relational database design, or MySQL.

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

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!

Specific Databases Books

Book Subjects
Most talked about in Specific Databases Books
Navegar en Internet. Creación de un portal con PHP y MySQL. 3ª edición. ImageNavegar en Internet. Creación de un portal con PHP y MySQL. 3ª edición.
UNKNOWN; Perfect Paperback; Book
MySQL. Das Praxisbuch. ImageMySQL. Das Praxisbuch.
by Matthias Kannengiesser
Franzis; Published: 2003-06-01; Hardcover; Book
Best price: $32.33
PHP-MySQL avec Dreamweaver MX ImagePHP-MySQL avec Dreamweaver MX
by Jean-Marie Defrance
Eyrolles; Published: 2003-05-22; Paperback; Book
FileMaker Instant Web Publishing VTC Training CD ImageFileMaker Instant Web Publishing VTC Training CD
by David Wheelock
Virtual Training Company, Inc.; Published: 2007-04-04; CD-ROM; Book
Best price: $99.95
dBASE IV for Windows: A Developers Resource Book ImagedBASE IV for Windows: A Developers Resource Book
by Jack L. Hursch, Carolyn J. Hursch
Windcrest; Published: 1993-03; Paperback; Book
Price in other shops: $32.95
Head First SQL: Your Brain on SQL -- A Learner's Guide ImageHead First SQL: Your Brain on SQL -- A Learner's Guide
by Lynn Beighley
O'Reilly Media; Published: 2007-09-01; Paperback; Book
Best price: $24.98
Price in other shops: $44.99
Backup & Recovery: Inexpensive Backup Solutions for Open Systems ImageBackup & Recovery: Inexpensive Backup Solutions for Open Systems
by W. Curtis Preston
O'Reilly Media; Published: 2007-01-10; Paperback; Book
Best price: $25.55
Price in other shops: $49.99
Programming PHP ImageProgramming PHP
by Rasmus Lerdorf, Kevin Tatroe, Peter MacIntyre
O'Reilly Media; Published: 2006-05-05; Paperback; Book
Best price: $19.55
Price in other shops: $39.99
Inside the dBASE Professional Compiler ImageInside the dBASE Professional Compiler
by Tony Lima
John Wiley & Sons Inc (Computers); Published: 2000-12; Paperback; Book
Price in other shops: $32.95
dBASE IV Systems Development Handbook ImagedBASE IV Systems Development Handbook
by Beth Galdeiri
Prentice Hall Trade; Published: 1991-06; Hardcover; Book
Price in other shops: $49.95
Similar Books and other products
Head First Data Analysis: A Learner's Guide to Big Numbers, Statistics, and Good Decisions ImageHead First Data Analysis: A Learner's Guide to Big Numbers, Statistics, and Good Decisions
by Michael Milton
O'Reilly Media; Published: 2009-08-04; Paperback; Book
Best price: $25.55
Price in other shops: $49.99
Head First HTML5 Programming: Building Web Apps with JavaScript ImageHead First HTML5 Programming: Building Web Apps with JavaScript
by Eric Freeman, Elisabeth Robson
O'Reilly Media; Published: 2011-10-18; Paperback; Book
Best price: $27.16
Price in other shops: $49.99
Database Design ImageDatabase Design
by Ryan Stephens, Ronald Plew
Sams; Published: 2000-11-30; Paperback; Book
Best price: $25.22
Price in other shops: $39.99
Head First Software Development ImageHead First Software Development
by Dan Pilone, Russ Miles
O'Reilly Media; Published: 2008-01-11; Paperback; Book
Best price: $27.09
Price in other shops: $49.99
Head First JavaScript ImageHead First JavaScript
by Michael Morrison
O'Reilly Media; Published: 2008-01-11; Paperback; Book
Best price: $15.00
Price in other shops: $39.99
Head First PHP & MySQL ImageHead First PHP & MySQL
by Lynn Beighley, Michael Morrison
O'Reilly Media; Published: 2008-12-29; Paperback; Book
Best price: $24.39
Price in other shops: $44.99
Head First C#, 2E: A Learner's Guide to Real-World Programming with Visual C# and .NET (Head First Guides) ImageHead First C#, 2E: A Learner's Guide to Real-World Programming with Visual C# and .NET (Head First Guides)
by Andrew Stellman, Jennifer Greene
O'Reilly Media; Published: 2010-05-28; Paperback; Book
Best price: $25.98
Price in other shops: $49.99
Learning SQL ImageLearning SQL
by Alan Beaulieu
O'Reilly Media; Published: 2009-04-27; Paperback; Book
Best price: $22.35
Price in other shops: $39.99
Head First Java, 2nd Edition ImageHead First Java, 2nd Edition
by Kathy Sierra, Bert Bates, Bert Bates
O'Reilly Media; Published: 2005-02-16; Paperback; Book
Best price: $24.50
Price in other shops: $44.95
Head First HTML with CSS & XHTML ImageHead First HTML with CSS & XHTML
by Eric T Freeman, Elisabeth Freeman, Elisabeth Robson
O'Reilly Media; Published: 2005-12-15; Paperback; Book
Best price: $18.95
Price in other shops: $39.99