Head First SQL – Lynn Beighley – 1st Edition

Is your dragging you down? Are your all tangled up? Well we’ve got the tools to teach you just 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, 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!

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 : 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

Appendix Leftovers: The Top Ten Topics (we didn’t )
#1. Get a GUI for your RDBMS
#2. Reserved Words and Special Characters
#3. ALL, ANY, and SOME
#4. More on Data Types
#5. Temporary tables
#6. Cast your data
#7. Who are you? What time is it?
#8. Useful numeric functions
#9. Indexing to speed things up
#10. 2-minute PHP/

Appendix MySQL Installation: Try it out for yourself
Get started, fast!
Instructions and Troubleshooting
Steps to Install MySQL on Windows
Steps to Install MySQL on Mac OS X

Title: Head First SQL: Your Brain on SQL
Author: Lynn Beighley
Edition: 1st Edition
ISBN: 1449360440 | 9781449360443
Type: eBook
Language: English
Computer Programming
REVIEW 63%
63%

No Comments

  • Can you please leave feedback and comments here

    Your opinions and comments would be greatly appreciated. If you have comments or questions we've added this section so that we might have a dialogue with you.

Complete all fields

10 − 8 =