SQL Books - Page 4

Web Database Applications with PHP & MySQL, 2nd Edition

Hugh E. Williams

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

Buy at Amazon.com

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

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

Editorial Review:

There are many reasons for serving up dynamic content from a web site:to offer an online shopping site, create customized information pages for users, or just manage a large volume of content through a database. Anyone with a modest knowledge of HTML and web site management can learn to create dynamic content through the PHP programming language and the MySQL database. This book gives you the background and tools to do the job safely and reliably.

Web Database Applications with PHP and MySQL, Second Edition thoroughly reflects the needs of real-world applications. It goes into detail on such practical issues as validating input (do you know what a proper credit card number looks like?), logging in users, and using templates to give your dynamic web pages a standard look.

But this book goes even further. It shows how JavaScript and PHP can be used in tandem to make a user's experience faster and more pleasant. It shows the correct way to handle errors in user input so that a site looks professional. It introduces the vast collection of powerful tools available in the PEAR repository and shows how to use some of the most popular tools.

Even while it serves as an introduction to new programmers, the book does not omit critical tasks that web sites require. For instance, every site that allows updates must handle the possibility of multiple users accessing data at the same time. This book explains how to solve the problem in detail with locking.

Through a sophisticated sample application--Hugh and Dave's Wine Store--all the important techniques of dynamic content are introduced. Good design is emphasized, such as dividing logic from presentation. The book introduces PHP 5 and MySQL 4.1 features, while providing techniques that can be used on older versions of the software that are still in widespread use.

This new edition has been redesigned around the rich offerings of PEAR. Several of these, including the Template package and the database-independent query API, are fully integrated into examples and thorougly described in the text. Topics include: Installation and configuration of Apache, MySQL, and PHP on Unix®, Windows®, and Mac OS® X systems Introductions to PHP, SQL, and MySQL administration Session management, including the use of a custom database for improved efficiency User input validation, security, and authentication The PEAR repository, plus details on the use of PEAR DB and Template classes Production of PDF reports

The Manga Guide to Databases

Mana Takahashi, Shoko Azuma, Trend-pro Ltd.

Amazon Price: $13.57 List Price: $19.95 Usually ships in 24 hours By: No Starch Press Amazon Marketplace: 4 new & used starting at $13.57

Buy at Amazon.com

Browse similar items by category:
Subjects -> Arts & Photography -> General
Subjects -> Arts & Photography -> General AAS
Subjects -> Comics & Graphic Novels -> Comic Strips -> General

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

Editorial Review:

Want to learn about databases without the tedium? With its unique combination of Japanese-style comics and serious educational content, The Manga Guide to Databases is just the book for you.

Princess Ruruna is stressed out. With the king and queen away, she has to manage the Kingdom of Kod's humongous fruit-selling empire. Overseas departments, scads of inventory, conflicting prices, and so many customers! It's all such a confusing mess. But a mysterious book and a helpful fairy promise to solve her organizational problems-with the practical magic of databases.

In The Manga Guide to Databases, Tico the fairy teaches the Princess how to simplify her data management. We follow along as they design a relational database, understand the entity-relationship model, perform basic database operations, and delve into more advanced topics. Once the Princess is familiar with transactions and basic SQL statements, she can keep her data timely and accurate for the entire kingdom. Finally, Tico explains ways to make the database more efficient and secure, and they discuss methods for concurrency and replication.

Examples and exercises (with answer keys) help you learn, and an appendix of frequently used SQL statements gives the tools you need to create and maintain full-featured databases.

(Of course, it wouldn't be a royal kingdom without some drama, so read on to find out who gets the girl-the arrogant prince or the humble servant.)

This EduManga book is a translation of a bestselling series in Japan, co-published with Ohmsha, Ltd., of Tokyo, Japan.

Beginning SQL Server 2005 Administration

Dan Wood, Chris Leiter, Paul Turley

Amazon Price: $26.39 List Price: $39.99 Usually ships in 24 hours By: Wrox Amazon Marketplace: 41 new & used starting at $21.31

Buy at Amazon.com

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

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

Editorial Review:

For the first time, SQL Server 2005 provides features that can support large-scale enterprise databases. With this powerful new release, you may find yourself being called upon to perform duties that are no longer strictly "administrative," duties that have become much more complicated and difficult. With that in mind, a team of experienced Microsoft Certified Professionals provides you with the necessary information to be a more competent and successful database developer or administrator.

Beginning with a foundation that features detailed coverage of typical administrative duties, the authors proceed to explain how to build complex data transformations for data import, build distributed data solutions, and maintain the security and integrity of the database. You will be able to apply what you learn to real-world scenarios, and smoothly navigate the vastly changed landscape of SQL Server 2005 administration.

What you will learn from this book

• How to install, maintain, and manage an SQL Server 2005 installation, including high availability and security considerations
• Various features such as the Common Language Runtime, SQL Server Integration Services, Notification Service, and the Service Broker
• How to use the tools that are necessary to manage configuration, backups, restores, security, availability, performance, and monitoring
• A sampling of some of the more advanced areas and complex jobs of the broadening role of a database administrator in the enterprise

Who this book is for

This book is for both developers and administrators who are responsible for the management and maintenance of an SQL Server 2005 database. Familiarity with relational database concepts and SQL is assumed.

Wrox Beginning guides are crafted to make learning programming languages and technologies easier than you think, providing a structured, tutorial format that will guide you through all the techniques involved.

Enhance Your Knowledge Advance Your Career

MySQL Crash Course (Sams Teach Yourself in 10 Minutes)

Ben Forta

Amazon Price: $16.49 List Price: $24.99 Usually ships in 24 hours By: Sams Amazon Marketplace: 51 new & used starting at $12.00

Buy at Amazon.com

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

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

Editorial Review:

MySQL is one of the most popular database management systems available, powering everything from Internet powerhouses to individual corporate databases to simple end-user applications, and everything in between. And this book will teach you all you need to know to be immediately productive with MySQL. By working through 30 highly focused hands-on lessons, your MySQL Crash Course will be both easier and more effective than you'd have thought possible. Learn how to:

• Retrieve and sort data
• Filter data using comparisons, regular expressions, full text search, and much more
• Join relational data
• Create and alter tables
• Insert, update, and delete data
• Leverage the power of stored procedures and triggers
• Use views and Cursors
• Manage transactional processing
• Create user accounts and manage security via access control

Ben Forta is Macromedia's Senior Technical Evangelist, and has almost 20 years of experience in the computer industry in product development, support, training, and product marketing. Ben is the author of the best-selling Sams Teach Yourself SQL in 10 Minutes (now in its third edition, and translated into over a dozen languages), ColdFusion Web Application Construction Kit, and Advanced ColdFusion Development (both published by Que Publishing), Sams Teach Yourself Regular Expressions in 10 Minutes, as well as books on SQL, Flash, JSP, HomeSite, WAP, Windows 2000, and other subjects.

SQL Pocket Guide (Pocket References)

Jonathan Gennick

Amazon Price: $10.19 List Price: $14.99 Usually ships in 24 hours By: O'Reilly Media, Inc. Amazon Marketplace: 48 new & used starting at $8.00

Buy at Amazon.com

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

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

Editorial Review:

SQL is the language of databases. It's used to create and maintain database objects, place data into those objects, query the data, modify the data, and, finally, delete data that is no longer needed. Databases lie at the heart of many, if not most business applications. Chances are very good that if you're involved with software development, you're using SQL to some degree. And if you're using SQL, you should own a good reference or two.

Now available in an updated second edition, our very popular "SQL Pocket Guide" is a major help to programmers, database administrators, and everyone who uses SQL in their day-to-day work. The "SQL Pocket Guide" is a concise reference to frequently used SQL statements and commonly used SQL functions. Not just an endless collection of syntax diagrams, this portable guide addresses the language's complexity head on and leads by example. The information in this edition has been updated to reflect the latest versions of the most commonly used SQL variants including:

Oracle Database 10g, Release 2 (including

the free Oracle Database 10g Express Edition (XE))

Microsoft SQL Server 2005

MySQL 5

IBM DB2 8.2

PostreSQL 8.1 database

Microsoft® SQL Server® 2008 T-SQL Fundamentals (PRO-Developer)

Itzik Ben-gan

Amazon Price: $31.49 List Price: $49.99 Usually ships in 24 hours By: Microsoft Press Amazon Marketplace: 42 new & used starting at $25.97

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: 2 Average rating: 5.0 of 5

Editorial Review:

This book walks you through your first steps in T-SQL (also known as Transact-SQL), which is Microsoft SQL Server s dialect of the standard ANSI-SQL language. You ll learn the theory behind T-SQL querying and programming, how to develop T-SQL code to query and modify data, and get an overview of programmable objects. Although this book is intended for beginners, it is not merely a step-by-step book. It goes beyond the syntactical elements of T-SQL and explains the logic behind the language and its elements. Many aspects of SQL are unique to the language, and are very different from other programming languages. This book helps you adopt the right state of mind and gain a true understanding of the language elements. You learn how to think in terms of sets and follow good SQL programming practices. The book is not version-specific; it does, however, cover language elements that were introduced in recent versions of SQL Server, including SQL Server 2008. To complement the learning experience, the book provides exercises that enable you to practice what you ve learned. The book starts with a theoretical background to T-SQL querying and programming (Chapter 1) laying the foundations for the rest of the book, and also coverage of creating tables and defining data integrity. The book moves on to various aspects of querying and modifying data (Chapters 2 through 8), then to a discussion of concurrency and transactions (Chapter 9), and finally provides an overview of programmable objects (Chapter 10). This book features a companion Web site that makes available to you all the code used in the book, the errata, additional resources, and more.

A Guide to SQL

Philip J. Pratt, Mary Z. Last

Amazon Price: $57.95 List Price: $62.95 Usually ships in 24 hours By: Course Technology Amazon Marketplace: 20 new & used starting at $51.22

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Computer Science -> Software Engineering -> Information Systems
Subjects -> Computers & Internet -> Databases -> Database Management Systems
Subjects -> Computers & Internet -> Databases -> SQL -> General

Customer Reviews:
Total reviews: 12 Average rating: 3.0 of 5

great service not so great book 2 out of 5 stars.
0 of 0 people found this review helpful.

The delivery service for this book was excellent..no doubt about that. The book itself was confusing to navigate through, and it lacks material

Excellent for beginners 5 out of 5 stars.
0 of 0 people found this review helpful.

I have used several editions of this book with nary a complaint from students. The book uses real, honest-to-goodness, standard SQL. SQL is a standardized language, but the 900 lb. gorillas in the market like Oracle and Microsoft refuse to follow the standard. If you use some flavor of Microsoft Jet SQL or Oracle, this book will be of use, but will not teach you all of the "extensions" that the big SQL players have made in their proprietary versions of SQL. Still, pretty much all of the code in this book will run, even from the bone-headed SQL prompt in Microsoft Access!

As other reviewers have noted, this is not a general DBMS book, although good design principles are followed. If you want a relatively short and comprehensive introduction to DBMS, I recommend Pratt and Adamski's _Concepts of Database Management_ 6th ed. There are many outstanding DBMS books out there, but Pratt and Adamski is the arguably the briefest. The chapters on normalization are very good--very practical with very little set theory. I regard database design as little more than applied set theory, and if your set theory is weak, Pratt and Adamski is the book for you.

Editorial Review:

A GUIDE TO SQL, 8E, illustrates the basics of SQL programming using straightforward instruction and extensive hands-on exercises. Phil Pratt and Mary Last continue to present basic SQL commands in a business context using Oracle. A new running case, for a total of three, presents lessons in a real-world context for managing orders, parts, customers, and sales reps. The text provides hands-on projects at the end of each chapter, including review questions, running cases, and extensive exercises, providing students with the opportunity to solve problems and apply skills from each chapter.

LINQ in Action

Fabrice Marguerie, Steve Eichert, Jim Wooley

Amazon Price: $29.69 List Price: $44.99 Usually ships in 24 hours By: Manning Publications Amazon Marketplace: 43 new & used starting at $24.77

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Databases -> SQL -> General
Subjects -> Computers & Internet -> Databases -> SQL -> General AAS
Subjects -> Computers & Internet -> Microsoft -> Development -> Visual Basic -> General AAS

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

Editorial Review:

LLINQ, Language INtegrated Query, is a new extension to the Visual Basic and C# programming languages designed to simplify data queries and database interaction. It addreses O/R mapping issues by making query operations like SQL statements part of the programming language. It also offers built-in support for querying in-memory collections like arrays or lists, XML, DataSets, and relational databases.

LINQ in Action is a fast-paced, comprehensive tutorial for professional developers. This book explores what can be done with LINQ, shows how it works in an application, and addresses the emerging best practices. It presents the general purpose query facilities offered by LINQ in the upcoming C# 3.0 and VB.NET 9.0 languages. A running example introduces basic LINQ concepts. You'll then learn to query unstructured data using LINQ to XML and relational data with LINQ to SQL. Finally, you'll see how to extend LINQ for custom applications.

LINQ in Action will guide you along as you explore this new world of lambda expressions, query operators, and expression trees. As well, you'll explore the new features of C# 3.0, VB.NET 9.0. The book is very practical, anchoring each new idea with running code. Whether you want to use LINQ to query objects, XML documents, or relational databases, you will find all the information you need to get started

But LINQ in Action does not stop at the basic code. This book also shows you how LINQ can be used for advanced processing of data, including coverage of LINQ's extensibility, which allows querying more data sources than those supported by default. All code samples are built on a concrete business case. The running example, LinqBooks, is a personal book cataloging system that shows you how to create LINQ applications with Visual Studio 2008.

Accelerated SQL Server 2008

Rob Walters, Michael Coles, Fabio Claudio Ferracchiati, Robert Rae, Donald Farmer

Amazon Price: $33.38 List Price: $52.99 Usually ships in 24 hours By: Apress Amazon Marketplace: 42 new & used starting at $22.00

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: 3 Average rating: 4.5 of 5

Editorial Review:

The expert tuition and approach to rapid learning in Accelerated SQL Server 2008, one of the first SQL Server 2008 books available, will enable SQL Server and other database professionals to make the leap to the latest release of Microsoft’s flagship database management system quickly. Take full advantage of the new features of SQL Server 2008, know what tools are available, and quickly realize the power and ease of use that SQL Server 2008 has to offer.

• Lightning–quick introduction to SQL Server 2008
• Written by top experts in the field
• Provides a solid grounding in key features and technologies

What you’ll learn

• Manage SQL Server installations through the brand–new Declarative Management Framework.
• Protect yourself from downtime with high–availability features such as failover clustering.
• Speed your applications by taking advantage of new performance–enhancement features in SQL Server 2008.
• Find what you need using full–text search.
• Store, retrieve, and manage XML in the database.
• Derive competitive advantage from business intelligence tools such as Analysis Services and Reporting Services.

Who is this book for?

Database professionals who need to make the leap to SQL Server 2008, and who need to make that leap quickly. This audience primarily includes users of previous releases of SQL Server such as SQL Server 2000 and SQL Server 2005. The audience also includes database professionals with experience on competing platforms who are moving laterally to SQL Server.

MySQL Cookbook

Paul DuBois

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

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 -> Data Mining

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

Editorial Review:

Along with MySQL's popularity has come a flood of questions about solving specific problems, and that's where this Cookbook is essential. Designed as a handy resource when you need quick solutions or techniques, the book offers dozens of short, focused pieces of code and hundreds of worked-out examples for programmers of all levels who don't have the time (or expertise) to solve MySQL problems from scratch.

The new edition covers MySQL 5.0 and its powerful new features, as well as the older but still widespread MySQL 4.1. One major emphasis of this book is how to use SQL to formulate queries for particular kinds of questions, using the mysql client program included in MySQL distributions. The other major emphasis is how to write programs that interact with the MySQL server through an API. You'll find plenty of examples using several language APIs in multiple scenarios and situations, including the use of Ruby to retrieve and format data. There are also many new examples for using Perl, PHP, Python, and Java as well.

Other recipes in the book teach you to: Access data from multiple tables at the same time Use SQL to select, sort, and summarize rows Find matches or mismatches between rows in two tables Determine intervals between dates or times, including age calculations Store images into MySQL and retrieve them for display in web pages Get LOAD DATA to read your data files properly or find which values in the file are invalid Use strict mode to prevent entry of bad data into your database Copy a table or a database to another server Generate sequence numbers to use as unique row identifiers Create database events that execute according to a schedule And a lot more

"MySQLCookbook" doesn't attempt to develop full-fledged, complex applications. Instead, it's intended to assist you in developing applications yourself by helping you get past problems that have you stumped.