Head First SQL

by Lynn Beighley

Published 1 January 2007
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. 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!

Head First PHP & MySQL

by Lynn Beighley

Published 1 January 2008
If you're ready to create web pages more complex than those you can build with HTML and CSS alone, Head First PHP & MySQL is the ultimate learning guide to building dynamic, database-driven websites using PHP and MySQL. Packed with real-world examples, this book teaches you all the essentials of server-side programming, from the fundamentals of PHP and MySQL coding to advanced topics such as form validation, session IDs, cookies, database queries and joins, file I/O operations, content management, and more. This updated second edition includes additions such as PHP security vulnerabilities and how to address them, file I/O, unit testing, and an introduction to object-oriented PHP. All the MySQL and PHP code has been updated to reflect latest versions. If you're ready to build a truly dynamic website, Head First PHP & MySQL is the ideal way to get going.