SQL Clearly Explained

SQL Clearly Explained, Second Edition (The Morgan Kaufmann Series in Data Management Systems)

This is the second edition of the popular practitioner's guide to SQL, the industry-standard database query language. Like most computer languages, SQL can be overwhelming when you first see it, but for years readers have relied on this book to clear the confusion and explain how SQL works and how to use it effectively. Packed with tips, tricks, and good information, SQL Clearly Explained, Second Edition teaches database users and programmers everything they need to know to get their job done including
· formulating SQL queries,
· understanding how queries are processed by the DBMS,
· maximizing performance,
· using SQL to enter, modify, or delete data,
· creating and maintaining database structural elements, and
· embedding SQL in applications.

Features
· Updated and expanded to include changes in the SQL standard (SQL:1999) as well as recently implemented aspects of SQL-92.
· Includes CD with examples from the book as well as MySQL, a popular open-source DBMS, on which the examples are based.
· Web enhanced with extra features available online at www.mkp.com.

* Second edition of classic SQL handbook
* Updated to cover changes in the SQL language standard (SQL:1999)
* Includes CD with MySQL software

DOWNLOAD :
http://rapidshare.com/files/137033355/SQeLL.pdf

Practical PHP and MySQL

This books (Practical PHP and MySQL: Building Eight Dynamic Web Applications) starts with a brief introduction to the technology and then gives you a quick primer in core PHP and MySQL skills—just enough to get you started writing an application. After this short primer (because no one likes reading primers), you get straight into writing an application. This way, you don’t have to wade through 200 pages of reading before you can get started writing an application.

After the primer in Chapter 2, you get to the applications. I have prepared a menu of applications for your esteemed delectation:

Chapter 3, “Running the Projects.” The Live CD that accompanies this book contains software projects, applications, and the LAMPP server. This chapter provides information about the CD contents and how you operate the disc on your computer.

Chapter 4, “Building a Weblog” Plug into the weblog culture by creating a weblog system. Here you can add posts, have your readers submit comments, create different categories, and much more.

Chapter 5, “Discussion Forums” Create a discussion forums Web site with all the bling of the circus. You add forum categories, different forums, threads and messages, user accounts, forum administration, and more.

Chapter 6, “Creating a Shopping Cart” Open an online shop with this project, in which you add support for products, create a shopping cart, take payment via checks/PayPal, support different accounts, and more.

Chapter 7, “Building an Online Auction Site” Auction sites present an interestingchallenge, and in this chapter, you learn to support multiple accounts, write a bidding engine, support uploaded images, add auction summaries, and more.

Chapter 8, “Creating a Web-Based Calendar” Don your orange sunglasses and prepare to write the word Beta everywhere as you write an AJAX-driven calendar. Here you learn how AJAX works, create a calendar interface, support different events, set up user logins, and more.

Chapter 9, “FAQ Content Management System” In this chapter, you create a Content Management System (CMS) for FAQs. Features include different privilege levels for users, topic ownership, a submissions system, comment support, and more.

Chapter 10, “Building a Re-Usable Project” In this application, you create an independent component that could be dropped into any Web site. This is useful if you want to create projects for other developers to download and use. This chapter discusses how to create a portable component and integrate it into a separate site easily.

Chapter 11, “Building a News Web Site” This project solidifies much of the previous knowledge in the book and also looks at categorization, search support, and the use of the HTML_QuickForm PEAR extension.

Appendix A, “Web Site Design” In this chapter you create a static Web site and add features such as a FAQ page and an About page, and design the pages with Cascading Style Sheets (CSS).
As each project progresses, you learn more and more skills that are useful in a wide variety of PHP and MySQL Web applications.

DOWNLOAD THIS BOOKS

PHP & MySQL For Dummies 3rd edition

This books (PHP & MySQL Tutorial) is divided into six parts, with several chapters in each part. The content ranges from an introduction to PHP and MySQL to installing to creating and using databases to writing PHP programs.

Part I: Developing a Web Database
Application Using PHP and MySQL
Part I provides an overview of using PHP and MySQL to create a Web database application. It describes and gives the advantages of PHP, of MySQL, andof their use together. You find out how to get started, including what you need, how to get access to PHP and MySQL, and how to test your software. You then find out about the process of developing the application.

Part II: MySQL Database
In Part II you find out the details of working with MySQL databases. You create a database, change a database, and move data into and out of a database.

Part III: PHP
Part III provides the details of writing PHP programs that enable your Web pages to insert new information, update existing information, or remove information from a MySQL database. You find out how to use the PHP features that are used for database interaction and forms processing.

Part IV: Applications
Part IV describes the Web database application as a whole. You find out how to organize the PHP programs into a functioning application that interacts with the database. Two complete sample applications are provided, described, and explained.

Part V: The Part of Tens
Part V provides some useful lists of important things to do and not to do when developing a Web database application.

Part VI: Appendixes
The final part, Part VI, provides instructions for installing PHP and MySQL for those who need to install the software themselves. Appendix C discusses the installation of the Apache Web server for those who need to install and administer the Web server themselves.

DOWNLOAD THIS EBOOKS