The Practical SQL Handbook: Using SQL Variants - Brossura

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

Brossura

ISBN 10: 0201703092 ISBN 13: 9780201703092

Casa editrice: Addison-Wesley Professional, 2001

Riassunto

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

Su questo libro

Informazioni sull?autore

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

Dalla quarta di copertina

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

Dettagli dell'edizione

• Editore: Addison-Wesley Professional
• Data di pubblicazione: 2001
• Lingua: Inglese
• ISBN 10: 0201703092
• ISBN 13: 9780201703092
• Rilegatura: Copertina flessibile
• Numero edizione: 4
• Numero di pagine: 469
• Contatto del produttore: non disponibile
• Persona responsabile: GS1 Slovakia; https://www.gs1sk.org; ; Nantersk� 23; Žilina; 010 08; Repubblica Slovacca