The Practical SQL Handbook

Using SQL Variants

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

650 pages, parution le 01/08/2001

Ajouter à une liste

Indisponible

Résumé

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, Practical SQL Handbookis the most complete reference scripts, and examples included in the book.

The available for day-to-day SQL implementations.

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

L'auteur - Judith S. Bowman

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).

L'auteur - Sandra L. Emerson

Sandra L. Emerson is an independent consultant and former Vice President of Publishing Programs for Sybase.

L'auteur - Marcy Darnovsky

Marcy Darnovsky, teaches at colleges throughout the San Francisco Bay area. She was formerly at Sybase.

Caractéristiques techniques

	PAPIER
Éditeur(s)	Addison Wesley
Auteur(s)	Judith S. Bowman, Sandra L. Emerson, Marcy Darnovsky
Parution	01/08/2001
Nb. de pages	650
Format	18,6 x 23,5
Couverture	Broché
Poids	1021g
Intérieur	Noir et Blanc
EAN13	9780201703092
ISBN13	978-0-201-70309-2