Head First SQL

Here’s what we do:

We use pictures,because your brain is tuned for visuals,not text. As far as your brain’s concerned,a picture really is worth a thousand words. And when text and pictures work together,we embedded the text in the pictures because your brain works more effectively when the text is within the thing the text refers to,as opposed to in a caption or buried in the text somewhere.

We use redundancy,saying the same thing in different ways and with different media types,and multiple senses,to increase the chance that the content gets coded into more than one area of your brain.

We use concepts and pictures in unexpected ways because your brain is tuned for novelty,and we use pictures and ideas with at least some emotional content,because your brain is more likely to remember when you feel something.

We use a personalized,conversational style,because your brain is tuned to pay more attention when it believes you’re in a conversation than if it thinks you’re passively listening to a presentation.

We include many activities,because your brain is tuned to learn and remember more when you do things than when you read about things. And we make the exercises challenging-yet-do-able,because that’s what most people prefer.

We use multiple learning styles,because you might prefer step-by: -step procedures,while someone else wants to understand the big picture first,and someone else just wants to see an example. But regardless of your own learning preference,everyone benefits from seeing the same content represented in multiple ways.

We include content for both sides of your brain,because the more of your brain you engage,the more likely you are to learn and remember,and the longer you can stay focused. Since working one side of the brain often means giving the other side a chance to rest,you can be more productive at learning for a longer period of time.

We include challenges by: asking questions that don’t always have a straight answer,because your brain is tuned to learn and remember when it has to work at something.

Finally,we use people in our stories,examples,and pictures,because,well,you’re a person. Your brain pays more attention to people than to things.

Chapter 1. Data and Tables: A place for everything
Chapter 2. The SELECT Statement: Gifted data retrieval
Chapter 3. DELETE and UPDATE: A change will do you
good
Chapter 4. Smart Table Design: Why be normal?
Chapter 5. ALTER: Rewriting the past
Chapter 6. Advanced SELECT: Seeing your data with new
eyes
Chapter 7. Multi-table Database Design: Outgrowing
your table
Chapter 8. Joins and Multi-table Operations: Can’t we all
just get along?
Chapter 9. Subqueries: Queries Within Queries
Chapter 10. Outer Joins,Self Joins,and Unions: New
maneuvers
Chapter 11. Constraints,Views,and Transactions: Too
many cooks spoil the database
Chapter 12. Security: Protecting your assets
Appendix l. Leftovers The Top Ten Topics(we didn’t cover)
Appendix ll. MySQL installation Try it out for yourself
Appendix ll. Tools roundup All your new SQL tools

下载地址 Download

解决验证以访问链接！进行人机身份验证