Head First SQL Your Brain on SQL -- A Learner\'s Guide~tqw

******************************************************************************* Head First SQL: Your Brain on SQL -- A Learner's Guide ******************************************************************************* ------------------------------------------------------------------------------- General Information ------------------------------------------------------------------------------- Type.................: Ebook Part Size............: 50,206,405 bytes ------------------------------------------------------------------------------- Post Information ------------------------------------------------------------------------------- Posted by............: ~tqw~ ------------------------------------------------------------------------------- Release Notes ------------------------------------------------------------------------------- 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! Table of Contents Intro Who is this book for? xxvi We know what you�re thinking xxvii Metacognition xxix Bend your brain into submission xxxi Read me xxxii The technical review team xxxiv Acknowledgments xxxv Intro xxv 1 Data and Tables: A place for everything 1 2 The SELECT Statement: Gifted data retrieval 53 3 DELETE and UPDATE: A change will do you good 119 4 Smart Table Design: Why be normal? 159 5 ALTER: Rewriting the past 197 6 Advanced SELECT: Seeing your data with new eyes 235 7 Multi-table Database Design: Outgrowing your table 281 8 Joins and Multi-table Operations: Can�t we all just get along? 343 9 Subqueries: Queries Within Queries 379 10 Outer Joins, Self Joins, and Unions: New maneuvers 417 11 Constraints, Views, and Transactions: Too many cooks spoil the database 455 12 Security: Protecting your assets 493 Index Product Details * ISBN: 0596526849 * ISBN-13: 9780596526849 * Format: Paperback, 571pp * Publisher: O'Reilly Media, Incorporated * Pub. Date: August 2007 ------------------------------------------------------------------------------- Install Notes ------------------------------------------------------------------------------- Adobe Acrobat Reader

udp://tracker.openbittorrent.com:80
udp://open.demonii.com:1337
udp://tracker.coppersurfer.tk:6969
udp://exodus.desync.com:6969