SQL: The Complete Reference, Second Edition - Brossura

Groff, James; Weinberg, Paul

Brossura

ISBN 10: 0072225599 ISBN 13: 9780072225594

Casa editrice: McGraw-Hill Education, 2002

Riassunto

Learn all you need to know about SQL with this one-stop resource. Updated to include information on Web services and XML, this complete guide also comes with a Windows 2000- and XP- compatible CD containing 4 databases (SQL Server 2000, IBM DB2 Version 7.2, Sybase, and mySQL).

Su questo libro

L'autore:

McGraw-Hill authors represent the leading experts in their fields and are dedicated to improving the lives, careers, and interests of readers worldwide

Paul N. Weinberg and James R. Groff are the authors of Using SQL, the book on which this guide is based. They were also the cofounders of Network Innovations Corporation, developers of SQL-based network software. Groff speaks and writes on SQL and UNIX topics. Weinberg is currently a developer at Apple Computer Corporation.

Contenuti:

Part I: An Overview of SQL

1: Introduction

2: A Quick Tour of SQL

3: SQL in Perspective

4: Relational Databases

Part II: Retrieving Data

5: SQL Basics

6: Simple Queries

7: Multitable Queries (Joins)

8: Summary Queries

9: Subqueries and Query Expressions

Part III: Updating Data

10: Database Updates

11: Data Integrity

12: Transaction Processing

Part IV: Database Structure

13: Creating a Database

14: Views

15: SQL Security

16: The System Catalog

Part V: Programming with SQL

17: Embedded SQL

18: Dynamic SQL *

19: SQL APIs

Part VI: SQL Today and Tomorrow

20: Database Processing and Stored Procedures

21: SQL and Data Warehousing

22: SQL and Application Servers

23: SQL Networking and Distributed Databases

24: SQL and Objects

25: SQL and XML

26: The Future of SQL

Part VII: Appendixes

A: The Sample Database

B: Database Vendor Profiles

C: SQL Syntax Reference

D: SQL Call-Level Interface

E: SQL Information Schema Standard

F: CD-ROM Installation Guide

Su questa edizione

• Editore: McGraw-Hill Education
• Data di pubblicazione: 2002
• ISBN 10: 0072225599
• ISBN 13: 9780072225594
• Rilegatura: Copertina flessibile
• Numero edizione: 2
• Numero di pagine: 1000