SQL Server 2000 Design and TSQL Programming
Published on 1. January 2000
Book
Paperback/Softback
608 pages
978-0-07-212375-3 (ISBN)
Description
This is a guide to designing and programming scalable, SQL server databases. The book develops a start to finish process of designing, building and optimizing SQL server 7 databases. It also looks at codes used and the issues of privacy, threats of lawsuits and many other issues.
More details
Series
Language
English
Place of publication
New York
United States
Publishing group
McGraw-Hill Education - Europe
Target group
College/higher education
Professional and scholarly
Illustrations
10 line illustrations
Dimensions
Height: 235 mm
Width: 188 mm
Weight
1210 gr
ISBN-13
978-0-07-212375-3 (9780072123753)
Copyright in bibliographic data is held by Nielsen Book Services Limited or its licensors: all rights reserved.
Schweitzer Classification
Content
Section 1 Getting started: database design; principles of design; planning the physical design. Section 2 Implementation: implementing the design; building tables. Section 3 Querying the database: data retrieval; joins - combining data from multiple tables; summarizing data and reporting; data modification; subqueries; views. Section 4 Programming for performance: introduction to transactions; locking; data integrity; control of flow languages; indexes; performance and optimization; stored procedures; triggers; distributed data. Section 5 Beyond Transact SQL: T-SQL from other applications; text queries; English query; cursors. Appendices: a recipe for Strawberry Smooches; the Strawberry Smooches entity-relationship diagram.