What will you learn from this book?
In today's world, data is power, but the real secret to success is having power over your data. Head First SQL takes you to the heart of SQL language, from basic syntax queries using INSERT and SELECT to hardcore database manipulation with subqueries, joins, and transactions. By the time you finish reading, you will not only understand effective and effcient database desingn and creation, you'll be querying, normalizing, and joining data like a pro. And you'll be a true master of your data.
Why does this book look so different?
We think your time is too valuable to spend struggling with new concepts. Using the latest research in cognitive science and learning theory to craft a multi-sensory learning experience, Head First SQL uses a visually rich format designed for the way your brain works, not a text-heavy approach that puts you to sleep.
Table of Contents (Summary)
1. Data and Tables: A place for everything
2. The SELECT Statement: Gified data retrieval
3. DELETE and UPDATE: A change will do you good
4. Smart Table Design: Why be normal?
5. ALTER: Rewriting the past
6. Advanced SELECT: Seeing your data with new eyes
7. Multi-table Database Design: Outgrowing your table
8. Joins and Multi-table Operations: Can't we all just get along?
9. Subqueries: Queries Within Queries
10. Outer Joins, Self Joins, and Unions: New maneuvers
11. Constrains, Views, and Transactions: Too many cooks spoil the database
12. Security: Protecting you assets
Table of Contents (the real thing)
- Who is this book for?
- We know what you're thinking
- Metacognition
- Bend your brain into submission
- Read me
- The technical review team
"This is not SQL made easy; this is SQL made challeging, SQL made fun. It even answers that age-old question 'How to teach non-correlated subqueries without losing the will to live? This is the righ way to learn--it's fast, it's flippant, and it looks fabulous."
--Andrew Cumming, Author of SQL Hacks, Zoo Keeper at sqlzoo.net--
"There are books you buy, books you keep, books you keep on your desk, and thanks to O'Reilly and the Head First crew, there is the crew, there is the penultimate category, Head First books. They're the ones that are dogeared, mangled, and carried everywhere. Head First SQL is at the top of my stack."
--Bill Sawyer, ATG Curriculum Manager, Oracle--