Useful Books and Software
|
Related MySQL Books |
|
|
 |
| |
|
|
| |
| Web Hosting and Web Design Related MySQL Books |
Page 6 of 40
Total results: 399 |
|
|
| |
|
|
| |
 |
|
SQL Hacks |
Whether you're running Access, MySQL, SQL Server, Oracle, or PostgreSQL, this book will help you push the limits of traditional SQL to squeeze data effectively from your database. The book offers 100 hacks -- unique tips and tools -- that bring you the knowledge of experts who apply what they know in the real world to help you take full advantage of the expressive power of SQL. You'll find practical techniques to address complex data manipulation problems. Learn how to: - Wrangle data in the most efficient way possible
- Aggregate and organize your data for meaningful and accurate reporting
- Make the most of subqueries, joins, and unions
- Stay on top of the performance of your queries and the server that runs them
- Avoid common SQL security pitfalls, including the dreaded SQL injection attack
Let SQL Hacks serve as your toolbox for digging up and manipulating data. If you love to tinker and optimize, SQL is the perfect technology and SQL Hacks is the must-have book for you.
Publisher:
O'Reilly Media, Inc.
Authors:
Andrew Cumming, Gordon Russell
Release Date: 2006-11-21
ISBN/EAN: 0596527993 / 9780596527990
New Price: $16.80 /
Used Price: $4.01 |
| |
|
|
|
|
| |
|
|
| |
 |
|
MySQL in a Nutshell (In a Nutshell (O'Reilly)) |
When you need to find the right SQL keyword or MySQL client command-line option right away, turn to this convenient reference, known for the same speed and flexibility as the system it covers so thoroughly. MySQL is packed with so many capabilities that the odds of remembering a particular function or statement at the right moment are pretty slim. With MySQL in a Nutshell, you get the details you need, day in and day out, in one concise and extremely well organized book.
The new edition contains all the commands and programming information for version 5.1, including new features and language interfaces. It's ideal for anyone using MySQL, from novices who need to get up to speed to advanced users who want a handy reference. Like all O'Reilly Nutshell references, it's easy to use and highly authoritative, written by the editor of the MySQL Knowledge Base at MySQL AB, the creator and owner of MySQL.
Inside, you'll find: - A thorough reference to MySQL statements, functions, and administrative utilities
- Several tutorial chapters to help newcomers get started
- Programming language APIs for PHP, Perl, and C
- Brief tutorials at the beginning of each API chapter to help anyone, regardless of experience level, understand and master unfamiliar territory
- New chapters on replication, triggers, and stored procedures
- Plenty of new examples of how MySQL is used in practice
- Useful tips to help you get through the most difficult subjects
Whether you employ MySQL in a mission-critical, heavy-use environment or for applications that are more modest, this book puts a wealth of easy-to-find information at your fingertips, saving you hundreds of hours of trial and error and tedious online searching. If you're ready to take advantage of everything MySQL has to offer, MySQL in a Nutshell has precisely what it takes.
Publisher:
O'Reilly Media, Inc.
Author:
Russell Dyer
Release Date: 2008-04-15
ISBN/EAN: 0596514336 / 9780596514334
New Price: $20.00 /
Used Price: $24.10 |
| |
|
|
|
|
| |
|
|
| |
 |
|
Upgrading to PHP 5 |
If you're using PHP 4, then chances are good that an upgrade to PHP 5 is in your future. The more you've heard about the exciting new features in PHP 5, the sooner that upgrade is probably going to be. Although an in-depth, soup-to-nuts reference guide to the language is good to have on hand, it's not the book an experienced PHP programmer needs to get started with the latest release. What you need is a lean and focused guide that answers your most pressing questions: what's new with the technology, what's different, and how do I make the best use of it? In other words, you need a copy of Upgrading to PHP 5. This book is targeted toward PHP developers who are already familiar with PHP 4. Rather than serve as a definitive guide to the entire language, the book zeroes in on PHP 5's new features, and covers these features definitively. You'll find a concise appraisal of the differences between PHP 4 and PHP 5, a detailed look at what's new in this latest version, and you'll see how PHP 5 improves on PHP 4 code. See PHP 4 and PHP 5 code side-by-side, to learn how the new features make it easier to solve common PHP problems. Each new feature is shown in code, helping you understand why it's there, when to use it, and how it's better than PHP 4. Short, sample programs are included throughout the book. Topics covered in Upgrading to PHP 5 include:- The new set of robust object-oriented programming features
- An improved MySQL extension, supporting MySQL 4.1, prepared statements, and bound parameters
- Completely rewritten support for XML: DOM, XSLT, SAX, and SimpleXML
- Easy web services with SOAP
- SQLite, an embedded database library bundled with PHP 5
- Cleaner error handling with exceptions
- Other new language features, such as iterators, streams, and more.
Upgrading to PHP 5 won't make you wade through information you've covered before. Written by Adam Trachtenberg, coauthor of the popular PHP Cookbook, this book will take you straight into the heart of all that's new in PHP 5. By the time you've finished, you'll know PHP 5 in practice as well as in theory.
Publisher:
O'Reilly Media, Inc.
Author:
Adam Trachtenberg
Release Date: 2004-07
ISBN/EAN: 0596006365 / 9780596006365
New Price: $3.94 /
Used Price: $1.49 |
| |
|
|
|
|
| |
|
|
| |
 |
|
High Performance MySQL: Optimization, Backups, Replication, and More |
High Performance MySQL is the definitive guide to building fast, reliable systems with MySQL. Written by noted experts with years of real-world experience building very large systems, this book covers every aspect of MySQL performance in detail, and focuses on robustness, security, and data integrity. High Performance MySQL teaches you advanced techniques in depth so you can bring out MySQL's full power. Learn how to design schemas, indexes, queries and advanced MySQL features for maximum performance, and get detailed guidance for tuning your MySQL server, operating system, and hardware to their fullest potential. You'll also learn practical, safe, high-performance ways to scale your applications with replication, load balancing, high availability, and failover. This second edition is completely revised and greatly expanded, with deeper coverage in all areas. Major additions include: Emphasis throughout on both performance and reliability Thorough coverage of storage engines, including in-depth tuning and optimizations for the InnoDB storage engine Effects of new features in MySQL 5.0 and 5.1, including stored procedures, partitioned databases, triggers, and views A detailed discussion on how to build very large, highly scalable systems with MySQL New options for backups and replication Optimization of advanced querying features, such as full-text searches Four new appendices The book also includes chapters on benchmarking, profiling, backups, security, and tools and techniques to help you measure, monitor, and manage your MySQL installations.
Publisher:
O'Reilly Media, Inc.
Authors:
Baron Schwartz, Peter Zaitsev, Vadim Tkachenko, Jeremy Zawodny, Arjen Lentz
Release Date: 2008-06-26
ISBN/EAN: 0596101716 / 9780596101718
New Price: $28.47 /
Used Price: $24.50 |
| |
|
|
|
|
| |
|
|
| |
 |
|
Expert MySQL (Expert) |
Since the enormous number of new features made available with MySQL release 5.0, MySQL has been gaining steam as a viable alternative to database behemoths like Oracle and IBM DB2. MySQL users now have the ability to extend MySQL with new SQL commands, optimize query execution, and embed MySQL within low-resource environments like embedded devices and kiosks. Expert MySQL, by Dr. Charles A. Bell, is the first book to examine these opportunities in detail, showing you how to wield maximum control over this powerful open source database. Youll learn how to create your own custom storage handlers, ensuring maximum flexibility and speed within your specialized applications. Youll also gain valuable insight into MySQLs architecture and learn how to tweak its behavior through custom changes to the source code.
Publisher:
Apress
Author:
Dr. Charles A. Bell
Release Date: 2007-01-22
ISBN/EAN: 1590597419 / 9781590597415
New Price: $4.97 /
Used Price: $1.35 |
| |
|
|
|
|
| |
|
|
| |
 |
|
Dimensional Data Warehousing with MySQL: A Tutorial |
Data warehousing with MySQL, a free and popular database, has never been made easier with this step-by-step tutorial on building dimensional data warehouses. Topics include star-schema modeling, populating (Extract, Transform, and Load: ETL), testing, and dimensional querying. It comes complete with a hands-on case—scaled-down from a real project—as well as an electronic copy of all MySQL scripts and sample data available for download. Computer programmers who need to build a data warehouse will find relevant examples and information written in a thorough, easy-to-follow style.
Publisher:
BrainySoftware
Author:
Djoni Darmawikarta
Release Date: 2007-04-01
ISBN/EAN: 0975212826 / 9780975212820
New Price: $24.91 /
Used Price: $29.52 |
| |
|
|
|
|
| |
|
|
| |
 |
|
MySQL Database Design and Tuning (Developer's Library) |
The authoritative, hands-on guide to advanced MySQL programming and administration techniques for high performance is here. MySQL Database Design and Tuning is the only guide with coverage of both the basics and advanced topics, including reliability, performance, optimization and tuning for MySQL. This clear, concise and unique source for the most reliable MySQL performance information will show you how to: - Deploy the right MySQL product for your performance needs.
- Set up a performance management and monitoring environment using tools from MySQL.
- Implement the right indexing strategy
- Apply good performance strategy when developing software to work with the MySQL database.
- Configure dozens of variable to correctly tune the MySQL engine.
If you deal with the intricacies and challenges of advanced MySQL functionality on a daily basis, you will be able to build on your knowledge with author Robert Schneider's real-world experiences in MySQL Database Design and Tuning.
Publisher:
MySQL Press
Author:
Robert D Schneider
Release Date: 2005-06-23
ISBN/EAN: 0672327651 / 9780672327650
New Price: $26.97 /
Used Price: $12.50 |
| |
|
|
|
|
| |
|
|
| |
 |
|
PHP & MySQL Web Development All-in-One Desk Reference For Dummies (For Dummies (Computer/Tech)) |
| If you want to build dynamic Web sites that encourage users to interact with them, PHP and MySQL are among the best tools you’ll find. PHP is a scripting language designed specifically for use on the Web, while MySQL is a database management system that works with it perfectly. Best of all, they’re free. It’s hard to beat that combination! PHP & MySQL Web Development All-in-One Desk Reference For Dummies is kind of one-stop shopping for the information you need to get up and running with these tools and put them to good use. It’s divided into six handy minibooks that cover setting up your environment, PHP programming, using MySQL, security, PHP extensions, and PHP Web applications. They make it easy to create a Web site where visitors can sign on, use shopping carts, complete forms, and do business with your business. It’s easy to find what you need in this handy guide. You’ll discover how to: - Find and acquire all the tools you need and set up your development environment
- Build PHP scripts to make your Web site work
- Create a MySQL database that visitors can access
- Summarize and sort data results
- Design and implement user access control
- Build a shopping cart application
- Create extensions that make your site more useful
With PHP & MySQL Web Development All-in-One Desk Reference For Dummies by your side, you’ll be a Web site guru before you know it!
Publisher:
For Dummies
Authors:
Janet Valade, Bill Ballad
Release Date: 2008-01-29
ISBN/EAN: 0470167777 / 9780470167779
New Price: $19.09 /
Used Price: $20.12 |
| |
|
|
|
|
| |
|
|
| |
 |
|
PHP with MySQL Essential Training |
Website and database assimilation is a necessity for many of today's businesses, and learning to work with PHP is key to integration success. The objective of PHP with MySQL Essential Training is to teach both new and experienced web developers the comprehensive steps for building dynamic, data-driven, interactive websites. Instructor Kevin Skoglund demonstrates the entire process of building a content management system. He starts with the basics of the PHP language (variables, arrays, loops, functions, etc.) and works up to building dynamic web pages with a MySQL back end. Kevin also covers blueprinting applications; structuring and interacting with databases; building, validating, and processing forms; and regulating user access with passwords. In addition, he provides practical advice, offers examples of best practices, and demonstrates refactoring techniques for improving existing code. Exercise files accompany the tutorials.Topics Include:- Viewing PHP configuration information
- Exploring data types
- Understanding logical expressions
- Working with loops
- Defining and using functions
- Building web pages
- Creating a database in MySQL
- Building a content management system
Duration: 10.75 hoursOn 2 CD-ROMs
Publisher:
lynda.com, Inc
Author:
Kevin Skoglund
Release Date: 2007-07-10
ISBN/EAN: 159671364X / 9781596713642
New Price: $129.95 /
Used Price: n.a. |
| |
|
|
|
|
| |
|
|
| |
 |
|
Beginning PHP 5 and MySQL: From Novice to Professional |
I can report that Gilmore and Apress have given the world one book that will replace many other PHP and MySQL volumes. This is one that the reader will consistently rely on and keep near to hand.
— Mary Norbury-Glaser, Slashdot contributor I can summarize this review in nine words: If you want to learn PHP, buy this book.
— Gregg Bolinger, JavaRanch Sheriff ...an extremely detailed book.
— Richard Testani, Apple-Sauce.com Beginning PHP 5 and MySQL: From Novice to Professional offers a comprehensive introduction to two of the most popular open source technologies on the planet: the PHP scripting language and the MySQL database server. You are not only exposed to the core features of both technologies, but will also gain valuable insight into how they are used in unison to create dynamic data-driven web applications, not to mention learn about many of the undocumented features of the most recent versions. The first part of the book is devoted to PHP's foundational features, with special focus on those new to PHP 5, including the improved object-oriented support, exception handling, SQLite support, SimpleXML, and much more. But PHP 5-specific topics are only part of what's covered; you'll also learn about the language's core capabilities, beginning with a survey of installation and configuration tasks. Early chapters are devoted to basic PHP programming concepts such as variables, datatypes, arrays, string manipulation, and user interaction. Later chapters cover session handling, LDAP integration, the Smarty templating engine, and Web Services support. Next up is a broad overview of the powerful MySQL database server. Among other topics, you'll learn about the installation and configuration process, datatypes, key security features, and various administration utilities. With this groundwork in pace, you'll then learn about PHP's assortment of MySQL functions, accompanied by dozens of examples depicting the creation and execution of queries. You'll also learn how to perform searches, and manage database transactions. Whether you're a newcomer searching for a thorough introduction to these popular technologies, or a seasoned developer in need of a comprehensive reference, this book is for you.
Beginning PHP 5 and MYSQL: From Novice to Professional offers a comprehensive introduction to two of the most popular Web application building technologies on the planet: the scripting language PHP and the MySQL database server. This book will not only expose you to the core aspects of both technologies, but will provide valuable insight into how they are used in unison to create dynamic data-driven Web applications. Beginning PHP 5 and MYSQL explains the new features of the latest releases of the world's most popular Open Source Web development technologies: MySQL 4 database server and PHP 5 scripting language. This book explores the benefits, extensive new features, and advantages of the object-oriented PHP 5, and how it can be used in conjunction with MySQL 4 to create powerful dynamic Web sites. This is the perfect book for the Web designer, programmer, hobbyist, or novice that wants to learn how to create applications with PHP 5 and MySQL 4, and is a great entrance point for Apress's extensive spectrum of PHP books planned for 2004.
Publisher:
Apress
Author:
W. Jason Gilmore
Release Date: 2004-06-21
ISBN/EAN: 1893115518 / 9781893115514
New Price: $11.00 /
Used Price: $6.86 |
| |
|
|
|
|
| |
|
|
|
|
|
