If you're ready to create web pages more complex than those you can build with HTML and CSS, "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. "Head First PHP & MySQL" offers the same visually rich format that's turned every title in the "Head First" series into a bestseller, with plenty of exercises, quizzes, puzzles, and other interactive features to help you retain what you've learned.This title discusses how to: use PHP to transform static HTML pages into dynamic web sites; create and populate your own MySQL database tables, and work with data stored in files; perform sophisticated MySQL queries with joins, and refine your results with LIMIT and ORDER BY; use cookies and sessions to track visitors' login information and personalize the site for users; protect your data from SQL injection attacks; use regular expressions to validate information on forms; dynamically display text based on session info and create images on the fly; and, pull syndicated data from other sites using PHP and XML. Throughout the book, you'll build sophisticated examples - including a mailing list, a job board, and an online dating site - to help you learn how to harness the power of PHP and MySQL in a variety of contexts. If you're ready to build a truly dynamic website, "Head First PHP & MySQL" is the ideal way to get going.

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!

Jumpstarting books provide an avenue for makers to quickly master topical knowledge! Each book starts with instructions on how to install or initialize the hardware or software needed to reach the "Hello, World" stage of getting started! The second project in the book builds on the first to use more of the hardware or software's capabilities. Later projects expand the user's knowledge into lesser-known aspects of the topic. All Jumpstarting projects are for Makers -- they provide hands-on, real-world experience in making the hardware or software do what you want it to do!

This hands-on book takes a look at four brilliant women -- Ada Lovelace, Anna Atkins, Hildegard Von Bingen, and Maria Telkes -- and the world-changing innovations they created. Walk in their footsteps as you discover how these women became inventors, learn what inspired them, and then try your hand at recreating their most famous inventions -- computer programs, solar photography, codes and ciphers, and water purifiers.

DESCRIPTION This book teaches young readers how to program using the Swift language while they develop iOS apps. Readers gain fundamental programming skills along the way. Hello Swift! is a how-to guide to programming iOS apps with the Swift language, written from a kid's perspective. This approachable, wellillustrated, step-by-step guide takes readers from very beginning programming concepts through creating complete apps. It begins by teaching the basics of what an app is and what is needed to build one. From there, readers will create their first simple app while learning more about programming with Swift. Readers conquer important programming concepts that can be used with other programming languages. KEY FEATURES * Crystal-clear explanations * Engaging images and straightforward examples * Hands-on lessons * Exercises that encourage critical thinking * Practical instructions for building and deploying apps on the App Store AUDIENCE While written with a younger audience in mind, this book is for readers of any age with no programming experience who want to enjoy learning to program while creating iOS apps. ABOUT THE TECHNOLOGY Swift is Apple's new robust and intuitive programming language for iOS. It's free and open source and can be used to build apps for iOS, Mac, Apple TV, and Apple Watch.