* Shows how to take advantage of MySQL's built-in functions, minimizing the need to process data once it's been retrieved from the database. * Demonstrates how to write and use advanced and complex queries to cut down on (middleware) application logic, including nested sub-queries and virtual tables (added since MySQL 4.1). * Points out database design do's and don'ts, including many real-world examples of bad database designs and how the databases were subsequently improved. * Includes a review of MySQL fundamentals and essential theory, such as naming conventions and connections, for quick reference purposes.

Learn PHP development best practices, such as version control, development environment virtualization, and coding standards. You'll also discover the most useful PHP web frameworks, including the new Laravel, symfony2, and micro-frameworks. As you do so, you'll learn how to use them to write the most productive PHP code possible. PHP Development Tool Essentials complements Jason Gilmore's best-selling Beginning PHP and MySQL. This book will further expose you to the many different methodologies, tools, and concepts that professional web developers are using more and more each day. What You'll Learn Use version control with PHP Set up virtualized development environments Maintain PHP coding standards Manage dependencies Leverage the best PHP frameworks Who This Book Is For Intermediate to advanced PHP developers looking to advance their skills with new tools, concepts, and approaches.