Monday, May 28, 2007
MySQL Basics
Printed: 141 pages
Publisher: Visibooks, LLC
Language: English
Country: United States
Description:
Learn to use the open-source MySQL database and integrate it with Web sites.
Monday, May 21, 2007
Expert MySQL (Expert)
Expert MySQL (Expert)
By Dr. Charles A. Bell
* Publisher: Apress
* Number Of Pages: 525
* Publication Date: 2007-01-22
* Sales Rank: 300146
* ISBN / ASIN: 1590597419
* EAN: 9781590597415
* Binding: Paperback
* Manufacturer: Apress
* Studio: Apress 
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.
Apress.Expert.MySQL.Jan.2007.eBook-BBL
7894 KB
RAR'd PDF
Saturday, May 12, 2007
DB2 SQL PL : Essential Guide for DB2 UDB on Linux, UNIX, Windows, i5/OS, and z/OS 2nd Edition 2004-11 [includes link to CD contents]
Publisher: IBM Press
Number Of Pages: 576
Publication Date: 2004-11-15
Sales Rank: 123163
ISBN / ASIN: 0131477005
EAN: 0076092035589
Binding: Hardcover
Manufacturer: IBM Press
Studio: IBM Press
embed yourself in db2
The book describes IBM's Procedural Language, which runs on their db2 servers. It is not a general purpose language, like C or Java. Rather, it is tied directly to db2 and IBM's implementation of SQL. But within this context, the book explains the expressive power of PL. It shows at length how you can write stored procedures, triggers and functions in PL. The level of detail and the cited examples should reassure you of PL's capability.But why even write business logic code at the database layer? There have been other books on n-tier application design, which call for the locating of business logic in a middle tier and not at the database. The authors' rejoinder is that while that makes for an elegant design, practical experience shows that often, crucial logic needs to be at the database. This reduces networks traffic and can heavily improve perforance. Hence the need for PL, or something like it.Be wary of the book's claim that PL lets you write "portable application logic". It is portable only between instances of db2 running under linux, unix, Microsoft Windows or IBM's operating systems. When you write embedded logic in PL, you are also embedding yourself or your company into db2. Which may indeed be fine by you. But just so you know.
Download
Friday, May 11, 2007
Introduction to SQL: Mastering the Relational Database Language (4th Edition)
By Rick F. van der Lans*
Publisher: Addison-Wesley Professional*
Number Of Pages: 1056*
Publication Date: 2006-09-26*
Sales Rank: 396411*
ISBN / ASIN: 0321305965*
EAN: 9780321305961* Binding: Paperback*
Manufacturer: Addison-Wesley Professional*
Studio: Addison-Wesley Professional
Book Description:
The Classic SQL Tutorial: Fully Updated for Today’s Standards and Today’s Top Databases
For twenty years, van der Lans’ Introduction to SQL has been the definitive SQL tutorial for database professionals everywhere, regardless of experience or platform. Now van der Lans has systematically updated this classic guide to reflect the latest SQL standards and the newest versions of today’s leading RDBMSs: Oracle, Microsoft SQL Server, DB2, and MySQL.
Using case study examples and hands-on exercises, van der Lans illuminates every key SQL concept, technique, and statement. Drawing on decades of experience as an SQL standards team member and enterprise consultant, he reveals exactly why SQL works as it does–and how to get the most out of it. You’ll gain powerful insight into everything from basic queries to stored procedures, transactions to data security. Whether you’re a programmer or DBA, a student or veteran, this book will take you from “apprentice” to true SQL master.
Writing queries and updating data: all you need to know about SELECT
Working with joins, functions, and subqueries
Creating database objects: tables, indexes, views, and more
Specifying keys and other integrity constraints
Using indexes to improve efficiency
Enforcing security via passwords and privileges
Building stored procedures and triggers
Developing with embedded SQL and ODBC
Working with transactions, including rollbacks, savepoints, isolation levels, and more
Optimizing performance by reformulating SQL statements
Using object-relational features: subtables, references, sets, and user-defined data types
Reference section: SQL statement definitions and SQL function lists
Download
The Classic SQL Tutorial: Fully Updated for Today’s Standards and Today’s Top Databases
For twenty years, van der Lans’ Introduction to SQL has been the definitive SQL tutorial for database professionals everywhere, regardless of experience or platform. Now van der Lans has systematically updated this classic guide to reflect the latest SQL standards and the newest versions of today’s leading RDBMSs: Oracle, Microsoft SQL Server, DB2, and MySQL.
Using case study examples and hands-on exercises, van der Lans illuminates every key SQL concept, technique, and statement. Drawing on decades of experience as an SQL standards team member and enterprise consultant, he reveals exactly why SQL works as it does–and how to get the most out of it. You’ll gain powerful insight into everything from basic queries to stored procedures, transactions to data security. Whether you’re a programmer or DBA, a student or veteran, this book will take you from “apprentice” to true SQL master.
Writing queries and updating data: all you need to know about SELECT
Working with joins, functions, and subqueries
Creating database objects: tables, indexes, views, and more
Specifying keys and other integrity constraints
Using indexes to improve efficiency
Enforcing security via passwords and privileges
Building stored procedures and triggers
Developing with embedded SQL and ODBC
Working with transactions, including rollbacks, savepoints, isolation levels, and more
Optimizing performance by reformulating SQL statements
Using object-relational features: subtables, references, sets, and user-defined data types
Reference section: SQL statement definitions and SQL function lists
Download
Wednesday, April 25, 2007
MySQL Administrator's Guide
Publisher: MySQL Press
Number Of Pages: 448
Publication Date: 2004-06-17
Sales Rank: 479520
ISBN / ASIN: 0672326345
EAN: 0752063326343
Binding: Paperback
Manufacturer: MySQL Press Book Description:
If you are not already one of the 4 million plus users of the MySQL database, you will want to become one after reading this book. MySQL Administrator's Guide is the official guide to installing, administering and working with MySQL 5.0 and MySQL databases. Starting with the basics, you will learn to store, manage and retrieve data in a MySQL database and to eventually manipulate the code behind MySQL 5.0 to customize your database. With the clear examples and tips provided in this comprehensive learning guide, you can become a MySQL expert in no time.Download Description:
With more than 4 million active installations, MySQL is the world's most popular open-source database. Known for its speed, high reliability, and ease of use, MySQL is rapidly becoming a low-cost alternative to high-priced, high-maintenance database systems from Oracle, IMB and Microsoft-and it already has more users than any of these more established proprietary databases. The MySQL User's Guide is the only official guide to installing MySQL, to setting up and administering databases, and to storing and retrieving data in these databases. Written by the creators of MySQL, and edited by the highly respected MySQL authors, the MySQL User's Guide is designed for a broad audience. Non-programmers and programmers alike will be able to quickly get up-to-speed with MySQL using the clear instructions, examples, and tips provided in the book.
Download
Wednesday, April 18, 2007
Microsoft SQL Server(TM) 2005 Administrator's Companion
Author: Edward Whalen, Microsoft SQL Server(TM) 2005 Administrator's Companion
ISBN: 0735621985 Publisher: Microsoft Press; Bk&CD-Rom edition Hardcover: 1225 pages PDF 22.9 mbBook
DescriptionGet comprehensive information to plan, deploy, administer, and support Microsoft SQL Server 2005 in organizations of any size. With the Microsoft SQL Server 2005 Administrators Companion, you get mission-critical information in a single volumestraight from the experts.Book InfoProvides the practical information that database administrators need to configure a SQL Server 7.0 database for better, faster, more scalable solutions. Covers Microsoft SQL Server 7.0. DLC: Client/server computing. --This text refers to an out of print or unavailable edition of this title.Get your mission-critical databases up and running quickly with this essential, single-volume guide.Discover how to:- Perform an installation or upgrade, and configure it on the network;- Plan and configure the I/O subsystem and model system capacity;- Create and maintain databases, tables, views, and indexes;- Administer transactions, deadlocks, and isolation levels;- Manage users with logins, user IDs, schemas, permissions, and roles;- Implement failover clustering, log shipping, and database mirroring for high availability;- Manage and tune snapshot, transactional, and merge replication;- Administer SQL Server Analysis Services and Reporting Services;- Monitor, troubleshoot, and fine-tune performance.
Download 22.9 mb
Download 22.9 mb
Inside SQL Server 2005 Tools (Microsoft Windows Server System Series)
Inside SQL Server 2005 Tools (Microsoft Windows Server System Series)
ISBN: 0321397967
Title: Inside SQL Server 2005 Tools (Microsoft Windows Server System Series)Author: Michael Raheem Dima Sonkin Thierry D’Hers Kami LeMonds
Publisher: Addison-Wesley Professional
Publication Date: 2006-10-25
Number Of Pages: 816
MySQL Enterprise Solutions: John Willey & Sons
Book Description:
* With more than three million users, MySQL is the most popular open-source database server in the world, providing an extremely fast, reliable, and inexpensive alternative to commercial* Gives corporate users a complete guide to building enterprise-level with MySQL* Covers the pros and cons of MySQL and installing, testing, and configuring the MySQL server* Written by one of the lead programmers of the MySQL product and reviewed by Monty Widenius, the creator of MySQL* Companion Web site includes all code examples as well as links to useful online resources►
* With more than three million users, MySQL is the most popular open-source database server in the world, providing an extremely fast, reliable, and inexpensive alternative to commercial* Gives corporate users a complete guide to building enterprise-level with MySQL* Covers the pros and cons of MySQL and installing, testing, and configuring the MySQL server* Written by one of the lead programmers of the MySQL product and reviewed by Monty Widenius, the creator of MySQL* Companion Web site includes all code examples as well as links to useful online resources►
No. of Pages: 416►
Publisher: Wiley (February 4, 2003)►
Language: English►
ISBN: 0471269220: Rapidshare.com►
File Size: 1.6 MB►
File Format: PDF►
Download Format: WinRAR
Download from Rapidshare.com
Download from Rapidshare.com
A First Look at Microsoft SQL Server 2005 for Developers by Bob Beauchemin
A First Look at Microsoft SQL Server 2005 for Developers by Bob Beauchemin, Niels Berglund, Dan Sullivan
Publisher: Addison-Wesley Professional; 1st edition (June 25, 2004) ISBN: 0321180593 PDF 4,7 Mb 736 pages
Few technologies have been as eagerly anticipated as Microsoft SQL Server 2005 ("Yukon"). Now, three SQL Server insiders deliver the definitive hands-on preview--accurate, comprehensive, and packed with examples.A First Look at SQL Server 2005 for Developers starts where Microsoft's white papers and Web articles leave off, showing working developers how to take full advantage of Yukon's key innovations. It draws on exceptional cooperation from Microsoft's Yukon developers and the authors' hands-on access to Yukon since its earliest alpha releases.
Few technologies have been as eagerly anticipated as Microsoft SQL Server 2005 ("Yukon"). Now, three SQL Server insiders deliver the definitive hands-on preview--accurate, comprehensive, and packed with examples.A First Look at SQL Server 2005 for Developers starts where Microsoft's white papers and Web articles leave off, showing working developers how to take full advantage of Yukon's key innovations. It draws on exceptional cooperation from Microsoft's Yukon developers and the authors' hands-on access to Yukon since its earliest alpha releases.
or mirror:
The Practical SQL Handbook
The Practical SQL Handbook: Using SQL Variants (4th Edition) by Judith S. Bowman, Sandra L. Emerson, Marcy Darnovsky
Publisher: Addison-Wesley Professional; 4 edition (June 26, 2001) ISBN-10: 0201703092 CHM 1,5 Mb 512 pages
Download from Ftp2Share
Download from Ftp2Share
Microsoft SQL Server 2005 Reporting Services For Dummies (For Dummies
ISBN: 076458913XAuthor: Mark RobinsonPublisher: For DummiesEdition: Language: EnglishPaperback: 432 pagesURL:Summary:Find the right information and present it the right way Take full advantage of all SQL Server Reporting Services can do for you Without a way to interpret it, the data in your database just sits there doing nothing. Now you have help! This handy guide shows you how to retrieve data and create reports with the newest version of SQL Server Reporting Services, so you can deliver both hard copy and interactive, Web-based reports that tell your story. Discover how to Access information from different databases Build the right queries Choose the best report type Move from other reporting tools Deliver reports on demand Produce drill-down and drill-through reports
SQL Tips & Techniques (Miscellaneous)
ISBN: 1931841454
Author: Konrad King / Kris Jamsa
Publisher: Premier Press, Inc.URL:
Summary:Owning this reference, which covers everything from the components of a table to performing batch updates, is a must! Beginning with tips for the person who is programming with SQL for the first time, SQL Tips and Techniques grows with your skills. You can start with Tip 1, "Understanding the Definition of a Database," and by the last tip, "Displaying Image Data Stored Within a SQL Table," you will have covered all aspects of SQL. Or, you can simply keep this book as a comprehensive reference for answering specific SQL questions quickly. However you read it, this invaluable reference will be the only SQL book you need on your shelf!Download
MySQL and mSQL
Publisher: O'Reilly
Number Of Pages: 500
Publication Date: 1999-08
Sales Rank: 390578
ISBN / ASIN: 1565924347
EAN: 0636920924340
Binding: Paperback
Manufacturer: O'Reilly
Studio: O'Reilly
Average Rating: 3
Total Reviews: 87
ISBN: 1565924347
Number Of Pages: 500
Publication Date: 1999-08
Sales Rank: 390578
ISBN / ASIN: 1565924347
EAN: 0636920924340
Binding: Paperback
Manufacturer: O'Reilly
Studio: O'Reilly
Average Rating: 3
Total Reviews: 87
ISBN: 1565924347
Author: Randy Jay Yarger / Randy Jay Yarger / George Reese / Tim King
Publisher: O'Reilly
URL: /http://www.amazon.com/exec/obidos/redirect?tag=songstech-20&path=ASIN%2F1565924347
Summary:
MySQL and mSQL provides the essentials to programming with these two popular Unix freeware database packages in C/C++, Perl, Python, and Java. The book begins with a fine introduction to databases that covers tables, fields, indexes, and normalization. Then it explains the history of the freeware mSQL and MySQL packages (which offer better performance than commercial relational database management system (RDBMS) packages, though they don't support transactions or other features). Next the authors look at SQL as used within MySQL and mSQL and clarify where to download these packages and how to install them. Examples of how to program with MySQL/mSQL in C/C++ follow.One of the best parts of this book is its introduction to using Common Gateway Interface (CGI) and Perl to power a Web site with a MySQL/mSQL database. This section offers complete information on using mSQL Perl (and the emerging Database Independent [DBI] standard) for developing CGI database scripts in Perl, and it includes clear examples (including a student database). The book then moves from Perl on to other programming languages--Python and Java. Reference material to all the relevant APIs is featured for each language.Whatever programming API you choose, MySQL and mSQL are ready to meet the needs of the small to moderate-size Web site. This book delivers essential information on these packages and will help both Web masters and programmers get the most out of these powerful freeware database tools. --Richard Dragan
DOwnload
DOwnload
No comments:
Post a Comment