The Practical SQL Handbook: Using Structured Query Language (3rd Edition)

by Judith S. Bowman

On This Page

Description

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 show more database applications. It fully explores SQL#146;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(tm) 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 show less

Tags

Recommendations

Member Reviews

Members

Recently Added By

Author Information

5 Works 263 Members
Judith Bowman is Professor of Music Education and Music Technology at Duquesne University in Pittsburgh, Pennsylvania, where she teaches online courses in music education and music technology.

Common Knowledge

Original publication date
1993

Classifications

Genres
Technology, Nonfiction, General Nonfiction
DDC/MDS
005.756Computer science, information & general worksComputer science, knowledge & systemsArtificial Intelligence/Virtual RealityData in computer systemsSpecific Databases And Data FilesRelational Databases
LCC
QA76.73 .S67 .B69ScienceMathematicsMathematicsInstruments and machinesCalculating machinesElectronic computers. Computer science
BISAC

Statistics

Members
194
Popularity
166,480
Reviews
1
Rating
(4.10)
Languages
English
Media
Paper
ISBNs
4
UPCs
2