|
Head First SQL
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!
CONTENTS:
1. Data and Tables: A Place for Everything
2. The SELECT statement: Gifted 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. Constraints, Views, and Transactions: Too many cooks spoil the database
12. Security: Protecting your assets
|
