The Practical SQL Handbook: Using SQL Variants / Edition 4
  • Alternative view 1 of The Practical SQL Handbook: Using SQL Variants / Edition 4
  • Alternative view 2 of The Practical SQL Handbook: Using SQL Variants / Edition 4

The Practical SQL Handbook: Using SQL Variants / Edition 4

by Judith S. Bowman, Sandra L. Emerson, Marcy Darnovsky, Sandra Emerson
     
 

ISBN-10: 0201703092

ISBN-13: 9780201703092

Pub. Date: 06/28/2001

Publisher: Addison-Wesley

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

…  See more details below

Overview

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

Read More

Product Details

ISBN-13:
9780201703092
Publisher:
Addison-Wesley
Publication date:
06/28/2001
Edition description:
4th Edition Book & CD-ROM
Pages:
469
Sales rank:
777,850
Product dimensions:
7.30(w) x 9.10(h) x 1.10(d)

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.

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >