Definitive Guide to Excel VBA

Definitive Guide to Excel VBA PDF

Author: Michael Kofler

Publisher: Apress

Published: 2008-01-01

Total Pages: 922

ISBN-13: 1430206667

DOWNLOAD EBOOK →

- Kofler's book offers more up-to-date coverage than other books on the market - Provides in-depth coverage of topics normally overlooked, such as the File Scripting Objects, accessing external databases using the ADO library, automating data analysis with pivot tables, and automating diagrams.

The Definitive Guide to MySQL

The Definitive Guide to MySQL PDF

Author: Michael Kofler

Publisher: Apress

Published: 2008-01-01

Total Pages: 802

ISBN-13: 1430206691

DOWNLOAD EBOOK →

This second edition of Michael Kofler's acclaimed MySQL book has updated and expanded to cover MySQL 4.0, the most recent production release of the popular open source database, which boasts more than 4 million users worldwide. Like the first edition, this revision, which has been renamed to reflect the breadth and depth of Kofler's coverage of the topic, provides a thorough introduction to the installation, configuration, implementation, and administration of MySQL. In addition, Kofler demonstrates how you can use MySQL in conjunction with various other technologies to create database-driven websites, and he gives practical advice on database design. Kofler also covers what's coming up next in MySQL 4.1.

The Definitive Guide to MySQL 5

The Definitive Guide to MySQL 5 PDF

Author: Michael Kofler

Publisher: Apress

Published: 2006-11-22

Total Pages: 756

ISBN-13: 1430200715

DOWNLOAD EBOOK →

* MySQL 5, due to be released in summer 2005, is slated to be the most significant release in the product’s history. The Definitive Guide to MySQL 5, Third Edition is the first book to offer in-depth instruction on the new features. * This book shows readers how to connect to MySQL via all of the major APIs, including PHP, Perl, Java, JSP, and C#/. * Novice and intermediate database administrators are introduced to both MySQL’s key features, and crucial database management concepts by way of real-world examples such as discussion forums, online polls, and other data administration projects.

SQL for MySQL Developers

SQL for MySQL Developers PDF

Author: Rick F. van der Lans

Publisher: Pearson Education

Published: 2007-04-20

Total Pages: 1032

ISBN-13: 9780132715898

DOWNLOAD EBOOK →

The Most Complete and Practical Guide to MySQL Version 5’s Powerful SQL Dialect MySQL version 5 offers a SQL dialect with immense power. In SQL for MySQL Developers, Rick F. van der Lans helps you master this version ofSQL and take advantage of its full potential. Using case study examplesand hands-on exercises, van der Lans illuminates every key concept,technique, and statement–including advanced features that make iteasier to create even the most complex statements and programs. Drawing on decades of experience as an SQL standards team member and enterprise consultant, he reveals exactly why MySQL’s dialect 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, Web developer, analyst, DBA, or database user, this book can take you from “apprentice” to true SQL expert. If you’ve used SQL in older versions of MySQL, you’ll become dramatically more effective–and if you’re migrating from other database platforms, you’ll gain practical mastery fast.

Learning MySQL

Learning MySQL PDF

Author: Seyed Tahaghoghi

Publisher: "O'Reilly Media, Inc."

Published: 2007-11-28

Total Pages: 620

ISBN-13: 0596008643

DOWNLOAD EBOOK →

This new book in the popular Learning series offers an easy-to-use resource for newcomers to the MySQL relational database. This tutorial explains in plain English how to set up MySQL and related software from the beginning, and how to do common tasks.

MySQL Reference Manual

MySQL Reference Manual PDF

Author: Michael Widenius

Publisher: "O'Reilly Media, Inc."

Published: 2002

Total Pages: 822

ISBN-13: 9780596002657

DOWNLOAD EBOOK →

This comprehensive reference guide offers useful pointers for advanced use of SQL and describes the bugs and workarounds involved in compiling MySQL for every system.

Head First PHP & MySQL

Head First PHP & MySQL PDF

Author: Lynn Beighley

Publisher: "O'Reilly Media, Inc."

Published: 2009

Total Pages: 812

ISBN-13: 0596006306

DOWNLOAD EBOOK →

With this book, Web designers who usually turn out static Websites with HTML and CSS can make the leap to the next level of Web development--full-fledged, dynamic, database-driven Websites using PHP and SQL.

MySQL in a Nutshell

MySQL in a Nutshell PDF

Author: Russell J.T. Dyer

Publisher: "O'Reilly Media, Inc."

Published: 2008-04-15

Total Pages: 568

ISBN-13: 1449379370

DOWNLOAD EBOOK →

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.

Expert MySQL

Expert MySQL PDF

Author: Charles Bell

Publisher: Apress

Published: 2007-04-01

Total Pages: 601

ISBN-13: 1430203463

DOWNLOAD EBOOK →

MySQL remains one of the hottest open source database technologies. As the database has evolved into a product competitive with proprietary counterparts like Oracle and IBM DB2, MySQL has found favor with large scale corporate users who require high-powered features and performance. Expert MySQL is the first book to delve deep into the MySQL architecture, showing users how to make the most of the database through creation of custom storage handlers, optimization of MySQL's query execution, and use of the embedded server product. This book will interest users deploying MySQL in high-traffic environments and in situations requiring minimal resource allocation.

MySQL and MSQL

MySQL and MSQL PDF

Author: Randy Jay Yarger

Publisher: O'Reilly Media

Published: 1999

Total Pages: 522

ISBN-13:

DOWNLOAD EBOOK →

A guide to the SQL-based database applications covers installation, configuration, interfaces, and administration.