The Good, the Bad, and the Hungry Sale
 
 

Recently Viewed clear list


Original Essays | July 22, 2014

Nick Harkaway: IMG The Florist-Assassins



The three men lit up in my mind's eye, with footnotes. They were converging on me — and on the object I was carrying — in a way that had... Continue »
  1. $18.87 Sale Hardcover add to wish list

    Tigerman

    Nick Harkaway 9780385352413

spacer
Qualifying orders ship free.
$69.99
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Qty Store Section
2 Local Warehouse Computer Languages- SQL
2 Remote Warehouse Database- Design

Practical SQL Handbook 4TH Edition Using SQL Variati

by

Practical SQL Handbook 4TH Edition Using SQL Variati Cover

 

Synopses & Reviews

Publisher Comments:

This latest edition of the best-selling implementation guide to the Structured Query Language teaches SQL fundamentals while providing practical solutions for critical business applications. The Practical SQL Handbook, Fourth Edition now includes expanded platform SQL coverage and extensive real-world examples based on feedback from actual SQL users.

The Practical SQL Handbook begins with a step-by-step introduction to SQL basics and examines the issues involved in designing SQL-based database applications. It fully explores SQL’s most popular implementations from industry leaders, Oracle, Microsoft, Sybase, and Informix.

Highlights include:

  • Detailed coverage of SQL commands for creating databases, tables, and indexes, and for
  • adding, changing, and deleting data
  • Using the SELECT command to retrieve specific data
  • Handling NULL values (missing information) in a relational database
  • Joining tables, including self joins and outer joins (ANSI and WHERE-clause syntax)
  • Working with nested queries (subqueries) to get data from multiple tables
  • Creating views (virtual tables) to provide customized access to data
  • Using SQL functions

A bonus CD-ROM contains a time-limited, full-feature version of the Sybase® Adaptive Server Anywhere™ software as well as the sample database, scripts, and examples included in the book.

The Practical SQL Handbook is the most complete reference available for day-to-day SQL implementations.

0201703092B05222001

Book News Annotation:

This guide to implementing Structured Query Language introduces basic concepts and offers practical suggestions for its application to business purposes. Instructions are included for the creation of databases, tables, and indexes, with particular attention to the retrieval of specific data, handling null values, and the use of nested queries and multiple tables. An accompanying CD-ROM contains sample databases, scripts, and examples from the book, in addition to a time-limited version of Sybase Adaptive Server Anywhere software.
Annotation c. Book News, Inc., Portland, OR (booknews.com)

Synopsis:

This edition has added coverage of Microsoft SQL Server, Oracle, and Informix. The CD-ROM contains a 60-day full feature version of the Sybase Adaptive Server Anywhere, plus sample database and scripts discussed in the book.

About the Author

Judith S. Bowman has been a database professional since the early 1980s. She is currently an independent consultant specializing in SQL and relational database issues and is the author of Practical SQL: The Sequel (Addison-Wesley, 2001). Sandra L. Emerson is an independent consultant and former Vice President of Publishing Programs for Sybase. Marcy Darnovsky, teaches at colleges throughout the San Francisco Bay area. She was formerly at Sybase.

0201703092AB04062001

Table of Contents

Preface.

Introduction.

 1.SQL and Relational Database Management.

 2. Designing Datases.

 3. Creating and Filling a Database.

 4. Selecting Data from the Database.

 5. Sorting Data and Other Selection Techniques.

 6. Grouping Data and Reporting from it.

 7. Joining Tables for Comprehensive Data Analysis.

 8. Structuring Queries with Subqueries.

 9. Creating and Using Views.

10. Security, Transactions, Performance, and Integrity.

11. Solving Business Problems.

Appendix A: Syntax Summary for the SQL Used in This Book.

Appendix B: Industry SQL Equivalents.

Appendix C: Glossary.

Appendix D: The 'bookbiz' Sample Database.

Product Details

ISBN:
9780201703092
Author:
Bowman, Judith S.
Author:
Emerson, Sandra L.
Author:
Bowman, Judith S.
Author:
Darnovsky, Marcy
Publisher:
Addison-Wesley Professional
Location:
Boston, MA
Subject:
Programming Languages - SQL
Subject:
Database Management - General
Subject:
Relational databases
Subject:
Sql (computer program language)
Subject:
SQL
Subject:
Computer Languages-SQL
Copyright:
Edition Number:
4
Edition Description:
Trade paper
Series Volume:
505
Publication Date:
June 2001
Binding:
TRADE PAPER
Grade Level:
Professional and scholarly
Language:
English
Illustrations:
Yes
Pages:
512
Dimensions:
9.1 x 7.4 x 1.2 in 894 gr

Other books you might like

  1. Application Development Using C# and... New Trade Paper $44.95
  2. Programming C# Used Trade Paper $2.25
  3. Delphi for .Net Developer's Guide Used Trade Paper $9.95
  4. Microsoft Visual Basic 2005 Step by... Used Trade Paper $5.95
  5. Microsoft Word Version 2002 Inside... Used Trade Paper $9.50
  6. Database Management Systems Used Hardcover $50.00

Related Subjects

Computers and Internet » Computer Languages » SQL
Computers and Internet » Database » Design
Computers and Internet » Database » SQL
Computers and Internet » Software Engineering » Software Management

Practical SQL Handbook 4TH Edition Using SQL Variati New Trade Paper
0 stars - 0 reviews
$69.99 In Stock
Product details 512 pages Addison-Wesley Professional - English 9780201703092 Reviews:
"Synopsis" by , This edition has added coverage of Microsoft SQL Server, Oracle, and Informix. The CD-ROM contains a 60-day full feature version of the Sybase Adaptive Server Anywhere, plus sample database and scripts discussed in the book.
spacer
spacer
  • back to top
Follow us on...




Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.