Head First SQL
- Length: 610 pages
- Edition: 1
- Language: English
- Publisher: O'Reilly Media
- Publication Date: 2007-09-01
- ISBN-10: 0596526849
- ISBN-13: 9780596526849
- Sales Rank: #257532 (See Top 100 Books)
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
Chapter 1. data and tables
Chapter 2. the SELECT statement
Chapter 3. DELETE and UPDATE
Chapter. 4 smart table design
Chapter 5. ALTER
Chapter 6. advanced SELECT
Chapter 7. multi-table database design
Chapter 8. joins and multi-table operations
Chapter 9. subqueries
Chapter 10. outer joins, self-joins, and unions
Chapter 11. constraints, views, and transactions
Chapter 12. security
appendix i: leftovers
appendix ii: MySQL installation
appendix iii: tools roundup
Donate to keep this site alive
How to download source code?
1. Go to: https://www.oreilly.com/
2. Search the book title: Head First SQL
, sometime you may not get the results, please search the main title
3. Click the book title in the search results
3. Publisher resources
section, click Download Example Code
.
1. Disable the AdBlock plugin. Otherwise, you may not get any links.
2. Solve the CAPTCHA.
3. Click download link.
4. Lead to download server to download.