Archive for the ‘MySQL’ Category

Beginning MySQL

April 20, 2007

Beginning MySQL

Provides programmers with a complete foundation in MySQL, the multi-user, multi-threaded SQL database server that easily stores, updates, and accesses information
Offers detailed instructions for MySQL installation and configuration on either Windows or Linux
Shows how to create a database, work with SQL, add and modify data, run queries, perform administrative tasks, and build database applications
Demonstrates how to connect to a MySQL database from within PHP, Java, ASP, and ASP.NET applications
Companion Web site includes SQL statements needed to create and populate a database plus three ready-to-use database applications (in PHP, Java, and ASP.NET)

Download Link:

Beginning MySQL

MySQL® Crash Course

April 20, 2007

MySQL® Crash Course

If you are a MySQL user who wants to find out more about the program, but is not interested in becoming a database administrator just to be able to read books on MySQL, then MySQL Crash Course is for you. This tutorial-based book is organized into a series of short, easy-to-follow lessons that take a very hands-on approach to meeting the needs of the average MySQL user. The essentials of MySQL are taught through a series of self-paced lessons in which you will complete exercises that illustrate the most important aspects of MySQL. You will learn how to:

Use the MySQL toolset.

Use the aggregate functions to analyze data.

Perform insert, update and delete operations.

Combine queries using unions.

Create and modify tables and access table schemas.

Manage databases, users and security privileges.

Don’t get bogged down in the database theory and relational design of other MySQL books. Let SQL Crash Course teach you what you need to know, when you need to know it, so you can quickly get on your way with MySQL.

Download Link:

MySQL® Crash Course

MySQL Tutorial – MySQL Press

April 20, 2007

MySQL Tutorial - MySQL Press

A concise introduction to the fundamentals of working with MySQL.

MySQL is an open-source relational database management system that is rapidly growing in popularity. Known for its speed, reliability, and ease of use, MySQL has proven itself to be particularly well suited both for beginners and for experienced developers to create sophisticated database-backed Web sites and applications.

MySQL Tutorial is a clear, concise introduction to the fundamental concepts and techniques of working with MySQL. It teaches the beginning MySQL user how to create and administer powerful databases that can be used at home, at work, and on the Web.

Whether you are a novice to databases or a technical professional looking to find out more about how MySQL works, MySQL Tutorial efficiently guides you through the information you need in order to get started with MySQL and quickly become proficient.

Download Link:

MySQL Tutorial – MySQL Press

PHP and MySQL Everyday Apps For Dummies

April 20, 2007

PHP and MySQL Everyday Apps For Dummies

Provides Web developers using the popular combination of PHP (a scripting language) and MySQL (a database system) with practical applications that they can adapt and put to work right away A 2002 survey found that PHP was running on over 9 million Web sites, and there have been over 1.8 million PHP downloads since May 2002; MySQL reports 2 million users Applications include a user login, an online catalog, a shopping cart, a content management system, a Web forum, and a mailing list management system The author walks readers through the creation of each application, offering two different versions-procedural (the traditional PHP coding method) and object-oriented

Download Link:

PHP and MySQL Everyday Apps For Dummies

MySQL, Second Edition (Visual QuickStart Guide)

April 14, 2007

MySQL, Second Edition (Visual QuickStart Guide)

Even if you’ve never used MySQL before, this Visual QuickStart Guide will have you up and running with the world’s most popular open source database application in no time. In this completely updated edition of our best-selling guide to MySQL, leading technology author Larry Ullman uses his trademark crystal-clear instructions and friendly prose to introduce you to everything that’s new in MySQL. Filled with step-by-step, task-based instructions and loads of visual aids, this book explains how to interact with MySQL using SQL, the language common to all databases. The interface examples show how to use MySQL’s own tools and how to use three popular programming languages (PHP, Perl, and Java). The book covers MySQL versions 3 and 4, as well as everything new in the eagerly anticipated version 5. Along the way, you’ll find extensive coverage of MySQL installation, administration, database design, as well as its use with various programming languages, database programming techniques, utilities, advanced MySQL and SQL, and more!

• Takes an easy, visual approach to teaching MySQL, using pictures to guide you through the software and show you what to do.
• Works like a reference book—you look up what you need and then get straight to work.
• No long-winded passages—concise, straightforward commentary explains what you need to know.
• Affordably priced, because buying a computer book shouldn’t be an investment in itself.
• Companion Web site at www.DMCInsights.com/mysql2 contains complete source code for examples in the book, online resources, extra scripts and tutorials, updates, a reader forum, and more.

Download:

MySQL, Second Edition (Visual QuickStart Guide)

PHP5 and MySQL Bible

April 3, 2007

This comprehensive tutorial and reference covers all the basics of PHP 5, a popular open source Web scripting language, and MySQL 4.012, the most popular open source database engine
Explores why users need PHP and MySQL, how to get started, how to add PHP to HTML, and how to connect HTML Web pages to MySQL
Offers an extensive tutorial for developing applications with PHP and MySQL
Includes coverage of how to install, administer, and design MySQL databases independently of PHP; exception and error handling; debugging techniques; PostgreSQL database system; and PEAR database functions
The authors provide unique case studies of how and where to use PHP drawn from their own extensive Web experience

Download Link:

PHP5 and MySQL Bible

Password: http://69448.rapidforum.com

Foundation PHP for Flash

February 5, 2007

PHP to Flash

Foundation PHP for Flash shows how to add dynamic content to Flash movies, by using PHP server-side scripting and the MySQL open-source database. Some knowledge of Flash is assumed, but PHP and MySQL are explained from scratch.
The advantage of combining these technologies is that Flash movies can interact with data on the Web server. A simple example, explained in the first chapter, is a user registration form. On the Flash side, ActionScript is the key ingredient that makes this kind of interaction possible. The author begins by showing how to send and receive external data from Flash movies. Next comes an introduction to PHP, from the basics of variables, statements and operators, through to functions, string handling, and regular expressions. There is also a chapter on cookie handling, often a vital part of a Web application. A mailing list example illustrates how to access external files from Flash and PHP. Finally the book introduces MySQL, showing how to get started with a system for serving up dynamic news items. That leaves space for three extensive case studies: online voting, an event planner, and a discussion forum. An appendix covers installation, and offers a brief guide to object-oriented programming.

With its friendly approach and practical examples, this is an excellent book for Flash designers looking to get started with dynamic content. It is not so good for existing PHP developers, as much of the material will already be familiar. Flash and PHP are a great combination, and this title offers plenty of ideas that you can take up in your own projects.

Download: Foundation PHP for Flash