SQL clearly explained

Jan L. Harrington

368 pages, parution le 23/09/2003 (2^eme édition)

Ajouter à une liste

Indisponible

Résumé

Second edition of classic SQL handbook
Updated to cover changes in the SQL language standard (SQL:1999)
Includes CD with MySQL software

This is the second edition of the popular practitioner's guide to SQL, the industry-standard database query language. Like most computer languages, SQL can be overwhelming when you first see it, but for years readers have relied on this book to clear the confusion and explain how SQL works and how to use it effectively. Packed with tips, tricks, and good information, SQL Clearly Explained, Second Edition teaches database users and programmers everything they need to know to get their job done including :

formulating SQL queries,
understanding how queries are processed by the DBMS,
maximizing performance,
using SQL to enter, modify, or delete data,
creating and maintaining database structural elements, and
embedding SQL in applications.

Features :

Updated and expanded to include changes in the SQL standard (SQL:1999) as well as recently implemented aspects of SQL-92.
Includes CD with examples from the book as well as MySQL, a popular open-source DBMS, on which the examples are based.
Web enhanced with extra features available online at www.mkp.com.

Getting Started
- Installing and Running MySQL
- Creating and Loading Databases
- Introduction to SQL
Performing Interactive Data Manipulation
- Simple SQL Retrieval
- Retrieving Data from More than One Table : Joins
- Advanced Retrieval Operations
- Calculations and Grouping Queries
- Data Modification
Managing Database Structure
- Schemas and Tables
- Views, Temporary Tables, and Indexes
Program-Based Data Manipulation
- Users, Sessions, and Transaction Control
- Embedded SQL
- Dynamic SQL
Additional Language Features
- Unimplemented Features in the SQL-92 Features
- Object-Oriented Features of the SQL : 1999 Standard
Appendices
Glossary
Index

L'auteur - Jan L. Harrington

Dr. Jan L. Harrington has been working with and writing about the Macintosh since March 1984. In her day job, she is Associate Professor and Chair of the Department of CS/IS/IT at Marist College, where she carries the torch for Macintosh users with great enthusiasm. Her 30+ published books include more than a dozen Macintosh-specific titles, including several on various flavors of the Macintosh OS.

Caractéristiques techniques

	PAPIER
Éditeur(s)	Morgan Kaufmann
Auteur(s)	Jan L. Harrington
Parution	23/09/2003
Édition	2^eme édition
Nb. de pages	368
Format	18,7 x 23,4
Couverture	Broché
Poids	640g
Intérieur	Noir et Blanc
EAN13	9781558608764
ISBN13	978-1-55860-876-4