Computer Media

SQL is the standard programming language for creating, manipulating, and retrieving information stored in relational databases; most libraries should own one or more guides. SQL Cookbook, a comprehensive source of code samples (or “recipes”) that shows developers how to solve common problems, compares solutions from different database management systems (DBMS), including SQL Server, PostgreSQL, Oracle, MySQL, and DB2. Each recipe contains a problem, a solution (with code samples from each platform), and a brief discussion and range from concatenating column values to searching for mixed alphanumeric strings. A great purchase for all medium and larger libraries as a supplement to basic how-to guides.

The three other titles each target beginners. A good self-study guide, SQL Demystified incorporates chapter quizzes and a “Final Exam” to test mastery. From a basic introduction to relational databases through SQL performance and tuning, Demystifie clearly introduces SQL concepts and points out where implementations on various platforms differ. Its conversational style and clear examples recommend it for all libraries. SQL: Visual QuickStart Guide moves from an overview of various DBMS to how to execute transactions. A nice layout shows both code samples and results, usage differences among DBMS are explained, a companion web site contains sample files, and an appendix lists standard SQL keywords. Clear prose and a sense of humor make this a winner for all libraries. Examples in Learning SQL run on MySQL, Oracle, and SQL Server, but the platform used in the book itself is (the free) MySQL. Coverage ranges from a background on databases to indexes and constraints; step-by-step examples and chapter exercises help readers learn independently. Appropriate for all libraries.

Skype, a free peer-to-peer VoIP (voice over IP) application that allows users to make voice calls over the Internet, is gaining popularity among both individuals and business owners who appreciate its cost effectiveness over traditional telephone service. For beginners to advanced users, Skype Me! contains something for everyone, from installing Skype on a home system to setting up firewalls and networks—plus a look at future devices that may become Skype-enabled. Plentiful screen shots and clear directions help users get up and running quickly, while nicely organized chapters build on previous knowledge and let readers skip directly to the topics they need. This straightforward and thorough guide is appropriate for all medium and larger libraries.

Among its other advantages, PHP, a popular free web programming language, plays quite well with the free MySQL DBMS (see above). For beginners, especially those with experience programming other languages, Spring into PHP 5 breaks down each topic into a one- to two-page unit, illustrating points with examples and screen shots. Code samples are available online, and appendixes cover language elements and provide a function reference table. Very clear, very straightforward, and an excellent basic overview for all libraries. Also for beginners, especially those new to programming in general, SAMS Teach Yourself PHP in 10 Minutes introduces the language in ten-minute lessons that encompass an overview of PHP and what it can do to how to install other developers’ code. Useful for the basics; supplement with more thorough guides. For all PHP programmers, the more thorough PHP in a Nutshell provides a handy developer’s reference, moving from an introduction to PHP to how to improve performance. Oddly, an image manipulation chapter captions the book’s gray-scale illustrations in color, but this is a minor annoyance. Libraries would do well to invest in this owing to its clear explanations, pointers to best practices, and in-depth discussions.

With its focus on developing dynamic web sites with both of the languages in its title, PHP and MySQL makes for a good all-in-one guide for cost-conscious libraries. Its two-column format will aid in comprehension: code and output examples are on one side, and the explanation is on the other. Step-by-step instructions and clear explanations and examples add up to a good self-study choice for beginning to intermediate developers. A companion web site offers code examples and a text file of SQL commands, while appendixes cover installation, reference material, and resources. Highly recommended for all libraries. PHP Phrasebook, part of a new SAMS series of compact code references for beginning to intermediate users, contains reusable code snippets that serve common functions or solve common problems, with brief introductions and discussions. Developers can use the book’s code for routine activities rather than constantly rewriting their own or having to remember how to accomplish each function. This nicely indexed and handy reference is a good supplemental purchase for all libraries.