Beginning MySQL of Wrox Publisher

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).
As the most popular open source database system in the world, MySQL boasts ease of implemen-tation, minimal overhead, consistent reliability, and low total cost of ownership. This hands-on resource offers you a complete look at MySQL and explains how to implement MySQL and access MySQL with various programming languages.
Written for experienced programmers who develop applications that access backend data-bases, this guide explains how to install MySQL 4.1 on Linux and Windows platforms, create a MySQL database, query and manage data in that data-base, and connect to the database from PHP, Java, and ASP.NET applica-tions. The authors also discuss transactions, system variable settings, the access privilege system, performance optimization, and backing up a database.
By the end of the book you'll have a solid foundation for understanding MySQL as a robust, flexible, and easy-to-implement application that has many diverse uses.

http://rapidshare.de/files/2356312/BMySQL.rar.html

|+|

Oracle Full Question Database Bank

 

This is a word document consisting of 97 pages of Questions which could be asked in interviews which u attend or in the exams

hope it might help u


code:

http://rapidshare.de/files/2466932/Oracle_Full_QB_afterdeath.zip.html

password: afterdeath

|+|

Pro Sql Server 2005 Reporting Services

ISBN: 1590594983
Title: Pro SQL Server 2005 Reporting Services (Pro)
Author: Rodney Landrum
Publisher: Apress



SQL Server Reporting Services 2005 is the latest version of the reporting technology from Mcft, providing the means to design, author, render, and deploy business reports to users, customers, and employees, via the web or the company intranet. The reporting engine is built in to the SQL Server 2005 database (and provided as a free add-on with SQL Server 2000) and the report manager is integrated with Visual Studio 2003, providing an effective and familiar environment for all SQL Server and .NET developers.

The book was written in parallel with a migration project, moving some 200 professional healthcare reports from various reporting architectures to SQL Server Reporting Services, and so is steeped in the day-to-day challenges, discoveries, and successes involved in delivering a successful reporting solution with this technology. In this book, you will find step-by-step guides, best practices, and real code examples that cover all of the common Reporting Services tasks.

Download Link : http://rapidshare.de/files/9790035/1590594983.rar.html

 

|+|

Relational Database Index Design and the Optimizers

Relational Database Index Design and the Optimizers by Tapio Lahdenmaki, Mike Leach
Hardcover: 328 pages - Publisher: Wiley-Interscience (July 7, 2005)
Language: English - ISBN: 0471719994 - File size: 5208 KB

iNFO:
mprove the performance of relational databases with indexes designed for today's hardware
Over the last few years, hardware and software have advanced beyond all recognition, so it's hardly surprising that relational database performance now receives much less attention. Unfortunately, the reality is that the improved hardware hasn't kept pace with the ever-increasing quantity of data processed today. Although disk packing densities have increased enormously, making storage costs extremely low and sequential read very fast, random reads are still painfully slow. Many of the old design recommendations are therefore no longer valid—the optimal point of indexing has come a long way. Consequently many of the old problems haven't actually gone away—they have simply changed their appearance.

This book provides an easy but effective approach to the design of indexes and tables. Using lots of examples and case studies, the authors describe how the DB2, Oracle, and SQL Server optimizers determine how to access data, and how CPU and response times for the resulting access paths can be quickly estimated. This enables comparisons to be made of the various designs, and helps you choose available choices for the most appropriate design.

This book is intended for anyone who wants to understand the issues of SQL performance or how to design tables and indexes effectively. With this title, readers with many years of experience of relational systems will be able to better grasp the implications that have been brought into play by the introduction of new hardware.

Download:

http://download.en911.com/uploadfile/2005/11/9/18414634996.zip
or
http://www.templateen.com/uploadfile/2005/11/9/18414634996.zip

|+|