General Books

PHP and MySQL Web Development (4th Edition) (Developer's Library)

Luke Welling, Laura Thomson

Amazon Price: $31.49 List Price: $49.99 Usually ships in 24 hours By: Addison-Wesley Professional Amazon Marketplace: 49 new & used starting at $24.99

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Databases -> Database Design
Subjects -> Computers & Internet -> Databases -> Specific Databases -> MySQL & mSQL
Subjects -> Computers & Internet -> Databases -> SQL -> General

Customer Reviews:
Total reviews: 178 Average rating: 4.5 of 5

Editorial Review:

The PHP server-side scripting language and the MySQL database management system (DBMS) make a potent pair. Both are open-source products--free of charge for most purposes--remarkably strong, and capable of handling all but the most enormous transaction loads. Both are supported by large, skilled, and enthusiastic communities of architects, programmers, and designers. PHP and MySQL Web Development introduces readers (who are assumed to have little or no experience with the title subjects) to PHP and MySQL for the purpose of creating dynamic Internet sites. It teaches the same skills as introductory Active Server Pages (ASP) and ColdFusion books--technologies that address the same niche.

Authors Luke Welling and Laura Thomson's technique aims to get readers going on their own projects as soon as possible. They present easily digestible sections on specific technical processes--"Accessing array contents" and "Using encryption with PHP" are two examples. Each section centers on a sample program that strips the task at hand down to its essentials, enabling the reader to fit the process into his or her own solutions as required. Tables that list options and other nuggets of reference material appear as well, but the many examples and the authors' commentary on them take center stage.

For reference material on MySQL, have a look at Paul DuBois's MySQL. On the PHP side, Web Application Development with PHP 4.0 is excellent. --David Wall

Topics covered:

• The MySQL database server (for both Unix and Windows)
• Accessing MySQL databases through PHP scripting (the letters don't really stand for anything)
• Database creation and modification
• PHP tricks in order of increasing complexity--everything from basic SQL queries to secure transactions for commerce
• Authentication
• Network connectivity
• Session management
• Content customization

Access 2007: The Missing Manual

Matthew MacDonald

Amazon Price: $23.09 List Price: $34.99 Usually ships in 24 hours By: Pogue Press Amazon Marketplace: 45 new & used starting at $18.00

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Databases -> Database Design
Subjects -> Computers & Internet -> Databases -> SQL -> General
Subjects -> Computers & Internet -> Databases -> SQL -> General AAS

Customer Reviews:
Total reviews: 15 Average rating: 4.5 of 5

Editorial Review:

Compared to industrial-strength database products such as Microsoft's SQL Server, Access is a breeze to use. It runs on PCs rather than servers and is ideal for small- to mid-sized businesses and households. But Access is still intimidating to learn. It doesn't help that each new version crammed in yet another set of features; so many, in fact, that even the pros don't know where to find them all. Access 2007 breaks this pattern with some of the most dramatic changes users have seen since Office 95. Most obvious is the thoroughly redesigned user interface, with its tabbed toolbar (or "Ribbon") that makes features easy to locate and use. The features list also includes several long-awaited changes. One thing that hasn't improved is Microsoft's documentation. To learn the ins and outs of all the features in Access 2007, Microsoft merely offers online help.

Access 2007: The Missing Manual was written from the ground up for this redesigned application. You will learn how to design complete databases, maintain them, search for valuable nuggets of information, and build attractive forms for quick-and-easy data entry. You'll even delve into the black art of Access programming (including macros and Visual Basic), and pick up valuable tricks and techniques to automate common tasks -- even if you've never touched a line of code before. You will also learn all about the new prebuilt databases you can customize to fit your needs, and how the new complex data feature will simplify your life. With plenty of downloadable examples, this objective and witty book will turn an Access neophyte into a true master.

PHP 6 and MySQL 5 for Dynamic Web Sites: Visual QuickPro Guide

Larry Ullman

Amazon Price: $26.39 List Price: $39.99 Usually ships in 24 hours By: Peachpit Press Amazon Marketplace: 54 new & used starting at $24.42

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Databases -> Database Design
Subjects -> Computers & Internet -> Databases -> Specific Databases -> MySQL & mSQL
Subjects -> Computers & Internet -> Databases -> SQL -> General

Customer Reviews:
Total reviews: 137 Average rating: 4.5 of 5

Editorial Review:

It hasn't taken Web developers long to discover that when it comes to creating dynamic, database-driven Web sites, MySQL and PHP provide a winning open source combination. Add this book to the mix, and there's no limit to the powerful, interactive Web sites that developers can create. With step-by-step instructions, complete scripts, and expert tips to guide readers, veteran author and database designer Larry Ullman gets right down to business: After grounding readers with separate discussions of first the scripting language (PHP) and then the database program (MySQL), he goes on to cover security, sessions and cookies, and using additional Web tools, with several sections devoted to creating sample applications. This guide is indispensable for intermediate- to advanced level Web designers who want to replace their static sites with something dynamic. In this edition, the bulk of the new material covers the latest versions of both technologies: PHP 6 (due out in 2008) and MySQL 5 (available now). The book's publication date is likely to beat the official release of PHP 6, making it one of the first books available on the subject.

Sams Teach Yourself SQL in 10 Minutes (3rd Edition) (Sams Teach Yourself)

Ben Forta

Amazon Price: $13.59 List Price: $19.99 Usually ships in 24 hours By: Sams Amazon Marketplace: 62 new & used starting at $9.90

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Databases -> Database Management Systems
Subjects -> Computers & Internet -> Databases -> Relational Databases
Subjects -> Computers & Internet -> Databases -> SQL -> General

Customer Reviews:
Total reviews: 140 Average rating: 4.5 of 5

Precisely what it promises to be: an introduction to SQL 5 out of 5 stars.
0 of 0 people found this review helpful.

Ben Forta has a commendable honesty about him. He explains the intent of his books clearly in their Introductions and then proceeds to deliver just that. In this instance, Forta is clear that the book is for those new to SQL and who quickly want to learn how to get the most out of SQL. He is equally clear that the book does not cover every last aspect of SQL.

The book is becoming a bit long in tooth since it has not been updted since 2004. DBMSs covered are IBM DB2, Microsoft Access, Microsoft SQL Server, MySQL (Version 4), Oracle, PostgreSQL, Sybase Adaptive Server. Some of the information is now outdated and MySQL v5 has added new capabilities. On the whole, though, everything Forta presents here is still usable.

In 22 chapters, Forta teaches the reader the basics of SQL, more than enough to deal with perhaps 80% or more of common SQL requirements. Beyond that and you're in the realm of system architects and administrators who are simply not the audience for this book.

Be sure to download the sample databases and errata from the author's website.

On the whole, one of the best introductions to SQL available.

Jerry

Editorial Review:

Sams Teach Yourself SQL in 10 Minutes has established itself as the gold standard for introductory SQL books, offering a fast-paced accessible tutorial to the major themes and techniques involved in applying the SQL language. Forta's examples are clear and his writing style is crisp and concise. As with earlier editions, this revision includes coverage of current versions of all major commercial SQL platforms. New this time around is coverage of MySQL, and PostgreSQL. All examples have been tested against each SQL platform, with incompatibilities or platform distinctives called out and explained.

High Performance MySQL: Optimization, Backups, Replication, and More

Baron Schwartz, Peter Zaitsev, Vadim Tkachenko, Jeremy Zawodny, Arjen Lentz, Derek Balling

Amazon Price: $31.49 List Price: $49.99 Usually ships in 24 hours By: O'Reilly Media, Inc. Amazon Marketplace: 40 new & used starting at $30.19

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Computer Science -> Modeling & Simulation
Subjects -> Computers & Internet -> Databases -> Database Design
Subjects -> Computers & Internet -> Databases -> Specific Databases -> MySQL & mSQL

Customer Reviews:
Total reviews: 8 Average rating: 5.0 of 5

Editorial Review:

High Performance MySQL is the definitive guide to building fast, reliable systems with MySQL. Written by noted experts with years of real-world experience building very large systems, this book covers every aspect of MySQL performance in detail, and focuses on robustness, security, and data integrity. High Performance MySQL teaches you advanced techniques in depth so you can bring out MySQL's full power. Learn how to design schemas, indexes, queries and advanced MySQL features for maximum performance, and get detailed guidance for tuning your MySQL server, operating system, and hardware to their fullest potential. You'll also learn practical, safe, high-performance ways to scale your applications with replication, load balancing, high availability, and failover. This second edition is completely revised and greatly expanded, with deeper coverage in all areas. Major additions include: Emphasis throughout on both performance and reliability Thorough coverage of storage engines, including in-depth tuning and optimizations for the InnoDB storage engine Effects of new features in MySQL 5.0 and 5.1, including stored procedures, partitioned databases, triggers, and views A detailed discussion on how to build very large, highly scalable systems with MySQL New options for backups and replication Optimization of advanced querying features, such as full-text searches Four new appendices The book also includes chapters on benchmarking, profiling, backups, security, and tools and techniques to help you measure, monitor, and manage your MySQL installations.

Mastering Regular Expressions

Jeffrey Friedl

Amazon Price: $29.69 List Price: $44.99 Usually ships in 24 hours By: O'Reilly Media, Inc. Amazon Marketplace: 52 new & used starting at $22.99

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Computer Science -> General
Subjects -> Computers & Internet -> Computer Science -> General AAS
Subjects -> Computers & Internet -> Databases -> Specific Databases -> MySQL & mSQL

Customer Reviews:
Total reviews: 125 Average rating: 4.5 of 5

Very in-depth 4 out of 5 stars.
0 of 0 people found this review helpful.

Quite a comprehensive guide to regular expressions. Gets very detailed in the areas that it covers. However, definitely not a 'beginner's guide'. I highly recommend that you are already comfortable with the basis of regular expressions before picking up this book. You will get way more out of it if this is not your first introduction to it. Comfort and proficiency with Perl would also be a big help. Title is correct though, this is a guide to 'mastering' regular expressions, not learning them from the beginning.

Editorial Review:

Regular expressions are a central element of UNIX utilities like egrep and programming languages such as Perl. But whether you're a UNIX user or not, you can benefit from a better understanding of regular expressions since they work with applications ranging from validating data-entry fields to manipulating information in multimegabyte text files. Mastering Regular Expressions quickly covers the basics of regular-expression syntax, then delves into the mechanics of expression-processing, common pitfalls, performance issues, and implementation-specific differences. Written in an engaging style and sprinkled with solutions to complex real-world problems, Mastering Regular Expressions offers a wealth information that you can put to immediate use.

MCTS Self-Paced Training Kit (Exam 70-431): Microsoft SQL Server 2005 Implementation and Maintenance (Pro-Certification)

Solid Quality Learning

Amazon Price: $37.79 List Price: $59.99 Usually ships in 24 hours By: Microsoft Press - Model: 0-7356-2271-X Amazon Marketplace: 41 new & used starting at $31.97

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Certification Central -> Publisher -> Microsoft Press
Subjects -> Computers & Internet -> Certification Central -> MS SQL Server
Subjects -> Computers & Internet -> Certification Central -> General

Customer Reviews:
Total reviews: 40 Average rating: 4.0 of 5

Editorial Review:

Announcing an all-new MCTS Training Kit designed to help maximize your performance on Exam 70-431, a core exam for the new Microsoft IT Professional certifications. This kit packs the tools and features that exam candidates want most—including in-depth, self-paced training based on final exam content; rigorous, objective-by-objective review; exam tips from expert, exam-certified authors; and a robust testing suite. It also provides real-world scenarios, case study examples, and troubleshooting labs for skills and expertise that you can apply to the job.

Focusing on SQL Server 2005, this official study guide covers topics such as installing and configuring SQL Server, implementing database mirroring, managing database snapshots, working with XML and flat files, managing replication, backing up and restoring a database, monitoring and troubleshooting, and creating and implementing database objects.

Ace your exam preparation and ramp up quickly on SQL Server 2005 database administration by working at your own pace through the lessons, hands-on exercises, and practice tests. The flexible, best-of-class test engine on CD features 300 practice questions and pre-assessment and post-assessment capabilities. Choose timed or untimed testing mode, generate random tests, or focus on discrete objectives or chapters, and get detailed explanations for right and wrong answers—including pointers back to the book for further study. You also get a 180-day evaluation version of SQL Server 2005 Enterprise Edition and a 15 percent exam discount voucher—making this kit an exceptional value and a great career investment.

Microsoft SQL Server 2005 Unleashed

Ray Rankins, Paul Bertucci, Chris Gallelli, Alex T. Silverstein

Amazon Price: $37.79 List Price: $59.99 Usually ships in 24 hours By: Sams Amazon Marketplace: 57 new & used starting at $29.98

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Databases -> Database Management Systems
Subjects -> Computers & Internet -> Databases -> Relational Databases
Subjects -> Computers & Internet -> Databases -> SQL -> General

Customer Reviews:
Total reviews: 16 Average rating: 5.0 of 5

Editorial Review:

<>Microsoft SQL Server 2005 Unleashed offers comprehensive coverage of SQL Server 2005 that goes beyond the basic syntax and information you’ll find in the product manuals, providing in-depth information derived from the authors’ real-world experience to help you build upon your working knowledge of the product and take your experience and knowledge to a higher level. This book focuses primarily on the information needed by system and database administrators, as well as for users with overlapping duties as both DBA and developer. Included is extensive coverage of the new features and upgraded tools and capabilities of SQL Server 2005, including .NET Framework integration, Integration Services, Service Broker, Database Mirroring and Snapshots, and Reporting Services.

Detailed information on…

• Installing, upgrading, and administering SQL Server 2005
• Database maintenance, backup, and recovery
• Creating and managing tables, views, stored procedures, triggers, and user-defined functions
• Database and index design
• SQL Server query optimization, and performance monitoring and tuning
• Transactions, transaction management, and distributed transactions
• SQL Server Management Studio—NEW!
• SQL Server Notification Services; Integration Services—NEW!; Analysis Services; Reporting Services—NEW!; Web Services—NEW!
• SQL Server Service Broker—NEW!
• SQL Server and Microsoft .NET Framework integration, including CLR-based stored procedures, functions, and triggers—NEW!
• SQL Server high availability and SQL Server clustering and replication
• Database Mirroring—NEW!
• Database Snapshots—NEW!
• Using XML in SQL Server 2005
• SQL Server tools and utilities

CD-ROM includes

• 8 bonus chapters covering topics such as Notification Services, Service Broker, and Full-Text Search
• Code samples, scripts, and sample databases
• A PDF version of the entire book

Introduction

Part I Welcome to Microsoft SQL Server

1 SQL Server 2005 Overview

2 What’s New in SQL Server 2005

Part II SQL Server Tools and Utilities

3 SQL Server Management Studio

4 SQL Server Command-Line Utilities

5 SQL Server Profiler

Part III SQL Server Administration

6 SQL Server System and Database Administration

7 Installing SQL Server 2005

8 Upgrading to SQL Server 2005

9 Client Installation and Configuration

10 Security and User Administration

11 Database Backup and Restore

12 Database Mail

13 SQL Server Scheduling and Notification

14 SQL Server High Availability.

15 Replication

16 Database Mirroring

17 SQL Server Clustering

Part IV Database Administration

18 Creating and Managing Databases

19 Creating and Managing Tables

20 Creating and Managing Indexes

21 Implementing Data Integrity

22 Creating and Managing Views in SQL Server

23 Creating and Managing Stored Procedures

24 Creating and Managing User-Defined Functions

25 Creating and Managing Triggers

26 Transaction Management and the Transaction Log

27 Database Snapshots

28 Database Maintenance

Part V SQL Server Performance and Optimization

29 Indexes and Performance

30 Understanding Query Optimization

31 Query Analysis

32 Locking and Performance

33 Database Design and Performance

34 Monitoring SQL Server Performance

Part VI SQL Server Application Development

35 What’s New for Transact-SQL in SQL Server 2005

36 SQL Server and the .NET Framework

37 Using XML in SQL Server 2005

38 SQL Server Web Services

Part VII SQL Server Business Intelligence Features

39 SQL Server 2005 Analysis Services

40 SQL Server Integration Services

41 SQL Server 2005 Reporting Services

Bonus Chapters on the CD

42 Managing Linked and Remote Servers

43 Configuring, Tuning, and Optimizing SQL Server Options

44 Administering Very Large SQL Server Databases

45 SQL Server Disaster Recovery Planning

46 Transact-SQL Programming Guidelines, Tips, and Tricks

47 SQL Server Notification Services

48 SQL Server Service Broker

49 SQL Server Full-Text Search

Index

Beginning PHP and MySQL: From Novice to Professional, Third Edition (Beginning from Novice to Professional)

W. Jason Gilmore

Amazon Price: $31.01 List Price: $46.99 Usually ships in 24 hours By: Apress Amazon Marketplace: 47 new & used starting at $20.78

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Databases -> Database Design
Subjects -> Computers & Internet -> Databases -> Specific Databases -> MySQL & mSQL
Subjects -> Computers & Internet -> Databases -> Beginning & Introductory

Customer Reviews:
Total reviews: 100 Average rating: 4.0 of 5

Editorial Review:

Beginning PHP and MySQL: From Novice to Professional, Third Edition offers a comprehensive introduction to two of the most prominent open source technologies on the planet: the PHP scripting language and the MySQL database server. Updated to introduce the features found in MySQLs most significant release to date, readers learn how to take advantage of the latest features of both technologies to build powerful, manageable, and stable web applications.

Essentially three books in one, readers not only profit from extensive introductions to the core features of each technology, but also learn how to effectively integrate the two in order to build robust data-driven applications. Packed with practical examples and insight into the real-world challenges faced by developers based on author W. Jason Gilmore's 7 years of expertise working with these technologies, readers will repeatedly return to this book as both a valuable instructional tool and reference guide.

What youll learn

• The PHP language
• How to back your web site with MySQL
• Templating so that you can apply a consistent design across all pages on your site
• How to authenticate your web site users
• How to use cookies to maintain information (such as items in a shopping cart) while a user is browsing your site

Who is this book for?

This book is written for developers seeking to take advantage of the PHP language and MySQL database to create powerful web applications.

About the Apress Beginning Series

The Beginning series from Apress is the right choice to get the information you need to land that crucial entry-level job. These books will teach you a standard and important technology from the ground up because they are explicitly designed to take you from "novice to professional." Youll start your journey by seeing what you need to knowbut without needless theory and filler. Youll build your skill set by learning how to put together real-world projects step by step. So whether your goal is your next career challenge or a new learning opportunity, the Beginning series from Apress will take you thereit is your trusted guide through unfamiliar territory!

Microsoft SQL Server 2005 Reporting Services 2005

Brian Larson

Amazon Price: $31.49 List Price: $49.99 Usually ships in 24 hours By: McGraw-Hill Osborne Media Amazon Marketplace: 45 new & used starting at $24.52

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Databases -> Database Management Systems
Subjects -> Computers & Internet -> Databases -> SQL -> General
Subjects -> Computers & Internet -> Databases -> SQL -> General AAS

Customer Reviews:
Total reviews: 46 Average rating: 4.0 of 5

Save your money.... 1 out of 5 stars.
1 of 2 people found this review helpful.

There's obviously 2 versions of this book: Version 1 uses the Adventureworks data; Version 2 uses Galactic Shipping data.....Installing the Galactic database and info is IMPOSSIBLE!!! Make sure you get the first version or you will truly be sorry (like I am!!!)....Other than that, the book is great.....but finding the download and installing it is truly more trouble than it's worth.......BEWARE!!!

Sql server 2005 Reportin Service, Brian Larson 1 out of 5 stars.
0 of 2 people found this review helpful.

SAVE YOUR MONEY!!! This is a book seems to be targetting retarded. There is a chapter on datbase concepts - if some one does not know, it is unlikely they will be reading reporting services. Too much fluff and descriptions are buried in the fluff. If you skip the fluff, you may find yourself difficult to connect dots. Too much details on formatting fonts, colors which is completly useless.

Editorial Review:

Microsoft's Reporting Services product is a vital part of the SQL Server 2005 business intelligence platform, but it works with virtually any data source. This hands-on guide explains how to transform data into insightful and interactive Web-based reports using Microsoft SQL Server 2005 Reporting Services. With coverage of everything from installation to administration, the book demonstrates how to use this powerful server-based reporting solution to improve business decision-making and facilitate company-wide -- even worldwide -- communication.