SQL

Pocket Guide

Jonathan Gennick - Collection Pocket Guide

192 pages, parution le 05/05/2006 (2^eme édition)

Ajouter à une liste

Indisponible

Résumé

SQL is the language of databases. It's used to create and maintain database objects, place data into those objects, query the data, modify the data, and, finally, delete data that is no longer needed. Databases lie at the heart of many, if not most business applications. Chances are very good that if you're involved with software development, you're using SQL to some degree. And if you're using SQL, you should own a good reference or two.

Now available in an updated second edition, our very popular SQL Pocket Guide is a major help to programmers, database administrators, and everyone who uses SQL in their day-to-day work. The SQL Pocket Guide is a concise reference to frequently used SQL statements and commonly used SQL functions. Not just an endless collection of syntax diagrams, this portable guide addresses the language's complexity head on and leads by example. The information in this edition has been updated to reflect the latest versions of the most commonly used SQL variants including:

Oracle Database 10g, Release 2 (including the free Oracle Database 10g Express Edition (XE))
Microsoft SQL Server 2005
MySQL 5
IBM DB2 8.2
PostreSQL 8.1 database

L'auteur - Jonathan Gennick

Jonathan Gennick est administrateur de base de données Oracle. Il est aussi écrivain et éditeur. Il est l'auteur de Oracle SQL*Plus : The Definitive Guide, dont proviennent les informations de ce guide, et de plusieurs autres ouvrages sur Oracle.

Sommaire

Introduction
CASE Expressions
Datatype Conversion
Deleting Data
Flashback Queries (Oracle)
Functions
Grouping and Summarizing
Hierarchical Queries
Inserting Data
Joining Tables
Literals
Merging Data
OLAP Functions
Tables Manipulations
NULLs
Predicates
Recursive Queries
Regular Expressions
Selecting Data
Subqueries
Transaction Management
Union Queries
Updating Data
Window Functions

Voir tout

Replier

Caractéristiques techniques

	PAPIER
Éditeur(s)	O'Reilly
Auteur(s)	Jonathan Gennick
Collection	Pocket Guide
Parution	05/05/2006
Édition	2^eme édition
Nb. de pages	192
Format	10,5 x 17,5
Couverture	Broché
Poids	170g
Intérieur	Noir et Blanc
EAN13	9780596526887
ISBN13	978-0-596-52688-7