 |
Head First SQL View Larger Image | Lynn Beighley
O'Reilly Media, Paperback, Published August 2007, 672 pages, ISBN 0596526849 | List Price: $44.99
Our Price: $28.50
You Save: $16.49 (37% Off)
| | | Availability: In-Stock |
Read an excerpt:
Chapter 1: Data and Tables: A Place for Everything
(Large File - Right Click and "Save Link As"!)
Excerpt provided courtesy of O'Reilly Media. Copyright © O'Reilly Media, Inc. Written permission from the publisher is required for any use of this material.
|
Be the First to Write a Review and tell the world about this title!People who purchase this book frequently purchase: - Head First JavaScript; Michael Morrison, $25.50, 36% Off!
- Head First HTML with CSS & XHTML; Eric Freeman, et al, $25.95, 35% Off!
- Effective Java, 2nd Edition; Joshua Bloch, $34.95, 30% Off!
- Head First C#; Andrew Stellman, et al, $31.95, 36% Off!
Books on similar topics, in best-seller order:Books from the same publisher, in best-seller order:
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
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
About the Author
Lynn Beighley is a freelance web programmer and designer who began working
on her Masters in Computer Science while working at the Naval Research Laboratory.
On the side, she created and ran a number of web sites for fun, which led to
her to open a company and write a series of Flash, Dreamweaver, and Photoshop
books and training CDs. She's worked at Los Alamos National Labs, Palm and Yahoo!
Inc. While at Yahoo! she worked on dynamic Flash advertisements on the front
page.
|
|
