SQL Unleashed

Sakhr Youness, Pierre Boutquin - Collection Unleashed

808 pages, parution le 10/10/1999 (2^eme édition)

Ajouter à une liste

Indisponible

Résumé

SQL Unleashed, Second Edition, covers ANSII SQL and how to implement them with several major relational database platforms used on a day-to-day basis. SQL Unleashed focuses on more intermediate to advanced topics and the latest trends forthcoming in SQL. Designed to be used as both a reference and implementation tool, this book serves as a practical, pragmatic guide to day-to-day SQL programming and provide the most efficient solutions for getting the job done. Topics include database design and data definition, data manipulation, data selection, more advanced, QL implementations, the future of SQL, and vendor SQL extensions.

Shows how to implement ANSII SQL with several major relational database platforms such as SQL Server, Oracle, DB2, SQL/DS, Sybase, and others
SQL Unleashed discusses the latest trends: SQL 3, Call Level Interface and Persistent Stored Modules
CD-ROM contains all SQL code from the book and third party programs that help create and analyze SQL statements

Table of contents

Structured Query Language (SQL) Standards
Relational Databases
Table Creation and Manipulation
Data Types
Handling Arrays in SQL
Other Schema Objects
Inserts, Updates, and Deletes
Transactions in SQL
Patterns and Ranges in SQL
10Table Joins
Sorting and Grouping
Sets and Subsets Operations
Subqueries
Creating and Using Views
Trees and Hierarchies
Dynamic SQL
Embedded SQL
Implementing Cursors
Optimizing Query Performance
Security Issues
Call Level Interface (CLI)
Persistent Stored Modules (PSM)
The Next Standard: SQL-99
Oracle SQL
Oracle PL/SQL
Microsoft Transact-SQL
An Introduction to SQL
Index

L'auteur - Sakhr Youness

Sakhr Youness

is an MCSD and MCPS with more than seven years experience in data modeling, client/server, and database application development. He is a technical consultant for the Web Architecture Group at the Ford Web Center and previously at Microsoft Consulting Services.

Caractéristiques techniques

	PAPIER
Éditeur(s)	Sams
Auteur(s)	Sakhr Youness, Pierre Boutquin
Collection	Unleashed
Parution	10/10/1999
Édition	2^eme édition
Nb. de pages	808
Format	18,5 x 23,2
Poids	1394g
EAN13	9780672317095
ISBN13	978-0-672-31709-5