A Guide to SYBASE and SQL Server
Addison Wesley (Publisher)
Published on 6. July 1992
Book
Paperback/Softback
576 pages
978-0-201-55710-7 (ISBN)
Article exhausted; check for reprint
Description
SQL Server is one of the leading relational database management systems on the market today. It effectively addresses the demanding requirements of distributed, on-line applications. Written by two leading database authorities, this book provides a convenient, comprehensive overview of the SYBASE relational database product line. Based on Chris Date's widely read Guide to DB2 and Guide to SQL/DS, this current text is the only volume that covers all of the key components of SYBASE and SQL Server. It is completely up to date with information on the current release as well as the forthcoming Release 5.0 of SYBASE. Emphasis throughout is on the user, with treatment of user-oriented material (such as the SQL language) being exceptionally thorough. This in-depth tutorial and reference does not assume any previous knowledge of SYBASE, though readers are assumed to have an appreciation of the overall structure, concepts, and objectives of database management systems in general. Features *Complete coverage of SQL Server, which handles all data management functions, and SQL Toolset, a complete set of tools for developing and using on-line applications.*
Detailed coverage of transaction processing. *Compatible with versions of SYBASE running on any supported platform. *Covers all of the important SYBASE advantages including: scalable high performance, server-enforced integrity and security, high application availability, open distributed DBMS, and window-based tools. 020155710XB04062001
Detailed coverage of transaction processing. *Compatible with versions of SYBASE running on any supported platform. *Covers all of the important SYBASE advantages including: scalable high performance, server-enforced integrity and security, high application availability, open distributed DBMS, and window-based tools. 020155710XB04062001
More details
Language
English
Place of publication
Boston
United States
Publishing group
Pearson Education (US)
Target group
College/higher education
Dimensions
Height: 241 mm
Width: 173 mm
Thickness: 29 mm
Weight
900 gr
ISBN-13
978-0-201-55710-7 (9780201557107)
Copyright in bibliographic data is held by Nielsen Book Services Limited or its licensors: all rights reserved.
Schweitzer Classification
Other editions
New editions

C. J. Date | Hugh Darwen
A Guide to SQL Standard
Book
03/1997
4th Edition
Addison Wesley
€44.56
Article is exhausted; no reprint
Persons
C. J. Date is an independent author, lecturer, researcher, and consultant specializing in relational database systems, a field he helped pioneer. Among other projects, he was involved in technical planning for the IBM products SQL/DS and DB2. He is best known for his books, in particular, An Introduction to Database Systems (7th edition, Addison-Wesley, 2000), the standard text in the field, which has sold well over half a million copies worldwide. Mr. Date is widely acknowledged for his ability to explain complex technical material in a clear and understandable fashion.
David McGoveran is the founding president of Alternative Technologies, a relational database consulting firm based in California. He has consulted for numerous users and virtually every major DBMS vendor, covering needs such as database design, development methodology, performance tuning, and migration and integration. He is co-author of A Guide to SYBASE and SQL Server and is best known for his ability to blend practical solutions with a technical understanding, resulting in robust and flexible systems.
020155710XAB04062001
David McGoveran is the founding president of Alternative Technologies, a relational database consulting firm based in California. He has consulted for numerous users and virtually every major DBMS vendor, covering needs such as database design, development methodology, performance tuning, and migration and integration. He is co-author of A Guide to SYBASE and SQL Server and is best known for his ability to blend practical solutions with a technical understanding, resulting in robust and flexible systems.
020155710XAB04062001
Content
I. AN OVERVIEW OF SYBASE.
SYBASE: A Relational System.
Client/Server Structure.
SQL Server Structure.
II. THE SYBASE DATABASE MANAGEMENT SYSTEM.
Basic Objects and Operators.
Data Definition.
Data Manipulation I: Retrieval Operations.
Data Manipulation II: Retrieval Operations (continued).
Data Manipulation III: Update Operations.
Data Manipulation IV: SQL Extensions.
The Catalog.
Views.
Security and Authorization.
Integrity.
Transaction Processing.
Storage Structure.
System Management.
III. THE SYBASE TOOLSET AND APPLICATIONS DEVELOPMENT.
Data Workbench.
SQL Interfaces.
Application Programming I: DB-Library and Open Client.
Application Programming II: Embedded SQL.
Application Programming III: Dynamic SQL.
APT Workbench Overview.
APT Workbench II: APT-EDIT.
APT-Workbench III: APT-SQL and APT-Library.
IV. RELATED PRODUCTS.
Secure SQL Server.
Microsoft SQL Server.
V. Distributed Processing Support.
Distribution and Fault Tolerant Services.
Open Server and Gateways.
VI. APPENDICES.
SYBASE Catalog Tables and System Procedures
Some Differences Between SYBASE and the SQL Standard
Abbreviations and Acronyms.
Bibliography.
Index. 020155710XT04062001
SYBASE: A Relational System.
Client/Server Structure.
SQL Server Structure.
II. THE SYBASE DATABASE MANAGEMENT SYSTEM.
Basic Objects and Operators.
Data Definition.
Data Manipulation I: Retrieval Operations.
Data Manipulation II: Retrieval Operations (continued).
Data Manipulation III: Update Operations.
Data Manipulation IV: SQL Extensions.
The Catalog.
Views.
Security and Authorization.
Integrity.
Transaction Processing.
Storage Structure.
System Management.
III. THE SYBASE TOOLSET AND APPLICATIONS DEVELOPMENT.
Data Workbench.
SQL Interfaces.
Application Programming I: DB-Library and Open Client.
Application Programming II: Embedded SQL.
Application Programming III: Dynamic SQL.
APT Workbench Overview.
APT Workbench II: APT-EDIT.
APT-Workbench III: APT-SQL and APT-Library.
IV. RELATED PRODUCTS.
Secure SQL Server.
Microsoft SQL Server.
V. Distributed Processing Support.
Distribution and Fault Tolerant Services.
Open Server and Gateways.
VI. APPENDICES.
SYBASE Catalog Tables and System Procedures
Some Differences Between SYBASE and the SQL Standard
Abbreviations and Acronyms.
Bibliography.
Index. 020155710XT04062001