Publisher: For Dummies; 1st edition (April 1, 2013)
Serves as essential reading for web designers who are new to these technologies, offering a crash course covering all of these powerful technologies in this handy volume of seven self-contained minibooks
Covers how to program in PHP and how to create and administer a MySQL database as well as how to manipulate MySQL data via a web interface
Shows how to create a secure website and how to code popular e-business applications such as login programs and shopping carts
Expert MySQL, 2nd Edition is the leading reference for learning, understanding, and extending the MySQL server. It unlocks the full promise of open source by showing how to modify the code, create your own storage engine, build your own authentication plugins, and even add your own functions and commands to the SQL language. No other book provides the level of detail or the extensive examples of the inner workings of MySQL that have taken engineers years to master. Expert MySQL, 2nd Edition is a must have book for all systems integrators, engineers, and software developers working with the MySQL server code.
Expert MySQL, 2nd Edition is also a wealth of information on key aspects of MySQL internals. You’ll learn about internal query representation, how the optimizer creates execution plans, and how to exert control over those plans for optimal performance in your environment. You’ll even learn to build your own query optimizer, giving insight that can help you understand and resolve tough performance problems. High-availability and replication are also covered, making Expert MySQL, 2nd Edition a must-have book for anyone doing high-end work involving MySQL. Download eBook Free »
This practical, hands-on training and reference guide is perfect for developers who need to learn MySQL. Written by Joel Murach, the author of bestselling “Java Servlets and JSP” and “PHP and MySQL” books, this is exactly the database book that web developers should have on their desks. This practical, hands-on tutorial/reference/guide to MySQL is perfect for beginners, but it also works for experienced developers who aren’t getting the most from MySQL.
As you would expect, this book shows how to code all of the essential SQL statements for creating and working with a MySQL database. But beyond that, this book also shows how to design a database, including how to use the graphical MySQL Workbench to create an EER model. It shows how to take advantage of the MySQL enhancements that aren’t covered in older books, such as foreign keys, transactions, stored procedures, stored functions, triggers, and events. It even presents a whole section on database administrator (DBA) skills, including how to secure and back up databases. And like all Murach books, it uses the distinctive “paired pages” format, which breaks the material into manageable skills to speed up both learning and reference. A great help for MySQL users at any level. Download eBook Free »
Publisher: Mike Murach & Associates (November 23, 2010)
Murach’s PHP and MySQL
This book is for any developer who wants to learn how to develop professional-level web applications using PHP and MySQL.
If you’re new to web programming, this book will get you going faster and better than any other book on the market. If you already have some web programming experience, this book lets you learn new skills whenever you have a few minutes. And new or experienced, this is the ideal reference for PHP and MySQL programming because you simply can’t remember the countless details that are required.
The only prerequisite for this book is that you have basic HTML and CSS skills. If you don’t have these skills, you can get them by reading the first 6 chapters of Murach’s HTML5 and CSS3.
Anytime you’re on the web, you’re going to be landing on PHP pages. By most counts, over a million web sites have been written in PHP, including some of today’s largest, most recognizable sites. And those sites often use MySQL as the database. Download eBook Free »
Get up to speed quickly. Learn how to install PHP and MySQL, and get them running on both your computer and a remote server.
Gain new techniques. Take advantage of the all-new chapter on integrating PHP with HTML web pages.
Manage your content. Use the file system to access user data, including images and other binary files.
Make it dynamic. Create pages that change with each new viewing.
Build a good database. Use MySQL to store user information and other data.
Keep your site working. Master the tools for fixing things that go wrong.
Control operations. Create an administrative interface to oversee your site.
Tips, tricks and fast-paced tutorials for getting the most out of Navicat
Master the visual design tools and editors with thorough examples
Discover how easy Navicat makes outsmarting the trickiest cases
Both Mac and PC versions covered, with screenshots detailing differences in performing tasks
MySQL Management and Administration with Navicat
Any database designer who wants to accomplish both everyday tasks and more advanced actions with a few clicks or drag-and-drops can now do so using Navicat’s advanced tools and this book.
Starting with the basics before progressing with advanced features, this book can be read from cover to cover, or simply used as a reference guide for any problems you encounter.
The book features ‘work along’ tutorials, some of which will surprise you by revealing features of Navicat which you may never have known existed – features such as designing functions and stored procedures, event triggers, creating batch jobs and scheduling. Download eBook Free »